summaryrefslogtreecommitdiff
path: root/sql/Pg-database.sql
AgeCommit message (Collapse)Author
2007-05-22add primary key to entity_class_to_entitylinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1236 4979c152-3d1c-0410-bac9-87ea11338e46
2007-05-22Created entity to class relationshiplinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1235 4979c152-3d1c-0410-bac9-87ea11338e46
2007-05-22Created authoritative classes for entity_classlinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1234 4979c152-3d1c-0410-bac9-87ea11338e46
2007-05-20fixed employee indexeslinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1232 4979c152-3d1c-0410-bac9-87ea11338e46
2007-05-20fix some index creation where vendor and customer are now meta tableslinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1231 4979c152-3d1c-0410-bac9-87ea11338e46
2007-05-20a couple more fixes... noted that this also breaks some of the stored procslinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1230 4979c152-3d1c-0410-bac9-87ea11338e46
2007-05-20fixed broken relationships in new entity and some spelling errors, now need ↵linuxpoet
to bust through some rules git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1229 4979c152-3d1c-0410-bac9-87ea11338e46
2007-05-20rebuild oe references and add oe_class tablelinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1228 4979c152-3d1c-0410-bac9-87ea11338e46
2007-05-20As promised mass breakage... employees, customers, vendors, ap, ar all all ↵linuxpoet
broke now from the user level... references from schema are correct git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1227 4979c152-3d1c-0410-bac9-87ea11338e46
2007-05-20removal of universal id sequencelinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1226 4979c152-3d1c-0410-bac9-87ea11338e46
2007-05-20first rev of entity relationship. Still missing some components, including ↵linuxpoet
company2person, relationship lookup, and contact info metadata such as cell, im etc... git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1225 4979c152-3d1c-0410-bac9-87ea11338e46
2007-05-20fixed really dumb use of sequences into seriallinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1224 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-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-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-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-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