upgrades/dbpatches/1.3/postgresql/patch/ids.sql


1
2
3
4
5
6
7

CREATE TABLE ids (
        nodeid          integer         DEFAULT '0'     NOT NULL,
        table_name              varchar(64)             DEFAULT ''      NOT NULL,
        field_name              varchar(64)             DEFAULT ''      NOT NULL,
        nextid          bigint unsigned         DEFAULT '0'     NOT NULL,
        PRIMARY KEY (nodeid,table_name,field_name)
) type=InnoDB;