am: 10. Januar 2018, 21:45:40
Hallowie kann ich diesen Text in der Datenbank löschen.
Was muss ich mit diesen Code zusammen eingeben.
Danke
CREATE TABLE IF NOT EXISTS `customers_notice` (
`customers_notice_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`status` SMALLINT(1) NOT NULL DEFAULT '0',
`position` INT(3) NOT NULL DEFAULT '1',
`startdate` datetime DEFAULT '0000-00-00 00:00:00',
`enddate` datetime DEFAULT '0000-00-00 00:00:00',
`template` VARCHAR(100)DEFAULT '',
`customers_status` VARCHAR(255) DEFAULT '',
`pages` text COLLATE,
PRIMARY KEY (`customers_notice_id`)
);
CREATE TABLE IF NOT EXISTS `customers_notice_description` (
`customers_notice_id` INT(10) UNSIGNED NOT NULL,
`languages_id` INT(10) UNSIGNED NOT NULL,
`title` VARCHAR(255)DEFAULT NULL,
`description` text,
PRIMARY KEY (`customers_notice_id`,`languages_id`)
);
ALTER TABLE admin_access ADD customers_notice SMALLINT(1) NOT NULL DEFAULT '0';
UPDATE admin_access SET customers_notice = 1 WHERE customers_id = '1';
Linkback: https://www.modified-shop.org/forum/index.php?topic=38463.0