diff options
| author | Christophe Romain <christophe.romain@process-one.net> | 2017-11-16 11:38:04 +0100 |
|---|---|---|
| committer | Christophe Romain <christophe.romain@process-one.net> | 2017-11-16 11:38:04 +0100 |
| commit | 44700d91ba270a251b512c0b7ad8e4c4d8962ad2 (patch) | |
| tree | 42b16f2b8a333ed1638fd345802a1d3ac1abac7a /sql | |
| parent | Let validator know about c2s_dhfile (diff) | |
PubSub: Cleanup tree requests, rename pubsub_node.type->pubsub_node.plugin
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/lite.sql | 2 | ||||
| -rw-r--r-- | sql/mssql.sql | 2 | ||||
| -rw-r--r-- | sql/mysql.sql | 2 | ||||
| -rw-r--r-- | sql/pg.new.sql | 2 | ||||
| -rw-r--r-- | sql/pg.sql | 2 |
5 files changed, 5 insertions, 5 deletions
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); |