summaryrefslogtreecommitdiff
path: root/sql/Pg-tables.sql
AgeCommit message (Collapse)Author
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-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-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-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-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-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-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-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-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-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-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-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