From e1fa499f637e00f5e7eb91ec460903558b46017a Mon Sep 17 00:00:00 2001 From: Dusty Phillips 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 0000000..ed2ceef --- /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-24-g4f1b