diff options
| author | redmatrix <git@macgirvin.com> | 2016-05-30 19:44:30 -0700 |
|---|---|---|
| committer | redmatrix <git@macgirvin.com> | 2016-05-30 19:44:30 -0700 |
| commit | 6602ff83dd54d0e17c985a5f527654fc2ed83eea (patch) | |
| tree | 920d7fa37f10786e806e847cf6b59b20a42e7cb8 /install/schema_postgres.sql | |
| parent | 490ab9e2c593275c0cf3d705a4ae52c6a22db4d9 (diff) | |
| download | volse-hubzilla-6602ff83dd54d0e17c985a5f527654fc2ed83eea.tar.gz volse-hubzilla-6602ff83dd54d0e17c985a5f527654fc2ed83eea.tar.bz2 volse-hubzilla-6602ff83dd54d0e17c985a5f527654fc2ed83eea.zip | |
start removing reserved words from database column names (this run: addon and hook)
Diffstat (limited to 'install/schema_postgres.sql')
| -rw-r--r-- | install/schema_postgres.sql | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql index e2c078dc1..76a3a013e 100644 --- a/install/schema_postgres.sql +++ b/install/schema_postgres.sql @@ -94,16 +94,16 @@ create index "account_level" on account ("account_level"); create index "account_password_changed" on account ("account_password_changed"); CREATE TABLE "addon" ( "id" serial NOT NULL, - "name" text NOT NULL, + "aname" text NOT NULL, "version" text NOT NULL DEFAULT '0', "installed" numeric(1) NOT NULL DEFAULT '0', "hidden" numeric(1) NOT NULL DEFAULT '0', - "timestamp" numeric(20) NOT NULL DEFAULT '0', + "tstamp" numeric(20) NOT NULL DEFAULT '0', "plugin_admin" numeric(1) NOT NULL DEFAULT '0', PRIMARY KEY ("id") ); create index "addon_hidden_idx" on addon ("hidden"); -create index "addon_name_idx" on addon ("name"); +create index "addon_name_idx" on addon ("aname"); create index "addon_installed_idx" on addon ("installed"); CREATE TABLE "app" ( "id" serial NOT NULL, @@ -514,7 +514,7 @@ CREATE TABLE "hook" ( "id" serial NOT NULL, "hook" text NOT NULL, "file" text NOT NULL, - "function" text NOT NULL, + "fn" text NOT NULL, "priority" bigint NOT NULL DEFAULT '0', "hook_version" smallint NOT NULL DEFAULT '0', PRIMARY KEY ("id") |