summaryrefslogtreecommitdiff
path: root/sql
AgeCommit message (Collapse)Author
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
2006-11-14converting Danish_Default-chart to utf-8 from 8859-1christopherm
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@601 4979c152-3d1c-0410-bac9-87ea11338e46
2006-11-14Fixed defaults in numerous CoA'seinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@598 4979c152-3d1c-0410-bac9-87ea11338e46
2006-11-14Fixed issue with US_General chart and updated BUGS fileeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@597 4979c152-3d1c-0410-bac9-87ea11338e46
2006-11-14Syntax fixestetragon
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@576 4979c152-3d1c-0410-bac9-87ea11338e46
2006-11-12Adding tax category support to the dbtetragon
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@524 4979c152-3d1c-0410-bac9-87ea11338e46
2006-11-12creating a central Session::password_check which will allow for an upgrade ↵christopherm
from crypted passwords to md5. Fixing session timeout problem for first login. Removing some old cruft (set_cookie and more). Changing central db users_conf to remove dbconnect (which will now be generated) and to add crypted_password (which will eventually be removed). git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@520 4979c152-3d1c-0410-bac9-87ea11338e46
2006-11-08Fixed bug: custom field tables don't contain declared primary keyeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@498 4979c152-3d1c-0410-bac9-87ea11338e46
2006-11-08Fixed bug: custom field tables don't contain declared primary keyeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@497 4979c152-3d1c-0410-bac9-87ea11338e46
2006-11-03moving all user preferences into the central db. This will break current ↵christopherm
test installs or anyone running HEAD. Please see ledger-smb.conf. You will also need to create the central db (using Pg-central.sql) and set the admin user password (md5(something)). More info to be given on the legdger-smb-devel mailing list git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@479 4979c152-3d1c-0410-bac9-87ea11338e46