/****** Object:  Table [dbo].[TimeEvent]    Script Date: 01/17/2010 01:02:04 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TimeEvent]') AND type in (N'U'))
DROP TABLE [dbo].[TimeEvent]
GO
/****** Object:  Table [dbo].[TimeZones]    Script Date: 01/17/2010 01:02:04 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TimeZones]') AND type in (N'U'))
DROP TABLE [dbo].[TimeZones]
GO
/****** Object:  Table [dbo].[TimeZones]    Script Date: 01/17/2010 01:02:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TimeZones]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[TimeZones](
	[TimeZoneID] [int] IDENTITY(1,1) NOT NULL,
	[Offset] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Sort] [smallint] NULL,
	[TimeLabel] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 CONSTRAINT [PK_TimeZones] PRIMARY KEY CLUSTERED 
(
	[TimeZoneID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON)
)
END
GO
SET IDENTITY_INSERT [dbo].[TimeZones] ON
INSERT [dbo].[TimeZones] ([TimeZoneID], [Offset], [Sort], [TimeLabel]) VALUES (4, N'+8:00', 255, N'Beijing, Perth, Singapore, Hong Kong')
INSERT [dbo].[TimeZones] ([TimeZoneID], [Offset], [Sort], [TimeLabel]) VALUES (5, N'+4:00', 255, N'Abu Dhabi, Muscat, Baku, Tbilisi')
INSERT [dbo].[TimeZones] ([TimeZoneID], [Offset], [Sort], [TimeLabel]) VALUES (6, N'-4:30', 255, N'Caracas')
INSERT [dbo].[TimeZones] ([TimeZoneID], [Offset], [Sort], [TimeLabel]) VALUES (7, N'+2:00', 255, N'Kaliningrad, South Africa')
INSERT [dbo].[TimeZones] ([TimeZoneID], [Offset], [Sort], [TimeLabel]) VALUES (8, N'-10:00', 255, N'Hawaii')
INSERT [dbo].[TimeZones] ([TimeZoneID], [Offset], [Sort], [TimeLabel]) VALUES (9, N'-9:00', 255, N'Alaska')
INSERT [dbo].[TimeZones] ([TimeZoneID], [Offset], [Sort], [TimeLabel]) VALUES (10, N'-4:00', 3, N'Atlantic Time (Canada), La Paz, Santiago')
INSERT [dbo].[TimeZones] ([TimeZoneID], [Offset], [Sort], [TimeLabel]) VALUES (11, N'+5:45', 255, N'Kathmandu')
INSERT [dbo].[TimeZones] ([TimeZoneID], [Offset], [Sort], [TimeLabel]) VALUES (12, N'+9:30', 255, N'Adelaide, Darwin')
INSERT [dbo].[TimeZones] ([TimeZoneID], [Offset], [Sort], [TimeLabel]) VALUES (13, N'-2:00', 255, N'Mid-Atlantic')
INSERT [dbo].[TimeZones] ([TimeZoneID], [Offset], [Sort], [TimeLabel]) VALUES (14, N'-6:00', 4, N'Central Time (US & Canada), Mexico City')
INSERT [dbo].[TimeZones] ([TimeZoneID], [Offset], [Sort], [TimeLabel]) VALUES (15, N'+11:00', 255, N'Magadan, Solomon Islands, New Caledonia')
INSERT [dbo].[TimeZones] ([TimeZoneID], [Offset], [Sort], [TimeLabel]) VALUES (16, N'-12:00', 255, N'Eniwetok, Kwajalein')
INSERT [dbo].[TimeZones] ([TimeZoneID], [Offset], [Sort], [TimeLabel]) VALUES (17, N'-3:30', 255, N'Newfoundland')
INSERT [dbo].[TimeZones] ([TimeZoneID], [Offset], [Sort], [TimeLabel]) VALUES (18, N'+0:00', 255, N'Western Europe Time, London, Lisbon, Casablanca')
INSERT [dbo].[TimeZones] ([TimeZoneID], [Offset], [Sort], [TimeLabel]) VALUES (19, N'+4:30', 255, N'Kabul')
INSERT [dbo].[TimeZones] ([TimeZoneID], [Offset], [Sort], [TimeLabel]) VALUES (20, N'+6:00', 255, N'Almaty, Dhaka, Colombo')
INSERT [dbo].[TimeZones] ([TimeZoneID], [Offset], [Sort], [TimeLabel]) VALUES (21, N'+9:00', 255, N'Tokyo, Seoul, Osaka, Sapporo, Yakutsk')
INSERT [dbo].[TimeZones] ([TimeZoneID], [Offset], [Sort], [TimeLabel]) VALUES (22, N'+1:00', 255, N'Brussels, Copenhagen, Madrid, Paris')
INSERT [dbo].[TimeZones] ([TimeZoneID], [Offset], [Sort], [TimeLabel]) VALUES (23, N'+10:00', 255, N'Eastern Australia, Guam, Vladivostok')
INSERT [dbo].[TimeZones] ([TimeZoneID], [Offset], [Sort], [TimeLabel]) VALUES (24, N'+7:00', 255, N'Bangkok, Hanoi, Jakarta')
INSERT [dbo].[TimeZones] ([TimeZoneID], [Offset], [Sort], [TimeLabel]) VALUES (25, N'+5:00', 255, N'Ekaterinburg, Islamabad, Karachi, Tashkent')
INSERT [dbo].[TimeZones] ([TimeZoneID], [Offset], [Sort], [TimeLabel]) VALUES (26, N'-11:00', 255, N'Midway Island, Samoa')
INSERT [dbo].[TimeZones] ([TimeZoneID], [Offset], [Sort], [TimeLabel]) VALUES (27, N'-1:00', 255, N'Azores, Cape Verde Islands')
INSERT [dbo].[TimeZones] ([TimeZoneID], [Offset], [Sort], [TimeLabel]) VALUES (28, N'-7:00', 5, N'Mountain Time (US & Canada)')
INSERT [dbo].[TimeZones] ([TimeZoneID], [Offset], [Sort], [TimeLabel]) VALUES (29, N'+12:00', 255, N'Auckland, Wellington, Fiji, Kamchatka')
INSERT [dbo].[TimeZones] ([TimeZoneID], [Offset], [Sort], [TimeLabel]) VALUES (30, N'+3:00', 255, N'Baghdad, Riyadh, Moscow, St. Petersburg')
INSERT [dbo].[TimeZones] ([TimeZoneID], [Offset], [Sort], [TimeLabel]) VALUES (31, N'+6:30', 255, N'Yangon, Cocos Islands')
INSERT [dbo].[TimeZones] ([TimeZoneID], [Offset], [Sort], [TimeLabel]) VALUES (32, N'+3:30', 255, N'Tehran')
INSERT [dbo].[TimeZones] ([TimeZoneID], [Offset], [Sort], [TimeLabel]) VALUES (33, N'-5:00', 1, N'Eastern Time (US & Canada), Bogota, Lima')
INSERT [dbo].[TimeZones] ([TimeZoneID], [Offset], [Sort], [TimeLabel]) VALUES (34, N'-8:00', 2, N'Pacific Time (US & Canada)')
INSERT [dbo].[TimeZones] ([TimeZoneID], [Offset], [Sort], [TimeLabel]) VALUES (35, N'-3:00', 255, N'Brazil, Buenos Aires, Georgetown')
INSERT [dbo].[TimeZones] ([TimeZoneID], [Offset], [Sort], [TimeLabel]) VALUES (36, N'+5:30', 255, N'Mumbai, Kolkata, Chennai, New Delhi')
SET IDENTITY_INSERT [dbo].[TimeZones] OFF
/****** Object:  Table [dbo].[TimeEvent]    Script Date: 01/17/2010 01:02:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TimeEvent]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[TimeEvent](
	[TimeEventID] [int] IDENTITY(1,1) NOT NULL,
	[EventName] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[EventDateTime] [datetime] NULL,
	[TimeZoneID] [int] NULL,
 CONSTRAINT [PK_TimeEvent] PRIMARY KEY CLUSTERED 
(
	[TimeEventID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON)
)
END
GO
SET IDENTITY_INSERT [dbo].[TimeEvent] ON
INSERT [dbo].[TimeEvent] ([TimeEventID], [EventName], [EventDateTime], [TimeZoneID]) VALUES (1, N'Dinner Time', CAST(0x000098E700D21D10 AS DateTime), 8)
INSERT [dbo].[TimeEvent] ([TimeEventID], [EventName], [EventDateTime], [TimeZoneID]) VALUES (2, N'Cleaning House', CAST(0x0000962F0019D160 AS DateTime), 12)
INSERT [dbo].[TimeEvent] ([TimeEventID], [EventName], [EventDateTime], [TimeZoneID]) VALUES (3, N'Wedding', CAST(0x00009CD20137859C AS DateTime), 19)
INSERT [dbo].[TimeEvent] ([TimeEventID], [EventName], [EventDateTime], [TimeZoneID]) VALUES (4, N'Buy New Computer', CAST(0x00009E1101624F20 AS DateTime), 33)
SET IDENTITY_INSERT [dbo].[TimeEvent] OFF