REPLACE INTO `pre_common_setting` (skey, svalue) VALUES ('paistatus', '1');
REPLACE INTO `pre_common_setting` (skey, svalue) VALUES ('paiseo', 'a:3:{s:5:\"title\";a:4:{s:5:\"index\";s:8:\"金币竞拍\";s:4:\"list\";s:8:\"今日竞拍\";s:10:\"investment\";s:8:\"竞拍招商\";s:2:\"my\";s:8:\"我的竞拍\";}s:11:\"description\";a:4:{s:5:\"index\";s:0:\"\";s:4:\"list\";s:0:\"\";s:10:\"investment\";s:0:\"\";s:2:\"my\";s:0:\"\";}s:8:\"keywords\";a:4:{s:5:\"index\";s:0:\"\";s:4:\"list\";s:0:\"\";s:10:\"investment\";s:0:\"\";s:2:\"my\";s:0:\"\";}}');
REPLACE INTO `pre_common_setting` (skey, svalue) VALUES ('paicredit', '2');
REPLACE INTO `pre_common_setting` (skey, svalue) VALUES ('paipmsubject', '恭喜您参加金币竞拍获奖');
REPLACE INTO `pre_common_setting` (skey, svalue) VALUES ('paipmmessage', '您竞拍{pai}获奖, 请前来领取');
DROP TABLE IF EXISTS `pre_pai_investment`;
CREATE TABLE `pre_pai_investment` (
`investmentid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`uid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`username` char(15) NOT NULL DEFAULT '',
`shop` varchar(100) NOT NULL DEFAULT '',
`manager` varchar(5) NOT NULL,
`phone` varchar(30) NOT NULL,
`address` varchar(200) NOT NULL,
`prize` varchar(100) NOT NULL,
`number` smallint(6) unsigned NOT NULL DEFAULT '0',
`rule` tinyint(1) unsigned NOT NULL DEFAULT '0',
`description` text NOT NULL,
`remark` text NOT NULL,
`useip` varchar(15) NOT NULL DEFAULT '',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`investmentid`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `pre_pai_pai`;
CREATE TABLE `pre_pai_pai` (
`paiid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`subject` varchar(100) NOT NULL DEFAULT '',
`price` decimal(8,2) NOT NULL DEFAULT '0.00',
`pic` varchar(255) NOT NULL DEFAULT '',
`rule` tinyint(1) unsigned NOT NULL DEFAULT '0',
`number` tinyint(3) unsigned NOT NULL DEFAULT '0',
`starttime` int(10) unsigned NOT NULL DEFAULT '0',
`endtime` int(10) unsigned NOT NULL DEFAULT '0',
`cost` smallint(6) unsigned NOT NULL DEFAULT '0',
`raise` tinyint(3) unsigned NOT NULL DEFAULT '0',
`description` text NOT NULL,
`views` mediumint(8) unsigned NOT NULL DEFAULT '0',
`applies` mediumint(8) unsigned NOT NULL DEFAULT '0',
`award` tinyint(1) unsigned NOT NULL DEFAULT '0',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`paiid`)
) TYPE=MyISAM;
DROP TABLE IF EXISTS `pre_pai_record`;
CREATE TABLE `pre_pai_record` (
`recordid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`paiid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`uid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`username` char(15) NOT NULL DEFAULT '',
`pay` smallint(6) unsigned NOT NULL DEFAULT '0',
`status` tinyint(1) NOT NULL DEFAULT '0',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`recordid`)
) TYPE=MyISAM; |