pgsql/x-dragon-cohead.sql
authorAlan Knowles <alan@roojs.com>
Wed, 25 Feb 2015 10:02:41 +0000 (18:02 +0800)
committerAlan Knowles <alan@roojs.com>
Wed, 25 Feb 2015 10:02:41 +0000 (18:02 +0800)
pgsql/x-dragon-cohead.sql [deleted file]

diff --git a/pgsql/x-dragon-cohead.sql b/pgsql/x-dragon-cohead.sql
deleted file mode 100644 (file)
index cb2e5c9..0000000
+++ /dev/null
@@ -1,15 +0,0 @@
--- add a 'displayed' sales person.
-
-
-alter table cohead add column cohead_display_salesrep_id INTEGER;
-
-ALTER TABLE cohead add column cohead_pretax_discount numeric(16,4) NOT NULL DEFAULT 0;
-
-ALTER TABLE cohead add column cohead_posttax_discount numeric(16,4) NOT NULL DEFAULT 0;
-ALTER TABLE cohead ADD CONSTRAINT cohead_display_salesrep_fkey FOREIGN KEY (cohead_display_salesrep_id)
-        REFERENCES salesrep(salesrep_id) MATCH SIMPLE
-      ON UPDATE CASCADE ON DELETE NO ACTION;
-