X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=db%2Fsite.sql;h=791303bd540885857f0f2baef805994684b8261a;hb=839592524783a686b4c5410ba5e273617132df06;hp=660ba475bb586edff429a7c271e8f434c96c2e96;hpb=e5094c3359fb74caeea474f8e08eb0d15b477652;p=quix0rs-gnu-social.git diff --git a/db/site.sql b/db/site.sql index 660ba475bb..791303bd54 100644 --- a/db/site.sql +++ b/db/site.sql @@ -5,12 +5,18 @@ create table status_network ( nickname varchar(64) primary key comment 'nickname', hostname varchar(255) unique key comment 'alternate hostname if any', pathname varchar(255) unique key comment 'alternate pathname if any', - sitename varchar(255) comment 'display name', + dbhost varchar(255) comment 'database host', dbuser varchar(255) comment 'database username', dbpass varchar(255) comment 'database password', dbname varchar(255) comment 'database name', + sitename varchar(255) comment 'display name', + theme varchar(255) comment 'theme name', + logo varchar(255) comment 'site logo', + + tags text comment 'site meta-info tags (pipe-separated)', + created datetime not null comment 'date this record was created', modified timestamp comment 'date this record was modified'