drawml.sql

CREATE TABLE `drawml`.`user` (
  `id` INTEGER NOT NULL AUTO_INCREMENT,
  `date_created` DATETIME DEFAULT NOW(),
  `date_modified` DATETIME DEFAULT NOW(),
  `user_id` VARCHAR(64) NOT NULL,
  `pw` VARCHAR(64) NOT NULL,
  PRIMARY KEY (`user_id`),
  UNIQUE INDEX `id_UNIQUE` (`id` ASC),
  UNIQUE INDEX `user_id_name_UNIQUE` (`user_id` ASC));

CREATE TABLE `drawml`.`experiment` (
  `id` INTEGER NOT NULL AUTO_INCREMENT,
  `date_created` DATETIME DEFAULT NOW(),
  `date_modified` DATETIME DEFAULT NOW(),
  `name` VARCHAR(45) NOT NULL,
  `user_id` INTEGER NOT NULL,
  `xml` BLOB NULL,
  `drawing` BLOB NULL,
  PRIMARY KEY (`user_id`, `name`),
  FOREIGN KEY user(user_id) REFERENCES user(id) ON DELETE CASCADE,
  UNIQUE INDEX `id_UNIQUE` (`id` ASC),
  UNIQUE INDEX `user_id_name_UNIQUE` (`user_id`, `name` ASC));

CREATE TABLE `drawml`.`data` (
  `id` INTEGER NOT NULL AUTO_INCREMENT,
  `date_created` DATETIME DEFAULT NOW(),
  `date_modified` DATETIME DEFAULT NOW(),
  `name` VARCHAR(255) NOT NULL,
  `path` VARCHAR(255) NOT NULL,
  `user_id` INTEGER NOT NULL,
  `type` VARCHAR(16) NOT NULL,
  PRIMARY KEY (`user_id`, `name`),
  FOREIGN KEY user(user_id) REFERENCES user(id) ON DELETE CASCADE,
  UNIQUE INDEX `id_UNIQUE` (`id` ASC),
  UNIQUE INDEX `user_id_name_UNIQUE` (`user_id`, `name` ASC));

CREATE TABLE `drawml`.`trainedmodel` (
  `id` INTEGER NOT NULL AUTO_INCREMENT,
  `date_created` DATETIME DEFAULT NOW(),
  `date_modified` DATETIME DEFAULT NOW(),
  `name` VARCHAR(45) NOT NULL,
  `path` VARCHAR(255) NOT NULL,
  `xml` BLOB NOT NULL,
  `user_id` INTEGER NOT NULL,
  PRIMARY KEY (`user_id`, `name`),
  FOREIGN KEY user(user_id) REFERENCES user(id) ON DELETE CASCADE,
  UNIQUE INDEX `id_UNIQUE` (`id` ASC),
  UNIQUE INDEX `user_id_name_UNIQUE` (`user_id`, `name` ASC));