diff options
| author | Magnus Hagander | 2021-10-23 14:02:41 +0000 |
|---|---|---|
| committer | Magnus Hagander | 2021-10-23 14:03:50 +0000 |
| commit | 524558856c3e96de30473689381136d2c8c3094d (patch) | |
| tree | 1159656ffdeeb615495781b526908c6c1d43818e /tools | |
| parent | 8b0cb45180187d19f5ad833bfd12e1ad6e2b4188 (diff) | |
Add baseurl field to sites table in the search system
This table isn't used beyond a single row at this time, so there is a
lot to be done for simplifying things around it, but for a quick-fix
just add the field that actually should be there.
Spotted by Célestin Matte
Diffstat (limited to 'tools')
| -rw-r--r-- | tools/search/sql/schema.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/tools/search/sql/schema.sql b/tools/search/sql/schema.sql index ad8fca33..dd63311f 100644 --- a/tools/search/sql/schema.sql +++ b/tools/search/sql/schema.sql @@ -23,6 +23,7 @@ ALTER TABLE messages ADD CONSTRAINT pk_messages PRIMARY KEY (list,year,month,msg CREATE TABLE sites ( id int NOT NULL PRIMARY KEY, hostname text NOT NULL UNIQUE, + baseurl text NOT NULL, description text NOT NULL, https boolean NOT NULL DEFAULT 'f', pagecount int NOT NULL |