summaryrefslogtreecommitdiff
path: root/sql
AgeCommit message (Collapse)Author
2007-06-10added referential mapping for noteslinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1261 4979c152-3d1c-0410-bac9-87ea11338e46
2007-06-07fix uniqueness on entity nameslinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1260 4979c152-3d1c-0410-bac9-87ea11338e46
2007-06-07fixed default of current_date to now()linuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1259 4979c152-3d1c-0410-bac9-87ea11338e46
2007-06-07first run of new notes system, includes tsearch2 full text indexinglinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1258 4979c152-3d1c-0410-bac9-87ea11338e46
2007-06-07added documentationm for tsearch2 requirementlinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1257 4979c152-3d1c-0410-bac9-87ea11338e46
2007-06-05added created columns for person, company and entitylinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1256 4979c152-3d1c-0410-bac9-87ea11338e46
2007-06-04added constraint to id,location_classlinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1254 4979c152-3d1c-0410-bac9-87ea11338e46
2007-06-04More trunk fixeseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1253 4979c152-3d1c-0410-bac9-87ea11338e46
2007-06-01Adding Reconciliation Moduleeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1249 4979c152-3d1c-0410-bac9-87ea11338e46
2007-06-01fix for authoritative addresses by adding location_classlinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1247 4979c152-3d1c-0410-bac9-87ea11338e46
2007-05-29changed employee_id to person(id) where needed, plus removed a couple of ↵linuxpoet
employee_id as they are now deprecated git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1246 4979c152-3d1c-0410-bac9-87ea11338e46
2007-05-29created relationships between contact_info and locationslinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1244 4979c152-3d1c-0410-bac9-87ea11338e46
2007-05-29forward testlinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1243 4979c152-3d1c-0410-bac9-87ea11338e46
2007-05-29added entity relationship between persons and companies. This is for Joshua ↵linuxpoet
Drake is related to Chris Travers who is Related to Metatrontech git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1242 4979c152-3d1c-0410-bac9-87ea11338e46
2007-05-23build out person->entity relationshiplinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1238 4979c152-3d1c-0410-bac9-87ea11338e46
2007-05-23added mailcode to locationlinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1237 4979c152-3d1c-0410-bac9-87ea11338e46
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
2007-05-08Translating stocks->inventaire in Quebec CoAeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1166 4979c152-3d1c-0410-bac9-87ea11338e46
2007-05-08Renaming French_General.sql to French-Quebec_General.sql so we can ↵einhverfr
automatically use French GIFI for other trnaslated CoA's git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1165 4979c152-3d1c-0410-bac9-87ea11338e46
2007-05-08Renaming Quebec to French for Canadian COA'seinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1164 4979c152-3d1c-0410-bac9-87ea11338e46
2007-05-08Adding Anarcat's patches to the Canadian French COAeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1163 4979c152-3d1c-0410-bac9-87ea11338e46
2007-05-06Fixing bug 1713288einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1132 4979c152-3d1c-0410-bac9-87ea11338e46
2007-05-06Fixing bug 1708011einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1131 4979c152-3d1c-0410-bac9-87ea11338e46
2007-04-30Adding first draft of voucher handling stored procedureseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1122 4979c152-3d1c-0410-bac9-87ea11338e46
2007-04-26fixing broken upgrade scripteinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1104 4979c152-3d1c-0410-bac9-87ea11338e46
2007-04-17reverting change to db structure for noweinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1075 4979c152-3d1c-0410-bac9-87ea11338e46
2007-04-16Rolling back tentative db commits for 1.3 pending Josh D's redesigneinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1074 4979c152-3d1c-0410-bac9-87ea11338e46
2007-03-13Fixing 8.0 compatibility bug in session managementeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@887 4979c152-3d1c-0410-bac9-87ea11338e46
2007-03-12Adding version numbers to modules that are ready to loadeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@885 4979c152-3d1c-0410-bac9-87ea11338e46
2007-03-11Moving functions back into sql/modules for now.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@883 4979c152-3d1c-0410-bac9-87ea11338e46
2007-03-10Moved defaults handling into separate objecteinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@876 4979c152-3d1c-0410-bac9-87ea11338e46
2007-03-09Employee search now workseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@873 4979c152-3d1c-0410-bac9-87ea11338e46
2007-03-08Fixing bug in employee search due to use of inner instead of left joineinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@867 4979c152-3d1c-0410-bac9-87ea11338e46
2007-03-08Adding a business location object as welleinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@865 4979c152-3d1c-0410-bac9-87ea11338e46
2007-03-08renaming employee to employees and dropping insert tracking ruleeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@864 4979c152-3d1c-0410-bac9-87ea11338e46
2007-03-07Moving HR bit into upgrade script.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@857 4979c152-3d1c-0410-bac9-87ea11338e46
2007-03-07Adding proof-of-concept HR stored procedures and some beginnings of the ↵einhverfr
security rewrite in temporary development files. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@856 4979c152-3d1c-0410-bac9-87ea11338e46
2007-03-06Final installment of coa file refactoringeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@853 4979c152-3d1c-0410-bac9-87ea11338e46
2007-03-06Third installment of refactoring of coa fileseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@852 4979c152-3d1c-0410-bac9-87ea11338e46