create table lights (
    lightID varchar(32) primary key,
    manufacturerID varchar(32) not null references manufacturers(manufacturerID),
    model varchar(128) not null,
    lumens int,
    watts  int,
    volts int,
    amps int,
    type varchar(32) not null, 
    config varchar(256),
    details varchar(256),
    minWidth int not null,
    maxWidth int not null,
    image varchar(128),
    link varchar(256)
);
