1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
|
CREATE TABLE IF NOT EXISTS `modules_articles_ini` (
`variable` varchar(255) NOT NULL COMMENT 'variable name',
`value` TINYTEXT NOT NULL COMMENT 'value of the variable',
`host` VARCHAR(36) NOT NULL COMMENT 'uniqueid of host',
`lockedby` TINYINT(2) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'denied changes of values for users with a lower level',
UNIQUE KEY `unique` (`variable`, `host`),
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='configuration « `%module_name%`';
CREATE TABLE IF NOT EXISTS `modules_articles_ids` (
`id` MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'unique (sequential) identifier',
`uniqueid` VARCHAR(36) NOT NULL COMMENT 'uniqueid',
`i18n` CHAR(2) NOT NULL COMMENT 'unique code language by uniqueid',
`title` TINYTEXT NOT NULL COMMENT 'title',
`content` longtext NOT NULL COMMENT 'content',
`tags` TINYTEXT DEFAULT NULL COMMENT 'tags',
`visible` ENUM('no', 'yes') NOT NULL DEFAULT 'no' COMMENT 'visible group uniqueid',
`valid_from` date NOT NULL DEFAULT '0000-00-00' COMMENT 'valid from date',
`valid_until` date NOT NULL DEFAULT '0000-00-00' COMMENT 'valid until date',
`host` VARCHAR(36) NOT NULL COMMENT 'uniqueid of host',
PRIMARY KEY (`id`),
UNIQUE KEY `unique` (`uniqueid`, `i18n`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='ids « `%module_name%`'; |
Partager