X-Git-Url: https://git.evergreen-ils.org/?p=Evergreen.git;a=blobdiff_plain;f=Open-ILS%2Fsrc%2Fsql%2FPg%2F080.schema.money.sql;h=4655150c2550357ab74e8d23436816bb77495aba;hp=14cab101cb4bd954776f91cdcf5ab837562c6dd9;hb=89ae42a6149ee13ca261e0ded6d1126aec02480e;hpb=b0980c6f2ae1d0f8cefcbd57313d16fc2b546690;ds=sidebyside

diff --git a/Open-ILS/src/sql/Pg/080.schema.money.sql b/Open-ILS/src/sql/Pg/080.schema.money.sql
index 14cab101cb..4655150c25 100644
--- a/Open-ILS/src/sql/Pg/080.schema.money.sql
+++ b/Open-ILS/src/sql/Pg/080.schema.money.sql
@@ -12,6 +12,11 @@ CREATE TABLE money.billable_xact (
 );
 CREATE INDEX m_b_x_open_xacts_idx ON money.billable_xact (usr) WHERE xact_finish IS NULL;
 
+CREATE TABLE money.grocery ( -- Catchall table for local billing
+	billing_location	INT	NOT NULL, -- library creating transaction
+	note			TEXT
+) INHERITS (money.billable_xact);
+
 CREATE TABLE money.billing (
 	id		BIGSERIAL			PRIMARY KEY,
 	xact		BIGINT				NOT NULL, -- money.billable_xact.id