diff options
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); |