
insert into products set kind='servers', description='LP-2220-2H, 2 x 500GB drives, 16GB memory', customer_num='5';

insert into servers set product='1', serial='11400027', case_man='Supermicro', case_serial='C510T0A45M00012', model='LP-2220-2H', description='LP-2220-2H, 2 x 500GB drives, 16GB memory', updated=CURRENT_TIMESTAMP;


update products set link='1' where prod_id='1';

insert into motherboards set product='1', man='Supermicro', mobo_serial='555M401191G14400390J001', model='X9SCL-F', description='uATX motherboard for Intel Xeon E3 processors', updated=CURRENT_TIMESTAMP;


insert into processors set product='1', proc_man='Intel', proc_serial='C042B265', proc_model='E3-1220L', ncores='2', clock='2200', description='Intel Xeon E3-1220L', updated=CURRENT_TIMESTAMP;

insert into ethernet_nics set product='1', eth_man='Intel', eth_mac='00:25:90:57:d2:a9', speed='100', onboard='true', `use`='ipmi', updated=CURRENT_TIMESTAMP;
insert into ethernet_nics set product='1', eth_man='Intel', eth_mac='00:25:90:57:d4:e0', speed='1000', onboard='true', updated=CURRENT_TIMESTAMP;
insert into ethernet_nics set product='1', eth_man='Intel', eth_mac='00:25:90:57:d4:e1', speed='1000', onboard='true', updated=CURRENT_TIMESTAMP;


insert into disks set product='1', disk_man='Western Digital', disk_model='WD5000BPVT-00HHX2T3', disk_serial='WX21CC1P2152', wwn='50014ee6acc49d5f', updated=CURRENT_TIMESTAMP;
insert into disks set product='1', disk_man='Western Digital', disk_model='WD5000BPVT-00HHX2T3', disk_serial='WXV1CB1F2674', wwn='50014ee6acc4729e', updated=CURRENT_TIMESTAMP;

