summaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/Pg-database.sql13
1 files changed, 7 insertions, 6 deletions
diff --git a/sql/Pg-database.sql b/sql/Pg-database.sql
index 57594e4a..8d22a0cb 100644
--- a/sql/Pg-database.sql
+++ b/sql/Pg-database.sql
@@ -94,7 +94,7 @@ CREATE FUNCTION lock_record (int, int) returns bool as
$$
declare
locked int;
-begin;
+begin
SELECT locked_by into locked from transactions where id = $1;
IF NOT FOUND THEN
RETURN FALSE;
@@ -430,6 +430,12 @@ ALTER TABLE invoice_note ADD FOREIGN KEY (ref_key) REFERENCES invoice(id);
--
+-- pricegroup added here due to references
+CREATE TABLE pricegroup (
+ id serial PRIMARY KEY,
+ pricegroup text
+);
+
CREATE TABLE entity_credit_account (
id serial not null unique,
entity_id int not null references entity(id) ON DELETE CASCADE,
@@ -897,11 +903,6 @@ CREATE TABLE partsvendor (
entry_id SERIAL PRIMARY KEY
);
--
-CREATE TABLE pricegroup (
- id serial PRIMARY KEY,
- pricegroup text
-);
---
CREATE TABLE partscustomer (
parts_id int,
customer_id int not null references entity_credit_account(id) on delete cascade,