diff options
| author | Daniel Frank <github-523@danielfrank.net> | 2015-02-26 23:50:46 +0100 |
|---|---|---|
| committer | Daniel Frank <github-523@danielfrank.net> | 2015-02-26 23:50:46 +0100 |
| commit | 32e4d4633ad78f322364f9558c017582be27a76c (patch) | |
| tree | 791535723440b10f1a9c95514b9881d30e100071 /install/schema_postgres.sql | |
| parent | 4162dfe43fa5bee7c0847d4b3a0e4e0ddba12976 (diff) | |
| download | volse-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
Diffstat (limited to 'install/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"); |