Postgres_id_table.sql

[Gunnar R|nning]

Hi, 

I just modified the Oracle id table to support PostgreSQL. Could somebody
add this to the CVS ? The file is appended.

Regards, 

        Gunnar

## 
## This table provides the primary keys for all
## other tables in the system.  Should be used
## with util.db.IDBroker.
##

DROP TABLE ID_TABLE ;
CREATE TABLE ID_TABLE (
  ID_TABLE_ID   INT4    PRIMARY KEY NOT NULL,
  TABLE_NAME    VARCHAR(255) UNIQUE NOT NULL,
  NEXT_ID       INT4,
  QUANTITY      INT4
);

INSERT INTO ID_TABLE 
        (ID_TABLE_ID, TABLE_NAME, NEXT_ID, QUANTITY)
 VALUES (1, 'Permission', 13, 10) ;
INSERT INTO ID_TABLE 
        (ID_TABLE_ID, TABLE_NAME, NEXT_ID, QUANTITY)
 VALUES (2, 'UserRole', 2, 10) ;

INSERT INTO ID_TABLE 
        (ID_TABLE_ID, TABLE_NAME, NEXT_ID, QUANTITY)
 VALUES (3, 'Visitor', 2, 10) ;

INSERT INTO ID_TABLE 
        (ID_TABLE_ID, TABLE_NAME, NEXT_ID, QUANTITY)
 VALUES (4, 'Jobentry', 5, 10) ;


------------------------------------------------------------
To subscribe:        [EMAIL PROTECTED]
To unsubscribe:      [EMAIL PROTECTED]
Problems?:           [EMAIL PROTECTED]