aboutsummaryrefslogtreecommitdiffstats
path: root/install/schema_mysql.sql
diff options
context:
space:
mode:
authorredmatrix <redmatrix@redmatrix.me>2015-09-28 04:15:21 -0700
committerredmatrix <redmatrix@redmatrix.me>2015-09-28 04:15:21 -0700
commitedbcba6f113a5c8b709cdbfca892e845b5096ede (patch)
treeb66d328d5f4c77c9d7d0bdcd704c72639e22a8b7 /install/schema_mysql.sql
parented876a9c529f59fa62bb45805aa4f355fe0e2c0d (diff)
downloadvolse-hubzilla-edbcba6f113a5c8b709cdbfca892e845b5096ede.tar.gz
volse-hubzilla-edbcba6f113a5c8b709cdbfca892e845b5096ede.tar.bz2
volse-hubzilla-edbcba6f113a5c8b709cdbfca892e845b5096ede.zip
schema support for additional site types
Diffstat (limited to 'install/schema_mysql.sql')
-rw-r--r--install/schema_mysql.sql4
1 files changed, 3 insertions, 1 deletions
diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql
index c78259e41..0e626752d 100644
--- a/install/schema_mysql.sql
+++ b/install/schema_mysql.sql
@@ -1131,6 +1131,7 @@ CREATE TABLE IF NOT EXISTS `site` (
`site_realm` char(255) NOT NULL DEFAULT '',
`site_valid` smallint NOT NULL DEFAULT '0',
`site_dead` smallint NOT NULL DEFAULT '0',
+ `site_type` smallint NOT NULL DEFAULT '0',
PRIMARY KEY (`site_url`),
KEY `site_flags` (`site_flags`),
KEY `site_update` (`site_update`),
@@ -1141,7 +1142,8 @@ CREATE TABLE IF NOT EXISTS `site` (
KEY `site_pull` (`site_pull`),
KEY `site_realm` (`site_realm`),
KEY `site_valid` (`site_valid`),
- KEY `site_dead` (`site_dead`)
+ KEY `site_dead` (`site_dead`),
+ KEY `site_type` (`site_type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `source` (