Changeset 718 for trunk/phpbms/modules/bms/install/updatev0.98.sql

Timestamp:

01/05/10 17:06:44 (2 years ago)

Author:

brieb

Message:

• Completely removed client email projects from the system. It was partially broken in v0.96 and fully broken in the new system. Also, sending out thousands of e-mails can get messy and requires a lot of coding to do correctly. Instead, we have opted to leave it to others who have done it right (mailchimp.com). This is a big reason we have implemented the MailChimp? module

Files:

• trunk/phpbms/modules/bms/install/updatev0.98.sql (modified) (2 diffs)

trunk/phpbms/modules/bms/install/updatev0.98.sql

@@ -48 +48 @@
 ALTER TABLE `attachments` ENGINE=INNODB;
 --end attachements ALTER--
---clientemailprojects ALTER--
-ALTER TABLE `clientemailprojects` ENGINE=INNODB;
-ALTER TABLE `clientemailprojects`
-    ADD COLUMN `uuid` varchar(64) NOT NULL AFTER `id`,
-    MODIFY `userid` VARCHAR(64) NOT NULL;
---end clientemailprojects ALTER--
+--clientemailprojects DROP--
+DROP TABLE `clientemailprojects`
+--end clientemailprojects DROP--
 --clients ALTER--
 ALTER TABLE `clients` ENGINE=INNODB;
@@ -663 +660 @@
 WHERE
     `id`='18';
+
+DELETE FROM `tabledefs` WHERE `id` = 22;
+DELETE FROM `tableoptions` WHERE `tabledefid` = 22;
+DELETE FROM `tablecolumns` WHERE `tabledefid` = 22;
+DELETE FROM `tableoptions` WHERE `tabledefid` = 22;
+DELETE FROM `tablegroupings` WHERE `tabledefid` = 22;
+DELETE FROM `tablefindoptions` WHERE `tabledefid` = 22;
+DELETE FROM `tablesearchablefields` WHERE `tabledefid` = 22;
+DELETE FROM `menu` WHERE `name` = 'Email Projects';
+
 UPDATE `tabledefs` SET
     `uuid`='tbld:157b7707-5503-4161-4dcf-6811f8b0322f',