aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorDaniel Frank <github-523@danielfrank.net>2015-02-26 23:50:46 +0100
committerDaniel Frank <github-523@danielfrank.net>2015-02-26 23:50:46 +0100
commit32e4d4633ad78f322364f9558c017582be27a76c (patch)
tree791535723440b10f1a9c95514b9881d30e100071
parent4162dfe43fa5bee7c0847d4b3a0e4e0ddba12976 (diff)
downloadvolse-hubzilla-32e4d4633ad78f322364f9558c017582be27a76c.tar.gz
volse-hubzilla-32e4d4633ad78f322364f9558c017582be27a76c.tar.bz2
volse-hubzilla-32e4d4633ad78f322364f9558c017582be27a76c.zip
fix issues in schema_postgres.sql
- change PRIMARY_KEY to PRIMARY KEY - replace smallint(1) with smallint
-rw-r--r--install/schema_postgres.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql
index 1370f3b8a..44b8f16a4 100644
--- a/install/schema_postgres.sql
+++ b/install/schema_postgres.sql
@@ -528,7 +528,7 @@ CREATE TABLE "item" (
"item_restrict" bigint NOT NULL DEFAULT '0',
"item_flags" bigint NOT NULL DEFAULT '0',
"item_private" numeric(4) NOT NULL DEFAULT '0',
- "item_unseen" smallint(1) NOT NULL DEFAULT '0',
+ "item_unseen" smallint NOT NULL DEFAULT '0',
"item_search_vector" tsvector,
PRIMARY KEY ("id")
);
@@ -1163,7 +1163,7 @@ CREATE TABLE "xperm" (
"xp_client" varchar( 20 ) NOT NULL DEFAULT '',
"xp_channel" bigint NOT NULL DEFAULT '0',
"xp_perm" varchar( 64 ) NOT NULL DEFAULT '',
- PRIMARY_KEY ("xp_id")
+ PRIMARY KEY ("xp_id")
);
create index "xp_client" on xperm ("xp_client");
create index "xp_channel" on xperm ("xp_channel");