X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=blobdiff_plain;f=DataObjects%2Fcore.sql;fp=DataObjects%2Fcore.sql;h=fcc74da4ece39e8071d81ebe7494f7cac0f1b514;hp=4c2c5ba88191aadcd67a67380d35d86f9c44a472;hb=d04ec2f9f49af51c73463c1d3616012f7fe50683;hpb=aaa15ce1dafdf1c7aa2a75f4c998cbd7f3aada2e

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;
-