summaryrefslogtreecommitdiff
path: root/sql
AgeCommit message (Collapse)Author
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
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-12-08Removing sql/legacy-- will package new download from the files in branches/1.2einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1964 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-07Fixing some payment issues.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1961 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-07New templates added for contact search and invoice/ordereinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1957 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-06Misc fixeseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1955 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-04More Roles fixeseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1942 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-02Correcting behavior of session timeout to release locks and create new session.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1928 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-30Separated out multiple payment interface from new payment interface. Still ↵einhverfr
not working, but almost there git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1926 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