Просмотр архива Портфолио HELLSTYLE

DROP TABLE IF EXISTS `categories`;

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

INSERT
INTO categories VALUES("1","WEB дизайн");
INSERT
INTO categories VALUES("2","Wap дизайн");
INSERT
INTO categories VALUES("3","Оформление
групп");
INSERT INTO categories
VALUES("4","Обработка фото");
INSERT INTO
categories VALUES("6","Разработка
макетов");
INSERT INTO categories
VALUES("7","Приложения");
INSERT INTO
categories VALUES("8","Баннеры");



DROP TABLE
IF EXISTS `contacts`;

CREATE TABLE `contacts` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `value` varchar(200) NOT
NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;




DROP
TABLE IF EXISTS `prices`;

CREATE TABLE `prices` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `price` int(11) NOT
NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;




DROP
TABLE IF EXISTS `projects`;

CREATE TABLE `projects` (
  `id` int(11) NOT
NULL AUTO_INCREMENT,
  `cat_id` int(11) NOT NULL,
  `name` varchar(200) NOT
NULL,
  `about` text NOT NULL,
  `time` int(11) NOT NULL,
  `price` int(11)
NOT NULL,
  `status` int(11) NOT NULL,
  `plus` int(11) NOT NULL,
  `minus`
int(11) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;




DROP TABLE IF
EXISTS `reviews`;

CREATE TABLE `reviews` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `name` varchar(20) NOT NULL,
  `type` int(11) NOT NULL,
 
`text` text NOT NULL,
  `date` timestamp NOT NULL DEFAULT
CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `vote`;

CREATE TABLE `vote` (
 
`id` int(11) NOT NULL AUTO_INCREMENT,
  `project_id` int(11) NOT NULL,
 
`ip` varchar(20) NOT NULL,
  `date` timestamp NOT NULL DEFAULT
CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8;