blob: f8005884a9d6084834ccf7d01d52df1ac7b9871b (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
IF NOT EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[plugin_manager]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
CREATE TABLE [plugin_manager] (
[id] int NOT NULL IDENTITY(1,1),
[conf] nvarchar(MAX) NOT NULL,
[value] nvarchar(MAX),
[type] nvarchar(MAX),
PRIMARY KEY ([id])
)
GO
IF NOT EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[system]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
CREATE TABLE [system] (
[name] nvarchar(64) NOT NULL,
[value] nvarchar(MAX),
PRIMARY KEY([name])
)
GO
INSERT INTO [system] (name, value) VALUES ('myrc_plugin_manager', 'initial|20131209')
GO
|
