netsim/db/dbinit.sqlite3.script

CREATE TABLE user (
	id integer PRIMARY KEY,
	name text,
	password text
);

INSERT INTO user (name, password) VALUES ('erinn','$2y$10$n5ajLY.kMZVjLCNsUuPXFO70VUYLoolpQRGl3RCXOBVIaY4/peWXS');

CREATE TABLE category (
	id integer PRIMARY KEY,
	name text,
	orderby integer
);

INSERT INTO category (name, orderby) VALUES
	('Basics', 1),
	('Spoofs', 2),
	('Denial of Service', 3),
	('Attacks', 4)
;

CREATE TABLE level (
	id integer PRIMARY KEY,
	category_id integer,
	name text,
	orderby integer,
	filename text
);

INSERT INTO level (category_id, name, orderby, filename) VALUES
	(1, 'Basics 1', 1, '01 Basics/level01'),
	(1, 'Basics 2', 2, '01 Basics/level02'),
	(1, 'Basics 3', 3, '01 Basics/level03'),
	(1, 'Basics 4', 4, '01 Basics/level04'),
	(1, 'Basics 5', 5, '01 Basics/level05'),

	(2, 'Spoofs 1', 1, '02 Spoofs/spoofs01'),
	(2, 'Spoofs 2', 2, '02 Spoofs/spoofs02'),
	
	(3, 'DoS 1', 1, '03 DoS/dos01'),
	(3, 'DoS 2', 2, '03 DoS/dos02'),
	(3, 'DoS 3', 3, '03 DoS/dos03'),

	(4, 'Attacks 1', 1, '04 Attacks/attacks01')
;

CREATE TABLE solns (
	id integer PRIMARY KEY,
	user_id integer,
	level_id integer,
	completed integer,
	json text
);