Subversion Repositories oidplus

Rev

Go to most recent revision | Blame | Compare with Previous | Last modification | View Log | RSS feed

  1. SET ANSI_NULLS ON
  2. GO
  3.  
  4. SET QUOTED_IDENTIFIER ON
  5. GO
  6.  
  7. SET ANSI_PADDING ON
  8. GO
  9.  
  10. /**********************************************/
  11.  
  12. IF OBJECT_ID('dbo.config', 'U') IS NOT NULL /*Backwards compatibility*/
  13.         DROP TABLE /*IF EXISTS*/ [dbo].[config];
  14. CREATE TABLE [dbo].[config](
  15.         [name] [nvarchar](50) NOT NULL,
  16.         [VALUE] [ntext] NOT NULL,
  17.         [description] [nvarchar](255) NULL,
  18.         [protected] [bit] NOT NULL DEFAULT ('0'),
  19.         [visible] [bit] NOT NULL DEFAULT ('0'),
  20.         CONSTRAINT [PK_config] PRIMARY KEY CLUSTERED
  21.         (
  22.                 [name] ASC
  23.         )
  24. )
  25. GO
  26.  
  27. /**********************************************/
  28.  
  29. IF OBJECT_ID('dbo.asn1id', 'U') IS NOT NULL /*Backwards compatibility*/
  30.         DROP TABLE /*IF EXISTS*/ [dbo].[asn1id];
  31. CREATE TABLE [dbo].[asn1id](
  32.         [lfd] [INT] IDENTITY(1,1) NOT NULL,
  33.         [oid] [nvarchar](255) COLLATE German_PhoneBook_CS_AS NOT NULL,
  34.         [name] [nvarchar](255) NOT NULL,
  35.         [standardized] [bit] NOT NULL CONSTRAINT [DF__asn1id__standardized]  DEFAULT ('0'),
  36.         [well_known] [bit] NOT NULL CONSTRAINT [DF__asn1id__well_known]  DEFAULT ('0'),
  37.         CONSTRAINT [PK_asn1id] PRIMARY KEY CLUSTERED
  38.         (
  39.                 [lfd] ASC
  40.         ),
  41.         INDEX [IX_asn1id_oid_name] NONCLUSTERED
  42.         (
  43.                 [oid] ASC,
  44.                 [name] ASC
  45.         )
  46. )
  47. GO
  48.  
  49. /**********************************************/
  50.  
  51. IF OBJECT_ID('dbo.iri', 'U') IS NOT NULL /*Backwards compatibility*/
  52.         DROP TABLE /*IF EXISTS*/ [dbo].[iri];
  53. CREATE TABLE [dbo].[iri](
  54.         [lfd] [INT] IDENTITY(1,1) NOT NULL,
  55.         [oid] [nvarchar](255) COLLATE German_PhoneBook_CS_AS NOT NULL,
  56.         [name] [nvarchar](255) NOT NULL,
  57.         [longarc] [bit] NOT NULL CONSTRAINT [DF__iri__longarc]  DEFAULT ('0'),
  58.         [well_known] [bit] NOT NULL CONSTRAINT [DF__iri__well_known]  DEFAULT ('0'),
  59.         CONSTRAINT [PK_iri] PRIMARY KEY CLUSTERED
  60.         (
  61.                 [lfd] ASC
  62.         ),
  63.         INDEX [IX_iri_oid_name] NONCLUSTERED
  64.         (
  65.                 [oid] ASC,
  66.                 [name] ASC
  67.         )
  68. )
  69. GO
  70.  
  71. /**********************************************/
  72.  
  73. IF OBJECT_ID('dbo.objects', 'U') IS NOT NULL /*Backwards compatibility*/
  74.         DROP TABLE /*IF EXISTS*/ [dbo].[objects];
  75. CREATE TABLE [dbo].[objects](
  76.         [id] [nvarchar](255) COLLATE German_PhoneBook_CS_AS NOT NULL,
  77.         [parent] [nvarchar](255) COLLATE German_PhoneBook_CS_AS NULL,
  78.         [title] [nvarchar](255) NULL,
  79.         [description] [ntext] NULL,
  80.         [ra_email] [nvarchar](100) NULL,
  81.         [confidential] [bit] NOT NULL,
  82.         [created] [datetime] NULL,
  83.         [updated] [datetime] NULL,
  84.         [comment] [nvarchar](255) NULL,
  85.         CONSTRAINT [PK_objects] PRIMARY KEY CLUSTERED
  86.         (
  87.                 [id] ASC
  88.         ),
  89.         INDEX [IX_objects_parent] NONCLUSTERED
  90.         (
  91.                 [parent] ASC
  92.         ),
  93.         INDEX [IX_objects_ra_email] NONCLUSTERED
  94.         (
  95.                 [ra_email] ASC
  96.         )
  97. )
  98. GO
  99.  
  100. /**********************************************/
  101.  
  102. IF OBJECT_ID('dbo.ra', 'U') IS NOT NULL /*Backwards compatibility*/
  103.         DROP TABLE /*IF EXISTS*/ [dbo].[ra];
  104. CREATE TABLE [dbo].[ra](
  105.         [ra_id] [INT] IDENTITY(1,1) NOT NULL,
  106.         [email] [nvarchar](100) NOT NULL,
  107.         [ra_name] [nvarchar](100) NULL,
  108.         [personal_name] [nvarchar](100) NULL,
  109.         [organization] [nvarchar](100) NULL,
  110.         [office] [nvarchar](100) NULL,
  111.         [street] [nvarchar](100) NULL,
  112.         [zip_town] [nvarchar](100) NULL,
  113.         [country] [nvarchar](100) NULL,
  114.         [phone] [nvarchar](100) NULL,
  115.         [mobile] [nvarchar](100) NULL,
  116.         [fax] [nvarchar](100) NULL,
  117.         [privacy] [bit] NOT NULL CONSTRAINT [DF__ra__privacy]  DEFAULT ('0'),
  118.         [authkey] [nvarchar](250) NULL,
  119.         [registered] [datetime] NULL,
  120.         [updated] [datetime] NULL,
  121.         [last_login] [datetime] NULL,
  122.         CONSTRAINT [PK_ra] PRIMARY KEY CLUSTERED
  123.         (
  124.                 [ra_id] ASC
  125.         ),
  126.         CONSTRAINT [IX_ra_email] UNIQUE (
  127.                 [email] ASC
  128.         )
  129. )
  130. GO
  131.  
  132. /**********************************************/
  133.  
  134. IF OBJECT_ID('dbo.log', 'U') IS NOT NULL /*Backwards compatibility*/
  135.         DROP TABLE /*IF EXISTS*/ [dbo].[log];
  136. CREATE TABLE [dbo].[log](
  137.         [id] [INT] IDENTITY(1,1) NOT NULL,
  138.         [unix_ts] [BIGINT] NOT NULL,
  139.         [addr] [nvarchar](45) NOT NULL,
  140.         [event] [ntext] NOT NULL,
  141.         CONSTRAINT [PK_log] PRIMARY KEY CLUSTERED
  142.         (
  143.                 [id] ASC
  144.         )
  145. )
  146. GO
  147.  
  148. /**********************************************/
  149.  
  150. IF OBJECT_ID('dbo.log_user', 'U') IS NOT NULL /*Backwards compatibility*/
  151.         DROP TABLE /*IF EXISTS*/ [dbo].[log_user];
  152. CREATE TABLE [dbo].[log_user](
  153.         [id] [INT] IDENTITY(1,1) NOT NULL,
  154.         [log_id] [INT] NOT NULL,
  155.         [username] [nvarchar](255) NOT NULL,
  156.         [severity] [INT] NOT NULL,
  157.         CONSTRAINT [PK_log_user] PRIMARY KEY CLUSTERED
  158.         (
  159.                 [id] ASC
  160.         ),
  161.         INDEX [IX_log_user_log_id] NONCLUSTERED
  162.         (
  163.                 [log_id] ASC
  164.         ),
  165.         INDEX [IX_log_user_username] NONCLUSTERED
  166.         (
  167.                 [username] ASC
  168.         ),
  169.         CONSTRAINT [IX_log_user_log_id_username] UNIQUE
  170.         (
  171.                 [log_id],
  172.                 [username]
  173.         )
  174. )
  175. GO
  176.  
  177. /**********************************************/
  178.  
  179. IF OBJECT_ID('dbo.log_object', 'U') IS NOT NULL /*Backwards compatibility*/
  180.         DROP TABLE /*IF EXISTS*/ [dbo].[log_object];
  181. CREATE TABLE [dbo].[log_object](
  182.         [id] [INT] IDENTITY(1,1) NOT NULL,
  183.         [log_id] [INT] NOT NULL,
  184.         [object] [nvarchar](255) COLLATE German_PhoneBook_CS_AS NOT NULL,
  185.         [severity] [INT] NOT NULL,
  186.         CONSTRAINT [PK_log_object] PRIMARY KEY CLUSTERED
  187.         (
  188.                 [id] ASC
  189.         ),
  190.         INDEX [IX_log_object_log_id] NONCLUSTERED
  191.         (
  192.                 [log_id] ASC
  193.         ),
  194.         INDEX [IX_log_object_object] NONCLUSTERED
  195.         (
  196.                 [object] ASC
  197.         ),
  198.         CONSTRAINT [IX_log_object_log_id_object] UNIQUE
  199.         (
  200.                 [log_id],
  201.                 [object]
  202.         )
  203. )
  204. GO
  205.  
  206.  
  207. /****** Set database version ******/
  208.  
  209. INSERT INTO [config] (name, description, VALUE, protected, visible) VALUES ('database_version', 'Version of the database tables', '1002', '1', '0');
  210.  
  211. SET ANSI_PADDING OFF
  212. GO
  213.