原帖由
PSV燕豪芬 於 2008-7-4 21:57 發表
升級錯誤，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 '---- 資料庫: `inv668co_discuz`---- --- ...
CREATE TABLE IF NOT EXISTS `cdb_qcbighome` (
`acc` varchar(50) NOT NULL,
`stockcode` varchar(10) NOT NULL,
`num` double NOT NULL default '0',
`area` varchar(10) NOT NULL,
`averagemoney` float NOT NULL default '0',
`nowprice` float NOT NULL default '0',
`work` varchar(50) NOT NULL,
`buytime` int(10) NOT NULL default '0',
`saletime` int(10) NOT NULL default '0',
`uid` int(10) NOT NULL default '0'
) ENGINE=MyISAM;
CREATE TABLE IF NOT EXISTS `cdb_qcclient` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`gmdj` varchar(255) NOT NULL,
`allmoney` double NOT NULL default '0',
`style` int(10) NOT NULL default '0',
`income` float NOT NULL default '0',
`sellbad` float NOT NULL default '0',
`cpsnum` int(100) NOT NULL default '0',
`nowsell` int(100) NOT NULL default '0',
`totalnums` int(100) NOT NULL default '0',
`sellearn` float NOT NULL default '0',
`numtype` int(10) NOT NULL default '0',
`sellcost` float NOT NULL default '0',
`money` double NOT NULL default '0',
`totalmoney` double NOT NULL default '0',
`opendate` int(10) NOT NULL default '0',
`nowbuy` int(100) NOT NULL default '0',
`lfbj` int(1) NOT NULL default '0',
`nowall` int(100) NOT NULL default '0',
`ynlock` int(6) NOT NULL default '0',
`lastallmoney` double NOT NULL default '0',
`gsnum` int(100) NOT NULL default '0',
`sellsy` float NOT NULL default '0',
`acc` varchar(50) NOT NULL,
`gwnum` int(10) NOT NULL default '0',
`stockqs` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=74 ;
CREATE TABLE IF NOT EXISTS `cdb_qcgupiaoconfig` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`todaydate` int(10) NOT NULL default '0',
`kaihu_setting` varchar(255) NOT NULL,
`trade_setting` varchar(255) NOT NULL,
`stopreadme` varchar(255) NOT NULL,
`gupiao_setting` varchar(255) NOT NULL,
`custom_setting` mediumtext NOT NULL,
`stockmanager` varchar(255) NOT NULL,
`gupiaoadmin` varchar(255) NOT NULL,
`stockmright` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 ;
INSERT INTO `cdb_qcgupiaoconfig` (`id`, `todaydate`, `kaihu_setting`, `trade_setting`, `stopreadme`, `gupiao_setting`, `custom_setting`, `stockmanager`, `gupiaoadmin`, `stockmright`) VALUES
(1, 1214756129, '1|0|0|0|0|10000|0', '1|100|0|1|1|0|0|1|1|1', '股市正在休市', '1,30,1,10:00||12:30||14:30||16:00,港股股王爭霸戰 2008,0,1,1,1,10,1,1', 'INV668 交易所最新公佈||<marquee scrollamount="2" scrolldelay="60"><font size="2" color="#0000ff">INV交易所推介：5窮 6絕 7番生？2823A50會否成為股王誕生的實力股？ ----------> 7月2日起，本交易所舉辦之《港股股王爭霸戰 2008》正式開始。 --------> 每日最新戰況，留意資產排行榜。 --------> 買賣佣金連手續費為成交金額之 1%，敬請留意，看誰由1萬元起賺取第一筒金？</font></marquee>', '', '', '0|1|1|1|1|1|0');