summaryrefslogtreecommitdiff
path: root/sql/Pg-database.sql
AgeCommit message (Collapse)Author
2007-10-31Converting the two left-over float4 fields to numerictetragon
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1832 4979c152-3d1c-0410-bac9-87ea11338e46
2007-10-18Pg-database now loads again. employee view is disabled for now.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1785 4979c152-3d1c-0410-bac9-87ea11338e46
2007-10-18POS Fixes:einhverfr
1: Drawer opening now uses correct printer designation 2: Change issued is now entered with correct memo field. 3: Closing tell report works as advertised git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1782 4979c152-3d1c-0410-bac9-87ea11338e46
2007-10-17Serious updates to the Admin controller;aurynn_cmd
Creation of a User controller/object - I would like to use this to save/load roles, as well. Creation of Person stored procs, Entity stored procs. Serious updates to the employee stored procs. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1778 4979c152-3d1c-0410-bac9-87ea11338e46
2007-10-15Fixing db building issue.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1760 4979c152-3d1c-0410-bac9-87ea11338e46
2007-10-14Adjustments to the menu SQL to correct the menu structure and renderingtetragon
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1753 4979c152-3d1c-0410-bac9-87ea11338e46
2007-10-09User::fetch_config now works, and there are some other auth fixes here tooeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1730 4979c152-3d1c-0410-bac9-87ea11338e46
2007-10-08Breaking user_preference into a separate tableeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1720 4979c152-3d1c-0410-bac9-87ea11338e46
2007-10-07A few authentication fixeseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1715 4979c152-3d1c-0410-bac9-87ea11338e46
2007-10-07Login is still broken. However, a lot of progress has been made. THis also ↵einhverfr
includes the COGS changes made since 1.2.8 git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1712 4979c152-3d1c-0410-bac9-87ea11338e46
2007-10-03Cleaning up scripts/menu.pl slightly.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1694 4979c152-3d1c-0410-bac9-87ea11338e46
2007-09-14Removing obsolete user creation stored procs and insertseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1600 4979c152-3d1c-0410-bac9-87ea11338e46
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