Product Documentation

FairCom SQL for PHP

Previous Topic

Next Topic

Define

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)");

}

TOCIndex