Changeset 718 for trunk/phpbms/modules/bms/install/tablecolumns.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/tablecolumns.sql (modified) (1 diff)

trunk/phpbms/modules/bms/install/tablecolumns.sql

@@ -1 @@
-INSERT INTO `tablecolumns` (`tabledefid`, `name`, `column`, `align`, `footerquery`, `displayorder`, `sortorder`, `wrap`, `size`, `format`, `roleid`) VALUES ('tbld:157b7707-5503-4161-4dcf-6811f8b0322f', 'name', 'clientemailprojects.name', 'left', '', '0', '', '0', '100%', NULL, '');
-INSERT INTO `tablecolumns` (`tabledefid`, `name`, `column`, `align`, `footerquery`, `displayorder`, `sortorder`, `wrap`, `size`, `format`, `roleid`) VALUES ('tbld:157b7707-5503-4161-4dcf-6811f8b0322f', 'last run', 'clientemailprojects.lastrun', 'right', '', '1', '', '0', '', 'datetime', '');
 INSERT INTO `tablecolumns` (`tabledefid`, `name`, `column`, `align`, `footerquery`, `displayorder`, `sortorder`, `wrap`, `size`, `format`, `roleid`) VALUES ('tbld:27b99bda-7bec-b152-8397-a3b09c74cb23', 'id', 'addresses.id', 'left', '', '0', '', '0', '', NULL, '');
 INSERT INTO `tablecolumns` (`tabledefid`, `name`, `column`, `align`, `footerquery`, `displayorder`, `sortorder`, `wrap`, `size`, `format`, `roleid`) VALUES ('tbld:31423480-a9b0-f0ff-749e-b3b5e18ca93c', 'id', 'lineitems.id', 'left', '', '0', '', '0', '', NULL, '');