logicalProgression.db.sql

BEGIN TRANSACTION;
CREATE TABLE IF NOT EXISTS `training` (
	`ID`	INTEGER PRIMARY KEY AUTOINCREMENT UNIQUE,
	`sessionID`	INTEGER,
	`exersiseID`	INTEGER,
	`sets`	INTEGER,
	`comment`	TEXT
);
CREATE TABLE IF NOT EXISTS `sets` (
	`ID`	INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,
	`trainingID`	INTEGER NOT NULL,
	`reps`	INTEGER NOT NULL,
	`weight`	REAL
);
CREATE TABLE IF NOT EXISTS `sessions` (
	`ID`	INTEGER PRIMARY KEY AUTOINCREMENT UNIQUE,
	`date`	INTEGER,
	`type`	TEXT,
	`climbDuration`	INTEGER,
	`trainingDuration`	INTEGER,
	`density`	REAL,
	`sum`	INTEGER,
	`avgGrade`	REAL,
	`avgSent`	REAL
);
CREATE TABLE IF NOT EXISTS `holdTypes` (
	`short`	TEXT,
	`longDE`	TEXT,
	`longEN`	INTEGER
);
CREATE TABLE IF NOT EXISTS `exersises` (
	`ID`	INTEGER PRIMARY KEY AUTOINCREMENT UNIQUE,
	`name`	TEXT UNIQUE,
	`muscleGroup`	TEXT,
	`multiplier`	REAL
);
CREATE TABLE IF NOT EXISTS `boulder` (
	`ID`	INTEGER PRIMARY KEY AUTOINCREMENT UNIQUE,
	`sessionID`	INTEGER,
	`grade`	INTEGER,
	`tries`	INTEGER,
	`sent`	INTEGER,
	`steepness`	REAL,
	`holdType`	TEXT,
	`comment`	TEXT
);
COMMIT;