<commit_before>/* CREATE TABLE FOR DYNAMIC PAGE REDIRECTION */
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[rb_Pages_DynamicRedirects]') AND type in (N'U'))
BEGIN
Create table rb_Pages_DynamicRedirects
(
DynamicPageID int identity(1,1) primary key,
FriendlyUrl nvarchar(512),
RedirectToUrl nvarchar(512)
)
END

/* CREATE PAGE FOR Page Friendly URL if not exist */
DECLARE @PAGEID INT,
		@ModuleDefId INT,
		@ModuleID INT
if not exists(select * from rb_pages where PageName='PageFriendlyUrl')
BEGIN
EXEC rb_AddTab 0,100,'PageFriendlyUrl',50,'Admins;',0,'', @PAGEID output
END

select @ModuleDefId=ModuleDefID from rb_ModuleDefinitions where GeneralModDefID='C1EA4115-E7F2-4CBC-B1E7-DDA46791493C'

/* Add PageFriendlyUrl Module on new created page if not loaded */
IF NOT EXISTS(SELECT * FROM rb_Modules WHERE ModuleDefID=@ModuleDefId)
BEGIN
EXEC rb_addModule @PAGEID,1,'Page Friendly URL','ContentPane',@ModuleDefId,0,'Admins','Admins;','Admins;','Admins;','Admins;','Admins;','Admins;',0,NULL,0,0,0,@ModuleID output
END
<commit_msg>Script Changes in 2.0.0.1905.sql<commit_after>/* CREATE TABLE FOR DYNAMIC PAGE REDIRECTION */
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[rb_Pages_DynamicRedirects]') AND type in (N'U'))
BEGIN
Create table rb_Pages_DynamicRedirects
(
DynamicPageID int identity(1,1) primary key,
FriendlyUrl nvarchar(512),
RedirectToUrl nvarchar(512)
)
END

/* CREATE PAGE FOR Page Friendly URL if not exist */
DECLARE @PAGEID INT,
		@ModuleDefId INT,
		@ModuleID INT
if not exists(select * from rb_pages where PageName='PageFriendlyUrl')
BEGIN
EXEC rb_AddTab 0,100,'PageFriendlyUrl',1205,'Admins;',0,'', @PAGEID output
END

select @ModuleDefId=ModuleDefID from rb_ModuleDefinitions where GeneralModDefID='C1EA4115-E7F2-4CBC-B1E7-DDA46791493C'

/* Add PageFriendlyUrl Module on new created page if not loaded */
IF NOT EXISTS(SELECT * FROM rb_Modules WHERE ModuleDefID=@ModuleDefId)
BEGIN
EXEC rb_addModule @PAGEID,1,'Page Friendly URL','ContentPane',@ModuleDefId,0,'Admins','Admins;','Admins;','Admins;','Admins;','Admins;','Admins;',0,NULL,0,0,0,@ModuleID output
END

{'fraction_non_alphanumeric': 0.11968209443665265, 'fraction_numerical': 0.04067321178120617, 'mean_word_length': 7.359375, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 1, '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': '15060', 'n_tokens_mistral': 820, 'n_tokens_neox': 761, 'n_words': 193}