USE trip;

DROP TABLE IF EXISTS `travellers`;
CREATE TABLE `travellers` (
  `label` varchar(45) NOT NULL default '',
  `idtraveller` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`idtraveller`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `travellers` (`label`, `idtraveller`) VALUES("john", "1");
INSERT INTO `travellers` (`label`, `idtraveller`) VALUES("paul", "2");

DROP TABLE IF EXISTS `trips`;
CREATE TABLE `trips` (
  `tdyrefnum` int(10) unsigned NOT NULL default '0',
  `label` varchar(45) NOT NULL default '',
  `idtraveller` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`tdyrefnum`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `trips` (`tdyrefnum`, `label`, `idtraveller`) VALUES("1", "tdy one", "2");
INSERT INTO `trips` (`tdyrefnum`, `label`, `idtraveller`) VALUES("2", "tdy two", "1");
INSERT INTO `trips` (`tdyrefnum`, `label`, `idtraveller`) VALUES("3", "tdy three", "1");

DROP TABLE IF EXISTS `tripsrequesters`;
CREATE TABLE `tripsrequesters` (
  `tdyrefnum` int(10) unsigned NOT NULL default '0',
  `label` varchar(45) NOT NULL default '',
  PRIMARY KEY  (`tdyrefnum`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `tripsrequesters` (`tdyrefnum`, `label`) VALUES("1", "rq1");
INSERT INTO `tripsrequesters` (`tdyrefnum`, `label`) VALUES("2", "rq2");
INSERT INTO `tripsrequesters` (`tdyrefnum`, `label`) VALUES("3", "rq3");

DROP TABLE IF EXISTS `tripstravellers`;
CREATE TABLE `tripstravellers` (
  `tdyrefnum` int(10) unsigned NOT NULL default '0',
  `label` varchar(45) NOT NULL default '',
  PRIMARY KEY  (`tdyrefnum`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `tripstravellers` (`tdyrefnum`, `label`) VALUES("1", "travel1");
INSERT INTO `tripstravellers` (`tdyrefnum`, `label`) VALUES("2", "travel2");
INSERT INTO `tripstravellers` (`tdyrefnum`, `label`) VALUES("3", "travel3");