/**************************************/ /* Upgrade the settings database */ /* for eMailSignature version 7. */ /* Last update September 23, 2009 */ /* Branded Mails ApS. */ /* www.emailsignature.eu */ /* */ /* Script for: */ /* SQL Server 2005 */ /**************************************/ /**************************************/ /* IMPORTANT: */ /* Replace the SQL users */ /* with your own names in this script */ /* if you have renamed your */ /* eMailSignature database users. */ /**************************************/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SettingsLegal]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[SettingsLegal] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[lgdaOWA]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[lgdaOWA] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[users]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[users] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[lgdaCollected]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[lgdaCollected] GO CREATE TABLE [dbo].[SettingsLegal] ( [id] [int] IDENTITY (1, 1) PRIMARY KEY NOT NULL , [e1] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [e2] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [e3] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [e4] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [e5] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [e6] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [e7] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [e8] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [e9] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [e10] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [b1] [int] NULL , [b2] [int] NULL , [b3] [int] NULL , [b4] [int] NULL , [b5] [int] NULL , [b6] [int] NULL , [b7] [int] NULL , [b8] [int] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[lgdaCollected] ( [init] [nvarchar] (50) PRIMARY KEY NOT NULL , [lastrun] [nvarchar] (50) NULL , [status] [int] NULL , [error] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [defaultsignature] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [replysignature] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [signatures] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [officeversion] [int] NULL , [owasignature_html] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [owasignature_txt] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [owaupdate] [int] NULL , [owastatus] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [first_name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [last_name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [dn] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [debugmode] [int] NULL , [log] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [primgrpid] [int] NULL , [defaultprofile] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [computername] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [vcf] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [collect_1] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [collect_2] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [collect_3] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [collect_4] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [collect_5] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [collect_6] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [collect_7] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [collect_8] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [collect_9] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [collect_10] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [collect_name_1] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [collect_name_2] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [collect_name_3] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [collect_name_4] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [collect_name_5] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [collect_name_6] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [collect_name_7] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [collect_name_8] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [collect_name_9] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [collect_name_10] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [collect_id_1] [int] NULL , [collect_id_2] [int] NULL , [collect_id_3] [int] NULL , [collect_id_4] [int] NULL , [collect_id_5] [int] NULL , [collect_id_6] [int] NULL , [collect_id_7] [int] NULL , [collect_id_8] [int] NULL , [collect_id_9] [int] NULL , [collect_id_10] [int] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[lgdaOWA] ( [id] [int] IDENTITY (1, 1) PRIMARY KEY NOT NULL , [version] [int] NULL , [url] [nvarchar] (249) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [fba] [int] NULL , [https] [int] NULL , [default] [int] NULL , [removeimgtag] [int] NULL , [users] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [proxy] [nvarchar] (249) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [proxyuid] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [proxypwd] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [custom_str1] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [custom_str2] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [custom_str3] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [custom_str4] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [custom_str5] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [custom_num1] [int] NULL , [custom_num2] [int] NULL , [custom_num3] [int] NULL , [custom_num4] [int] NULL , [custom_num5] [int] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[Users] ( [AccountName] [nvarchar] (50) NOT NULL , [FirstName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [Initials] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [LastName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [DisplayName] [nvarchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [DistinguishedName] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [Title] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [Description] [nvarchar] (350) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [Department] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [Company] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [Office] [nvarchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [TelephoneNumber] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [OtherTelephoneNumber] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [EMail] [nvarchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [HomePage] [nvarchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [Pager] [nvarchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [MobileNumber] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [HomeNumber] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [FaxNumber] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [IPPhone] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [Address] [nvarchar] (249) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [POBox] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [City] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [ZipCode] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [StateProvince] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [Country] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [e1] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [e2] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [e3] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [e4] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [e5] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [e6] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [e7] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [e8] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [e9] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [e10] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [e11] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [e12] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [e13] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [e14] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [e15] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [TimeStamp] [nvarchar] (30) NULL, [User] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [b1] [int] NULL , [b2] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [b3] [int] NULL , [b4] [int] NULL , [b5] [int] NULL , [b6] [int] NULL , [b7] [int] NULL , [b8] [int] NULL , [c1] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [c2] [nvarchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [c3] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [c4] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [c5] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [c6] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [c7] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [c8] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [c9] [nvarchar] (249) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , ) ON [PRIMARY] GO SET IDENTITY_INSERT LGDAOWA ON INSERT INTO [LGDAOWA] ([ID], [url], [proxy], [proxyuid], [proxypwd], [fba], [https], [version], [default], [users], [removeimgtag]) VALUES (1, 'OWA url', '', '', '', 1, 1, 2007, 0, '', 0); SET IDENTITY_INSERT LGDAOWA OFF GO ALTER TABLE [dbo].[lgdaUsers] ADD [custom_num6] [int] NULL GO ALTER TABLE [dbo].[lgdaUsers] ADD [custom_num7] [int] NULL GO ALTER TABLE [dbo].[lgdaUsers] ADD [custom_num8] [int] NULL GO ALTER TABLE [dbo].[lgdaUsers] ADD [custom_num9] [int] NULL GO ALTER TABLE [dbo].[lgdaUsers] ADD [custom_num10] [int] NULL GO ALTER TABLE [dbo].[lgdaUsers] ADD [custom_str6] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL GO ALTER TABLE [dbo].[lgdaUsers] ADD [custom_str7] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL GO ALTER TABLE [dbo].[lgdaUsers] ADD [custom_str8] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL GO ALTER TABLE [dbo].[lgdaUsers] ADD [custom_str9] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL GO ALTER TABLE [dbo].[lgdaUsers] ADD [custom_str10] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL GO ALTER TABLE [dbo].[lgdaUsers] ADD [owa_error] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL GO ALTER TABLE [dbo].[lgdaUsers] ADD [owa_lastrun] [nvarchar] (50) NULL GO ALTER TABLE [dbo].[preview] ADD [custom_str1] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL GO ALTER TABLE [dbo].[preview] ADD [custom_str2] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL GO ALTER TABLE [dbo].[preview] ADD [custom_str3] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL GO ALTER TABLE [dbo].[preview] ADD [custom_str4] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL GO ALTER TABLE [dbo].[preview] ADD [custom_str5] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL GO GRANT SELECT ON [dbo].[lgdaOWA] TO [Standard_User] GO GRANT UPDATE ON [dbo].[users] TO [Standard_User] GO GRANT SELECT ON [dbo].[users] TO [Standard_User] GO GRANT UPDATE ON [dbo].[settingsLegal] TO [Standard_User] GO GRANT SELECT ON [dbo].[settingsLegal] TO [Standard_User] GO GRANT INSERT ON [dbo].[lgdaCollected] TO [Standard_User] GO GRANT UPDATE ON [dbo].[lgdaCollected] TO [Standard_User] GO GRANT SELECT ON [dbo].[lgdaCollected] TO [Standard_User] GO GRANT DELETE ON [dbo].[lgdaOWA] TO [Cockpit_User] GO GRANT DELETE ON [dbo].[users] TO [Cockpit_User] GO GRANT DELETE ON [dbo].[settingsLegal] TO [Cockpit_User] GO GRANT DELETE ON [dbo].[lgdaCollected] TO [Cockpit_User] GO GRANT UPDATE ON [dbo].[lgdaOWA] TO [Cockpit_User] GO GRANT UPDATE ON [dbo].[users] TO [Cockpit_User] GO GRANT UPDATE ON [dbo].[settingsLegal] TO [Cockpit_User] GO GRANT UPDATE ON [dbo].[lgdaCollected] TO [Cockpit_User] GO GRANT INSERT ON [dbo].[lgdaOWA] TO [Cockpit_User] GO GRANT INSERT ON [dbo].[users] TO [Cockpit_User] GO GRANT INSERT ON [dbo].[settingsLegal] TO [Cockpit_User] GO GRANT INSERT ON [dbo].[lgdaCollected] TO [Cockpit_User] GO GRANT SELECT ON [dbo].[lgdaOWA] TO [Cockpit_User] GO GRANT SELECT ON [dbo].[users] TO [Cockpit_User] GO GRANT SELECT ON [dbo].[settingsLegal] TO [Cockpit_User] GO GRANT SELECT ON [dbo].[lgdaCollected] TO [Cockpit_User] GO