SQL Problem

[Heracross]

Hallo,
was muss ich von hier in den SQL einfügen?

Code: Alles auswählen

<sql><![CDATA[CREATE TABLE `phpbb_forums_selected` (`user_id` MEDIUMINT( 8 ) NOT NULL , `forum_id` MEDIUMINT( 8 ) NOT NULL , PRIMARY KEY ( `user_id` , `forum_id` ) )]]></sql>
		<sql><![CDATA[ALTER TABLE `phpbb_forums` ADD `static` TINYINT( 1 ) NOT NULL DEFAULT '0']]></sql>
		<sql><![CDATA[CREATE TABLE `phpbb_selection_templates` (`template_id` MEDIUMINT( 8 ) NOT NULL ,`forum_id` MEDIUMINT( 8 ) NOT NULL ,PRIMARY KEY ( `template_id` , `forum_id` ))]]></sql>
		<sql><![CDATA[CREATE TABLE `phpbb_selection_template_names` (`template_id` MEDIUMINT( 8 ) NOT NULL AUTO_INCREMENT ,`template_name` VARCHAR( 255 ) NOT NULL ,PRIMARY KEY ( `template_id` ))]]></sql>
		<sql><![CDATA[INSERT INTO `phpbb_selection_template_names` (`template_id` ,`template_name`)VALUES ('-1', 'Default'), ('0', 'reserved');]]></sql>

Wenn ich das hier nehme,dann kommt ein Fehler:

Code: Alles auswählen

CREATE TABLE `phpbb_forums_selected` (`user_id` MEDIUMINT( 8 ) NOT NULL , `forum_id` MEDIUMINT( 8 ) NOT NULL , PRIMARY KEY ( `user_id` , `forum_id` ) )
ALTER TABLE `phpbb_forums` ADD `static` TINYINT( 1 ) NOT NULL DEFAULT '0'
CREATE TABLE `phpbb_selection_templates` (`template_id` MEDIUMINT( 8 ) NOT NULL ,`forum_id` MEDIUMINT( 8 ) NOT NULL ,PRIMARY KEY ( `template_id` , `forum_id` ))
CREATE TABLE `phpbb_selection_template_names` (`template_id` MEDIUMINT( 8 ) NOT NULL AUTO_INCREMENT ,`template_name` VARCHAR( 255 ) NOT NULL ,PRIMARY KEY ( `template_id` ))
INSERT INTO `phpbb_selection_template_names` (`template_id` ,`template_name`)VALUES ('-1', 'Default'), ('0', 'reserved');

[nickvergessen]

Code: Alles auswählen

CREATE TABLE `phpbb_forums_selected` (`user_id` MEDIUMINT( 8 ) NOT NULL , `forum_id` MEDIUMINT( 8 ) NOT NULL , PRIMARY KEY ( `user_id` , `forum_id` ) );

ALTER TABLE `phpbb_forums` ADD `static` TINYINT( 1 ) NOT NULL DEFAULT '0';

CREATE TABLE `phpbb_selection_templates` (`template_id` MEDIUMINT( 8 ) NOT NULL ,`forum_id` MEDIUMINT( 8 ) NOT NULL ,PRIMARY KEY ( `template_id` , `forum_id` ));

CREATE TABLE `phpbb_selection_template_names` (`template_id` MEDIUMINT( 8 ) NOT NULL AUTO_INCREMENT ,`template_name` VARCHAR( 255 ) NOT NULL ,PRIMARY KEY ( `template_id` ));

INSERT INTO `phpbb_selection_template_names` (`template_id` ,`template_name`)VALUES ('-1', 'Default'), ('0', 'reserved');