 	title VARCHAR(128),
 	contractor INT UNSIGNED,
 	model INT UNSIGNED,
+	worker INT UNSIGNED,
+	helper INT UNSIGNED,
 	PRIMARY KEY (id)
+) ENGINE=innoDB;
+
+CREATE TABLE jobparts(
+	jid INT UNSIGNED,
+	pid INT UNSIGNED,
+	room VARCHAR(32),
 ) ENGINE=innoDB;
 
 CREATE TABLE parts(


CREATE DATABASE baskets;
GRANT ALL ON baskets.* TO baskets@localhost IDENTIFIED BY 'baskets';
CREATE TABLE jobs(
	id INT UNSIGNED NOT NULL AUTO_INCREMENT,
	dt DATETIME,

-- tables:
--	baskets
--	contractors
--	helpers
--	images
--	jobs
--	jobparts
--	models
--	parts
--	suppliers
