summaryrefslogtreecommitdiff
path: root/sql/Pg-database.sql
AgeCommit message (Expand)Author
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-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-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-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
2007-06-19Added ar voucher type.einhverfr
2007-06-19Added on-hold flags for invoices and voucher information to db schema.einhverfr
2007-06-10added referential mapping for noteslinuxpoet
2007-06-07fix uniqueness on entity nameslinuxpoet
2007-06-07fixed default of current_date to now()linuxpoet
2007-06-07first run of new notes system, includes tsearch2 full text indexinglinuxpoet
2007-06-07added documentationm for tsearch2 requirementlinuxpoet
2007-06-05added created columns for person, company and entitylinuxpoet
2007-06-04added constraint to id,location_classlinuxpoet
2007-06-04More trunk fixeseinhverfr
2007-06-01fix for authoritative addresses by adding location_classlinuxpoet
2007-05-29changed employee_id to person(id) where needed, plus removed a couple of empl...linuxpoet
2007-05-29created relationships between contact_info and locationslinuxpoet
2007-05-29forward testlinuxpoet
2007-05-29added entity relationship between persons and companies. This is for Joshua D...linuxpoet
2007-05-23build out person->entity relationshiplinuxpoet
2007-05-23added mailcode to locationlinuxpoet
2007-05-22add primary key to entity_class_to_entitylinuxpoet
2007-05-22Created entity to class relationshiplinuxpoet
2007-05-22Created authoritative classes for entity_classlinuxpoet
2007-05-20fixed employee indexeslinuxpoet
2007-05-20fix some index creation where vendor and customer are now meta tableslinuxpoet
2007-05-20a couple more fixes... noted that this also breaks some of the stored procslinuxpoet
2007-05-20fixed broken relationships in new entity and some spelling errors, now need t...linuxpoet