-- updated 040423 DDH

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

create table helpremark (
	id integer auto_increment primary key,
	helpid integer,
	-- Intro, Overview, Note, Tip
	type varchar(50),
	remark text
) ENGINE=InnoDB;
create index helpid_index on helpremark (helpid);

create table helpmore (
	id integer auto_increment primary key,
	helpid integer,
	-- More
	preformattextid integer
) ENGINE=InnoDB;
create index helpid_index on helpmore (helpid);
create index preformattextid_index on helpmore (preformattextid);