From ac63cc4101da73e5b1b4424c53f29033557c6596 Mon Sep 17 00:00:00 2001
From: Dusty Phillips <buchuki@gmail.com>
Date: Sat, 16 Aug 2008 13:36:15 -0400
Subject: #10340 Integrated Signoffs completed but untested

---
 migrate_signoff.sql | 10 +++-------
 1 file changed, 3 insertions(+), 7 deletions(-)

(limited to 'migrate_signoff.sql')

diff --git a/migrate_signoff.sql b/migrate_signoff.sql
index ed2ceef5..800062a7 100644
--- a/migrate_signoff.sql
+++ b/migrate_signoff.sql
@@ -2,13 +2,9 @@ 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`)
+    `pkgrel` varchar(255) NOT NULL,
+    `packager_id` integer NOT NULL REFERENCES `auth_user` (`id`)
 );
 CREATE INDEX main_signoff_pkg_id ON `main_signoff` (`pkg_id`);
+CREATE INDEX main_signoff_packager_id ON `main_signoff` (`packager_id`);
 
-- 
cgit v1.2.3-54-g00ecf

