DataObjects/core.sql

[Pman.Core] / DataObjects / core.sql

diff --git a/DataObjects/core.sql b/DataObjects/core.sql
index 5d22232..213596a 100644 (file)
--- a/DataObjects/core.sql
+++ b/DataObjects/core.sql
@@ -43,11 +43,11 @@ ALTER TABLE Companies ALTER url SET DEFAULT '';
 ALTER TABLE Companies ADD COLUMN    address1 text ;
 ALTER TABLE Companies ADD COLUMN    address2 text ;
 ALTER TABLE Companies ADD COLUMN    address3 text ;
-
+ALTER TABLE Companies ADD COLUMN is_system INT(2) NOT NULL DEFAULT 0;-- #2028
 
 
 ALTER TABLE Companies ADD INDEX name_lookup (name);
-ALTER TABLE Companies ADD COLUMN is_system INT(2) NOT NULL DEFAULT 0;
+
 
 -- our new code should have this fixed now..
 -- UPDATE Companies set comptype='OWNER' where isOwner=1;
@@ -457,5 +457,20 @@ ALTER TABLE  core_notify_recur  ADD INDEX lookup(person_id, dtstart, dtend, tz,
 
 -- old design..
 ALTER TABLE  core_notify_recur  CHANGE COLUMN tz  tz varchar(64)  NOT NULL;
- 
+
+
+
+CREATE  TABLE core_mailing_list_message (
+  id INT(11) NOT NULL AUTO_INCREMENT ,
+  subject TEXT NULL ,
+  bodytext TEXT NULL ,
+  plaintext TEXT NULL ,
+  name VARCHAR(255) NOT NULL DEFAULT '',
+  updated_dt DATETIME NOT NULL ,
+  from_email VARCHAR(254) NULL DEFAULT '',
+  from_name VARCHAR(254) NULL DEFAULT '',
+  owner_id INT(11) NOT NULL DEFAULT 0,
+  is_system INT(2) NOT NULL DEFAULT 1,
+  PRIMARY KEY (id)
+);