wagtailcore_site
Data license: MIT
1 row where root_page_id = 3
This data as json, CSV (advanced)
| id ▼ | hostname | port | is_default_site | root_page_id | site_name |
|---|---|---|---|---|---|
| 3 | www.from-inception.com | 443 | 1 | Home 3 | from-inception.com |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "wagtailcore_site" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "hostname" varchar(255) NOT NULL, "port" integer NOT NULL, "is_default_site" bool NOT NULL, "root_page_id" integer NOT NULL REFERENCES "wagtailcore_page" ("id") DEFERRABLE INITIALLY DEFERRED, "site_name" varchar(255) NOT NULL);
CREATE UNIQUE INDEX "wagtailcore_site_hostname_port_2c626d70_uniq" ON "wagtailcore_site" ("hostname", "port");
CREATE INDEX "wagtailcore_site_hostname_96b20b46" ON "wagtailcore_site" ("hostname");
CREATE INDEX "wagtailcore_site_root_page_id_e02fb95c" ON "wagtailcore_site" ("root_page_id");