character
DROP TABLE IF EXISTS character;
CREATE TABLE character (
id int(10) unsigned NOT NULL,
name varchar(255) NOT NULL,
depth bit(1) NOT NULL,
tagonist int(10) NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
event
DROP TABLE IF EXISTS event;
CREATE TABLE event (
id int(10) unsigned NOT NULL,
chronologicalOrder int(10) NOT NULL,
flash int(10) NULL,
note varchar(255) NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
situationExit
DROP TABLE IF EXISTS situationExitType;
CREATE TABLE situationExitType (
id int(10) unsigned NOT NULL,
situationId int(10) unsigned NOT NULL,
situationExitTypeId int(10) unsigned NOT NULL,
name varchar(255) NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
situationExitType
DROP TABLE IF EXISTS situationExitType;
CREATE TABLE situationExitType (
id int(10) unsigned NOT NULL,
name varchar(255) NOT NULL,
order int(10) unsigned NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO situationType (1,'Redirect',1);
INSERT INTO situationType (2,'Avoid',2);
INSERT INTO situationType (3,'Delay',3);
INSERT INTO situationType (4,'Brute Force',4);
INSERT INTO situationType (5,'Weaken',5);
INSERT INTO situationType (6,'Fail',6);
setting
DROP TABLE IF EXISTS setting;
CREATE TABLE setting (
id int(10) unsigned NOT NULL,
name varchar(255) NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
situation
DROP TABLE IF EXISTS situation;
CREATE TABLE situation (
id int(10) unsigned NOT NULL,
name varchar(255) NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
situationType
DROP TABLE IF EXISTS situationType;
CREATE TABLE situationType (
id int(10) unsigned NOT NULL,
name varchar(255) NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO situationType (1,'Acting');
INSERT INTO situationType (2,'Creating');
INSERT INTO situationType (3,'Feeling');
INSERT INTO situationType (4,'Fighting');
INSERT INTO situationType (5,'Solving');