P.s база данных автоматическая
до редактирования
CREATE TABLE IF NOT EXISTS `users` ( `id` int(11) NOT NULL, `sn` varchar(20) default NULL, `nick` varchar(255) default NULL, `localnick` varchar(255) default NULL, `fname` varchar(255) default NULL, `lname` varchar(255) default NULL, `email` varchar(255) default NULL, `city` varchar(255) default NULL, `homepage` varchar(255) default NULL, `gender` int(11) default NULL, `birthyear` int(11) default NULL, `birthmonth` int(11) default NULL, `birthday` int(11) default NULL, `age` int(11) default NULL, `country` int(11) default NULL, `language` int(11) default NULL, `state` int(11) default NULL, `basesn` varchar(20) default NULL, `createtime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `room` int(11) default NULL, `lastkick` timestamp NOT NULL default '0000-00-00 00:00:00', `lastclosed` timestamp NOT NULL default '0000-00-00 00:00:00', `SP` timestamp NOT NULL default '0000-00-00 00:00:00', `ball` int(11) default NULL, `viev` int(11) default NULL, `odegd` varchar(255) NOT NULL, `giv` varchar(255) NOT NULL, `auto` varchar(255) NOT NULL, `dom` varchar(255) NOT NULL, `clansman` int(11) default NULL, `clangroup` varchar(255) default '', `ohran` int(11) default NULL, `banks` int(11) default NULL, `orujie` int(7) NOT NULL default '0', `lastMod` timestamp NOT NULL default '0000-00-00 00:00:00', `data` timestamp NOT NULL default '0000-00-00 00:00:00', `bar` varchar(255) NOT NULL, `alcohol` int(11) default NULL, `hp` int(11) default NULL, `hp_` varchar(255) NOT NULL, `bronya` int(11) default NULL, `bronya_` varchar(255) NOT NULL, `game` int(11) default NULL, `score` int(11) default NULL, `bomba` int(11) default NULL, `holodnoe` int(11) default NULL, `pushka` varchar(255) NOT NULL, `hold_org` varchar(255) NOT NULL, `sms` int(255) NOT NULL, `sms_t` timestamp NOT NULL default '0000-00-00 00:00:00', `pol` int(11) default NULL, `smskiplat` int(11) default NULL, `number` int(11) default NULL, `answer` int(11) default NULL, `smsstat` int(11) default NULL, `billing` timestamp NOT NULL default '0000-00-00 00:00:00', `carMax` int(11) default NULL, `car` varchar(255) NOT NULL, `fuel` int(11) default NULL, `win` int(11) default NULL, `lost` int(11) default NULL, `leavel` int(11) NOT NULL default '1', `id_auto` int(11) default NULL, `cena` int(11) default NULL, `wedding` int(11) default NULL, `sv_status` varchar(255) NOT NULL, `ugroza` int(11) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; INSERT INTO `users` (`id`, `sn`, `nick`, `localnick`, `fname`, `lname`, `email`, `city`, `homepage`, `gender`, `birthyear`, `birthmonth`, `birthday`, `age`, `country`, `language`, `state`, `basesn`, `createtime`, `room`, `lastkick`, `lastclosed`, `SP`, `ball`, `viev`, `odegd`, `giv`, `auto`, `dom`, `clansman`, `clangroup`, `ohran`, `banks`, `orujie`, `lastMod`, `data`, `bar`, `alcohol`, `hp`, `hp_`, `bronya`, `bronya_`, `game`, `score`, `bomba`, `holodnoe`, `pushka`, `hold_org`, `sms`, `sms_t`, `pol`, `smskiplat`, `number`, `answer`, `smsstat`, `billing`, `carMax`, `car`, `fuel`, `win`, `lost`, `leavel`, `id_auto`, `cena`, `wedding`, `sv_status`,`ugroza`) VALUES (-12321, 'none', '', 'SYSTEM', '', '', '', '', '', -1, -1, -1, -1, -1, -1, -1, 1, '0', '2001-01-01 00:00:00', 0, '2000-01-01 00:00:00', '2000-01-01 00:00:00', '2000-01-01 00:00:00', 0, 0, '', '', '', '', 0, '', 0, 0, 0, '2000-01-01 00:00:00', '2000-01-01 00:00:00', '', 0, 0, '', 0, '', 0, 0, 0, 0, '', '', 0, '2000-01-01 00:00:00', 0, 0, 0, 0, NULL, NOW(), NULL, '', NULL, NULL, NULL, 1, NULL, NULL, NULL, '', NULL);
вот отредактировал
CREATE TABLE IF NOT EXISTS `users` ( `id` int(11) NOT NULL, `sn` varchar(20) default NULL, `nick` varchar(255) default NULL, `localnick` varchar(255) default NULL, `fname` varchar(255) default NULL, `lname` varchar(255) default NULL, `email` varchar(255) default NULL, `city` varchar(255) default NULL, `homepage` varchar(255) default NULL, `gender` int(11) default NULL, `birthyear` int(11) default NULL, `birthmonth` int(11) default NULL, `birthday` int(11) default NULL, `age` int(11) default NULL, `country` int(11) default NULL, `language` int(11) default NULL, `state` int(11) default NULL, `basesn` varchar(20) default NULL, `createtime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `room` int(11) default NULL, `lastkick` timestamp NOT NULL default '0000-00-00 00:00:00', `lastclosed` timestamp NOT NULL default '0000-00-00 00:00:00', `SP` timestamp NOT NULL default '0000-00-00 00:00:00', `ball` int(11) default NULL, `viev` int(11) default NULL, `odegd` varchar(255) NOT NULL, `giv` varchar(255) NOT NULL, `auto` varchar(255) NOT NULL, `dom` varchar(255) NOT NULL, `clansman` int(11) default NULL, `clangroup` varchar(255) default '', `ohran` int(11) default NULL, `banks` int(11) default NULL, `orujie` int(7) NOT NULL default '0', `lastMod` timestamp NOT NULL default '0000-00-00 00:00:00', `data` timestamp NOT NULL default '0000-00-00 00:00:00', `bar` varchar(255) NOT NULL, `alcohol` int(11) default NULL, `hp` int(11) default NULL, `hp_` varchar(255) NOT NULL, `bronya` int(11) default NULL, `bronya_` varchar(255) NOT NULL, `game` int(11) default NULL, `score` int(11) default NULL, `bomba` int(11) default NULL, `holodnoe` int(11) default NULL, `pushka` varchar(255) NOT NULL, `hold_org` varchar(255) NOT NULL, `sms` int(255) NOT NULL, `sms_t` timestamp NOT NULL default '0000-00-00 00:00:00', `pol` int(11) default NULL, `smskiplat` int(11) default NULL, `number` int(11) default NULL, `answer` int(11) default NULL, `smsstat` int(11) default NULL, `billing` timestamp NOT NULL default '0000-00-00 00:00:00', `wedding` int(11) default NULL, `sv_status` varchar(255) NOT NULL, `ugroza` int(11) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; INSERT INTO `users` (`id`, `sn`, `nick`, `localnick`, `fname`, `lname`, `email`, `city`, `homepage`, `gender`, `birthyear`, `birthmonth`, `birthday`, `age`, `country`, `language`, `state`, `basesn`, `createtime`, `room`, `lastkick`, `lastclosed`, `SP`, `ball`, `viev`, `odegd`, `giv`, `auto`, `dom`, `clansman`, `clangroup`, `ohran`, `banks`, `orujie`, `lastMod`, `data`, `bar`, `alcohol`, `hp`, `hp_`, `bronya`, `bronya_`, `game`, `score`, `bomba`, `holodnoe`, `pushka`, `hold_org`, `sms`, `sms_t`, `pol`, `smskiplat`, `number`, `answer`, `smsstat`, `billing`, `wedding`, `sv_status`, `ugroza`) VALUES (-12321, 'none', '', 'SYSTEM', '', '', '', '', '', -1, -1, -1, -1, -1, -1, -1, 1, '0', '2001-01-01 00:00:00', 0, '2000-01-01 00:00:00', '2000-01-01 00:00:00', '2000-01-01 00:00:00', 0, 0, '', '', '', '', 0, '', 0, 0, 0, '2000-01-01 00:00:00', '2000-01-01 00:00:00', '', 0, 0, '', 0, '', 0, 0, 0, 0, '', '', 0, '2000-01-01 00:00:00', 0, 0, 0, 0, NULL, NOW(), NULL, '', NULL, NULL, NULL, 1, NULL, NULL, NULL, '', NULL);
P.s до редактирования заливается отлично, а после того как я убрал `carMax`int(11)default NULL,`car` varchar(255) NOT NULL,`fuel`int(11)default NULL,`win`int(11)default NULL,`lost`int(11)default NULL,`leavel`int(11) NOT NULL default'1',`id_auto`int(11)default NULL,`cena`int(11)default NULL,
перестало работать
Сообщение отредактировал WOLF_2010: 09 Август 2012 - 20:12