From 7f00e9fe251a366ccb2546ed3115fb799418a7dd Mon Sep 17 00:00:00 2001 From: Andrew Garrett Date: Thu, 1 Feb 2007 09:01:30 +0000 Subject: [PATCH] Fix last commit - patches were using SERIAL instead of int unsigned not null auto_increment --- maintenance/archives/patch-log_id.sql | 2 +- maintenance/archives/patch-page_restrictions_sortkey.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/maintenance/archives/patch-log_id.sql b/maintenance/archives/patch-log_id.sql index d3f0d3350f..cde9868cf0 100644 --- a/maintenance/archives/patch-log_id.sql +++ b/maintenance/archives/patch-log_id.sql @@ -4,5 +4,5 @@ -- Andrew Garrett, February 2007. ALTER TABLE logging - ADD COLUMN log_id SERIAL, + ADD COLUMN log_id int unsigned not null auto_increment, ADD PRIMARY KEY log_id (log_id); diff --git a/maintenance/archives/patch-page_restrictions_sortkey.sql b/maintenance/archives/patch-page_restrictions_sortkey.sql index 8b7e00470e..63bc032a5a 100644 --- a/maintenance/archives/patch-page_restrictions_sortkey.sql +++ b/maintenance/archives/patch-page_restrictions_sortkey.sql @@ -4,5 +4,5 @@ -- Andrew Garrett, February 2007 ALTER TABLE page_restrictions - ADD COLUMN pr_id SERIAL, + ADD COLUMN pr_id int unsigned not null auto_increment, ADD UNIQUE KEY pr_id (pr_id); -- 2.20.1