File indexing completed on 2025-01-19 05:21:24
0001 0002 CREATE TABLE [dbo].[queue]( 0003 [queue_id] [int] IDENTITY(1,1) NOT NULL, 0004 [queue_name] [varchar](100) NOT NULL, 0005 [timeout] [int] NOT NULL, 0006 CONSTRAINT [PK_queue] PRIMARY KEY CLUSTERED 0007 ( 0008 [queue_id] ASC 0009 )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] 0010 ) ON [PRIMARY] 0011 0012 GO 0013 0014 ALTER TABLE [dbo].[queue] ADD DEFAULT ((30)) FOR [timeout] 0015 GO 0016 0017 0018 CREATE TABLE [dbo].[message]( 0019 [message_id] [bigint] IDENTITY(1,1) NOT NULL, 0020 [queue_id] [int] NOT NULL, 0021 [handle] [char](32) NULL, 0022 [body] [varchar](max) NOT NULL, 0023 [md5] [char](32) NOT NULL, 0024 [timeout] [decimal](14, 4) NULL, 0025 [created] [int] NOT NULL, 0026 CONSTRAINT [PK_message] PRIMARY KEY CLUSTERED 0027 ( 0028 [message_id] ASC 0029 )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] 0030 ) ON [PRIMARY] 0031 0032 GO 0033 0034 ALTER TABLE [dbo].[message] WITH CHECK ADD CONSTRAINT [fk_message_queue_id] FOREIGN KEY([queue_id]) 0035 REFERENCES [dbo].[queue] ([queue_id]) 0036 GO 0037 0038 ALTER TABLE [dbo].[message] CHECK CONSTRAINT [fk_message_queue_id] 0039 GO 0040 0041 0042 0043 0044