diff options
| author | Christophe Romain <christophe.romain@process-one.net> | 2017-02-22 11:09:15 +0100 |
|---|---|---|
| committer | Christophe Romain <christophe.romain@process-one.net> | 2017-02-22 15:47:36 +0100 |
| commit | 56df6e7ba83ee615296691696f638dfc89dd4da8 (patch) | |
| tree | f540cf0c7228c2794870ebb8167c55ea43ea6547 /sql/mssql.sql | |
| parent | Move archive tables into lite.sql for better comparison with other schemas (diff) | |
Add missing NOT NULL restrictions
Diffstat (limited to '')
| -rw-r--r-- | sql/mssql.sql | 36 |
1 files changed, 18 insertions, 18 deletions
diff --git a/sql/mssql.sql b/sql/mssql.sql index 7925fd92d..a3b814e02 100644 --- a/sql/mssql.sql +++ b/sql/mssql.sql @@ -182,11 +182,11 @@ WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW CREATE TABLE [dbo].[pubsub_item] (
[nodeid] [bigint] NULL,
- [itemid] [varchar] (255) NULL,
- [publisher] [text] NULL,
- [creation] [text] NULL,
- [modification] [varchar] (255) NULL,
- [payload] [text] NULL
+ [itemid] [varchar] (255) NOT NULL,
+ [publisher] [text] NOT NULL,
+ [creation] [text] NOT NULL,
+ [modification] [varchar] (255) NOT NULL,
+ [payload] [text] NOT NULL DEFAULT ''
) TEXTIMAGE_ON [PRIMARY];
CREATE INDEX [pubsub_item_itemid] ON [pubsub_item] (itemid)
@@ -197,8 +197,8 @@ WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW CREATE TABLE [dbo].[pubsub_node_option] (
[nodeid] [bigint] NULL,
- [name] [text] NULL,
- [val] [text] NULL
+ [name] [text] NOT NULL,
+ [val] [text] NOT NULL
) TEXTIMAGE_ON [PRIMARY];
CREATE CLUSTERED INDEX [pubsub_node_option_nodeid] ON [pubsub_node_option] (nodeid)
@@ -206,7 +206,7 @@ WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW CREATE TABLE [dbo].[pubsub_node_owner] (
[nodeid] [bigint] NULL,
- [owner] [text] NULL
+ [owner] [text] NOT NULL
) TEXTIMAGE_ON [PRIMARY];
CREATE CLUSTERED INDEX [pubsub_node_owner_nodeid] ON [pubsub_node_owner] (nodeid)
@@ -214,9 +214,9 @@ WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW CREATE TABLE [dbo].[pubsub_state] (
[nodeid] [bigint] NULL,
- [jid] [varchar] (255) NULL,
- [affiliation] [char] (1) NULL,
- [subscriptions] [text] NULL,
+ [jid] [varchar] (255) NOT NULL,
+ [affiliation] [char] (1) NOT NULL,
+ [subscriptions] [text] NOT NULL DEFAULT '',
[stateid] [bigint] IDENTITY(1,1) NOT NULL,
CONSTRAINT [pubsub_state_PRIMARY] PRIMARY KEY CLUSTERED
(
@@ -231,19 +231,19 @@ CREATE UNIQUE INDEX [pubsub_state_nodeid_jid] ON [pubsub_state] (nodeid, jid) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON);
CREATE TABLE [dbo].[pubsub_subscription_opt] (
- [subid] [varchar] (255) NULL,
- [opt_name] [varchar] (32) NULL,
- [opt_value] [text] NULL
+ [subid] [varchar] (255) NOT NULL,
+ [opt_name] [varchar] (32) NOT NULL,
+ [opt_value] [text] NOT NULL
) TEXTIMAGE_ON [PRIMARY];
CREATE UNIQUE CLUSTERED INDEX [pubsub_subscription_opt_subid_opt_name] ON [pubsub_subscription_opt] (subid, opt_name)
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON);
CREATE TABLE [dbo].[pubsub_node] (
- [host] [varchar] (255) NULL,
- [node] [varchar] (255) NULL,
- [parent] [varchar] (255) NULL,
- [type] [text] NULL,
+ [host] [varchar] (255) NOT NULL,
+ [node] [varchar] (255) NOT NULL,
+ [parent] [varchar] (255) NOT NULL DEFAULT '',
+ [type] [text] NOT NULL,
[nodeid] [bigint] IDENTITY(1,1) NOT NULL,
CONSTRAINT [pubsub_node_PRIMARY] PRIMARY KEY CLUSTERED
(
|