View file profileCover.sql

DROP TABLE IF EXISTS `profileCoversCategories`;

CREATE TABLE IF NOT EXISTS `profileCoversCategories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

DELETE FROM `profileCoversCategories`;

INSERT INTO `profileCoversCategories` (`id`, `name`) VALUES
	(1, 'Космос'),
	(2, 'Разное'),
	(4, 'Авто, мото'),
	(5, 'Игра цветов'),
	(6, 'Города'),
	(7, 'Архитектура');

DROP TABLE IF EXISTS `profileCoversList`;

CREATE TABLE IF NOT EXISTS `profileCoversList` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_category` int(11) NOT NULL DEFAULT '0',
  `price` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=83 DEFAULT CHARSET=utf8;

DELETE FROM `profileCoversList`;

INSERT INTO `profileCoversList` (`id`, `id_category`, `price`) VALUES
	(1, 1, 120),
	(6, 2, 100),
	(10, 2, 150),
	(11, 2, 130),
	(13, 2, 200),
	(16, 1, 150),
	(17, 1, 130),
	(18, 1, 150),
	(19, 1, 170),
	(20, 1, 200),
	(21, 1, 190),
	(22, 1, 110),
	(23, 1, 180),
	(24, 1, 170),
	(25, 1, 250),
	(26, 1, 230),
	(27, 4, 100),
	(28, 4, 120),
	(29, 4, 130),
	(30, 4, 140),
	(31, 4, 150),
	(32, 4, 160),
	(33, 4, 170),
	(34, 4, 155),
	(35, 4, 190),
	(36, 4, 200),
	(37, 4, 180),
	(38, 4, 230),
	(39, 5, 150),
	(40, 5, 170),
	(41, 5, 160),
	(42, 5, 180),
	(43, 5, 155),
	(44, 5, 140),
	(45, 5, 175),
	(46, 5, 190),
	(47, 5, 200),
	(48, 5, 195),
	(49, 5, 165),
	(50, 5, 230),
	(51, 6, 200),
	(52, 6, 210),
	(53, 6, 180),
	(54, 6, 195),
	(55, 6, 230),
	(56, 6, 240),
	(57, 6, 300),
	(58, 6, 260),
	(59, 6, 280),
	(60, 6, 170),
	(61, 6, 220),
	(62, 6, 235),
	(63, 7, 100),
	(64, 7, 120),
	(65, 7, 130),
	(66, 7, 140),
	(67, 7, 200),
	(68, 7, 155),
	(69, 7, 135),
	(70, 7, 155),
	(71, 7, 170),
	(72, 7, 180),
	(73, 7, 190),
	(74, 7, 145),
	(75, 2, 170),
	(76, 2, 180),
	(77, 2, 165),
	(78, 2, 160),
	(79, 2, 190),
	(80, 2, 145),
	(81, 2, 130),
	(82, 2, 125);

ALTER TABLE `user` ADD COLUMN `profileCover` INT(11) NULL DEFAULT '0';