Changeset 714 for trunk/phpbms/modules/recurringinvoices/install/updatev1.01.sql

Timestamp:

01/05/10 11:56:12 (2 years ago)

Author:

brieb

Message:

• Fixed conversion of client addresses
• Fixed widgets and menu tabledefs not having module uuid set correctly
• Correctly display module db / current version on update screen

Files:

• trunk/phpbms/modules/recurringinvoices/install/updatev1.01.sql (modified) (1 diff)

trunk/phpbms/modules/recurringinvoices/install/updatev1.01.sql

@@ -1 +1 @@
 INSERT INTO `menu` (`id`, `name`, `link`, `parentid`, `displayorder`, `createdby`, `modifiedby`, `creationdate`, `modifieddate`, `roleid`) VALUES (521, 'Recurring Invoices','search.php?id=400',204,17,1,1,NOW(),NOW(),30);
-INSERT INTO `tableoptions` (`tabledefid`, `name`, `option`, `othercommand`, `roleid`, `displayorder`) VALUES ('edit', '1', '0', '0', '0');
-INSERT INTO `tableoptions` (`tabledefid`, `name`, `option`, `othercommand`, `roleid`, `displayorder`) VALUES ('new', '0', '0', '0', '0');
-INSERT INTO `tableoptions` (`tabledefid`, `name`, `option`, `othercommand`, `roleid`, `displayorder`) VALUES ('select', '1', '0', '0', '0');
-INSERT INTO `tableoptions` (`tabledefid`, `name`, `option`, `othercommand`, `roleid`, `displayorder`) VALUES ('printex', '0', '0', '0', '0');
+INSERT INTO `tableoptions` (`tabledefid`, `name`, `option`, `othercommand`, `roleid`, `displayorder`) VALUES ('400','edit', '1', '0', '0', '0');
+INSERT INTO `tableoptions` (`tabledefid`, `name`, `option`, `othercommand`, `roleid`, `displayorder`) VALUES ('400','new', '0', '0', '0', '0');
+INSERT INTO `tableoptions` (`tabledefid`, `name`, `option`, `othercommand`, `roleid`, `displayorder`) VALUES ('400','select', '1', '0', '0', '0');
+INSERT INTO `tableoptions` (`tabledefid`, `name`, `option`, `othercommand`, `roleid`, `displayorder`) VALUES ('400','printex', '0', '0', '0', '0');