create database propulsion-studies;
use propulsion-studies;
create table participant (id int not null default 0 auto_increment primary key, account char(42), name char(42), city char(42), state char(42), country char(42), )
create table side-effects (id int not null default 0 auto_increment primary key, injuries blob, damage blob, experience blob, )
create table battery-type (id int not null default 0 auto_increment primary key, manufacture char(42), type char(42), mAh char(5), )
create table motor-type (id int not null default 0 auto_increment primary key, manufacture char(42), type char(42), )
create table craft-type (id int not null default 0 auto_increment primary key, )
create table fuel-type (id int not null default 0 auto_increment primary key, )
create table date-place-temps (id int not null default 0 auto_increment primary key, enterdate date NOT NULL, time char(6), city char(42), state char(42), country char(42), track-length char(42), daytemp char(5), tracktemp char(5), motortemp char(5), )
create table lap-times (id int not null default 0 auto_increment primary key, laptime char(6), )