CREATE TABLE [dbo].[topic_view]
(
[topic_view_id] [int] NOT NULL IDENTITY(1, 1) NOT FOR REPLICATION,
[topic_id] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[username] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[track_msg_id] [int] NOT NULL,
[start_time] [datetime] NOT NULL,
[end_time] [datetime] NOT NULL,
[view_time_span] [int] NOT NULL,
[play_mode] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[score] [int] NULL,
[passed] [tinyint] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[topic_view] ADD CONSTRAINT [pk_topic_view2] PRIMARY KEY CLUSTERED ([topic_view_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_topic_end_time] ON [dbo].[topic_view] ([end_time]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_topic_play_mode] ON [dbo].[topic_view] ([play_mode]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_topic_start_time] ON [dbo].[topic_view] ([start_time]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_topic_id] ON [dbo].[topic_view] ([topic_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_topic_username] ON [dbo].[topic_view] ([username]) ON [PRIMARY]
GO