1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
|
-- $Id$
--
-- MSSQL schema for DHCP for FreeRADIUS
--
-- To load:
-- isql -S db_ip_addr -d db_name -U db_login -P db_passwd -i schema.sql
--
-- Table structure for table 'dhcpgroupreply'
--
CREATE TABLE [dhcpgroupreply] (
[id] [int] IDENTITY (1, 1) NOT NULL,
[GroupName] [varchar] (64) NOT NULL,
[Attribute] [varchar] (32) NOT NULL,
[Value] [varchar] (253) NOT NULL,
[op] [char] (2) NULL,
[prio] [int] NOT NULL,
[Context] [varchar] (16) NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dhcpgroupreply] WITH NOCHECK ADD
CONSTRAINT [DF_dhcpgroupreply_GroupName] DEFAULT ('') FOR [GroupName],
CONSTRAINT [DF_dhcpgroupreply_Attribute] DEFAULT ('') FOR [Attribute],
CONSTRAINT [DF_dhcpgroupreply_Value] DEFAULT ('') FOR [Value],
CONSTRAINT [DF_dhcpgroupreply_op] DEFAULT (null) FOR [op],
CONSTRAINT [DF_dhcpgroupreply_prio] DEFAULT (0) FOR [prio],
CONSTRAINT [DF_dhcpgroupreply_context] DEFAULT ('') FOR [Context],
CONSTRAINT [PK_dhcpgroupreply] PRIMARY KEY NONCLUSTERED
(
[id]
) ON [PRIMARY]
GO
CREATE INDEX [GroupName] ON [dhcpgroupreply]([Context],[GroupName]) ON [PRIMARY]
GO
--
-- Table structure for table 'dhcpreply'
--
CREATE TABLE [dhcpreply] (
[id] [int] IDENTITY (1, 1) NOT NULL,
[Identifier] [varchar] (64) NOT NULL,
[Attribute] [varchar] (32) NOT NULL,
[Value] [varchar] (253) NOT NULL,
[op] [char] (2) NULL,
[Context] [varchar] (16) NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dhcpreply] WITH NOCHECK ADD
CONSTRAINT [DF_dhcpreply_Identifier] DEFAULT ('') FOR [Identifier],
CONSTRAINT [DF_dhcpreply_Attribute] DEFAULT ('') FOR [Attribute],
CONSTRAINT [DF_dhcpreply_Value] DEFAULT ('') FOR [Value],
CONSTRAINT [DF_dhcpreply_op] DEFAULT (null) FOR [op],
CONSTRAINT [DF_dhcpreply_Context] DEFAULT ('') FOR [Context],
CONSTRAINT [PK_dhcpreply] PRIMARY KEY NONCLUSTERED
(
[id]
) ON [PRIMARY]
GO
CREATE INDEX [Identifier] ON [dhcpreply]([Context],[Identifier]) ON [PRIMARY]
GO
--
-- Table structure for table 'dhcpgroup'
--
CREATE TABLE [dhcpgroup] (
[id] [int] IDENTITY (1, 1) NOT NULL,
[Identifier] [varchar] (64) NOT NULL,
[GroupName] [varchar] (64) NULL,
[Priority] [int] NULL,
[Context] [varchar] (16) NULL
) ON [PRIMARY]
GO
ALTER TABLE [dhcpgroup] WITH NOCHECK ADD
CONSTRAINT [DF_dhcpgroup_Identifier] DEFAULT ('') FOR [Identifier],
CONSTRAINT [DF_dhcpgroup_GroupName] DEFAULT ('') FOR [GroupName],
CONSTRAINT [DF_dhcpgroup_Context] DEFAULT ('') FOR [Context],
CONSTRAINT [PK_dhcpgroup] PRIMARY KEY NONCLUSTERED
(
[id]
) ON [PRIMARY]
GO
CREATE INDEX [Identifier] ON [dhcpgroup]([Context],[Identifier]) ON [PRIMARY]
GO
|