diff options
| author | nobody <nobody@zotlabs.com> | 2021-05-31 14:36:14 -0700 |
|---|---|---|
| committer | nobody <nobody@zotlabs.com> | 2021-05-31 14:36:14 -0700 |
| commit | 462980c70a2698490d97a481cee0f2500dacb91c (patch) | |
| tree | 4935db45ad6fbe37cd0af3b93bbb20ecb656c752 /install/schema_postgres.sql | |
| parent | a96345401f47be71a6eef531e204c0e25b792a16 (diff) | |
| parent | 217168628421f4e394b9b85e33d2d653d8b5b3d6 (diff) | |
| download | volse-hubzilla-462980c70a2698490d97a481cee0f2500dacb91c.tar.gz volse-hubzilla-462980c70a2698490d97a481cee0f2500dacb91c.tar.bz2 volse-hubzilla-462980c70a2698490d97a481cee0f2500dacb91c.zip | |
Merge branch 'dev' of https://framagit.org/hubzilla/core into dev
Diffstat (limited to 'install/schema_postgres.sql')
| -rw-r--r-- | install/schema_postgres.sql | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql index 52b44bd07..c18cc087b 100644 --- a/install/schema_postgres.sql +++ b/install/schema_postgres.sql @@ -506,6 +506,7 @@ CREATE TABLE "hubloc" ( create index "hubloc_url" on hubloc ("hubloc_url"); create index "hubloc_site_id" on hubloc ("hubloc_site_id"); create index "hubloc_guid" on hubloc ("hubloc_guid"); +create index "hubloc_hash" on hubloc ("hubloc_hash"); create index "hubloc_id_url" on hubloc ("hubloc_id_url"); create index "hubloc_flags" on hubloc ("hubloc_flags"); create index "hubloc_connect" on hubloc ("hubloc_connect"); @@ -1099,9 +1100,9 @@ CREATE TABLE "register" ( "reg_did2" text DEFAULT '' NOT NULL, "reg_hash" text DEFAULT '' NOT NULL, "reg_email" text DEFAULT '' NOT NULL, - "reg_created" timestamp NOT NULL, - "reg_startup" timestamp NOT NULL, - "reg_expires" timestamp NOT NULL, + "reg_created" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', + "reg_startup" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', + "reg_expires" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "reg_byc" bigint DEFAULT 0 NOT NULL, "reg_uid" bigint DEFAULT 0 NOT NULL, "reg_atip" text DEFAULT '' NOT NULL, |