-- updated 040423 DDH

-- Paper: journal->reference

create table journal (
	id integer auto_increment primary key,
	name text
) ENGINE=InnoDB;
create index name_index on journal (name(255));

create table journalremark (
        id integer auto_increment primary key,
	journalid integer,
	-- Other_name, Source_code, ISSN_number, URL, Remark
	type varchar(50),
	remark text
) ENGINE=InnoDB;
create index journalid_index on journalremark (journalid);