I export my old Database for Backup, now I want inport it but I can add it via phpmyadmin. I get this message:
MySQL reports: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax touse near '(6) NOT NULL,
lucky1int(6) NOT NULL,lucky2int(6) NOT NULL, `flyingf' at line 44
I rly dont understand that :/
CREATE TABLE `users` (
`id` bigint(20) NOT NULL,
`username` varchar(30) NOT NULL,
`password` varchar(32) DEFAULT NULL,
`userid` varchar(32) DEFAULT NULL,
`userlevel` tinyint(1) UNSIGNED NOT NULL,
`email` varchar(50) DEFAULT NULL,
`register_date` varchar(20) NOT NULL,
`status` tinyint(4) NOT NULL,
`country` varchar(300) NOT NULL,
`about` varchar(512) NOT NULL,
`birthdate_day` varchar(2) NOT NULL,
`birthdate_month` varchar(2) NOT NULL,
`birthdate_year` varchar(4) NOT NULL,
`gender` varchar(32) NOT NULL,
`age` varchar(100) NOT NULL,
`homepage` varchar(256) NOT NULL,
`msn` varchar(64) NOT NULL DEFAULT 'Keine Angabe',
`icq` varchar(12) NOT NULL DEFAULT 'Keine Angabe',
`skype` varchar(32) NOT NULL DEFAULT 'Keine Angabe',
`profile_color` varchar(7) NOT NULL DEFAULT '#383838',
`profile_banner` varchar(255) NOT NULL DEFAULT 'img/profilbanner.png',
`imagelocation` varchar(600) NOT NULL DEFAULT 'img/avatars/Default.png',
`timestamp` int(11) UNSIGNED NOT NULL,
`S4_ClanMember` varchar(100) NOT NULL DEFAULT 'Keine Angabe',
`S4_MemberSince` varchar(12) NOT NULL DEFAULT 'Keine Angabe',
`S4_OnlySword` varchar(14) NOT NULL DEFAULT 'Keine Angabe',
`S4_AP` varchar(24) NOT NULL DEFAULT 'Keine Angabe',
`S4_Character` varchar(12) NOT NULL DEFAULT 'Keine Angabe',
`S4_GameMode` varchar(100) NOT NULL DEFAULT 'Keine Angabe',
`S4_Players` varchar(18) NOT NULL DEFAULT 'Keine Angabe',
`S4_Level` varchar(8) NOT NULL DEFAULT 'Level 0',
`S4_InGame` varchar(50) NOT NULL DEFAULT 'Keine Angabe',
`money` int(100) NOT NULL DEFAULT '0',
`feature_profile_color` tinyint(1) NOT NULL DEFAULT '0',
`feature_shout_box_color` tinyint(1) NOT NULL DEFAULT '0',
`feature_wait_time` tinyint(1) NOT NULL DEFAULT '0',
`last_login` datetime(6) NOT NULL,
`lucky1` int(6) NOT NULL,
`lucky2` int(6) NOT NULL,
`flyingfox` int(11) NOT NULL,
`wheel` varchar(11) NOT NULL,
`snake` int(11) NOT NULL,
`tetris` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Whats wrong there?
Aucun commentaire:
Enregistrer un commentaire