diff options
| author | redmatrix <git@macgirvin.com> | 2016-02-17 16:24:26 -0800 |
|---|---|---|
| committer | redmatrix <git@macgirvin.com> | 2016-02-17 16:24:26 -0800 |
| commit | 4da7fcb41dd97669305551914964df57ffc22ee7 (patch) | |
| tree | b2fc2a5c702374caf2f4a27df66b751acf035bfb /install/schema_postgres.sql | |
| parent | 3a84e7051e70ac9c26ec705155ac4020d9a64f62 (diff) | |
| download | volse-hubzilla-4da7fcb41dd97669305551914964df57ffc22ee7.tar.gz volse-hubzilla-4da7fcb41dd97669305551914964df57ffc22ee7.tar.bz2 volse-hubzilla-4da7fcb41dd97669305551914964df57ffc22ee7.zip | |
schema updates for iconfig
Diffstat (limited to 'install/schema_postgres.sql')
| -rw-r--r-- | install/schema_postgres.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql index 5cabbc2c9..2d9bffdec 100644 --- a/install/schema_postgres.sql +++ b/install/schema_postgres.sql @@ -538,6 +538,17 @@ create index "hubloc_primary" on hubloc ("hubloc_primary"); create index "hubloc_orphancheck" on hubloc ("hubloc_orphancheck"); create index "hubloc_error" on hubloc ("hubloc_error"); create index "hubloc_deleted" on hubloc ("hubloc_deleted"); +CREATE TABLE "iconfig" ( + "id" serial NOT NULL, + "iid" bigint NOT NULL DEFAULT '0', + "cat" text NOT NULL DEFAULT '', + "k" text NOT NULL DEFAULT '', + "v" text NOT NULL DEFAULT '', + PRIMARY_KEY("id") +); +create index "iconfig_iid" on iconfig ("iid"); +create index "iconfig_cat" on iconfig ("cat"); +create index "iconfig_k" on iconfig ("k"); CREATE TABLE "issue" ( "issue_id" serial NOT NULL, "issue_created" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', |