Тема: dump DB from mysql 4.0.28 to MySQL 5.1
Hello All!
SQL-запрос:
CREATE TABLE om_gallery(
id int( 12 ) NOT NULL AUTO_INCREMENT ,
identy varchar( 250 ) NOT NULL default '',
name varchar( 250 ) NOT NULL default '',
DESC text,
titlepages text NOT NULL ,
text mediumtext NOT NULL ,
keywords text NOT NULL ,
langchar( 2 ) NOT NULL default '',
parent int( 12 ) NOT NULL default '0',
prior int( 12 ) NOT NULL default '0',
FIRST int( 1 ) NOT NULL default '0',
url varchar( 250 ) default NULL ,
STATUS int( 1 ) NOT NULL default '0',
img varchar( 200 ) default NULL ,
bottom int( 1 ) default '0',
UNIQUE KEY id( id ) ,
KEY identy( identy )
) TYPE = MYISAM ;
#1064 - 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 'desc text,
titlepages text NOT NULL,
text mediumtext NOT NULL,
keywords te' at line 5