$PASSWORD = "******";
$RECOVERYEMAIL = "*****@*****.**";
$USERNAME = "******";
$COMPANY = "Your Company Name";
$BRANCH = "Headquarters";
$gdbo->debug = true;
$gdbo->dbSchema = $DESTINATION;
$gdbo->sql = "SELECT TABLE_NAME FROM information_schema.tables WHERE TABLE_SCHEMA='{$DESTINATION}'";
$gdbo->getRec();
$adms = $gdbo->dbData;
$debug = 1;
printArray($gdbo->dbData);
foreach ($adms as $row => $data) {
echo "Deleting " . $data[0] . ".";
$gdbo->sql = "DELETE FROM " . $data[0];
$gdbo->execQuery();
echo "Resetting Index " . $data[0] . ".";
$gdbo->sql = "ALTER TABLE " . $data[0] . " AUTO_INCREMENT=1";
$gdbo->execQuery();
echo "Done.\n";
}
#create admin account
echo "Creating Administrator\n";
$gdbo->dbTable = "_cust_company";
$gdbo->sql = "(cust_company,id_cust_company_tp) values ('{$COMPANY}',1)";
$gdbo->insertRec();
$id_cust_company = $gdbo->insertedID;
$gdbo->dbTable = "_cust_branch";
$gdbo->sql = "(cust_branch,id_cust_branch_tp,id_cust_company) values ('{$BRANCH}',1,{$id_cust_company} )";
$gdbo->insertRec();
$id_cust_branch = $gdbo->insertedID;
