diff options
| author | friendica <info@friendica.com> | 2012-08-09 20:34:10 -0700 |
|---|---|---|
| committer | friendica <info@friendica.com> | 2012-08-09 20:34:10 -0700 |
| commit | 8c0ac63d8a890eff9e8f5eeb3c6c9443c71f0e98 (patch) | |
| tree | 77a7dfea704130692498cb72b79a37ed6d268d96 /database.sql | |
| parent | 26e29d7f885f929793b9f0720fde8843e7bf8d6d (diff) | |
| download | volse-hubzilla-8c0ac63d8a890eff9e8f5eeb3c6c9443c71f0e98.tar.gz volse-hubzilla-8c0ac63d8a890eff9e8f5eeb3c6c9443c71f0e98.tar.bz2 volse-hubzilla-8c0ac63d8a890eff9e8f5eeb3c6c9443c71f0e98.zip | |
hubloc schema changes
Diffstat (limited to 'database.sql')
| -rw-r--r-- | database.sql | 16 |
1 files changed, 11 insertions, 5 deletions
diff --git a/database.sql b/database.sql index f67d083af..dfa039559 100644 --- a/database.sql +++ b/database.sql @@ -263,6 +263,7 @@ CREATE TABLE IF NOT EXISTS `event` ( `type` char(255) NOT NULL, `nofinish` tinyint(1) NOT NULL DEFAULT '0', `adjust` tinyint(1) NOT NULL DEFAULT '1', + `ignore` tinyint(1) NOT NULL DEFAULT '0', `allow_cid` mediumtext NOT NULL, `allow_gid` mediumtext NOT NULL, `deny_cid` mediumtext NOT NULL, @@ -275,7 +276,8 @@ CREATE TABLE IF NOT EXISTS `event` ( KEY `start` (`start`), KEY `finish` (`finish`), KEY `adjust` (`adjust`), - KEY `nofinish` (`nofinish`) + KEY `nofinish` (`nofinish`), + KEY `ignore` (`ignore`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `fcontact` ( @@ -414,12 +416,16 @@ CREATE TABLE IF NOT EXISTS `hook` ( CREATE TABLE IF NOT EXISTS `hubloc` ( `hubloc_id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `hubloc_zuid` char(255) NOT NULL, - `hubloc_url` char(255) NOT NULL, + `hubloc_guid` char(255) NOT NULL DEFAULT '', + `hubloc_primary` tinyint(3) unsigned NOT NULL DEFAULT '0', + `hubloc_url` char(255) NOT NULL DEFAULT '', + `hubloc_callback` char(255) NOT NULL DEFAULT '', + `hubloc_sitekey` text NOT NULL, `hubloc_key` text NOT NULL, PRIMARY KEY (`hubloc_id`), - KEY `hubloc_zuid` (`hubloc_zuid`), - KEY `hubloc_url` (`hubloc_url`) + KEY `hubloc_url` (`hubloc_url`), + KEY `hubloc_primary` (`hubloc_primary`), + KEY `hubloc_guid` (`hubloc_guid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `intro` ( |