X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=db%2Fsite.sql;h=791303bd540885857f0f2baef805994684b8261a;hb=7bbdea10327dfd5cd059337e4f2d3d5f21d909da;hp=660ba475bb586edff429a7c271e8f434c96c2e96;hpb=e34011f1bd862bc0e68ce7dc49aea39dcd164a4e;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'