From 44700d91ba270a251b512c0b7ad8e4c4d8962ad2 Mon Sep 17 00:00:00 2001
From: Christophe Romain <christophe.romain@process-one.net>
Date: Thu, 16 Nov 2017 11:38:04 +0100
Subject: PubSub: Cleanup tree requests, rename
 pubsub_node.type->pubsub_node.plugin

---
 sql/lite.sql   | 2 +-
 sql/mssql.sql  | 2 +-
 sql/mysql.sql  | 2 +-
 sql/pg.new.sql | 2 +-
 sql/pg.sql     | 2 +-
 5 files changed, 5 insertions(+), 5 deletions(-)

(limited to 'sql')

diff --git a/sql/lite.sql b/sql/lite.sql
index b0c8675f5..e9d2ac6f2 100644
--- a/sql/lite.sql
+++ b/sql/lite.sql
@@ -203,7 +203,7 @@ CREATE TABLE pubsub_node (
   host text NOT NULL,
   node text NOT NULL,
   parent text NOT NULL DEFAULT '',
-  type text NOT NULL,
+  plugin text NOT NULL,
   nodeid INTEGER PRIMARY KEY AUTOINCREMENT
 );
 CREATE INDEX i_pubsub_node_parent ON pubsub_node (parent);
diff --git a/sql/mssql.sql b/sql/mssql.sql
index 83b219298..8a24bd5d5 100644
--- a/sql/mssql.sql
+++ b/sql/mssql.sql
@@ -279,7 +279,7 @@ CREATE TABLE [dbo].[pubsub_node] (
         [host] [varchar] (255) NOT NULL,
         [node] [varchar] (255) NOT NULL,
         [parent] [varchar] (255) NOT NULL DEFAULT '',
-        [type] [text] NOT NULL,
+        [plugin] [text] NOT NULL,
         [nodeid] [bigint] IDENTITY(1,1) NOT NULL,
  CONSTRAINT [pubsub_node_PRIMARY] PRIMARY KEY CLUSTERED 
 (
diff --git a/sql/mysql.sql b/sql/mysql.sql
index acf2bfe1a..3e34bbb32 100644
--- a/sql/mysql.sql
+++ b/sql/mysql.sql
@@ -215,7 +215,7 @@ CREATE TABLE pubsub_node (
   host text NOT NULL,
   node text NOT NULL,
   parent VARCHAR(191) NOT NULL DEFAULT '',
-  type text NOT NULL,
+  plugin text NOT NULL,
   nodeid bigint auto_increment primary key
 ) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
 CREATE INDEX i_pubsub_node_parent ON pubsub_node(parent(120));
diff --git a/sql/pg.new.sql b/sql/pg.new.sql
index b155a4223..feb334779 100644
--- a/sql/pg.new.sql
+++ b/sql/pg.new.sql
@@ -396,7 +396,7 @@ CREATE TABLE pubsub_node (
   host text NOT NULL,
   node text NOT NULL,
   parent text NOT NULL DEFAULT '',
-  "type" text NOT NULL,
+  plugin text NOT NULL,
   nodeid SERIAL UNIQUE
 );
 CREATE INDEX i_pubsub_node_parent ON pubsub_node USING btree (parent);
diff --git a/sql/pg.sql b/sql/pg.sql
index fd56ba39d..48f4a85d4 100644
--- a/sql/pg.sql
+++ b/sql/pg.sql
@@ -221,7 +221,7 @@ CREATE TABLE pubsub_node (
   host text NOT NULL,
   node text NOT NULL,
   parent text NOT NULL DEFAULT '',
-  "type" text NOT NULL,
+  plugin text NOT NULL,
   nodeid SERIAL UNIQUE
 );
 CREATE INDEX i_pubsub_node_parent ON pubsub_node USING btree (parent);
-- 
cgit v1.2.3