CREATE TABLE [dbo].[SMS_MESSAGES] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[SMS_DIRECT] [int] NULL CONSTRAINT [DF_SMS_MESSAGES_SMS_DIRECT] DEFAULT (0),
	[SMS_PHONE] [char] (50) NOT NULL ,
	[SMS_TEXT] [text] NULL ,
	[SMS_TIME] [datetime] NOT NULL CONSTRAINT [DF_SMS_MESSAGES_SMS_TIME] DEFAULT (getdate()),
	[SMS_VP] [int] NOT NULL CONSTRAINT [DF_SMS_MESSAGES_SMS_VP] DEFAULT (0),
	[SMS_STATE] [int] NOT NULL CONSTRAINT [DF_SMS_MESSAGES_SMS_STATE] DEFAULT (0),
	[SMS_PRIORITY] [int] NOT NULL CONSTRAINT [DF_SMS_MESSAGES_SMS_PRIORITY] DEFAULT (1),
	[F_REQ_STATUS] [int] NULL CONSTRAINT [DF_SMS_MESSAGES_F_REQ_STATUS] DEFAULT (0),
	[F_USSD] [int] NULL CONSTRAINT [DF_SMS_MESSAGES_F_USSD] DEFAULT (0),
	[F_WAIT_SUBMIT] [int] CONSTRAINT [DF_SMS_MESSAGES_F_WAIT_SUBMIT] DEFAULT (0),
	[GROUP_ID] [int] NULL CONSTRAINT [DF_SMS_MESSAGES_GROUP_ID] DEFAULT (0),
	[GROUP_COUNT] [int] NULL CONSTRAINT [DF_SMS_MESSAGES_GROUP_COUNT] DEFAULT (0),
	[GROUP_INDEX] [int] NULL CONSTRAINT [DF_SMS_MESSAGES_GROUP_INDEX] DEFAULT (0),
	[MODULE_ID] [int] NULL CONSTRAINT [DF_SMS_MESSAGES_MODULE_ID] DEFAULT (0),
	[MODULE_HANDLE] [int] NULL CONSTRAINT [DF_SMS_MESSAGES_MODULE_HANDLE] DEFAULT (0),
	[RULE_ID] [int] NULL  CONSTRAINT [DF_SMS_MESSAGES_RULE_ID] DEFAULT (0),
	[CUSTOM_ID] [char] (255) NULL,
	[ERR_CODE] [int] NULL CONSTRAINT [DF_SMS_MESSAGES_ERR_CODE] DEFAULT (0),
	[TIME_SMSC] [datetime] NULL,
	[TIME_SEND_START] [datetime] NULL,
	[TIME_SEND_STOP] [datetime] NULL,
	[TIME_STATUS_REPORT] [datetime] NULL,
	[EDT] [datetime] NULL CONSTRAINT [DF_SMS_MESSAGES_EDT] DEFAULT (getdate()),
	CONSTRAINT [PK_SMS_MESSAGES] PRIMARY KEY  CLUSTERED
	(
		[ID]
	)  ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [SMS_MESSAGES_SMS_TIME] ON [dbo].[SMS_MESSAGES]( [SMS_TIME])
GO
CREATE NONCLUSTERED INDEX [SMS_MESSAGES_CUSTOM_ID] ON [dbo].[SMS_MESSAGES]( [CUSTOM_ID])
GO