diff options
| author | redmatrix <redmatrix@redmatrix.me> | 2015-10-15 18:52:04 -0700 |
|---|---|---|
| committer | redmatrix <redmatrix@redmatrix.me> | 2015-10-15 18:52:04 -0700 |
| commit | 93f061f78a8b914a731838058a38354a62d002de (patch) | |
| tree | a2444956ccadaad1ef5dcda1a98364bbc987d3a9 /install/schema_postgres.sql | |
| parent | 7517c76ae48ddad741fe61c41dd6dcc09421d160 (diff) | |
| download | volse-hubzilla-93f061f78a8b914a731838058a38354a62d002de.tar.gz volse-hubzilla-93f061f78a8b914a731838058a38354a62d002de.tar.bz2 volse-hubzilla-93f061f78a8b914a731838058a38354a62d002de.zip | |
mail sync/migrate continued; also abstract delivery loop to make it re-usable, change refresh_all to use delivery loop.
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 f378a3e3d..f42f6b297 100644 --- a/install/schema_postgres.sql +++ b/install/schema_postgres.sql @@ -728,6 +728,7 @@ create index "likes_target_id" on likes ("target_id"); CREATE TABLE "mail" ( "id" serial NOT NULL, "convid" bigint NOT NULL DEFAULT '0', + "conv_guid" text NOT NULL, "mail_flags" bigint NOT NULL DEFAULT '0', "from_xchan" text NOT NULL DEFAULT '', "to_xchan" text NOT NULL DEFAULT '', @@ -750,6 +751,7 @@ CREATE TABLE "mail" ( PRIMARY KEY ("id") ); create index "mail_convid" on mail ("convid"); +create index "mail_conv_guid" on mail ("conv_guid"); create index "mail_created" on mail ("created"); create index "mail_flags" on mail ("mail_flags"); create index "mail_account_id" on mail ("account_id"); |