----- DROP TABLE	-----
drop table sch_table;
drop sequence sch_sequence;

----- CREATE SEQUENCE	-----
create sequence sch_sequence;

----- CREATE TABLE	-----
create table sch_table(
	user_id		int,
--	groupmei	int,
	ymd1		timestamp,
	ymd2		timestamp,
	sch_ser		int,
	basho		text,
	subject		text,
	comment		text
--	constraint sch_pkey primary key(sch_ser)
);

----- GRANT TABLE	-----
grant all on sch_table to public;
grant all on sch_sequence to public;
