summaryrefslogtreecommitdiff
path: root/sql/Pg-database.sql
AgeCommit message (Collapse)Author
2007-07-20Adding locking mechanism for discretionary lockseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1431 4979c152-3d1c-0410-bac9-87ea11338e46
2007-07-16Adding foreign key to acc_trans.trans_ideinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1406 4979c152-3d1c-0410-bac9-87ea11338e46
2007-07-16Finalizing data integrity control checks for global sequence for 1.3einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1405 4979c152-3d1c-0410-bac9-87ea11338e46
2007-07-15* Restoring global id sequence (until 1.4)einhverfr
* Dropping new not null constraints in legacy portions of db. * Updating Menu db tables. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1398 4979c152-3d1c-0410-bac9-87ea11338e46
2007-07-12Adding partial unique index on partnumber to prevent multiple active items ↵einhverfr
sharing the same part number git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1391 4979c152-3d1c-0410-bac9-87ea11338e46
2007-07-10Got rid of del_customer and del_vendor triggers and moved to ON DELETE ↵einhverfr
actions instead git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1379 4979c152-3d1c-0410-bac9-87ea11338e46
2007-07-10Merging Pg-central and Pg-database fileseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1378 4979c152-3d1c-0410-bac9-87ea11338e46
2007-07-10Changes to the comments on entity_metadata, which does not exist, to refer ↵aurynn_cmd
to entity_credit account. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1374 4979c152-3d1c-0410-bac9-87ea11338e46
2007-07-10Fixes Add Vendor, to correctly work with the new entity_credit_account ↵aurynn_cmd
table, in place of the customer/vendor tables. Removes the Vendor and Customer tables, replacing them with entity_credit_account (previously entity_metadata) and Vendor and Customer as a view, mimicking the original Vendor and Customer tables. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1373 4979c152-3d1c-0410-bac9-87ea11338e46
2007-07-10Fixing menu_attributes so that it does not roll back the functioneinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1369 4979c152-3d1c-0410-bac9-87ea11338e46
2007-07-10Moving commit to end of fileeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1368 4979c152-3d1c-0410-bac9-87ea11338e46
2007-07-09Moving menu over to new template and stored proc model. THe menu ↵einhverfr
expansion/contraction doesn't quite work yet and there needs to be some additional help on the CSS/Javascript side of this. Also, this makes a few changes to the lower-level Perl API. Classes calling LedgerSMB::call_procedure() directly may need some editing but I believe I got them all. These changes were necessary to accomodate zero-argument stored procedures. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1355 4979c152-3d1c-0410-bac9-87ea11338e46
2007-07-05fix entity/entity_class so you aren't limited to only one customer everlinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1351 4979c152-3d1c-0410-bac9-87ea11338e46
2007-06-27changed inventory to track employee table, instead of entity tablelinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1340 4979c152-3d1c-0410-bac9-87ea11338e46
2007-06-27fixed inventory model to force employeelinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1339 4979c152-3d1c-0410-bac9-87ea11338e46
2007-06-21minor date style changelinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1296 4979c152-3d1c-0410-bac9-87ea11338e46
2007-06-21added tracking capability to location. When implemented in 1.3, locations ↵linuxpoet
should not be deleted. Instead they are marked active/inactive and tracked git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1295 4979c152-3d1c-0410-bac9-87ea11338e46
2007-06-19man that was more work that it should of been. there is no employee(id), ↵linuxpoet
vendor(id) anymore. Refer to key checks. Also fixed rules associated to compile, but may not be correct git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1288 4979c152-3d1c-0410-bac9-87ea11338e46
2007-06-19further cleaning of batchlinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1287 4979c152-3d1c-0410-bac9-87ea11338e46
2007-06-19fixed some issues with batch tableslinuxpoet
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1286 4979c152-3d1c-0410-bac9-87ea11338e46
2007-06-19Added ar voucher type.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1283 4979c152-3d1c-0410-bac9-87ea11338e46
2007-06-19Added on-hold flags for invoices and voucher information to db schema.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1282 4979c152-3d1c-0410-bac9-87ea11338e46
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-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
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
generated by cgit v1.2.3 (git 2.46.0) at 2024-12-26 01:56:22 +0000