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

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

@@ -7 +7 @@
 INSERT INTO `tabledefs` (`uuid`, `displayname`, `prefix`, `type`, `moduleid`, `maintable`, `querytable`, `editfile`, `editroleid`, `addfile`, `addroleid`, `importfile`, `importroleid`, `searchroleid`, `advsearchroleid`, `viewsqlroleid`, `deletebutton`, `canpost`, `hascustomfields`, `defaultwhereclause`, `defaultsortorder`, `defaultsearchtype`, `defaultcriteriafindoptions`, `defaultcriteriaselection`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('tbld:8179e105-5487-5173-d835-d9d510cc7f1b', 'Prerequisites', NULL, 'table', 'mod:0aa9cca0-7388-0eae-81b9-9935f9d127cc', 'prerequisites', '(prerequisites LEFT JOIN `products` ON prerequisites.parentid=products.uuid) LEFT JOiN products AS childproducts on prerequisites.childid=childproducts.uuid', 'N/A', '', 'N/A', '', NULL, 'Admin', '', 'Admin', 'Admin', 'NA', '0', '0', 'prerequisites.id =-1', 'products.id', '', '', '', 1, NOW(), 1, NOW());
 INSERT INTO `tabledefs` (`uuid`, `displayname`, `prefix`, `type`, `moduleid`, `maintable`, `querytable`, `editfile`, `editroleid`, `addfile`, `addroleid`, `importfile`, `importroleid`, `searchroleid`, `advsearchroleid`, `viewsqlroleid`, `deletebutton`, `canpost`, `hascustomfields`, `defaultwhereclause`, `defaultsortorder`, `defaultsearchtype`, `defaultcriteriafindoptions`, `defaultcriteriaselection`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('tbld:f993cf23-ad4a-047b-e920-d45fee1dc08e', 'Client Duplicates', NULL, 'view', 'mod:0aa9cca0-7388-0eae-81b9-9935f9d127cc', 'clients', '((clients INNER JOIN addresstorecord on clients.uuid = addresstorecord.recordid AND addresstorecord.tabledefid=\'tbld:6d290174-8b73-e199-fe6c-bcf3d4b61083\' AND addresstorecord.primary=1) INNER JOIN addresses ON addresstorecord.addressid = addresses.uuid),((clients AS dclients INNER JOIN addresstorecord as daddresstorecord on dclients.uuid = daddresstorecord.recordid AND daddresstorecord.tabledefid=\'tbld:6d290174-8b73-e199-fe6c-bcf3d4b61083\' AND daddresstorecord.primary=1) INNER JOIN addresses AS daddresses ON daddresstorecord.addressid = daddresses.uuid)', 'N/A', '', 'N/A', '', NULL, 'Admin', '', 'Admin', 'Admin', 'NA', '0', '0', 'clients.id = -100', 'clients.company, clients.lastname, clients.firstname', NULL, NULL, NULL, 1, NOW(), 1, NOW());
-INSERT INTO `tabledefs` (`uuid`, `displayname`, `prefix`, `type`, `moduleid`, `maintable`, `querytable`, `editfile`, `editroleid`, `addfile`, `addroleid`, `importfile`, `importroleid`, `searchroleid`, `advsearchroleid`, `viewsqlroleid`, `deletebutton`, `canpost`, `hascustomfields`, `defaultwhereclause`, `defaultsortorder`, `defaultsearchtype`, `defaultcriteriafindoptions`, `defaultcriteriaselection`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('tbld:157b7707-5503-4161-4dcf-6811f8b0322f', 'Client E-mail Projects', NULL, 'system', 'mod:0aa9cca0-7388-0eae-81b9-9935f9d127cc', 'clientemailprojects', '`clientemailprojects` LEFT JOIN `users` ON `clientemailprojects`.`userid`=`users`.`uuid`', 'modules/bms/clientemailprojects_edit.php', '', 'NA', '', NULL, 'Admin', '', 'Admin', 'Admin', 'delete', '0', '0', 'clientemailprojects.id !=-1', 'clientemailprojects.name', 'search', '', '', 1, NOW(), 1, NOW());
 INSERT INTO `tabledefs` (`uuid`, `displayname`, `prefix`, `type`, `moduleid`, `maintable`, `querytable`, `editfile`, `editroleid`, `addfile`, `addroleid`, `importfile`, `importroleid`, `searchroleid`, `advsearchroleid`, `viewsqlroleid`, `deletebutton`, `canpost`, `hascustomfields`, `defaultwhereclause`, `defaultsortorder`, `defaultsearchtype`, `defaultcriteriafindoptions`, `defaultcriteriaselection`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('tbld:455b8839-162b-3fcb-64b6-eeb946f873e1', 'Discounts', 'dsct', 'table', 'mod:0aa9cca0-7388-0eae-81b9-9935f9d127cc', 'discounts', 'discounts', 'modules/bms/discounts_addedit.php', '', 'modules/bms/discounts_addedit.php', '', NULL, 'Admin', '', 'Admin', 'Admin', 'inactivate', '0', '1', 'discounts.id!=0', 'discounts.id', 'search', 'Active Records', 'name', 1, NOW(), 1, NOW());
 INSERT INTO `tabledefs` (`uuid`, `displayname`, `prefix`, `type`, `moduleid`, `maintable`, `querytable`, `editfile`, `editroleid`, `addfile`, `addroleid`, `importfile`, `importroleid`, `searchroleid`, `advsearchroleid`, `viewsqlroleid`, `deletebutton`, `canpost`, `hascustomfields`, `defaultwhereclause`, `defaultsortorder`, `defaultsearchtype`, `defaultcriteriafindoptions`, `defaultcriteriaselection`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('tbld:fa8a0ddc-87d3-a9e9-60b0-1bab374b2993', 'Shipping Methods', 'smtd', 'table', 'mod:0aa9cca0-7388-0eae-81b9-9935f9d127cc', 'shippingmethods', 'shippingmethods', 'modules/bms/shippingmethods_addedit.php', 'role:259ead9f-100b-55b5-508a-27e33a6216bf', 'modules/bms/shippingmethods_addedit.php', 'role:259ead9f-100b-55b5-508a-27e33a6216bf', NULL, 'Admin', 'role:259ead9f-100b-55b5-508a-27e33a6216bf', 'role:259ead9f-100b-55b5-508a-27e33a6216bf', 'Admin', 'inactivate', '0', '1', 'shippingmethods.inactive!=0', 'shippingmethods.priority, shippingmethods.name', '', '', '', 1, NOW(), 1, NOW());