From 02b3877dd799b46090c10c574f9fa882292821f6 Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
Date: Fri, 18 Aug 2006 08:39:21 +0000
Subject: - Patch #76914 by smsimms/sammys: PostgreSQL fixes for installer.

---
 modules/system/system.install | 6 ++----
 1 file changed, 2 insertions(+), 4 deletions(-)

(limited to 'modules/system/system.install')

diff --git a/modules/system/system.install b/modules/system/system.install
index a8e3cef79..751bfec87 100644
--- a/modules/system/system.install
+++ b/modules/system/system.install
@@ -587,7 +587,7 @@ function system_install() {
 
       db_query("CREATE TABLE {node_revisions} (
         nid int_unsigned NOT NULL,
-        vid int_unsigned NOT NULL,
+        vid serial CHECK (vid >= 0),
         uid int NOT NULL default '0',
         title varchar(128) NOT NULL default '',
         body text NOT NULL default '',
@@ -599,7 +599,6 @@ function system_install() {
       )");
       db_query("CREATE INDEX {node_revisions}_nid_idx ON {node_revisions} (nid)");
       db_query("CREATE INDEX {node_revisions}_uid_idx ON {node_revisions} (uid)");
-      db_query("CREATE SEQUENCE {node_revisions}_vid_seq INCREMENT 1 START 1");
 
       db_query("CREATE TABLE {node_type} (
         type varchar(32) NOT NULL,
@@ -734,7 +733,7 @@ function system_install() {
       db_query("CREATE INDEX {term_synonym}_name_idx ON {term_synonym} (substr(name, 1, 3))");
 
       db_query("CREATE TABLE {users} (
-        uid int_unsigned NOT NULL default '0',
+        uid serial CHECK (uid >= 0),
         name varchar(60) NOT NULL default '',
         pass varchar(32) NOT NULL default '',
         mail varchar(64) default '',
@@ -756,7 +755,6 @@ function system_install() {
         UNIQUE (name)
       )");
       db_query("CREATE INDEX {users}_access_idx ON {users} (access)");
-      db_query("CREATE SEQUENCE {users}_uid_seq INCREMENT 1 START 1");
 
       db_query("CREATE TABLE {users_roles} (
         uid int_unsigned NOT NULL default '0',
-- 
cgit v1.2.3