// set up system status table
// to do - move this to a dbrowobject model - and replace in facebook initdb too
$manageObj->addTable("SystemStatus", "id", "INT(4) unsigned NOT NULL auto_increment", "MyISAM");
$manageObj->addColumn("SystemStatus", "name", "VARCHAR(35) default ''");
$manageObj->addColumn("SystemStatus", "strValue", "TEXT default ''");
$manageObj->addColumn("SystemStatus", "numValue", "BIGINT(20) default 0");
//////////////////////////////////////////////////////////////////////////////////////////
// news-specific tables
if ($manageObj->modifyLibrary(PATH_CORE . '/classes/', 'dynamicTemplate.class.php')) {
require_once PATH_CORE . '/classes/dynamicTemplate.class.php';
TemplateTable::createTable($manageObj);
}
if ($manageObj->modifyLibrary(PATH_CORE . '/classes/', 'user.class.php')) {
// Create the User table
require_once PATH_CORE . '/classes/user.class.php';
UserTable::createTable($manageObj);
UserInfoTable::createTable($manageObj);
$userInfoTable = new UserInfoTable($manageObj->db);
UserInviteTable::createTable($manageObj);
}
// set up newswire table
$manageObj->addTable("Newswire", "id", "INT(11) unsigned NOT NULL auto_increment", "MyISAM");
$manageObj->addColumn("Newswire", "title", "VARCHAR(255) default ''");
$manageObj->addColumn("Newswire", "caption", "TEXT default ''");
$manageObj->addColumn("Newswire", "source", "VARCHAR (150) default ''");
$manageObj->addColumn("Newswire", "url", "VARCHAR(255) default ''");
$manageObj->addColumn("Newswire", "date", "DATETIME");
// to do - deprecate
$manageObj->addColumn("Newswire", "wireid", "INT(11) default 0");
// deprecated
$manageObj->addColumn("Newswire", "feedid", "INT(11) default 0");