summaryrefslogtreecommitdiff
path: root/migrate_signoff.sql
diff options
context:
space:
mode:
authorDusty Phillips <buchuki@gmail.com>2008-08-16 13:36:15 -0400
committerDusty Phillips <buchuki@gmail.com>2008-08-16 13:36:15 -0400
commitac63cc4101da73e5b1b4424c53f29033557c6596 (patch)
tree34e02c6288290f93d5a8be2d13e7183d77a1690a /migrate_signoff.sql
parente1fa499f637e00f5e7eb91ec460903558b46017a (diff)
#10340 Integrated Signoffs completed but untested
Diffstat (limited to 'migrate_signoff.sql')
-rw-r--r--migrate_signoff.sql10
1 files changed, 3 insertions, 7 deletions
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`);