Changeset 397
- Timestamp:
- 05/15/08 12:39:32
- Files:
-
- trunk/phpbms/install/modules.sql (modified) (1 diff)
- trunk/phpbms/modules/bms/install/modules.sql (modified) (1 diff)
- trunk/phpbms/modules/bms/install/updatev0.96.sql (modified) (1 diff)
- trunk/phpbms/modules/recurringinvoices/install/modules.sql (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
- Modified
- Copied
- Moved
trunk/phpbms/install/modules.sql
r375 r397 1 INSERT INTO modules VALUES (1,'Base','base','The basic phpBMS framkework. This is the minimum module required in order for the web applicatoin to work.','0.9 4');1 INSERT INTO modules VALUES (1,'Base','base','The basic phpBMS framkework. This is the minimum module required in order for the web applicatoin to work.','0.96'); trunk/phpbms/modules/bms/install/modules.sql
r375 r397 1 INSERT INTO modules VALUES (2,'BMS Module','bms','The Business Magagement functionality of phpBMS. This module includes clients/propsetcs, quote/order/invoice, and products sections.','0.9 4');1 INSERT INTO modules VALUES (2,'BMS Module','bms','The Business Magagement functionality of phpBMS. This module includes clients/propsetcs, quote/order/invoice, and products sections.','0.96'); trunk/phpbms/modules/bms/install/updatev0.96.sql
r386 r397 1 1 CREATE TABLE `addresses` (`id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, `title` VARCHAR(128), `shiptoname` VARCHAR(128), `address1` VARCHAR(128), `address2` VARCHAR(128), `city` VARCHAR(64), `state` VARCHAR(20), `postalcode` VARCHAR(15), `country` VARCHAR(64), `phone` VARCHAR(25), `email` VARCHAR(128), `notes` TEXT, `createdby` INTEGER UNSIGNED NOT NULL, `creationdate` DATETIME NOT NULL, `modifiedby` INTEGER UNSIGNED, `modifieddate` TIMESTAMP, PRIMARY KEY(`id`)); 2 2 CREATE TABLE `addresstorecord` (`id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, `tabledefid` INTEGER UNSIGNED NOT NULL, `recordid` INTEGER UNSIGNED NOT NULL, `addressid` INTEGER UNSIGNED NOT NULL, `defaultshipto` TINYINT UNSIGNED NOT NULL DEFAULT 0, `primary` TINYINT UNSIGNED NOT NULL DEFAULT 0, `createdby` INTEGER UNSIGNED NOT NULL, `creationdate` DATETIME NOT NULL, `modifiedby` INTEGER UNSIGNED, `modifieddate` TIMESTAMP, PRIMARY KEY(`id`)); 3 ALTER TABLE `invoices` DROP COLUMN `status`,ADD COLUMN `shiptoname` VARCHAR(128), ADD COLUMN `shiptoaddress1` VARCHAR(128), ADD COLUMN `shiptoaddress2` VARCHAR(128),ADD COLUMN `shiptocity` VARCHAR(64), ADD COLUMN `shiptostate` VARCHAR(20), ADD COLUMN `shiptopostalcode` VARCHAR(15), ADD COLUMN `shiptocountry` VARCHAR(64), ADD COLUMN `billingaddressid` INTEGER, ADD COLUMN `shiptoaddressid` INTEGER, ADD COLUMN `shiptosameasbilling` TINYINT UNSIGNED NOT NULL DEFAULT 0;3 ALTER TABLE `invoices` ADD COLUMN `shiptoname` VARCHAR(128), ADD COLUMN `shiptoaddress1` VARCHAR(128), ADD COLUMN `shiptoaddress2` VARCHAR(128),ADD COLUMN `shiptocity` VARCHAR(64), ADD COLUMN `shiptostate` VARCHAR(20), ADD COLUMN `shiptopostalcode` VARCHAR(15), ADD COLUMN `shiptocountry` VARCHAR(64), ADD COLUMN `billingaddressid` INTEGER, ADD COLUMN `shiptoaddressid` INTEGER, ADD COLUMN `shiptosameasbilling` TINYINT UNSIGNED NOT NULL DEFAULT 0; 4 4 INSERT INTO `settings` (`name`, `value`) VALUES ('clear_payment_on_invoice','1'); 5 5 INSERT INTO `smartsearches` (`id`, `name`, `fromclause`, `valuefield`, `displayfield`, `secondaryfield`, `classfield`, `searchfields`, `filterclause`, `rolefield`, `tabledefid`, `moduleid`, `createdby`, `creationdate`, `modifiedby`, `modifieddate`) VALUES ('1', 'Pick Exisiting Client Address', '(clients INNER JOIN addresstorecord ON clients.id = addresstorecord.recordid AND addresstorecord.tabledefid = 2) INNER JOIN addresses ON addresstorecord.addressid = addresses.id', 'addresses.id', 'concat(if(clients.lastname!=\"\",concat(clients.lastname,\", \",clients.firstname,if(clients.company!=\"\",concat(\" (\",clients.company,\")\"),\"\")),clients.company), if(addresses.title != \"\",concat(\" [\", addresses.title, \"]\"),\"\"))', 'CONCAT(addresses.address1,if(addresses.address2 != \'\',concat(\'[br]\', addresses.address2),\'\'),if(addresses.city != \'\',concat(\'[br]\',addresses.city,\', \',if(addresses.state != \'\',addresses.state, \'\'),\' \',if(addresses.postalcode != \'\', addresses.postalcode, \'\')),\'\'),if(addresses.country != \'\',concat(\'[br]\',addresses.country),\'\'))', 'if(addresstorecord.primary,\'primary\',\'\')', 'clients.firstname, clients.lastname, clients.company, addresses.title, addresses.address1', 'clients.inactive=0', NULL, '306', '2', 1, NOW(), 1, NOW()); trunk/phpbms/modules/recurringinvoices/install/modules.sql
r285 r397 1 INSERT INTO modules VALUES (200,'Recurring Invoices','recurringinvoices','This module adds the ability to repeat invoices on a scheduled basis.','1.0 ');1 INSERT INTO modules VALUES (200,'Recurring Invoices','recurringinvoices','This module adds the ability to repeat invoices on a scheduled basis.','1.02');
