summaryrefslogtreecommitdiff
path: root/sql
AgeCommit message (Collapse)Author
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
2006-09-04Removed the underscore from valid login names since it was causing regex errors.einhverfr
Fixed the system so that the db upgrade script works. Added some new tasks, notes, etc to TODO. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@21 4979c152-3d1c-0410-bac9-87ea11338e46
2006-09-01Initial Importchristopherm
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/ledger-smb@1 4979c152-3d1c-0410-bac9-87ea11338e46