rollerverbrauch/app/schema.sql

drop table if exists pitstops;
create table pitstops (
	`id`		INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
	`date`		TEXT NOT NULL,
	`odometer`	INTEGER NOT NULL,
	`litres`	REAL NOT NULL
);

drop table if exists services;
CREATE TABLE `services` (
	`id`			INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
	`date`			TEXT,
	`odometer_planned`	INTEGER NOT NULL,
	`odometer_done`		INTEGER,
	`tasks`			TEXT NOT NULL
);

drop table if exists users;
create table `users` (
	`id` 		INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
	`name`		TEXT NOT NULL,
	`salt`		TEXT NOT NULL,
	`password`	TEXT NOT NULL
);
insert into users (name, salt, password) values ('shing19m', 'pL85Kl2U', '207357fdbf6f379c53bb5ab7fa0bc8c0072ae743973a510f551db7b5c90049b7');