summaryrefslogtreecommitdiff
path: root/sql
AgeCommit message (Expand)Author
2007-09-14Removing obsolete user creation stored procs and insertseinhverfr
2007-09-14Moving array aggregates into Pg-database.sqleinhverfr
2007-09-14Applying David Morar's db script fixeseinhverfr
2007-09-14Documenting Payment.sql functionseinhverfr
2007-09-14Adding multi-vendor searches now require the account number for the AR/AP acc...einhverfr
2007-09-14Adding Payment search stored procedures.einhverfr
2007-09-14Adding discount_terms and threshold to entity_credit_accounteinhverfr
2007-09-13Adding dbobject/admin.pmaurynn_cmd
2007-09-12Added sequences, etc. Roles should be functional with these permissionseinhverfr
2007-09-12More additions to role systemeinhverfr
2007-09-12Goods and Services permissions now addedeinhverfr
2007-09-12Correcting validation issues in frameseteinhverfr
2007-09-11More permissions material added to the Roleseinhverfr
2007-09-11Cleaning up lsmb-request slightlyeinhverfr
2007-09-11Adding some permission grantseinhverfr
2007-09-11Full tree in place. Now to add permission grantseinhverfr
2007-09-10Creation of next-gen admin.pl, admin.pm, and admin.sql systems.aurynn_cmd
2007-09-08Correcting customer/vendor viewseinhverfr
2007-09-08Adding some SQL queries for reports that are being moved out of the old codeb...einhverfr
2007-09-06Final menu change: Stored procedure for inserting menu items.einhverfr
2007-09-06Adding date format conversion to upgrade script.einhverfr
2007-09-01Moving employee table further up the creation script.einhverfr
2007-09-01Fixing a few foreign keyseinhverfr
2007-09-01Menu cross sections, used for example in handhelds, now work from an API poin...einhverfr
2007-08-27Applying patch 1780397einhverfr
2007-08-09fixed primary key for entitylinuxpoet
2007-08-06Addition of Vendor and Customer-specific save, get, and search functions in P...aurynn_cmd
2007-07-24Adds the missing SELECT INTO statements for the correct_bank_charge and corre...aurynn_cmd
2007-07-20Adding locking mechanism for discretionary lockseinhverfr
2007-07-16Adding foreign key to acc_trans.trans_ideinhverfr
2007-07-16Finalizing data integrity control checks for global sequence for 1.3einhverfr
2007-07-15* Restoring global id sequence (until 1.4)einhverfr
2007-07-12Adding partial unique index on partnumber to prevent multiple active items sh...einhverfr
2007-07-10Got rid of del_customer and del_vendor triggers and moved to ON DELETE action...einhverfr
2007-07-10Merging Pg-central and Pg-database fileseinhverfr
2007-07-10Changes to the comments on entity_metadata, which does not exist, to refer to...aurynn_cmd
2007-07-10Fixes Add Vendor, to correctly work with the new entity_credit_account table,...aurynn_cmd
2007-07-10Fixing menu_attributes so that it does not roll back the functioneinhverfr
2007-07-10Moving commit to end of fileeinhverfr
2007-07-09Moving menu over to new template and stored proc model. THe menu expansion/c...einhverfr
2007-07-08Menu db schema added for revieweinhverfr
2007-07-05fix entity/entity_class so you aren't limited to only one customer everlinuxpoet
2007-06-27changed inventory to track employee table, instead of entity tablelinuxpoet
2007-06-27fixed inventory model to force employeelinuxpoet
2007-06-22Added version of Aurynn's reconciliation logiceinhverfr
2007-06-21minor date style changelinuxpoet
2007-06-21added tracking capability to location. When implemented in 1.3, locations sho...linuxpoet
2007-06-19man that was more work that it should of been. there is no employee(id), vend...linuxpoet
2007-06-19further cleaning of batchlinuxpoet
2007-06-19fixed some issues with batch tableslinuxpoet