aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorredmatrix <redmatrix@redmatrix.me>2015-11-11 15:13:01 -0800
committerredmatrix <redmatrix@redmatrix.me>2015-11-11 15:13:01 -0800
commitf7c837aad0ac08bdc8cc4f8a770c973dda641a28 (patch)
treea23f752d5da7c86594326b92a5e44d3ce49ccee1
parentbd3d32384956f8c5c7ca2624c96f47bb66d8958c (diff)
parent52f6bd03b7da71671df79eed2819dd066c5e9f8b (diff)
downloadvolse-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.sql14
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,