drop table supportuser;
drop table supportusers;

create table supportusers (
	userid varchar(80) not null,
	passwd varchar(80) not null,
	email varchar(80) not null,
	firstname varchar(80) not null,
	lastname varchar(80) not null,
	phone varchar(80) not null,
	constraint pk_supportuser primary key (userid));

grant all on supportusers to public;

insert into supportusers values ('psaurugger', 'ps', =
'psaurugger@lboard.com', 'Peter', 'Saurugger', '408-571-3378');
insert into supportusers values ('customer1ntt', 'nihauntt', =
'customer1ntt@hotmail.com', 'Shimi', 'Otake', '408-571-3378');

drop table supportuser_groups;

create table supportuser_groups (
	usergroup varchar(80) not null,
	userid varchar(80) not null);

insert into supportuser_groups values ('CustomersUserGroup', =
'customer1ntt');
insert into supportuser_groups values ('CustomersUserGroup', =
'psaurugger');
