// 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"); if ($manageObj->modifyLibrary(PATH_CORE . '/classes/', 'content.class.php')) {