[feladat @ 108]
authorpeter
Thu, 03 Jan 2008 21:52:57 +0000
changeset 61 d015f5c9b308
parent 60 6ffacb626294
child 62 ce4919f37489
[feladat @ 108] Modified the SQL statements for PostgreSQL as the tables are created with wrong definitions.
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
                                 )";
 	}