summaryrefslogtreecommitdiff
path: root/sql/Pg-database.sql
AgeCommit message (Collapse)Author
2008-01-10Menu fixes to Pg-database.sqleinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2034 4979c152-3d1c-0410-bac9-87ea11338e46
2008-01-09Correcting trial balance and gl report not to pull unapproved transactionseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2031 4979c152-3d1c-0410-bac9-87ea11338e46
2008-01-04New tables by David Mora for payment trackingeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2027 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-29Adding inventory adjustment stored procedureseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2018 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-28Adding description field to batcheinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2010 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-27Adding missing voucher_id field to Pg-database.sqleinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2008 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-12Basic outline of Job Queue Systemeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1975 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-11More db fixeseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1974 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-11Minor db fixeseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1973 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-11Minor db fixeseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1972 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-08More customer/vendor search enhancementseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1966 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-29Adjusting the schema to account for recurring(print|email) and status havingtetragon
multicolumn primary keys git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1922 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-29Removing duplicate drawer openeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1917 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-29Correcting more Payment Problemseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1914 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-28More Employee fixeseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1912 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-27Fixing wrong index on location tableeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1911 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-27AR/AP Breakage Fixedeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1909 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-25Employee creation/management is now on new system. May need some additional ↵einhverfr
tweaking git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1908 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-25Few more fixes for vendor stuff.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1904 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-25Contact management postfactoringeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1899 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-18More customer/vendor screen/stored proc fixes. Note that since locations ↵einhverfr
are mapped many<->many with companies and persons, I have moved the location class foreign key into the mapping tables. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1879 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-18Pass 1 of QA committed for Reconciliation.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1876 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-17removed all errors loading Roles.sqleinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1872 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-17Commiting David Mora's payment codeeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1871 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-16fix the location table... I would like to know who thought check (foo ↵linuxpoet
'regex' NOT NULL) was going to work... git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1870 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-09Fixing db schema field names to match stored procedures (since those names ↵einhverfr
are clearer anyway) git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1861 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-09Province (or state) is now distinct from city in terms of db stroageeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1860 4979c152-3d1c-0410-bac9-87ea11338e46
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