From 6adf7b28a45919a9976ef03f90cb39d21e3f8606 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Sun, 6 Mar 2011 10:13:42 +0800 Subject: [PATCH] DataObjects/core.sql --- DataObjects/core.sql | 13 +++++++++++++ 1 file changed, 13 insertions(+) diff --git a/DataObjects/core.sql b/DataObjects/core.sql index 56022673..17696b10 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -258,6 +258,19 @@ CREATE TABLE core_locking ( alter table core_locking ADD INDEX `lookup`(`on_table`, `on_id`, `person_id`, `created`); +# -- a generic enumeraction +CREATE TABLE `core_enum` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `etype` varchar(32) NOT NULL, + `name` varchar(255) NOT NULL, + `active` int(2) NOT NULL DEFAULT 1, + `seqid` int(11) NOT NULL DEFAULT 0, + PRIMARY KEY (`id`), + INDEX `lookup`(`seqid`, `active`, `name`, `etype`) +) +ENGINE = MyISAM; + + CREATE TABLE `translations` ( -- 2.39.2