diff options
| author | RedMatrix <info@friendica.com> | 2015-02-27 10:14:46 +1100 |
|---|---|---|
| committer | RedMatrix <info@friendica.com> | 2015-02-27 10:14:46 +1100 |
| commit | b79d2420520d72b878982f3b98052c0f816af83e (patch) | |
| tree | 791535723440b10f1a9c95514b9881d30e100071 | |
| parent | 4162dfe43fa5bee7c0847d4b3a0e4e0ddba12976 (diff) | |
| parent | 32e4d4633ad78f322364f9558c017582be27a76c (diff) | |
| download | volse-hubzilla-b79d2420520d72b878982f3b98052c0f816af83e.tar.gz volse-hubzilla-b79d2420520d72b878982f3b98052c0f816af83e.tar.bz2 volse-hubzilla-b79d2420520d72b878982f3b98052c0f816af83e.zip | |
Merge pull request #911 from tokudan/patch-1
fix issues in schema_postgres.sql
| -rw-r--r-- | install/schema_postgres.sql | 4 |
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"); |