67 lines
41 KiB
MySQL
67 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
|
|||
|
|
PRINT N'Altering Assembly [SqlCustomFunctions]...';
|
|||
|
|
|
|||
|
|
|
|||
|
|
GO
|
|||
|
|
ALTER ASSEMBLY [SqlCustomFunctions]
|
|||
|
|
DROP FILE ALL;
|
|||
|
|
|
|||
|
|
|
|||
|
|
GO
|
|||
|
|
ALTER ASSEMBLY [SqlCustomFunctions]
|
|||
|
|
FROM 0x4D5A90000300000004000000FFFF0000B800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000E1FBA0E00B409CD21B8014CCD21546869732070726F6772616D2063616E6E6F742062652072756E20696E20444F53206D6F64652E0D0D0A2400000000000000504500004C01030039F670680000000000000000E00022200B013000000A0000000600000000000066290000002000000040000000000010002000000002000004000000000000000600000000000000008000000002000000000000030060850000100000100000000010000010000000000000100000000000000000000000142900004F00000000400000D002000000000000000000000000000000000000006000000C000000DC2700001C0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002E746578740000006C09000000200000000A000000020000000000000000000000000000200000602E72737263000000D00200000040000000040000000C0000000000000000000000000000400000402E72656C6F6300000C000000006000000002000000100000000000000000000000000000400000420000000000000000000000000000000048290000000000004800000002000500482200009405000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001B30020059000000010000111200FE1508000001140B0F00FE16070000016F0500000A1201280600000A2C25076F0700000A1F17331B076F0800000A0C7E0900000A2C0608280A00000A08730B00000A0ADE0A2616280C00000A0ADE001200280D00000A2A00000001100000000008003F47000A050000011B3005007F000000020000117E0E00000A280F00000A0A1F108D0E0000010B028E691F10311202028E691F105907161F10281000000A2B23028E691F102F130216071F10028E6959028E69281000000A2B0902071F10281100000A7E0900000A2C0607280A00000A07731200000A6F0500000A280F00000A0ADE0E267E0E00000A280F00000A0ADE00062A000110000000000B00646F000E050000011B3002003D000000030000111A8D0E0000010A140B0F00FE16070000016F0500000A1201280600000A2C10076F0700000A183307076F0800000A0ADE0A261A8D0E0000010ADE00062A00000001100000000007002A31000A050000011B3005006B000000020000117E0E00000A280F00000A0A1A8D0E0000010B028E691A311002028E691A5907161A281000000A2B20028E691A2F120216071A028E6959028E69281000000A2B0802071A281100000A07731200000A6F0500000A280F00000A0ADE0E267E0E00000A280F00000A0ADE00062A000110000000000B00505B000E0500000142534A4201000100000000000C00000076342E302E33303331390000000005006C00000010020000237E00007C0200004802000023537472696E677300000000C40400000400000023555300C8040000100000002347554944000000D8040000BC00000023426C6F620000000000000002000001471502000900000000FA013300160000010000000E00000002000000040000000400000012000000070000000300000001000000040000000000E8000100000000000600920071010600B2007101060069005E010F009101000006000102FF000A007D002D010A00D500A0010E0015014E011200E401080212002F02EE0106002001FF0006002502FF000600E100FF000600D000FF00000000003700000000000100010081011000C501D10115000100010050200000000096001B0078000100C82000000000960029007F0002006421000000009600010078000300C0210000000096000E007F000400000001004000000001004000000001004000000001004000090048010100110048010600190048010A003100480106002900DF001900490058001D0049002B0225004900B5012A00590006012F00610061003200410048013800410013023E0041001F022A00690042024B00390013024E0061003D02540061003D025F0049004801380020002300B7002E000B0086002E0013008F002E001B00AE0040002300B70060002300B70080002300B700100044006800048000000000000000000000000000000000D10100000400000000000000000000006F004F00000000000400000000000000000000006F004300000000000400000000000000000000006F004E01000000000400000000000000000000006F00FF00000000000000000000697049505634746F42494E3400697042494E34746F4950563400697049505636746F42494E313600697042494E3136746F49505636003C4D6F64756C653E0049500053797374656D2E44617461006D73636F726C696200547279506172736500526576657273650044656275676761626C654174747269627574650053716C46756E6374696F6E41747472696275746500436F6D70696C6174696F6E52656C61786174696F6E734174747269627574650052756E74696D65436F6D7061746962696C69747941747472696275746500427974650053716C537472696E6700546F537472696E670053716C437573746F6D46756E6374696F6E732E646C6C0053797374656D0049734C6974746C65456E6469616E00426967496E746567657200426974436F6E766572746572004D6963726F736F6674
|
|||
|
|
|
|||
|
|
|
|||
|
|
GO
|
|||
|
|
ALTER ASSEMBLY [SqlCustomFunctions]
|
|||
|
|
DROP FILE ALL
|
|||
|
|
ADD FILE FROM 0x4D6963726F736F667420432F432B2B204D534620372E30300D0A1A445300000000020000010000001F000000A0000000000000001C000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000E00100E0FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF18FEFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF0BCA310138000000001000000010000000000000FFFFFFFF04000000FFFF030000000000FFFFFFFF00000000FFFFFFFF00000000FFFFFFFF000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
|
|||
|
|
|
|||
|
|
|
|||
|
|
GO
|
|||
|
|
PRINT N'Update complete.';
|
|||
|
|
|
|||
|
|
|
|||
|
|
GO
|