From d04ec2f9f49af51c73463c1d3616012f7fe50683 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Fri, 3 Jun 2016 16:03:37 +0800 Subject: [PATCH] DataObjects/core.sql --- DataObjects/core.sql | 59 -------------------------------------------- 1 file changed, 59 deletions(-) diff --git a/DataObjects/core.sql b/DataObjects/core.sql index 4c2c5ba8..fcc74da4 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -163,62 +163,3 @@ alter table core_locking change column `int` id int(11) auto_increment not null -- ---------------------------- -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; - -- 2.39.2