WebSVN – oidplus – Diff – /trunk/setup/sql/struct_mssql.sql



        DROP TABLE /*IF EXISTS*/ [dbo].[asn1id];
CREATE TABLE [dbo].[asn1id](
        [lfd] [INT] IDENTITY(1,1) NOT NULL,
        [oid] [VARCHAR](255) NOT NULL,
        [name] [VARCHAR](255) NOT NULL,
        [standardized] [bit] NOT NULL CONSTRAINT [DF__asn1id__standardized]  DEFAULT ('0'),
        [well_known] [bit] NOT NULL CONSTRAINT [DF__asn1id__well_known]  DEFAULT ('0'),
        CONSTRAINT [PK_asn1id] PRIMARY KEY CLUSTERED
        (
                [lfd] ASC
        ),
        INDEX [IX_asn1id_oid_name] NONCLUSTERED

        DROP TABLE /*IF EXISTS*/ [dbo].[iri];
CREATE TABLE [dbo].[iri](
        [lfd] [INT] IDENTITY(1,1) NOT NULL,
        [oid] [VARCHAR](255) NOT NULL,
        [name] [VARCHAR](255) NOT NULL,
        [longarc] [bit] NOT NULL CONSTRAINT [DF__iri__longarc]  DEFAULT ('0'),
        [well_known] [bit] NOT NULL CONSTRAINT [DF__iri__well_known]  DEFAULT ('0'),
        CONSTRAINT [PK_iri] PRIMARY KEY CLUSTERED
        (
                [lfd] ASC
        ),
        INDEX [IX_iri_oid_name] NONCLUSTERED

        ),
        INDEX [IX_objects_parent] NONCLUSTERED
        (
                [parent] ASC
        ),
        INDEX [IX_objects_ra_email] NONCLUSTERED
        (
                [ra_email] ASC
        )
)
GO

        [zip_town] [VARCHAR](100) NOT NULL,
        [country] [VARCHAR](100) NOT NULL,
        [phone] [VARCHAR](100) NOT NULL,
        [mobile] [VARCHAR](100) NOT NULL,
        [fax] [VARCHAR](100) NOT NULL,
        [privacy] [bit] NOT NULL CONSTRAINT [DF__ra__privacy]  DEFAULT ('0'),
        [salt] [VARCHAR](100) NOT NULL,
        [authkey] [VARCHAR](100) NOT NULL,
        [registered] [datetime] NULL,
        [updated] [datetime] NULL,
        [last_login] [datetime] NULL,

        [username] [VARCHAR](255) NOT NULL,
        CONSTRAINT [PK_log_user] PRIMARY KEY CLUSTERED
        (
                [id] ASC
        ),
        INDEX [IX_log_user_log_id] NONCLUSTERED
        (
                [log_id] ASC
        ),
        INDEX [IX_log_user_username] NONCLUSTERED
        (
                [username] ASC
        ),
        CONSTRAINT [IX_log_object_log_id_username] UNIQUE
        (
                [log_id],
                [username]
        )
)

        [object] [VARCHAR](255) NOT NULL,
        CONSTRAINT [PK_log_object] PRIMARY KEY CLUSTERED
        (
                [id] ASC
        ),
        INDEX [IX_log_object_log_id] NONCLUSTERED
        (
                [log_id] ASC
        ),
        INDEX [IX_log_object_object] NONCLUSTERED
        (
                [object] ASC
        ),
        CONSTRAINT [IX_log_object_log_id_object] UNIQUE
        (
                [log_id],
                [object]
        )
)

Rev 273	Rev 276
Line 74...	Line 74...
74	DROP TABLE /IF EXISTS/ [dbo].[asn1id];	74	DROP TABLE /IF EXISTS/ [dbo].[asn1id];
75	CREATE TABLE [dbo].[asn1id](	75	CREATE TABLE [dbo].[asn1id](
76	[lfd] [INT] IDENTITY(1,1) NOT NULL,	76	[lfd] [INT] IDENTITY(1,1) NOT NULL,
77	[oid] [VARCHAR](255) NOT NULL,	77	[oid] [VARCHAR](255) NOT NULL,
78	[name] [VARCHAR](255) NOT NULL,	78	[name] [VARCHAR](255) NOT NULL,
79	[standardized] [bit] NOT NULL CONSTRAINT [DF__asn1id__standard__21B6055D] DEFAULT ('0'),	79	[standardized] [bit] NOT NULL CONSTRAINT [DF__asn1id__standardized] DEFAULT ('0'),
80	[well_known] [bit] NOT NULL CONSTRAINT [DF__asn1id__well_kno__22AA2996] DEFAULT ('0'),	80	[well_known] [bit] NOT NULL CONSTRAINT [DF__asn1id__well_known] DEFAULT ('0'),
81	CONSTRAINT [PK_asn1id] PRIMARY KEY CLUSTERED	81	CONSTRAINT [PK_asn1id] PRIMARY KEY CLUSTERED
82	(	82	(
83	[lfd] ASC	83	[lfd] ASC
84	),	84	),
85	INDEX [IX_asn1id_oid_name] NONCLUSTERED	85	INDEX [IX_asn1id_oid_name] NONCLUSTERED
Line 96...	Line 96...
96	DROP TABLE /IF EXISTS/ [dbo].[iri];	96	DROP TABLE /IF EXISTS/ [dbo].[iri];
97	CREATE TABLE [dbo].[iri](	97	CREATE TABLE [dbo].[iri](
98	[lfd] [INT] IDENTITY(1,1) NOT NULL,	98	[lfd] [INT] IDENTITY(1,1) NOT NULL,
99	[oid] [VARCHAR](255) NOT NULL,	99	[oid] [VARCHAR](255) NOT NULL,
100	[name] [VARCHAR](255) NOT NULL,	100	[name] [VARCHAR](255) NOT NULL,
101	[longarc] [bit] NOT NULL CONSTRAINT [DF__iri__longarc__24927208] DEFAULT ('0'),	101	[longarc] [bit] NOT NULL CONSTRAINT [DF__iri__longarc] DEFAULT ('0'),
102	[well_known] [bit] NOT NULL CONSTRAINT [DF__iri__well_known__25869641] DEFAULT ('0'),	102	[well_known] [bit] NOT NULL CONSTRAINT [DF__iri__well_known] DEFAULT ('0'),
103	CONSTRAINT [PK_iri] PRIMARY KEY CLUSTERED	103	CONSTRAINT [PK_iri] PRIMARY KEY CLUSTERED
104	(	104	(
105	[lfd] ASC	105	[lfd] ASC
106	),	106	),
107	INDEX [IX_iri_oid_name] NONCLUSTERED	107	INDEX [IX_iri_oid_name] NONCLUSTERED
Line 132...	Line 132...
132	),	132	),
133	INDEX [IX_objects_parent] NONCLUSTERED	133	INDEX [IX_objects_parent] NONCLUSTERED
134	(	134	(
135	[parent] ASC	135	[parent] ASC
136	),	136	),
137	INDEX [IX_objects_ra_email] NONCLUSTERED /* TODO: add to other DBMS structs */	137	INDEX [IX_objects_ra_email] NONCLUSTERED
138	(	138	(
139	[ra_email] ASC	139	[ra_email] ASC
140	)	140	)
141	)	141	)
142	GO	142	GO
Line 156...	Line 156...
156	[zip_town] [VARCHAR](100) NOT NULL,	156	[zip_town] [VARCHAR](100) NOT NULL,
157	[country] [VARCHAR](100) NOT NULL,	157	[country] [VARCHAR](100) NOT NULL,
158	[phone] [VARCHAR](100) NOT NULL,	158	[phone] [VARCHAR](100) NOT NULL,
159	[mobile] [VARCHAR](100) NOT NULL,	159	[mobile] [VARCHAR](100) NOT NULL,
160	[fax] [VARCHAR](100) NOT NULL,	160	[fax] [VARCHAR](100) NOT NULL,
161	[privacy] [bit] NOT NULL CONSTRAINT [DF__ra__privacy__29572725] DEFAULT ('0'),	161	[privacy] [bit] NOT NULL CONSTRAINT [DF__ra__privacy] DEFAULT ('0'),
162	[salt] [VARCHAR](100) NOT NULL,	162	[salt] [VARCHAR](100) NOT NULL,
163	[authkey] [VARCHAR](100) NOT NULL,	163	[authkey] [VARCHAR](100) NOT NULL,
164	[registered] [datetime] NULL,	164	[registered] [datetime] NULL,
165	[updated] [datetime] NULL,	165	[updated] [datetime] NULL,
166	[last_login] [datetime] NULL,	166	[last_login] [datetime] NULL,
Line 200...	Line 200...
200	[username] [VARCHAR](255) NOT NULL,	200	[username] [VARCHAR](255) NOT NULL,
201	CONSTRAINT [PK_log_user] PRIMARY KEY CLUSTERED	201	CONSTRAINT [PK_log_user] PRIMARY KEY CLUSTERED
202	(	202	(
203	[id] ASC	203	[id] ASC
204	),	204	),
205	INDEX [IX_log_user_log_id] NONCLUSTERED /* TODO: add to other DBMS structs */	205	INDEX [IX_log_user_log_id] NONCLUSTERED
206	(	206	(
207	[log_id] ASC	207	[log_id] ASC
208	),	208	),
209	INDEX [IX_log_user_username] NONCLUSTERED /* TODO: add to other DBMS structs */	209	INDEX [IX_log_user_username] NONCLUSTERED
210	(	210	(
211	[username] ASC	211	[username] ASC
212	),	212	),
213	CONSTRAINT [IX_log_object_log_id_username] UNIQUE /* TODO: add to other DBMS structs */	213	CONSTRAINT [IX_log_object_log_id_username] UNIQUE
214	(	214	(
215	[log_id],	215	[log_id],
216	[username]	216	[username]
217	)	217	)
218	)	218	)
Line 228...	Line 228...
228	[object] [VARCHAR](255) NOT NULL,	228	[object] [VARCHAR](255) NOT NULL,
229	CONSTRAINT [PK_log_object] PRIMARY KEY CLUSTERED	229	CONSTRAINT [PK_log_object] PRIMARY KEY CLUSTERED
230	(	230	(
231	[id] ASC	231	[id] ASC
232	),	232	),
233	INDEX [IX_log_object_log_id] NONCLUSTERED /* TODO: add to other DBMS structs */	233	INDEX [IX_log_object_log_id] NONCLUSTERED
234	(	234	(
235	[log_id] ASC	235	[log_id] ASC
236	),	236	),
237	INDEX [IX_log_object_object] NONCLUSTERED /* TODO: add to other DBMS structs */	237	INDEX [IX_log_object_object] NONCLUSTERED
238	(	238	(
239	[object] ASC	239	[object] ASC
240	),	240	),
241	CONSTRAINT [IX_log_object_log_id_object] UNIQUE /* TODO: add to other DBMS structs */	241	CONSTRAINT [IX_log_object_log_id_object] UNIQUE
242	(	242	(
243	[log_id],	243	[log_id],
244	[object]	244	[object]
245	)	245	)
246	)	246	)

Subversion Repositories oidplus

oidplus/trunk/setup/sql/struct_mssql.sql – Rev 273 → 276