diff options
| author | redmatrix <redmatrix@redmatrix.me> | 2015-11-11 15:13:01 -0800 |
|---|---|---|
| committer | redmatrix <redmatrix@redmatrix.me> | 2015-11-11 15:13:01 -0800 |
| commit | f7c837aad0ac08bdc8cc4f8a770c973dda641a28 (patch) | |
| tree | a23f752d5da7c86594326b92a5e44d3ce49ccee1 | |
| parent | bd3d32384956f8c5c7ca2624c96f47bb66d8958c (diff) | |
| parent | 52f6bd03b7da71671df79eed2819dd066c5e9f8b (diff) | |
| download | volse-hubzilla-f7c837aad0ac08bdc8cc4f8a770c973dda641a28.tar.gz volse-hubzilla-f7c837aad0ac08bdc8cc4f8a770c973dda641a28.tar.bz2 volse-hubzilla-f7c837aad0ac08bdc8cc4f8a770c973dda641a28.zip | |
Merge https://github.com/redmatrix/hubzilla into pending_merge
| -rw-r--r-- | install/schema_postgres.sql | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql index 70a7a576a..d60e1bc69 100644 --- a/install/schema_postgres.sql +++ b/install/schema_postgres.sql @@ -342,8 +342,8 @@ create index "conv_created_idx" on conv ("created"); create index "conv_updated_idx" on conv ("updated"); CREATE TABLE IF NOT EXISTS "dreport" ( - "dreport_id" int(11) NOT NULL, - "dreport_channel" int(11) NOT NULL DEFAULT '0', + "dreport_id" int NOT NULL, + "dreport_channel" int NOT NULL DEFAULT '0', "dreport_mid" char(255) NOT NULL DEFAULT '', "dreport_site" char(255) NOT NULL DEFAULT '', "dreport_recip" char(255) NOT NULL DEFAULT '', @@ -388,7 +388,7 @@ CREATE TABLE "event" ( "deny_gid" text NOT NULL, "event_status" char(255) NOT NULL DEFAULT '', "event_status_date" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', - "event_percent" smallint(6) NOT NULL DEFAULT '0', + "event_percent" smallint NOT NULL DEFAULT '0', "event_repeat" text NOT NULL, "event_sequence" smallint NOT NULL DEFAULT '0', "event_priority" smallint NOT NULL DEFAULT '0', @@ -623,7 +623,7 @@ CREATE TABLE "item" ( "item_retained" smallint NOT NULL DEFAULT '0', "item_rss" smallint NOT NULL DEFAULT '0', "item_deleted" smallint NOT NULL DEFAULT '0', - "item_type" int(11) NOT NULL DEFAULT '0', + "item_type" int NOT NULL DEFAULT '0', "item_hidden" smallint NOT NULL DEFAULT '0', "item_unpublished" smallint NOT NULL DEFAULT '0', "item_delayed" smallint NOT NULL DEFAULT '0', @@ -918,11 +918,11 @@ CREATE TABLE "photo" ( "data" bytea NOT NULL, "scale" numeric(3) NOT NULL, "profile" numeric(1) NOT NULL DEFAULT '0', - "photo_usage" smallint(6) NOT NULL DEFAULT '0', + "photo_usage" smallint NOT NULL DEFAULT '0', "is_nsfw" smallint NOT NULL DEFAULT '0', "os_storage" smallint NOT NULL DEFAULT '0', - "os_path" mediumtext NOT NULL, - "display_path" mediumtext NOT NULL, + "os_path" text NOT NULL, + "display_path" text NOT NULL, "photo_flags" bigint NOT NULL DEFAULT '0', "allow_cid" text NOT NULL, "allow_gid" text NOT NULL, |