hi!!!
i have a problem with uploading a table that i have exported from mysql version 4.1 to 4.0...
this is the table...
Code:
CREATE TABLE `admin` (
  `ADMIN_ID` int(11) NOT NULL auto_increment,
  `username` varchar(40) collate latin1_general_ci default NULL,
  `password` varchar(6) collate latin1_general_ci default NULL,
  `vaznost` enum('0','1') collate latin1_general_ci default '0',
  `IsAktivan` enum('0','1') collate latin1_general_ci default '1' COMMENT '0 = nije aktivan 1=aktivan',
  PRIMARY KEY  (`ADMIN_ID`),
  UNIQUE KEY `password` (`password`),
  KEY `IDX_AUTH1` (`ADMIN_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='0 je administrator za podatke, a 1 za cijelu bazu';
i get the following error...
error 1064 blabla mysql manual blabla near collate latin1_general_ci default NULL,....
any suggestion about why this error comes up?
thanx in avdance!