create table users (
	userid bigint not null auto_increment,
	name varchar(256) not null,
	groupids text,
	primary key( userid )
);

create table groups (
	groupid bigint(64) not null auto_increment,
	name varchar(256) not null,
	userids text,
	primary key( groupid )
);

create table datas (
	id bigint(64) not null auto_increment,
	type enum('D','F') not null default 'F',
	name varchar(512) not null,
	path varchar(2048) not null,
	size bigint(64) default 0,
	parent_id bigint(64),
	md5 varchar(32),
	owner_uid bigint(64) not null,
	owner_gid bigint(64) not null,
	mtime bigint(64),
	usage_count bigint(64),
	referred enum('Y','N') default 'N',
	referer_id bigint(64),
	path_on_disk varchar(2048),
	primary key(id)
);