DROP TABLE IF EXISTS `cdb_ai`;
CREATE TABLE `cdb_ai` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`ainame` varchar(50) NOT NULL default '',
`cash` double NOT NULL default '0',
`fund` double NOT NULL default '0',
`stocktypenum` int(10) NOT NULL default '0',
`todaybuy` int(10) NOT NULL default '0',
`todaysale` int(10) NOT NULL default '0',
`totalbuy` double NOT NULL default '0',
`totalsale` double NOT NULL default '0',
`aid` int(10) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=GBK AUTO_INCREMENT=3 ;
DROP TABLE IF EXISTS `cdb_bighome`;
CREATE TABLE `cdb_bighome` (
`acc` varchar(50) NOT NULL default '',
`stockid` int(10) NOT NULL default '0',
`stockcode` varchar(10) NOT NULL default '',
`buymoney` float NOT NULL default '0',
`num` double NOT NULL default '0',
`averagemoney` float NOT NULL default '0',
`work` varchar(50) NOT NULL default '',
`buytime` int(10) NOT NULL default '0',
`saletime` int(10) NOT NULL default '0',
`uid` int(10) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=GBK;
DROP TABLE IF EXISTS `cdb_client`;
CREATE TABLE `cdb_client` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`acc` varchar(50) NOT NULL default '',
`zxtime` int(10) NOT NULL default '0',
`zxbj` int(1) NOT NULL default '0',
`lfbj` int(1) NOT NULL default '0',
`cxbj` int(1) NOT NULL default '0',
`cxkey` varchar(50) NOT NULL default '',
`gmdj` varchar(255) NOT NULL default '',
`bmtime` int(10) NOT NULL default '0',
`bmbj` int(1) NOT NULL default '0',
`csbj` int(1) NOT NULL default '0',
`buytime` int(10) NOT NULL default '0',
`saletime` int(10) NOT NULL default '0',
`bmallmoney` double NOT NULL default '0',
`money` double NOT NULL default '0',
`allmoney` double NOT NULL default '0',
`lastallmoney` double NOT NULL default '0',
`income` float NOT NULL default '0',
`sellcost` float NOT NULL default '0',
`sellsy` float NOT NULL default '0',
`bankmoney` double NOT NULL default '0',
`cunqutime` int(10) NOT NULL default '0',
`ynlock` int(6) NOT NULL default '0',
`numtype` int(10) NOT NULL default '0',
`nowbuy` int(100) NOT NULL default '0',
`nowsell` int(100) NOT NULL default '0',
`nowall` int(100) NOT NULL default '0',
`nowbuygf` bigint(100) NOT NULL default '0',
`nowsellgf` bigint(100) NOT NULL default '0',
`sellearn` float NOT NULL default '0',
`sellbad` float NOT NULL default '0',
`opendate` int(10) NOT NULL default '0',
`lastdate` int(10) NOT NULL default '0',
`allbuy` int(100) NOT NULL default '0',
`allsell` int(100) NOT NULL default '0',
`gsnum` int(100) NOT NULL default '0',
`cpsnum` int(100) NOT NULL default '0',
`dxgjnum` int(10) NOT NULL default '0',
`style` int(10) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=GBK AUTO_INCREMENT=13 ;
DROP TABLE IF EXISTS `cdb_gupiaoconfig`;
CREATE TABLE `cdb_gupiaoconfig` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`todaybuy` bigint(100) NOT NULL default '0',
`todaysale` bigint(100) NOT NULL default '0',
`todaytotal` bigint(100) NOT NULL default '0',
`todaydate` int(10) NOT NULL default '0',
`settime` int(10) NOT NULL default '0',
`dpycbj` int(1) NOT NULL default '0',
`jhjjbj` int(1) NOT NULL default '0',
`gupiao_setting` varchar(255) NOT NULL default '',
`pstock_setting` varchar(255) NOT NULL default '',
`kaihu_setting` varchar(255) NOT NULL default '',
`trade_setting` varchar(255) NOT NULL default '',
`stopreadme` varchar(255) NOT NULL default '',
`user_setting` varchar(255) NOT NULL default '',
`ai_setting` varchar(255) NOT NULL default '',
`custom_setting` text NOT NULL,
`stockmanager` varchar(255) NOT NULL default '',
`gupiaoadmin` varchar(255) NOT NULL default '',
`stockmright` varchar(255) NOT NULL default '',
`gpmax` float NOT NULL default '0',
`gpmin` float NOT NULL default '0',
`noticeshow` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=GBK AUTO_INCREMENT=2 ;
INSERT INTO `cdb_gupiaoconfig` VALUES (1, 0, 0, 0, 1201270966, 0, 1, 0, '1,,30,0,8||23,??????,,,,,0.4,0.53,20,1,1,1,1,1,,1,0.1,0,1,0.52,-1', '1|1000000000|1|50|255|50000000|||2', '1|2|||0|500000|0|0|0', '1||100|100000000|0|0.3|2|2|2|0.2|0.2|1|0.4|0.4|0.7|0.2|0|1|1.05|0.95|1|100000000', '????????????????', '1|0|0|0|10|10000|1||0.0001|0|0|0|0|0|0|0|0|0', '0|0.3|???@???||', '??????||??|<font color=red>????????!</font>', '', '', '0|0|0|1|1|1|0', 10, 10, 0);
DROP TABLE IF EXISTS `cdb_personalstock`;
CREATE TABLE `cdb_personalstock` (
`stockid` mediumint(8) unsigned NOT NULL auto_increment,
`stockcode` varchar(10) NOT NULL default '',
`username` varchar(50) NOT NULL default '',
`uid` int(10) NOT NULL default '0',
`stockname` varchar(50) NOT NULL default '',
`price` float NOT NULL default '0',
`stocknum` double NOT NULL default '0',
`applydate` int(10) NOT NULL default '0',
`states` int(10) NOT NULL default '0',
`sexplain` varchar(255) NOT NULL default '',
`ltdimg` varchar(200) NOT NULL default '',
`on_cash` double NOT NULL default '0',
PRIMARY KEY (`stockid`)
) ENGINE=MyISAM AUTO_INCREMENT=1242 DEFAULT CHARSET=GBK AUTO_INCREMENT=1242 ;
DROP TABLE IF EXISTS `cdb_rndevent`;
CREATE TABLE `cdb_rndevent` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`content` text NOT NULL,
`addtime` int(10) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=GBK AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `cdb_stock`;
CREATE TABLE `cdb_stock` (
`stockid` mediumint(8) unsigned NOT NULL auto_increment,
`stockcode` varchar(10) NOT NULL default '',
`work` varchar(50) NOT NULL default '',
`openmoney` float NOT NULL default '0',
`nowmoney` float NOT NULL default '0',
`datet` int(10) NOT NULL default '0',
`zzbj` int(1) NOT NULL default '0',
`tkbj` int(1) NOT NULL default '0',
`fgbj` int(1) NOT NULL default '0',
`state` varchar(50) NOT NULL default '',
`buynum` bigint(100) NOT NULL default '0',
`sellnum` bigint(100) NOT NULL default '0',
`buygfsum` bigint(100) NOT NULL default '0',
`sellgfsum` bigint(100) NOT NULL default '0',
`buymoney` float NOT NULL default '0',
`sellmoney` float NOT NULL default '0',
`pansaletime` int(10) NOT NULL default '0',
`cid` int(10) NOT NULL default '0',
`usename` varchar(50) NOT NULL default '',
`uid` bigint(10) NOT NULL default '0',
`todaywave` float NOT NULL default '0',
`totalwave` double NOT NULL default '0',
`allnum` bigint(100) NOT NULL default '0',
`leavenum` bigint(100) NOT NULL default '0',
`buy` bigint(100) NOT NULL default '0',
`bargain` bigint(100) NOT NULL default '0',
`sexplain` varchar(255) NOT NULL default '',
`tongji` text NOT NULL,
`ltdimg` varchar(200) NOT NULL default '',
`unum` float NOT NULL default '0',
`lnum` float NOT NULL default '0',
`zdf` float NOT NULL default '0',
`on_cash` double NOT NULL default '0',
`total_cash` double NOT NULL default '0',
`earn_cash` double NOT NULL default '0',
`totalnum` bigint(100) NOT NULL default '0',
`vend` int(10) NOT NULL default '0',
PRIMARY KEY (`stockid`)
) ENGINE=MyISAM AUTO_INCREMENT=55 DEFAULT CHARSET=GBK AUTO_INCREMENT=55 ;
DROP TABLE IF EXISTS `cdb_stocknews`;
CREATE TABLE `cdb_stocknews` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`title` varchar(100) NOT NULL default '',
`content` varchar(255) NOT NULL default '',
`color` varchar(20) NOT NULL default '',
`addtime` int(10) NOT NULL default '0',
`username` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=GBK AUTO_INCREMENT=5 ;
DROP TABLE IF EXISTS `cdb_tjstock`;
CREATE TABLE `cdb_tjstock` (
`acc` varchar(50) NOT NULL default '',
`stockid` int(10) NOT NULL default '0',
`stockcode` varchar(10) NOT NULL default '',
`tjprice` float NOT NULL default '0',
`gmdj` varchar(255) NOT NULL default '',
`work` varchar(50) NOT NULL default '',
`tjtime` int(10) NOT NULL default '0',
`stocksy` float NOT NULL default '0',
`uid` int(10) NOT NULL default '0',
`tjreason` varchar(255) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=GBK;
亲爱的LZ..你的这个 数据库升级文件用不了呀~~~
提示：升级错误，MySQL 提示: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=GBK AUTO_INCREMENT=3' at line 1 ，请返回。
