create table myuser(
 name varchar(48) default '' not null,
 email varchar(48) default '' not null,
 password varchar(32) default '' not null,
 department varchar(48) default '' not null,
 primary key(email));

create table myworkstation(
 tracking_no int(6) default '0' not null,
 model varchar(15),
 qty int(3),
 primary key(tracking_no));

create table mylaptop(
 tracking_no int(6) default '0' not null,
 model varchar(8),
 qty int(3),
 primary key(tracking_no));
 
create table myequipment(
 tracking_no int(6) default '0' not null,
 hdd_model varchar(9),
 hdd_qty int(3),
 fdd_model varchar(9),
 fdd_qty int(3),
 ram_model varchar(9),
 ram_qty int(3),
 nic_model varchar(9),
 nic_qty int(3),
 mouse_model varchar(9),
 mouse_qty int(3),
 keyboard_model varchar(9),
 keyboard_qty int(3),
 videocard_model varchar(9),
 videocard_qty int(3),
 soundcard_model varchar(9),
 soundcard_qty int(3),
 cdrom_model varchar(9),
 cdrom_qty int(3),
 cdrw_model varchar(9),
 cdrw_qty int(3),
 dvd_model varchar(9),
 dvd_qty int(3),
 zip_model varchar(9),
 zip_qty int(3),
 speaker_model varchar(9),
 speaker_qty int(3),
 os_model varchar(9),
 os_qty int(3),
 monitor_model varchar(9),
 monitor_qty int(3),
 primary key(tracking_no));

create table myorder(
 email varchar(48) default '' not null,
 tracking_no int(6) default '0' not null,
 status varchar(32),
 order_date date,
 price float(10, 2),
 primary key(email, tracking_no));

create table myequipt(
 tracking_no int(6) default '0' not null,
 primary key(tracking_no));