4chan archiver tables

USE [4ch]
GO

/****** Object:  Table [dbo].[word]    Script Date: 20.10.2021 18:33:00 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[word](
    [word] [varchar](255) NULL,
    [counter] [int] NULL,
    [word_excluded] [bit] NULL
) ON [PRIMARY]
GO


USE [4ch]
GO

/****** Object:  Table [dbo].[webpage]    Script Date: 20.10.2021 18:32:49 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[webpage](
    [webpage] [varchar](max) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO


USE [4ch]
GO

/****** Object:  Table [dbo].[thread]    Script Date: 20.10.2021 18:32:33 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[thread](
    [thread_id] [bigint] NULL,
    [thread_subject] [varchar](4000) NULL,
    [date_loaded] [datetime] NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[thread] ADD  CONSTRAINT [DF_thread_date_loaded]  DEFAULT (getdate()) FOR [date_loaded]
GO


USE [4ch]
GO

/****** Object:  Index [idx_0_thread]    Script Date: 20.10.2021 18:36:32 ******/
CREATE CLUSTERED INDEX [idx_0_thread] ON [dbo].[thread]
(
    [thread_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO


USE [4ch]
GO

/****** Object:  Index [idx_1_thread]    Script Date: 20.10.2021 18:36:54 ******/
CREATE NONCLUSTERED INDEX [idx_1_thread] ON [dbo].[thread]
(
    [thread_id] ASC
)
INCLUDE([thread_subject]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO


USE [4ch]
GO

SET ANSI_PADDING ON
GO

/****** Object:  Index [idx_0_word]    Script Date: 20.10.2021 18:37:09 ******/
CREATE CLUSTERED INDEX [idx_0_word] ON [dbo].[word]
(
    [word] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO




USE [4ch]
GO

/****** Object:  Table [dbo].[post]    Script Date: 20.10.2021 18:32:23 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[post](
    [post_id] [bigint] NULL,
    [thread_id] [bigint] NULL,
    [file_id] [bigint] NULL,
    [board_short] [varchar](4) NULL,
    [post_message] [varchar](4000) NULL,
    [date_loaded] [datetime] NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[post] ADD  CONSTRAINT [DF_post_DATE]  DEFAULT (getdate()) FOR [date_loaded]
GO

USE [4ch]
GO

/****** Object:  Index [idx_0_post]    Script Date: 20.10.2021 18:35:52 ******/
CREATE CLUSTERED INDEX [idx_0_post] ON [dbo].[post]
(
    [post_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO


USE [4ch]
GO

/****** Object:  Index [idx_2_post]    Script Date: 20.10.2021 18:36:08 ******/
CREATE NONCLUSTERED INDEX [idx_2_post] ON [dbo].[post]
(
    [file_id] ASC,
    [date_loaded] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO


USE [4ch]
GO

/****** Object:  Index [idx_3_post]    Script Date: 20.10.2021 18:36:17 ******/
CREATE NONCLUSTERED INDEX [idx_3_post] ON [dbo].[post]
(
    [date_loaded] ASC,
    [file_id] ASC,
    [thread_id] ASC
)
INCLUDE([post_id],[board_short],[post_message]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO





USE [4ch]
GO

/****** Object:  Table [dbo].[file]    Script Date: 20.10.2021 18:32:06 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[file](
    [file_id] [bigint] NOT NULL,
    [file_name] [varchar](4000) NULL,
    [md5] [varchar](50) NULL,
    [file_link] [varchar](255) NULL,
    [date_loaded] [datetime] NULL,
    [file_body] [image] NULL,
    [download_lock] [bit] NULL,
    [download_error] [bit] NULL,
    [download_error_second] [bit] NULL,
    [thumbnail] [image] NULL,
    [downloaded] [bit] NULL,
 CONSTRAINT [PK_file] PRIMARY KEY NONCLUSTERED
(
    [file_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[file] ADD  CONSTRAINT [DF_file_date_loaded]  DEFAULT (getdate()) FOR [date_loaded]
GO


USE [4ch]
GO

/****** Object:  Index [idx_0_file]    Script Date: 20.10.2021 18:34:03 ******/
CREATE CLUSTERED INDEX [idx_0_file] ON [dbo].[file]
(
    [file_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO


USE [4ch]
GO

/****** Object:  Index [idx_1_file]    Script Date: 20.10.2021 18:34:23 ******/
CREATE NONCLUSTERED INDEX [idx_1_file] ON [dbo].[file]
(
    [download_error] ASC,
    [download_lock] ASC
)
INCLUDE([file_id],[file_name],[file_link])
WHERE ([file_body] IS NULL AND [download_lock] IS NULL AND [download_error] IS NULL)
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO


USE [4ch]
GO

/****** Object:  Index [idx_2_file]    Script Date: 20.10.2021 18:34:40 ******/
CREATE NONCLUSTERED INDEX [idx_2_file] ON [dbo].[file]
(
    [download_error] ASC
)
INCLUDE([file_id],[file_name],[file_link])
WHERE ([download_error]=(1))
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO



USE [4ch]
GO

/****** Object:  Index [NonClusteredColumnStoreIndex-20210301-143620]    Script Date: 20.10.2021 18:35:01 ******/
CREATE NONCLUSTERED COLUMNSTORE INDEX [NonClusteredColumnStoreIndex-20210301-143620] ON [dbo].[file]
(
    [download_lock],
    [download_error],
    [file_id],
    [file_name],
    [file_link]
)WITH (DROP_EXISTING = OFF, COMPRESSION_DELAY = 0) ON [PRIMARY]
GO


USE [4ch]
GO

/****** Object:  Index [NonClusteredIndex-20210301-072944]    Script Date: 20.10.2021 18:35:16 ******/
CREATE NONCLUSTERED INDEX [NonClusteredIndex-20210301-072944] ON [dbo].[file]
(
    [file_id] ASC
)
WHERE ([file_body] IS NULL AND [download_lock] IS NULL AND [download_error] IS NULL)
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO


USE [4ch]
GO

/****** Object:  Index [PK_file]    Script Date: 20.10.2021 18:35:30 ******/
ALTER TABLE [dbo].[file] ADD  CONSTRAINT [PK_file] PRIMARY KEY NONCLUSTERED
(
    [file_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO






USE [4ch]
GO

/****** Object:  Table [dbo].[board_last_update]    Script Date: 20.10.2021 18:31:39 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[board_last_update](
    [board_link] [varchar](50) NULL,
    [board_short] [varchar](4) NULL,
    [last_update] [datetime] NULL
) ON [PRIMARY]
GO

USE [4ch]
GO

SET ANSI_PADDING ON
GO

/****** Object:  Index [idx_0_board_last_update]    Script Date: 20.10.2021 18:33:14 ******/
CREATE CLUSTERED INDEX [idx_0_board_last_update] ON [dbo].[board_last_update]
(
    [board_link] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO


USE [4ch]
GO

SET ANSI_PADDING ON
GO

/****** Object:  Index [idx_0_board_last_update]    Script Date: 20.10.2021 18:33:45 ******/
CREATE CLUSTERED INDEX [idx_0_board_last_update] ON [dbo].[board_last_update]
(
    [board_link] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO