aboutsummaryrefslogtreecommitdiffstats
path: root/install/schema_mysql.sql
diff options
context:
space:
mode:
authorMario Vavti <mario@mariovavti.com>2017-10-20 10:08:57 +0200
committerMario Vavti <mario@mariovavti.com>2017-10-20 10:08:57 +0200
commitc80f4feb6234ff195171a92704d7ebe24aff4336 (patch)
treed9149141f52e3758afe1dfa8387bbd8229de1cc9 /install/schema_mysql.sql
parent2d06e86b5b99af3a5e6c65f4c510bdeaddd5126a (diff)
parent400441d56b21e69663ea7213ccf63fe0ee6a6bab (diff)
downloadvolse-hubzilla-c80f4feb6234ff195171a92704d7ebe24aff4336.tar.gz
volse-hubzilla-c80f4feb6234ff195171a92704d7ebe24aff4336.tar.bz2
volse-hubzilla-c80f4feb6234ff195171a92704d7ebe24aff4336.zip
Merge remote-tracking branch 'mike/master' into dev
Diffstat (limited to 'install/schema_mysql.sql')
-rw-r--r--install/schema_mysql.sql13
1 files changed, 13 insertions, 0 deletions
diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql
index 3143854f5..afa3c095d 100644
--- a/install/schema_mysql.sql
+++ b/install/schema_mysql.sql
@@ -900,6 +900,19 @@ CREATE TABLE IF NOT EXISTS `outq` (
KEY `outq_priority` (`outq_priority`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+
+CREATE TABLE IF NOT EXISTS pchan (
+ `pchan_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
+ `pchan_guid` char(191) NOT NULL DEFAULT '',
+ `pchan_hash` char(191) NOT NULL DEFAULT '',
+ `pchan_pubkey` text NOT NULL,
+ `pchan_prvkey` text NOT NULL,
+ PRIMARY KEY (`pchan_id`),
+ KEY `pchan_guid` (`pchan_guid`),
+ KEY `pchan_hash` (`pchan_hash`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+
+
CREATE TABLE IF NOT EXISTS `pconfig` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL DEFAULT 0 ,