--- a/ChangeLog	Tue Jan 15 01:33:25 2008 +0000
+++ b/ChangeLog	Fri Jan 18 20:25:05 2008 +0000
@@ -1,4 +1,10 @@
 === 0.0.0 ===
+2008-01-18  Pascal Volk  <neverseen@users.sourceforge.net>
+
+	* create_tables.pgsql: Removed unneeded sequences 'alias_id' and
+	 'relocated_id'.
+	 Removed unneeded column 'id' from table 'alias' and 'relocated'.
+
 2008-01-15  Pascal Volk  <neverseen@users.sourceforge.net>
 
 	* create_tables.pgsql: Redesign of table layout, create separate tables for

--- a/create_tables.pgsql	Tue Jan 15 01:33:25 2008 +0000
+++ b/create_tables.pgsql	Fri Jan 18 20:25:05 2008 +0000
@@ -61,9 +61,7 @@
         REFERENCES transport (tid)
 );
 
-CREATE SEQUENCE alias_id;
 CREATE TABLE alias (
-    id          bigint NOT NULL DEFAULT nextval('alias_id'),
     gid         bigint NOT NULL,
     address     varchar(256) NOT NULL,
     destination varchar(320) NOT NULL,
@@ -72,9 +70,7 @@
         REFERENCES domains (gid)
 );
 
-CREATE SEQUENCE relocated_id;
 CREATE TABLE relocated (
-    id          bigint NOT NULL DEFAULT nextval('relocated_id'),
     gid         bigint NOT NULL,
     address     varchar(64) NOT NULL,
     destination varchar(320) NOT NULL,