This is a classic Order Header -> Order Detail structure.
$
SQL = "CREATE TABLE $headertable (
$headercolumn [order_id] int(10) NOT NULL auto_increment,
$headercolumn [order_no] varchar(8) NOT NULL default '',
$headercolumn [rep_code] int(5) NOT NULL default 0,
$headercolumn [cus_no] int(12) NOT NULL default 0,
$headercolumn [po_no] int(25) NOT NULL default 0,
$headercolumn [ord_dt] date NOT NULL default '0000-00-00',
$headercolumn [billing_dt] date NOT NULL default '0000-00-00',
$headercolumn [shipping_dt] date NOT NULL default '0000-00-00',
$headercolumn [ship_via] varchar(5) NOT NULL default '',
$headercolumn [tracking_no] varchar(50) NOT NULL default '',
$headercolumn [status] varchar(5) NOT NULL default '',
PRIMARY KEY(order_id))";
$dbconn->Execute($
SQL);
$
SQL = "CREATE TABLE $detailtable (
$detailcolumn [order_id] int(10) NOT NULL default '0',
$detailcolumn [line_no] smallint(6) NOT NULL default '0',
$detailcolumn [item_no] varchar(15) NOT NULL default '',
$detailcolumn [item_desc_1] varchar(30) NOT NULL default '',
$detailcolumn [qty_ordered] decimal(10,0) NOT NULL default '0',
$detailcolumn [unit_price] decimal(10,2) NOT NULL default '0.00'
)";
$dbconn->Execute($
SQL);