--BEGIN WORK;
drop sequence kaiin_id;
drop table kaiin_table;

create sequence kaiin_id start 1000;

create table kaiin_table(
	kaiin_id int,
	company text,
	name text,
	address text,
	tel text,
	email text,
	password text,
        constraint kaiin_table_pkey primary key(kaiin_id) 
);

grant all on kaiin_id to nobody;
grant all on kaiin_table to nobody;

--COMMIT;
