/*--------------------------------------------------------------*
 |            haxeQL Generated: 2007-06-21 04:29:02             |
 *--------------------------------------------------------------*/



/*==============================================================*
	Table:	client
 *==============================================================*/
  CREATE TABLE `client`
  (
	`id` INT(10) SIGNED NOT NULL AUTO_INCREMENT,
	`address` VARCHAR(200),
	`name` VARCHAR(255),
	
	PRIMARY KEY(id)
  ) ENGINE=InnoDB;


/*==============================================================*
	Table:	order
 *==============================================================*/
  CREATE TABLE `order`
  (
	`id` INT(10) SIGNED NOT NULL AUTO_INCREMENT,
	`clientid` INT(10) SIGNED NOT NULL,
	`date` DATETIME,
	`referrer_clientid` INT(10) SIGNED,
	
	FOREIGN KEY   (clientid)
	  REFERENCES  `client`(id)
	  ON UPDATE CASCADE  ON DELETE CASCADE,
	
	FOREIGN KEY   (referrer_clientid)
	  REFERENCES  `client`(id)
	  ON UPDATE CASCADE  ON DELETE CASCADE,
	
	PRIMARY KEY(id, clientid)
  ) ENGINE=InnoDB;


/*==============================================================*
	Table:	orderline
 *==============================================================*/
  CREATE TABLE `orderline`
  (
	`id` INT(10) SIGNED NOT NULL AUTO_INCREMENT,
	`orderid` INT(10) SIGNED NOT NULL,
	`clientid` INT(10) SIGNED NOT NULL,
	`number` MEDIUMINT(7) SIGNED,
	`product` VARCHAR(255),
	
	FOREIGN KEY   (orderid, clientid)
	  REFERENCES  `order`(id, clientid)
	  ON UPDATE CASCADE  ON DELETE CASCADE,
	
	PRIMARY KEY(id, orderid, clientid)
  ) ENGINE=InnoDB;


/*==============================================================*
	Table:	myorderdelivery
 *==============================================================*/
  CREATE TABLE `myorderdelivery`
  (
	`address` VARCHAR(255) NOT NULL,
	`lineid` INT(10) SIGNED NOT NULL,
	`orderid` INT(10) SIGNED NOT NULL,
	`clientid` INT(10) SIGNED NOT NULL,
	`amount` MEDIUMINT(7) SIGNED NOT NULL,
	
	FOREIGN KEY   (lineid, orderid, clientid)
	  REFERENCES  `orderline`(id, orderid, clientid)
	  ON UPDATE RESTRICT  ON DELETE RESTRICT,
	
	PRIMARY KEY(address, lineid, orderid, clientid)
  ) ENGINE=InnoDB;