-- updated 040423 DDH

-- Paper: author->referenceauthor->reference

create table author (
	id integer auto_increment primary key,
	name varchar(255),
	-- Full_name
	fullname_colleagueid integer
) ENGINE=InnoDB;
create index name_index on author (name);
create index fullname_colleagueid_index on author (fullname_colleagueid);

create table authorimage (
	id integer auto_increment primary key,
	authorid integer,
	-- Image
	imageid integer
) ENGINE=InnoDB;
create index authorid_index on authorimage (authorid);
create index imageid_index on authorimage (imageid);