diff options
| author | redmatrix <redmatrix@redmatrix.me> | 2015-08-31 20:55:25 -0700 |
|---|---|---|
| committer | redmatrix <redmatrix@redmatrix.me> | 2015-08-31 20:55:25 -0700 |
| commit | d7cf7316beaecc6efacc01d56dbb066af8174416 (patch) | |
| tree | 49a556c5055a0c75646e53ffb867da4aec08496e /install/schema_postgres.sql | |
| parent | 96c61fc5f26af06bf43ecae0819c095141e18db7 (diff) | |
| download | volse-hubzilla-d7cf7316beaecc6efacc01d56dbb066af8174416.tar.gz volse-hubzilla-d7cf7316beaecc6efacc01d56dbb066af8174416.tar.bz2 volse-hubzilla-d7cf7316beaecc6efacc01d56dbb066af8174416.zip | |
change the likes db structure to make it more easily importable/exportable
Diffstat (limited to 'install/schema_postgres.sql')
| -rw-r--r-- | install/schema_postgres.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql index 9bda284ac..0b8ed52dc 100644 --- a/install/schema_postgres.sql +++ b/install/schema_postgres.sql @@ -602,6 +602,7 @@ CREATE TABLE "likes" ( "liker" char(128) NOT NULL DEFAULT '', "likee" char(128) NOT NULL DEFAULT '', "iid" bigint NOT NULL DEFAULT '0', + "i_mid" char(255) NOT NULL DEFAULT '', "verb" text NOT NULL DEFAULT '', "target_type" text NOT NULL DEFAULT '', "target_id" char(128) NOT NULL DEFAULT '', @@ -612,6 +613,7 @@ create index "likes_channel_id" on likes ("channel_id"); create index "likes_liker" on likes ("liker"); create index "likes_likee" on likes ("likee"); create index "likes_iid" on likes ("iid"); +create index "likes_i_mid" on likes ("i_mid"); create index "likes_verb" on likes ("verb"); create index "likes_target_type" on likes ("target_type"); create index "likes_target_id" on likes ("target_id"); |