summaryrefslogtreecommitdiff
path: root/sql
AgeCommit message (Collapse)Author
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
2006-10-08First round of tax code replacement, adds cumulative tax supporttetragon
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@195 4979c152-3d1c-0410-bac9-87ea11338e46
2006-10-08Fix syntax and table names to match schematetragon
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@194 4979c152-3d1c-0410-bac9-87ea11338e46
2006-10-06remove duplicate transactions table creationlinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@192 4979c152-3d1c-0410-bac9-87ea11338e46
2006-10-03Update Canadian GST rates.tetragon
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@184 4979c152-3d1c-0410-bac9-87ea11338e46
2006-09-30Fixed Pg-tables.sql, added scripts to configure replicationeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@174 4979c152-3d1c-0410-bac9-87ea11338e46
2006-09-25Removed "ALSO" from rules.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@148 4979c152-3d1c-0410-bac9-87ea11338e46
2006-09-25Moved Form.pm to parameterized queries. Did some basic testing, but can'teinhverfr
guarantee that nothing broke. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@146 4979c152-3d1c-0410-bac9-87ea11338e46
2006-09-24correcting omission of primary key for shipto updating in anticipation ofeinhverfr
multiple shipto support git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@144 4979c152-3d1c-0410-bac9-87ea11338e46
2006-09-24Added defined primary keys to all tableseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@143 4979c152-3d1c-0410-bac9-87ea11338e46
2006-09-24Started the next db upgrade file. So far, I have set acc_trans.trans_id as ↵einhverfr
a foreign key. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@138 4979c152-3d1c-0410-bac9-87ea11338e46
2006-09-23Fixed issues with the creation of function in the upgrade scripts and functioneinhverfr
files git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@136 4979c152-3d1c-0410-bac9-87ea11338e46
2006-09-21Fixed custom table functions not being added.einhverfr
Fixed parts short trigger not being creted Pg option in new user creation is now checked by default. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@127 4979c152-3d1c-0410-bac9-87ea11338e46
2006-09-21New datasets have transaction reversal enforced by default.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@124 4979c152-3d1c-0410-bac9-87ea11338e46
2006-09-20Renamed transaction_ledger to transactionseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@123 4979c152-3d1c-0410-bac9-87ea11338e46
2006-09-19Committing db fixes from Senecaeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@115 4979c152-3d1c-0410-bac9-87ea11338e46
2006-09-18fixed broken db version. Also fixed bug of trying to add all relations toeinhverfr
template1. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@110 4979c152-3d1c-0410-bac9-87ea11338e46
2006-09-18Updating for testing. Dataset creation and backup are currently known to be einhverfr
broken. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@109 4979c152-3d1c-0410-bac9-87ea11338e46
2006-09-18Added stored procedures and catalogs for custom fields. No logic is added toeinhverfr
API yet. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@107 4979c152-3d1c-0410-bac9-87ea11338e46
2006-09-15renamed id_tracker to transaction_ledger since in the future it may play a ↵einhverfr
larger role git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@101 4979c152-3d1c-0410-bac9-87ea11338e46
2006-09-15Added the foreign key constraint to pg_tables too...einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@100 4979c152-3d1c-0410-bac9-87ea11338e46
2006-09-15Added foreign key constraint to acc_transeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@99 4979c152-3d1c-0410-bac9-87ea11338e46
2006-09-13Added unique id tracking.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@80 4979c152-3d1c-0410-bac9-87ea11338e46
2006-09-12New sl-stack changes extensionseinhverfr
Added parts notify trigger to pg-functions.sql git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@74 4979c152-3d1c-0410-bac9-87ea11338e46
2006-09-11Rather large amount of changes to Pg-tables.sql and the 2.6.17-2.6.18 ↵linuxpoet
upgrade script. Changed all floats to numeric. If the float was a percent, it is just numeric. If the float was a cost, it is (10,2) git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@62 4979c152-3d1c-0410-bac9-87ea11338e46
2006-09-10Added a script which will notify individuals of short parts via email in einhverfr
nearly real time git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@56 4979c152-3d1c-0410-bac9-87ea11338e46
2006-09-09Added a little documentationlinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@49 4979c152-3d1c-0410-bac9-87ea11338e46
2006-09-09initial script for upgrade to 2.6.18. Adds primary key to acc_translinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@48 4979c152-3d1c-0410-bac9-87ea11338e46
2006-09-09Remove all non Pg Ports, they were unsupported and LedgerSMB is a Pg only ↵linuxpoet
project now. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@47 4979c152-3d1c-0410-bac9-87ea11338e46
2006-09-06Fixed db updateeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@27 4979c152-3d1c-0410-bac9-87ea11338e46