summaryrefslogtreecommitdiffstats
path: root/upgrades/dbpatches/1.3/postgresql/patch/ids.sql
diff options
context:
space:
mode:
Diffstat (limited to 'upgrades/dbpatches/1.3/postgresql/patch/ids.sql')
-rw-r--r--upgrades/dbpatches/1.3/postgresql/patch/ids.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/upgrades/dbpatches/1.3/postgresql/patch/ids.sql b/upgrades/dbpatches/1.3/postgresql/patch/ids.sql
new file mode 100644
index 00000000..9080273f
--- /dev/null
+++ b/upgrades/dbpatches/1.3/postgresql/patch/ids.sql
@@ -0,0 +1,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;