aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/share/sql/mssql-CreateAssetsTable.sql
diff options
context:
space:
mode:
Diffstat (limited to 'share/sql/mssql-CreateAssetsTable.sql')
-rw-r--r--share/sql/mssql-CreateAssetsTable.sql19
1 files changed, 0 insertions, 19 deletions
diff --git a/share/sql/mssql-CreateAssetsTable.sql b/share/sql/mssql-CreateAssetsTable.sql
deleted file mode 100644
index c7cb21a..0000000
--- a/share/sql/mssql-CreateAssetsTable.sql
+++ /dev/null
@@ -1,19 +0,0 @@
1SET ANSI_NULLS ON
2SET QUOTED_IDENTIFIER ON
3SET ANSI_PADDING ON
4CREATE TABLE [assets] (
5 [id] [varchar](36) NOT NULL,
6 [name] [varchar](64) NOT NULL,
7 [description] [varchar](64) NOT NULL,
8 [assetType] [tinyint] NOT NULL,
9 [invType] [tinyint] NOT NULL,
10 [local] [tinyint] NOT NULL,
11 [temporary] [tinyint] NOT NULL,
12 [data] [image] NOT NULL,
13PRIMARY KEY CLUSTERED
14(
15 [id] ASC
16)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
17) ON [PRIMARY]
18
19SET ANSI_PADDING OFF