DataObjects/core.sql

[Pman.Core] / DataObjects / core.sql

diff --git a/DataObjects/core.sql b/DataObjects/core.sql
index 574d69e..fcc74da 100644 (file)
--- a/DataObjects/core.sql
+++ b/DataObjects/core.sql
@@ -160,90 +160,6 @@ ALTER TABLE  core_locking ADD COLUMN  created datetime ;
 alter table  core_locking ADD  INDEX lookup(on_table, on_id, person_id, created);
 -- oops... - wrong name of pid.
 alter table  core_locking change column `int` id int(11) auto_increment not null;
-
--- a generic enumeraction
-
-CREATE TABLE   core_enum (
-  id int(11)  NOT NULL AUTO_INCREMENT,
-  PRIMARY KEY (id)
- 
-);
  
-alter table  core_enum ADD COLUMN  etype varchar(32)  NOT NULL DEFAULT '';
-alter table  core_enum ADD COLUMN  name varchar(255)  NOT NULL DEFAULT '';
-alter table  core_enum ADD COLUMN  active int(2)  NOT NULL DEFAULT 1;
-alter table  core_enum ADD COLUMN  seqid int(11)  NOT NULL DEFAULT 0;
-alter table  core_enum ADD COLUMN  seqmax int(11)  NOT NULL DEFAULT 0;
-alter table  core_enum ADD COLUMN  display_name varchar(255)  NOT NULL DEFAULT '';
-
-
-ALTER TABLE core_enum ADD COLUMN is_system_enum INT(2) NOT NULL DEFAULT 0;
-ALTER TABLE core_enum CHANGE COLUMN display_name display_name TEXT NOT NULL DEFAULT '';
-
-alter table  core_enum ADD  INDEX lookup(seqid, active, name, etype);
-
-
-UPDATE core_enum SET display_name = name WHERE display_name = '';
-
-
 -- ----------------------------
 
-CREATE TABLE  translations (
-  id int(11)  NOT NULL AUTO_INCREMENT,
-  PRIMARY KEY (id)
-);
-
-alter table  translations ADD COLUMN    module varchar(64)  NOT NULL DEFAULT '';
-alter table  translations ADD COLUMN    tfile varchar(128) NOT NULL DEFAULT '';
-alter table  translations ADD COLUMN    tlang varchar(8)  NOT NULL DEFAULT '';
-alter table  translations ADD COLUMN    tkey varchar(32)  NOT NULL DEFAULT '';
-alter table  translations ADD COLUMN    tval longtext ;
-
-
-ALTER TABLE translations ADD INDEX qlookup (module, tfile, tlang, tkey);
-
-
-
-CREATE TABLE core_person_alias (
-  id int(11)  NOT NULL AUTO_INCREMENT,
-
-  PRIMARY KEY (id)
-) ;
-ALTER TABLE core_person_alias ADD COLUMN   person_id varchar(128) DEFAULT NULL;
-ALTER TABLE core_person_alias ADD COLUMN  alias varchar(254) NOT NULL DEFAULT '';
-  
-ALTER TABLE core_person_alias ADD INDEX alias (alias);
-
-
-
-CREATE TABLE core_notify_recur (
-  id int(11)  NOT NULL AUTO_INCREMENT,
-
-  PRIMARY KEY (id)
-);
- 
-
-ALTER TABLE  core_notify_recur  ADD COLUMN person_id int(11)  NOT NULL;
-ALTER TABLE  core_notify_recur  ADD COLUMN dtstart datetime  NOT NULL;
-ALTER TABLE  core_notify_recur  ADD COLUMN dtend datetime  NOT NULL;
-ALTER TABLE  core_notify_recur  ADD COLUMN max_applied_dt datetime  NOT NULL;
-ALTER TABLE  core_notify_recur  ADD COLUMN updated_dt datetime  NOT NULL;
-ALTER TABLE  core_notify_recur  ADD COLUMN last_applied_dt datetime  NOT NULL;
-ALTER TABLE  core_notify_recur  ADD COLUMN tz varchar(64)  NOT NULL;
- 
-ALTER TABLE  core_notify_recur  ADD COLUMN freq varchar(8) NOT NULL;
-ALTER TABLE  core_notify_recur  ADD COLUMN freq_day text NOT NULL;
-ALTER TABLE  core_notify_recur  ADD COLUMN freq_hour text  NOT NULL;
-
-ALTER TABLE  core_notify_recur  ADD COLUMN onid int(11)  NOT NULL default 0;
-ALTER TABLE  core_notify_recur  ADD COLUMN ontable varchar(128)  NOT NULL default '';
-ALTER TABLE  core_notify_recur  ADD COLUMN last_event_id  int(11)  default 0;
-ALTER TABLE  core_notify_recur  ADD COLUMN method varchar(128) default '';     
-
-ALTER TABLE  core_notify_recur  ADD COLUMN method_id  int(11)  default 0;
-
-ALTER TABLE  core_notify_recur  ADD INDEX lookup(person_id, dtstart, dtend, tz, max_applied_dt, updated_dt, last_applied_dt);
-
--- old design..
-ALTER TABLE  core_notify_recur  CHANGE COLUMN tz  tz varchar(64)  NOT NULL;
-