Tabellen zur installation hinzufügen

[xTeN]

Hallo,

ich habe ein problem, und zwar möchte ich gerne 3 von mir erstellte tabellen in die mysql_schema.sql datei einfügen, dass sie bei künftigen installationen gleich mit erstellt werden, ich habe mich am schema orientiert aber scheine etwas falsch gemacht zu haben, denn ich bekomme immer den folgenden Fehler:

Beim Update der Datenbank trat ein Fehler auf
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 ''0' NOT NULL, faq_game mediumint(8) UNSIGNED '0' NOT NULL, faq_publisher m' at line 3

Das ist der Code:

Code: Alles auswählen

CREATE TABLE faq_contents (
   faq_id mediumint(8) UNSIGNED NOT NULL auto_increment,
   faq_poster mediumint(8) UNSIGNED '0' NOT NULL,
   faq_game mediumint(8) UNSIGNED '0' NOT NULL,
   faq_publisher mediumint(8) DEFAULT '0' NOT NULL,
   faq_type smallint(2)  UNSIGNED '1' NOT NULL,
   faq_subject text,
   faq_time int(11) DEFAULT '0' NOT NULL,
   faq_text text,
   faq_file text,
   PRIMARY KEY (faq_id)
);

CREATE TABLE faq_games (
   game_id mediumint(8) UNSIGNED NOT NULL auto_increment,
   game_platform_id mediumint(8) UNSIGNED '0' NOT NULL,
   game_title varchar(60)NULL,
   game_release varchar(20) NULL,
   game_creator varchar(60) NULL,
   game_publisher varchar(60) NULL,
   game_boxart text,
   game_articles smallint(5) UNSIGNED '0' NOT NULL,
   game_clicks mediumint(8) DEFAULT '0' NOT NULL,
   game_clicks_ips text,
   game_clicks_day int(11) DEFAULT '0' NOT NULL,
   PRIMARY KEY (game_id)
);

CREATE TABLE faq_platforms (
   platform_id mediumint(8) UNSIGNED NOT NULL auto_increment,
   platform_name varchar(60) NULL,
   platform_logo text,
   PRIMARY KEY (platform_id)
);

CREATE TABLE faq_submissions (
   submit_id mediumint(8) UNSIGNED NOT NULL auto_increment,
   poster_id mediumint(8) UNSIGNED '0' NOT NULL,
   poster_ip varchar(15) NOT NULL,
   submit_time int(11) DEFAULT '0' NOT NULL,
   submit_game mediumint(8) DEFAULT '0' NOT NULL,
   submit_type smallint(2) UNSIGNED '1' NOT NULL,
   submit_subject text,
   submit_text text,
   submit_attachment text,
   PRIMARY KEY (submit_id)
);

[xTeN]

Okay erledigt, so gehts:

Code: Alles auswählen

# --------------------------------------------------------
#
# MAINPAGE TABLES 
#
# --------------------------------------------------------

CREATE TABLE faq_contents (
   faq_id mediumint(8) NOT NULL auto_increment,
   faq_poster mediumint(8) DEFAULT '0' NOT NULL,
   faq_game mediumint(8) DEFAULT '0' NOT NULL,
   faq_publisher mediumint(8) DEFAULT '0' NOT NULL,
   faq_type smallint(2) UNSIGNED DEFAULT '1' NOT NULL,
   faq_subject text,
   faq_time int(11),
   faq_text text,
   faq_file text,
   PRIMARY KEY (faq_id)
);

CREATE TABLE faq_games (
   game_id mediumint(8) NOT NULL auto_increment,
   game_platform_id mediumint(8) DEFAULT '0' NOT NULL,
   game_title varchar(60) NULL,
   game_release varchar(20) NULL,
   game_creator varchar(60) NULL,
   game_publisher varchar(60) NULL,
   game_boxart text,
   game_articles smallint(5) UNSIGNED DEFAULT '0' NOT NULL,
   game_clicks mediumint(8) DEFAULT '0' NOT NULL,
   game_clicks_ips text,
   game_clicks_day int(11),
   PRIMARY KEY (game_id)
);

CREATE TABLE faq_platforms (
   platform_id mediumint(8) NOT NULL auto_increment,
   platform_name varchar(60) NULL,
   platform_logo text,
   PRIMARY KEY (platform_id)
);

CREATE TABLE faq_submissions (
   submit_id mediumint(8) NOT NULL auto_increment,
   poster_id mediumint(8) DEFAULT '0' NOT NULL,
   poster_ip varchar(15) NOT NULL,
   submit_time int(11),
   submit_game mediumint(8) DEFAULT '0' NOT NULL,
   submit_type smallint(2) UNSIGNED DEFAULT '1' NOT NULL,
   submit_subject text,
   submit_text text,
   submit_attachment text,
   PRIMARY KEY (submit_id)
);