99 lines
41 KiB
MySQL
99 lines
41 KiB
MySQL
|
/*
|
|||
|
|
Deployment script for Common
|
|||
|
|
|
|||
|
|
This code was generated by a tool.
|
|||
|
|
Changes to this file may cause incorrect behavior and will be lost if
|
|||
|
|
the code is regenerated.
|
|||
|
|
*/
|
|||
|
|
|
|||
|
|
GO
|
|||
|
|
SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, CONCAT_NULL_YIELDS_NULL, QUOTED_IDENTIFIER ON;
|
|||
|
|
|
|||
|
|
SET NUMERIC_ROUNDABORT OFF;
|
|||
|
|
|
|||
|
|
|
|||
|
|
GO
|
|||
|
|
:setvar DatabaseName "Common"
|
|||
|
|
:setvar DefaultFilePrefix "Common"
|
|||
|
|
:setvar DefaultDataPath "D:\SqlData\"
|
|||
|
|
:setvar DefaultLogPath "D:\SqlLogs\"
|
|||
|
|
|
|||
|
|
GO
|
|||
|
|
:on error exit
|
|||
|
|
GO
|
|||
|
|
/*
|
|||
|
|
Detect SQLCMD mode and disable script execution if SQLCMD mode is not supported.
|
|||
|
|
To re-enable the script after enabling SQLCMD mode, execute the following:
|
|||
|
|
SET NOEXEC OFF;
|
|||
|
|
*/
|
|||
|
|
:setvar __IsSqlCmdEnabled "True"
|
|||
|
|
GO
|
|||
|
|
IF N'$(__IsSqlCmdEnabled)' NOT LIKE N'True'
|
|||
|
|
BEGIN
|
|||
|
|
PRINT N'SQLCMD mode must be enabled to successfully execute this script.';
|
|||
|
|
SET NOEXEC ON;
|
|||
|
|
END
|
|||
|
|
|
|||
|
|
|
|||
|
|
GO
|
|||
|
|
USE [$(DatabaseName)];
|
|||
|
|
|
|||
|
|
|
|||
|
|
GO
|
|||
|
|
IF EXISTS (SELECT 1
|
|||
|
|
FROM [master].[dbo].[sysdatabases]
|
|||
|
|
WHERE [name] = N'$(DatabaseName)')
|
|||
|
|
BEGIN
|
|||
|
|
ALTER DATABASE [$(DatabaseName)]
|
|||
|
|
SET QUERY_STORE (QUERY_CAPTURE_MODE = ALL)
|
|||
|
|
WITH ROLLBACK IMMEDIATE;
|
|||
|
|
END
|
|||
|
|
|
|||
|
|
|
|||
|
|
GO
|
|||
|
|
PRINT N'Creating Assembly [SqlCustomFunctions]...';
|
|||
|
|
|
|||
|
|
|
|||
|
|
GO
|
|||
|
|
CREATE ASSEMBLY [SqlCustomFunctions]
|
|||
|
|
AUTHORIZATION [dbo]
|
|||
|
|
FROM 0x4D5A90000300000004000000FFFF0000B800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000E1FBA0E00B409CD21B8014CCD21546869732070726F6772616D2063616E6E6F742062652072756E20696E20444F53206D6F64652E0D0D0A2400000000000000504500004C0103004FE870680000000000000000E00022200B013000000800000006000000000000D2270000002000000040000000000010002000000002000004000000000000000600000000000000008000000002000000000000030060850000100000100000000010000010000000000000100000000000000000000000802700004F00000000400000D002000000000000000000000000000000000000006000000C000000482600001C0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002E74657874000000D8070000002000000008000000020000000000000000000000000000200000602E72737263000000D00200000040000000040000000A0000000000000000000000000000400000402E72656C6F6300000C0000000060000000020000000E00000000000000000000000000004000004200000000000000000000000000000000B42700000000000048000000020005003C2100000C05000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001B30020040000000010000111200FE1507000001140B021201280500000A2C18076F0600000A1F17330E076F0700000A0C08730800000A0ADE0A2616280900000A0ADE001200280A00000A2A0110000000000800262E000A050000011B30050072000000020000117E0B00000A280C00000A0A1F108D0C0000010B028E691F10311202028E691F105907161F10280D00000A2B23028E691F102F130216071F10028E6959028E69280D00000A2B0902071F10280E00000A07730F00000A6F1000000A280C00000A0ADE0E267E0B00000A280C00000A0ADE00062A00000110000000000B005762000E0500000142534A4201000100000000000C00000076342E302E33303331390000000005006C000000C8010000237E0000340200001802000023537472696E6773000000004C04000004000000235553005004000010000000234755494400000060040000AC00000023426C6F620000000000000002000001471502000900000000FA013300160000010000000D00000002000000020000000200000010000000050000000200000001000000040000000000B00001000000000006005A00290106007A0029010600310016010F00490100000600C501C7000A004500E5000E00DA0006011200A801CC010A009D0058011200FC01B2010600A900C70006009800C7000600F201C700000000000A000000000001000100810110007D0189011500010001005020000000009600E30168000100AC2000000000960001006E000200000001009C0100000100CE00090000010100110000010600190000010A003100000106004100280019004100F801210041006D012600390000012B003900D70131003900EC01260059000F023E004900D701410069000A02470069000A025200410000012B002900A7005B0020002300A6002E000B0075002E0013007E002E001B009D0040002300A60010003700048000000000000000000000000000000000890100000400000000000000000000005F001F00000000000400000000000000000000005F001300000000000400000000000000000000005F000601000000000400000000000000000000005F00C700000000000000000000496E74546F495036003C4D6F64756C653E0053797374656D2E44617461006D73636F726C69620054727950617273650044656275676761626C654174747269627574650053716C46756E6374696F6E41747472696275746500436F6D70696C6174696F6E52656C61786174696F6E734174747269627574650052756E74696D65436F6D7061746962696C69747941747472696275746500427974650053716C537472696E6700546F537472696E670053716C437573746F6D46756E6374696F6E732E646C6C0053797374656D0049505636496E746567657200426967496E7465676572004D6963726F736F66742E53716C5365727665722E536572766572002E63746F720053797374656D2E4E756D65726963730053797374656D2E446961676E6F73746963730053797374656D2E52756E74696D652E436F6D70696C6572536572766963657300446562756767696E674D6F6465730053797374656D2E446174612E53716C54797065730047657441646472657373427974657300495046756E6374696F6E730053716C437573746F6D46756E6374696F6E73004950563641646472657373004950416464726573730053797374656D2E4E65742E536F636B657473004F626A6563740053797374656D2E4E6574006F705F496D706C6963697400495036746F496E7400546F427974654172726179006765745F4164647265737346616D696C7900436F707900456D7074790000000000000000D4E5F3EE1EF94B46AD38DF53FC45406D00042001010803200001052001011111080703111D12211D05070002020E10122104200011290420001D05052001011D05050001111D0806070211251D0502060E05000111250E0A00050112350812350808080003011235123508032000
|
|||
|
|
WITH PERMISSION_SET = UNSAFE;
|
|||
|
|
|
|||
|
|
|
|||
|
|
GO
|
|||
|
|
ALTER ASSEMBLY [SqlCustomFunctions]
|
|||
|
|
DROP FILE ALL
|
|||
|
|
ADD FILE FROM 0x4D6963726F736F667420432F432B2B204D534620372E30300D0A1A445300000000020000010000001F0000009C000000000000001B000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000E00100F0FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF18FEFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF0BCA310138000000001000000010000000000000FFFFFFFF04000000FFFF030000000000FFFFFFFF00000000FFFFFFFF00000000FFFFFFFF000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
|
|||
|
|
|
|||
|
|
|
|||
|
|
GO
|
|||
|
|
PRINT N'Creating Function [dbo].[IntToIP6]...';
|
|||
|
|
|
|||
|
|
|
|||
|
|
GO
|
|||
|
|
CREATE FUNCTION [dbo].[IntToIP6]
|
|||
|
|
(@IPV6Integer VARBINARY (8000) NULL)
|
|||
|
|
RETURNS NVARCHAR (MAX)
|
|||
|
|
AS
|
|||
|
|
EXTERNAL NAME [SqlCustomFunctions].[SqlCustomFunctions.IPFunctions].[IntToIP6]
|
|||
|
|
|
|||
|
|
|
|||
|
|
GO
|
|||
|
|
PRINT N'Creating Function [dbo].[IP6toInt]...';
|
|||
|
|
|
|||
|
|
|
|||
|
|
GO
|
|||
|
|
CREATE FUNCTION [dbo].[IP6toInt]
|
|||
|
|
(@IPV6Address NVARCHAR (MAX) NULL)
|
|||
|
|
RETURNS VARBINARY (8000)
|
|||
|
|
AS
|
|||
|
|
EXTERNAL NAME [SqlCustomFunctions].[SqlCustomFunctions.IPFunctions].[IP6toInt]
|
|||
|
|
|
|||
|
|
|
|||
|
|
GO
|
|||
|
|
PRINT N'Update complete.';
|
|||
|
|
|
|||
|
|
|
|||
|
|
GO
|