Changeset 613 for trunk/phpbms/install/smartsearches.sql

Timestamp:

06/19/09 17:21:27 (3 years ago)

Author:

nate

Message:

• Prerequisites changed to use uuids.
• Lineitems changed to use prerequisites considering the above change.
• Initial sql changes for install.

Files:

• trunk/phpbms/install/smartsearches.sql (modified) (1 diff)

trunk/phpbms/install/smartsearches.sql

@@ -1 @@
-INSERT INTO `smartsearches` (`uuid`, `name`, `fromclause`, `valuefield`, `displayfield`, `secondaryfield`, `classfield`, `searchfields`, `filterclause`, `rolefield`, `tabledefid`, `moduleid`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('smrt:ccc73fa4-6176-fad4-fbb1-5186d0edbdd1', 'Pick Active User', 'users', 'users.id', 'CONCAT(users.firstname,\' \',users.lastname)', 'users.email', '\'\'', 'users.firstname, users.lastname', 'users.revoked=0 AND users.portalaccess = 0', NULL, '9', '1', 1, NOW(), 1, NOW());
-INSERT INTO `smartsearches` (`uuid`, `name`, `fromclause`, `valuefield`, `displayfield`, `secondaryfield`, `classfield`, `searchfields`, `filterclause`, `rolefield`, `tabledefid`, `moduleid`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('smrt:855406d5-659d-c907-74a1-acfd3802fd73', 'Pick File', 'files', 'files.id', 'files.name', 'files.description', '\'\'', 'files.name, files.description', 'files.id!=0', 'files.roleid', '26', '1', 1, NOW(), 1, NOW());
-INSERT INTO `smartsearches` (`uuid`, `name`, `fromclause`, `valuefield`, `displayfield`, `secondaryfield`, `classfield`, `searchfields`, `filterclause`, `rolefield`, `tabledefid`, `moduleid`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('smrt:ed5b1d7f-b0fe-2088-f17c-47bfbe1ace25', 'Pick Active User Email', 'users', 'users.id', 'concat(users.firstname,\' \',users.lastname,\' [\',users.email,\']\')', 'users.phone', '\'\'', 'users.firstname, users.lastname, users.email', 'users.revoked = 0 AND users.portalaccess = 0', NULL, '9', '1', 1, NOW(), 1, NOW());
+INSERT INTO `smartsearches` (`uuid`, `name`, `fromclause`, `valuefield`, `displayfield`, `secondaryfield`, `classfield`, `searchfields`, `filterclause`, `rolefield`, `tabledefid`, `moduleid`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('smrt:ccc73fa4-6176-fad4-fbb1-5186d0edbdd1', 'Pick Active User', 'users', '`users`.`uuid`', 'CONCAT(users.firstname,\' \',users.lastname)', 'users.email', '\'\'', 'users.firstname, users.lastname', 'users.revoked=0 AND users.portalaccess = 0', NULL, 'tbld:afe6d297-b484-4f0b-57d4-1c39412e9dfb', 'mod:29873ee8-c12a-e3f6-9010-4cd24174ffd7', 1, NOW(), 1, NOW());
+INSERT INTO `smartsearches` (`uuid`, `name`, `fromclause`, `valuefield`, `displayfield`, `secondaryfield`, `classfield`, `searchfields`, `filterclause`, `rolefield`, `tabledefid`, `moduleid`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('smrt:855406d5-659d-c907-74a1-acfd3802fd73', 'Pick File', 'files', 'files.id', 'files.name', 'files.description', '\'\'', 'files.name, files.description', 'files.id!=0', 'files.roleid', 'tbld:80b4f38d-b957-bced-c0a0-ed08a0db6475', 'mod:29873ee8-c12a-e3f6-9010-4cd24174ffd7', 1, NOW(), 1, NOW());
+INSERT INTO `smartsearches` (`uuid`, `name`, `fromclause`, `valuefield`, `displayfield`, `secondaryfield`, `classfield`, `searchfields`, `filterclause`, `rolefield`, `tabledefid`, `moduleid`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('smrt:ed5b1d7f-b0fe-2088-f17c-47bfbe1ace25', 'Pick Active User Email', 'users', 'users.id', 'concat(users.firstname,\' \',users.lastname,\' [\',users.email,\']\')', 'users.phone', '\'\'', 'users.firstname, users.lastname, users.email', 'users.revoked = 0 AND users.portalaccess = 0', NULL, 'tbld:afe6d297-b484-4f0b-57d4-1c39412e9dfb', 'mod:29873ee8-c12a-e3f6-9010-4cd24174ffd7', 1, NOW(), 1, NOW());