From e1fa499f637e00f5e7eb91ec460903558b46017a Mon Sep 17 00:00:00 2001
From: Dusty Phillips <buchuki@gmail.com>
Date: Sat, 16 Aug 2008 12:58:22 -0400
Subject: add signoff model for capturing signoffs

---
 migrate_signoff.sql | 14 ++++++++++++++
 1 file changed, 14 insertions(+)
 create mode 100644 migrate_signoff.sql

(limited to 'migrate_signoff.sql')

diff --git a/migrate_signoff.sql b/migrate_signoff.sql
new file mode 100644
index 00000000..ed2ceef5
--- /dev/null
+++ b/migrate_signoff.sql
@@ -0,0 +1,14 @@
+CREATE TABLE `main_signoff` (
+    `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
+    `pkg_id` integer NOT NULL,
+    `pkgver` varchar(255) NOT NULL,
+    `pkgrel` varchar(255) NOT NULL
+);
+CREATE TABLE `main_signoff_signed_off` (
+    `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
+    `signoff_id` integer NOT NULL REFERENCES `main_signoff` (`id`),
+    `user_id` integer NOT NULL REFERENCES `auth_user` (`id`),
+    UNIQUE (`signoff_id`, `user_id`)
+);
+CREATE INDEX main_signoff_pkg_id ON `main_signoff` (`pkg_id`);
+
-- 
cgit v1.2.3-2-g168b

