diff options
| author | Haakon Meland Eriksen <haakon.eriksen@far.no> | 2015-09-19 11:35:31 +0200 |
|---|---|---|
| committer | Haakon Meland Eriksen <haakon.eriksen@far.no> | 2015-09-19 11:35:31 +0200 |
| commit | 5a7e8d8520601b3c08ef15c520da19d05b31d23b (patch) | |
| tree | d6f91b9982f80d7db26beb8be953ca8f3325af85 /install/schema_mysql.sql | |
| parent | 1bd1050160efd88483a50c3a2a239e2160048924 (diff) | |
| parent | 63146821d7f28107ca34fbe581dcc3abf6fd49fe (diff) | |
| download | volse-hubzilla-5a7e8d8520601b3c08ef15c520da19d05b31d23b.tar.gz volse-hubzilla-5a7e8d8520601b3c08ef15c520da19d05b31d23b.tar.bz2 volse-hubzilla-5a7e8d8520601b3c08ef15c520da19d05b31d23b.zip | |
Merge remote-tracking branch 'upstream/master'
Diffstat (limited to 'install/schema_mysql.sql')
| -rw-r--r-- | install/schema_mysql.sql | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql index 1793f89c2..3bb3b7133 100644 --- a/install/schema_mysql.sql +++ b/install/schema_mysql.sql @@ -350,6 +350,23 @@ CREATE TABLE IF NOT EXISTS `conv` ( KEY `updated` (`updated`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; +CREATE TABLE IF NOT EXISTS `dreport` ( + `dreport_id` int(11) NOT NULL AUTO_INCREMENT, + `dreport_channel` int(11) NOT NULL DEFAULT '0', + `dreport_mid` char(255) NOT NULL DEFAULT '', + `dreport_site` char(255) NOT NULL DEFAULT '', + `dreport_recip` char(255) NOT NULL DEFAULT '', + `dreport_result` char(255) NOT NULL DEFAULT '', + `dreport_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', + `dreport_xchan` char(255) NOT NULL DEFAULT '', + PRIMARY KEY (`dreport_id`), + KEY `dreport_mid` (`dreport_mid`), + KEY `dreport_site` (`dreport_site`), + KEY `dreport_time` (`dreport_time`), + KEY `dreport_xchan` (`dreport_xchan`), + KEY `dreport_channel` (`dreport_channel`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + CREATE TABLE IF NOT EXISTS `event` ( `id` int(11) NOT NULL AUTO_INCREMENT, `aid` int(10) unsigned NOT NULL DEFAULT '0', |