CREATE TABLE IF NOT EXISTS `cookies`
(
  `id`      int(11) NOT NULL AUTO_INCREMENT,
  `cookie`  text    NOT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = latin1
  AUTO_INCREMENT = 10;

CREATE TABLE IF NOT EXISTS `quotes`
(
  `id`         int(11)  NOT NULL AUTO_INCREMENT,
  `user_id`    int(11)  NOT NULL,
  `created_at` datetime NOT NULL,
  `status`     int(11)  NOT NULL,
  `price`      double DEFAULT NULL,
  `details`    text,
  `file`       text,
  PRIMARY KEY (`id`),
  KEY `user_id_index` (`user_id`),
  KEY `status_index` (`status`)
) ENGINE = InnoDB
  DEFAULT CHARSET = latin1
  AUTO_INCREMENT = 100;

CREATE TABLE IF NOT EXISTS `register_requests`
(
  `user_id` int(11)      NOT NULL,
  `email`   varchar(255) NOT NULL,
  `token`   varchar(255) NOT NULL,
  PRIMARY KEY (`user_id`),
  KEY `token_index` (`token`),
  KEY `email_index` (`email`)
) ENGINE = InnoDB
  DEFAULT CHARSET = latin1;