create database graphlayout;

DROP TABLE IF EXISTS graph_model;
CREATE TABLE graph_model
(
  version INTEGER NOT NULL AUTO_INCREMENT,
  name VARCHAR(256) NULL,
  created_date  TIMESTAMP NOT NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY(version)
);

DROP TABLE IF EXISTS edge_snapshot;
CREATE TABLE graph_model
(
  version INTEGER NOT NULL,
  edge_version INTEGER NOT NULL,
  edge_id INTEGER NOT NULL,
  PRIMARY KEY(version,edge_version,edge_id)
);

DROP TABLE IF EXISTS vertex_snapshot;
CREATE TABLE graph_model
(
  version INTEGER NOT NULL,
  vertex_version INTEGER NOT NULL,
  vertex_id INTEGER NOT NULL,
  PRIMARY KEY(version,vertex_version,vertex_id)
);

DROP TABLE IF EXISTS vertex_model;
CREATE TABLE vertex_model
(
  version INTEGER NOT NULL,
  vertex_id INTEGER NOT NULL,
  layer INTEGER NOT NULL,
  constraint FLOAT NOT NULL default 0.0,
  movable BOOL NULL,
  barycentric FLOAT NOT NULL,
  PRIMARY KEY(version,vertex_id)
);

DROP TABLE IF EXISTS vertex_property;
CREATE TABLE vertex_property
(
  vertex_id INTEGER NOT NULL,
  width INTEGER NOT NULL,
  height INTEGER NOT NULL,
  shape_type INTEGER NOT NULL,
  filled_color  INTEGER NOT NULL,
  PRIMARY KEY(vertex_id)
);

DROP TABLE IF EXISTS edge_model;
CREATE TABLE edge_model
(
  version INTEGER NOT NULL,
  edge_id INTEGER NOT NULL,
  head INTEGER NOT NULL,
  tail INTEGER NOT NULL,
  PRIMARY KEY(version,edge_id)
);

DROP TABLE IF EXISTS edge_property;
CREATE TABLE vertex_property
(
  edge_id INTEGER NOT NULL,
  thickness INTEGER NOT NULL,
  color INTEGER NOT NULL,
  PRIMARY KEY(edge_id)
);