[feladat @ 108]
Modified the SQL statements for PostgreSQL as the tables are created with wrong definitions.
--- 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
)";
}