Discuz! info: MySQL Query Error
User: 风影V雷霸天
Time: 2006-9-12 2:45pm
Script: /bbs/installpf.php
SQL: CREATE TABLE `cdb_petconfig` (
`version` varchar(30) NOT NULL default '快乐天使PetPlusV2.10',
`play` smallint(5) unsigned NOT NULL default '0',
`peopen` smallint(5) unsigned NOT NULL default '0',
`people1` smallint(5) unsigned NOT NULL default '0',
`people2` smallint(5) unsigned NOT NULL default '0',
`people3` smallint(5) unsigned NOT NULL default '0',
`people4` smallint(5) unsigned NOT NULL default '0',
`people5` smallint(5) unsigned NOT NULL default '0',
`people6` smallint(5) unsigned NOT NULL default '0',
`people7` smallint(5) unsigned NOT NULL default '0',
`people8` smallint(5) unsigned NOT NULL default '0',
`basichp` smallint(5) unsigned NOT NULL default '100',
`basicsp` smallint(5) unsigned NOT NULL default '5000',
`basicsp2` smallint(5) unsigned NOT NULL default '500',
`eggmoney` smallint(5) unsigned NOT NULL default '200',
`basichpmoney` smallint(5) unsigned NOT NULL default '100',
`basicbhpmoney` smallint(5) unsigned NOT NULL default '500',
`basicmpmoney` smallint(5) unsigned NOT NULL default '200',
`basicspmoney` smallint(5) unsigned NOT NULL default '100',
`basicexpmoney` smallint(5) unsigned NOT NULL default '50000',
`nomoney` int(11) unsigned NOT NULL default '100000',
`livemoney` smallint(5) unsigned NOT NULL default '3000',
`basicusehp` smallint(5) unsigned NOT NULL default '100',
`basicusemp` smallint(5) unsigned NOT NULL default '25',
`basicusebhp` smallint(5) unsigned NOT NULL default '2500',
`basicusebmp` smallint(5) unsigned NOT NULL default '100',
`basicuseexp` smallint(5) unsigned NOT NULL default '50',
`petpkhp` smallint(5) unsigned NOT NULL default '0',
`petpklv` smallint(5) unsigned NOT NULL default '10',
`petpktime` int(10) unsigned NOT NULL default '1',
`losegd` smallint(5) unsigned NOT NULL default '0',
`changesexmoney` smallint(5) unsigned NOT NULL default '500',
`swordmoneya` smallint(5) unsigned NOT NULL default '30',
`swordmoneyb` smallint(5) unsigned NOT NULL default '60',
`swordmoneyc` smallint(5) unsigned NOT NULL default '120',
`swordmoneyd` smallint(5) unsigned NOT NULL default '240',
`swordmoneye` smallint(5) unsigned NOT NULL default '480',
`swordmoneyf` smallint(5) unsigned NOT NULL default '960',
`swordmoneyg` smallint(5) unsigned NOT NULL default '1920',
`swordmoneyh` smallint(5) unsigned NOT NULL default '3840',
`swordmoneyi` smallint(5) unsigned NOT NULL default '7680',
`necklacemoneya` smallint(5) unsigned NOT NULL default '1500',
`necklacemoneyb` smallint(5) unsigned NOT NULL default '3000',
`necklacemoneyc` smallint(5) unsigned NOT NULL default '4500',
`necklacemoneyd` smallint(5) unsigned NOT NULL default '6000',
`necklacemoneye` smallint(5) unsigned NOT NULL default '7500',
`necklacemoneyf` smallint(5) unsigned NOT NULL default '9000',
`necklacemoneyg` smallint(5) unsigned NOT NULL default '10500',
`necklacemoneyh` smallint(5) unsigned NOT NULL default '12000',
`necklacemoneyi` smallint(5) unsigned NOT NULL default '13500',
`headmoneya` smallint(5) unsigned NOT NULL default '25',
`headmoneyb` smallint(5) unsigned NOT NULL default '50',
`headmoneyc` smallint(5) unsigned NOT NULL default '100',
`headmoneyd` smallint(5) unsigned NOT NULL default '200',
`headmoneye` smallint(5) unsigned NOT NULL default '400',
`headmoneyf` smallint(5) unsigned NOT NULL default '800',
`headmoneyg` smallint(5) unsigned NOT NULL default '1600',
`headmoneyh` smallint(5) unsigned NOT NULL default '3200',
`headmoneyi` smallint(5) unsigned NOT NULL default '6400',
`bodymoneya` smallint(5) unsigned NOT NULL default '20',
`bodymoneyb` smallint(5) unsigned NOT NULL default '40',
`bodymoneyc` smallint(5) unsigned NOT NULL default '80',
`bodymoneyd` smallint(5) unsigned NOT NULL default '160',
`bodymoneye` smallint(5) unsigned NOT NULL default '320',
`bodymoneyf` smallint(5) unsigned NOT NULL default '640',
`bodymoneyg` smallint(5) unsigned NOT NULL default '1280',
`bodymoneyh` smallint(5) unsigned NOT NULL default '2560',
`bodymoneyi` smallint(5) unsigned NOT NULL default '5120',
`footmoneya` smallint(5) unsigned NOT NULL default '10',
`footmoneyb` smallint(5) unsigned NOT NULL default '20',
`footmoneyc` smallint(5) unsigned NOT NULL default '40',
`footmoneyd` smallint(5) unsigned NOT NULL default '80',
`footmoneye` smallint(5) unsigned NOT NULL default '160',
`footmoneyf` smallint(5) unsigned NOT NULL default '320',
`footmoneyg` smallint(5) unsigned NOT NULL default '640',
`footmoneyh` smallint(5) unsigned NOT NULL default '1280',
`footmoneyi` smallint(5) unsigned NOT NULL default '2560',
`area` smallint(5) unsigned NOT NULL default '0',
`arealv` smallint(5) unsigned NOT NULL default '50',
`arealv2` smallint(5) unsigned NOT NULL default '100',
`arealv3` smallint(5) unsigned NOT NULL default '150',
`arealv4` smallint(5) unsigned NOT NULL default '200',
`arealv5` smallint(5) unsigned NOT NULL default '250',
`arealv6` smallint(5) unsigned NOT NULL default '300',
`arealv7` smallint(5) unsigned NOT NULL default '350',
`arealv8` smallint(5) unsigned NOT NULL default '400',
`arealv9` smallint(5) unsigned NOT NULL default '450',
`arealv10` smallint(5) unsigned NOT NULL default '1500',
`arealv11` smallint(5) unsigned NOT NULL default '1600',
`repoints` int(10) unsigned NOT NULL default '1000000',
`setactime` int(10) unsigned NOT NULL default '0',
`pofa` smallint(5) unsigned NOT NULL default '0',
`dirange` smallint(5) unsigned NOT NULL default '900',
`dirange2` smallint(5) unsigned NOT NULL default '900',
`dirange3` smallint(5) unsigned NOT NULL default '900',
`dirange4` smallint(5) unsigned NOT NULL default '900',
`dirange5` smallint(5) unsigned NOT NULL default '600',
`dirange6` smallint(5) unsigned NOT NULL default '600',
`closetime` varchar(6) NOT NULL default '0||24',
`dayocset` varchar(100) NOT NULL default '',
`chaton` smallint(5) unsigned NOT NULL default '0',
`dropmm1` smallint(5) unsigned NOT NULL default '2',
`dropmm2` smallint(5) unsigned NOT NULL default '3',
`dropmm3` smallint(5) unsigned NOT NULL default '4',
`dropmm4` smallint(5) unsigned NOT NULL default '5',
`dropmm5` smallint(5) unsigned NOT NULL default '6',
`dropmm6` smallint(5) unsigned NOT NULL default '8',
`dropmm7` smallint(5) unsigned NOT NULL default '10',
`put` smallint(5) unsigned NOT NULL default '5',
`put1` smallint(5) unsigned NOT NULL default '10',
`postline` smallint(5) unsigned NOT NULL default '0',
`setpost` smallint(5) unsigned NOT NULL default '5',
`settime` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`version`)
) TYPE=MyISAM;
Error: Invalid default value for 'version'
Errno.: 1067
求助,安装出现这样
[ 本帖最后由 wujian8150 于 2006-9-12 14:50 编辑 ] |