|
|
|
Define() establishes specific data definitions. This involves defining columns/fields and creating the tables/files with optional indexes.
Below is the code for Define():
//
// Define()
//
// Create the tables
//
function Defines($ses) {
print("\t<h4>DEFINE</h4>\n");
Create_CustomerMaster_Table($ses);
Create_CustomerOrders_Table($ses);
Create_OrderItems_Table($ses);
Create_ItemMaster_Table($ses);
if (!ctsql_commit($ses))
Handle_Error("ctsql_commit()");
}
//
// Create_CustomerMaster_Table()
//
// Create the table CustomerMaster
//
function Create_CustomerMaster_Table ($ses) {
print("\t\ttable CustomerMaster<br>\n");
$qry = ctsql_query(
"CREATE TABLE custmast (
cm_custnumb CHAR(4),
cm_custzipc CHAR(9),
cm_custstat CHAR(2),
cm_custrtng CHAR(1),
cm_custname VARCHAR(47),
cm_custaddr VARCHAR(47),
cm_custcity VARCHAR(47))",
$ses);
if (!$qry)
Handle_Error("ctsql_query(CREATE TABLE)");
$qry = ctsql_query(
"CREATE UNIQUE INDEX cm_custnumb_idx ON custmast (cm_custnumb)",
$ses);
if (!$qry)
Handle_Error("ctsql_query(CREATE INDEX)");
}
//
// Create_CustomerOrders_Table()
//
// Create the table CustomerOrders
//
function Create_CustomerOrders_Table ($ses) {
print("\t\ttable CustomerOrders<br>\n");
$qry = ctsql_query(
"CREATE TABLE custordr (
co_ordrdate DATE,
co_promdate DATE,
co_ordrnumb CHAR(6),
co_custnumb CHAR(4))",
$ses);
if (!$qry)
Handle_Error("ctsql_query(CREATE TABLE)");
$qry = ctsql_query(
"CREATE UNIQUE INDEX co_ordrnumb_idx ON custordr (co_ordrnumb)",
$ses);
if (!$qry)
Handle_Error("ctsql_query(CREATE INDEX)");
$qry = ctsql_query(
"CREATE INDEX co_custnumb_idx ON custordr (co_custnumb)",
$ses);
if (!$qry)
Handle_Error("ctsql_query(CREATE INDEX)");
}
//
// Create_OrderItems_Table()
//
// Create the table OrderItems
//
function Create_OrderItems_Table ($ses) {
print("\t\ttable OrderItems<br>\n");
$qry = ctsql_query(
"CREATE TABLE ordritem (
oi_sequnumb SMALLINT,
oi_quantity SMALLINT,
oi_ordrnumb CHAR(6),
oi_itemnumb CHAR(5))",
$ses);
if (!$qry)
Handle_Error("ctsql_query(CREATE TABLE)");
$qry = ctsql_query(
"CREATE UNIQUE INDEX oi_ordrnumb_idx ON ordritem (oi_ordrnumb, oi_sequnumb)",
$ses);
if (!$qry)
Handle_Error("ctsql_query(CREATE INDEX)");
$qry = ctsql_query(
"CREATE INDEX oi_itemnumb_idx ON ordritem (oi_itemnumb)",
$ses);
if (!$qry)
Handle_Error("ctsql_query(CREATE INDEX)");
}
//
// Create_ItemMaster_Table()
//
// Create the table ItemMaster
//
function Create_ItemMaster_Table ($ses) {
print("\t\ttable ItemMaster<br>\n");
$qry = ctsql_query(
"CREATE TABLE itemmast (
im_itemwght INTEGER,
im_itempric MONEY,
im_itemnumb CHAR(5),
im_itemdesc VARCHAR(47))",
$ses);
if (!$qry)
Handle_Error("ctsql_query(CREATE TABLE)");
$qry = ctsql_query(
"CREATE UNIQUE INDEX im_itemnumb_idx ON itemmast (im_itemnumb)",
$ses);
if (!$qry)
Handle_Error("ctsql_query(CREATE INDEX)");
}
