CREATE DATABASE `strikeironstudio_db`;
USE `strikeironstudio_db`;

CREATE TABLE IF NOT EXISTS `questions` (
   `id` int UNIQUE NOT NULL AUTO_INCREMENT,
   `text` text,
   `deleted` boolean NOT NULL DEFAULT 0,
   PRIMARY KEY(id)
);

CREATE TABLE IF NOT EXISTS `column` (
   `id` int UNIQUE NOT NULL AUTO_INCREMENT,
   `text` text(),
   `deleted` boolean NOT NULL DEFAULT 0,
   PRIMARY KEY(id)
);

CREATE TABLE IF NOT EXISTS `questions__column` (
    `question_id` int,
    `column_id` int,
    `false_value` float DEFAULT 1.0,
    `true_value` float,
);

CREATE TABLE IF NOT EXISTS `column_result` (
    `column_id` int,
    `min` float,
    `min_inclusive` boolean,
    `max` float,
    `max_inclusive` boolean,
    `img` text(),
    `html` text(),
);

INSERT INTO questions VALUES(1,'I only want a sulfate-free product.');
INSERT INTO questions VALUES(2,'I have allergies to milk.');
INSERT INTO questions VALUES(3,'My hair is very oily.');

INSERT INTO column VALUES(1,'Product 1');
INSERT INTO column VALUES(2,'Additional Weight');
INSERT INTO column VALUES(3,'Disqualifier');