Fixed From: mail address. Sorry for re-mailing, Frank >From 3fc2828bd18e00127f8e7bc18083164f045b1e48 Mon Sep 17 00:00:00 2001 From: Frank Becker <[email protected]> Date: Tue, 5 Jul 2011 17:54:09 +0200
- added id field to ManyToMany tables Signed-off-by: Frank Becker <[email protected]> --- .../migrations/067_add_id_afe_acl_groups_hosts.py | 7 +++++++ .../migrations/068_add_id_afe_acl_groups_users.py | 7 +++++++ 2 files changed, 14 insertions(+), 0 deletions(-) create mode 100644 frontend/migrations/067_add_id_afe_acl_groups_hosts.py create mode 100644 frontend/migrations/068_add_id_afe_acl_groups_users.py diff --git a/frontend/migrations/067_add_id_afe_acl_groups_hosts.py b/frontend/migrations/067_add_id_afe_acl_groups_hosts.py new file mode 100644 index 0000000..4bd6572 --- /dev/null +++ b/frontend/migrations/067_add_id_afe_acl_groups_hosts.py @@ -0,0 +1,7 @@ +UP_SQL = """ +ALTER TABLE afe_acl_groups_hosts ADD COLUMN id integer AUTO_INCREMENT NOT NULL PRIMARY KEY FIRST; +""" + +DOWN_SQL = """ +ALTER TABLE afe_acl_groups_hosts DROP COLUMN id; +""" diff --git a/frontend/migrations/068_add_id_afe_acl_groups_users.py b/frontend/migrations/068_add_id_afe_acl_groups_users.py new file mode 100644 index 0000000..185eb05 --- /dev/null +++ b/frontend/migrations/068_add_id_afe_acl_groups_users.py @@ -0,0 +1,7 @@ +UP_SQL = """ +ALTER TABLE afe_acl_groups_users ADD COLUMN id integer AUTO_INCREMENT NOT NULL PRIMARY KEY FIRST; +""" + +DOWN_SQL = """ +ALTER TABLE afe_acl_groups_users DROP COLUMN id; +""" -- 1.7.4.1 _______________________________________________ Autotest mailing list [email protected] http://test.kernel.org/cgi-bin/mailman/listinfo/autotest
