drop table if exists sequence;
create table sequence (
    id integer not null
);
insert into sequence values (0);

drop table if exists class;
create table class (
	rec_id integer auto_increment  primary key,
	name char(32),
	title char(64),
	permissions char(10),
	owner integer,
	reference integer
);

drop table if exists property;
create table property (
	rec_id integer auto_increment primary key,
	name char(32),
	title char(32),
	store_type char(100),
	domain char(32),
	relation char(10),
	range char(32),
	foreign_id char(32)
);

drop table if exists User;
drop table if exists Organization;