4zE9mkLe

1DROP TABLE IF EXISTS donations;
2DROP TABLE IF EXISTS disbursement;
3
4CREATE TABLE disbursement(
5	d_id VARCHAR(100) UNIQUE NOT NULL,
6	v_id INT(11) NOT NULL,
7	transporter_id INT(11) NOT NULL,
8	receipt VARCHAR(100) UNIQUE NOT NULL,
9	amount INT(100) NOT NULL,
10	completion_time VARCHAR(100) NOT NULL,
11
12	PRIMARY KEY(d_id),
13	FOREIGN KEY(v_id) REFERENCES vehicle(id)
14		ON UPDATE CASCADE ON DELETE CASCADE,
15	FOREIGN KEY(transporter_id) REFERENCES transporter(id)
16		ON UPDATE CASCADE ON DELETE CASCADE
17);
18
19CREATE TABLE donations(
20	id INT(11) NOT NULL UNIQUE AUTO_INCREMENT,
21	amount INT(100) NOT NULL,
22
23	PRIMARY KEY(id)
24);