aboutsummaryrefslogtreecommitdiffstats
path: root/install/schema_mysql.sql
diff options
context:
space:
mode:
authorzotlabs <mike@macgirvin.com>2017-10-22 19:32:08 -0700
committerzotlabs <mike@macgirvin.com>2017-10-22 19:32:08 -0700
commitc49eec71f0995cd75be99a64a4dde398f9f0241b (patch)
tree06e29769c32460299d9c73794028e657e362b6e2 /install/schema_mysql.sql
parentcdb1bc9be6fbc09caff62c0153386cc58a2bfbd9 (diff)
parentb58bf75f21d15ac440bb3a90edb29afac9eb64ba (diff)
downloadvolse-hubzilla-c49eec71f0995cd75be99a64a4dde398f9f0241b.tar.gz
volse-hubzilla-c49eec71f0995cd75be99a64a4dde398f9f0241b.tar.bz2
volse-hubzilla-c49eec71f0995cd75be99a64a4dde398f9f0241b.zip
Merge branch 'dev' of https://github.com/redmatrix/hubzilla into dev_merge
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 ,