summaryrefslogtreecommitdiff
path: root/sql/Pg-database.sql
AgeCommit message (Collapse)Author
2008-11-25undoing accidental deletion to good chunk of Pg-database.sqleinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2421 4979c152-3d1c-0410-bac9-87ea11338e46
2008-11-21Committing David Mora's single payment interface enhancementseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2410 4979c152-3d1c-0410-bac9-87ea11338e46
2008-11-07Changing primary key for eca_to_location to make this testable.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2383 4979c152-3d1c-0410-bac9-87ea11338e46
2008-10-28Allowing multiple payment vouchers per batch per invoice. Test cases addedeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2380 4979c152-3d1c-0410-bac9-87ea11338e46
2008-10-10Adding draft menu itemeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2365 4979c152-3d1c-0410-bac9-87ea11338e46
2008-09-25Saving locations and contacts to a user now works as expected.aurynn_cmd
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2342 4979c152-3d1c-0410-bac9-87ea11338e46
2008-09-18Adding unit tests to Session.sql and correcting logic that causes it to fail.einhverfr
Adding a 90 min timeout to the sessions by default git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2328 4979c152-3d1c-0410-bac9-87ea11338e46
2008-09-12Added description field to customer/vendor generation.einhverfr
Corrected entity credit account autogenerated number sequences. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2321 4979c152-3d1c-0410-bac9-87ea11338e46
2008-08-22Correcting load issues with Pg-database.sqleinhverfr
Also adding NOT NULL constraints to ar.entity_credit_account and ap.entity_credit_account git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2299 4979c152-3d1c-0410-bac9-87ea11338e46
2008-08-21 * Minor fixes to customer/vendor entryeinhverfr
* Fixes to customer search functionality git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2295 4979c152-3d1c-0410-bac9-87ea11338e46
2008-08-19Enhancements to notes and entity management:einhverfr
* Default workflow only allows addresses connected to entity_credit_accounts * Default workflow only allows contact info conntected to entity_credit_accounts * Notes now display the Pgsql user that created them * Notes are now displayed with linebreaks properly showing up. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2282 4979c152-3d1c-0410-bac9-87ea11338e46
2008-08-19Adding eca to bank account linkeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2281 4979c152-3d1c-0410-bac9-87ea11338e46
2008-08-12Correcting load errorseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2254 4979c152-3d1c-0410-bac9-87ea11338e46
2008-08-12 * Correcting discount display discrepancies in multiple payment detail screeneinhverfr
* Merging entity_credit_account mapped functions to SVN main * Adding schema entries for entity_credit_account mappings git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2253 4979c152-3d1c-0410-bac9-87ea11338e46
2008-08-12Undoing svn commit rev 2250einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2251 4979c152-3d1c-0410-bac9-87ea11338e46
2008-08-12Merging fix for bug 1974974einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2250 4979c152-3d1c-0410-bac9-87ea11338e46
2008-07-22Added format option to LedgerSMB::format_amounteinhverfr
Added batch information options for check template Added batch default_date field Corrected issues with payment batches not preserving post dates when adding vouchers to existing batch. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2219 4979c152-3d1c-0410-bac9-87ea11338e46
2008-07-07Correcting svn conflicteinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2189 4979c152-3d1c-0410-bac9-87ea11338e46
2008-07-04Committing David Mora's single payment updateseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2185 4979c152-3d1c-0410-bac9-87ea11338e46
2008-06-30Adding the reconciliation SQL stuff. Testing my SVN interface.aurynn_cmd
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2177 4979c152-3d1c-0410-bac9-87ea11338e46
2008-05-25Fixes to per-transaction separation of dutieseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2155 4979c152-3d1c-0410-bac9-87ea11338e46
2008-05-17Correcting all load errors for all working scripts on Pg 8.1.x and above.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2150 4979c152-3d1c-0410-bac9-87ea11338e46
2008-05-12Merging in fix for 1870069einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2137 4979c152-3d1c-0410-bac9-87ea11338e46
2008-05-09Adding ability to force closed transactions (via db only) to prevent them ↵einhverfr
from showing up on the outstanding report. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2131 4979c152-3d1c-0410-bac9-87ea11338e46
2008-04-04Adding infrastructure for form trackingeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2125 4979c152-3d1c-0410-bac9-87ea11338e46
2008-02-22Adding index on acc_trans(voucher_id)einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2077 4979c152-3d1c-0410-bac9-87ea11338e46
2008-01-21Attaching Jeff Kowalzic's SQL cleanup patcheinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2058 4979c152-3d1c-0410-bac9-87ea11338e46
2008-01-12Fixing (in Pg-database) 1771834, inventory lost when converting order to invoiceeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2040 4979c152-3d1c-0410-bac9-87ea11338e46
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
generated by cgit v1.2.3 (git 2.39.1) at 2024-06-29 07:59:40 +0000