summaryrefslogtreecommitdiff
path: root/sql
AgeCommit message (Collapse)Author
2007-02-06Adding LBMoore's db upgrade fixeseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@795 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/trunk@733 4979c152-3d1c-0410-bac9-87ea11338e46
2006-11-27removing user and session tables from this legacy file. Having it there ↵christopherm
makes it harder for people to move to 1.2 ina single db context git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@695 4979c152-3d1c-0410-bac9-87ea11338e46
2006-11-22Adjusting del_exchangerate to work with current defaults table layouttetragon
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@681 4979c152-3d1c-0410-bac9-87ea11338e46
2006-11-21adding transaction_id. This will require an update to the session table, ↵christopherm
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/trunk@674 4979c152-3d1c-0410-bac9-87ea11338e46
2006-11-18Fix SQL syntaxtetragon
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@657 4979c152-3d1c-0410-bac9-87ea11338e46
2006-11-17Moving upgrade script fixes into trunkeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@653 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/trunk@623 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
2006-11-02fixing unescaped quote in commentchristopherm
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@467 4979c152-3d1c-0410-bac9-87ea11338e46
2006-11-01Merged Pg-tables, functions, and indeces into Pg-database.sqleinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@449 4979c152-3d1c-0410-bac9-87ea11338e46
2006-10-31Making Pg-upgrade-2.6.18-2.6.19.sql safe to use for noweinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@421 4979c152-3d1c-0410-bac9-87ea11338e46
2006-10-31Moving Pg-upgrade* into sql/legacy directoryeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@420 4979c152-3d1c-0410-bac9-87ea11338e46
2006-10-31Finished converting CoA's...einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@418 4979c152-3d1c-0410-bac9-87ea11338e46
2006-10-31Egyptian and French CoA's...einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@417 4979c152-3d1c-0410-bac9-87ea11338e46
2006-10-31Danish and Dutch CoA's...einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@416 4979c152-3d1c-0410-bac9-87ea11338e46
2006-10-31COnverted all Canadian, Colombian, and Czech CoA'seinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@415 4979c152-3d1c-0410-bac9-87ea11338e46
2006-10-31Converted Australian and Austrian CoA'seinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@414 4979c152-3d1c-0410-bac9-87ea11338e46
2006-10-31Defaults table revision. Most COA's and System->defaults are known to be broken.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@413 4979c152-3d1c-0410-bac9-87ea11338e46
2006-10-30Fixing IR, IS, and CT bugseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@382 4979c152-3d1c-0410-bac9-87ea11338e46
2006-10-27removing stray commachristopherm
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@330 4979c152-3d1c-0410-bac9-87ea11338e46
2006-10-26Moved Slony configuration scripts into new contrib directory.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@327 4979c152-3d1c-0410-bac9-87ea11338e46
2006-10-24changed create_user to return users.id if successfullinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@275 4979c152-3d1c-0410-bac9-87ea11338e46
2006-10-24added functions create_user and update_user.. see docslinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@274 4979c152-3d1c-0410-bac9-87ea11338e46
2006-10-24added admin user defaults for postgresqllinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@273 4979c152-3d1c-0410-bac9-87ea11338e46
2006-10-21Note to Chrish ... Added users table, added users_conf table which is to ↵linuxpoet
replace users/username.conf etc... added comments git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@260 4979c152-3d1c-0410-bac9-87ea11338e46
2006-10-21fixed length check for upgradeslinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@256 4979c152-3d1c-0410-bac9-87ea11338e46
2006-10-21session.token now uses a varchar(32) with length check constraint. ↵linuxpoet
session_id now uses a proper serial as we don't support version < 8.x this should be fine git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@255 4979c152-3d1c-0410-bac9-87ea11338e46
2006-10-21Modified parsing to return undef on empty string.einhverfr
Modified CT to use 0 credit limit if none provided. Added On Hand column to invoices. Dropped foreign key constrant on acc_trans.trans_id due to limitations in current API (will be in a future version). git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@250 4979c152-3d1c-0410-bac9-87ea11338e46
2006-10-17Added default tax modules to Pg-tables.sqleinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@223 4979c152-3d1c-0410-bac9-87ea11338e46
2006-10-16syntax error in sql using wrong closing bracechristopherm
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@217 4979c152-3d1c-0410-bac9-87ea11338e46
2006-10-10Fixing broken escapes of single quotes in stringschristopherm
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@201 4979c152-3d1c-0410-bac9-87ea11338e46
2006-10-10sorting by account number to simplify translation/comparison to ↵christopherm
Canada-English, and just because it's the right thing to do(tm) git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@200 4979c152-3d1c-0410-bac9-87ea11338e46
2006-10-10renaming Canada-French to more accurate Canada-Quebec, using utf-8 and ↵christopherm
setting correct provincial tax rate (7.5%) git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@196 4979c152-3d1c-0410-bac9-87ea11338e46