Файл: profileCover.sql
Строк: 11
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';