Index: trunk/phase3/maintenance/archives/patch-log_id.sql |
— | — | @@ -4,5 +4,5 @@ |
5 | 5 | -- Andrew Garrett, February 2007. |
6 | 6 | |
7 | 7 | ALTER TABLE logging |
8 | | - ADD COLUMN log_id SERIAL, |
| 8 | + ADD COLUMN log_id int unsigned not null auto_increment, |
9 | 9 | ADD PRIMARY KEY log_id (log_id); |
Index: trunk/phase3/maintenance/archives/patch-page_restrictions_sortkey.sql |
— | — | @@ -4,5 +4,5 @@ |
5 | 5 | -- Andrew Garrett, February 2007 |
6 | 6 | |
7 | 7 | ALTER TABLE page_restrictions |
8 | | - ADD COLUMN pr_id SERIAL, |
| 8 | + ADD COLUMN pr_id int unsigned not null auto_increment, |
9 | 9 | ADD UNIQUE KEY pr_id (pr_id); |