(29 май 2013, 21:21) (
0/
0)
[
0]
Вот исходный,он везде стоит
=========
CREATE TABLE `ban_user` (
`uid` int(10) unsigned NOT NULL default \'0\',
`link` varchar(35) NOT NULL default \'\',
PRIMARY KEY (`uid`)
) TYPE=MyISAM;
CREATE TABLE `count_24` (
`id` int(10) unsigned NOT NULL auto_increment,
`uid` int(10) unsigned NOT NULL default \'0\',
`date` int(10) unsigned NOT NULL default \'0\',
`hour` smallint(5) unsigned NOT NULL default \'0\',
`count` int(10) unsigned NOT NULL default \'0\',
`host` int(10) unsigned NOT NULL default \'0\',
PRIMARY KEY (`id`)
) TYPE=MyISAM ;
CREATE TABLE `hits_ip` (
`uid` int(10) unsigned NOT NULL default \'0\',
`ip` varchar(15) NOT NULL default \'\',
`ua` varchar(255) NOT NULL default \'n/a\',
PRIMARY KEY (`ip`,`ua`,`uid`)
) TYPE=MyISAM;
CREATE TABLE `hits_time` (
`uid` int(10) unsigned NOT NULL default \'0\',
`time` int(10) unsigned NOT NULL default \'0\',
PRIMARY KEY (`uid`)
) TYPE=MyISAM;
CREATE TABLE `models_data` (
`ua` varchar(40) NOT NULL default \'\',
`vendor` varchar(20) NOT NULL default \'n/a\',
`model` varchar(20) NOT NULL default \'n/a\',
`screensize` varchar(7) NOT NULL default \'n/a\',
`bitsperpixel` smallint(5) unsigned NOT NULL default \'0\',
`supportedbearers` varchar(50) NOT NULL default \'n/a\',
`javaplatform` varchar(50) NOT NULL default \'n/a\',
`wapversion` varchar(30) NOT NULL default \'n/a\',
`wmlversion` varchar(30) NOT NULL default \'n/a\',
`wmlscript` varchar(30) NOT NULL default \'n/a\',
`keyboard` varchar(40) NOT NULL default \'n/a\',
`numsoftkeys` varchar(5) NOT NULL default \'n/a\',
`charset` varchar(50) NOT NULL default \'n/a\',
`emailschemes` varchar(30) NOT NULL default \'n/a\',
`browserframes` varchar(10) NOT NULL default \'n/a\',
`browserjavaapplet` varchar(10) NOT NULL default \'n/a\',
`html` varchar(10) NOT NULL default \'n/a\',
`xhtml` varchar(10) NOT NULL default \'n/a\',
`browsertables` varchar(10) NOT NULL default \'n/a\',
PRIMARY KEY (`ua`)
) TYPE=MyISAM;
CREATE TABLE `months` (
`id` int(10) unsigned NOT NULL auto_increment,
`uid` int(10) unsigned NOT NULL default \'0\',
`date` int(10) unsigned NOT NULL default \'0\',
`count` int(10) unsigned NOT NULL default \'0\',
`host` int(10) unsigned NOT NULL default \'0\',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
CREATE TABLE `online_ip` (
`uid` int(10) unsigned NOT NULL default \'0\',
`ip` varchar(15) NOT NULL default \'\',
`time` int(10) unsigned NOT NULL default \'0\',
`browser` varchar(25) NOT NULL default \'unknow\',
PRIMARY KEY (`ip`,`uid`)
) TYPE=MyISAM;
CREATE TABLE `superadmin` (
`id` int(10) unsigned NOT NULL auto_increment,
`login` varchar(20) NOT NULL default \'\',
`pass` varchar(50) NOT NULL default \'\',
PRIMARY KEY (`id`,`login`)
) TYPE=MyISAM;
CREATE TABLE `online_time` (
`uid` int(10) unsigned NOT NULL default \'0\',
`time` int(10) unsigned NOT NULL default \'0\',
PRIMARY KEY (`uid`)
) TYPE=MyISAM;
CREATE TABLE `users` (
`uid` int(10) unsigned NOT NULL auto_increment,
`site_name` varchar(50) NOT NULL default \'\',
`link` varchar(50) NOT NULL default \'\',
`admin` varchar(30) NOT NULL default \'\',
`email` varchar(30) NOT NULL default \'\',
`info` varchar(200) NOT NULL default \'\',
`date` int(10) unsigned NOT NULL default \'0\',
`pass` varchar(50) NOT NULL default \'\',
`ncont` varchar(6) NOT NULL default \'\',
`type` int(1) unsigned NOT NULL default \'2\',
`typeStat` int(1) unsigned NOT NULL default \'1\',
PRIMARY KEY (`uid`)
) TYPE=MyISAM;
CREATE TABLE `weeks` (
`id` int(10) unsigned NOT NULL auto_increment,
`uid` int(10) unsigned NOT NULL default \'0\',
`next_mon` int(10) unsigned NOT NULL default \'0\',
`date` int(10) unsigned NOT NULL default \'0\',
`day_week` smallint(5) unsigned NOT NULL default \'0\',
`count` int(10) unsigned NOT NULL default \'0\',
`host` int(10) unsigned NOT NULL default \'0\',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
(29 май 2013, 20:56) (
0/
0)
[
0]
Ошибка
Error: Синтактическая ошибка \'TYPE=MyISAM\' at line 5
CREATE TABLE `ban_user` ( `uid` int(10) unsigned NOT NULL default \'0\', `link` varchar(35) NOT NULL default \'\', PRIMARY KEY (`uid`) ) TYPE=MyISAM
-----------
Ошибка
Error: Синтактическая ошибка \'TYPE=MyISAM\' at line 9
CREATE TABLE `count_24` ( `id` int(10) unsigned NOT NULL auto_increment, `uid` int(10) unsigned NOT NULL default \'0\', `date` int(10) unsigned NOT NULL default \'0\', `hour` smallint(5) unsigned NOT NULL default \'0\', `count` int(10) unsigned NOT NULL default \'0\', `host` int(10) unsigned NOT NULL default \'0\', PRIMARY KEY (`id`) ) TYPE=MyISAM
-----------
Ошибка
Error: Синтактическая ошибка \'TYPE=MyISAM\' at line 6
CREATE TABLE `hits_ip` ( `uid` int(10) unsigned NOT NULL default \'0\', `ip` varchar(15) NOT NULL default \'\', `ua` varchar(255) NOT NULL default \'n/a\', PRIMARY KEY (`ip`,`ua`,`uid`) ) TYPE=MyISAM
-----------
Ошибка
Error: Синтактическая ошибка \'TYPE=MyISAM\' at line 5
CREATE TABLE `hits_time` ( `uid` int(10) unsigned NOT NULL default \'0\', `time` int(10) unsigned NOT NULL default \'0\', PRIMARY KEY (`uid`) ) TYPE=MyISAM
-----------
Ошибка
Error: Синтактическая ошибка \'TYPE=MyISAM\' at line 22
CREATE TABLE `models_data` ( `ua` varchar(40) NOT NULL default \'\', `vendor` varchar(20) NOT NULL default \'n/a\', `model` varchar(20) NOT NULL default \'n/a\', `screensize` varchar(7) NOT NULL default \'n/a\', `bitsperpixel` smallint(5) unsigned NOT NULL default \'0\', `supportedbearers` varchar(50) NOT NULL default \'n/a\', `javaplatform` varchar(50) NOT NULL default \'n/a\', `wapversion` varchar(30) NOT NULL default \'n/a\', `wmlversion` varchar(30) NOT NULL default \'n/a\', `wmlscript` varchar(30) NOT NULL default \'n/a\', `keyboard` varchar(40) NOT NULL default \'n/a\', `numsoftkeys` varchar(5) NOT NULL default \'n/a\', `charset` varchar(50) NOT NULL default \'n/a\', `emailschemes` varchar(30) NOT NULL default \'n/a\', `browserframes` varchar(10) NOT NULL default \'n/a\', `browserjavaapplet` varchar(10) NOT NULL default \'n/a\', `html` varchar(10) NOT NULL default \'n/a\', `xhtml` varchar(10) NOT NULL default \'n/a\', `browsertables` varchar(10) NOT NULL default \'n/a\', PRIMARY KEY (`ua`) ) TYPE=MyISAM
-----------
Ошибка
Error: Синтактическая ошибка \'TYPE=MyISAM\' at line 8
CREATE TABLE `months` ( `id` int(10) unsigned NOT NULL auto_increment, `uid` int(10) unsigned NOT NULL default \'0\', `date` int(10) unsigned NOT NULL default \'0\', `count` int(10) unsigned NOT NULL default \'0\', `host` int(10) unsigned NOT NULL default \'0\', PRIMARY KEY (`id`) ) TYPE=MyISAM
-----------
Ошибка
Error: Синтактическая ошибка \'TYPE=MyISAM\' at line 7
CREATE TABLE `online_ip` ( `uid` int(10) unsigned NOT NULL default \'0\', `ip` varchar(15) NOT NULL default \'\', `time` int(10) unsigned NOT NULL default \'0\', `browser` varchar(25) NOT NULL default \'unknow\', PRIMARY KEY (`ip`,`uid`) ) TYPE=MyISAM
-----------
Ошибка
Error: Синтактическая ошибка \'TYPE=MyISAM\' at line 6
CREATE TABLE `superadmin` ( `id` int(10) unsigned NOT NULL auto_increment, `login` varchar(20) NOT NULL default \'\', `pass` varchar(50) NOT NULL default \'\', PRIMARY KEY (`id`,`login`) ) TYPE=MyISAM
-----------
Ошибка
Error: Синтактическая ошибка \'TYPE=MyISAM\' at line 5
CREATE TABLE `online_time` ( `uid` int(10) unsigned NOT NULL default \'0\', `time` int(10) unsigned NOT NULL default \'0\', PRIMARY KEY (`uid`) ) TYPE=MyISAM
-----------
Ошибка
Error: Синтактическая ошибка \'TYPE=MyISAM\' at line 14
CREATE TABLE `users` ( `uid` int(10) unsigned NOT NULL auto_increment, `site_name` varchar(50) NOT NULL default \'\', `link` varchar(50) NOT NULL default \'\', `admin` varchar(30) NOT NULL default \'\', `email` varchar(30) NOT NULL default \'\', `info` varchar(200) NOT NULL default \'\', `date` int(10) unsigned NOT NULL default \'0\', `pass` varchar(50) NOT NULL default \'\', `ncont` varchar(6) NOT NULL default \'\', `type` int(1) unsigned NOT NULL default \'2\', `typeStat` int(1) unsigned NOT NULL default \'1\', PRIMARY KEY (`uid`) ) TYPE=MyISAM
-----------
Ошибка
Error: Синтактическая ошибка \'TYPE=MyISAM\' at line 10
CREATE TABLE `weeks` ( `id` int(10) unsigned NOT NULL auto_increment, `uid` int(10) unsigned NOT NULL default \'0\', `next_mon` int(10) unsigned NOT NULL default \'0\', `date` int(10) unsigned NOT NULL default \'0\', `day_week` smallint(5) unsigned NOT NULL default \'0\', `count` int(10) unsigned NOT NULL default \'0\', `host` int(10) unsigned NOT NULL default \'0\', PRIMARY KEY (`id`) ) TYPE=MyISAM;
-----------
Процесс дампа окончен.
Всего запросов: 11
Ошибок: 11