From: Alan Knowles <alan@akbkhome.com>
Date: Sun, 6 Mar 2011 02:13:42 +0000 (+0800)
Subject: DataObjects/core.sql
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=6adf7b28a45919a9976ef03f90cb39d21e3f8606

DataObjects/core.sql
---

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` (