summaryrefslogtreecommitdiff
path: root/sql/Pg-database.sql
AgeCommit message (Collapse)Author
2007-09-14Moving array aggregates into Pg-database.sqleinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1599 4979c152-3d1c-0410-bac9-87ea11338e46
2007-09-14Applying David Morar's db script fixeseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1598 4979c152-3d1c-0410-bac9-87ea11338e46
2007-09-14Adding discount_terms and threshold to entity_credit_accounteinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1594 4979c152-3d1c-0410-bac9-87ea11338e46
2007-09-13Adding dbobject/admin.pmaurynn_cmd
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1589 4979c152-3d1c-0410-bac9-87ea11338e46
2007-09-08Correcting customer/vendor viewseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1540 4979c152-3d1c-0410-bac9-87ea11338e46
2007-09-06Final menu change: Stored procedure for inserting menu items.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1517 4979c152-3d1c-0410-bac9-87ea11338e46
2007-09-01Moving employee table further up the creation script.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1492 4979c152-3d1c-0410-bac9-87ea11338e46
2007-09-01Fixing a few foreign keyseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1489 4979c152-3d1c-0410-bac9-87ea11338e46
2007-09-01Menu cross sections, used for example in handhelds, now work from an API ↵einhverfr
point of view git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1477 4979c152-3d1c-0410-bac9-87ea11338e46
2007-08-27Applying patch 1780397einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1468 4979c152-3d1c-0410-bac9-87ea11338e46
2007-08-09fixed primary key for entitylinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1455 4979c152-3d1c-0410-bac9-87ea11338e46
2007-08-06Addition of Vendor and Customer-specific save, get, and search functions in ↵aurynn_cmd
Pgsql stored procedures. Cleanup and modification of Employee.sql, to fit the new Entity framework, as well as the modifications to support trigram searching. Addition of customer.pl and vendor.pl scripts, to support new perl framework code, as well as .pm modules for the same. Some cleanup of Pg-database.sql. addition of note_class = 1 check on entity_note, removal of check id = 1. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1454 4979c152-3d1c-0410-bac9-87ea11338e46
2007-07-20Adding locking mechanism for discretionary lockseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1431 4979c152-3d1c-0410-bac9-87ea11338e46
2007-07-16Adding foreign key to acc_trans.trans_ideinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1406 4979c152-3d1c-0410-bac9-87ea11338e46
2007-07-16Finalizing data integrity control checks for global sequence for 1.3einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1405 4979c152-3d1c-0410-bac9-87ea11338e46
2007-07-15* Restoring global id sequence (until 1.4)einhverfr
* Dropping new not null constraints in legacy portions of db. * Updating Menu db tables. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1398 4979c152-3d1c-0410-bac9-87ea11338e46
2007-07-12Adding partial unique index on partnumber to prevent multiple active items ↵einhverfr
sharing the same part number git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1391 4979c152-3d1c-0410-bac9-87ea11338e46
2007-07-10Got rid of del_customer and del_vendor triggers and moved to ON DELETE ↵einhverfr
actions instead git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1379 4979c152-3d1c-0410-bac9-87ea11338e46
2007-07-10Merging Pg-central and Pg-database fileseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1378 4979c152-3d1c-0410-bac9-87ea11338e46
2007-07-10Changes to the comments on entity_metadata, which does not exist, to refer ↵aurynn_cmd
to entity_credit account. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1374 4979c152-3d1c-0410-bac9-87ea11338e46
2007-07-10Fixes Add Vendor, to correctly work with the new entity_credit_account ↵aurynn_cmd
table, in place of the customer/vendor tables. Removes the Vendor and Customer tables, replacing them with entity_credit_account (previously entity_metadata) and Vendor and Customer as a view, mimicking the original Vendor and Customer tables. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1373 4979c152-3d1c-0410-bac9-87ea11338e46
2007-07-10Fixing menu_attributes so that it does not roll back the functioneinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1369 4979c152-3d1c-0410-bac9-87ea11338e46
2007-07-10Moving commit to end of fileeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1368 4979c152-3d1c-0410-bac9-87ea11338e46
2007-07-09Moving menu over to new template and stored proc model. THe menu ↵einhverfr
expansion/contraction doesn't quite work yet and there needs to be some additional help on the CSS/Javascript side of this. Also, this makes a few changes to the lower-level Perl API. Classes calling LedgerSMB::call_procedure() directly may need some editing but I believe I got them all. These changes were necessary to accomodate zero-argument stored procedures. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1355 4979c152-3d1c-0410-bac9-87ea11338e46
2007-07-05fix entity/entity_class so you aren't limited to only one customer everlinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1351 4979c152-3d1c-0410-bac9-87ea11338e46
2007-06-27changed inventory to track employee table, instead of entity tablelinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1340 4979c152-3d1c-0410-bac9-87ea11338e46
2007-06-27fixed inventory model to force employeelinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1339 4979c152-3d1c-0410-bac9-87ea11338e46
2007-06-21minor date style changelinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1296 4979c152-3d1c-0410-bac9-87ea11338e46
2007-06-21added tracking capability to location. When implemented in 1.3, locations ↵linuxpoet
should not be deleted. Instead they are marked active/inactive and tracked git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1295 4979c152-3d1c-0410-bac9-87ea11338e46
2007-06-19man that was more work that it should of been. there is no employee(id), ↵linuxpoet
vendor(id) anymore. Refer to key checks. Also fixed rules associated to compile, but may not be correct git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1288 4979c152-3d1c-0410-bac9-87ea11338e46
2007-06-19further cleaning of batchlinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1287 4979c152-3d1c-0410-bac9-87ea11338e46
2007-06-19fixed some issues with batch tableslinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1286 4979c152-3d1c-0410-bac9-87ea11338e46
2007-06-19Added ar voucher type.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1283 4979c152-3d1c-0410-bac9-87ea11338e46
2007-06-19Added on-hold flags for invoices and voucher information to db schema.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1282 4979c152-3d1c-0410-bac9-87ea11338e46
2007-06-10added referential mapping for noteslinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1261 4979c152-3d1c-0410-bac9-87ea11338e46
2007-06-07fix uniqueness on entity nameslinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1260 4979c152-3d1c-0410-bac9-87ea11338e46
2007-06-07fixed default of current_date to now()linuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1259 4979c152-3d1c-0410-bac9-87ea11338e46
2007-06-07first run of new notes system, includes tsearch2 full text indexinglinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1258 4979c152-3d1c-0410-bac9-87ea11338e46
2007-06-07added documentationm for tsearch2 requirementlinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1257 4979c152-3d1c-0410-bac9-87ea11338e46
2007-06-05added created columns for person, company and entitylinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1256 4979c152-3d1c-0410-bac9-87ea11338e46
2007-06-04added constraint to id,location_classlinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1254 4979c152-3d1c-0410-bac9-87ea11338e46
2007-06-04More trunk fixeseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1253 4979c152-3d1c-0410-bac9-87ea11338e46
2007-06-01fix for authoritative addresses by adding location_classlinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1247 4979c152-3d1c-0410-bac9-87ea11338e46
2007-05-29changed employee_id to person(id) where needed, plus removed a couple of ↵linuxpoet
employee_id as they are now deprecated git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1246 4979c152-3d1c-0410-bac9-87ea11338e46
2007-05-29created relationships between contact_info and locationslinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1244 4979c152-3d1c-0410-bac9-87ea11338e46
2007-05-29forward testlinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1243 4979c152-3d1c-0410-bac9-87ea11338e46
2007-05-29added entity relationship between persons and companies. This is for Joshua ↵linuxpoet
Drake is related to Chris Travers who is Related to Metatrontech git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1242 4979c152-3d1c-0410-bac9-87ea11338e46
2007-05-23build out person->entity relationshiplinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1238 4979c152-3d1c-0410-bac9-87ea11338e46
2007-05-23added mailcode to locationlinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1237 4979c152-3d1c-0410-bac9-87ea11338e46
2007-05-22add primary key to entity_class_to_entitylinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1236 4979c152-3d1c-0410-bac9-87ea11338e46