/* Navicat MySQL Data Transfer Source Server : localhost Source Server Version : 50528 Source Host : localhost:3306 Source Database : test Target Server Type : MYSQL Target Server Version : 50528 File Encoding : 65001 Date: 2013-06-02 17:56:12 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `misc` -- ---------------------------- DROP TABLE IF EXISTS `misc`; CREATE TABLE `misc` ( `gMOTD` varchar(256) NOT NULL, `aMOTD` varchar(256) NOT NULL, `vMOTD` varchar(256) NOT NULL, `cMOTD` varchar(256) NOT NULL, `pMOTD` varchar(256) NOT NULL, `ShopTechPay` float(11,1) NOT NULL DEFAULT '0.5', `Safe` int(11) NOT NULL DEFAULT '0', `TicketsSold` int(11) NOT NULL DEFAULT '0', `GiftCode` varchar(32) NOT NULL DEFAULT 'off', `GiftCodeBypass` int(11) NOT NULL DEFAULT '0', `TotalCitizens` int(11) NOT NULL DEFAULT '0', `TRCitizens` int(11) NOT NULL DEFAULT '0', `SecurityCode` varchar(32) NOT NULL DEFAULT 'none', `ShopClosed` int(11) NOT NULL DEFAULT '0', `RimMod` int(11) NOT NULL DEFAULT '0', `CarVoucher` int(11) NOT NULL DEFAULT '0', `GunPrice0` int(11) NOT NULL DEFAULT '0', `GunPrice1` int(11) NOT NULL DEFAULT '0', `GunPrice2` int(11) NOT NULL DEFAULT '0', `GunPrice3` int(11) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of misc -- ----------------------------