IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'Asiar')਀ऀ䐀刀伀倀 䐀䄀吀䄀䈀䄀匀䔀 嬀䄀猀椀愀爀崀
GO਀
CREATE DATABASE [Asiar]  ON (NAME = N'Asiar_Data', FILENAME = N'C:\Webs\5411\Asiar\Base\Asiar_Data.MDF' , SIZE = 2, FILEGROWTH = 10%) LOG ON (NAME = N'Asiar_Log', FILENAME = N'C:\Webs\5411\Asiar\Base\Asiar_Log.LDF' , SIZE = 12, FILEGROWTH = 10%)਀ 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀
GO਀
exec sp_dboption N'Asiar', N'autoclose', N'false'਀䜀伀
਀攀砀攀挀 猀瀀开搀戀漀瀀琀椀漀渀 一✀䄀猀椀愀爀✀Ⰰ 一✀戀甀氀欀挀漀瀀礀✀Ⰰ 一✀昀愀氀猀攀✀
GO਀
exec sp_dboption N'Asiar', N'trunc. log', N'false'਀䜀伀
਀攀砀攀挀 猀瀀开搀戀漀瀀琀椀漀渀 一✀䄀猀椀愀爀✀Ⰰ 一✀琀漀爀渀 瀀愀最攀 搀攀琀攀挀琀椀漀渀✀Ⰰ 一✀昀愀氀猀攀✀
GO਀
exec sp_dboption N'Asiar', N'read only', N'false'਀䜀伀
਀攀砀攀挀 猀瀀开搀戀漀瀀琀椀漀渀 一✀䄀猀椀愀爀✀Ⰰ 一✀搀戀漀 甀猀攀✀Ⰰ 一✀昀愀氀猀攀✀
GO਀
exec sp_dboption N'Asiar', N'single', N'false'਀䜀伀
਀攀砀攀挀 猀瀀开搀戀漀瀀琀椀漀渀 一✀䄀猀椀愀爀✀Ⰰ 一✀愀甀琀漀猀栀爀椀渀欀✀Ⰰ 一✀昀愀氀猀攀✀
GO਀
exec sp_dboption N'Asiar', N'ANSI null default', N'false'਀䜀伀
਀攀砀攀挀 猀瀀开搀戀漀瀀琀椀漀渀 一✀䄀猀椀愀爀✀Ⰰ 一✀爀攀挀甀爀猀椀瘀攀 琀爀椀最最攀爀猀✀Ⰰ 一✀昀愀氀猀攀✀
GO਀
exec sp_dboption N'Asiar', N'ANSI nulls', N'false'਀䜀伀
਀攀砀攀挀 猀瀀开搀戀漀瀀琀椀漀渀 一✀䄀猀椀愀爀✀Ⰰ 一✀挀漀渀挀愀琀 渀甀氀氀 礀椀攀氀搀猀 渀甀氀氀✀Ⰰ 一✀昀愀氀猀攀✀
GO਀
exec sp_dboption N'Asiar', N'cursor close on commit', N'false'਀䜀伀
਀攀砀攀挀 猀瀀开搀戀漀瀀琀椀漀渀 一✀䄀猀椀愀爀✀Ⰰ 一✀搀攀昀愀甀氀琀 琀漀 氀漀挀愀氀 挀甀爀猀漀爀✀Ⰰ 一✀昀愀氀猀攀✀
GO਀
exec sp_dboption N'Asiar', N'quoted identifier', N'false'਀䜀伀
਀攀砀攀挀 猀瀀开搀戀漀瀀琀椀漀渀 一✀䄀猀椀愀爀✀Ⰰ 一✀䄀一匀䤀 眀愀爀渀椀渀最猀✀Ⰰ 一✀昀愀氀猀攀✀
GO਀
exec sp_dboption N'Asiar', N'auto create statistics', N'true'਀䜀伀
਀攀砀攀挀 猀瀀开搀戀漀瀀琀椀漀渀 一✀䄀猀椀愀爀✀Ⰰ 一✀愀甀琀漀 甀瀀搀愀琀攀 猀琀愀琀椀猀琀椀挀猀✀Ⰰ 一✀琀爀甀攀✀
GO਀
if( ( (@@microsoftversion / power(2, 24) = 8) and (@@microsoftversion & 0xffff >= 724) ) or ( (@@microsoftversion / power(2, 24) = 7) and (@@microsoftversion & 0xffff >= 1082) ) )਀ऀ攀砀攀挀 猀瀀开搀戀漀瀀琀椀漀渀 一✀䄀猀椀愀爀✀Ⰰ 一✀搀戀 挀栀愀椀渀椀渀最✀Ⰰ 一✀昀愀氀猀攀✀
GO਀
use [Asiar]਀䜀伀
਀椀昀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 搀戀漀⸀猀礀猀漀戀樀攀挀琀猀 眀栀攀爀攀 椀搀 㴀 漀戀樀攀挀琀开椀搀⠀一✀嬀搀戀漀崀⸀嬀瘀椀攀眀䌀氀椀攀渀琀攀猀堀刀甀戀爀漀崀✀⤀ 愀渀搀 伀䈀䨀䔀䌀吀倀刀伀倀䔀刀吀夀⠀椀搀Ⰰ 一✀䤀猀嘀椀攀眀✀⤀ 㴀 ㄀⤀
drop view [dbo].[viewClientesXRubro]਀䜀伀
਀椀昀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 搀戀漀⸀猀礀猀漀戀樀攀挀琀猀 眀栀攀爀攀 椀搀 㴀 漀戀樀攀挀琀开椀搀⠀一✀嬀搀戀漀崀⸀嬀䄀搀洀椀渀崀✀⤀ 愀渀搀 伀䈀䨀䔀䌀吀倀刀伀倀䔀刀吀夀⠀椀搀Ⰰ 一✀䤀猀唀猀攀爀吀愀戀氀攀✀⤀ 㴀 ㄀⤀
drop table [dbo].[Admin]਀䜀伀
਀椀昀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 搀戀漀⸀猀礀猀漀戀樀攀挀琀猀 眀栀攀爀攀 椀搀 㴀 漀戀樀攀挀琀开椀搀⠀一✀嬀搀戀漀崀⸀嬀䌀氀椀攀渀琀攀猀崀✀⤀ 愀渀搀 伀䈀䨀䔀䌀吀倀刀伀倀䔀刀吀夀⠀椀搀Ⰰ 一✀䤀猀唀猀攀爀吀愀戀氀攀✀⤀ 㴀 ㄀⤀
drop table [dbo].[Clientes]਀䜀伀
਀椀昀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 搀戀漀⸀猀礀猀漀戀樀攀挀琀猀 眀栀攀爀攀 椀搀 㴀 漀戀樀攀挀琀开椀搀⠀一✀嬀搀戀漀崀⸀嬀䔀洀瀀爀攀猀愀猀倀漀爀刀甀戀爀漀崀✀⤀ 愀渀搀 伀䈀䨀䔀䌀吀倀刀伀倀䔀刀吀夀⠀椀搀Ⰰ 一✀䤀猀唀猀攀爀吀愀戀氀攀✀⤀ 㴀 ㄀⤀
drop table [dbo].[EmpresasPorRubro]਀䜀伀
਀椀昀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 搀戀漀⸀猀礀猀漀戀樀攀挀琀猀 眀栀攀爀攀 椀搀 㴀 漀戀樀攀挀琀开椀搀⠀一✀嬀搀戀漀崀⸀嬀䔀猀琀愀搀嘀椀猀椀琀愀猀崀✀⤀ 愀渀搀 伀䈀䨀䔀䌀吀倀刀伀倀䔀刀吀夀⠀椀搀Ⰰ 一✀䤀猀唀猀攀爀吀愀戀氀攀✀⤀ 㴀 ㄀⤀
drop table [dbo].[EstadVisitas]਀䜀伀
਀椀昀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 搀戀漀⸀猀礀猀漀戀樀攀挀琀猀 眀栀攀爀攀 椀搀 㴀 漀戀樀攀挀琀开椀搀⠀一✀嬀搀戀漀崀⸀嬀䔀瘀攀渀琀漀猀崀✀⤀ 愀渀搀 伀䈀䨀䔀䌀吀倀刀伀倀䔀刀吀夀⠀椀搀Ⰰ 一✀䤀猀唀猀攀爀吀愀戀氀攀✀⤀ 㴀 ㄀⤀
drop table [dbo].[Eventos]਀䜀伀
਀椀昀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 搀戀漀⸀猀礀猀漀戀樀攀挀琀猀 眀栀攀爀攀 椀搀 㴀 漀戀樀攀挀琀开椀搀⠀一✀嬀搀戀漀崀⸀嬀䴀椀猀椀漀渀攀猀崀✀⤀ 愀渀搀 伀䈀䨀䔀䌀吀倀刀伀倀䔀刀吀夀⠀椀搀Ⰰ 一✀䤀猀唀猀攀爀吀愀戀氀攀✀⤀ 㴀 ㄀⤀
drop table [dbo].[Misiones]਀䜀伀
਀椀昀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 搀戀漀⸀猀礀猀漀戀樀攀挀琀猀 眀栀攀爀攀 椀搀 㴀 漀戀樀攀挀琀开椀搀⠀一✀嬀搀戀漀崀⸀嬀伀昀椀挀椀渀愀猀崀✀⤀ 愀渀搀 伀䈀䨀䔀䌀吀倀刀伀倀䔀刀吀夀⠀椀搀Ⰰ 一✀䤀猀唀猀攀爀吀愀戀氀攀✀⤀ 㴀 ㄀⤀
drop table [dbo].[Oficinas]਀䜀伀
਀椀昀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 搀戀漀⸀猀礀猀漀戀樀攀挀琀猀 眀栀攀爀攀 椀搀 㴀 漀戀樀攀挀琀开椀搀⠀一✀嬀搀戀漀崀⸀嬀倀愀爀琀渀攀爀猀崀✀⤀ 愀渀搀 伀䈀䨀䔀䌀吀倀刀伀倀䔀刀吀夀⠀椀搀Ⰰ 一✀䤀猀唀猀攀爀吀愀戀氀攀✀⤀ 㴀 ㄀⤀
drop table [dbo].[Partners]਀䜀伀
਀椀昀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 搀戀漀⸀猀礀猀漀戀樀攀挀琀猀 眀栀攀爀攀 椀搀 㴀 漀戀樀攀挀琀开椀搀⠀一✀嬀搀戀漀崀⸀嬀儀猀漀洀漀猀崀✀⤀ 愀渀搀 伀䈀䨀䔀䌀吀倀刀伀倀䔀刀吀夀⠀椀搀Ⰰ 一✀䤀猀唀猀攀爀吀愀戀氀攀✀⤀ 㴀 ㄀⤀
drop table [dbo].[Qsomos]਀䜀伀
਀椀昀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 搀戀漀⸀猀礀猀漀戀樀攀挀琀猀 眀栀攀爀攀 椀搀 㴀 漀戀樀攀挀琀开椀搀⠀一✀嬀搀戀漀崀⸀嬀匀攀爀瘀椀挀椀漀猀崀✀⤀ 愀渀搀 伀䈀䨀䔀䌀吀倀刀伀倀䔀刀吀夀⠀椀搀Ⰰ 一✀䤀猀唀猀攀爀吀愀戀氀攀✀⤀ 㴀 ㄀⤀
drop table [dbo].[Servicios]਀䜀伀
਀椀昀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 搀戀漀⸀猀礀猀漀戀樀攀挀琀猀 眀栀攀爀攀 椀搀 㴀 漀戀樀攀挀琀开椀搀⠀一✀嬀搀戀漀崀⸀嬀匀琀愀昀昀崀✀⤀ 愀渀搀 伀䈀䨀䔀䌀吀倀刀伀倀䔀刀吀夀⠀椀搀Ⰰ 一✀䤀猀唀猀攀爀吀愀戀氀攀✀⤀ 㴀 ㄀⤀
drop table [dbo].[Staff]਀䜀伀
਀椀昀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 搀戀漀⸀猀礀猀漀戀樀攀挀琀猀 眀栀攀爀攀 椀搀 㴀 漀戀樀攀挀琀开椀搀⠀一✀嬀搀戀漀崀⸀嬀匀琀爀愀琀愀开䄀搀洀椀渀崀✀⤀ 愀渀搀 伀䈀䨀䔀䌀吀倀刀伀倀䔀刀吀夀⠀椀搀Ⰰ 一✀䤀猀唀猀攀爀吀愀戀氀攀✀⤀ 㴀 ㄀⤀
drop table [dbo].[Strata_Admin]਀䜀伀
਀椀昀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 搀戀漀⸀猀礀猀漀戀樀攀挀琀猀 眀栀攀爀攀 椀搀 㴀 漀戀樀攀挀琀开椀搀⠀一✀嬀搀戀漀崀⸀嬀匀琀爀愀琀愀开䌀椀琀礀崀✀⤀ 愀渀搀 伀䈀䨀䔀䌀吀倀刀伀倀䔀刀吀夀⠀椀搀Ⰰ 一✀䤀猀唀猀攀爀吀愀戀氀攀✀⤀ 㴀 ㄀⤀
drop table [dbo].[Strata_City]਀䜀伀
਀椀昀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 搀戀漀⸀猀礀猀漀戀樀攀挀琀猀 眀栀攀爀攀 椀搀 㴀 漀戀樀攀挀琀开椀搀⠀一✀嬀搀戀漀崀⸀嬀匀琀爀愀琀愀开䌀氀椀攀渀琀攀猀崀✀⤀ 愀渀搀 伀䈀䨀䔀䌀吀倀刀伀倀䔀刀吀夀⠀椀搀Ⰰ 一✀䤀猀唀猀攀爀吀愀戀氀攀✀⤀ 㴀 ㄀⤀
drop table [dbo].[Strata_Clientes]਀䜀伀
਀椀昀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 搀戀漀⸀猀礀猀漀戀樀攀挀琀猀 眀栀攀爀攀 椀搀 㴀 漀戀樀攀挀琀开椀搀⠀一✀嬀搀戀漀崀⸀嬀匀琀爀愀琀愀开䌀漀甀渀琀爀礀崀✀⤀ 愀渀搀 伀䈀䨀䔀䌀吀倀刀伀倀䔀刀吀夀⠀椀搀Ⰰ 一✀䤀猀唀猀攀爀吀愀戀氀攀✀⤀ 㴀 ㄀⤀
drop table [dbo].[Strata_Country]਀䜀伀
਀椀昀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 搀戀漀⸀猀礀猀漀戀樀攀挀琀猀 眀栀攀爀攀 椀搀 㴀 漀戀樀攀挀琀开椀搀⠀一✀嬀搀戀漀崀⸀嬀匀琀爀愀琀愀开䘀愀洀椀氀椀愀猀崀✀⤀ 愀渀搀 伀䈀䨀䔀䌀吀倀刀伀倀䔀刀吀夀⠀椀搀Ⰰ 一✀䤀猀唀猀攀爀吀愀戀氀攀✀⤀ 㴀 ㄀⤀
drop table [dbo].[Strata_Familias]਀䜀伀
਀椀昀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 搀戀漀⸀猀礀猀漀戀樀攀挀琀猀 眀栀攀爀攀 椀搀 㴀 漀戀樀攀挀琀开椀搀⠀一✀嬀搀戀漀崀⸀嬀匀琀爀愀琀愀开䰀椀渀攀愀猀崀✀⤀ 愀渀搀 伀䈀䨀䔀䌀吀倀刀伀倀䔀刀吀夀⠀椀搀Ⰰ 一✀䤀猀唀猀攀爀吀愀戀氀攀✀⤀ 㴀 ㄀⤀
drop table [dbo].[Strata_Lineas]਀䜀伀
਀椀昀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 搀戀漀⸀猀礀猀漀戀樀攀挀琀猀 眀栀攀爀攀 椀搀 㴀 漀戀樀攀挀琀开椀搀⠀一✀嬀搀戀漀崀⸀嬀匀琀爀愀琀愀开倀爀漀搀甀挀琀漀猀崀✀⤀ 愀渀搀 伀䈀䨀䔀䌀吀倀刀伀倀䔀刀吀夀⠀椀搀Ⰰ 一✀䤀猀唀猀攀爀吀愀戀氀攀✀⤀ 㴀 ㄀⤀
drop table [dbo].[Strata_Productos]਀䜀伀
਀椀昀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 搀戀漀⸀猀礀猀漀戀樀攀挀琀猀 眀栀攀爀攀 椀搀 㴀 漀戀樀攀挀琀开椀搀⠀一✀嬀搀戀漀崀⸀嬀匀甀戀䌀愀琀攀最漀爀椀愀猀崀✀⤀ 愀渀搀 伀䈀䨀䔀䌀吀倀刀伀倀䔀刀吀夀⠀椀搀Ⰰ 一✀䤀猀唀猀攀爀吀愀戀氀攀✀⤀ 㴀 ㄀⤀
drop table [dbo].[SubCategorias]਀䜀伀
਀椀昀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 搀戀漀⸀猀礀猀漀戀樀攀挀琀猀 眀栀攀爀攀 椀搀 㴀 漀戀樀攀挀琀开椀搀⠀一✀嬀搀戀漀崀⸀嬀氀椀渀欀猀崀✀⤀ 愀渀搀 伀䈀䨀䔀䌀吀倀刀伀倀䔀刀吀夀⠀椀搀Ⰰ 一✀䤀猀唀猀攀爀吀愀戀氀攀✀⤀ 㴀 ㄀⤀
drop table [dbo].[links]਀䜀伀
਀椀昀 渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀氀漀最椀渀猀 眀栀攀爀攀 氀漀最椀渀渀愀洀攀 㴀 一✀䄀最爀漀洀攀愀琀✀⤀
BEGIN਀ऀ搀攀挀氀愀爀攀 䀀氀漀最椀渀搀戀 渀瘀愀爀挀栀愀爀⠀㄀㌀㈀⤀Ⰰ 䀀氀漀最椀渀氀愀渀最 渀瘀愀爀挀栀愀爀⠀㄀㌀㈀⤀ 猀攀氀攀挀琀 䀀氀漀最椀渀搀戀 㴀 一✀䄀最爀漀洀攀愀琀✀Ⰰ 䀀氀漀最椀渀氀愀渀最 㴀 一✀甀猀开攀渀最氀椀猀栀✀
	if @logindb is null or not exists (select * from master.dbo.sysdatabases where name = @logindb)਀ऀऀ猀攀氀攀挀琀 䀀氀漀最椀渀搀戀 㴀 一✀洀愀猀琀攀爀✀
	if @loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english')਀ऀऀ猀攀氀攀挀琀 䀀氀漀最椀渀氀愀渀最 㴀 䀀䀀氀愀渀最甀愀最攀
	exec sp_addlogin N'Agromeat', null, @logindb, @loginlang਀䔀一䐀
GO਀
if not exists (select * from master.dbo.syslogins where loginname = N'Ambas')਀䈀䔀䜀䤀一
	declare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N'Ambas', @loginlang = N'us_english'਀ऀ椀昀 䀀氀漀最椀渀搀戀 椀猀 渀甀氀氀 漀爀 渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀搀愀琀愀戀愀猀攀猀 眀栀攀爀攀 渀愀洀攀 㴀 䀀氀漀最椀渀搀戀⤀
		select @logindb = N'master'਀ऀ椀昀 䀀氀漀最椀渀氀愀渀最 椀猀 渀甀氀氀 漀爀 ⠀渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀氀愀渀最甀愀最攀猀 眀栀攀爀攀 渀愀洀攀 㴀 䀀氀漀最椀渀氀愀渀最⤀ 愀渀搀 䀀氀漀最椀渀氀愀渀最 㰀㸀 一✀甀猀开攀渀最氀椀猀栀✀⤀
		select @loginlang = @@language਀ऀ攀砀攀挀 猀瀀开愀搀搀氀漀最椀渀 一✀䄀洀戀愀猀✀Ⰰ 渀甀氀氀Ⰰ 䀀氀漀最椀渀搀戀Ⰰ 䀀氀漀最椀渀氀愀渀最
END਀䜀伀
਀椀昀 渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀氀漀最椀渀猀 眀栀攀爀攀 氀漀最椀渀渀愀洀攀 㴀 一✀䄀洀椀戀漀搀愀✀⤀
BEGIN਀ऀ搀攀挀氀愀爀攀 䀀氀漀最椀渀搀戀 渀瘀愀爀挀栀愀爀⠀㄀㌀㈀⤀Ⰰ 䀀氀漀最椀渀氀愀渀最 渀瘀愀爀挀栀愀爀⠀㄀㌀㈀⤀ 猀攀氀攀挀琀 䀀氀漀最椀渀搀戀 㴀 一✀䄀洀椀戀漀搀愀✀Ⰰ 䀀氀漀最椀渀氀愀渀最 㴀 一✀甀猀开攀渀最氀椀猀栀✀
	if @logindb is null or not exists (select * from master.dbo.sysdatabases where name = @logindb)਀ऀऀ猀攀氀攀挀琀 䀀氀漀最椀渀搀戀 㴀 一✀洀愀猀琀攀爀✀
	if @loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english')਀ऀऀ猀攀氀攀挀琀 䀀氀漀最椀渀氀愀渀最 㴀 䀀䀀氀愀渀最甀愀最攀
	exec sp_addlogin N'Amiboda', null, @logindb, @loginlang਀䔀一䐀
GO਀
if not exists (select * from master.dbo.syslogins where loginname = N'Amitech')਀䈀䔀䜀䤀一
	declare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N'master', @loginlang = N'us_english'਀ऀ椀昀 䀀氀漀最椀渀搀戀 椀猀 渀甀氀氀 漀爀 渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀搀愀琀愀戀愀猀攀猀 眀栀攀爀攀 渀愀洀攀 㴀 䀀氀漀最椀渀搀戀⤀
		select @logindb = N'master'਀ऀ椀昀 䀀氀漀最椀渀氀愀渀最 椀猀 渀甀氀氀 漀爀 ⠀渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀氀愀渀最甀愀最攀猀 眀栀攀爀攀 渀愀洀攀 㴀 䀀氀漀最椀渀氀愀渀最⤀ 愀渀搀 䀀氀漀最椀渀氀愀渀最 㰀㸀 一✀甀猀开攀渀最氀椀猀栀✀⤀
		select @loginlang = @@language਀ऀ攀砀攀挀 猀瀀开愀搀搀氀漀最椀渀 一✀䄀洀椀琀攀挀栀✀Ⰰ 渀甀氀氀Ⰰ 䀀氀漀最椀渀搀戀Ⰰ 䀀氀漀最椀渀氀愀渀最
END਀䜀伀
਀椀昀 渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀氀漀最椀渀猀 眀栀攀爀攀 氀漀最椀渀渀愀洀攀 㴀 一✀䄀猀椀愀爀䘀䄀✀⤀
BEGIN਀ऀ搀攀挀氀愀爀攀 䀀氀漀最椀渀搀戀 渀瘀愀爀挀栀愀爀⠀㄀㌀㈀⤀Ⰰ 䀀氀漀最椀渀氀愀渀最 渀瘀愀爀挀栀愀爀⠀㄀㌀㈀⤀ 猀攀氀攀挀琀 䀀氀漀最椀渀搀戀 㴀 一✀䄀猀椀愀爀✀Ⰰ 䀀氀漀最椀渀氀愀渀最 㴀 一✀甀猀开攀渀最氀椀猀栀✀
	if @logindb is null or not exists (select * from master.dbo.sysdatabases where name = @logindb)਀ऀऀ猀攀氀攀挀琀 䀀氀漀最椀渀搀戀 㴀 一✀洀愀猀琀攀爀✀
	if @loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english')਀ऀऀ猀攀氀攀挀琀 䀀氀漀最椀渀氀愀渀最 㴀 䀀䀀氀愀渀最甀愀最攀
	exec sp_addlogin N'AsiarFA', null, @logindb, @loginlang਀䔀一䐀
GO਀
if not exists (select * from master.dbo.syslogins where loginname = N'bST')਀䈀䔀䜀䤀一
	declare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N'bST', @loginlang = N'us_english'਀ऀ椀昀 䀀氀漀最椀渀搀戀 椀猀 渀甀氀氀 漀爀 渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀搀愀琀愀戀愀猀攀猀 眀栀攀爀攀 渀愀洀攀 㴀 䀀氀漀最椀渀搀戀⤀
		select @logindb = N'master'਀ऀ椀昀 䀀氀漀最椀渀氀愀渀最 椀猀 渀甀氀氀 漀爀 ⠀渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀氀愀渀最甀愀最攀猀 眀栀攀爀攀 渀愀洀攀 㴀 䀀氀漀最椀渀氀愀渀最⤀ 愀渀搀 䀀氀漀最椀渀氀愀渀最 㰀㸀 一✀甀猀开攀渀最氀椀猀栀✀⤀
		select @loginlang = @@language਀ऀ攀砀攀挀 猀瀀开愀搀搀氀漀最椀渀 一✀戀匀吀✀Ⰰ 渀甀氀氀Ⰰ 䀀氀漀最椀渀搀戀Ⰰ 䀀氀漀最椀渀氀愀渀最
END਀䜀伀
਀椀昀 渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀氀漀最椀渀猀 眀栀攀爀攀 氀漀最椀渀渀愀洀攀 㴀 一✀䌀愀猀椀漀䘀䄀✀⤀
BEGIN਀ऀ搀攀挀氀愀爀攀 䀀氀漀最椀渀搀戀 渀瘀愀爀挀栀愀爀⠀㄀㌀㈀⤀Ⰰ 䀀氀漀最椀渀氀愀渀最 渀瘀愀爀挀栀愀爀⠀㄀㌀㈀⤀ 猀攀氀攀挀琀 䀀氀漀最椀渀搀戀 㴀 一✀䌀愀猀椀漀✀Ⰰ 䀀氀漀最椀渀氀愀渀最 㴀 一✀甀猀开攀渀最氀椀猀栀✀
	if @logindb is null or not exists (select * from master.dbo.sysdatabases where name = @logindb)਀ऀऀ猀攀氀攀挀琀 䀀氀漀最椀渀搀戀 㴀 一✀洀愀猀琀攀爀✀
	if @loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english')਀ऀऀ猀攀氀攀挀琀 䀀氀漀最椀渀氀愀渀最 㴀 䀀䀀氀愀渀最甀愀最攀
	exec sp_addlogin N'CasioFA', null, @logindb, @loginlang਀䔀一䐀
GO਀
if not exists (select * from master.dbo.syslogins where loginname = N'CasioRO')਀䈀䔀䜀䤀一
	declare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N'Casio', @loginlang = N'us_english'਀ऀ椀昀 䀀氀漀最椀渀搀戀 椀猀 渀甀氀氀 漀爀 渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀搀愀琀愀戀愀猀攀猀 眀栀攀爀攀 渀愀洀攀 㴀 䀀氀漀最椀渀搀戀⤀
		select @logindb = N'master'਀ऀ椀昀 䀀氀漀最椀渀氀愀渀最 椀猀 渀甀氀氀 漀爀 ⠀渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀氀愀渀最甀愀最攀猀 眀栀攀爀攀 渀愀洀攀 㴀 䀀氀漀最椀渀氀愀渀最⤀ 愀渀搀 䀀氀漀最椀渀氀愀渀最 㰀㸀 一✀甀猀开攀渀最氀椀猀栀✀⤀
		select @loginlang = @@language਀ऀ攀砀攀挀 猀瀀开愀搀搀氀漀最椀渀 一✀䌀愀猀椀漀刀伀✀Ⰰ 渀甀氀氀Ⰰ 䀀氀漀最椀渀搀戀Ⰰ 䀀氀漀最椀渀氀愀渀最
END਀䜀伀
਀椀昀 渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀氀漀最椀渀猀 眀栀攀爀攀 氀漀最椀渀渀愀洀攀 㴀 一✀䌀爀攀搀椀氀漀最爀漀猀✀⤀
BEGIN਀ऀ搀攀挀氀愀爀攀 䀀氀漀最椀渀搀戀 渀瘀愀爀挀栀愀爀⠀㄀㌀㈀⤀Ⰰ 䀀氀漀最椀渀氀愀渀最 渀瘀愀爀挀栀愀爀⠀㄀㌀㈀⤀ 猀攀氀攀挀琀 䀀氀漀最椀渀搀戀 㴀 一✀䌀爀攀搀椀氀漀最爀漀猀✀Ⰰ 䀀氀漀最椀渀氀愀渀最 㴀 一✀甀猀开攀渀最氀椀猀栀✀
	if @logindb is null or not exists (select * from master.dbo.sysdatabases where name = @logindb)਀ऀऀ猀攀氀攀挀琀 䀀氀漀最椀渀搀戀 㴀 一✀洀愀猀琀攀爀✀
	if @loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english')਀ऀऀ猀攀氀攀挀琀 䀀氀漀最椀渀氀愀渀最 㴀 䀀䀀氀愀渀最甀愀最攀
	exec sp_addlogin N'Credilogros', null, @logindb, @loginlang਀䔀一䐀
GO਀
if not exists (select * from master.dbo.syslogins where loginname = N'Delafore')਀䈀䔀䜀䤀一
	declare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N'Delafore', @loginlang = N'us_english'਀ऀ椀昀 䀀氀漀最椀渀搀戀 椀猀 渀甀氀氀 漀爀 渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀搀愀琀愀戀愀猀攀猀 眀栀攀爀攀 渀愀洀攀 㴀 䀀氀漀最椀渀搀戀⤀
		select @logindb = N'master'਀ऀ椀昀 䀀氀漀最椀渀氀愀渀最 椀猀 渀甀氀氀 漀爀 ⠀渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀氀愀渀最甀愀最攀猀 眀栀攀爀攀 渀愀洀攀 㴀 䀀氀漀最椀渀氀愀渀最⤀ 愀渀搀 䀀氀漀最椀渀氀愀渀最 㰀㸀 一✀甀猀开攀渀最氀椀猀栀✀⤀
		select @loginlang = @@language਀ऀ攀砀攀挀 猀瀀开愀搀搀氀漀最椀渀 一✀䐀攀氀愀昀漀爀攀✀Ⰰ 渀甀氀氀Ⰰ 䀀氀漀最椀渀搀戀Ⰰ 䀀氀漀最椀渀氀愀渀最
END਀䜀伀
਀椀昀 渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀氀漀最椀渀猀 眀栀攀爀攀 氀漀最椀渀渀愀洀攀 㴀 一✀䐀攀氀氀愀䌀愀猀愀✀⤀
BEGIN਀ऀ搀攀挀氀愀爀攀 䀀氀漀最椀渀搀戀 渀瘀愀爀挀栀愀爀⠀㄀㌀㈀⤀Ⰰ 䀀氀漀最椀渀氀愀渀最 渀瘀愀爀挀栀愀爀⠀㄀㌀㈀⤀ 猀攀氀攀挀琀 䀀氀漀最椀渀搀戀 㴀 一✀䐀攀氀氀愀䌀愀猀愀✀Ⰰ 䀀氀漀最椀渀氀愀渀最 㴀 一✀甀猀开攀渀最氀椀猀栀✀
	if @logindb is null or not exists (select * from master.dbo.sysdatabases where name = @logindb)਀ऀऀ猀攀氀攀挀琀 䀀氀漀最椀渀搀戀 㴀 一✀洀愀猀琀攀爀✀
	if @loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english')਀ऀऀ猀攀氀攀挀琀 䀀氀漀最椀渀氀愀渀最 㴀 䀀䀀氀愀渀最甀愀最攀
	exec sp_addlogin N'DellaCasa', null, @logindb, @loginlang਀䔀一䐀
GO਀
if not exists (select * from master.dbo.syslogins where loginname = N'DellaCasa2')਀䈀䔀䜀䤀一
	declare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N'DellaCasa', @loginlang = N'us_english'਀ऀ椀昀 䀀氀漀最椀渀搀戀 椀猀 渀甀氀氀 漀爀 渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀搀愀琀愀戀愀猀攀猀 眀栀攀爀攀 渀愀洀攀 㴀 䀀氀漀最椀渀搀戀⤀
		select @logindb = N'master'਀ऀ椀昀 䀀氀漀最椀渀氀愀渀最 椀猀 渀甀氀氀 漀爀 ⠀渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀氀愀渀最甀愀最攀猀 眀栀攀爀攀 渀愀洀攀 㴀 䀀氀漀最椀渀氀愀渀最⤀ 愀渀搀 䀀氀漀最椀渀氀愀渀最 㰀㸀 一✀甀猀开攀渀最氀椀猀栀✀⤀
		select @loginlang = @@language਀ऀ攀砀攀挀 猀瀀开愀搀搀氀漀最椀渀 一✀䐀攀氀氀愀䌀愀猀愀㈀✀Ⰰ 渀甀氀氀Ⰰ 䀀氀漀最椀渀搀戀Ⰰ 䀀氀漀最椀渀氀愀渀最
END਀䜀伀
਀椀昀 渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀氀漀最椀渀猀 眀栀攀爀攀 氀漀最椀渀渀愀洀攀 㴀 一✀䐀攀氀氀愀䌀愀猀愀䔀砀瀀爀攀猀猀✀⤀
BEGIN਀ऀ搀攀挀氀愀爀攀 䀀氀漀最椀渀搀戀 渀瘀愀爀挀栀愀爀⠀㄀㌀㈀⤀Ⰰ 䀀氀漀最椀渀氀愀渀最 渀瘀愀爀挀栀愀爀⠀㄀㌀㈀⤀ 猀攀氀攀挀琀 䀀氀漀最椀渀搀戀 㴀 一✀䐀攀氀氀愀䌀愀猀愀䔀砀瀀爀攀猀猀✀Ⰰ 䀀氀漀最椀渀氀愀渀最 㴀 一✀甀猀开攀渀最氀椀猀栀✀
	if @logindb is null or not exists (select * from master.dbo.sysdatabases where name = @logindb)਀ऀऀ猀攀氀攀挀琀 䀀氀漀最椀渀搀戀 㴀 一✀洀愀猀琀攀爀✀
	if @loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english')਀ऀऀ猀攀氀攀挀琀 䀀氀漀最椀渀氀愀渀最 㴀 䀀䀀氀愀渀最甀愀最攀
	exec sp_addlogin N'DellaCasaExpress', null, @logindb, @loginlang਀䔀一䐀
GO਀
if not exists (select * from master.dbo.syslogins where loginname = N'dellacasasist')਀䈀䔀䜀䤀一
	declare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N'DellacasaSistema', @loginlang = N'us_english'਀ऀ椀昀 䀀氀漀最椀渀搀戀 椀猀 渀甀氀氀 漀爀 渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀搀愀琀愀戀愀猀攀猀 眀栀攀爀攀 渀愀洀攀 㴀 䀀氀漀最椀渀搀戀⤀
		select @logindb = N'master'਀ऀ椀昀 䀀氀漀最椀渀氀愀渀最 椀猀 渀甀氀氀 漀爀 ⠀渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀氀愀渀最甀愀最攀猀 眀栀攀爀攀 渀愀洀攀 㴀 䀀氀漀最椀渀氀愀渀最⤀ 愀渀搀 䀀氀漀最椀渀氀愀渀最 㰀㸀 一✀甀猀开攀渀最氀椀猀栀✀⤀
		select @loginlang = @@language਀ऀ攀砀攀挀 猀瀀开愀搀搀氀漀最椀渀 一✀搀攀氀氀愀挀愀猀愀猀椀猀琀✀Ⰰ 渀甀氀氀Ⰰ 䀀氀漀最椀渀搀戀Ⰰ 䀀氀漀最椀渀氀愀渀最
END਀䜀伀
਀椀昀 渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀氀漀最椀渀猀 眀栀攀爀攀 氀漀最椀渀渀愀洀攀 㴀 一✀䐀嘀䐀䐀椀猀琀爀椀戀甀椀搀漀爀攀猀✀⤀
BEGIN਀ऀ搀攀挀氀愀爀攀 䀀氀漀最椀渀搀戀 渀瘀愀爀挀栀愀爀⠀㄀㌀㈀⤀Ⰰ 䀀氀漀最椀渀氀愀渀最 渀瘀愀爀挀栀愀爀⠀㄀㌀㈀⤀ 猀攀氀攀挀琀 䀀氀漀最椀渀搀戀 㴀 一✀䐀嘀䐀䐀椀猀琀爀椀戀甀椀搀漀爀攀猀✀Ⰰ 䀀氀漀最椀渀氀愀渀最 㴀 一✀甀猀开攀渀最氀椀猀栀✀
	if @logindb is null or not exists (select * from master.dbo.sysdatabases where name = @logindb)਀ऀऀ猀攀氀攀挀琀 䀀氀漀最椀渀搀戀 㴀 一✀洀愀猀琀攀爀✀
	if @loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english')਀ऀऀ猀攀氀攀挀琀 䀀氀漀最椀渀氀愀渀最 㴀 䀀䀀氀愀渀最甀愀最攀
	exec sp_addlogin N'DVDDistribuidores', null, @logindb, @loginlang਀䔀一䐀
GO਀
if not exists (select * from master.dbo.syslogins where loginname = N'ElBoyero')਀䈀䔀䜀䤀一
	declare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N'ElBoyero', @loginlang = N'us_english'਀ऀ椀昀 䀀氀漀最椀渀搀戀 椀猀 渀甀氀氀 漀爀 渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀搀愀琀愀戀愀猀攀猀 眀栀攀爀攀 渀愀洀攀 㴀 䀀氀漀最椀渀搀戀⤀
		select @logindb = N'master'਀ऀ椀昀 䀀氀漀最椀渀氀愀渀最 椀猀 渀甀氀氀 漀爀 ⠀渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀氀愀渀最甀愀最攀猀 眀栀攀爀攀 渀愀洀攀 㴀 䀀氀漀最椀渀氀愀渀最⤀ 愀渀搀 䀀氀漀最椀渀氀愀渀最 㰀㸀 一✀甀猀开攀渀最氀椀猀栀✀⤀
		select @loginlang = @@language਀ऀ攀砀攀挀 猀瀀开愀搀搀氀漀最椀渀 一✀䔀氀䈀漀礀攀爀漀✀Ⰰ 渀甀氀氀Ⰰ 䀀氀漀最椀渀搀戀Ⰰ 䀀氀漀最椀渀氀愀渀最
END਀䜀伀
਀椀昀 渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀氀漀最椀渀猀 眀栀攀爀攀 氀漀最椀渀渀愀洀攀 㴀 一✀䔀猀琀甀搀椀漀䌀攀爀瘀椀渀椀漀✀⤀
BEGIN਀ऀ搀攀挀氀愀爀攀 䀀氀漀最椀渀搀戀 渀瘀愀爀挀栀愀爀⠀㄀㌀㈀⤀Ⰰ 䀀氀漀最椀渀氀愀渀最 渀瘀愀爀挀栀愀爀⠀㄀㌀㈀⤀ 猀攀氀攀挀琀 䀀氀漀最椀渀搀戀 㴀 一✀䔀猀琀甀搀椀漀䌀攀爀瘀椀渀椀漀✀Ⰰ 䀀氀漀最椀渀氀愀渀最 㴀 一✀甀猀开攀渀最氀椀猀栀✀
	if @logindb is null or not exists (select * from master.dbo.sysdatabases where name = @logindb)਀ऀऀ猀攀氀攀挀琀 䀀氀漀最椀渀搀戀 㴀 一✀洀愀猀琀攀爀✀
	if @loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english')਀ऀऀ猀攀氀攀挀琀 䀀氀漀最椀渀氀愀渀最 㴀 䀀䀀氀愀渀最甀愀最攀
	exec sp_addlogin N'EstudioCervinio', null, @logindb, @loginlang਀䔀一䐀
GO਀
if not exists (select * from master.dbo.syslogins where loginname = N'EXODTareas')਀䈀䔀䜀䤀一
	declare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N'master', @loginlang = N'us_english'਀ऀ椀昀 䀀氀漀最椀渀搀戀 椀猀 渀甀氀氀 漀爀 渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀搀愀琀愀戀愀猀攀猀 眀栀攀爀攀 渀愀洀攀 㴀 䀀氀漀最椀渀搀戀⤀
		select @logindb = N'master'਀ऀ椀昀 䀀氀漀最椀渀氀愀渀最 椀猀 渀甀氀氀 漀爀 ⠀渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀氀愀渀最甀愀最攀猀 眀栀攀爀攀 渀愀洀攀 㴀 䀀氀漀最椀渀氀愀渀最⤀ 愀渀搀 䀀氀漀最椀渀氀愀渀最 㰀㸀 一✀甀猀开攀渀最氀椀猀栀✀⤀
		select @loginlang = @@language਀ऀ攀砀攀挀 猀瀀开愀搀搀氀漀最椀渀 一✀䔀堀伀䐀吀愀爀攀愀猀✀Ⰰ 渀甀氀氀Ⰰ 䀀氀漀最椀渀搀戀Ⰰ 䀀氀漀最椀渀氀愀渀最
END਀䜀伀
਀椀昀 渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀氀漀最椀渀猀 眀栀攀爀攀 氀漀最椀渀渀愀洀攀 㴀 一✀䜀攀漀挀愀爀琀漀最爀愀昀椀愀✀⤀
BEGIN਀ऀ搀攀挀氀愀爀攀 䀀氀漀最椀渀搀戀 渀瘀愀爀挀栀愀爀⠀㄀㌀㈀⤀Ⰰ 䀀氀漀最椀渀氀愀渀最 渀瘀愀爀挀栀愀爀⠀㄀㌀㈀⤀ 猀攀氀攀挀琀 䀀氀漀最椀渀搀戀 㴀 一✀䜀攀漀挀愀爀琀漀最爀愀昀椀愀✀Ⰰ 䀀氀漀最椀渀氀愀渀最 㴀 一✀甀猀开攀渀最氀椀猀栀✀
	if @logindb is null or not exists (select * from master.dbo.sysdatabases where name = @logindb)਀ऀऀ猀攀氀攀挀琀 䀀氀漀最椀渀搀戀 㴀 一✀洀愀猀琀攀爀✀
	if @loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english')਀ऀऀ猀攀氀攀挀琀 䀀氀漀最椀渀氀愀渀最 㴀 䀀䀀氀愀渀最甀愀最攀
	exec sp_addlogin N'Geocartografia', null, @logindb, @loginlang਀䔀一䐀
GO਀
if not exists (select * from master.dbo.syslogins where loginname = N'IISLogs')਀䈀䔀䜀䤀一
	declare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N'IISLogs', @loginlang = N'us_english'਀ऀ椀昀 䀀氀漀最椀渀搀戀 椀猀 渀甀氀氀 漀爀 渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀搀愀琀愀戀愀猀攀猀 眀栀攀爀攀 渀愀洀攀 㴀 䀀氀漀最椀渀搀戀⤀
		select @logindb = N'master'਀ऀ椀昀 䀀氀漀最椀渀氀愀渀最 椀猀 渀甀氀氀 漀爀 ⠀渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀氀愀渀最甀愀最攀猀 眀栀攀爀攀 渀愀洀攀 㴀 䀀氀漀最椀渀氀愀渀最⤀ 愀渀搀 䀀氀漀最椀渀氀愀渀最 㰀㸀 一✀甀猀开攀渀最氀椀猀栀✀⤀
		select @loginlang = @@language਀ऀ攀砀攀挀 猀瀀开愀搀搀氀漀最椀渀 一✀䤀䤀匀䰀漀最猀✀Ⰰ 渀甀氀氀Ⰰ 䀀氀漀最椀渀搀戀Ⰰ 䀀氀漀最椀渀氀愀渀最
END਀䜀伀
਀椀昀 渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀氀漀最椀渀猀 眀栀攀爀攀 氀漀最椀渀渀愀洀攀 㴀 一✀䬀漀甀爀愀䠀漀挀欀攀礀✀⤀
BEGIN਀ऀ搀攀挀氀愀爀攀 䀀氀漀最椀渀搀戀 渀瘀愀爀挀栀愀爀⠀㄀㌀㈀⤀Ⰰ 䀀氀漀最椀渀氀愀渀最 渀瘀愀爀挀栀愀爀⠀㄀㌀㈀⤀ 猀攀氀攀挀琀 䀀氀漀最椀渀搀戀 㴀 一✀䤀䤀匀䰀漀最猀✀Ⰰ 䀀氀漀最椀渀氀愀渀最 㴀 一✀甀猀开攀渀最氀椀猀栀✀
	if @logindb is null or not exists (select * from master.dbo.sysdatabases where name = @logindb)਀ऀऀ猀攀氀攀挀琀 䀀氀漀最椀渀搀戀 㴀 一✀洀愀猀琀攀爀✀
	if @loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english')਀ऀऀ猀攀氀攀挀琀 䀀氀漀最椀渀氀愀渀最 㴀 䀀䀀氀愀渀最甀愀最攀
	exec sp_addlogin N'KouraHockey', null, @logindb, @loginlang਀䔀一䐀
GO਀
if not exists (select * from master.dbo.syslogins where loginname = N'Maersrl')਀䈀䔀䜀䤀一
	declare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N'Maersrl', @loginlang = N'us_english'਀ऀ椀昀 䀀氀漀最椀渀搀戀 椀猀 渀甀氀氀 漀爀 渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀搀愀琀愀戀愀猀攀猀 眀栀攀爀攀 渀愀洀攀 㴀 䀀氀漀最椀渀搀戀⤀
		select @logindb = N'master'਀ऀ椀昀 䀀氀漀最椀渀氀愀渀最 椀猀 渀甀氀氀 漀爀 ⠀渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀氀愀渀最甀愀最攀猀 眀栀攀爀攀 渀愀洀攀 㴀 䀀氀漀最椀渀氀愀渀最⤀ 愀渀搀 䀀氀漀最椀渀氀愀渀最 㰀㸀 一✀甀猀开攀渀最氀椀猀栀✀⤀
		select @loginlang = @@language਀ऀ攀砀攀挀 猀瀀开愀搀搀氀漀最椀渀 一✀䴀愀攀爀猀爀氀✀Ⰰ 渀甀氀氀Ⰰ 䀀氀漀最椀渀搀戀Ⰰ 䀀氀漀最椀渀氀愀渀最
END਀䜀伀
਀椀昀 渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀氀漀最椀渀猀 眀栀攀爀攀 氀漀最椀渀渀愀洀攀 㴀 一✀䴀䐀愀攀洀漀渀✀⤀
BEGIN਀ऀ搀攀挀氀愀爀攀 䀀氀漀最椀渀搀戀 渀瘀愀爀挀栀愀爀⠀㄀㌀㈀⤀Ⰰ 䀀氀漀最椀渀氀愀渀最 渀瘀愀爀挀栀愀爀⠀㄀㌀㈀⤀ 猀攀氀攀挀琀 䀀氀漀最椀渀搀戀 㴀 一✀䴀䐀愀攀洀漀渀✀Ⰰ 䀀氀漀最椀渀氀愀渀最 㴀 一✀甀猀开攀渀最氀椀猀栀✀
	if @logindb is null or not exists (select * from master.dbo.sysdatabases where name = @logindb)਀ऀऀ猀攀氀攀挀琀 䀀氀漀最椀渀搀戀 㴀 一✀洀愀猀琀攀爀✀
	if @loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english')਀ऀऀ猀攀氀攀挀琀 䀀氀漀最椀渀氀愀渀最 㴀 䀀䀀氀愀渀最甀愀最攀
	exec sp_addlogin N'MDaemon', null, @logindb, @loginlang਀䔀一䐀
GO਀
if not exists (select * from master.dbo.syslogins where loginname = N'MedAndLabs')਀䈀䔀䜀䤀一
	declare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N'MedAndLabs', @loginlang = N'us_english'਀ऀ椀昀 䀀氀漀最椀渀搀戀 椀猀 渀甀氀氀 漀爀 渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀搀愀琀愀戀愀猀攀猀 眀栀攀爀攀 渀愀洀攀 㴀 䀀氀漀最椀渀搀戀⤀
		select @logindb = N'master'਀ऀ椀昀 䀀氀漀最椀渀氀愀渀最 椀猀 渀甀氀氀 漀爀 ⠀渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀氀愀渀最甀愀最攀猀 眀栀攀爀攀 渀愀洀攀 㴀 䀀氀漀最椀渀氀愀渀最⤀ 愀渀搀 䀀氀漀最椀渀氀愀渀最 㰀㸀 一✀甀猀开攀渀最氀椀猀栀✀⤀
		select @loginlang = @@language਀ऀ攀砀攀挀 猀瀀开愀搀搀氀漀最椀渀 一✀䴀攀搀䄀渀搀䰀愀戀猀✀Ⰰ 渀甀氀氀Ⰰ 䀀氀漀最椀渀搀戀Ⰰ 䀀氀漀最椀渀氀愀渀最
END਀䜀伀
਀椀昀 渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀氀漀最椀渀猀 眀栀攀爀攀 氀漀最椀渀渀愀洀攀 㴀 一✀䴀攀搀礀䰀愀戀✀⤀
BEGIN਀ऀ搀攀挀氀愀爀攀 䀀氀漀最椀渀搀戀 渀瘀愀爀挀栀愀爀⠀㄀㌀㈀⤀Ⰰ 䀀氀漀最椀渀氀愀渀最 渀瘀愀爀挀栀愀爀⠀㄀㌀㈀⤀ 猀攀氀攀挀琀 䀀氀漀最椀渀搀戀 㴀 一✀䴀攀搀礀䰀愀戀✀Ⰰ 䀀氀漀最椀渀氀愀渀最 㴀 一✀甀猀开攀渀最氀椀猀栀✀
	if @logindb is null or not exists (select * from master.dbo.sysdatabases where name = @logindb)਀ऀऀ猀攀氀攀挀琀 䀀氀漀最椀渀搀戀 㴀 一✀洀愀猀琀攀爀✀
	if @loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english')਀ऀऀ猀攀氀攀挀琀 䀀氀漀最椀渀氀愀渀最 㴀 䀀䀀氀愀渀最甀愀最攀
	exec sp_addlogin N'MedyLab', null, @logindb, @loginlang਀䔀一䐀
GO਀
if not exists (select * from master.dbo.syslogins where loginname = N'Miliners')਀䈀䔀䜀䤀一
	declare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N'Miliners', @loginlang = N'us_english'਀ऀ椀昀 䀀氀漀最椀渀搀戀 椀猀 渀甀氀氀 漀爀 渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀搀愀琀愀戀愀猀攀猀 眀栀攀爀攀 渀愀洀攀 㴀 䀀氀漀最椀渀搀戀⤀
		select @logindb = N'master'਀ऀ椀昀 䀀氀漀最椀渀氀愀渀最 椀猀 渀甀氀氀 漀爀 ⠀渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀氀愀渀最甀愀最攀猀 眀栀攀爀攀 渀愀洀攀 㴀 䀀氀漀最椀渀氀愀渀最⤀ 愀渀搀 䀀氀漀最椀渀氀愀渀最 㰀㸀 一✀甀猀开攀渀最氀椀猀栀✀⤀
		select @loginlang = @@language਀ऀ攀砀攀挀 猀瀀开愀搀搀氀漀最椀渀 一✀䴀椀氀椀渀攀爀猀✀Ⰰ 渀甀氀氀Ⰰ 䀀氀漀最椀渀搀戀Ⰰ 䀀氀漀最椀渀氀愀渀最
END਀䜀伀
਀椀昀 渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀氀漀最椀渀猀 眀栀攀爀攀 氀漀最椀渀渀愀洀攀 㴀 一✀倀愀琀愀最漀渀椀愀渀氀愀渀搀猀✀⤀
BEGIN਀ऀ搀攀挀氀愀爀攀 䀀氀漀最椀渀搀戀 渀瘀愀爀挀栀愀爀⠀㄀㌀㈀⤀Ⰰ 䀀氀漀最椀渀氀愀渀最 渀瘀愀爀挀栀愀爀⠀㄀㌀㈀⤀ 猀攀氀攀挀琀 䀀氀漀最椀渀搀戀 㴀 一✀倀愀琀愀最漀渀椀愀渀氀愀渀搀猀✀Ⰰ 䀀氀漀最椀渀氀愀渀最 㴀 一✀甀猀开攀渀最氀椀猀栀✀
	if @logindb is null or not exists (select * from master.dbo.sysdatabases where name = @logindb)਀ऀऀ猀攀氀攀挀琀 䀀氀漀最椀渀搀戀 㴀 一✀洀愀猀琀攀爀✀
	if @loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english')਀ऀऀ猀攀氀攀挀琀 䀀氀漀最椀渀氀愀渀最 㴀 䀀䀀氀愀渀最甀愀最攀
	exec sp_addlogin N'Patagonianlands', null, @logindb, @loginlang਀䔀一䐀
GO਀
if not exists (select * from master.dbo.syslogins where loginname = N'plastico')਀䈀䔀䜀䤀一
	declare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N'Plasticoslucero', @loginlang = N'us_english'਀ऀ椀昀 䀀氀漀最椀渀搀戀 椀猀 渀甀氀氀 漀爀 渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀搀愀琀愀戀愀猀攀猀 眀栀攀爀攀 渀愀洀攀 㴀 䀀氀漀最椀渀搀戀⤀
		select @logindb = N'master'਀ऀ椀昀 䀀氀漀最椀渀氀愀渀最 椀猀 渀甀氀氀 漀爀 ⠀渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀氀愀渀最甀愀最攀猀 眀栀攀爀攀 渀愀洀攀 㴀 䀀氀漀最椀渀氀愀渀最⤀ 愀渀搀 䀀氀漀最椀渀氀愀渀最 㰀㸀 一✀甀猀开攀渀最氀椀猀栀✀⤀
		select @loginlang = @@language਀ऀ攀砀攀挀 猀瀀开愀搀搀氀漀最椀渀 一✀瀀氀愀猀琀椀挀漀✀Ⰰ 渀甀氀氀Ⰰ 䀀氀漀最椀渀搀戀Ⰰ 䀀氀漀最椀渀氀愀渀最
END਀䜀伀
਀椀昀 渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀氀漀最椀渀猀 眀栀攀爀攀 氀漀最椀渀渀愀洀攀 㴀 一✀倀爀漀瘀攀洀攀搀椀挀愀✀⤀
BEGIN਀ऀ搀攀挀氀愀爀攀 䀀氀漀最椀渀搀戀 渀瘀愀爀挀栀愀爀⠀㄀㌀㈀⤀Ⰰ 䀀氀漀最椀渀氀愀渀最 渀瘀愀爀挀栀愀爀⠀㄀㌀㈀⤀ 猀攀氀攀挀琀 䀀氀漀最椀渀搀戀 㴀 一✀倀爀漀瘀攀洀攀搀椀挀愀✀Ⰰ 䀀氀漀最椀渀氀愀渀最 㴀 一✀甀猀开攀渀最氀椀猀栀✀
	if @logindb is null or not exists (select * from master.dbo.sysdatabases where name = @logindb)਀ऀऀ猀攀氀攀挀琀 䀀氀漀最椀渀搀戀 㴀 一✀洀愀猀琀攀爀✀
	if @loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english')਀ऀऀ猀攀氀攀挀琀 䀀氀漀最椀渀氀愀渀最 㴀 䀀䀀氀愀渀最甀愀最攀
	exec sp_addlogin N'Provemedica', null, @logindb, @loginlang਀䔀一䐀
GO਀
if not exists (select * from master.dbo.syslogins where loginname = N'Rafaela')਀䈀䔀䜀䤀一
	declare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N'Rafaela', @loginlang = N'us_english'਀ऀ椀昀 䀀氀漀最椀渀搀戀 椀猀 渀甀氀氀 漀爀 渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀搀愀琀愀戀愀猀攀猀 眀栀攀爀攀 渀愀洀攀 㴀 䀀氀漀最椀渀搀戀⤀
		select @logindb = N'master'਀ऀ椀昀 䀀氀漀最椀渀氀愀渀最 椀猀 渀甀氀氀 漀爀 ⠀渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀氀愀渀最甀愀最攀猀 眀栀攀爀攀 渀愀洀攀 㴀 䀀氀漀最椀渀氀愀渀最⤀ 愀渀搀 䀀氀漀最椀渀氀愀渀最 㰀㸀 一✀甀猀开攀渀最氀椀猀栀✀⤀
		select @loginlang = @@language਀ऀ攀砀攀挀 猀瀀开愀搀搀氀漀最椀渀 一✀刀愀昀愀攀氀愀✀Ⰰ 渀甀氀氀Ⰰ 䀀氀漀最椀渀搀戀Ⰰ 䀀氀漀最椀渀氀愀渀最
END਀䜀伀
਀椀昀 渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀氀漀最椀渀猀 眀栀攀爀攀 氀漀最椀渀渀愀洀攀 㴀 一✀匀栀漀瀀琀漀漀氀猀✀⤀
BEGIN਀ऀ搀攀挀氀愀爀攀 䀀氀漀最椀渀搀戀 渀瘀愀爀挀栀愀爀⠀㄀㌀㈀⤀Ⰰ 䀀氀漀最椀渀氀愀渀最 渀瘀愀爀挀栀愀爀⠀㄀㌀㈀⤀ 猀攀氀攀挀琀 䀀氀漀最椀渀搀戀 㴀 一✀匀栀漀瀀琀漀漀氀猀✀Ⰰ 䀀氀漀最椀渀氀愀渀最 㴀 一✀甀猀开攀渀最氀椀猀栀✀
	if @logindb is null or not exists (select * from master.dbo.sysdatabases where name = @logindb)਀ऀऀ猀攀氀攀挀琀 䀀氀漀最椀渀搀戀 㴀 一✀洀愀猀琀攀爀✀
	if @loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english')਀ऀऀ猀攀氀攀挀琀 䀀氀漀最椀渀氀愀渀最 㴀 䀀䀀氀愀渀最甀愀最攀
	exec sp_addlogin N'Shoptools', null, @logindb, @loginlang਀䔀一䐀
GO਀
if not exists (select * from master.dbo.syslogins where loginname = N'StratadesignFA')਀䈀䔀䜀䤀一
	declare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N'Stratadesign', @loginlang = N'us_english'਀ऀ椀昀 䀀氀漀最椀渀搀戀 椀猀 渀甀氀氀 漀爀 渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀搀愀琀愀戀愀猀攀猀 眀栀攀爀攀 渀愀洀攀 㴀 䀀氀漀最椀渀搀戀⤀
		select @logindb = N'master'਀ऀ椀昀 䀀氀漀最椀渀氀愀渀最 椀猀 渀甀氀氀 漀爀 ⠀渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀氀愀渀最甀愀最攀猀 眀栀攀爀攀 渀愀洀攀 㴀 䀀氀漀最椀渀氀愀渀最⤀ 愀渀搀 䀀氀漀最椀渀氀愀渀最 㰀㸀 一✀甀猀开攀渀最氀椀猀栀✀⤀
		select @loginlang = @@language਀ऀ攀砀攀挀 猀瀀开愀搀搀氀漀最椀渀 一✀匀琀爀愀琀愀搀攀猀椀最渀䘀䄀✀Ⰰ 渀甀氀氀Ⰰ 䀀氀漀最椀渀搀戀Ⰰ 䀀氀漀最椀渀氀愀渀最
END਀䜀伀
਀椀昀 渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀氀漀最椀渀猀 眀栀攀爀攀 氀漀最椀渀渀愀洀攀 㴀 一✀匀甀最愀爀㌀搀✀⤀
BEGIN਀ऀ搀攀挀氀愀爀攀 䀀氀漀最椀渀搀戀 渀瘀愀爀挀栀愀爀⠀㄀㌀㈀⤀Ⰰ 䀀氀漀最椀渀氀愀渀最 渀瘀愀爀挀栀愀爀⠀㄀㌀㈀⤀ 猀攀氀攀挀琀 䀀氀漀最椀渀搀戀 㴀 一✀匀甀最愀爀㌀搀✀Ⰰ 䀀氀漀最椀渀氀愀渀最 㴀 一✀甀猀开攀渀最氀椀猀栀✀
	if @logindb is null or not exists (select * from master.dbo.sysdatabases where name = @logindb)਀ऀऀ猀攀氀攀挀琀 䀀氀漀最椀渀搀戀 㴀 一✀洀愀猀琀攀爀✀
	if @loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english')਀ऀऀ猀攀氀攀挀琀 䀀氀漀最椀渀氀愀渀最 㴀 䀀䀀氀愀渀最甀愀最攀
	exec sp_addlogin N'Sugar3d', null, @logindb, @loginlang਀䔀一䐀
GO਀
if not exists (select * from master.dbo.syslogins where loginname = N'Tactica')਀䈀䔀䜀䤀一
	declare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N'Tactica', @loginlang = N'us_english'਀ऀ椀昀 䀀氀漀最椀渀搀戀 椀猀 渀甀氀氀 漀爀 渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀搀愀琀愀戀愀猀攀猀 眀栀攀爀攀 渀愀洀攀 㴀 䀀氀漀最椀渀搀戀⤀
		select @logindb = N'master'਀ऀ椀昀 䀀氀漀最椀渀氀愀渀最 椀猀 渀甀氀氀 漀爀 ⠀渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀氀愀渀最甀愀最攀猀 眀栀攀爀攀 渀愀洀攀 㴀 䀀氀漀最椀渀氀愀渀最⤀ 愀渀搀 䀀氀漀最椀渀氀愀渀最 㰀㸀 一✀甀猀开攀渀最氀椀猀栀✀⤀
		select @loginlang = @@language਀ऀ攀砀攀挀 猀瀀开愀搀搀氀漀最椀渀 一✀吀愀挀琀椀挀愀✀Ⰰ 渀甀氀氀Ⰰ 䀀氀漀最椀渀搀戀Ⰰ 䀀氀漀最椀渀氀愀渀最
END਀䜀伀
਀椀昀 渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀氀漀最椀渀猀 眀栀攀爀攀 氀漀最椀渀渀愀洀攀 㴀 一✀吀攀猀琀开䄀洀戀愀猀✀⤀
BEGIN਀ऀ搀攀挀氀愀爀攀 䀀氀漀最椀渀搀戀 渀瘀愀爀挀栀愀爀⠀㄀㌀㈀⤀Ⰰ 䀀氀漀最椀渀氀愀渀最 渀瘀愀爀挀栀愀爀⠀㄀㌀㈀⤀ 猀攀氀攀挀琀 䀀氀漀最椀渀搀戀 㴀 一✀吀攀猀琀开䄀洀戀愀猀✀Ⰰ 䀀氀漀最椀渀氀愀渀最 㴀 一✀甀猀开攀渀最氀椀猀栀✀
	if @logindb is null or not exists (select * from master.dbo.sysdatabases where name = @logindb)਀ऀऀ猀攀氀攀挀琀 䀀氀漀最椀渀搀戀 㴀 一✀洀愀猀琀攀爀✀
	if @loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english')਀ऀऀ猀攀氀攀挀琀 䀀氀漀最椀渀氀愀渀最 㴀 䀀䀀氀愀渀最甀愀最攀
	exec sp_addlogin N'Test_Ambas', null, @logindb, @loginlang਀䔀一䐀
GO਀
if not exists (select * from master.dbo.syslogins where loginname = N'Test_Asiar')਀䈀䔀䜀䤀一
	declare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N'Test_Asiar', @loginlang = N'us_english'਀ऀ椀昀 䀀氀漀最椀渀搀戀 椀猀 渀甀氀氀 漀爀 渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀搀愀琀愀戀愀猀攀猀 眀栀攀爀攀 渀愀洀攀 㴀 䀀氀漀最椀渀搀戀⤀
		select @logindb = N'master'਀ऀ椀昀 䀀氀漀最椀渀氀愀渀最 椀猀 渀甀氀氀 漀爀 ⠀渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀氀愀渀最甀愀最攀猀 眀栀攀爀攀 渀愀洀攀 㴀 䀀氀漀最椀渀氀愀渀最⤀ 愀渀搀 䀀氀漀最椀渀氀愀渀最 㰀㸀 一✀甀猀开攀渀最氀椀猀栀✀⤀
		select @loginlang = @@language਀ऀ攀砀攀挀 猀瀀开愀搀搀氀漀最椀渀 一✀吀攀猀琀开䄀猀椀愀爀✀Ⰰ 渀甀氀氀Ⰰ 䀀氀漀最椀渀搀戀Ⰰ 䀀氀漀最椀渀氀愀渀最
END਀䜀伀
਀椀昀 渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀氀漀最椀渀猀 眀栀攀爀攀 氀漀最椀渀渀愀洀攀 㴀 一✀吀攀猀琀开匀琀爀愀琀愀✀⤀
BEGIN਀ऀ搀攀挀氀愀爀攀 䀀氀漀最椀渀搀戀 渀瘀愀爀挀栀愀爀⠀㄀㌀㈀⤀Ⰰ 䀀氀漀最椀渀氀愀渀最 渀瘀愀爀挀栀愀爀⠀㄀㌀㈀⤀ 猀攀氀攀挀琀 䀀氀漀最椀渀搀戀 㴀 一✀吀攀猀琀开匀琀爀愀琀愀✀Ⰰ 䀀氀漀最椀渀氀愀渀最 㴀 一✀甀猀开攀渀最氀椀猀栀✀
	if @logindb is null or not exists (select * from master.dbo.sysdatabases where name = @logindb)਀ऀऀ猀攀氀攀挀琀 䀀氀漀最椀渀搀戀 㴀 一✀洀愀猀琀攀爀✀
	if @loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english')਀ऀऀ猀攀氀攀挀琀 䀀氀漀最椀渀氀愀渀最 㴀 䀀䀀氀愀渀最甀愀最攀
	exec sp_addlogin N'Test_Strata', null, @logindb, @loginlang਀䔀一䐀
GO਀
if not exists (select * from master.dbo.syslogins where loginname = N'VissenFA')਀䈀䔀䜀䤀一
	declare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N'Vissen-Fuego', @loginlang = N'us_english'਀ऀ椀昀 䀀氀漀最椀渀搀戀 椀猀 渀甀氀氀 漀爀 渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀搀愀琀愀戀愀猀攀猀 眀栀攀爀攀 渀愀洀攀 㴀 䀀氀漀最椀渀搀戀⤀
		select @logindb = N'master'਀ऀ椀昀 䀀氀漀最椀渀氀愀渀最 椀猀 渀甀氀氀 漀爀 ⠀渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀氀愀渀最甀愀最攀猀 眀栀攀爀攀 渀愀洀攀 㴀 䀀氀漀最椀渀氀愀渀最⤀ 愀渀搀 䀀氀漀最椀渀氀愀渀最 㰀㸀 一✀甀猀开攀渀最氀椀猀栀✀⤀
		select @loginlang = @@language਀ऀ攀砀攀挀 猀瀀开愀搀搀氀漀最椀渀 一✀嘀椀猀猀攀渀䘀䄀✀Ⰰ 渀甀氀氀Ⰰ 䀀氀漀最椀渀搀戀Ⰰ 䀀氀漀最椀渀氀愀渀最
END਀䜀伀
਀椀昀 渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀氀漀最椀渀猀 眀栀攀爀攀 氀漀最椀渀渀愀洀攀 㴀 一✀嘀椀猀猀攀渀刀伀✀⤀
BEGIN਀ऀ搀攀挀氀愀爀攀 䀀氀漀最椀渀搀戀 渀瘀愀爀挀栀愀爀⠀㄀㌀㈀⤀Ⰰ 䀀氀漀最椀渀氀愀渀最 渀瘀愀爀挀栀愀爀⠀㄀㌀㈀⤀ 猀攀氀攀挀琀 䀀氀漀最椀渀搀戀 㴀 一✀嘀椀猀猀攀渀ⴀ䘀甀攀最漀✀Ⰰ 䀀氀漀最椀渀氀愀渀最 㴀 一✀甀猀开攀渀最氀椀猀栀✀
	if @logindb is null or not exists (select * from master.dbo.sysdatabases where name = @logindb)਀ऀऀ猀攀氀攀挀琀 䀀氀漀最椀渀搀戀 㴀 一✀洀愀猀琀攀爀✀
	if @loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english')਀ऀऀ猀攀氀攀挀琀 䀀氀漀最椀渀氀愀渀最 㴀 䀀䀀氀愀渀最甀愀最攀
	exec sp_addlogin N'VissenRO', null, @logindb, @loginlang਀䔀一䐀
GO਀
if not exists (select * from master.dbo.syslogins where loginname = N'WebSiteReadOnly')਀䈀䔀䜀䤀一
	declare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N'WebSiteSolutions', @loginlang = N'us_english'਀ऀ椀昀 䀀氀漀最椀渀搀戀 椀猀 渀甀氀氀 漀爀 渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀搀愀琀愀戀愀猀攀猀 眀栀攀爀攀 渀愀洀攀 㴀 䀀氀漀最椀渀搀戀⤀
		select @logindb = N'master'਀ऀ椀昀 䀀氀漀最椀渀氀愀渀最 椀猀 渀甀氀氀 漀爀 ⠀渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀氀愀渀最甀愀最攀猀 眀栀攀爀攀 渀愀洀攀 㴀 䀀氀漀最椀渀氀愀渀最⤀ 愀渀搀 䀀氀漀最椀渀氀愀渀最 㰀㸀 一✀甀猀开攀渀最氀椀猀栀✀⤀
		select @loginlang = @@language਀ऀ攀砀攀挀 猀瀀开愀搀搀氀漀最椀渀 一✀圀攀戀匀椀琀攀刀攀愀搀伀渀氀礀✀Ⰰ 渀甀氀氀Ⰰ 䀀氀漀最椀渀搀戀Ⰰ 䀀氀漀最椀渀氀愀渀最
END਀䜀伀
਀椀昀 渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀氀漀最椀渀猀 眀栀攀爀攀 氀漀最椀渀渀愀洀攀 㴀 一✀圀攀戀匀椀琀攀匀漀氀甀琀椀漀渀猀✀⤀
BEGIN਀ऀ搀攀挀氀愀爀攀 䀀氀漀最椀渀搀戀 渀瘀愀爀挀栀愀爀⠀㄀㌀㈀⤀Ⰰ 䀀氀漀最椀渀氀愀渀最 渀瘀愀爀挀栀愀爀⠀㄀㌀㈀⤀ 猀攀氀攀挀琀 䀀氀漀最椀渀搀戀 㴀 一✀圀攀戀匀椀琀攀匀漀氀甀琀椀漀渀猀✀Ⰰ 䀀氀漀最椀渀氀愀渀最 㴀 一✀甀猀开攀渀最氀椀猀栀✀
	if @logindb is null or not exists (select * from master.dbo.sysdatabases where name = @logindb)਀ऀऀ猀攀氀攀挀琀 䀀氀漀最椀渀搀戀 㴀 一✀洀愀猀琀攀爀✀
	if @loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english')਀ऀऀ猀攀氀攀挀琀 䀀氀漀最椀渀氀愀渀最 㴀 䀀䀀氀愀渀最甀愀最攀
	exec sp_addlogin N'WebSiteSolutions', null, @logindb, @loginlang਀䔀一䐀
GO਀
if not exists (select * from master.dbo.syslogins where loginname = N'WSSCPFA')਀䈀䔀䜀䤀一
	declare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N'WSSControlPanel', @loginlang = N'us_english'਀ऀ椀昀 䀀氀漀最椀渀搀戀 椀猀 渀甀氀氀 漀爀 渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀搀愀琀愀戀愀猀攀猀 眀栀攀爀攀 渀愀洀攀 㴀 䀀氀漀最椀渀搀戀⤀
		select @logindb = N'master'਀ऀ椀昀 䀀氀漀最椀渀氀愀渀最 椀猀 渀甀氀氀 漀爀 ⠀渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀氀愀渀最甀愀最攀猀 眀栀攀爀攀 渀愀洀攀 㴀 䀀氀漀最椀渀氀愀渀最⤀ 愀渀搀 䀀氀漀最椀渀氀愀渀最 㰀㸀 一✀甀猀开攀渀最氀椀猀栀✀⤀
		select @loginlang = @@language਀ऀ攀砀攀挀 猀瀀开愀搀搀氀漀最椀渀 一✀圀匀匀䌀倀䘀䄀✀Ⰰ 渀甀氀氀Ⰰ 䀀氀漀最椀渀搀戀Ⰰ 䀀氀漀最椀渀氀愀渀最
END਀䜀伀
਀椀昀 渀漀琀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ⨀ 昀爀漀洀 洀愀猀琀攀爀⸀搀戀漀⸀猀礀猀氀漀最椀渀猀 眀栀攀爀攀 氀漀最椀渀渀愀洀攀 㴀 一✀圀匀匀䌀倀刀伀✀⤀
BEGIN਀ऀ搀攀挀氀愀爀攀 䀀氀漀最椀渀搀戀 渀瘀愀爀挀栀愀爀⠀㄀㌀㈀⤀Ⰰ 䀀氀漀最椀渀氀愀渀最 渀瘀愀爀挀栀愀爀⠀㄀㌀㈀⤀ 猀攀氀攀挀琀 䀀氀漀最椀渀搀戀 㴀 一✀圀匀匀䌀漀渀琀爀漀氀倀愀渀攀氀✀Ⰰ 䀀氀漀最椀渀氀愀渀最 㴀 一✀甀猀开攀渀最氀椀猀栀✀
	if @logindb is null or not exists (select * from master.dbo.sysdatabases where name = @logindb)਀ऀऀ猀攀氀攀挀琀 䀀氀漀最椀渀搀戀 㴀 一✀洀愀猀琀攀爀✀
	if @loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english')਀ऀऀ猀攀氀攀挀琀 䀀氀漀最椀渀氀愀渀最 㴀 䀀䀀氀愀渀最甀愀最攀
	exec sp_addlogin N'WSSCPRO', null, @logindb, @loginlang਀䔀一䐀
GO਀
if not exists (select * from dbo.sysusers where name = N'Asiar' and uid < 16382)਀ऀ䔀堀䔀䌀 猀瀀开最爀愀渀琀搀戀愀挀挀攀猀猀 一✀䄀猀椀愀爀✀
GO਀
if not exists (select * from dbo.sysusers where name = N'AsiarFA' and uid < 16382)਀ऀ䔀堀䔀䌀 猀瀀开最爀愀渀琀搀戀愀挀挀攀猀猀 一✀䄀猀椀愀爀䘀䄀✀Ⰰ 一✀䄀猀椀愀爀䘀䄀✀
GO਀
if not exists (select * from dbo.sysusers where name = N'dboasiar' and uid < 16382)਀ऀ䔀堀䔀䌀 猀瀀开最爀愀渀琀搀戀愀挀挀攀猀猀 一✀搀戀漀愀猀椀愀爀✀
GO਀
if not exists (select * from dbo.sysusers where name = N'sqlasiar' and uid < 16382)਀ऀ䔀堀䔀䌀 猀瀀开最爀愀渀琀搀戀愀挀挀攀猀猀 一✀猀焀氀愀猀椀愀爀✀
GO਀
exec sp_addrolemember N'db_owner', N'Asiar'਀䜀伀
਀攀砀攀挀 猀瀀开愀搀搀爀漀氀攀洀攀洀戀攀爀 一✀搀戀开漀眀渀攀爀✀Ⰰ 一✀䄀猀椀愀爀䘀䄀✀
GO਀
exec sp_addrolemember N'db_owner', N'dboasiar'਀䜀伀
਀䌀刀䔀䄀吀䔀 吀䄀䈀䰀䔀 嬀搀戀漀崀⸀嬀䄀搀洀椀渀崀 ⠀
	[idUser] [int] IDENTITY (1, 1) NOT NULL ,਀ऀ嬀一漀洀戀爀攀崀 嬀瘀愀爀挀栀愀爀崀 ⠀㔀　⤀ 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 Ⰰ
	[Apellido] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,਀ऀ嬀唀猀攀爀渀愀洀攀崀 嬀瘀愀爀挀栀愀爀崀 ⠀㔀　⤀ 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 Ⰰ
	[Password] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ਀⤀ 伀一 嬀倀刀䤀䴀䄀刀夀崀
GO਀
CREATE TABLE [dbo].[Clientes] (਀ऀ嬀椀搀䌀氀椀攀渀琀攀崀 嬀椀渀琀崀 䤀䐀䔀一吀䤀吀夀 ⠀㄀Ⰰ ㄀⤀ 一伀吀 一唀䰀䰀 Ⰰ
	[Logo] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,਀ऀ嬀一漀洀戀爀攀崀 嬀瘀愀爀挀栀愀爀崀 ⠀㄀　　⤀ 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 Ⰰ
	[URL] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,਀ऀ嬀一漀洀戀爀攀䤀渀最崀 嬀瘀愀爀挀栀愀爀崀 ⠀㄀　　⤀ 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 Ⰰ
	[idSubCategoria] [int] NULL ਀⤀ 伀一 嬀倀刀䤀䴀䄀刀夀崀
GO਀
CREATE TABLE [dbo].[EmpresasPorRubro] (਀ऀ嬀椀搀崀 嬀椀渀琀崀 䤀䐀䔀一吀䤀吀夀 ⠀㄀Ⰰ ㄀⤀ 一伀吀 一唀䰀䰀 Ⰰ
	[idCliente] [int] NULL ,਀ऀ嬀椀搀刀甀戀爀漀崀 嬀椀渀琀崀 一唀䰀䰀 
) ON [PRIMARY]਀䜀伀
਀䌀刀䔀䄀吀䔀 吀䄀䈀䰀䔀 嬀搀戀漀崀⸀嬀䔀猀琀愀搀嘀椀猀椀琀愀猀崀 ⠀
	[id] [int] IDENTITY (1, 1) NOT NULL ,਀ऀ嬀昀攀挀栀愀崀 嬀搀愀琀攀琀椀洀攀崀 一唀䰀䰀 Ⰰ
	[remote_ip] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ਀⤀ 伀一 嬀倀刀䤀䴀䄀刀夀崀
GO਀
CREATE TABLE [dbo].[Eventos] (਀ऀ嬀䤀䐀䔀瘀攀渀琀漀崀 嬀椀渀琀崀 䤀䐀䔀一吀䤀吀夀 ⠀㄀Ⰰ ㄀⤀ 一伀吀 一唀䰀䰀 Ⰰ
	[Titulo] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,਀ऀ嬀䌀椀甀搀愀搀崀 嬀瘀愀爀挀栀愀爀崀 ⠀㔀　⤀ 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 Ⰰ
	[Pais] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,਀ऀ嬀䘀攀挀栀愀崀 嬀搀愀琀攀琀椀洀攀崀 一唀䰀䰀 Ⰰ
	[Duracion] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,਀ऀ嬀伀戀樀攀琀椀瘀漀崀 嬀琀攀砀琀崀 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 Ⰰ
	[Participantes] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,਀ऀ嬀䌀氀椀攀渀琀攀猀崀 嬀瘀愀爀挀栀愀爀崀 ⠀㔀　⤀ 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 Ⰰ
	[Resultados] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,਀ऀ嬀䠀漀洀攀崀 嬀戀椀琀崀 一唀䰀䰀 Ⰰ
	[Logo] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,਀ऀ嬀吀椀琀甀氀漀椀渀最崀 嬀瘀愀爀挀栀愀爀崀 ⠀㔀　⤀ 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 Ⰰ
	[Ciudading] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,਀ऀ嬀倀愀椀猀椀渀最崀 嬀瘀愀爀挀栀愀爀崀 ⠀㔀　⤀ 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 Ⰰ
	[Duracioning] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,਀ऀ嬀伀戀樀攀琀椀瘀漀椀渀最崀 嬀琀攀砀琀崀 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 Ⰰ
	[Resultadosing] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ਀⤀ 伀一 嬀倀刀䤀䴀䄀刀夀崀 吀䔀堀吀䤀䴀䄀䜀䔀开伀一 嬀倀刀䤀䴀䄀刀夀崀
GO਀
CREATE TABLE [dbo].[Misiones] (਀ऀ嬀椀搀䴀椀猀椀漀渀崀 嬀椀渀琀崀 䤀䐀䔀一吀䤀吀夀 ⠀㄀Ⰰ ㄀⤀ 一伀吀 一唀䰀䰀 Ⰰ
	[Titulo] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,਀ऀ嬀䰀漀最漀崀 嬀瘀愀爀挀栀愀爀崀 ⠀㔀　⤀ 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 Ⰰ
	[Gacetilla] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,਀ऀ嬀䌀椀甀搀愀搀崀 嬀瘀愀爀挀栀愀爀崀 ⠀㔀　⤀ 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 Ⰰ
	[Pais] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,਀ऀ嬀䐀攀猀搀攀崀 嬀搀愀琀攀琀椀洀攀崀 一唀䰀䰀 Ⰰ
	[Hasta] [datetime] NULL ,਀ऀ嬀䐀甀爀愀挀椀漀渀崀 嬀瘀愀爀挀栀愀爀崀 ⠀㔀　⤀ 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 Ⰰ
	[objetivo] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,਀ऀ嬀倀愀爀琀椀挀椀瀀愀渀琀攀猀崀 嬀琀攀砀琀崀 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 Ⰰ
	[Empresa] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,਀ऀ嬀䌀氀椀攀渀琀攀猀崀 嬀瘀愀爀挀栀愀爀崀 ⠀㔀　⤀ 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 Ⰰ
	[Resultados] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,਀ऀ嬀䠀漀洀攀崀 嬀戀椀琀崀 一唀䰀䰀 Ⰰ
	[Tituloing] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,਀ऀ嬀䜀愀挀攀琀椀氀氀愀椀渀最崀 嬀琀攀砀琀崀 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 Ⰰ
	[Ciudading] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,਀ऀ嬀倀愀椀猀椀渀最崀 嬀瘀愀爀挀栀愀爀崀 ⠀㔀　⤀ 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 Ⰰ
	[Duracioning] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,਀ऀ嬀漀戀樀攀琀椀瘀漀椀渀最崀 嬀琀攀砀琀崀 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 Ⰰ
	[Participantesing] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,਀ऀ嬀刀攀猀甀氀琀愀搀漀猀椀渀最崀 嬀琀攀砀琀崀 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]਀䜀伀
਀䌀刀䔀䄀吀䔀 吀䄀䈀䰀䔀 嬀搀戀漀崀⸀嬀伀昀椀挀椀渀愀猀崀 ⠀
	[IDOficinas] [int] IDENTITY (1, 1) NOT NULL ,਀ऀ嬀吀椀琀甀氀漀崀 嬀瘀愀爀挀栀愀爀崀 ⠀㔀　⤀ 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 Ⰰ
	[Texto] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,਀ऀ嬀䔀洀愀椀氀崀 嬀瘀愀爀挀栀愀爀崀 ⠀㄀㔀　⤀ 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 Ⰰ
	[TituloIng] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,਀ऀ嬀吀攀砀琀漀䤀渀最崀 嬀瘀愀爀挀栀愀爀崀 ⠀㈀　　⤀ 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 Ⰰ
	[EmailIng] [varchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ਀⤀ 伀一 嬀倀刀䤀䴀䄀刀夀崀
GO਀
CREATE TABLE [dbo].[Partners] (਀ऀ嬀椀搀倀愀爀琀渀攀爀猀崀 嬀椀渀琀崀 䤀䐀䔀一吀䤀吀夀 ⠀㄀Ⰰ ㄀⤀ 一伀吀 一唀䰀䰀 Ⰰ
	[Texto] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,਀ऀ嬀䰀漀最漀崀 嬀瘀愀爀挀栀愀爀崀 ⠀㔀　⤀ 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 Ⰰ
	[Nombre] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,਀ऀ嬀唀刀䰀崀 嬀瘀愀爀挀栀愀爀崀 ⠀㔀　⤀ 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 Ⰰ
	[NombreIng] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ਀⤀ 伀一 嬀倀刀䤀䴀䄀刀夀崀
GO਀
CREATE TABLE [dbo].[Qsomos] (਀ऀ嬀䤀䐀儀猀漀洀漀猀崀 嬀椀渀琀崀 䤀䐀䔀一吀䤀吀夀 ⠀㄀Ⰰ ㄀⤀ 一伀吀 一唀䰀䰀 Ⰰ
	[Titulo] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,਀ऀ嬀吀攀砀琀漀崀 嬀琀攀砀琀崀 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 Ⰰ
	[Posicion] [int] NULL ,਀ऀ嬀吀椀琀甀氀漀椀渀最崀 嬀瘀愀爀挀栀愀爀崀 ⠀㔀　⤀ 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 Ⰰ
	[Textoing] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ਀⤀ 伀一 嬀倀刀䤀䴀䄀刀夀崀 吀䔀堀吀䤀䴀䄀䜀䔀开伀一 嬀倀刀䤀䴀䄀刀夀崀
GO਀
CREATE TABLE [dbo].[Servicios] (਀ऀ嬀䤀䐀匀攀爀瘀椀挀椀漀猀崀 嬀椀渀琀崀 䤀䐀䔀一吀䤀吀夀 ⠀㄀Ⰰ ㄀⤀ 一伀吀 一唀䰀䰀 Ⰰ
	[Titulo] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,਀ऀ嬀吀攀砀琀漀崀 嬀琀攀砀琀崀 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 Ⰰ
	[Email] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,਀ऀ嬀倀漀猀椀挀椀漀渀崀 嬀椀渀琀崀 一唀䰀䰀 Ⰰ
	[tituloing] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,਀ऀ嬀琀攀砀琀漀椀渀最崀 嬀琀攀砀琀崀 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 Ⰰ
	[Emailing] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,਀ऀ嬀甀爀氀崀 嬀瘀愀爀挀栀愀爀崀 ⠀㔀　⤀ 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 Ⰰ
	[urling] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,਀ऀ嬀猀甀戀挀愀琀攀最漀爀椀愀猀崀 嬀戀椀琀崀 一伀吀 一唀䰀䰀 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]਀䜀伀
਀䌀刀䔀䄀吀䔀 吀䄀䈀䰀䔀 嬀搀戀漀崀⸀嬀匀琀愀昀昀崀 ⠀
	[idStaff] [int] IDENTITY (1, 1) NOT NULL ,਀ऀ嬀一漀洀戀爀攀崀 嬀瘀愀爀挀栀愀爀崀 ⠀㔀　⤀ 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 Ⰰ
	[Cargo] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,਀ऀ嬀吀攀砀琀漀崀 嬀琀攀砀琀崀 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 Ⰰ
	[Email] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,਀ऀ嬀䘀漀琀漀崀 嬀瘀愀爀挀栀愀爀崀 ⠀㔀　⤀ 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 Ⰰ
	[Cargoing] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,਀ऀ嬀吀攀砀琀漀椀渀最崀 嬀琀攀砀琀崀 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]਀䜀伀
਀䌀刀䔀䄀吀䔀 吀䄀䈀䰀䔀 嬀搀戀漀崀⸀嬀匀琀爀愀琀愀开䄀搀洀椀渀崀 ⠀
	[idUser] [int] NOT NULL ,਀ऀ嬀一漀洀戀爀攀崀 嬀瘀愀爀挀栀愀爀崀 ⠀㔀　⤀ 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 Ⰰ
	[Apellido] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,਀ऀ嬀唀猀攀爀渀愀洀攀崀 嬀瘀愀爀挀栀愀爀崀 ⠀㔀　⤀ 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 Ⰰ
	[Password] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,਀ऀ嬀䘀漀琀漀䈀一崀 嬀瘀愀爀挀栀愀爀崀 ⠀㔀　⤀ 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 Ⰰ
	[FotoColor] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ਀⤀ 伀一 嬀倀刀䤀䴀䄀刀夀崀
GO਀
CREATE TABLE [dbo].[Strata_City] (਀ऀ嬀椀搀䌀椀琀礀崀 嬀椀渀琀崀 一伀吀 一唀䰀䰀 Ⰰ
	[City] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ਀⤀ 伀一 嬀倀刀䤀䴀䄀刀夀崀
GO਀
CREATE TABLE [dbo].[Strata_Clientes] (਀ऀ嬀椀搀䌀氀椀攀渀琀攀崀 嬀椀渀琀崀 一伀吀 一唀䰀䰀 Ⰰ
	[TipoMail] [int] NULL ,਀ऀ嬀䘀椀爀猀琀一愀洀攀崀 嬀瘀愀爀挀栀愀爀崀 ⠀㄀　　⤀ 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 Ⰰ
	[LastName] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,਀ऀ嬀䌀漀洀瀀愀渀礀崀 嬀瘀愀爀挀栀愀爀崀 ⠀㄀　　⤀ 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 Ⰰ
	[Position] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,਀ऀ嬀䴀愀椀氀崀 嬀瘀愀爀挀栀愀爀崀 ⠀㄀　　⤀ 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 Ⰰ
	[Telephone] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,਀ऀ嬀䘀愀砀崀 嬀瘀愀爀挀栀愀爀崀 ⠀㄀　　⤀ 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 Ⰰ
	[Country] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,਀ऀ嬀匀琀愀琀攀崀 嬀瘀愀爀挀栀愀爀崀 ⠀㄀　　⤀ 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 Ⰰ
	[Address] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,਀ऀ嬀娀椀瀀崀 嬀瘀愀爀挀栀愀爀崀 ⠀㄀　　⤀ 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 Ⰰ
	[Collection] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,਀ऀ嬀䌀漀洀洀攀渀琀猀崀 嬀琀攀砀琀崀 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]਀䜀伀
਀䌀刀䔀䄀吀䔀 吀䄀䈀䰀䔀 嬀搀戀漀崀⸀嬀匀琀爀愀琀愀开䌀漀甀渀琀爀礀崀 ⠀
	[idCountry] [int] NULL ,਀ऀ嬀䌀漀甀渀琀爀礀崀 嬀渀瘀愀爀挀栀愀爀崀 ⠀㈀㔀㔀⤀ 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 
) ON [PRIMARY]਀䜀伀
਀䌀刀䔀䄀吀䔀 吀䄀䈀䰀䔀 嬀搀戀漀崀⸀嬀匀琀爀愀琀愀开䘀愀洀椀氀椀愀猀崀 ⠀
	[idFamilia] [int] NOT NULL ,਀ऀ嬀椀搀䰀椀渀攀愀崀 嬀椀渀琀崀 一唀䰀䰀 Ⰰ
	[Nombre] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,਀ऀ嬀䤀洀愀最攀渀匀椀琀攀䴀攀渀甀崀 嬀瘀愀爀挀栀愀爀崀 ⠀㄀　　⤀ 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 
) ON [PRIMARY]਀䜀伀
਀䌀刀䔀䄀吀䔀 吀䄀䈀䰀䔀 嬀搀戀漀崀⸀嬀匀琀爀愀琀愀开䰀椀渀攀愀猀崀 ⠀
	[idLinea] [int] NOT NULL ,਀ऀ嬀一漀洀戀爀攀崀 嬀瘀愀爀挀栀愀爀崀 ⠀㔀　⤀ 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 Ⰰ
	[CatalogoPapel] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ਀⤀ 伀一 嬀倀刀䤀䴀䄀刀夀崀
GO਀
CREATE TABLE [dbo].[Strata_Productos] (਀ऀ嬀椀搀倀爀漀搀甀挀琀漀崀 嬀椀渀琀崀 一伀吀 一唀䰀䰀 Ⰰ
	[idFamilia] [int] NULL ,਀ऀ嬀一漀洀戀爀攀崀 嬀瘀愀爀挀栀愀爀崀 ⠀㔀　⤀ 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 Ⰰ
	[FotoMenuIzq] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,਀ऀ嬀䘀漀琀漀䴀攀渀甀䤀稀焀䌀漀氀漀爀崀 嬀瘀愀爀挀栀愀爀崀 ⠀㄀　　⤀ 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 Ⰰ
	[FotoCentral] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,਀ऀ嬀吀椀瀀漀䘀漀琀漀崀 嬀戀椀琀崀 一唀䰀䰀 Ⰰ
	[FotoLateral] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,਀ऀ嬀䐀攀猀挀爀椀瀀挀椀漀渀崀 嬀琀攀砀琀崀 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 Ⰰ
	[FichaTecnica1Titulo] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,਀ऀ嬀䘀椀挀栀愀吀攀挀渀椀挀愀㄀䤀洀愀最攀渀崀 嬀瘀愀爀挀栀愀爀崀 ⠀㄀　　⤀ 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 Ⰰ
	[FichaTecnica2Titulo] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,਀ऀ嬀䘀椀挀栀愀吀攀挀渀椀挀愀㈀䤀洀愀最攀渀崀 嬀瘀愀爀挀栀愀爀崀 ⠀㄀　　⤀ 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 Ⰰ
	[ImagenSiglas] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ਀⤀ 伀一 嬀倀刀䤀䴀䄀刀夀崀 吀䔀堀吀䤀䴀䄀䜀䔀开伀一 嬀倀刀䤀䴀䄀刀夀崀
GO਀
CREATE TABLE [dbo].[SubCategorias] (਀ऀ嬀椀搀匀甀戀䌀愀琀攀最漀爀椀愀崀 嬀椀渀琀崀 䤀䐀䔀一吀䤀吀夀 ⠀㄀Ⰰ ㄀⤀ 一伀吀 一唀䰀䰀 Ⰰ
	[idServicios] [int] NULL ,਀ऀ嬀吀攀砀琀漀崀 嬀瘀愀爀挀栀愀爀崀 ⠀㄀　　⤀ 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 Ⰰ
	[TextoING] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,਀ऀ嬀䔀洀瀀爀攀猀愀猀崀 嬀戀椀琀崀 一伀吀 一唀䰀䰀 
) ON [PRIMARY]਀䜀伀
਀䌀刀䔀䄀吀䔀 吀䄀䈀䰀䔀 嬀搀戀漀崀⸀嬀氀椀渀欀猀崀 ⠀
	[idLink] [int] IDENTITY (1, 1) NOT NULL ,਀ऀ嬀琀攀砀琀漀崀 嬀瘀愀爀挀栀愀爀崀 ⠀㈀　　⤀ 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 Ⰰ
	[textoing] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,਀ऀ嬀甀爀氀崀 嬀瘀愀爀挀栀愀爀崀 ⠀㔀　⤀ 䌀伀䰀䰀䄀吀䔀 匀儀䰀开䰀愀琀椀渀㄀开䜀攀渀攀爀愀氀开䌀倀㄀开䌀䤀开䄀匀 一唀䰀䰀 Ⰰ
	[urling] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ਀⤀ 伀一 嬀倀刀䤀䴀䄀刀夀崀
GO਀
ALTER TABLE [dbo].[Servicios] ADD ਀ऀ䌀伀一匀吀刀䄀䤀一吀 嬀䐀䘀开匀攀爀瘀椀挀椀漀猀开猀甀戀挀愀琀攀最漀爀椀愀猀崀 䐀䔀䘀䄀唀䰀吀 ⠀　⤀ 䘀伀刀 嬀猀甀戀挀愀琀攀最漀爀椀愀猀崀
GO਀
GRANT  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[Admin]  TO [sqlasiar]਀䜀伀
਀䜀刀䄀一吀  匀䔀䰀䔀䌀吀 Ⰰ  唀倀䐀䄀吀䔀 Ⰰ  䤀一匀䔀刀吀 Ⰰ  䐀䔀䰀䔀吀䔀  伀一 嬀搀戀漀崀⸀嬀䌀氀椀攀渀琀攀猀崀  吀伀 嬀猀焀氀愀猀椀愀爀崀
GO਀
GRANT  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[EmpresasPorRubro]  TO [sqlasiar]਀䜀伀
਀䜀刀䄀一吀  匀䔀䰀䔀䌀吀 Ⰰ  唀倀䐀䄀吀䔀 Ⰰ  䤀一匀䔀刀吀 Ⰰ  䐀䔀䰀䔀吀䔀  伀一 嬀搀戀漀崀⸀嬀䔀猀琀愀搀嘀椀猀椀琀愀猀崀  吀伀 嬀猀焀氀愀猀椀愀爀崀
GO਀
GRANT  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[Eventos]  TO [sqlasiar]਀䜀伀
਀䜀刀䄀一吀  匀䔀䰀䔀䌀吀 Ⰰ  唀倀䐀䄀吀䔀 Ⰰ  䤀一匀䔀刀吀 Ⰰ  䐀䔀䰀䔀吀䔀  伀一 嬀搀戀漀崀⸀嬀䴀椀猀椀漀渀攀猀崀  吀伀 嬀猀焀氀愀猀椀愀爀崀
GO਀
GRANT  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[Oficinas]  TO [sqlasiar]਀䜀伀
਀䜀刀䄀一吀  匀䔀䰀䔀䌀吀 Ⰰ  唀倀䐀䄀吀䔀 Ⰰ  䤀一匀䔀刀吀 Ⰰ  䐀䔀䰀䔀吀䔀  伀一 嬀搀戀漀崀⸀嬀倀愀爀琀渀攀爀猀崀  吀伀 嬀猀焀氀愀猀椀愀爀崀
GO਀
GRANT  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[Qsomos]  TO [sqlasiar]਀䜀伀
਀䜀刀䄀一吀  匀䔀䰀䔀䌀吀 Ⰰ  唀倀䐀䄀吀䔀 Ⰰ  䤀一匀䔀刀吀 Ⰰ  䐀䔀䰀䔀吀䔀  伀一 嬀搀戀漀崀⸀嬀匀攀爀瘀椀挀椀漀猀崀  吀伀 嬀猀焀氀愀猀椀愀爀崀
GO਀
GRANT  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[Staff]  TO [sqlasiar]਀䜀伀
਀䜀刀䄀一吀  匀䔀䰀䔀䌀吀 Ⰰ  唀倀䐀䄀吀䔀 Ⰰ  䤀一匀䔀刀吀 Ⰰ  䐀䔀䰀䔀吀䔀  伀一 嬀搀戀漀崀⸀嬀匀甀戀䌀愀琀攀最漀爀椀愀猀崀  吀伀 嬀猀焀氀愀猀椀愀爀崀
GO਀
GRANT  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[links]  TO [sqlasiar]਀䜀伀
਀匀䔀吀 儀唀伀吀䔀䐀开䤀䐀䔀一吀䤀䘀䤀䔀刀 伀一 
GO਀匀䔀吀 䄀一匀䤀开一唀䰀䰀匀 伀一 
GO਀
CREATE VIEW dbo.viewClientesXRubro਀䄀匀
SELECT EmpresasPorRubro.idCliente, EmpresasPorRubro.idRubro, ਀    䔀洀瀀爀攀猀愀猀倀漀爀刀甀戀爀漀⸀椀搀Ⰰ 匀甀戀䌀愀琀攀最漀爀椀愀猀⸀吀攀砀琀漀Ⰰ 
    SubCategorias.TextoING, Clientes.Nombre, ਀    䌀氀椀攀渀琀攀猀⸀一漀洀戀爀攀䤀渀最Ⰰ 䌀氀椀攀渀琀攀猀⸀唀刀䰀Ⰰ 䌀氀椀攀渀琀攀猀⸀䰀漀最漀
FROM EmpresasPorRubro INNER JOIN਀    䌀氀椀攀渀琀攀猀 伀一 
    EmpresasPorRubro.idCliente = Clientes.idCliente INNER JOIN਀    匀甀戀䌀愀琀攀最漀爀椀愀猀 伀一 
    EmpresasPorRubro.idRubro = SubCategorias.idSubCategoria਀
GO਀匀䔀吀 儀唀伀吀䔀䐀开䤀䐀䔀一吀䤀䘀䤀䔀刀 伀䘀䘀 
GO਀匀䔀吀 䄀一匀䤀开一唀䰀䰀匀 伀一 
GO਀
GRANT  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[viewClientesXRubro]  TO [sqlasiar]਀䜀伀
਀਀