CREATE TABLE IF NOT EXISTS `user_link` (
`id_user` int(11) NOT NULL,
`id_link` int(11) NOT NULL,
`position` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `user_link_list` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`icon` varchar(24) NOT NULL,
`name` varchar(32) NOT NULL,
`link` varchar(32) NOT NULL,
`name_str` varchar(32) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
alter table `user` add `foot_panel_type` varchar(10) default 'icon';
ALTER TABLE `user` ADD COLUMN `user_panel_colors` VARCHAR(50) NULL DEFAULT NULL;
CREATE TABLE IF NOT EXISTS `user_panel_colors` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`color` varchar(100) NOT NULL,
`name` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=123 DEFAULT CHARSET=utf8;
INSERT INTO `user_panel_colors` (`id`, `color`, `name`) VALUES
(1, 'CD5C5C', 'IndianRed'),
(2, 'F08080', 'LightCoral'),
(3, 'FA8072', 'Salmon'),
(4, 'E9967A', 'DarkSalmon'),
(5, 'FFA07A', 'LightSalmon'),
(6, 'DC143C', 'Crimson'),
(7, 'FF0000', 'Red'),
(8, 'B22222', 'FireBrick'),
(9, '8B0000', 'DarkRed'),
(10, 'FFC0CB', 'Pink'),
(11, 'FFB6C1', 'LightPink'),
(12, 'FF69B4', 'HotPink'),
(13, 'FF1493', 'DeepPink'),
(14, 'C71585', 'MediumVioletRed'),
(15, 'DB7093', 'PaleVioletRed'),
(16, 'FF7F50', 'Coral'),
(20, 'FFA500', 'Orange'),
(21, 'FFD700', 'Gold'),
(27, 'FFE4B5', 'Moccasin'),
(28, 'FFDAB9', 'PeachPuff'),
(29, 'EEE8AA', 'PaleGoldenrod'),
(30, 'F0E68C', 'Khaki'),
(31, 'BDB76B', 'DarkKhaki'),
(32, 'E6E6FA', 'Lavender'),
(33, 'D8BFD8', 'Thistle'),
(34, 'DDA0DD', 'Plum'),
(35, 'EE82EE', 'Violet'),
(36, 'DA70D6', 'Orchid'),
(37, 'FF00FF', 'Magenta'),
(38, 'BA55D3', 'MediumOrchid'),
(39, '9370DB', 'MediumPurple'),
(40, '8A2BE2', 'BlueViolet'),
(41, '9400D3', 'DarkViolet'),
(42, '9932CC', 'DarkOrchid'),
(43, '8B008B', 'DarkMagenta'),
(44, '800080', 'Purple'),
(45, '4B0082', 'Indigo'),
(46, '6A5ACD', 'SlateBlue'),
(50, '7CFC00', 'LawnGreen'),
(52, '32CD32', 'LimeGreen'),
(53, '98FB98', 'PaleGreen'),
(54, '90EE90', 'LightGreen'),
(55, '00FA9A', 'MediumSpringGreen'),
(56, '00FF7F', 'SpringGreen'),
(57, '3CB371', 'MediumSeaGreen'),
(58, '2E8B57', 'SeaGreen'),
(59, '228B22', 'ForestGreen'),
(60, '008000', 'Green'),
(61, '006400', 'DarkGreen'),
(62, '9ACD32', 'YellowGreen'),
(63, '6B8E23', 'OliveDrab'),
(64, '808000', 'Olive'),
(65, '556B2F', 'DarkOliveGreen'),
(66, '66CDAA', 'MediumAquamarine'),
(67, '8FBC8F', 'DarkSeaGreen'),
(68, '20B2AA', 'LightSeaGreen'),
(69, '008B8B', 'DarkCyan'),
(70, '008080', 'Teal'),
(71, '00FFFF', 'Cyan'),
(73, 'AFEEEE', 'PaleTurquoise'),
(74, '7FFFD4', 'Aquamarine'),
(75, '40E0D0', 'Turquoise'),
(76, '48D1CC', 'MediumTurquoise'),
(77, '00CED1', 'DarkTurquoise'),
(78, '5F9EA0', 'CadetBlue'),
(79, '4682B4', 'SteelBlue'),
(80, 'B0C4DE', 'LightSteelBlue'),
(81, 'B0E0E6', 'PowderBlue'),
(82, 'ADD8E6', 'LightBlue'),
(83, '87CEEB', 'SkyBlue'),
(84, '87CEFA', 'LightSkyBlue'),
(85, '00BFFF', 'DeepSkyBlue'),
(86, '1E90FF', 'DodgerBlue'),
(87, '6495ED', 'CornflowerBlue'),
(88, '7B68EE', 'MediumSlateBlue'),
(89, '4169E1', 'RoyalBlue'),
(90, '0000FF', 'Blue'),
(91, '0000CD', 'MediumBlue'),
(92, '00008B', 'DarkBlue'),
(93, '000080', 'Navy'),
(94, '191970', 'MidnightBlue'),
(96, 'FFEBCD', 'BlanchedAlmond'),
(97, 'FFE4C4', 'Bisque'),
(98, 'FFDEAD', 'NavajoWhite'),
(99, 'F5DEB3', 'Wheat'),
(100, 'DEB887', 'BurlyWood'),
(101, 'D2B48C', 'Tan'),
(102, 'BC8F8F', 'RosyBrown'),
(103, 'F4A460', 'SandyBrown'),
(104, 'DAA520', 'Goldenrod'),
(105, 'B8860B', 'DarkGoldenrod'),
(106, 'CD853F', 'Peru'),
(107, 'D2691E', 'Chocolate'),
(108, '8B4513', 'SaddleBrown'),
(109, 'A0522D', 'Sienna'),
(110, 'A52A2A', 'Brown'),
(111, '800000', 'Maroon'),
(112, 'FFE4E1', 'MistyRose'),
(113, 'DCDCDC', 'Gainsboro'),
(114, 'D3D3D3', 'LightGray'),
(115, 'C0C0C0', 'Silver'),
(116, 'A9A9A9', 'DarkGray'),
(117, '808080', 'Gray'),
(118, '696969', 'DimGray'),
(119, '778899', 'LightSlateGray'),
(120, '708090', 'SlateGray'),
(121, '2F4F4F', 'DarkSlateGray'),
(122, '000000', 'Black');