$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;