<commit_before>/*Add the Mail to weblog parameters to subtext_config - GY*/
IF NOT EXISTS 
	(
		SELECT	* FROM [information_schema].[columns] 
		WHERE	table_name = 'subtext_Config' 
		AND		table_schema = '<dbUser,varchar,dbo>'
		AND		column_name = 'pop3User' 
		AND		column_name = 'pop3Pass'
		AND		column_name = 'pop3Server'
		AND		column_name = 'pop3StartTag'
		AND		column_name = 'pop3EndTag'
		AND		column_name = 'pop3SubjectPrefix'
		AND		column_name = 'pop3MTBEnable'
		AND		column_name = 'pop3DeleteOnlyProcessed'
		AND		column_name = 'pop3InlineAttachedPictures'
		AND		column_name = 'pop3HeightForThumbs'
	)
	
	ALTER TABLE [<dbUser,varchar,dbo>].[subtext_Config] WITH NOCHECK
	ADD [pop3User] [varchar](32) NULL
		,[pop3Pass] [varchar] (32) NULL
		,[pop3Server] [varchar] (56) NULL
		,[pop3StartTag] [varchar] (10) NULL
		,[pop3EndTag] [varchar] (10) NULL
		,[pop3SubjectPrefix] [nvarchar] (20) NULL
		,[pop3MTBEnable] [bit] NULL
		,[pop3DeleteOnlyProcessed] [bit] NULL
		,[pop3InlineAttachedPictures] [bit] NULL
		,[pop3HeightForThumbs] [int] NULL 

GO<commit_msg>Added create statements for subtext_PluginConfiguration and subtext_PluginEntryData tables. These tables are used to manage plugin configuration setting<commit_after>/*Add the Mail to weblog parameters to subtext_config - GY*/
IF NOT EXISTS 
	(
		SELECT	* FROM [information_schema].[columns] 
		WHERE	table_name = 'subtext_Config' 
		AND		table_schema = '<dbUser,varchar,dbo>'
		AND		column_name = 'pop3User' 
		AND		column_name = 'pop3Pass'
		AND		column_name = 'pop3Server'
		AND		column_name = 'pop3StartTag'
		AND		column_name = 'pop3EndTag'
		AND		column_name = 'pop3SubjectPrefix'
		AND		column_name = 'pop3MTBEnable'
		AND		column_name = 'pop3DeleteOnlyProcessed'
		AND		column_name = 'pop3InlineAttachedPictures'
		AND		column_name = 'pop3HeightForThumbs'
	)
	
	ALTER TABLE [<dbUser,varchar,dbo>].[subtext_Config] WITH NOCHECK
	ADD [pop3User] [varchar](32) NULL
		,[pop3Pass] [varchar] (32) NULL
		,[pop3Server] [varchar] (56) NULL
		,[pop3StartTag] [varchar] (10) NULL
		,[pop3EndTag] [varchar] (10) NULL
		,[pop3SubjectPrefix] [nvarchar] (20) NULL
		,[pop3MTBEnable] [bit] NULL
		,[pop3DeleteOnlyProcessed] [bit] NULL
		,[pop3InlineAttachedPictures] [bit] NULL
		,[pop3HeightForThumbs] [int] NULL 

GO




/* Add tables to manage plugin configuration */


if exists (select * from dbo.sysobjects where id = object_id(N'[<dbUser,varchar,dbo>].[subtext_PluginConfiguration]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [<dbUser,varchar,dbo>].[subtext_PluginConfiguration]
GO

CREATE TABLE [<dbUser,varchar,dbo>].[subtext_PluginConfiguration] (
	[id] [int] NOT NULL ,
	[PluginId] [int] NOT NULL ,
	[BlogId] [int] NOT NULL ,
	[Key] [nvarchar] (256) COLLATE Latin1_General_CI_AS NOT NULL ,
	[Value] [ntext] COLLATE Latin1_General_CI_AS NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO


if exists (select * from dbo.sysobjects where id = object_id(N'[<dbUser,varchar,dbo>].[subtext_PluginEntryData]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [<dbUser,varchar,dbo>].[subtext_PluginEntryData]
GO

CREATE TABLE [<dbUser,varchar,dbo>].[subtext_PluginEntryData] (
	[id] [int] NOT NULL ,
	[PluginId] [int] NOT NULL ,
	[BlogId] [int] NOT NULL ,
	[EntryId] [int] NOT NULL ,
	[Key] [nvarchar] (256) COLLATE Latin1_General_CI_AS NOT NULL ,
	[Value] [ntext] COLLATE Latin1_General_CI_AS NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

EXEC sp_tableoption  N'[<dbUser,varchar,dbo>].[subtext_PluginConfiguration]', 'text in row', '2048'
EXEC sp_tableoption  N'[<dbUser,varchar,dbo>].[subtext_PluginEntryData]', 'text in row', '2048'
{'fraction_non_alphanumeric': 0.12238147739801543, 'fraction_numerical': 0.023153252480705624, 'mean_word_length': 5.4919499105545615, 'pattern_counts': {'":': 0, '<': 15, '<?xml version=': 0, '>': 15, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '3110613', 'n_tokens_mistral': 1497, 'n_tokens_neox': 1395, 'n_words': 323}