# HG changeset patch
# User Pascal Volk <neverseen@users.sourceforge.net>
# Date 1200687905 0
# Node ID 96761c442dcf5f8bad1d3b72ed8cc80b204c9b8c
# Parent  07d141039f749d79433ea65f77123fb30569848d
* 'create_tables.pgsql'
    - Removed unneeded sequences 'alias_id' and 'relocated_id'
    - Removed unneeded column 'id' from table 'alias' and 'relocated'.

diff -r 07d141039f74 -r 96761c442dcf ChangeLog
--- 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
diff -r 07d141039f74 -r 96761c442dcf create_tables.pgsql
--- 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,