1 

     2 CREATE TABLE [dbo].[queue](

     3 	[queue_id] [int] IDENTITY(1,1) NOT NULL,

     4 	[queue_name] [varchar](100) NOT NULL,

     5 	[timeout] [int] NOT NULL,

     6  CONSTRAINT [PK_queue] PRIMARY KEY CLUSTERED 

     7 (

     8 	[queue_id] ASC

     9 )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

    10 ) ON [PRIMARY]

    11 

    12 GO

    13 

    14 ALTER TABLE [dbo].[queue] ADD  DEFAULT ((30)) FOR [timeout]

    15 GO

    16 

    17 

    18 CREATE TABLE [dbo].[message](

    19 	[message_id] [bigint] IDENTITY(1,1) NOT NULL,

    20 	[queue_id] [int] NOT NULL,

    21 	[handle] [char](32) NULL,

    22 	[body] [varchar](max) NOT NULL,

    23 	[md5] [char](32) NOT NULL,

    24 	[timeout] [decimal](14, 4) NULL,

    25 	[created] [int] NOT NULL,

    26  CONSTRAINT [PK_message] PRIMARY KEY CLUSTERED 

    27 (

    28 	[message_id] ASC

    29 )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

    30 ) ON [PRIMARY]

    31 

    32 GO

    33 

    34 ALTER TABLE [dbo].[message]  WITH CHECK ADD  CONSTRAINT [fk_message_queue_id] FOREIGN KEY([queue_id])

    35 REFERENCES [dbo].[queue] ([queue_id])

    36 GO

    37 

    38 ALTER TABLE [dbo].[message] CHECK CONSTRAINT [fk_message_queue_id]

    39 GO

    40 

    41 

    42 

    43 

    44