# HG changeset patch
# User peter
# Date 1199397177 0
# Node ID d015f5c9b308c72276ce1346d5e0f1c1666fefe9
# Parent  6ffacb626294c01c1e7b1c0d915f63203dd021db
[feladat @ 108]
Modified the SQL statements for PostgreSQL as the tables are created with wrong definitions.

diff -r 6ffacb626294 -r d015f5c9b308 install.php
--- a/install.php	Thu Jan 03 20:27:47 2008 +0000
+++ b/install.php	Thu Jan 03 21:52:57 2008 +0000
@@ -109,7 +109,7 @@
 		$sqlusers =	"CREATE TABLE users (
 				id SERIAL PRIMARY KEY,
 				username varchar(16) NOT NULL,
-				password varchar(255) NOT NULL,
+				password varchar(34) NOT NULL,
 				fullname varchar(255) NOT NULL,
 				email varchar(255) NOT NULL,
 				description text NOT NULL,
@@ -118,14 +118,14 @@
 				)";
 		$sqlzones =	"CREATE TABLE zones (
 				id SERIAL PRIMARY KEY,
-				name varchar(255) NOT NULL,
-				owner smallint NOT NULL,
+				domain_id integer NOT NULL,
+				owner integer NOT NULL,
 				comment text NULL
 				)";
                 $sqlrecowns =   "CREATE TABLE record_owners (
                                 id SERIAL PRIMARY KEY,
-                                user_id smallint NOT NULL,
-                                record_id smallint NOT NULL
+                                user_id integer NOT NULL,
+                                record_id integer NOT NULL
                                 )";
 	}