Antwort #18 am: 24. September 2010, 06:14:12
Hallo Torsten,
ich habe den Befehl so per phpMyAdmin ausgeführt:
ALTER TABLE admin_access ADD (infocenter INT(1) DEFAULT '0');
UPDATE admin_access SET infocenter = 1 WHERE customers_id = 1;
CREATE TABLE infocenter_categories (
id INT(11) NOT NULL DEFAULT '0',
language_id INT(11) NOT NULL DEFAULT '0',
titel VARCHAR(150) NOT NULL DEFAULT '',
description text NOT NULL,
INT(1) NOT NULL DEFAULT '0',
POSITION INT(11) NOT NULL DEFAULT '0',
PRIMARY KEY (id,language_id)
) TYPE=MyISAM;
CREATE TABLE infocenter_items (
id INT(11) NOT NULL DEFAULT '0',
language_id INT(11) NOT NULL DEFAULT '0',
categories_id INT(11) NOT NULL DEFAULT '0',
title VARCHAR(150) NOT NULL DEFAULT '',
name VARCHAR(200) NOT NULL DEFAULT '',
description text NOT NULL,
INT(1) NOT NULL DEFAULT '0',
POSITION INT(11) NOT NULL DEFAULT '0',
PRIMARY KEY (id,language_id)
) TYPE=MyISAM;
CREATE TABLE infocenter_start (
id INT(1) NOT NULL DEFAULT '0',
language_id INT(11) NOT NULL DEFAULT '0',
description text NOT NULL,
PRIMARY KEY (id,language_id)
) TYPE=MyISAM;
Grüße
Basti