lundi 13 juin 2016

MySQL: #1064 - right syntax to use near '(6) NOT NULL,

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 to

use near '(6) NOT NULL, lucky1 int(6) NOT NULL, lucky2 int(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