BlackCat CMS Forum

Code: Alles auswählen

CREATE TABLE `cat_pages_settings` (
	`page_id` INT(11) NOT NULL,
	`set_type` ENUM('internal','meta') NOT NULL DEFAULT 'internal',
	`set_name` VARCHAR(50) NOT NULL,
	`set_value` TINYTEXT NOT NULL,
	UNIQUE INDEX `set_type_set_name` (`page_id`, `set_type`, `set_name`),
	CONSTRAINT `page_id` FOREIGN KEY (`page_id`) REFERENCES `cat_pages` (`page_id`)
) COMMENT='Additional settings for pages' ENGINE=InnoDB DEFAULT CHARSET=utf8;

Code: Alles auswählen

ALTER TABLE `cat_sections`
    ADD COLUMN `modified_when` INT(11) NOT NULL DEFAULT '0' AFTER `name`;
ALTER TABLE `cat_sections`
    ADD COLUMN `modified_by` INT(11) NOT NULL DEFAULT '0' AFTER  `modified_when`;

Code: Alles auswählen

CREATE TABLE `cat_mod_filter` (
    `filter_name` VARCHAR(50) NOT NULL,
    `module_name` VARCHAR(50) NULL DEFAULT NULL,
    `filter_description` TEXT NULL,
    `filter_code` TEXT NULL,
    `filter_active` ENUM('Y','N') NOT NULL DEFAULT 'Y',
    UNIQUE INDEX `filter_name_module_name` (`filter_name`, `module_name`)
    )
    COMMENT='Successor of Output Filters'
    COLLATE='utf8_general_ci'
    ENGINE=InnoDB;