From 0b888d2a736b1b307da7bb412fc4beb151af0173 Mon Sep 17 00:00:00 2001
From: Peter Hormanns <peter.hormanns@jalin.de>
Date: Sat, 11 May 2013 17:52:53 +0200
Subject: [PATCH] prepare for moving basepacket foreign key

---
 hsarback/database/schema.sql |   32 ++++++++++++++------------------
 1 files changed, 14 insertions(+), 18 deletions(-)

diff --git a/hsarback/database/schema.sql b/hsarback/database/schema.sql
index 089fbdd..b66cf76 100644
--- a/hsarback/database/schema.sql
+++ b/hsarback/database/schema.sql
@@ -329,8 +329,6 @@
 );
 
 
-SET default_with_oids = true;
-
 --
 -- Name: hive; Type: TABLE; Schema: public; Owner: -; Tablespace: 
 --
@@ -396,21 +394,6 @@
 
 
 --
--- Name: packet_component; Type: TABLE; Schema: public; Owner: -; Tablespace: 
---
-
-CREATE TABLE packet_component (
-    basepacket_id integer NOT NULL,
-    basecomponent_id integer NOT NULL,
-    packet_id integer NOT NULL,
-    quantity integer NOT NULL,
-    created date,
-    cancelled date,
-    CONSTRAINT ckt_packet_component CHECK (((cancelled IS NULL) OR (cancelled > created)))
-);
-
-
---
 -- Name: packet_packet_id_seq; Type: SEQUENCE; Schema: public; Owner: -
 --
 
@@ -421,7 +404,20 @@
     CACHE 1;
 
 
-SET default_with_oids = false;
+--
+-- Name: packet_component; Type: TABLE; Schema: public; Owner: -; Tablespace: 
+--
+
+CREATE TABLE packet_component (
+    basepacket_id integer NOT NULL,  -- move to packet
+    basecomponent_id integer NOT NULL,
+    packet_id integer NOT NULL,
+    quantity integer NOT NULL,
+    created date,
+    cancelled date,
+    CONSTRAINT ckt_packet_component CHECK (((cancelled IS NULL) OR (cancelled > created)))
+);
+
 
 --
 -- Name: queue_task; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--
Gitblit v1.9.0-SNAPSHOT