##################################################
# An SQL File to create a simple sample menu
# structure for an imint applet demonstration
#
# copyright KM Newnham 2001
##################################################

DROP TABLE IF EXISTS imint_menus;

CREATE TABLE imint_menus  (
    parent tinyint default '0' not null,
    imint_index  tinyint default 0 not null,
    description char(100),
    url char(100),
    mouseover char(100),
    primary key (parent,imint_index)
);
	
insert into imint_menus (parent,imint_index,description,url,mouseover) values (0,1,"Menu item 1","","Start Here");
insert into imint_menus (parent,imint_index,description,url,mouseover) values (0,2,"IBM","http://www.ibm.com","Big Blue");
insert into imint_menus (parent,imint_index,description,url,mouseover) values (1,3,"Sub Menu item 1","","A sub menu");
insert into imint_menus (parent,imint_index,description,url,mouseover) values (1,4,"Sub Menu item 2","","Another sub menu");
insert into imint_menus (parent,imint_index,description,url,mouseover) values (3,5,"HP","http://www.hp.com","HP");
insert into imint_menus (parent,imint_index,description,url,mouseover) values (3,6,"Microsoft","http://www.microsoft.com","Microsoft");
insert into imint_menus (parent,imint_index,description,url,mouseover) values (4,7,"Dell","http://www.dell.com","Dell Computers");
insert into imint_menus (parent,imint_index,description,url,mouseover) values (4,8,"Sun","http://www.sun.com","Sun Systems");