diff options
| author | redmatrix <redmatrix@redmatrix.me> | 2015-09-01 17:06:58 -0700 |
|---|---|---|
| committer | redmatrix <redmatrix@redmatrix.me> | 2015-09-01 17:06:58 -0700 |
| commit | 3852b5ce7fe83cce93c0826a92c378a589bc8664 (patch) | |
| tree | 26b3d216c9f4fb284d64902a593c5b66a31e47ab /install/schema_postgres.sql | |
| parent | 1447499776ce07bf48b76435a23de704952e6aa2 (diff) | |
| download | volse-hubzilla-3852b5ce7fe83cce93c0826a92c378a589bc8664.tar.gz volse-hubzilla-3852b5ce7fe83cce93c0826a92c378a589bc8664.tar.bz2 volse-hubzilla-3852b5ce7fe83cce93c0826a92c378a589bc8664.zip | |
separate objs/things from taxonomy
Diffstat (limited to 'install/schema_postgres.sql')
| -rw-r--r-- | install/schema_postgres.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql index c594d0f87..4c307a7f0 100644 --- a/install/schema_postgres.sql +++ b/install/schema_postgres.sql @@ -812,6 +812,11 @@ CREATE TABLE "obj" ( "obj_type" bigint NOT NULL DEFAULT '0', "obj_obj" text NOT NULL DEFAULT '', "obj_channel" bigint NOT NULL DEFAULT '0', + "obj_term" char(255) NOT NULL DEFAULT '', + "obj_url" char(255) NOT NULL DEFAULT '', + "obj_imgurl" char(255) NOT NULL DEFAULT '', + "obj_created" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', + "obj_edited" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "allow_cid" text NOT NULL, "allow_gid" text NOT NULL, "deny_cid" text NOT NULL, @@ -824,6 +829,11 @@ create index "obj_page" on obj ("obj_page"); create index "obj_type" on obj ("obj_type"); create index "obj_channel" on obj ("obj_channel"); create index "obj_obj" on obj ("obj_obj"); +create index "obj_term" on obj ("obj_term"); +create index "obj_url" on obj ("obj_url"); +create index "obj_imgurl" on obj ("obj_imgurl"); +create index "obj_created" on obj ("obj_created"); +create index "obj_edited" on obj ("obj_edited"); CREATE TABLE "outq" ( "outq_hash" text NOT NULL, |