summaryrefslogtreecommitdiff
path: root/sql
AgeCommit message (Collapse)Author
2008-03-21Updating Roles.sql to allow hyphens in db nameseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2112 4979c152-3d1c-0410-bac9-87ea11338e46
2008-03-21Correcting comment syntax in Payment.sqleinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2111 4979c152-3d1c-0410-bac9-87ea11338e46
2008-03-21Correcting problem with batch posts only posting some payments.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2110 4979c152-3d1c-0410-bac9-87ea11338e46
2008-03-11Correcting two issues with Voucher.sql which prevent loading.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2108 4979c152-3d1c-0410-bac9-87ea11338e46
2008-03-11Updating READMEeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2107 4979c152-3d1c-0410-bac9-87ea11338e46
2008-03-11Adding roles for voucher/batch deletion. Moving functions to SECURITY ↵einhverfr
DEFINER to allow for more granular delete permissions. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2106 4979c152-3d1c-0410-bac9-87ea11338e46
2008-03-08Correcting ambiguous join in payment_get_all_contact_invoiceseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2102 4979c152-3d1c-0410-bac9-87ea11338e46
2008-03-04Adding David Mora's single-payment interface patcheseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2098 4979c152-3d1c-0410-bac9-87ea11338e46
2008-03-03Correcting all voucher/ batch reporting discrepencieseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2097 4979c152-3d1c-0410-bac9-87ea11338e46
2008-02-28Moving Setting.sql to standard (if hard to read) escaping syntaxeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2096 4979c152-3d1c-0410-bac9-87ea11338e46
2008-02-28Updating README to mention that Setting.sql needs to be loaded.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2095 4979c152-3d1c-0410-bac9-87ea11338e46
2008-02-27Committing customer/vendor address save fixeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2093 4979c152-3d1c-0410-bac9-87ea11338e46
2008-02-27Removing notes saving from initial credit account insert routine.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2089 4979c152-3d1c-0410-bac9-87ea11338e46
2008-02-27Adding role grant to note_id_seqeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2088 4979c152-3d1c-0410-bac9-87ea11338e46
2008-02-24Adding explicit cast to md5() so it will work on Pg 8.3einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2085 4979c152-3d1c-0410-bac9-87ea11338e46
2008-02-24Updating the Candian GST ratetetragon
Switching away from the use of backslashes to quote quotes git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2083 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-02-20Changing batch search to handle null created_by valueseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2074 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-17Adding new payment posting routine for single payments from David Moraeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2049 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-08Including missing Session.sql in Readmeeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2030 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-30Moving Isvan's basic Hungarian chart to Minimaleinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2022 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-30Adding Istvan's Hungarian chartseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2021 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-28Correcting join in payment select for single paymenteinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2016 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-27Correcting typo in Roles.sqleinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2007 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-26Commenting out bogus comment for payment_post function.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2006 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-26Fixing broken Account.sqleinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2005 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-26Fixing broken Account.sqleinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2004 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-26Removing as_array and compound_array since they are part of Pg-databaseeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2003 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-26Applying David Mora's Patch to Location.sqleinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2002 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-26Applying David Mora's patch to Account.sqleinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2001 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-21Documentation changes for installation order of scripts.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1999 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-21Correcting header error when creating dataseteinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1991 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-21Adding ability to delete vouchers from batcheinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1989 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-21More batch, vendor, and payment reversal fixeseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1987 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-20Voucher and Payment Enhancements and fixeseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1986 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-20More contact, payment, voucher fixes/enhancementseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1984 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-19Some bulk payment enhancementseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1983 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-19More batch enhancementseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1982 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-18Correcting join projection errors in batch searcheinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1981 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-17Batch enhancementseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1980 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-13Added a routine to sanitize the CGI variables. Needed for some CSV exports ↵einhverfr
routines. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1978 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-13More payment fixeseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1976 4979c152-3d1c-0410-bac9-87ea11338e46