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



/*==============================================================*
	Table:	client
 *==============================================================*/

  CREATE TABLE "client"(
	"id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
	"address" TEXT,
	"name" TEXT

  );

/*==============================================================*
	Table:	order
 *==============================================================*/

  CREATE TABLE "order"(
	"id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
	"clientid" INTEGER NOT NULL,
	"date" INTEGER,
	"referrer_clientid" INTEGER,
	
	UNIQUE(id, clientid)

  );

 ---------------------------------------------------------------
 ------ Generated Indexes for (possibly) faster LEFT JOIN ------

  CREATE INDEX IF NOT EXISTS "order_client"
    ON  "order"(clientid);

  CREATE INDEX IF NOT EXISTS "client_order"
    ON  "client"(id);

  CREATE INDEX IF NOT EXISTS "order_client"
    ON  "order"(referrer_clientid);

  CREATE INDEX IF NOT EXISTS "client_order"
    ON  "client"(id);

 ---------------------------------------------------------------


/*==============================================================*
	Table:	orderline
 *==============================================================*/

  CREATE TABLE "orderline"(
	"id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
	"orderid" INTEGER NOT NULL,
	"clientid" INTEGER NOT NULL,
	"number" INTEGER,
	"product" TEXT,
	
	UNIQUE(id, orderid, clientid)

  );

 ---------------------------------------------------------------
 ------ Generated Indexes for (possibly) faster LEFT JOIN ------

  CREATE INDEX IF NOT EXISTS "orderline_order"
    ON  "orderline"(orderid, clientid);

  CREATE INDEX IF NOT EXISTS "order_orderline"
    ON  "order"(id, clientid);

 ---------------------------------------------------------------


/*==============================================================*
	Table:	myorderdelivery
 *==============================================================*/

  CREATE TABLE "myorderdelivery"
  (
	"address" TEXT NOT NULL,
	"lineid" INTEGER NOT NULL,
	"orderid" INTEGER NOT NULL,
	"clientid" INTEGER NOT NULL,
	"amount" INTEGER NOT NULL,
	
	PRIMARY KEY(address, lineid, orderid, clientid)
  );

 ---------------------------------------------------------------
 ------ Generated Indexes for (possibly) faster LEFT JOIN ------

  CREATE INDEX IF NOT EXISTS "myorderdelivery_orderline"
    ON  "myorderdelivery"(lineid, orderid, clientid);

  CREATE INDEX IF NOT EXISTS "orderline_myorderdelivery"
    ON  "orderline"(id, orderid, clientid);

 ---------------------------------------------------------------