summaryrefslogtreecommitdiff
path: root/sql
AgeCommit message (Collapse)Author
2008-08-17Correcting issue with ar_ap_summary_data.sqleinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@2276 4979c152-3d1c-0410-bac9-87ea11338e46
2008-08-16Committing patch 1928336, to transactions_foreign_key_fix.sqleinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@2272 4979c152-3d1c-0410-bac9-87ea11338e46
2008-08-13Correcting bug 1987545: upgrade script creates sequence with wrong nameeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@2259 4979c152-3d1c-0410-bac9-87ea11338e46
2008-08-13Committing patch 1906081: Making Czech COA UTF-8-friendly from Dr. Vladimir ↵einhverfr
Botka git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@2257 4979c152-3d1c-0410-bac9-87ea11338e46
2008-08-12upper casing some SQL statementseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@2243 4979c152-3d1c-0410-bac9-87ea11338e46
2008-05-14better approach to handling negative amounts on the fix.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@2145 4979c152-3d1c-0410-bac9-87ea11338e46
2008-05-14fixed ar_ap_summary_fix again.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@2144 4979c152-3d1c-0410-bac9-87ea11338e46
2008-05-14ar_ap_summary_fix now handles transactions with negative ammounts properly.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@2143 4979c152-3d1c-0410-bac9-87ea11338e46
2008-05-14Renaming fix for 1.2.14einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@2142 4979c152-3d1c-0410-bac9-87ea11338e46
2008-05-12Adding datepaid fixes to ar/ap transactions fix. will rename next commit.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@2138 4979c152-3d1c-0410-bac9-87ea11338e46
2008-05-12Final version of amount_blank_ap_transactions.sql fixeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@2135 4979c152-3d1c-0410-bac9-87ea11338e46
2008-05-12Adding fix for amount blank on AR/AP transaction reporteinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@2134 4979c152-3d1c-0410-bac9-87ea11338e46
2008-02-24Updating GST rate to current valuetetragon
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@2084 4979c152-3d1c-0410-bac9-87ea11338e46
2008-01-28fix syntax error in COMMENT ON INDEX statementtetragon
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@2062 4979c152-3d1c-0410-bac9-87ea11338e46
2008-01-21Adding fix for double-incrementing id sequenceeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@2059 4979c152-3d1c-0410-bac9-87ea11338e46
2008-01-12Adding fix for 1771834, inventory lost when converting order to invoiceeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@2039 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-28Adding a fix script for the primary key to the tax tabletetragon
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@2011 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-29Add in the changes for the status tabletetragon
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@1919 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-29Adding the fixes for the primary key on the recurring email and print tablestetragon
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@1918 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-24Adding hotfix for 1819483einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@1896 4979c152-3d1c-0410-bac9-87ea11338e46
2007-09-30Fixing 1804712 and some related issuestetragon
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@1677 4979c152-3d1c-0410-bac9-87ea11338e46
2007-09-22Spelling correctionstetragon
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@1647 4979c152-3d1c-0410-bac9-87ea11338e46
2007-09-06Adding date format conversion to upgrade script.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@1515 4979c152-3d1c-0410-bac9-87ea11338e46
2007-05-08Translating stocks->inventaire in Quebec CoAeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@1167 4979c152-3d1c-0410-bac9-87ea11338e46
2007-05-08Adding Anarcat's patches to the Canadian French COAeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@1162 4979c152-3d1c-0410-bac9-87ea11338e46
2007-05-06Removing the tax primary key from the upgrade scripteinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@1128 4979c152-3d1c-0410-bac9-87ea11338e46
2007-04-24Updating version strings following release of 1.2.4. Also adding fix for ↵einhverfr
partsgroup handling. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@1097 4979c152-3d1c-0410-bac9-87ea11338e46
2007-04-13fix avgcost() and lastcost() to not use floatlinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@1071 4979c152-3d1c-0410-bac9-87ea11338e46
2007-04-12Formatting with Perltidyeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@1068 4979c152-3d1c-0410-bac9-87ea11338e46
2007-04-12Fixing wrong data type in invoice.qtyeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@1065 4979c152-3d1c-0410-bac9-87ea11338e46
2007-03-20Renaming ledger-smb.conf to ledgersmb.conftetragon
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@952 4979c152-3d1c-0410-bac9-87ea11338e46
2007-03-17Adding provisions in upgrade script for duplicate orderitems (id)'s.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@925 4979c152-3d1c-0410-bac9-87ea11338e46
2007-02-06Undoing broken changeseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@798 4979c152-3d1c-0410-bac9-87ea11338e46
2007-02-06Accepting LBMoore's upgrade fixeseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@793 4979c152-3d1c-0410-bac9-87ea11338e46
2006-12-06Applying Mads' patch to upgrade scriptseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@734 4979c152-3d1c-0410-bac9-87ea11338e46
2006-11-22Adjust del_exchangerate to work with current defaults table layouttetragon
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@682 4979c152-3d1c-0410-bac9-87ea11338e46
2006-11-21Moving to 1.2: Adding transaction_id. This will require an update to the ↵christopherm
session table, please drop table session and recreate with the create statement in Pg-central.sql. This is an anti-hijacking tool and something that will prevent users from double posting data. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@675 4979c152-3d1c-0410-bac9-87ea11338e46
2006-11-18Fix SQL syntaxtetragon
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@656 4979c152-3d1c-0410-bac9-87ea11338e46
2006-11-17Deleting primary key on old defaults tableeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@649 4979c152-3d1c-0410-bac9-87ea11338e46
2006-11-17Adding crypted_password field :-)einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@648 4979c152-3d1c-0410-bac9-87ea11338e46
2006-11-17Fixing braindead issues in upgrade scripteinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@647 4979c152-3d1c-0410-bac9-87ea11338e46
2006-11-15The admin password will now only be md5() in the databasechristopherm
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@624 4979c152-3d1c-0410-bac9-87ea11338e46
2006-11-15Removing UTF8 named copies of the Chinese sql fileschristopherm
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@614 4979c152-3d1c-0410-bac9-87ea11338e46
2006-11-15renaming Columbian files to remove utf8 from their nameschristopherm
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@613 4979c152-3d1c-0410-bac9-87ea11338e46
2006-11-15deleting old fileschristopherm
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@612 4979c152-3d1c-0410-bac9-87ea11338e46
2006-11-15Making sql files internally single transactionseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@611 4979c152-3d1c-0410-bac9-87ea11338e46
2006-11-15making all files UTF8, removing UTF8 from their nameschristopherm
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@610 4979c152-3d1c-0410-bac9-87ea11338e46
2006-11-15deleting old 8859-1 versionchristopherm
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@609 4979c152-3d1c-0410-bac9-87ea11338e46
2006-11-15deleting old 8859-1 versionchristopherm
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@608 4979c152-3d1c-0410-bac9-87ea11338e46
2006-11-14renaming Danish_Default to match current scheme which has charset in file ↵christopherm
name for utf8 git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@602 4979c152-3d1c-0410-bac9-87ea11338e46