USE [master] GO /****** Object: Database [trafficdatacentre] Script Date: 25/09/2014 6:28:04 AM ******/ CREATE DATABASE [trafficdatacentre] ON PRIMARY ( NAME = N'TrafficDataCenter', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\trafficdatacentre.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ) LOG ON ( NAME = N'TrafficDataCenter_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\trafficdatacentre.ldf' , SIZE = 3456KB , MAXSIZE = 2048GB , FILEGROWTH = 10%) GO IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')) begin EXEC [trafficdatacentre].[dbo].[sp_fulltext_database] @action = 'enable' end GO ALTER DATABASE [trafficdatacentre] SET ANSI_NULL_DEFAULT OFF GO ALTER DATABASE [trafficdatacentre] SET ANSI_NULLS OFF GO ALTER DATABASE [trafficdatacentre] SET ANSI_PADDING OFF GO ALTER DATABASE [trafficdatacentre] SET ANSI_WARNINGS OFF GO ALTER DATABASE [trafficdatacentre] SET ARITHABORT OFF GO ALTER DATABASE [trafficdatacentre] SET AUTO_CLOSE OFF GO ALTER DATABASE [trafficdatacentre] SET AUTO_CREATE_STATISTICS ON GO ALTER DATABASE [trafficdatacentre] SET AUTO_SHRINK OFF GO ALTER DATABASE [trafficdatacentre] SET AUTO_UPDATE_STATISTICS ON GO ALTER DATABASE [trafficdatacentre] SET CURSOR_CLOSE_ON_COMMIT OFF GO ALTER DATABASE [trafficdatacentre] SET CURSOR_DEFAULT GLOBAL GO ALTER DATABASE [trafficdatacentre] SET CONCAT_NULL_YIELDS_NULL OFF GO ALTER DATABASE [trafficdatacentre] SET NUMERIC_ROUNDABORT OFF GO ALTER DATABASE [trafficdatacentre] SET QUOTED_IDENTIFIER OFF GO ALTER DATABASE [trafficdatacentre] SET RECURSIVE_TRIGGERS OFF GO ALTER DATABASE [trafficdatacentre] SET DISABLE_BROKER GO ALTER DATABASE [trafficdatacentre] SET AUTO_UPDATE_STATISTICS_ASYNC OFF GO ALTER DATABASE [trafficdatacentre] SET DATE_CORRELATION_OPTIMIZATION OFF GO ALTER DATABASE [trafficdatacentre] SET TRUSTWORTHY OFF GO ALTER DATABASE [trafficdatacentre] SET ALLOW_SNAPSHOT_ISOLATION OFF GO ALTER DATABASE [trafficdatacentre] SET PARAMETERIZATION SIMPLE GO ALTER DATABASE [trafficdatacentre] SET READ_COMMITTED_SNAPSHOT OFF GO ALTER DATABASE [trafficdatacentre] SET HONOR_BROKER_PRIORITY OFF GO ALTER DATABASE [trafficdatacentre] SET RECOVERY FULL GO ALTER DATABASE [trafficdatacentre] SET MULTI_USER GO ALTER DATABASE [trafficdatacentre] SET PAGE_VERIFY CHECKSUM GO ALTER DATABASE [trafficdatacentre] SET DB_CHAINING OFF GO USE [trafficdatacentre] GO /****** Object: Table [dbo].[Clients] Script Date: 25/09/2014 6:28:04 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Clients]( [ClientId] [int] IDENTITY(1,1) NOT NULL, [ClientName] [varchar](100) NOT NULL, [About] [varchar](200) NULL, [IsDeleted] [bit] NOT NULL, [DeletedOn] [smalldatetime] NULL, CONSTRAINT [PK_Clients] PRIMARY KEY CLUSTERED ( [ClientId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[Contents] Script Date: 25/09/2014 6:28:04 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Contents]( [ContentId] [int] IDENTITY(1,1) NOT NULL, [ContentName] [varchar](50) NOT NULL, [ProjectId] [int] NOT NULL, [ParentContentId] [int] NULL, [ContentTypeId] [tinyint] NOT NULL, [FileName] [varchar](100) NULL, [FileContent] [varbinary](max) NULL, [IsHidden] [bit] NOT NULL, [CreatedDate] [smalldatetime] NOT NULL, [ModifedDate] [smalldatetime] NOT NULL, [IsDeleted] [bit] NOT NULL, [DeletedOn] [smalldatetime] NULL, CONSTRAINT [PK_Contents] PRIMARY KEY CLUSTERED ( [ContentId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[Locations] Script Date: 25/09/2014 6:28:04 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Locations]( [LocationId] [smallint] IDENTITY(1,1) NOT NULL, [LocationName] [varchar](100) NOT NULL, CONSTRAINT [PK_Locations] PRIMARY KEY CLUSTERED ( [LocationId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[Projects] Script Date: 25/09/2014 6:28:04 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Projects]( [ProjectId] [int] IDENTITY(1,1) NOT NULL, [ProjectName] [varchar](200) NOT NULL, [Date] [date] NOT NULL, [ClientId] [int] NOT NULL, [LocationId] [smallint] NOT NULL, [IsDeleted] [bit] NOT NULL, [DeletedOn] [smalldatetime] NULL, CONSTRAINT [PK_Projects] PRIMARY KEY CLUSTERED ( [ProjectId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[Users] Script Date: 25/09/2014 6:28:04 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Users]( [UserId] [int] IDENTITY(1,1) NOT NULL, [UserName] [nvarchar](56) NOT NULL, [ClientId] [int] NULL, [IsActive] [bit] NOT NULL, CONSTRAINT [PK__Users__1788CC4C95A63F6B] PRIMARY KEY CLUSTERED ( [UserId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[webpages_Membership] Script Date: 25/09/2014 6:28:04 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[webpages_Membership]( [UserId] [int] NOT NULL, [CreateDate] [datetime] NULL, [ConfirmationToken] [nvarchar](128) NULL, [IsConfirmed] [bit] NULL, [LastPasswordFailureDate] [datetime] NULL, [PasswordFailuresSinceLastSuccess] [int] NOT NULL, [Password] [nvarchar](128) NOT NULL, [PasswordChangedDate] [datetime] NULL, [PasswordSalt] [nvarchar](128) NOT NULL, [PasswordVerificationToken] [nvarchar](128) NULL, [PasswordVerificationTokenExpirationDate] [datetime] NULL, PRIMARY KEY CLUSTERED ( [UserId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[webpages_OAuthMembership] Script Date: 25/09/2014 6:28:04 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[webpages_OAuthMembership]( [Provider] [nvarchar](30) NOT NULL, [ProviderUserId] [nvarchar](100) NOT NULL, [UserId] [int] NOT NULL, PRIMARY KEY CLUSTERED ( [Provider] ASC, [ProviderUserId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[webpages_Roles] Script Date: 25/09/2014 6:28:04 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[webpages_Roles]( [RoleId] [int] IDENTITY(1,1) NOT NULL, [RoleName] [nvarchar](256) NOT NULL, PRIMARY KEY CLUSTERED ( [RoleId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[webpages_UsersInRoles] Script Date: 25/09/2014 6:28:04 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[webpages_UsersInRoles]( [UserId] [int] NOT NULL, [RoleId] [int] NOT NULL, PRIMARY KEY CLUSTERED ( [UserId] ASC, [RoleId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO SET IDENTITY_INSERT [dbo].[Clients] ON INSERT [dbo].[Clients] ([ClientId], [ClientName], [About], [IsDeleted], [DeletedOn]) VALUES (1, N'ClientA', N'About ClientA', 0, NULL) INSERT [dbo].[Clients] ([ClientId], [ClientName], [About], [IsDeleted], [DeletedOn]) VALUES (2, N'ClientB', N'About ClientB', 0, NULL) INSERT [dbo].[Clients] ([ClientId], [ClientName], [About], [IsDeleted], [DeletedOn]) VALUES (3, N'ClientC', N'About client C', 1, CAST(0xA3B00195 AS SmallDateTime)) INSERT [dbo].[Clients] ([ClientId], [ClientName], [About], [IsDeleted], [DeletedOn]) VALUES (4, N'ClientD', N'Something about ClientD', 1, CAST(0xA3B00194 AS SmallDateTime)) SET IDENTITY_INSERT [dbo].[Clients] OFF SET IDENTITY_INSERT [dbo].[Contents] ON INSERT [dbo].[Contents] ([ContentId], [ContentName], [ProjectId], [ParentContentId], [ContentTypeId], [FileName], [FileContent], [IsHidden], [CreatedDate], [ModifedDate], [IsDeleted], [DeletedOn]) VALUES (1, N'Croydon Survey', 1, NULL, 2, N'Croydon Survery.txt', 0x, 0, CAST(0xA3A00109 AS SmallDateTime), CAST(0xA3AF01D6 AS SmallDateTime), 0, NULL) INSERT [dbo].[Contents] ([ContentId], [ContentName], [ProjectId], [ParentContentId], [ContentTypeId], [FileName], [FileContent], [IsHidden], [CreatedDate], [ModifedDate], [IsDeleted], [DeletedOn]) VALUES (2, N'Croydon Project 3.0', 3, NULL, 1, NULL, NULL, 0, CAST(0xA3A0010A AS SmallDateTime), CAST(0xA3A00109 AS SmallDateTime), 1, CAST(0xA3B00200 AS SmallDateTime)) INSERT [dbo].[Contents] ([ContentId], [ContentName], [ProjectId], [ParentContentId], [ContentTypeId], [FileName], [FileContent], [IsHidden], [CreatedDate], [ModifedDate], [IsDeleted], [DeletedOn]) VALUES (3, N'Croydon Project 3.1.1', 3, 2, 1, NULL, NULL, 0, CAST(0xA3A0010B AS SmallDateTime), CAST(0xA3A00109 AS SmallDateTime), 1, CAST(0xA3B00200 AS SmallDateTime)) INSERT [dbo].[Contents] ([ContentId], [ContentName], [ProjectId], [ParentContentId], [ContentTypeId], [FileName], [FileContent], [IsHidden], [CreatedDate], [ModifedDate], [IsDeleted], [DeletedOn]) VALUES (4, N'Map Analysis', 3, 2, 2, N'Map Analysis.txt', 0x, 0, CAST(0xA3A0010C AS SmallDateTime), CAST(0xA3A00109 AS SmallDateTime), 1, CAST(0xA3B00200 AS SmallDateTime)) INSERT [dbo].[Contents] ([ContentId], [ContentName], [ProjectId], [ParentContentId], [ContentTypeId], [FileName], [FileContent], [IsHidden], [CreatedDate], [ModifedDate], [IsDeleted], [DeletedOn]) VALUES (5, N'Croydon Document', 3, 3, 2, N'Croydon Document.docx', 0x, 0, CAST(0xA3A0010D AS SmallDateTime), CAST(0xA3A00109 AS SmallDateTime), 1, CAST(0xA3B00200 AS SmallDateTime)) INSERT [dbo].[Contents] ([ContentId], [ContentName], [ProjectId], [ParentContentId], [ContentTypeId], [FileName], [FileContent], [IsHidden], [CreatedDate], [ModifedDate], [IsDeleted], [DeletedOn]) VALUES (6, N'Croydon Worksheet', 3, 3, 2, N'Croydon Worksheet.xlsx', 0x504B03040A0000000000A564333500000000000000000000000009008900646F6350726F70732F53447400E8000000000800B7F13E3B636460691061606050618000072066640233591580840290CDC80AE18B028905A9E7EB2ABC67C73FAF692F00A9636258C1C00E92659660F8CF288FA19781590422CE081117025338D472835CC2200055CBCC0035772583108A5A45109B49828105CDAD3071262CE20055540D0007E6461045EA461045E6461045504B0304140000000800DCB6ED3A5066F8409D010000AC03000010007200646F6350726F70732F6170702E786D6C53445D00A4000000000800E9FEEA16636460691061606050618000072066640233591580840290CDC80AE18B028905A9E7EB2ABC67C73FAF692F00A96362486160014B4B30FC6794C7D0CBC02002116784880BE1552BC1B0924108455C11C8060055540D00078016CF126F1A0E4576170E459D53C16E1B21103DA752FF61C53D666D475565B14495D3AA8756B564273D5376D68BC2C28A99ACEC7E7D818D1DC74E55A937786FE6F11E03E276D7D9628080C6BB8A4D27252BC0695F1BB7ADD8FDE6CBF547562029572BEB1D546C0FC86EE5FB7762157C0F810C6011251C56AC25EA179CA36EA1533889B48B4CE343A7286EC396FBA6311AEEBC7EEAC0119F95E5070E3B0257437DDD1F05D9A8B818E87F456BAF933F7CD8ECFBA817FD5E894F7D6F8D561483CAEF46078FBEA1E2F34E8315FC944CC5516E0DFA2918DACB52F0D36DA2D75A5958C61364A32C82E02F40A2BF824A17B852266002AEC4408B0134F950A0F91DAF71C68A5F0A21D9ABD8A082518EB2CDE7DA1119818CD81E29C89F3E3C620B4028F8111CBBF879DBDB3AE646CE736D5CBCDD3802D96C0EC3CFD3888D210BF8A359A9407FC9373FCD976D9EA41B6DAF538EE9458ED7FCEC1FFCFC8CBF307FE1552C7DD72BB797821F5609FD66DC23DEF71B7FA7080E537D0DE6C1B72A401D9FC371F047200F3EE60D36752D5BE5B6501FCA2E89E727F9307E3D39BD9994F3B2CC2FF180C55FC65FBE99FC03504B0304140000000800000021001CAB412F250100003102000011006600646F6350726F70732F636F72652E786D6C20A2620028A0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000A4915F4BC33014C5DF05BF43C97B9BD6C1D0D2660C650FE244B463E25B48EEBA60F38724DAEDDB9B766B37716F425E72CFB9BF9CDC5BCC76B289BEC13AA15589B224451128A6B950758956D522BE4591F35471DA680525DA834333727D553093336DE1C56A03D60B70512029973353A2ADF726C7D8B12D48EA92E05041DC682BA90F575B6343D927AD01DFA4E9144BF094534F71078CCD484447246723D27CD9A6077086A10109CA3B9C25193E793D58E92E36F4CA99530ABF3770D13A88A37BE7C4686CDB366927BD35E4CFF0FBF2E9ADFF6A2C54372B0688149CE5CC02F5DA92E5FC71F53A7F2EF059AD38063D148047E181FC106750D693FB876A814837A338BD8BB36995A6797F3E3AD6AFFE135086E56DC43F88038014F8CF92C90F000000FFFF0300504B03040A0000000000A664333500000000000000000000000003008900786C2F53447400E8000000000800B7F13E3B636460691061606050618000072066640233591580840290CDC80AE18B028905A9E7EB2ABC67C73FAF692F00A9636258C1C00E92659660F8CF288FA19781590422CE081117025338D472835CC2200055CBCC0035772583108A5A45109B49828105CDAD3071262CE20055540D0007E7461045E7461045E6461045504B03041400000008004F85FD3ADFC8F3FA8E010000640300000D007200786C2F7374796C65732E786D6C53445D00A4000000000800E9FEEA16636460691061606050618000072066640233591580840290CDC80AE18B028905A9E7EB2ABC67C73FAF692F00A96362486160014B4B30FC6794C7D0CBC02002116784880BE1552BC1B0924108455C11C8060055540D00078016CF125A1A0E4576170E45A593C18ADB301086EF857D07A1FBAE13C396B6D8DE4321D0C396C2A6D0AB62C98E603432D238C47DFA8E2CAF9D40A1879E34FAE79F6F46925DBD5C1D888B09D17AACE5FE692785C1D66B8B7D2D7F1E0F8F9FA488A4502BF0686A3999285F9A870F55A409CCDBD918128CC058CB33D1F0A528627B364EC5273F18E44CE78353C4DBD017710846E9988A1C14E56EF7B170CAA26CAACE2345D1FA1189A75884A68ABFC545012B7B593455EBC107418C37C9C40A2A67B2E3AB027B0A36899D7216A62C974998275A7CCEA20F492C728779895C6401D6014A9985A61A14910978E08D58E2E334707BE4DBC898D9F70F771FD4B42F9F6F0AE685FB9E7CD07CFBB747CF525381E9880B82EDCF69253F142949E41D07DAAADEA382847CAF5802C6B606E02DBDD0AFEE8E7DED048EEEE0E89BAE25BF753AFD7BC8032D61C6E44DE2DFD232FBBFB1E2DADDF357F4DCE88EBEAA22BD772DBFA74F0A3684388D16C8E25F0666A6BE6EB3CE595227FE72EFBA30439B4E8D40C73559CB2D7E35DA8EAE5C5D3FECC5D3E2DAE2ECFA3C4FB0FD1ECD1F504B03040A0000000000A564333500000000000000000000000009008900786C2F7468656D652F53447400E8000000000800B7F13E3B636460691061606050618000072066640233591580840290CDC80AE18B028905A9E7EB2ABC67C73FAF692F00A9636258C1C00E92659660F8CF288FA19781590422CE081117025338D472835CC2200055CBCC0035772583108A5A45109B49828105CDAD3071262CE20055540D0007E6461045E6461045E6461045504B030414000000080038B7ED3A399CEAEED5050000AE1B000013007200786C2F7468656D652F7468656D65312E786D6C53445D00A4000000000800E9FEEA16636460691061606050618000072066640233591580840290CDC80AE18B028905A9E7EB2ABC67C73FAF692F00A96362486160014B4B30FC6794C7D0CBC02002116784880BE1552BC1B0924108455C11C8060055540D00078016CF125A1A0E4576170E45ED594D6F1B4518BE23F11F467B6FD7EBAF3A519D2A76EC16DAB451E216F538DE1DEF4E3DBBB39A1927F50DB547242444415C90B8714040A556E240113F26500445CA5FE0DD0F7B67ED71E2B6A900B53EC43BB3CFFB3EEFF7CE3A273FFF7AF9CAFD90A1432224E551DB722E562C4422977B34F2DBD6ED41FF42CB4252E1C8C38C47A46D4D89B4AE6CBDFFDE65BCA902121204F291DCC46D2B502ADEB46DE9C2369617794C22B837E222C40A96C2B73D818F406FC8EC6AA5D2B4434C230B453804B5B74623EA123448545A5B33E53D067F2225930D9789033765D42552AC3776922F39955D26D021666D0B783C7E3420F7958518960A6EB4AD4AFAB1ECADCBF65C88A915B29A5C3FFDE472B98037AEA672C21FCE059D7E7DE3D2CE5C7F35D3BF8CEBF57ADD9E33D79702B0EB82A7CE12B6DE6F399D994E0D945D2EEBEE561A957A19AFE9AF2DE1373A9D4E63A384AF15F8FA12BE5569D6B7AB257CBDC03796EDEF6C77BBCD12BE51E09B4BF8FEA58D66BD8C4F4101A3D178099DE4739E993964C4D93523BC05F0D6AC000A94AD5557261FA955B516E27B5CF4019026172B1A21358DC908BB80EBE27028284E08F026C1DA9D6CCB954B5B091792AEA0B16A5B1FC6183AA2809C3CFBFEE4D91374F2ECF1F183A7C70F7E3A7EF8F0F8C18F06C16B38F275C117DF7EF6F7D71FA3BF9E7CF3E2D11766BCD4F1BFFFF0C96FBF7C6E062A1DF8FCCBC77F3C7DFCFCAB4FFFFCEE9101BE2DF050870F684824BA498ED03E0FC1370301198A9793180498962470004803B0A78212F0E6143313AE43CAC1BB23600098805727F74AB61E0462A2A801783D084BC05DCE59870BA33BD7132EDD9D49E49BC9C544C7ED637C68E2EE2EA4B63789A192A9496537202533F718641BFB24220A25F7F8981083D85D4A4B71DDA5AEE0928F14BA4B51075363480674A8CC42D7680879999A0C84549762B37B07753833A9DF2187652434046626958495C278154F140E8D16E390E9C81B580526230FA6C22D055C2AC8B44F18473D8F486992B925A62573AF639844C6B4EFB26958460A45C726E40DCCB98EDCE1E36E80C3D868338D021DFB811C438962B4C795D1085EEE90640D79C0D1CA74DFA1A494EEB3DBFA36F54B26150592DC9908534B105EEEC7291B61922887F389BD30AB431A9D36B81985C96DBD1BDC397C1B1E63A6F6591CD7AB70FFC321BD8327D11E81BE7837A39784DECDE8B76046AFEAE53731998B616C67A2DAE93B5C79F81E51C60ED494911B321DE3121CF4FAB0992E52A1F9593F0EE03231CD5EC0F902A7D74870F51155C1418063A07152065FE6AA7D89622EE10DC35AA93BB9018F1195ED3566EF9680C66A977BD9764D7FE79CAB4957BED4896A898275C96A975E8FCCC9806BB2390D335BE354365B8B26740EC2C92F0A4EB39A5143A96046BC24EE9982595ACE3D4532C01EC973E4181D716A6B86AD7576D434B68DDAEBB1AD93249DAEBE82AE711ADD9A59AA2C65C95E6E47169557E808AC6A541B167271DCB64670EA82CB30067D32195698F951DB7255EECA99CDBCE8B0B92C9DCA4A874B14B1906A07CB20934A6FE5422C2AECAF36EA491CCEC701C3345ACF8A5ACBF917ADB017534B4623E2AA153BC532BFC7278A8883C03B42433611FB18ECAE67D5E551090F8BEA6C21A043EB79E1953B3FEF82C59F7EF2EEC02C0E703E935A5AEE33787A3DB7215D69E6D92B6C7F45576AE7E88A5EC66F992B49E5C211B7E625972E1C030446498DB62D2E54C0610AC50175FB020E0E2917D885A02D1293104B7EC84E6C2587C5DCCA74A40D056716B54F7D24284C3A150842F654EEE719CA9C7C2AE69D912BCAE7CCDC5C1967DF437248D820E9DE66E2BF8582D934C90391E21693565EE7C118FAFDFFF0C9A73E0B0A7E99E34141549F97CC3A64DAD0D71E051BAF67C24B3E6AAB668FAB8DB51FB531BCA8A0E40F0C6E2A5C569C6F077C1FB28FD8EC4489A0102FB4F2F69B6F0EC1E696E65CA22A637853C7A8220573DE8560EBCD718EC1AE99E9AAA7D3BD7AB01B8658EB756408B5BDDCA2B6F62293AE96FEA1C587F7807B07DE90264CC9D43F721F5E4BBBB37F45801EBB10DDFA07504B030414000000080000002100FB4146165A010000830200000F007200786C2F776F726B626F6F6B2E786D6C53445D00A4000000000800E9FEEA16636460691061606050618000072066640233591580840290CDC80AE18B028905A9E7EB2ABC67C73FAF692F00A96362486160014B4B30FC6794C7D0CBC02002116784880BE1552BC1B0924108455C11C8060055540D00078016CF125A1A0E4576170E458D50416FC22018BD2FD97F20DC272D56638CADC9B22DF3B298CCE99995AF9648A101B4FAEF0798CE2EDB6127788FC7FBDEF716CB7323D1098C155AE5381D2518812A35176A9FE38FCDCBC30C23EB98E24C6A0539BE80C5CBE2FE6ED16973F8D4FA80BC81B239AE9D6BE784D8B28686D9916E41F9974A9B86390FCD9ED8D600E3B606708D243449A6A46142E1ABC3DCFCC743579528E14997C70694BB9A1890CCF9F8B616ADC5C5A21212B6D78D106BDB37D6F8DC67899164D63D73E180E738F35077F08330C7F6F128640093648249F1BDE4DA20EFEAC0AC8D38B1F2E29BC28843C58ED26D7CD87E9EE76946E934FC0DFFB6023A7BB309109D774271DDE59866BEEC4B8F523F117511EC0477B567B2D98D7B05B1AF5D8E67499A047732B08F95F6275271DFF770F72123B7E231B0990B7F312B9E06875F6A3A50D3819AFEA91E0FD4E3817A1CD3F5914A264B5F5E3862084A691AA793BE93E20B504B03040A0000000000A66433350000000000000000000000000E008900786C2F776F726B7368656574732F53447400E8000000000800B7F13E3B636460691061606050618000072066640233591580840290CDC80AE18B028905A9E7EB2ABC67C73FAF692F00A9636258C1C00E92659660F8CF288FA19781590422CE081117025338D472835CC2200055CBCC0035772583108A5A45109B49828105CDAD3071262CE20055540D0007E7461045E7461045E7461045504B030414000000080000002100075F38D316010000C701000018007200786C2F776F726B7368656574732F7368656574312E786D6C53445D00A4000000000800E9FEEA16636460691061606050618000072066640233591580840290CDC80AE18B028905A9E7EB2ABC67C73FAF692F00A96362486160014B4B30FC6794C7D0CBC02002116784880BE1552BC1B0924108455C11C8060055540D00078016CF125A1A0E4576170E458D514D4FC3300CBD23F11F22DF593AD0004D6D27A469820312E2EBEEB54E1B2D89ABC463F0EF493B0D2171E1F65E9EFDFCEC94AB4FEFD407C5643954309F15A02834DCDAD055F0F6BAB9B8059504438B8E0355F0450956F5F95979E0B84B3D91A8EC105205BDC8B0D43A353D794C331E2864C570F42899C64EA72112B6539377FAB228AEB5471BE0E8B08CFFF160636C436B6EF69E821C4D2239949C3FF576485097ADCDDAB8908A642AB89B83AECB69ECBBA543FA8595E0F6851C35426DDE1ED4B8D59679378A0FF9A9185BF59FDECD94E829AA960CEE9D3CF3E19E6CD74B3659FC4C5BA360C60376F488B1B321294726D714B31B50F1583F61E161420B505B16617F627D3E18C5915D8132CC722263AC9F2FA8BF01504B030414000000080000002100B84A4B2D0B010000B701000018007200786C2F776F726B7368656574732F7368656574322E786D6C53445D00A4000000000800E9FEEA16636460691061606050618000072066640233591580840290CDC80AE18B028905A9E7EB2ABC67C73FAF692F00A96362486160014B4B30FC6794C7D0CBC02002116784880BE1552BC1B0924108455C11C8060055540D00078016CF125A1A0E4576170E458D50C14AC43010BD0BFE4398BB4D575995A5ED222C8B1E0411F59E6D276DD82613925957FFDEA46517C18BB7F798376FDEBC6AFD6547F189211A72352C8A1204BA963AE3FA1ADEDFB657F720222BD7A9911CD6F08D11D6CDE54575A4B08F03228BE4E0620D03B35F4919DB01AD8A05797469A22958C589865E461F5075D3921DE57559DE4AAB8C83D96115FEE3415A9B1637D41E2C3A9E4D028E8A53FE38181FA1A93A9366F9211150D7F0B000D954D3D90F83C7F80B8BFCC58E689FC953574399A5F28F763B257809A243AD0E23BFD2F1114D3F70AA6C7976DF2856097BD5E3B30ABD71518CA893A62CEE4084593F61263FA125881D31933DB121158421B31B109A884F24C73A57DEFC00504B030414000000080000002100B84A4B2D0B010000B701000018007200786C2F776F726B7368656574732F7368656574332E786D6C53445D00A4000000000800E9FEEA16636460691061606050618000072066640233591580840290CDC80AE18B028905A9E7EB2ABC67C73FAF692F00A96362486160014B4B30FC6794C7D0CBC02002116784880BE1552BC1B0924108455C11C8060055540D00078016CF125A1A0E4576170E458D50C14AC43010BD0BFE4398BB4D575995A5ED222C8B1E0411F59E6D276DD82613925957FFDEA46517C18BB7F798376FDEBC6AFD6547F189211A72352C8A1204BA963AE3FA1ADEDFB657F720222BD7A9911CD6F08D11D6CDE54575A4B08F03228BE4E0620D03B35F4919DB01AD8A05797469A22958C589865E461F5075D3921DE57559DE4AAB8C83D96115FEE3415A9B1637D41E2C3A9E4D028E8A53FE38181FA1A93A9366F9211150D7F0B000D954D3D90F83C7F80B8BFCC58E689FC953574399A5F28F763B257809A243AD0E23BFD2F1114D3F70AA6C7976DF2856097BD5E3B30ABD71518CA893A62CEE4084593F61263FA125881D31933DB121158421B31B109A884F24C73A57DEFC00504B03040A0000000000A664333500000000000000000000000009008900786C2F5F72656C732F53447400E8000000000800B7F13E3B636460691061606050618000072066640233591580840290CDC80AE18B028905A9E7EB2ABC67C73FAF692F00A9636258C1C00E92659660F8CF288FA19781590422CE081117025338D472835CC2200055CBCC0035772583108A5A45109B49828105CDAD3071262CE20055540D0007E7461045E7461045E7461045504B0304140000000800000021009677CD9BEB000000580300001A007200786C2F5F72656C732F776F726B626F6F6B2E786D6C2E72656C7353445D00A4000000000800E9FEEA16636460691061606050618000072066640233591580840290CDC80AE18B028905A9E7EB2ABC67C73FAF692F00A96362486160014B4B30FC6794C7D0CBC02002116784880BE1552BC1B0924108455C11C8060055540D00078016CF125A1A0E4576170E45BD934D6BC3300C86CF1BEC3F18DD1727E936C688DBCB18F43ABA1F601CE58326B6B1B48FFCFB8916DA1536B243E9C9BC327AFC60A46AF5350EEA0313F5C11B28B21C147A17EADEB706DE362FB78FA088ADAFED103C1A989060B5BCB9AE5E71B02C4DD4F59194503C19E898E393D6E43A1C2D6521A2979B26A4D1B2C4D4EA68DDD6B6A8CB3C7FD0E92703847A758255EBDA405AD70B509B29E27FF0A1697A87CFC1BD8FE8F99757F467485BEA1059A036B5C8060E25D2BB63910915F49F3EE5857DCA199FE2C23EC58CCFFD397D88A74166EE20B3CF330677E73460E9C5A3C02EEE8BC78FA8F4C93E2CBF01504B0304140000000800000021006FBE93EE4F01000038050000130072005B436F6E74656E745F54797065735D2E786D6C53445D00A4000000000800E9FEEA16636460691061606050618000072066640233591580840290CDC80AE18B028905A9E7EB2ABC67C73FAF692F00A96362486160014B4B30FC6794C7D0CBC02002116784880BE1552BC1B0924108455C11C8060055540D00078016CF122B1A0E4576170E45CD94CB4EC3301444D720F10F91B728715B248450D22E782CA18BF201C6BE69ACFA255FB7B47FCF4D021520D4AAB40B36B1A278E64CC68F72B2B6265B4144ED5DC586C58065E0A457DACD2BF6327BCC6F58864938258C7750B10D209B8C2FCECBD9260066A47658B126A570CB39CA06ACC0C20770F4A5F6D18A44AF71CE83900B31073E1A0CAEB9F42E814B796A3D18B99D95CF94216A05D954C4F4242CA1F8DAF04486D03F870559B2ECAED7B6F88A89108C96225178BE72EA0738F775AD25282F979624456773D9BAF05D4C4C1B0378340D4304A1B00148D614BDE917F83DD4626952F6B02640DF7E048387213F5A2D48D9CDC146873D90DDBFB5B79C371F17AFDE2F4E5D4F3B165668B7677D483F8D3E2027DAD119A0AD4581CA0359424CFADB0AED68A08B8BBC1B4627AE62EB7F7894ABFF13E5F8D3FAB728DBFD217D84C3337C1EA856FDDBAE287977EF8DDF01504B03040A0000000000A6643335000000000000000000000000060089005F72656C732F53447400E8000000000800B7F13E3B636460691061606050618000072066640233591580840290CDC80AE18B028905A9E7EB2ABC67C73FAF692F00A9636258C1C00E92659660F8CF288FA19781590422CE081117025338D472835CC2200055CBCC0035772583108A5A45109B49828105CDAD3071262CE20055540D0007E7461045E7461045E7461045504B030414000000080000002100F94AADACEE000000570200000B0072005F72656C732F2E72656C7353445D00A4000000000800E9FEEA16636460691061606050618000072066640233591580840290CDC80AE18B028905A9E7EB2ABC67C73FAF692F00A96362486160014B4B30FC6794C7D0CBC02002116784880BE1552BC1B0924108455C11C8060055540D00078016CF12421A0E4576170E45AD92CD4EC3300C80CF20F10E91EFABBB2121849AED3221ED8650790093B83F6A1B474980EEED0917A012831D38C6B13F7FB65CEDE66954AF1C622F4EC3BA2841B133627BD76A78AAEF57B7A06222676914C71A8E1C61B7BDBAAC1E79A4948B62D7FBA832C5450D5D4AFE0E319A8E278A857876F9A7913051CACFD0A2273350CBB829CB1B0CDF1990A9170BAC3A580DE160AF41D547CFE7E0A5697AC37B312F13BBF44317E439B1B36C573EE4FA90FA3C90AA29B49C3458310F391C91BC2F321AF0A4D4E67CA9D333E3C4892C254223817F57FAC8F8C369FD9F8B5A667C09CD23BE49189E45864F9D0A17E7B07D07504B010214000A0000000000A5643335000000000000000000000000090011000000000000001000FF4100000000646F6350726F70732F53440400E80000005554050007E6461045504B01021400140000000800DCB6ED3A5066F8409D010000AC0300001000110000000000010020000000B0000000646F6350726F70732F6170702E786D6C53440400A400000055540500078016CF12504B01021400140000000800AC6433351CAB412F2501000031020000110011000000000001002000B681ED020000646F6350726F70732F636F72652E786D6C53440400A40000005554050007F3461045504B010214000A0000000000A6643335000000000000000000000000030011000000000000001000FF41A7040000786C2F53440400E80000005554050007E7461045504B010214001400000008004F85FD3ADFC8F3FA8E010000640300000D0011000000000001002000000051050000786C2F7374796C65732E786D6C53440400A400000055540500078016CF12504B010214000A0000000000A5643335000000000000000000000000090011000000000000001000FF417C070000786C2F7468656D652F53440400E80000005554050007E6461045504B0102140014000000080038B7ED3A399CEAEED5050000AE1B000013001100000000000100200000002C080000786C2F7468656D652F7468656D65312E786D6C53440400A400000055540500078016CF12504B0102140014000000080000002100FB4146165A010000830200000F0011000000000001002000B681A40E0000786C2F776F726B626F6F6B2E786D6C53440400A400000055540500078016CF12504B010214000A0000000000A66433350000000000000000000000000E0011000000000000001000FF419D100000786C2F776F726B7368656574732F53440400E80000005554050007E7461045504B0102140014000000080000002100075F38D316010000C7010000180011000000000001002000B68152110000786C2F776F726B7368656574732F7368656574312E786D6C53440400A400000055540500078016CF12504B0102140014000000080000002100B84A4B2D0B010000B7010000180011000000000001002000B68110130000786C2F776F726B7368656574732F7368656574322E786D6C53440400A400000055540500078016CF12504B0102140014000000080000002100B84A4B2D0B010000B7010000180011000000000001002000B681C3140000786C2F776F726B7368656574732F7368656574332E786D6C53440400A400000055540500078016CF12504B010214000A0000000000A6643335000000000000000000000000090011000000000000001000FF4176160000786C2F5F72656C732F53440400E80000005554050007E7461045504B01021400140000000800000021009677CD9BEB000000580300001A0011000000000001002000B68126170000786C2F5F72656C732F776F726B626F6F6B2E786D6C2E72656C7353440400A400000055540500078016CF12504B01021400140000000800000021006FBE93EE4F01000038050000130011000000000001002000B681BB1800005B436F6E74656E745F54797065735D2E786D6C53440400A400000055540500078016CF12504B010214000A0000000000A6643335000000000000000000000000060011000000000000001000FF41AD1A00005F72656C732F53440400E80000005554050007E7461045504B0102140014000000080000002100F94AADACEE000000570200000B0011000000000001002000B6815A1B00005F72656C732F2E72656C7353440400A400000055540500078016CF12504B0506000000001100110031050000E31C00000000, 0, CAST(0xA3A0010E AS SmallDateTime), CAST(0xA3A00109 AS SmallDateTime), 1, CAST(0xA3B00200 AS SmallDateTime)) INSERT [dbo].[Contents] ([ContentId], [ContentName], [ProjectId], [ParentContentId], [ContentTypeId], [FileName], [FileContent], [IsHidden], [CreatedDate], [ModifedDate], [IsDeleted], [DeletedOn]) VALUES (7, N'Harrow Project 1.0', 4, NULL, 1, NULL, NULL, 0, CAST(0xA3A502D1 AS SmallDateTime), CAST(0xA3A00109 AS SmallDateTime), 0, NULL) INSERT [dbo].[Contents] ([ContentId], [ContentName], [ProjectId], [ParentContentId], [ContentTypeId], [FileName], [FileContent], [IsHidden], [CreatedDate], [ModifedDate], [IsDeleted], [DeletedOn]) VALUES (8, N'Harrow Project 1.1', 4, 7, 1, NULL, NULL, 0, CAST(0xA3A502D1 AS SmallDateTime), CAST(0xA3A00109 AS SmallDateTime), 0, NULL) INSERT [dbo].[Contents] ([ContentId], [ContentName], [ProjectId], [ParentContentId], [ContentTypeId], [FileName], [FileContent], [IsHidden], [CreatedDate], [ModifedDate], [IsDeleted], [DeletedOn]) VALUES (9, N'Croydon Project 3.1.2', 3, 2, 1, NULL, NULL, 0, CAST(0xA3AF0179 AS SmallDateTime), CAST(0xA3AF0179 AS SmallDateTime), 1, CAST(0xA3B00200 AS SmallDateTime)) INSERT [dbo].[Contents] ([ContentId], [ContentName], [ProjectId], [ParentContentId], [ContentTypeId], [FileName], [FileContent], [IsHidden], [CreatedDate], [ModifedDate], [IsDeleted], [DeletedOn]) VALUES (10, N'Croydon Project 3.1.3', 3, 2, 1, NULL, NULL, 0, CAST(0xA3AF017B AS SmallDateTime), CAST(0xA3AF017B AS SmallDateTime), 1, CAST(0xA3B00200 AS SmallDateTime)) INSERT [dbo].[Contents] ([ContentId], [ContentName], [ProjectId], [ParentContentId], [ContentTypeId], [FileName], [FileContent], [IsHidden], [CreatedDate], [ModifedDate], [IsDeleted], [DeletedOn]) VALUES (11, N'Croydon Survey 1 ', 1, NULL, 1, NULL, NULL, 0, CAST(0xA3B10271 AS SmallDateTime), CAST(0xA3B10271 AS SmallDateTime), 0, NULL) INSERT [dbo].[Contents] ([ContentId], [ContentName], [ProjectId], [ParentContentId], [ContentTypeId], [FileName], [FileContent], [IsHidden], [CreatedDate], [ModifedDate], [IsDeleted], [DeletedOn]) VALUES (12, N'Croydon Project 1.1', 1, 11, 2, N'Croydon Survey.txt', 0x, 0, CAST(0xA3B10271 AS SmallDateTime), CAST(0xA3B10271 AS SmallDateTime), 0, NULL) SET IDENTITY_INSERT [dbo].[Contents] OFF SET IDENTITY_INSERT [dbo].[Locations] ON INSERT [dbo].[Locations] ([LocationId], [LocationName]) VALUES (1, N'Croydon') INSERT [dbo].[Locations] ([LocationId], [LocationName]) VALUES (2, N'Harrow') SET IDENTITY_INSERT [dbo].[Locations] OFF SET IDENTITY_INSERT [dbo].[Projects] ON INSERT [dbo].[Projects] ([ProjectId], [ProjectName], [Date], [ClientId], [LocationId], [IsDeleted], [DeletedOn]) VALUES (1, N'Croydon Project 1', CAST(0xFB350B00 AS Date), 1, 1, 0, NULL) INSERT [dbo].[Projects] ([ProjectId], [ProjectName], [Date], [ClientId], [LocationId], [IsDeleted], [DeletedOn]) VALUES (2, N'Croydon Project 2', CAST(0x8D370B00 AS Date), 1, 1, 0, NULL) INSERT [dbo].[Projects] ([ProjectId], [ProjectName], [Date], [ClientId], [LocationId], [IsDeleted], [DeletedOn]) VALUES (3, N'Croydon Project 3', CAST(0xFA380B00 AS Date), 1, 1, 0, NULL) INSERT [dbo].[Projects] ([ProjectId], [ProjectName], [Date], [ClientId], [LocationId], [IsDeleted], [DeletedOn]) VALUES (4, N'Harrow Project 1', CAST(0xF4380B00 AS Date), 1, 2, 0, NULL) INSERT [dbo].[Projects] ([ProjectId], [ProjectName], [Date], [ClientId], [LocationId], [IsDeleted], [DeletedOn]) VALUES (5, N'Harrow Project 2', CAST(0xD9380B00 AS Date), 1, 2, 0, NULL) INSERT [dbo].[Projects] ([ProjectId], [ProjectName], [Date], [ClientId], [LocationId], [IsDeleted], [DeletedOn]) VALUES (6, N'Harrow Project 3', CAST(0x0A390B00 AS Date), 2, 2, 1, CAST(0xA3B001AE AS SmallDateTime)) SET IDENTITY_INSERT [dbo].[Projects] OFF SET IDENTITY_INSERT [dbo].[Users] ON INSERT [dbo].[Users] ([UserId], [UserName], [ClientId], [IsActive]) VALUES (1, N'admin@tdc.com', NULL, 1) INSERT [dbo].[Users] ([UserId], [UserName], [ClientId], [IsActive]) VALUES (2, N'client1@tdc.com', 1, 1) INSERT [dbo].[Users] ([UserId], [UserName], [ClientId], [IsActive]) VALUES (3, N'client2@tdc.com', 2, 1) INSERT [dbo].[Users] ([UserId], [UserName], [ClientId], [IsActive]) VALUES (4, N'clienta@tdc.coom', 1, 1) INSERT [dbo].[Users] ([UserId], [UserName], [ClientId], [IsActive]) VALUES (5, N'clienta@tdc.com', 1, 1) INSERT [dbo].[Users] ([UserId], [UserName], [ClientId], [IsActive]) VALUES (6, N'clientb@tdc.com', 2, 1) INSERT [dbo].[Users] ([UserId], [UserName], [ClientId], [IsActive]) VALUES (7, N'clientaa@tdc.com', 1, 1) SET IDENTITY_INSERT [dbo].[Users] OFF INSERT [dbo].[webpages_Membership] ([UserId], [CreateDate], [ConfirmationToken], [IsConfirmed], [LastPasswordFailureDate], [PasswordFailuresSinceLastSuccess], [Password], [PasswordChangedDate], [PasswordSalt], [PasswordVerificationToken], [PasswordVerificationTokenExpirationDate]) VALUES (1, CAST(0x0000A39000B26040 AS DateTime), NULL, 1, NULL, 0, N'AJJpuCve5OjFD9zIPzRBiJlXbCP3mMS4V22bwIPDU1JM1w/f47BQcwI4mXd6Iq/lWQ==', CAST(0x0000A39000B26040 AS DateTime), N'', NULL, NULL) INSERT [dbo].[webpages_Membership] ([UserId], [CreateDate], [ConfirmationToken], [IsConfirmed], [LastPasswordFailureDate], [PasswordFailuresSinceLastSuccess], [Password], [PasswordChangedDate], [PasswordSalt], [PasswordVerificationToken], [PasswordVerificationTokenExpirationDate]) VALUES (2, CAST(0x0000A3940061AAE9 AS DateTime), NULL, 1, CAST(0x0000A3AE005EFBB1 AS DateTime), 0, N'APu5tlekoel00hxb7Op4zv/uQdss/nlv8qUCeuTutGREeZemCBTWcqo88V18A1+o0w==', CAST(0x0000A3940061AAE9 AS DateTime), N'', NULL, NULL) INSERT [dbo].[webpages_Membership] ([UserId], [CreateDate], [ConfirmationToken], [IsConfirmed], [LastPasswordFailureDate], [PasswordFailuresSinceLastSuccess], [Password], [PasswordChangedDate], [PasswordSalt], [PasswordVerificationToken], [PasswordVerificationTokenExpirationDate]) VALUES (3, CAST(0x0000A3940061D821 AS DateTime), NULL, 1, NULL, 0, N'ABOUaGSrsq/hqGKHov1R9bAZKF1Yq1gpxLfH/JrQKoXy5uCIDl2whvJwpb92T+iUfQ==', CAST(0x0000A3940061D821 AS DateTime), N'', NULL, NULL) INSERT [dbo].[webpages_Membership] ([UserId], [CreateDate], [ConfirmationToken], [IsConfirmed], [LastPasswordFailureDate], [PasswordFailuresSinceLastSuccess], [Password], [PasswordChangedDate], [PasswordSalt], [PasswordVerificationToken], [PasswordVerificationTokenExpirationDate]) VALUES (4, CAST(0x0000A3B100718F43 AS DateTime), NULL, 1, NULL, 0, N'AC29KU0WtuwPICXULC6KL2nZqrWHU13hnEU8EzrWP4Oun75hMn7c39L5QhgOw7V0wA==', CAST(0x0000A3B100718F43 AS DateTime), N'', NULL, NULL) INSERT [dbo].[webpages_Membership] ([UserId], [CreateDate], [ConfirmationToken], [IsConfirmed], [LastPasswordFailureDate], [PasswordFailuresSinceLastSuccess], [Password], [PasswordChangedDate], [PasswordSalt], [PasswordVerificationToken], [PasswordVerificationTokenExpirationDate]) VALUES (5, CAST(0x0000A3B10076C7F3 AS DateTime), NULL, 1, NULL, 0, N'ALIqg/saJsHFd2kys0n0JZtV11od9T9karrVLquJimVSJsz8/HHRbJEQgVXIJ8lzjg==', CAST(0x0000A3B10076C7F3 AS DateTime), N'', NULL, NULL) INSERT [dbo].[webpages_Membership] ([UserId], [CreateDate], [ConfirmationToken], [IsConfirmed], [LastPasswordFailureDate], [PasswordFailuresSinceLastSuccess], [Password], [PasswordChangedDate], [PasswordSalt], [PasswordVerificationToken], [PasswordVerificationTokenExpirationDate]) VALUES (6, CAST(0x0000A3B10077593F AS DateTime), NULL, 1, NULL, 0, N'AI8tFNvBSAGFlL3v9o9tkvEnOz61lps/oqLrCzow9DTJ8Dc7fR1JyKocQGl7WUZtqA==', CAST(0x0000A3B10077593F AS DateTime), N'', NULL, NULL) INSERT [dbo].[webpages_Membership] ([UserId], [CreateDate], [ConfirmationToken], [IsConfirmed], [LastPasswordFailureDate], [PasswordFailuresSinceLastSuccess], [Password], [PasswordChangedDate], [PasswordSalt], [PasswordVerificationToken], [PasswordVerificationTokenExpirationDate]) VALUES (7, CAST(0x0000A3B1007B4C84 AS DateTime), NULL, 1, NULL, 0, N'AP9hTyXSl36LVbCr0vknuMoIxGnGaZKFsdIFntM9S2jnfGIUkGRvLo1yknXJe7RYHA==', CAST(0x0000A3B1007B4C84 AS DateTime), N'', NULL, NULL) SET IDENTITY_INSERT [dbo].[webpages_Roles] ON INSERT [dbo].[webpages_Roles] ([RoleId], [RoleName]) VALUES (1, N'Administrator') INSERT [dbo].[webpages_Roles] ([RoleId], [RoleName]) VALUES (3, N'Client') INSERT [dbo].[webpages_Roles] ([RoleId], [RoleName]) VALUES (2, N'Staff') SET IDENTITY_INSERT [dbo].[webpages_Roles] OFF INSERT [dbo].[webpages_UsersInRoles] ([UserId], [RoleId]) VALUES (1, 1) INSERT [dbo].[webpages_UsersInRoles] ([UserId], [RoleId]) VALUES (2, 3) INSERT [dbo].[webpages_UsersInRoles] ([UserId], [RoleId]) VALUES (3, 3) INSERT [dbo].[webpages_UsersInRoles] ([UserId], [RoleId]) VALUES (4, 3) INSERT [dbo].[webpages_UsersInRoles] ([UserId], [RoleId]) VALUES (5, 3) INSERT [dbo].[webpages_UsersInRoles] ([UserId], [RoleId]) VALUES (6, 3) INSERT [dbo].[webpages_UsersInRoles] ([UserId], [RoleId]) VALUES (7, 3) SET ANSI_PADDING ON GO /****** Object: Index [UQ__Users__C9F28456C5EC5D14] Script Date: 25/09/2014 6:28:04 AM ******/ ALTER TABLE [dbo].[Users] ADD CONSTRAINT [UQ__Users__C9F28456C5EC5D14] UNIQUE NONCLUSTERED ( [UserName] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO SET ANSI_PADDING ON GO /****** Object: Index [UQ__webpages__8A2B6160A0D32EA5] Script Date: 25/09/2014 6:28:04 AM ******/ ALTER TABLE [dbo].[webpages_Roles] ADD UNIQUE NONCLUSTERED ( [RoleName] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO ALTER TABLE [dbo].[webpages_Membership] ADD DEFAULT ((0)) FOR [IsConfirmed] GO ALTER TABLE [dbo].[webpages_Membership] ADD DEFAULT ((0)) FOR [PasswordFailuresSinceLastSuccess] GO ALTER TABLE [dbo].[Contents] WITH CHECK ADD CONSTRAINT [FK_Contents_ParentContents] FOREIGN KEY([ParentContentId]) REFERENCES [dbo].[Contents] ([ContentId]) GO ALTER TABLE [dbo].[Contents] CHECK CONSTRAINT [FK_Contents_ParentContents] GO ALTER TABLE [dbo].[Contents] WITH CHECK ADD CONSTRAINT [FK_Contents_Projects] FOREIGN KEY([ProjectId]) REFERENCES [dbo].[Projects] ([ProjectId]) GO ALTER TABLE [dbo].[Contents] CHECK CONSTRAINT [FK_Contents_Projects] GO ALTER TABLE [dbo].[Projects] WITH CHECK ADD CONSTRAINT [FK_Projects_Clients] FOREIGN KEY([ClientId]) REFERENCES [dbo].[Clients] ([ClientId]) GO ALTER TABLE [dbo].[Projects] CHECK CONSTRAINT [FK_Projects_Clients] GO ALTER TABLE [dbo].[Projects] WITH CHECK ADD CONSTRAINT [FK_Projects_Locations] FOREIGN KEY([LocationId]) REFERENCES [dbo].[Locations] ([LocationId]) GO ALTER TABLE [dbo].[Projects] CHECK CONSTRAINT [FK_Projects_Locations] GO ALTER TABLE [dbo].[Users] WITH CHECK ADD CONSTRAINT [FK_Users_Clients] FOREIGN KEY([ClientId]) REFERENCES [dbo].[Clients] ([ClientId]) GO ALTER TABLE [dbo].[Users] CHECK CONSTRAINT [FK_Users_Clients] GO ALTER TABLE [dbo].[webpages_UsersInRoles] WITH CHECK ADD CONSTRAINT [fk_RoleId] FOREIGN KEY([RoleId]) REFERENCES [dbo].[webpages_Roles] ([RoleId]) GO ALTER TABLE [dbo].[webpages_UsersInRoles] CHECK CONSTRAINT [fk_RoleId] GO ALTER TABLE [dbo].[webpages_UsersInRoles] WITH CHECK ADD CONSTRAINT [fk_UserId] FOREIGN KEY([UserId]) REFERENCES [dbo].[Users] ([UserId]) GO ALTER TABLE [dbo].[webpages_UsersInRoles] CHECK CONSTRAINT [fk_UserId] GO USE [master] GO ALTER DATABASE [trafficdatacentre] SET READ_WRITE GO