USE [GenApp]
GO
/****** Object: Table [dbo].[Color] Script Date: 07/09/2009 11:59:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Color](
[ColorId] [int] IDENTITY(1,1) NOT NULL,
[ColorName] [varchar](50) NULL,
[ColorHex] [nchar](7) NULL,
[ColorDescription] [varchar](200) NULL,
CONSTRAINT [PK_Color] PRIMARY KEY CLUSTERED
(
[ColorId] 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 ON
GO
USE [GenApp];
SET NOCOUNT ON;
SET XACT_ABORT ON;
GO
SET IDENTITY_INSERT [dbo].[Color] ON;
BEGIN TRANSACTION;
INSERT INTO [dbo].[Color]([ColorId], [ColorName], [ColorHex], [ColorDescription])
SELECT 1, N'Black ', N'#000000', NULL UNION ALL
SELECT 2, N'Navy ', N'#000080', NULL UNION ALL
SELECT 3, N'DarkBlue ', N'#00008B', NULL UNION ALL
SELECT 4, N'MediumBlue ', N'#0000CD', NULL UNION ALL
SELECT 5, N'Blue ', N'#0000FF', NULL UNION ALL
SELECT 6, N'DarkGreen ', N'#006400', NULL UNION ALL
SELECT 7, N'Green ', N'#008000', NULL UNION ALL
SELECT 8, N'Teal ', N'#008080', NULL UNION ALL
SELECT 9, N'DarkCyan ', N'#008B8B', NULL UNION ALL
SELECT 10, N'DeepSkyBlue ', N'#00BFFF', NULL UNION ALL
SELECT 11, N'DarkTurquoise ', N'#00CED1', NULL UNION ALL
SELECT 12, N'MediumSpringGreen ', N'#00FA9A', NULL UNION ALL
SELECT 13, N'Lime ', N'#00FF00', NULL UNION ALL
SELECT 14, N'SpringGreen ', N'#00FF7F', NULL UNION ALL
SELECT 15, N'Aqua ', N'#00FFFF', NULL UNION ALL
SELECT 16, N'Cyan ', N'#00FFFF', NULL UNION ALL
SELECT 17, N'MidnightBlue ', N'#191970', NULL UNION ALL
SELECT 18, N'DodgerBlue ', N'#1E90FF', NULL UNION ALL
SELECT 19, N'LightSeaGreen ', N'#20B2AA', NULL UNION ALL
SELECT 20, N'ForestGreen ', N'#228B22', NULL UNION ALL
SELECT 21, N'SeaGreen ', N'#2E8B57', NULL UNION ALL
SELECT 22, N'DarkSlateGray ', N'#2F4F4F', NULL UNION ALL
SELECT 23, N'LimeGreen ', N'#32CD32', NULL UNION ALL
SELECT 24, N'MediumSeaGreen ', N'#3CB371', NULL UNION ALL
SELECT 25, N'Turquoise ', N'#40E0D0', NULL UNION ALL
SELECT 26, N'RoyalBlue ', N'#4169E1', NULL UNION ALL
SELECT 27, N'SteelBlue ', N'#4682B4', NULL UNION ALL
SELECT 28, N'DarkSlateBlue ', N'#483D8B', NULL UNION ALL
SELECT 29, N'MediumTurquoise ', N'#48D1CC', NULL UNION ALL
SELECT 30, N'Indigo ', N'#4B0082', NULL UNION ALL
SELECT 31, N'DarkOliveGreen ', N'#556B2F', NULL UNION ALL
SELECT 32, N'CadetBlue ', N'#5F9EA0', NULL UNION ALL
SELECT 33, N'CornflowerBlue ', N'#6495ED', NULL UNION ALL
SELECT 34, N'MediumAquaMarine ', N'#66CDAA', NULL UNION ALL
SELECT 35, N'DimGray ', N'#696969', NULL UNION ALL
SELECT 36, N'SlateBlue ', N'#6A5ACD', NULL UNION ALL
SELECT 37, N'OliveDrab ', N'#6B8E23', NULL UNION ALL
SELECT 38, N'SlateGray ', N'#708090', NULL UNION ALL
SELECT 39, N'LightSlateGray ', N'#778899', NULL UNION ALL
SELECT 40, N'MediumSlateBlue ', N'#7B68EE', NULL UNION ALL
SELECT 41, N'LawnGreen ', N'#7CFC00', NULL UNION ALL
SELECT 42, N'Chartreuse ', N'#7FFF00', NULL UNION ALL
SELECT 43, N'Aquamarine ', N'#7FFFD4', NULL UNION ALL
SELECT 44, N'Maroon ', N'#800000', NULL UNION ALL
SELECT 45, N'Purple ', N'#800080', NULL UNION ALL
SELECT 46, N'Olive ', N'#808000', NULL UNION ALL
SELECT 47, N'Gray ', N'#808080', NULL UNION ALL
SELECT 48, N'SkyBlue ', N'#87CEEB', NULL UNION ALL
SELECT 49, N'LightSkyBlue ', N'#87CEFA', NULL UNION ALL
SELECT 50, N'BlueViolet ', N'#8A2BE2', NULL
COMMIT;
RAISERROR (N'[dbo].[Color]: Insert Batch: 1.....Done!', 10, 1) WITH NOWAIT;
GO
BEGIN TRANSACTION;
INSERT INTO [dbo].[Color]([ColorId], [ColorName], [ColorHex], [ColorDescription])
SELECT 51, N'DarkRed ', N'#8B0000', NULL UNION ALL
SELECT 52, N'DarkMagenta ', N'#8B008B', NULL UNION ALL
SELECT 53, N'SaddleBrown ', N'#8B4513', NULL UNION ALL
SELECT 54, N'DarkSeaGreen ', N'#8FBC8F', NULL UNION ALL
SELECT 55, N'LightGreen ', N'#90EE90', NULL UNION ALL
SELECT 56, N'MediumPurple ', N'#9370D8', NULL UNION ALL
SELECT 57, N'DarkViolet ', N'#9400D3', NULL UNION ALL
SELECT 58, N'PaleGreen ', N'#98FB98', NULL UNION ALL
SELECT 59, N'DarkOrchid ', N'#9932CC', NULL UNION ALL
SELECT 60, N'YellowGreen ', N'#9ACD32', NULL UNION ALL
SELECT 61, N'Sienna ', N'#A0522D', NULL UNION ALL
SELECT 62, N'Brown ', N'#A52A2A', NULL UNION ALL
SELECT 63, N'DarkGray ', N'#A9A9A9', NULL UNION ALL
SELECT 64, N'LightBlue ', N'#ADD8E6', NULL UNION ALL
SELECT 65, N'GreenYellow ', N'#ADFF2F', NULL UNION ALL
SELECT 66, N'PaleTurquoise ', N'#AFEEEE', NULL UNION ALL
SELECT 67, N'LightSteelBlue ', N'#B0C4DE', NULL UNION ALL
SELECT 68, N'PowderBlue ', N'#B0E0E6', NULL UNION ALL
SELECT 69, N'FireBrick ', N'#B22222', NULL UNION ALL
SELECT 70, N'DarkGoldenRod ', N'#B8860B', NULL UNION ALL
SELECT 71, N'MediumOrchid ', N'#BA55D3', NULL UNION ALL
SELECT 72, N'RosyBrown ', N'#BC8F8F', NULL UNION ALL
SELECT 73, N'DarkKhaki ', N'#BDB76B', NULL UNION ALL
SELECT 74, N'Silver ', N'#C0C0C0', NULL UNION ALL
SELECT 75, N'MediumVioletRed ', N'#C71585', NULL UNION ALL
SELECT 76, N'IndianRed ', N'#CD5C5C', NULL UNION ALL
SELECT 77, N'Peru ', N'#CD853F', NULL UNION ALL
SELECT 78, N'Chocolate ', N'#D2691E', NULL UNION ALL
SELECT 79, N'Tan ', N'#D2B48C', NULL UNION ALL
SELECT 80, N'LightGrey ', N'#D3D3D3', NULL UNION ALL
SELECT 81, N'PaleVioletRed ', N'#D87093', NULL UNION ALL
SELECT 82, N'Thistle ', N'#D8BFD8', NULL UNION ALL
SELECT 83, N'Orchid ', N'#DA70D6', NULL UNION ALL
SELECT 84, N'GoldenRod ', N'#DAA520', NULL UNION ALL
SELECT 85, N'Crimson ', N'#DC143C', NULL UNION ALL
SELECT 86, N'Gainsboro ', N'#DCDCDC', NULL UNION ALL
SELECT 87, N'Plum ', N'#DDA0DD', NULL UNION ALL
SELECT 88, N'BurlyWood ', N'#DEB887', NULL UNION ALL
SELECT 89, N'LightCyan ', N'#E0FFFF', NULL UNION ALL
SELECT 90, N'Lavender ', N'#E6E6FA', NULL UNION ALL
SELECT 91, N'DarkSalmon ', N'#E9967A', NULL UNION ALL
SELECT 92, N'Violet ', N'#EE82EE', NULL UNION ALL
SELECT 93, N'PaleGoldenRod ', N'#EEE8AA', NULL UNION ALL
SELECT 94, N'LightCoral ', N'#F08080', NULL UNION ALL
SELECT 95, N'Khaki ', N'#F0E68C', NULL UNION ALL
SELECT 96, N'AliceBlue ', N'#F0F8FF', NULL UNION ALL
SELECT 97, N'HoneyDew ', N'#F0FFF0', NULL UNION ALL
SELECT 98, N'Azure ', N'#F0FFFF', NULL UNION ALL
SELECT 99, N'SandyBrown ', N'#F4A460', NULL UNION ALL
SELECT 100, N'Wheat ', N'#F5DEB3', NULL
COMMIT;
RAISERROR (N'[dbo].[Color]: Insert Batch: 2.....Done!', 10, 1) WITH NOWAIT;
GO
BEGIN TRANSACTION;
INSERT INTO [dbo].[Color]([ColorId], [ColorName], [ColorHex], [ColorDescription])
SELECT 101, N'Beige ', N'#F5F5DC', NULL UNION ALL
SELECT 102, N'WhiteSmoke ', N'#F5F5F5', NULL UNION ALL
SELECT 103, N'MintCream ', N'#F5FFFA', NULL UNION ALL
SELECT 104, N'GhostWhite ', N'#F8F8FF', NULL UNION ALL
SELECT 105, N'Salmon ', N'#FA8072', NULL UNION ALL
SELECT 106, N'AntiqueWhite ', N'#FAEBD7', NULL UNION ALL
SELECT 107, N'Linen ', N'#FAF0E6', NULL UNION ALL
SELECT 108, N'LightGoldenRodYellow ', N'#FAFAD2', NULL UNION ALL
SELECT 109, N'OldLace ', N'#FDF5E6', NULL UNION ALL
SELECT 110, N'Red ', N'#FF0000', NULL UNION ALL
SELECT 111, N'Fuchsia ', N'#FF00FF', NULL UNION ALL
SELECT 112, N'Magenta ', N'#FF00FF', NULL UNION ALL
SELECT 113, N'DeepPink ', N'#FF1493', NULL UNION ALL
SELECT 114, N'OrangeRed ', N'#FF4500', NULL UNION ALL
SELECT 115, N'Tomato ', N'#FF6347', NULL UNION ALL
SELECT 116, N'HotPink ', N'#FF69B4', NULL UNION ALL
SELECT 117, N'Coral ', N'#FF7F50', NULL UNION ALL
SELECT 118, N'Darkorange ', N'#FF8C00', NULL UNION ALL
SELECT 119, N'LightSalmon ', N'#FFA07A', NULL UNION ALL
SELECT 120, N'Orange ', N'#FFA500', NULL UNION ALL
SELECT 121, N'LightPink ', N'#FFB6C1', NULL UNION ALL
SELECT 122, N'Pink ', N'#FFC0CB', NULL UNION ALL
SELECT 123, N'Gold ', N'#FFD700', NULL UNION ALL
SELECT 124, N'PeachPuff ', N'#FFDAB9', NULL UNION ALL
SELECT 125, N'NavajoWhite ', N'#FFDEAD', NULL UNION ALL
SELECT 126, N'Moccasin ', N'#FFE4B5', NULL UNION ALL
SELECT 127, N'Bisque ', N'#FFE4C4', NULL UNION ALL
SELECT 128, N'MistyRose ', N'#FFE4E1', NULL UNION ALL
SELECT 129, N'BlanchedAlmond ', N'#FFEBCD', NULL UNION ALL
SELECT 130, N'PapayaWhip ', N'#FFEFD5', NULL UNION ALL
SELECT 131, N'LavenderBlush ', N'#FFF0F5', NULL UNION ALL
SELECT 132, N'SeaShell ', N'#FFF5EE', NULL UNION ALL
SELECT 133, N'Cornsilk ', N'#FFF8DC', NULL UNION ALL
SELECT 134, N'LemonChiffon ', N'#FFFACD', NULL UNION ALL
SELECT 135, N'FloralWhite ', N'#FFFAF0', NULL UNION ALL
SELECT 136, N'Snow ', N'#FFFAFA', NULL UNION ALL
SELECT 137, N'Yellow ', N'#FFFF00', NULL UNION ALL
SELECT 138, N'LightYellow ', N'#FFFFE0', NULL UNION ALL
SELECT 139, N'Ivory ', N'#FFFFF0', NULL UNION ALL
SELECT 140, N'White ', N'#FFFFFF', NULL
COMMIT;
RAISERROR (N'[dbo].[Color]: Insert Batch: 3.....Done!', 10, 1) WITH NOWAIT;
GO
SET IDENTITY_INSERT [dbo].[Color] OFF;
No comments:
Post a Comment
- the first minus - Comments have to be moderated because of the spammers
- the second minus - I am very lazy at moderating comments ... hardly find time ...
- the third minus - Short links are no good for security ...
- The REAL PLUS : Any critic and positive feedback is better than none, so your comments will be published sooner or later !!!!