/** * Define module tables * @author Albert Pérez Monfort (intraweb@xtec.cat) * @return module tables information */ function IWwebbox_tables() { // Initialise table array $table = array(); // IWwebbox table definition $table['IWwebbox'] = DBUtil::getLimitedTablename('IWwebbox'); $table['IWwebbox_column'] = array('pid' => 'iw_pid', 'url' => 'iw_url', 'ref' => 'iw_ref', 'scrolls' => 'iw_scrolls', 'description' => 'iw_description', 'width' => 'iw_width', 'height' => 'iw_height', 'widthunit' => 'iw_widthunit'); $table['IWwebbox_column_def'] = array('pid' => "I NOTNULL AUTO PRIMARY", 'url' => "C(255) NOTNULL DEFAULT ''", 'ref' => "C(10) NOTNULL DEFAULT ''", 'scrolls' => "I(1) NOTNULL DEFAULT '1'", 'description' => "C(255) NOTNULL DEFAULT ''", 'width' => "I NOTNULL DEFAULT '100'", 'height' => "I NOTNULL DEFAULT '600'", 'widthunit' => "C(10) NOTNULL DEFAULT '%'"); ObjectUtil::addStandardFieldsToTableDefinition($table['IWwebbox_column'], 'pn_'); ObjectUtil::addStandardFieldsToTableDataDefinition($table['IWwebbox_column_def'], 'iw_'); // Return the table information return $table; }
/** * Define module tables * @author Albert Perez Monfort (aperezm@xtec.cat) * @return module tables information */ function IWmenu_tables() { // Initialise table array $tables = array(); // IWmain table definition $tables['IWmenu'] = DBUtil::getLimitedTablename('IWmenu'); //Noms dels camps $tables['IWmenu_column'] = array('mid' => 'iw_mid', 'text' => 'iw_text', 'url' => 'iw_url', 'id_parent' => 'iw_id_parent', 'groups' => 'iw_groups', 'active' => 'iw_active', 'target' => 'iw_target', 'descriu' => 'iw_descriu', 'iorder' => 'iw_iorder', 'icon' => 'iw_icon',); $tables['IWmenu_column_def'] = array('mid' => "I NOTNULL AUTO PRIMARY", 'text' => "C(255) NOTNULL DEFAULT ''", 'url' => "X NOTNULL", 'id_parent' => "I NOTNULL DEFAULT '0'", 'groups' => "X NOTNULL", 'active' => "I(1) NOTNULL DEFAULT '0'", 'target' => "I(1) NOTNULL DEFAULT '0'", 'descriu' => "X NOTNULL", 'iorder' => "I NOTNULL DEFAULT '0'", 'icon' => "C(40) NOTNULL DEFAULT ''"); // Return the table information return $tables; }
/** * upgrade the module from an old version * * This function must consider all the released versions of the module! * If the upgrade fails at some point, it returns the last upgraded version. * * @param string $oldVersion version number string to upgrade from * @return mixed true on success, last valid version string or false if fails */ public function upgrade($oldversion) { // Upgrade dependent on old version number switch ($oldversion) { case '3.6': // Rename 'thelang' block. $table = 'blocks'; $sql = "UPDATE {$table} SET bkey = 'lang' WHERE bkey = 'thelang'"; \DBUtil::executeSQL($sql); // Optional upgrade if (in_array(\DBUtil::getLimitedTablename('message'), \DBUtil::metaTables())) { $this->migrateMessages(); } $this->migrateBlockNames(); $this->migrateExtMenu(); case '3.7': case '3.7.0': if (!\DBUtil::changeTable('blocks')) { return false; } case '3.7.1': $this->newBlockPositions(); case '3.8.0': // update empty filter fields to an empty array $entity = $this->name . '\\Entity\\Block'; $dql = "UPDATE {$entity} p SET p.filter = 'a:0:{}' WHERE p.filter = '' OR p.filter = 's:0:\"\";'"; $query = $this->entityManager->createQuery($dql); $query->getResult(); case '3.8.1': // future upgrade routines } // Update successful return true; }
/** * Zikula Application Framework * * @license GNU/GPL - http://www.gnu.org/copyleft/gpl.html * @author Joan Guillén i Pelegay (jguille2@xtec.cat) * * @category Sirius Modules */ function SiriusXtecAuth_tables() { // Inclusió de la definició de la taula IWusers $tables['IWusers'] = DBUtil::getLimitedTablename('IWusers'); $tables['IWusers_column'] = array( 'suid' => 'iw_suid', 'uid' => 'iw_uid', 'id' => 'iw_id', 'nom' => 'iw_nom', 'cognom1' => 'iw_cognom1', 'cognom2' => 'iw_cognom2', 'naixement' => 'iw_naixement', 'accio' => 'iw_accio', 'sex' => 'iw_sex', 'description' => 'iw_description', 'avatar' => 'iw_avatar', 'newavatar' => 'iw_newavatar', ); $tables['IWusers_column_def'] = array('suid' => "I NOTNULL AUTO PRIMARY", 'uid' => "I NOTNULL DEFAULT '0'", 'id' => "C(50) NOTNULL DEFAULT ''", 'nom' => "C(25) NOTNULL DEFAULT ''", 'cognom1' => "C(25) NOTNULL DEFAULT ''", 'cognom2' => "C(25) NOTNULL DEFAULT ''", 'naixement' => "C(8) NOTNULL DEFAULT ''", 'accio' => "I(1) NOTNULL DEFAULT '0'", 'sex' => "C(1) NOTNULL DEFAULT ''", 'description' => "X NOTNULL", 'avatar' => "C(50) NOTNULL DEFAULT ''", 'newavatar' => "C(50) NOTNULL DEFAULT ''", ); //Returns informació de les taules return $tables; }
/** * Reviews table information */ function Reviews_tables() { // Initialise table array $tables = array(); // legacy Reviews comments table $tables['reviews_comments'] = DBUtil::getLimitedTablename('reviews_comments'); $tables['reviews_comments_column'] = array('cid' => 'pn_cid', 'rid' => 'pn_rid', 'userid' => 'pn_userid', 'date' => 'pn_date', 'comments' => 'pn_comments', 'score' => 'pn_score'); $tables['reviews_comments_column_def'] = array('cid' => 'I(11) NOTNULL AUTOINCREMENT PRIMARY', 'rid' => "I(11) NOTNULL DEFAULT '0'", 'userid' => 'C(25) NOTNULL', 'date' => 'T DEFAULT NULL', 'comments' => 'X DEFAULT NULL', 'score' => "I(11) NOTNULL DEFAULT '0'"); return $tables; }
/** * This function is called internally by the core whenever the module is * loaded. It adds in the information */ function Admin_Messages_tables() { // Initialise table array $pntable = array(); // Get the name for the table. $message = DBUtil::getLimitedTablename('message'); $pntable['message'] = $message; $pntable['message_column'] = array('mid' => 'pn_mid', 'title' => 'pn_title', 'content' => 'pn_content', 'date' => 'pn_date', 'expire' => 'pn_expire', 'active' => 'pn_active', 'view' => 'pn_view', 'language' => 'pn_language'); $pntable['message_column_def'] = array('mid' => 'I PRIMARY AUTO', 'title' => "C(100) NOTNULL DEFAULT ''", 'content' => "XL NOTNULL", 'date' => "I NOTNULL DEFAULT 0", 'expire' => "I NOTNULL DEFAULT 0", 'active' => "I NOTNULL DEFAULT 1", 'view' => "I NOTNULL DEFAULT 1", 'language' => "C(30) NOTNULL DEFAULT ''"); // Return the table information return $pntable; }
/** * Upgrade the dynamic user data module from an old version. * * @param string $oldversion The version from which the upgrade is beginning (the currently installed version); this should be compatible * with {@link version_compare()}. * * @return boolean True on success or false on failure. */ public function upgrade($oldversion) { switch ($oldversion) { case '1.5.2': // 1.5.2 -> 1.6.0 EventUtil::registerPersistentEventHandlerClass($this->name, 'Profile_Listener_UsersUiHandler'); $connection = Doctrine_Manager::getInstance()->getConnection('default'); $sqlStatements = array(); // N.B. statements generated with PHPMyAdmin $sqlStatements[] = 'RENAME TABLE ' . DBUtil::getLimitedTablename('user_property') . " TO user_property"; $sqlStatements[] = "ALTER TABLE `user_property` CHANGE `pn_prop_id` `id` INT( 11 ) NOT NULL AUTO_INCREMENT , CHANGE `pn_prop_label` `label` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL , CHANGE `pn_prop_dtype` `dtype` INT( 11 ) NOT NULL DEFAULT '0', CHANGE `pn_prop_modname` `modname` VARCHAR( 64 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL , CHANGE `pn_prop_weight` `weight` INT( 11 ) NOT NULL DEFAULT '0', CHANGE `pn_prop_validation` `validation` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , CHANGE `pn_prop_attribute_name` `attributename` VARCHAR( 80 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL"; foreach ($sqlStatements as $sql) { $stmt = $connection->prepare($sql); try { $stmt->execute(); } catch (Exception $e) { } } case '1.6.0': case '1.6.1': // 1.6.0 -> X.X.X when appropriate. } $modVars = $this->getVars(); $defaultModVars = $this->getDefaultModVars(); // Remove modvars no longer in the default set. foreach ($modVars as $modVar => $value) { if (!array_key_exists($modVar, $defaultModVars)) { $this->delVar($modVar); } } // Add vars defined in the default set, but missing from the current set. foreach ($defaultModVars as $modVar => $value) { if (!array_key_exists($modVar, $modVars)) { $this->setVar($modVar, $value); } } // Update successful return true; }
/** * pages table information */ function Pages_tables() { // Initialise table array $table = array(); // Full table definition $table['pages'] = 'pages'; $table['pages_column'] = array ('pageid' => 'pageid', 'title' => 'title', 'metadescription' => 'metadescription', 'metakeywords' => 'metakeywords', 'urltitle' => 'urltitle', 'content' => 'content', 'counter' => 'counter', 'displaywrapper' => 'displaywrapper', 'displaytitle' => 'displaytitle', 'displaycreated' => 'displaycreated', 'displayupdated' => 'displayupdated', 'displaytextinfo' => 'displaytextinfo', 'displayprint' => 'displayprint', 'language' => 'language'); $table['pages_column_def'] = array('pageid' => 'I AUTOINCREMENT PRIMARY', 'title' => "X NOTNULL DEFAULT ''", 'metadescription' => "X NOTNULL DEFAULT ''", 'metakeywords' => "X NOTNULL DEFAULT ''", 'urltitle' => "X NOTNULL DEFAULT ''", 'content' => "X NOTNULL DEFAULT ''", 'counter' => "I NOTNULL DEFAULT '0'", 'displaywrapper' => "I1 NOTNULL DEFAULT '1'", 'displaytitle' => "I1 NOTNULL DEFAULT '1'", 'displaycreated' => "I1 NOTNULL DEFAULT '1'", 'displayupdated' => "I1 NOTNULL DEFAULT '1'", 'displaytextinfo' => "I1 NOTNULL DEFAULT '1'", 'displayprint' => "I1 NOTNULL DEFAULT '1'", 'language' => "C(30) NOTNULL DEFAULT ''"); // Enable categorization services $table['pages_db_extra_enable_categorization'] = ModUtil::getVar('Pages', 'enablecategorization'); $table['pages_primary_key_column'] = 'pageid'; // add standard data fields ObjectUtil::addStandardFieldsToTableDefinition($table['pages_column']); ObjectUtil::addStandardFieldsToTableDataDefinition($table['pages_column_def']); // old tables for upgrade/renaming purposes $table['seccont'] = DBUtil::getLimitedTablename('seccont'); $table['sections'] = DBUtil::getLimitedTablename('sections'); return $table; }
function IWusers_tables() { // Initialise table array $tables = array(); // IWusers table definition $tables['IWusers'] = DBUtil::getLimitedTablename('IWusers'); $tables['IWusers_column'] = array( 'suid' => 'iw_suid', 'uid' => 'iw_uid', 'id' => 'iw_id', 'nom' => 'iw_nom', 'cognom1' => 'iw_cognom1', 'cognom2' => 'iw_cognom2', 'naixement' => 'iw_naixement', 'code' => 'iw_code', 'sex' => 'iw_sex', 'accio' => 'iw_accio', 'description' => 'iw_description', 'avatar' => 'iw_avatar', 'newavatar' => 'iw_newavatar', ); $tables['IWusers_column_def'] = array( 'suid' => "I NOTNULL AUTO PRIMARY", 'uid' => "I NOTNULL DEFAULT '0'", 'id' => "C(50) NOTNULL DEFAULT ''", 'nom' => "C(25) NOTNULL DEFAULT ''", 'cognom1' => "C(25) NOTNULL DEFAULT ''", 'cognom2' => "C(25) NOTNULL DEFAULT ''", 'naixement' => "C(8) NOTNULL DEFAULT ''", 'accio' => "I(1) NOTNULL DEFAULT '0'", 'code' => "C(5)", 'sex' => "C(1) NOTNULL DEFAULT ''", 'description' => "X NOTNULL", 'avatar' => "C(50) NOTNULL DEFAULT ''", 'newavatar' => "C(50) NOTNULL DEFAULT ''", ); // IWusers table definition $tables['IWusers_friends'] = DBUtil::getLimitedTablename('IWusers_friends'); $tables['IWusers_friends_column'] = array('fid' => 'iw_fid', 'uid' => 'iw_uid', 'fuid' => 'iw_fuid'); $tables['IWusers_friends_column_def'] = array('fid' => "I NOTNULL AUTO PRIMARY", 'uid' => "I NOTNULL DEFAULT '0'", 'fuid' => "I NOTNULL DEFAULT '0'"); // Return the table information return $tables; }
/** * This function is called internally by the core whenever the module is * loaded. It adds in information about the tables that the module uses. */ function mediashare_pntables() { $pntable = array(); // Album and media setup $pntable['mediashare_albums'] = DBUtil::getLimitedTablename('mediashare_albums'); $pntable['mediashare_albums_column'] = array('id' => 'ms_id', 'ownerId' => 'ms_ownerid', 'createdDate' => 'ms_createddate', 'modifiedDate' => 'ms_modifieddate', 'title' => 'ms_title', 'keywords' => 'ms_keywords', 'summary' => 'ms_summary', 'description' => 'ms_description', 'template' => 'ms_template', 'parentAlbumId' => 'ms_parentAlbumId', 'access' => 'ms_accesslevel', 'viewKey' => 'ms_viewkey', 'mainMediaId' => 'ms_mainmediaid', 'thumbnailSize' => 'ms_thumbnailsize', 'nestedSetLeft' => 'ms_nestedsetleft', 'nestedSetRight' => 'ms_nestedsetright', 'nestedSetLevel' => 'ms_nestedsetlevel', 'extappURL' => 'ms_extappURL', 'extappData' => 'ms_extappData'); $pntable['mediashare_albums_column_def'] = array('id' => 'I NOTNULL AUTO PRIMARY', 'ownerId' => 'I NOTNULL', 'createdDate' => 'T NOTNULL', 'modifiedDate' => 'T NOTNULL DEFTIMESTAMP', 'title' => "C(255) NOTNULL DEFAULT ''", 'keywords' => "C(255) NOTNULL DEFAULT ''", 'summary' => "X NOTNULL DEFAULT ''", 'description' => "X NOTNULL DEFAULT ''", 'template' => "C(255) NOTNULL DEFAULT 'msslideshow'", 'parentAlbumId' => 'I', 'access' => 'I1 NOTNULL DEFAULT 0', 'viewKey' => 'C(32) NOTNULL', 'mainMediaId' => 'I NOTNULL DEFAULT 0', 'thumbnailSize' => 'I NOTNULL', 'nestedSetLeft' => 'I NOTNULL DEFAULT 0', 'nestedSetRight' => 'I NOTNULL DEFAULT 0', 'nestedSetLevel' => 'I NOTNULL DEFAULT 0', 'extappURL' => 'C(255)', 'extappData' => 'C(512)'); // Media information $pntable['mediashare_media'] = DBUtil::getLimitedTablename('mediashare_media'); $pntable['mediashare_media_column'] = array('id' => 'ms_id', 'ownerId' => 'ms_ownerid', 'createdDate' => 'ms_createddate', 'modifiedDate' => 'ms_modifieddate', 'title' => 'ms_title', 'keywords' => 'ms_keywords', 'description' => 'ms_description', 'parentAlbumId' => 'ms_parentalbumid', 'position' => 'ms_position', 'mediaHandler' => 'ms_mediahandler', 'thumbnailId' => 'ms_thumbnailid', 'previewId' => 'ms_previewid', 'originalId' => 'ms_originalid'); $pntable['mediashare_media_column_def'] = array('id' => 'I NOTNULL AUTO PRIMARY', 'ownerId' => 'I NOTNULL', 'createdDate' => 'T NOTNULL', 'modifiedDate' => 'T NOTNULL DEFTIMESTAMP', 'title' => "C(255) NOTNULL DEFAULT ''", 'keywords' => "C(255) NOTNULL DEFAULT ''", 'description' => "X NOTNULL DEFAULT ''", 'parentAlbumId' => 'I NOTNULL', 'position' => 'I NOTNULL', 'mediaHandler' => 'C(50) NOTNULL', 'thumbnailId' => 'I NOTNULL', 'previewId' => 'I NOTNULL', 'originalId' => 'I NOTNULL'); // Keyword handling $pntable['mediashare_keywords'] = DBUtil::getLimitedTablename('mediashare_keywords'); $pntable['mediashare_keywords_column'] = array('itemId' => 'ms_itemid', 'type' => 'ms_type', 'keyword' => 'ms_keyword'); $pntable['mediashare_keywords_column_def'] = array('itemId' => 'I NOTNULL', 'type' => 'C(5) NOTNULL', 'keyword' => 'C(50) NOTNULL'); $pntable['mediashare_keywords_column_idx'] = array('keywordIdx' => array('keyword')); // Media storage (image information) $pntable['mediashare_mediastore'] = DBUtil::getLimitedTablename('mediashare_mediastore'); $pntable['mediashare_mediastore_column'] = array('id' => 'mss_id', 'fileRef' => 'mss_fileref', 'mimeType' => 'mss_mimetype', 'width' => 'mss_width', 'height' => 'mss_height', 'bytes' => 'mss_bytes'); $pntable['mediashare_mediastore_column_def'] = array('id' => 'I NOTNULL AUTO PRIMARY', 'fileRef' => 'C(300) NOTNULL', 'mimeType' => 'C(100) NOTNULL', 'width' => 'I2 NOTNULL', 'height' => 'I2 NOTNULL', 'bytes' => 'I NOTNULL'); // Media DB storage (image data for storing images in DB) $pntable['mediashare_mediadb'] = DBUtil::getLimitedTablename('mediashare_mediadb'); $pntable['mediashare_mediadb_column'] = array('id' => 'mdb_id', 'fileref' => 'mdb_ref', 'mode' => 'mdb_mode', 'type' => 'mdb_type', 'bytes' => 'mdb_bytes', 'data' => 'mdb_data'); $pntable['mediashare_mediadb_column_def'] = array('id' => 'I NOTNULL AUTO PRIMARY', 'fileref' => 'C(50) NOTNULL', 'mode' => 'C(20) NOTNULL', 'type' => 'C(10) NOTNULL', 'bytes' => 'I NOTNULL', 'data' => 'B NOTNULL'); // Media handlers $pntable['mediashare_mediahandlers'] = DBUtil::getLimitedTablename('mediashare_mediahandlers'); $pntable['mediashare_mediahandlers_column'] = array('id' => 'ms_id', 'mimeType' => 'ms_mimetype', 'fileType' => 'ms_filetype', 'foundMimeType' => 'ms_foundmimetype', 'foundFileType' => 'ms_foundfiletype', 'handler' => 'ms_handler', 'title' => 'ms_title', 'active' => 'ms_active'); $pntable['mediashare_mediahandlers_column_def'] = array('id' => 'I NOTNULL AUTO PRIMARY', 'mimeType' => 'C(50)', 'fileType' => 'C(10)', 'foundMimeType' => 'C(50) NOTNULL', 'foundFileType' => 'C(50) NOTNULL', 'handler' => 'C(50) NOTNULL', 'title' => "C(50) NOTNULL DEFAULT ''", 'active' => 'I1 NOTNULL DEFAULT 1'); // Sources $pntable['mediashare_sources'] = DBUtil::getLimitedTablename('mediashare_sources'); $pntable['mediashare_sources_column'] = array('id' => 'ms_id', 'name' => 'ms_name', 'title' => 'ms_title', 'formEncType' => 'ms_formenctype', 'active' => 'ms_active'); $pntable['mediashare_sources_column_def'] = array('id' => 'I NOTNULL AUTO PRIMARY', 'name' => 'C(50) NOTNULL', 'title' => "C(50) NOTNULL DEFAULT ''", 'formEncType' => "C(50) NOTNULL DEFAULT 'multipart/form-data'", 'active' => 'I1 NOTNULL DEFAULT 1'); // Access table setup $pntable['mediashare_access'] = DBUtil::getLimitedTablename('mediashare_access'); $pntable['mediashare_access_column'] = array('id' => 'msa_id', 'albumId' => 'msa_albumid', 'groupId' => 'msa_groupid', 'access' => 'msa_access'); $pntable['mediashare_access_column_def'] = array('id' => 'I NOTNULL AUTO PRIMARY', 'albumId' => 'I NOTNULL', 'groupId' => 'I NOTNULL', 'access' => 'I NOTNULL'); $pntable['mediashare_access_column_idx'] = array('albumIdIdx' => array('albumId')); // Setup table setup $pntable['mediashare_setup'] = DBUtil::getLimitedTablename('mediashare_setup'); $pntable['mediashare_setup_column'] = array('id' => 'ms_id', 'kind' => 'ms_kind', 'storageLimit' => 'ms_storagelimit', 'unitId' => 'ms_unitid'); $pntable['mediashare_setup_column_def'] = array('id' => 'I NOTNULL AUTO PRIMARY', 'kind' => 'I1 NOTNULL', 'storageLimit' => 'I NOTNULL', 'unitId' => 'I NOTNULL'); // Invitations table $pntable['mediashare_invitation'] = DBUtil::getLimitedTablename('mediashare_invitation'); $pntable['mediashare_invitation_column'] = array('id' => 'msinv_id', 'created' => 'msinv_created', 'albumId' => 'msinv_albumid', 'key' => 'msinv_key', 'viewCount' => 'msinv_count', 'email' => 'msinv_email', 'subject' => 'msinv_subject', 'text' => 'msinv_text', 'sender' => 'msinv_sender', 'expires' => 'msinv_expires'); $pntable['mediashare_invitation_column_def'] = array('id' => 'I NOTNULL AUTO PRIMARY', 'created' => 'T NOTNULL', 'albumId' => 'I NOTNULL', 'key' => "C(20) NOTNULL DEFAULT ''", 'viewCount' => 'I NOTNULL DEFAULT 0', 'email' => "C(100) NOTNULL DEFAULT ''", 'subject' => "C(255) NOTNULL DEFAULT ''", 'text' => "X NOTNULL DEFAULT ''", 'sender' => "C(50) NOTNULL DEFAULT ''", 'expires' => 'T'); // Photoshare upgrade table (deprecated) $pntable['mediashare_photoshare'] = DBUtil::getLimitedTablename('mediashare_photoshare'); return $pntable; }
/** * Define module tables * @author Albert Pérez Monfort * @return module tables information */ function Files_tables() { // Initialise table array $pntable = array(); // Files table definition $pntable['Files'] = DBUtil::getLimitedTablename('Files'); $pntable['Files_column'] = array('fileId' => 'fileId', 'userId' => 'userId', 'diskUse' => 'diskUse'); $pntable['Files_column_def'] = array('fileId' => "I NOTNULL AUTO PRIMARY", 'userId' => "I NOTNULL DEFAULT 0", 'diskUse' => "I NOTNULL DEFAULT '0'"); // Return the table information return $pntable; }
/** * Define module tables * @author Albert Pérez Monfort (aperezm@xtec.cat) * @return module tables information */ function IWmessages_tables() { // Initialise table array $table = array(); // iw_noteboard table definition $table['IWmessages'] = DBUtil::getLimitedTablename('IWmessages'); $table['IWmessages_column'] = array('msg_id' => 'iw_msg_id', 'msg_image' => 'iw_msg_image', 'subject' => 'iw_subject', 'from_userid' => 'iw_from_userid', 'to_userid' => 'iw_to_userid', 'msg_time' => 'iw_msg_time', 'msg_readtime' => 'iw_msg_readtime', 'msg_text' => 'iw_msg_text', 'read_msg' => 'iw_read_msg', 'del_msg_to' => 'iw_del_msg_to', 'del_msg_from' => 'iw_del_msg_from', 'marcat' => 'iw_marcat', 'reply' => 'iw_reply', 'file1' => 'iw_file1', 'file2' => 'iw_file2', 'file3' => 'iw_file3', 'replied' => 'iw_replied'); $table['IWmessages_column_def'] = array('msg_id' => "I NOTNULL AUTO PRIMARY", 'msg_image' => "C(100) NOTNULL DEFAULT ''", 'subject' => "C(100) NOTNULL DEFAULT ''", 'from_userid' => "I(10) NOTNULL DEFAULT '0'", 'to_userid' => "I(10) NOTNULL DEFAULT '0'", 'msg_time' => "C(20) NOTNULL DEFAULT ''", 'msg_readtime' => "C(20) NOTNULL DEFAULT ''", 'msg_text' => "X NOTNULL", 'read_msg' => "I(4) NOTNULL DEFAULT '0'", 'del_msg_to' => "I(4) NOTNULL DEFAULT '0'", 'del_msg_from' => "I(4) NOTNULL DEFAULT '0'", 'marcat' => "I(1) NOTNULL DEFAULT '0'", 'reply' => "X NOTNULL", 'file1' => "C(100) NOTNULL DEFAULT ''", 'file2' => "C(100) NOTNULL DEFAULT ''", 'file3' => "C(100) NOTNULL DEFAULT ''", 'replied' => "I(1) NOTNULL DEFAULT '0'"); ObjectUtil::addStandardFieldsToTableDefinition($table['IWmessages_column'], 'pn_'); ObjectUtil::addStandardFieldsToTableDataDefinition($table['IWmessages_column_def'], 'iw_'); // Return the table information return $table; }
/** * Returns (legacy) table information for the Profile module. * * @return array Table/column definition array. */ function Profile_tables() { // Initialise table array $dbtable = array(); // Set the table name $dbtable['user_property'] = 'user_property'; $dbtable['user_property_column'] = array('prop_id' => 'id', 'prop_label' => 'label', 'prop_dtype' => 'dtype', 'prop_modname' => 'modname', 'prop_weight' => 'weight', 'prop_validation' => 'validation', 'prop_attribute_name' => 'attributename'); $dbtable['user_property_column_def'] = array('prop_id' => 'I4 NOTNULL AUTO PRIMARY', 'prop_label' => "C(255) NOTNULL DEFAULT ''", 'prop_dtype' => "I4 NOTNULL DEFAULT 0", 'prop_modname' => "C(64) NOTNULL DEFAULT ''", 'prop_weight' => 'I4 NOTNULL DEFAULT 0', 'prop_validation' => 'X', 'prop_attribute_name' => "C(80) NOTNULL DEFAULT ''"); $dbtable['user_property_column_idx'] = array('prop_label' => 'prop_label', 'prop_attr' => 'prop_attribute_name'); // // declaration of user_data is still needed for upgrade purposes // in the Users module and cannot be removed // // Set the table name $dbtable['user_data'] = DBUtil::getLimitedTablename('user_data'); $dbtable['user_data_column'] = array('uda_id' => 'pn_uda_id', 'uda_propid' => 'pn_uda_propid', 'uda_uid' => 'pn_uda_uid', 'uda_value' => 'pn_uda_value'); $dbtable['user_data_column_def'] = array('uda_id' => 'I4 NOTNULL AUTO PRIMARY', 'uda_propid' => 'I4 NOTNULL DEFAULT 0', 'uda_uid' => 'I4 NOTNULL DEFAULT 0', 'uda_value' => 'XL NOTNULL'); // Return the table information return $dbtable; }
/** * Define module tables * @author Albert Pérez Monfort (aperezm@xtec.cat) * @return module tables information */ function IWvhmenu_tables() { // Initialise table array $table = array(); // iw_main table definition $table['IWvhmenu'] = DBUtil::getLimitedTablename('IWvhmenu'); //Noms dels camps $table['IWvhmenu_column'] = array('mid' => 'iw_mid', 'text' => 'iw_text', 'url' => 'iw_url', 'bg_image' => 'iw_bg_image', 'height' => 'iw_height', 'width' => 'iw_width', 'id_parent' => 'iw_id_parent', 'groups' => 'iw_groups', 'active' => 'iw_active', 'target' => 'iw_target', 'descriu' => 'iw_descriu', 'iorder' => 'iw_iorder', 'grafic' => 'iw_grafic', 'image1' => 'iw_image1', 'image2' => 'iw_image2'); $table['IWvhmenu_column_def'] = array('mid' => "I NOTNULL AUTO PRIMARY", 'text' => "C(50) NOTNULL DEFAULT ''", 'url' => "C(255) NOTNULL DEFAULT ''", 'bg_image' => "C(20) NOTNULL DEFAULT ''", 'height' => "I(3) NOTNULL DEFAULT '25'", 'width' => "I(3) NOTNULL DEFAULT '125'", 'id_parent' => "INT(11) NOTNULL DEFAULT '0'", 'groups' => "X NOTNULL", 'active' => "I(1) NOTNULL DEFAULT '0'", 'target' => "I(1) NOTNULL DEFAULT '0'", 'descriu' => "X NOTNULL", 'iorder' => "I NOTNULL DEFAULT '0'", 'grafic' => "I(1) NOTNULL DEFAULT '0'", 'image1' => "C(20) NOTNULL DEFAULT ''", 'image2' => "C(20) NOTNULL DEFAULT ''"); ObjectUtil::addStandardFieldsToTableDefinition($table['IWvhmenu_column'], 'pn_'); ObjectUtil::addStandardFieldsToTableDataDefinition($table['IWvhmenu_column_def'], 'iw_'); // Return the table information return $table; }
/** * Define module tables * @author Albert Pérez Monfort * @return module tables information */ function IWdocmanager_tables() { // Initialise table array $table = array(); // define downloads table $table['IWdocmanager'] = DBUtil::getLimitedTablename('IWdocmanager'); $table['IWdocmanager_column'] = array('documentId' => 'documentId', 'documentName' => 'documentName', 'categoryId' => 'categoryId', 'fileName' => 'fileName', 'description' => 'description', 'filesize' => 'filesize', 'author' => 'author', 'nClicks' => 'nClicks', 'validated' => 'validated', 'version' => 'version', 'authorName' => 'authorName', 'documentLink' => 'documentLink', 'fileOriginalName' => 'fileOriginalName', 'versioned' => 'versioned', 'versionFrom' => 'versionFrom', ); $table['IWdocmanager_column_def'] = array('documentId' => "I NOTNULL AUTO PRIMARY", 'documentName' => "C(200) NOTNULL DEFAULT ''", 'categoryId' => "I NOTNULL DEFAULT 0", 'fileName' => "C(10) NOTNULL DEFAULT ''", 'description' => "X NOTNULL", 'filesize' => "C(10) NOTNULL DEFAULT ''", 'author' => "I NOTNULL DEFAULT 0", 'nClicks' => "I NOTNULL DEFAULT '0'", 'validated' => "I(4) NOTNULL DEFAULT '0'", 'version' => "C(30) NOTNULL DEFAULT ''", 'authorName' => "C(120) NOTNULL DEFAULT ''", 'documentLink' => "C(200) NOTNULL DEFAULT ''", 'fileOriginalName' => "C(100) NOTNULL DEFAULT ''", 'versioned' => "I NOTNULL DEFAULT '0'", 'versionFrom' => "C(255) NOTNULL DEFAULT ''", ); ObjectUtil::addStandardFieldsToTableDefinition($table['IWdocmanager_column'], 'pn_'); ObjectUtil::addStandardFieldsToTableDataDefinition($table['IWdocmanager_column_def'], 'iw_'); // define categories table $table['IWdocmanager_categories'] = DBUtil::getLimitedTablename('IWdocmanager_categories'); $table['IWdocmanager_categories_column'] = array('categoryId' => 'categoryId', 'categoryName' => 'categoryName', 'description' => 'description', 'groups' => 'groups', 'nDocuments' => 'nDocuments', 'nDocumentsNV' => 'nDocumentsNV', 'active' => 'active', 'parentId' => 'parentId', 'groupsAdd' => 'groupsAdd', ); $table['IWdocmanager_categories_column_def'] = array('categoryId' => "I NOTNULL AUTO PRIMARY", 'categoryName' => "C(200) NOTNULL DEFAULT ''", 'description' => "X NOTNULL", 'groups' => "X NOTNULL DEFAULT ''", 'nDocuments' => "I NOTNULL DEFAULT '0'", 'nDocumentsNV' => "I NOTNULL DEFAULT '0'", 'active' => "I(4) NOTNULL DEFAULT '0'", 'parentId' => "I NOTNULL DEFAULT '0'", 'groupsAdd' => "X NOTNULL DEFAULT ''", ); ObjectUtil::addStandardFieldsToTableDefinition($table['IWdocmanager_categories_column'], 'pn_'); ObjectUtil::addStandardFieldsToTableDataDefinition($table['IWdocmanager_categories_column_def'], 'iw_'); // Return the table information return $table; }
/** * @authors Josep Ferràndiz Farré <*****@*****.**> * @authors Jordi Fons Vilardell <*****@*****.**> * @authors Joan Guillén Pelegay <*****@*****.**> * * @par Llicència: * GNU/GPL - http://www.gnu.org/copyleft/gpl.html * @package Cataleg * @version 1.0 * @copyright Departament d'Ensenyament. Generalitat de Catalunya 2012-2013 */ function Cataleg_tables() { // Initialise table array $tables = array(); // CATALEG ************************************************************************************************* // Cataleg: definició de la taula // Contindrà la informació general del catàleg i l'estat // L'estat ens indica la visualització del catàleg. Cada estat incrementa la visualització // 0-Només el veuen els gestors // 1-El veuen els editors a 'les meves activitats' // 2-El veuen els editors en format 'catàleg' sense activitats // 3-El veuen els editors en format 'catàleg' complert // 4-El veuen els lectors // Nota: els estats definits apareixen a la 1.0 (les versions anteriors tenien un altre sistema d'estats') $tables['cataleg'] = DBUtil::getLimitedTablename('cataleg'); $tables['cataleg_column'] = array( 'catId' => 'catId', 'anyAcad' => 'anyAcad', // Exemple: 2012-2013 'nom' => 'nom', // Exemple: Catàleg unificat de formació del curs 2012-2013 'estat' => 'estat', // Estat de visualització: 0, 1, 2, 3 o 4 'editable'=> 'editable' // True si és el catàleg és editable (en les versions inicials(abans de la 1.0) hi havia el camp actiu) ); $tables['cataleg_column_def'] = array( 'catId' => "I NOTNULL AUTO PRIMARY", 'anyAcad' => "C(9) NOTNULL DEFAULT ''", 'nom' => "C(255) NOTNULL DEFAULT ''", 'estat' => "I1", 'editable'=> "L NOTNULL DEFAULT 0" ); // Afegir camps estàndard ObjectUtil::addStandardFieldsToTableDefinition($tables['cataleg_column'], 'pn_'); ObjectUtil::addStandardFieldsToTableDataDefinition($tables['cataleg_column_def'],''); // EIXOS ************************************************************************************************* // eixos: definició de taula // Contindrà informació relativa als eixos de les orientacions. // Cada prioritat s'enmarca en un eix $tables['cataleg_eixos'] = DBUtil::getLimitedTablename('cataleg_eixos'); $tables['cataleg_eixos_column'] = array( 'eixId' => 'eixId', 'catId' => 'catId', 'nom' => 'nom', 'nomCurt' => 'nomCurt', 'descripcio'=> 'descripcio', 'ordre' => 'ordre', 'visible' => 'visible' ); $tables['cataleg_eixos_column_def'] = array( 'eixId' => "I NOTNULL AUTO PRIMARY", 'catId' => "I NOTNULL", 'nom' => "C(255)", 'nomCurt' => "C(100)" , 'descripcio'=> "X", 'ordre' => "C(2)", 'visible' => "L DEFAULT 1" ); // Afegir camps estàndard ObjectUtil::addStandardFieldsToTableDefinition($tables['cataleg_eixos_column'], 'pn_'); ObjectUtil::addStandardFieldsToTableDataDefinition($tables['cataleg_eixos_column_def']); // PRIORITATS ************************************************************************************************* // prioritats: definició de taula // Recollirà la informació relativa a les prioritats i les orientacions $tables['cataleg_prioritats'] = DBUtil::getLimitedTablename('cataleg_prioritats'); $tables['cataleg_prioritats_column'] = array( 'priId' => 'priId', 'eixId' => 'eixId', 'nom' => 'nom', 'nomCurt' => 'nomCurt', 'orientacions' => 'orientacions', 'recursos' => 'recursos', 'ordre' => 'ordre', 'visible' => 'visible' ); $tables['cataleg_prioritats_column_def'] = array( 'priId' => "I NOTNULL AUTO PRIMARY", 'eixId' => "I", 'nom' => "X", 'nomCurt' => "C(200)", 'orientacions' => "X", 'recursos' => "X" , 'ordre' => "I", 'visible' => "L DEFAULT 1" ); ObjectUtil::addStandardFieldsToTableDefinition($tables['cataleg_prioritats_column'], 'pn_'); ObjectUtil::addStandardFieldsToTableDataDefinition($tables['cataleg_prioritats_column_def']); // UNITATS IMPLICADES ************************************************************************************************* // unitatsImplicades: definició de taula // Recollirà llista d'unitats implicades en una prioritat // i les dades de les persones responsables $tables['cataleg_unitatsImplicades'] = DBUtil::getLimitedTablename('cataleg_unitatsImplicades'); $tables['cataleg_unitatsImplicades_column'] = array( 'impunitId' => 'impunitId', // Camp id de la taula d'unitats implicades 'priId' => 'priId', // Id prioritat relacionada 'uniId' => 'uniId', // Id Unitat implicada 'tematica' => 'tematica', // Opcional. Indicació temàtica específica de la prioritat 'pContacte' => 'pContacte', // Persona de contacte 'email' => 'email', // Correu electrònic de la persona de contacte 'telContacte' => 'telContacte', // Telèfon/extensió persona de contacte 'dispFormador' => 'dispFormador' // La unitat organitzadora disposa de persones formadores ); $tables['cataleg_unitatsImplicades_column_def'] = array( 'impunitId' => "I NOTNULL AUTO PRIMARY", //Afegit a la versió 1.0 'priId' => "I NOTNULL ", 'uniId' => "I NOTNULL ", 'tematica' => "C(50)", // Opcional. Indicació temàtica específica de la prioritat 'pContacte' => "C(120)", // Persona de contacte 'email' => "C(50)", // Correu electrònic de la persona de contacte 'telContacte' => "C(20)", // Telefon/extensió persona de contacte 'dispFormador' => "L NOTNULL DEFAULT 0" // La unitat organitzadora disposa de persones formadores ); ObjectUtil::addStandardFieldsToTableDefinition($tables['cataleg_unitatsImplicades_column'], 'pn_'); ObjectUtil::addStandardFieldsToTableDataDefinition($tables['cataleg_unitatsImplicades_column_def']); // SUBPRIORITATS ************************************************************************************************* // subprioritats: definició de taula // Recollirà llista de subprioritats $tables['cataleg_subprioritats'] = DBUtil::getLimitedTablename('cataleg_subprioritats'); $tables['cataleg_subprioritats_column'] = array( 'sprId' => 'sprId', 'priId' => 'priId', // Id de la prioritat mare 'nom' => 'nom', 'nomCurt' => 'nomCurt', 'ordre' => 'ordre', //a, b, c, ... 'visible' => 'visible' ); $tables['cataleg_subprioritats_column_def'] = array( 'sprId' => "I NOTNULL AUTO PRIMARY", 'priId' => "I NOTNULL", 'nom' => "X", 'nomCurt' => "C(200)", 'ordre' => "C(4)", 'visible' => "L DEFAULT 1" ); ObjectUtil::addStandardFieldsToTableDefinition($tables['cataleg_subprioritats_column'], 'pn_'); ObjectUtil::addStandardFieldsToTableDataDefinition($tables['cataleg_subprioritats_column_def']); // ACTIVITATS ************************************************************************************************* // activitats: definició de taula // Recollirà informació relativa a les activitats proposades $tables['cataleg_activitats'] = DBUtil::getLimitedTablename('cataleg_activitats'); $tables['cataleg_activitats_column'] = array( 'actId' => 'actId', 'priId' => 'priId', // Id de prioritat 'sprId' => 'sprId', // Id de subprioritat 'uniId' => 'uniId', // id del grup propietari de la fitxa (unitat) 'titol' => 'titol', // Títol activitat 'prioritaria' => 'prioritaria', // Indica si l'activitat està prioritzada pel Dept. 'tGTAF' => 'tGTAF', // Tipologia GTAF 'destinataris' => 'destinataris', // serialització dels id's a qui s'adreça(taula auxiliar/mode = "d") 'observacions' => 'observacions', // perfil de les persones destinatàries 'curs' => 'curs', // curs, taller, seminari... 'presencialitat'=> 'presencialitat', // presencial, semipresencial, no presencial 'abast' => 'abast', // al centre, diversos centres 'hores' => 'hores', // Hores totals activitat 'objectius' => 'objectius', // serialització d'objectius 'continguts' => 'continguts', // serialització de continguts 'gestio' => 'gestio', // serialització de les opcions de gestió: ID taula auxiliar tipus "gest" 'estat' => 'estat', // 'ordre' => 'ordre', // Per si es vol forçar alguna ordenació no alfabètica 'validador' => 'validador', // uid de la persona que valida la fitxa 'dataVal' => 'dataVal', // Data de validació 'dataModif' => 'dataModif', // Data de modificació per publicitar 'obs_validador' => 'obs_validador', // Notes del validador a l'editor 'obs_editor' => 'obs_editor', // Notes de l'editor al validador 'centres' => 'centres', // Relació de centres (serialitzat) 'info' => 'info', // Observacions generals - visibles a la fitxa 'activa' => 'activa' ); $tables['cataleg_activitats_column_def'] = array( 'actId' => "I NOTNULL AUTO PRIMARY", 'priId' => "I", 'sprId' => "I", 'uniId' => "I", // id del grup propietari de la fitxa (unitat) 'titol' => "C(255)", 'prioritaria' => "L DEFAULT 0", 'tGTAF' => "C(4)", // Tipologia GTAF 'destinataris' => "C(255)", // serialització dels id's a qui s'adreça(taula destinataris) //(taula destinataris) ID taula auxiliar tipus "dest" 'observacions' => "C(255)", // perfil de les persones destinatàries 'curs' => "I", // ID taula auxiliar tipus:"curs" curs, taller, seminari... 'presencialitat'=> "I", // ID taula auxiliar tipus:"pres" presencial, semi, no presencial 'abast' => "I", // ID taula auxiliar tipus:"abast" al centre, diversos centres 'hores' => "I2 UNSIGNED",// Durada en hores de l'activitat 'objectius' => "X", // serialització d'objectius 'continguts' => "X", // serialització de continguts 'gestio' => "X", // serialització de les opcions de gestió: ID taula auxiliar tipus "gest" // tipus "gest" + gesId taula gestioActivitatDefaults 'estat' => "I1 DEFAULT 0", // Estat de la fitxa codificat: // 0 -> esborrany; // 1 -> enviada // 2 -> cal revisar // 3 -> validada // 4 -> modificada // 5 -> anul·lada 'ordre' => "I2 UNSIGNED",// Per si es vol forçar alguna ordenació no alfabètica 'validador' => "I", // uid de la persona que valida la fitxa 'dataVal' => "T", // Datetime o timestamp de validació 'dataModif' => "T", // Datetime de la validació de modificació per publicitar 'obs_validador' => "X", // Text per observacions de pers. validadora a editora 'obs_editor' => "X", // Text per observacions de pers. editora a validadora 'centres' => "X", 'info' => "X", // Text per a observacions generals - camp ordinari de la fitxa 'activa' => "L DEFAULT 1" ); ObjectUtil::addStandardFieldsToTableDefinition($tables['cataleg_activitats_column'], 'pn_'); ObjectUtil::addStandardFieldsToTableDataDefinition($tables['cataleg_activitats_column_def']); // ACTIVITATS ZONA ************************************************************************************************* // activitatsZona: definició de taula // per a cada activitat recollir distribució territorial // Relació amb la taula activitats pel camp actId $tables['cataleg_activitatsZona'] = DBUtil::getLimitedTablename('cataleg_activitatsZona'); $tables['cataleg_activitatsZona_column'] = array( 'actId' => 'actId', // Id activitat relacionada 'lloc' => 'lloc', // lloc o Id del lloc de realització 'qtty' => 'qtty', // Quantitat d'activitats previstes 'mesInici'=> 'mesInici' // Mes d'inici de l'activitat ); $tables['cataleg_activitatsZona_column_def'] = array( 'actId' => "I NOTNULL PRIMARY", 'lloc' => "I PRIMARY", // Id del lloc de realització (taula auxiliar: tipus "c" 'qtty' => "C(3)", // Quantitat d'activitats previstes 'mesInici'=> "C(10)" // Mes d'inici de l'activitat ); ObjectUtil::addStandardFieldsToTableDefinition($tables['cataleg_activitatsZona_column'], 'pn_'); ObjectUtil::addStandardFieldsToTableDataDefinition($tables['cataleg_activitatsZona_column_def']); // UNITATS ************************************************************************************************* // unitats: definició de taula // Recollirà llista de subprioritats $tables['cataleg_unitats'] = DBUtil::getLimitedTablename('cataleg_unitats'); $tables['cataleg_unitats_column'] = array( 'uniId' => 'uniId', 'gzId' => 'gzId', // Identificador del grup Zikula ambpermís per gestionar aquesta unitat 'catId' => 'catId', 'nom' => 'nom', 'descripcio' => 'descripcio', 'activa' => 'activa' ); $tables['cataleg_unitats_column_def'] = array( 'uniId' => "I NOTNULL AUTO PRIMARY", 'gzId' => "I", 'catId' => "I", 'nom' => "C(255)", 'descripcio' => "X", 'activa' => "L DEFAULT 1" ); ObjectUtil::addStandardFieldsToTableDefinition($tables['cataleg_unitats_column'], 'pn_'); ObjectUtil::addStandardFieldsToTableDataDefinition($tables['cataleg_unitats_column_def']); // RESPONSABLES ************************************************************************************************* // responsables: definició de taula // recull informació de les persones responsable d'una unitat o servei // UNITATS <---- RESPONSABLES (camp relacionats: uniId, uniId) $tables['cataleg_responsables'] = DBUtil::getLimitedTablename('cataleg_responsables'); $tables['cataleg_responsables_column'] = array( 'respunitId' => 'respunitId', //Id de la taula 'uniId' => 'uniId', // Id de la unitat de la persona responsable 'responsable' => 'responsable', // Nom i cognoms de la persona responsable 'email' => 'email', // Correu electrònic de la pers. responsable 'telefon' => 'telefon' // Telefon i extensió ); $tables['cataleg_responsables_column_def'] = array( 'respunitId' => "I NOTNULL AUTO PRIMARY", //Afegit ala versió 1.0 'uniId' => "I NOTNULL", 'responsable' => "C(120)", // Nom i cognoms de la persona responsable 'email' => "C(50)", // Correu electrònic de la pers. responsable 'telefon' => "C(20)" // Telefon i extensió ); ObjectUtil::addStandardFieldsToTableDefinition($tables['cataleg_responsables_column'], 'pn_'); ObjectUtil::addStandardFieldsToTableDataDefinition($tables['cataleg_responsables_column_def']); // CONTACTES ************************************************************************************************* // contactes: definició de taula // recull informació de les persones de contacte relacionades amb una activitat // Fitxa: activitats // // ACTIVITATS <---- CONTACTES (camp relacionats: actId, actId) $tables['cataleg_contactes'] = DBUtil::getLimitedTablename('cataleg_contactes'); $tables['cataleg_contactes_column'] = array( 'actId' => 'actId', // Id de la unitat de la persona responsable 'pContacte' => 'pContacte', // Nom i cognoms de la persona responsable 'email' => 'email', // Correu electrònic de la pers. responsable 'telefon' => 'telefon' // Telefon i extensió ); $tables['cataleg_contactes_column_def'] = array( 'actId' => "I", 'pContacte' => "C(120)", // Nom i cognoms de la persona responsable 'email' => "C(50)", // Correu electrònic de la pers. responsable 'telefon' => "C(20)" // Telefon i extensió ); ObjectUtil::addStandardFieldsToTableDefinition($tables['cataleg_contactes_column'], 'pn_'); ObjectUtil::addStandardFieldsToTableDataDefinition($tables['cataleg_contactes_column_def']); // AUXILIAR ************************************************************************************************* // auxiliar: definició de taula // Contindrà informació ítul en llistats o desplegables agrupats per "tipus" // tipus "dest": possibles distinatris de la formació (Infantil, Primària, CdA, ...) // tipus "abast": abast de la formació (al centre / diversos centres) // tipus "pres": modalitat de la formació (semi/presencial/no presencial) // tipus "curs": tipologia de la formació (curs, taller, seminari, jornada, ...) // tipus "sstt": llistat de comarques (SSTT) // tipus "gest": (gestió) Servei educatiu, Servei territorial, Unitat, PEEE, ... $tables['cataleg_auxiliar'] = DBUtil::getLimitedTablename('cataleg_auxiliar'); $tables['cataleg_auxiliar_column'] = array( 'auxId' => 'auxId', 'nom' => 'nom', 'nomCurt' => 'nomCurt', 'tipus' => 'tipus', // tipus "dest": possibles distinatris de la formació (Infantil, Primària, CdA, ...) // tipus "abast": abast de la formació (al centre / diversos centres) // tipus "pres": modalitat de la formació (semi/presencial/no presencial) // tipus "curs": tipologia de la formació (curs, taller, seminari, jornada, ...) // tipus "sstt": llistat de comarques (SSTT) // tipus "gest": (gestió) Servei educatiu, Servei territorial, Unitat, PEEE, ... 'ordre' => 'ordre', 'visible' => 'visible' ); $tables['cataleg_auxiliar_column_def'] = array( 'auxId' => "I NOTNULL AUTO PRIMARY", 'nom' => "C(50) NOTNULL", 'nomCurt' => "C(10)", 'tipus' => "C(5)", 'ordre' => "I1 UNSIGNED DEFAULT 125", 'visible' => "L DEFAULT 1" ); ObjectUtil::addStandardFieldsToTableDefinition($tables['cataleg_auxiliar_column'], 'pn_'); ObjectUtil::addStandardFieldsToTableDataDefinition($tables['cataleg_auxiliar_column_def']); // GESTIÓ ************************************************************************************************* // gestio: definició de taula // opcions per defecte i elements de gestió d'una activitat $tables['cataleg_gestioActivitatDefaults'] = DBUtil::getLimitedTablename('cataleg_gestioActivitatDefaults'); $tables['cataleg_gestioActivitatDefaults_column'] = array( 'gesId' => 'gesId', 'text' => 'text', //Cerca el lloc..., Difusió, Donar d'alta al GTAF, ... 'opcions' => 'opcions', //Serialització dels elements a mostrar en la llista desplegable: //ID taula auxiliar: tipus "gest" -> SE, ST, ... 'opSE' => 'opSE', // Default per a servei educatiu Id 'opST' => 'opST', // Default per a servei territorial Id 'opUN' => 'opUN', // Default per a Unitat Id 'ordre' => 'ordre', // Ordre per mostrar els diferents elements de gestió 'visible' => 'visible' ); $tables['cataleg_gestioActivitatDefaults_column_def'] = array( 'gesId' => "I NOTNULL AUTO PRIMARY", 'text' => "C(50)", //Cerca el lloc..., Difusió, Donar d'alta al GTAF, ... 'opcions' => "C(255)", //Serialització dels elements a mostrar en la llista desplegable: //ID taula auxiliar: tipus "gest" -> SE, ST, ... 'opSE' => "I", // Default per a servei educatiu Id 'opST' => "I", // Default per a servei territorial Id 'opUN' => "I", // Default per a Unitat Id 'ordre' => "I1 UNSIGNED",// (0 - 255) Ordre per mostrar els diferents elements de gestió 'visible' => "L DEFAULT 1" ); ObjectUtil::addStandardFieldsToTableDefinition($tables['cataleg_gestioActivitat_column'], 'pn_'); ObjectUtil::addStandardFieldsToTableDataDefinition($tables['cataleg_gestioActivitat_column_def']); // CENTRESACTIVITAT ************************************************************************************************* // centresActivitat: definició de taula // opcions per defecte i elements de gestió d'una activitat $tables['cataleg_centresActivitat'] = DBUtil::getLimitedTablename('cataleg_centresActivitat'); $tables['cataleg_centresActivitat_column'] = array( 'actId' => 'actId', 'centre' => 'centre' ); $tables['cataleg_centresActivitat_column_def'] = array( 'actId' => "I NOTNULL PRIMARY", 'centre' => "C(8) NOTNULL PRIMARY" ); ObjectUtil::addStandardFieldsToTableDefinition($tables['cataleg_centresActivitat_column'], 'pn_'); ObjectUtil::addStandardFieldsToTableDataDefinition($tables['cataleg_centresActivitat_column_def']); // CENTRES ************************************************************************************************* // centres: definició de taula // importació de la informació del GTAF per tenir la informació dels centres de Catalunya $tables['cataleg_centres'] = DBUtil::getLimitedTablename('cataleg_centres'); $tables['cataleg_centres_column'] = array( 'CODI_ENTITAT' => 'CODI_ENTITAT', 'CODI_TIPUS_ENTITAT'=> 'CODI_TIPUS_ENTITAT', 'NOM_ENTITAT' => 'NOM_ENTITAT', 'NOM_LOCALITAT' => 'NOM_LOCALITAT', 'NOM_DT' => 'NOM_DT', 'CODI_DT' => 'CODI_DT', 'NOM_TIPUS_ENTITAT' => 'NOM_TIPUS_ENTITAT' ); $tables['cataleg_centres_column_def'] = array( 'CODI_ENTITAT' => "C(8) NOTNULL PRIMARY", 'CODI_TIPUS_ENTITAT'=> "C(5)", 'NOM_ENTITAT' => "C(50)", 'NOM_LOCALITAT' => "C(50)", 'NOM_DT' => "C(50)", 'CODI_DT' => "C(1)", 'NOM_TIPUS_ENTITAT' => "C(30)" ); ObjectUtil::addStandardFieldsToTableDefinition($tables['cataleg_centres_column'], 'pn_'); ObjectUtil::addStandardFieldsToTableDataDefinition($tables['cataleg_centres_column_def']); // importTaules ************************************************************************************************* // Recull les correspondències definides entre catàlegs per a poder importar activitats // $tables['cataleg_importTaules'] = DBUtil::getLimitedTablename('cataleg_importTaules'); $tables['cataleg_importTaules_column'] = array( 'importId' => 'importId', 'catIdOri' => 'catIdOri', 'catIdDest' => 'catIdDest' ); $tables['cataleg_importTaules_column_def'] = array( 'importId' => "I NOTNULL AUTO PRIMARY", //index, es fa servir com a referència a cataleg_importAssign 'catIdOri' => "I", //catId del Catàleg origen de la importació 'catIdDest' => "I" //catId del Catàleg destinació de la importació ); ObjectUtil::addStandardFieldsToTableDefinition($tables['cataleg_importTaules_column'], 'pn_'); ObjectUtil::addStandardFieldsToTableDataDefinition($tables['cataleg_importTaules_column_def']); $tables['cataleg_importTaules_column_idx'] = array ('catsId' => array('columns' => array('catIdOri', 'catIdDest'),'options' => array('UNIQUE' => true))); // Taula cataleg_importAssign ************************************************************************************************* // Recull les relacions entre prioritat-subprioritat d'un catàleg i un altre // Permet fer l'assignació de valors en importar activitats entre dos catàlegs $tables['cataleg_importAssign'] = DBUtil::getLimitedTablename('cataleg_importAssign'); $tables['cataleg_importAssign_column'] = array( 'importId' => 'importId', 'idsOri' => 'idsOri', 'idsDest' => 'idsDest' ); $tables['cataleg_importAssign_column_def'] = array( 'importId' => "I NOTNULL", // index de la taula cataleg_importTaules on s'estableix la correspondència 'idsOri' => "C(25) NOTNULL PRIMARY", //priId$$sprId del catàleg origen 'idsDest' => "C(25) NOTNULL PRIMARY" //priId$$sprId del catàleg destinació ); ObjectUtil::addStandardFieldsToTableDefinition($tables['cataleg_importAssign_column'], 'pn_'); ObjectUtil::addStandardFieldsToTableDataDefinition($tables['cataleg_importAssign_column_def']); // Taula cataleg_gtafEntities ************************************************************************************************* // Recull les entitats de gtaf utilitzaces per a l'assignació dels usuaris // Corresponen a unitats (ex-> 0552), st (ex-> 7) i crp (ex-> 702) // El camp tipus podrà ser UNI, ST o SE $tables['cataleg_gtafEntities'] = DBUtil::getLimitedTablename('cataleg_gtafEntities'); $tables['cataleg_gtafEntities_column'] = array( 'gtafEntityId' => 'gtafEntityId', 'nom' => 'nom', 'tipus' => 'tipus', 'gtafGroupId' => 'gtafGroupId' ); $tables['cataleg_gtafEntities_column_def'] = array( 'gtafEntityId' => 'C(5) NOTNULL PRIMARY', 'nom' => 'C(100) NOTNULL', 'tipus' => 'C(5) NOTNULL', 'gtafGroupId' => 'C(5) NOTNULL' ); // Taula cataleg_gtafGroups *************************************************************************************************** // Recull les agrupacions d'enitats de gtaf amb la seva dependència orgànica // Utilitzarem els mateixos codis que té la seva entitat (gtafEnitityId) principal $tables['cataleg_gtafGroups'] = DBUtil::getLimitedTablename('cataleg_gtafGroups'); $tables['cataleg_gtafGroups_column'] = array( 'gtafGroupId' => 'gtafGroupId', 'nom' => 'nom', 'resp_uid' => 'resp_uid' ); $tables['cataleg_gtafGroups_column_def'] = array( 'gtafGroupId' => 'C(5) NOTNULL PRIMARY', 'nom' => 'C(100) NOTNULL', 'resp_uid' => 'I' ); // Inclusió de la definició de la taula IWusers $tables['IWusers'] = DBUtil::getLimitedTablename('IWusers'); $tables['IWusers_column'] = array( 'suid' => 'iw_suid', 'uid' => 'iw_uid', 'id' => 'iw_id', 'nom' => 'iw_nom', 'cognom1' => 'iw_cognom1', 'cognom2' => 'iw_cognom2', 'naixement' => 'iw_naixement', 'accio' => 'iw_accio', 'sex' => 'iw_sex', 'description' => 'iw_description', 'avatar' => 'iw_avatar', 'newavatar' => 'iw_newavatar', 'code' => 'iw_code' ); $tables['IWusers_column_def'] = array('suid' => "I NOTNULL AUTO PRIMARY", 'uid' => "I NOTNULL DEFAULT '0'", 'id' => "C(50) NOTNULL DEFAULT ''", 'nom' => "C(25) NOTNULL DEFAULT ''", 'cognom1' => "C(25) NOTNULL DEFAULT ''", 'cognom2' => "C(25) NOTNULL DEFAULT ''", 'naixement' => "C(8) NOTNULL DEFAULT ''", 'accio' => "I(1) NOTNULL DEFAULT '0'", 'sex' => "C(1) NOTNULL DEFAULT ''", 'description' => "X NOTNULL", 'avatar' => "C(50) NOTNULL DEFAULT ''", 'newavatar' => "C(50) NOTNULL DEFAULT ''", 'code' => "C(5)" ); //Returns informació de les taules return $tables; }
/** * Module upgrade */ function mediashare_upgrade($oldVersion) { // Upgrade dependent on old version number switch ($oldVersion) { case '1.0.0': case '1.0.1': if (!mediashare_upgrade_to_1_0_2()) { return '1.0.1'; } case '1.0.2': case '2.0.0': case '2.0.1': case '2.1.0': if (!mediashare_upgrade_to_2_1_1()) { return '2.1.0'; } case '2.1.1': case '2.1.2': if (!mediashare_upgrade_to_2_2_0()) { return '2.1.2'; } case '2.2.0': if (!mediashare_upgrade_to_2_3_0()) { return '2.2.0'; } case '2.3.0': case '3.0.0': case '3.0.1': case '3.1.0': case '3.1.1': case '3.2.0': case '3.3.0': if (!mediashare_upgrade_to_3_4_0()) { return '3.3.0'; } case '3.4.0': if (!mediashare_upgrade_to_3_4_1()) { return '3.4.0'; } case '3.4.1': mediashare_upgrade_to_3_4_2(); case '3.4.2': case '4.0.0': case '4.0.1': $tables = DBUtil::metaTables(); $ptable = DBUtil::getLimitedTablename('mediashare_photoshare'); if (in_array($ptable, $tables) && !DBUtil::dropTable('mediashare_photoshare')) { return '4.0.1'; } case '4.0.2': case '4.1': // future } // Update successful return true; }
/** * @authors Josep Ferràndiz Farré <*****@*****.**> * @authors Jordi Fons Vilardell <*****@*****.**> * @authors Joan Guillén Pelegay <*****@*****.**> * * @par Llicència: * GNU/GPL - http://www.gnu.org/copyleft/gpl.html * @package Llicencies * @version 1.0 * @copyright Departament d'Ensenyament. Generalitat de Catalunya 2013-2014 */ function Llicencies_tables() { // Initialise table array $tables = array(); // LLICENCIES ************************************************************************************************* // llicencies: // Contindrà la informació de les llicències d'estudi realitzades i l'estat de finalització $tables['llicencies'] = DBUtil::getLimitedTablename('llicencies'); $tables['llicencies_column'] = array( 'codi_treball' => 'codi_treball', 'titol' => 'titol', 'caracteristiques' => 'caracteristiques', 'orientacio' => 'orientacio', 'nivell' => 'nivell' , 'resum' => 'resum' , 'annexos' => 'annexos' , 'web' => 'web' , 'altres' => 'altres' , 'tema' => 'tema' , 'subtema' => 'subtema' , 'tipus' => 'tipus', 'curs' => 'curs', 'capsa' => 'capsa', 'url' => 'url', 'modalitat' => 'modalitat', 'cognoms' => 'cognoms', 'nom' => 'nom', 'correuel' => 'correuel', 'estat' => 'estat' ); $tables['llicencies_column_def'] = array( 'codi_treball' => "I NOTNULL AUTO PRIMARY", 'titol' => "C(255) NOTNULL", 'caracteristiques' => "X", 'orientacio' => "X", 'nivell' => "C(255)", 'resum' => "X", 'annexos' => "C(255)" , 'web' => "C(255)" , 'altres' => "C(255)" , 'tema' => "I" , 'subtema' => "I" , 'tipus' => "I" , 'curs' => "C(10)", 'capsa' => "C(10)", 'url' => "C(255)" , 'modalitat' => "C(3)" , 'cognoms' => "C(255)" , 'nom' => "C(100)" , 'correuel' => "C(255)", 'estat' => "I" ); // Afegir camps estàndard ObjectUtil::addStandardFieldsToTableDefinition($tables['llicencies_column']); ObjectUtil::addStandardFieldsToTableDataDefinition($tables['llicencies_column_def']); // CURS ************************************************************************************************* // curs: llistat de cursos disponibles format yyyy/yy $tables['llicencies_curs'] = DBUtil::getLimitedTablename('llicencies_curs'); $tables['llicencies_curs_column'] = array( 'curs' => 'curs' ); $tables['llicencies_curs_column_def'] = array( 'curs' => "C(10) NOTNULL PRIMARY" ); // Afegir camps estàndard ObjectUtil::addStandardFieldsToTableDefinition($tables['llicencies_curs_column']); ObjectUtil::addStandardFieldsToTableDataDefinition($tables['llicencies_curs_column_def']); // MODALITAT ************************************************************************************************* // modalitat de llicència A, B1, B2, B3 o C $tables['llicencies_modalitat'] = DBUtil::getLimitedTablename('llicencies_modalitat'); $tables['llicencies_modalitat_column'] = array( 'id_mod' => 'id_mod', 'descripcio' => 'descripcio' ); $tables['llicencies_modalitat_column_def'] = array( 'id_mod' => "C(3) NOTNULL PRIMARY", 'descripcio' => "C(255) NOTNULL" ); ObjectUtil::addStandardFieldsToTableDefinition($tables['llicencies_modalitat_column']); ObjectUtil::addStandardFieldsToTableDataDefinition($tables['llicencies_modalitat_column_def']); // TEMA ************************************************************************************************* $tables['llicencies_tema'] = DBUtil::getLimitedTablename('llicencies_tema'); $tables['llicencies_tema_column'] = array( 'codi_tema' => 'codi_tema', 'nom' => 'nom' ); $tables['llicencies_tema_column_def'] = array( 'codi_tema' => "I NOTNULL PRIMARY", 'nom' => "C(255) NOTNULL" ); ObjectUtil::addStandardFieldsToTableDefinition($tables['llicencies_tema_column']); ObjectUtil::addStandardFieldsToTableDataDefinition($tables['llicencies_tema_column_def']); // SUBTEMA ************************************************************************************************* $tables['llicencies_subtema'] = DBUtil::getLimitedTablename('llicencies_subtema'); $tables['llicencies_subtema_column'] = array( 'codi_subt' => 'codi_subt', 'nom' => 'nom' ); $tables['llicencies_subtema_column_def'] = array( 'codi_subt' => "I NOTNULL PRIMARY", 'nom' => "C(255) NOTNULL" ); ObjectUtil::addStandardFieldsToTableDefinition($tables['llicencies_subtema_column']); ObjectUtil::addStandardFieldsToTableDataDefinition($tables['llicencies_subtema_column_def']); // TIPUS ************************************************************************************************* // Més categories relatives a l'àmbit del treball $tables['llicencies_tipus'] = DBUtil::getLimitedTablename('llicencies_tipus'); $tables['llicencies_tipus_column'] = array( 'codi_tipus' => 'codi_tipus', 'nom' => 'nom' ); $tables['llicencies_tipus_column_def'] = array( 'codi_tipus' => "I NOTNULL PRIMARY", 'nom' => "C(255) NOTNULL" ); ObjectUtil::addStandardFieldsToTableDefinition($tables['llicencies_tipus_column']); ObjectUtil::addStandardFieldsToTableDataDefinition($tables['llicencies_tipus_column_def']); // ESTATS ************************************************************************************************* // estat de la llicència: // sense memòria pdf, preparada, pròrroga, renúncia, expedient, desapareguda, pendent, en elaboració $tables['llicencies_estats'] = DBUtil::getLimitedTablename('llicencies_estats'); $tables['llicencies_estats_column'] = array( 'id_estat' => 'id_estat', 'descripcio' => 'descripcio' ); $tables['llicencies_estats_column_def'] = array( 'id_estat' => "I NOTNULL PRIMARY", 'descripcio' => "C(255) NOTNULL" ); ObjectUtil::addStandardFieldsToTableDefinition($tables['llicencies_estats_column']); ObjectUtil::addStandardFieldsToTableDataDefinition($tables['llicencies_estats_column_def']); //Returns informació de les taules return $tables; }
/** * Upgrade the errors module from an old version * * This function must consider all the released versions of the module! * If the upgrade fails at some point, it returns the last upgraded version. * * @param string $oldversion Version number string to upgrade from. * * @return mixed True on success, last valid version string or false if fails. */ public function upgrade($oldversion) { // rename table if upgrading from an earlier version if (in_array(DBUtil::getLimitedTablename('seccont'), DBUtil::MetaTables())) { DBUtil::renameTable('seccont', 'pages'); DBUtil::renameColumn('pages', 'pn_artid', 'pageid'); } switch ($oldversion) { // 1.0 shipped with .7x case '1.0': // populate permalinks for existing content $tables = DBUtil::getTables(); $shorturlsep = System::getVar('shorturlsseparator'); $sqls = array(); $sqls[] = "UPDATE $tables[pages] SET pn_urltitle = REPLACE(pn_title, ' ', '{$shorturlsep}')"; $sqls[] = "UPDATE $tables[pages] SET pn_cr_date = '".DateUtil::getDatetime()."'"; $sqls[] = "UPDATE $tables[pages] SET pn_displaywrapper = 0"; foreach ($sqls as $sql) { if (!DBUtil::executeSQL($sql)) { return LogUtil::registerError($this->__('Error! Update attempt failed.')); } } $this->setVar('itemsperpage', 25); case '2.0': case '2.1': $this->setVar('enablecategorization', true); $this->setVar('addcategorytitletopermalink', true); ModUtil::dbInfoLoad('Pages', 'Pages', true); if (!$this->_migratecategories()) { LogUtil::registerError($this->__('Error! Update attempt failed.')); return '2.1'; } case '2.2': if (!$this->_migratedisplayvars()) { LogUtil::registerError($this->__('Error! Update attempt failed.')); return '2.2'; } // gettext conversion case '2.3': $this->setVar('showpermalinkinput', true); if (!$this->_migrategtlanguage()) { LogUtil::registerError($this->__('Error! Update attempt failed.')); return '2.3'; } case '2.4': case '2.4.1': case '2.4.2': $prefix = $this->serviceManager['prefix']; $connection = Doctrine_Manager::getInstance()->getConnection('default'); $sqlStatements = array(); // N.B. statements generated with PHPMyAdmin $sqlStatements[] = 'RENAME TABLE ' . $prefix . '_pages' . " TO `pages`"; $sqlStatements[] = "ALTER TABLE `pages` CHANGE `pn_pageid` `pageid` INT( 11 ) NOT NULL AUTO_INCREMENT , CHANGE `pn_title` `title` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , CHANGE `pn_content` `content` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , CHANGE `pn_counter` `counter` INT( 11 ) NOT NULL DEFAULT '0', CHANGE `pn_language` `language` VARCHAR( 30 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `pn_urltitle` `urltitle` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , CHANGE `pn_displaywrapper` `displaywrapper` TINYINT( 4 ) NOT NULL DEFAULT '1', CHANGE `pn_displaytitle` `displaytitle` TINYINT( 4 ) NOT NULL DEFAULT '1', CHANGE `pn_displaycreated` `displaycreated` TINYINT( 4 ) NOT NULL DEFAULT '1', CHANGE `pn_displayupdated` `displayupdated` TINYINT( 4 ) NOT NULL DEFAULT '1', CHANGE `pn_displaytextinfo` `displaytextinfo` TINYINT( 4 ) NOT NULL DEFAULT '1', CHANGE `pn_displayprint` `displayprint` TINYINT( 4 ) NOT NULL DEFAULT '1', CHANGE `pn_obj_status` `obj_status` CHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'A', CHANGE `pn_cr_date` `cr_date` DATETIME NOT NULL DEFAULT '1970-01-01 00:00:00', CHANGE `pn_cr_uid` `cr_uid` INT( 11 ) NOT NULL DEFAULT '0', CHANGE `pn_lu_date` `lu_date` DATETIME NOT NULL DEFAULT '1970-01-01 00:00:00', CHANGE `pn_lu_uid` `lu_uid` INT( 11 ) NOT NULL DEFAULT '0'"; foreach ($sqlStatements as $sql) { $stmt = $connection->prepare($sql); try { $stmt->execute(); } catch (Exception $e) { } } HookUtil::registerSubscriberBundles($this->version->getHookSubscriberBundles()); // set defaults for modvars that should have been set in 2.2 upgrade $this->resetModVars(); // update table if (!DBUtil::changeTable('pages')) { return '2.4.2'; } // further upgrade routines } // Update successful return true; }
/** * Define module tables * @author Albert Pérez Monfort (aperezm@xtec.cat) * @author Josep Ferràndiz Farré (jferran6@xtec.cat) * @return module tables information */ function IWbookings_tables() { // Initialize table array $table = array(); // IWbookings table definition $table['IWbookings'] = DBUtil::getLimitedTablename('IWbookings'); $table['IWbookings_column'] = array('bid' => 'bid', 'user' => 'user', 'sid' => 'sid', 'start' => 'start', 'end' => 'end', 'usrgroup' => 'usrgroup', 'dayofweek' => 'dayofweek', 'temp' => 'temp', 'cancel' => 'cancel', 'reason' => 'reason', 'bkey' => 'bkey'); $table['IWbookings_column_def'] = array('bid' => "I NOTNULL AUTO PRIMARY", 'sid' => "I NOTNULL DEFAULT '0'", 'user' => "I NOTNULL DEFAULT '0'", 'start' => "T NOTNULL DEFAULT '0000-00-00 00:00:00'", 'end' => "T NOTNULL DEFAULT '0000-00-00 00:00:00'", 'usrgroup' => "C(30) NOTNULL DEFAULT ''", 'reason' => "C(255) NOTNULL DEFAULT ''", 'dayofweek' => "I(1) NOTNULL DEFAULT '0'", 'temp' => "I(1) NOTNULL DEFAULT '0'", 'cancel' => "I(1) NOTNULL DEFAULT '0'", 'bkey' => "I(10) NOTNULL DEFAULT '0'"); ObjectUtil::addStandardFieldsToTableDefinition($table['IWbookings_column'], 'pn_'); ObjectUtil::addStandardFieldsToTableDataDefinition($table['IWbookings_column_def'], 'iw_'); // IWbookings_spaces table definition $table['IWbookings_spaces'] = DBUtil::getLimitedTablename('IWbookings_spaces'); $table['IWbookings_spaces_column'] = array('sid' => 'sid', 'space_name' => 'space_name', 'description' => 'description', 'mdid' => 'mdid', 'vertical' => 'vertical', 'color' => 'color', 'active' => 'active'); $table['IWbookings_spaces_column_def'] = array('sid' => "I NOTNULL AUTO PRIMARY", 'space_name' => "C(100) NOTNULL DEFAULT ''", 'description' => "C(255) NOTNULL DEFAULT ''", 'mdid' => "I NOTNULL DEFAULT '0'", 'vertical' => "I(1) NOTNULL DEFAULT '0'", 'color' => "C(7) NOT NULL DEFAULT '#FFFFFF'", 'active' => "I(1) NOTNULL DEFAULT '0'"); ObjectUtil::addStandardFieldsToTableDefinition($table['IWbookings_spaces_column'], 'pn_'); ObjectUtil::addStandardFieldsToTableDataDefinition($table['IWbookings_spaces_column_def'], 'iw_'); // IWmain table definition needed in this module $table['IWmain'] = DBUtil::getLimitedTablename('IWmain'); $table['IWmain_column'] = array('id' => 'iw_id', 'uid' => 'iw_uid', 'module' => 'iw_module', 'name' => 'iw_name', 'value' => 'iw_value', 'lifetime' => 'iw_lifetime'); // iw_timeframes table definition needed in this module // IWtimeframes table definition $table['IWtimeframes'] = DBUtil::getLimitedTablename('IWtimeframes'); $table['IWtimeframes_column'] = array('hid' => 'hid', 'mdid' => 'mdid', //identifica el marc horari 'start' => 'start', 'end' => 'end', 'descriu' => 'descriu'); $table['IWtimeframes_definition'] = DBUtil::getLimitedTablename('IWtimeframes_definition'); $table['IWtimeframes_definition_column'] = array('mdid' => 'mdid', 'nom_marc' => 'nom_marc', 'descriu' => 'descriu'); $table['IWtimeframes_definition_column_def'] = array('mdid' => "I NOTNULL AUTO PRIMARY", 'nom_marc' => "C(50) NOTNULL DEFAULT ''", 'descriu' => "C(255) NOTNULL DEFAULT ''"); // Return the table information return $table; }
function EZComments_get76xcolumns_news(&$Commentstable, &$Commentscolumn) { $Commentstable = DBUtil::getLimitedTablename('comments'); $Commentscolumn = array('tid' => 'pn_tid', 'pid' => 'pn_pid', 'sid' => 'pn_sid', 'date' => 'pn_date', 'name' => 'pn_name', 'email' => 'pn_email', 'url' => 'pn_url', 'host_name' => 'pn_host_name', 'subject' => 'pn_subject', 'comment' => 'pn_comment', 'score' => 'pn_score', 'reason' => 'pn_reason'); }
function IWbooks_tables() { // Initialise table array $table = array(); $table['IWbooks'] = DBUtil::getLimitedTablename('IWbooks'); $table['IWbooks_column'] = array( 'tid' => 'pn_tid', 'autor' => 'pn_autor', 'titol' => 'pn_titol', 'editorial' => 'pn_editorial', 'any_publi' => 'pn_any_publi', 'isbn' => 'pn_isbn', 'codi_mat' => 'pn_codi_mat', 'lectura' => 'pn_lectura', 'any' => 'pn_any', 'etapa' => 'pn_etapa', 'nivell' => 'pn_nivell', 'avaluacio' => 'pn_avaluacio', 'optativa' => 'pn_optativa', 'observacions' => 'pn_observacions', 'materials' => 'pn_materials' ); $table['IWbooks_column_def'] = array( 'tid' => "I NOTNULL AUTO PRIMARY", 'autor' => "C(50) NOT NULL DEFAULT ''", 'titol' => "C(50) NOT NULL DEFAULT ''", 'editorial' => "C(50) NOT NULL DEFAULT ''", 'any_publi' => "C(4) NOT NULL DEFAULT ''", 'isbn' => "C(20) NOT NULL DEFAULT ''", 'codi_mat' => "C(3) NOT NULL DEFAULT ''", 'lectura' => "I(1) NOT NULL DEFAULT 0", 'any' => "C(4) NOT NULL DEFAULT ''", 'etapa' => "C(32) NOT NULL DEFAULT ''", 'nivell' => "C(15) NOT NULL DEFAULT ''", 'avaluacio' => "C(1) NOT NULL DEFAULT ''", 'optativa' => "I(1) NOT NULL DEFAULT 0", 'observacions' => "C(100) NOT NULL DEFAULT ''", 'materials' => "X NOT NULL" ); $table['IWbooks_column_idx'] = array('tid' => 'tid'); ObjectUtil::addStandardFieldsToTableDefinition($table['IWbooks_column'], 'pn_'); ObjectUtil::addStandardFieldsToTableDataDefinition($table['IWbooks_column_def'], 'pn_'); $table['IWbooks_materies'] = DBUtil::getLimitedTablename('IWbooks_materies'); $table['IWbooks_materies_column'] = array( 'tid' => 'pn_tid', 'codi_mat' => 'pn_codi_mat', 'materia' => 'pn_materia' ); $table['IWbooks_materies_column_def'] = array( 'tid' => "I NOTNULL AUTO PRIMARY", 'codi_mat' => "C(3) NOT NULL default ''", 'materia' => "C(50) NOT NULL default ''" ); ObjectUtil::addStandardFieldsToTableDefinition($table['IWbooks_materies_column'], 'pn_'); ObjectUtil::addStandardFieldsToTableDataDefinition($table['IWbooks_materies_column_def'], 'pn_'); return $table; }
function IWstats_tables() { // Initialise table array $table = array(); // Global table $table['IWstats'] = DBUtil::getLimitedTablename('IWstats'); $table['IWstats_column'] = array('statsid' => 'iw_statsid', 'datetime' => 'iw_datetime', 'ip' => 'iw_ip', 'ipForward' => 'iw_ipForward', 'ipClient' => 'iw_ipClient', 'userAgent' => 'iw_userAgent', 'moduleid' => 'iw_moduleid', 'params' => 'iw_params', 'uid' => 'iw_uid', 'isadmin' => 'iw_isadmin', 'skipped' => 'iw_skipped', 'skippedModule' => 'iw_skippedModule', 'summarised' => 'iw_summarised', ); $table['IWstats_column_def'] = array('statsid' => "I NOTNULL AUTO PRIMARY", 'datetime' => "T DEFDATETIME NOTNULL DEFAULT '1970-01-01 00:00:00'", 'ip' => "C(15) NOTNULL DEFAULT ''", 'ipForward' => "C(15) NOTNULL DEFAULT ''", 'ipClient' => "C(15) NOTNULL DEFAULT ''", 'userAgent' => "C(255) NOTNULL DEFAULT ''", 'moduleid' => "I NOTNULL DEFAULT '0'", 'params' => "C(255) NOTNULL DEFAULT ''", 'uid' => "I NOTNULL DEFAULT '0'", 'isadmin' => "I1 NOTNULL DEFAULT '0'", 'skipped' => "I1 NOTNULL DEFAULT '0'", 'skippedModule' => "I1 NOTNULL DEFAULT '0'", 'summarised' => "I1 NOTNULL DEFAULT '0'", ); $table['IWstats_summary'] = DBUtil::getLimitedTablename('IWstats_summary'); $table['IWstats_summary_column'] = array('summaryid' => 'iw_summaryid', 'datetime' => 'iw_datetime', 'nrecords' => 'iw_nrecords', 'registered' => 'iw_registered', 'modules' => 'iw_modules', 'skipped' => 'iw_skipped', 'skippedModule' => 'iw_skippedModule', 'isadmin' => 'iw_isadmin', 'users' => 'iw_users', 'nips' => 'iw_nips', ); $table['IWstats_summary_column_def'] = array('summaryid' => "I NOTNULL AUTO PRIMARY", 'datetime' => "T DEFDATETIME NOTNULL DEFAULT '1970-01-01 00:00:00'", 'nrecords' => "I NOTNULL DEFAULT '0'", 'registered' => "I NOTNULL DEFAULT '0'", 'modules' => "X NOTNULL", 'skipped' => "I NOTNULL DEFAULT '0'", 'skippedModule' => "I NOTNULL DEFAULT '0'", 'isadmin' => "I NOTNULL DEFAULT '0'", 'users' => "X NOTNULL", 'nips' => "I NOTNULL DEFAULT '0'", ); // Return the table information return $table; }
/** * Define module tables * * @return module tables information */ function IWagendas_tables() { // Initialise table array $table = array(); // IWagendas table definition $table['IWagendas'] = DBUtil::getLimitedTablename('IWagendas'); $table['IWagendas_column'] = array( 'aid' => 'aid', 'usuari' => 'usuari', 'data' => 'data', 'completa' => 'completa', 'c1' => 'c1', 'c2' => 'c2', 'c3' => 'c3', 'c4' => 'c4', 'c5' => 'c5', 'c6' => 'c6', 'totdia' => 'totdia', 'tasca' => 'tasca', 'nivell' => 'nivell', 'rid' => 'rid', 'daid' => 'daid', 'nova' => 'nova', 'vcalendar' => 'vcalendar', 'dataanota' => 'dataanota', 'fitxer' => 'fitxer', 'origen' => 'origen', 'protegida' => 'protegida', 'origenid' => 'origenid', 'modified' => 'modified', 'deleted' => 'deleted', 'deletedByUser' => 'deletedByUser', 'completedByUser' => 'completedByUser', 'gCalendarEventId' => 'gCalendarEventId', 'data1' => 'data1' ); $table['IWagendas_column_def'] = array( 'aid' => "I NOTNULL AUTO PRIMARY", 'usuari' => "I NOTNULL DEFAULT '0'", 'data' => "C(20) NOTNULL DEFAULT ''", 'completa' => "I(1) NOTNULL DEFAULT '0'", 'c1' => "X NOTNULL", 'c2' => "X NOTNULL", 'c3' => "X NOTNULL", 'c4' => "X NOTNULL", 'c5' => "X NOTNULL", 'c6' => "X NOTNULL", 'totdia' => "I(1) NOTNULL DEFAULT '0'", 'tasca' => "I(1) NOTNULL DEFAULT '0'", 'nivell' => "I(1) NOTNULL DEFAULT '0'", 'rid' => "I NOTNULL DEFAULT '0'", 'daid' => "I NOTNULL DEFAULT '0'", 'nova' => "X NOTNULL", 'vcalendar' => "I(1) NOTNULL DEFAULT '0'", 'dataanota' => "C(20) NOTNULL DEFAULT ''", 'fitxer' => "C(50) NOTNULL DEFAULT ''", 'origen' => "C(50) NOTNULL DEFAULT ''", 'protegida' => "I(1) NOTNULL DEFAULT '0'", 'origenid' => "I NOTNULL DEFAULT '0'", 'modified' => "I(1) NOTNULL DEFAULT '0'", 'deleted' => "I(1) NOTNULL DEFAULT '0'", 'deletedByUser' => "X NOTNULL", 'completedByUser' => "X NOTNULL", 'gCalendarEventId' => "C(150) NOTNULL DEFAULT ''", 'data1' => "C(20) NOTNULL DEFAULT ''" ); ObjectUtil::addStandardFieldsToTableDefinition($table['IWagendas_column'], 'pn_'); ObjectUtil::addStandardFieldsToTableDataDefinition($table['IWagendas_column_def'], 'iw_'); // IWagendas_definition table definition $table['IWagendas_definition'] = DBUtil::getLimitedTablename('IWagendas_definition'); $table['IWagendas_definition_column'] = array( 'daid' => 'daid', 'nom_agenda' => 'nom_agenda', 'descriu' => 'descriu', 'c1' => 'c1', 'c2' => 'c2', 'c3' => 'c3', 'c4' => 'c4', 'c5' => 'c5', 'c6' => 'c6', 'tc1' => 'tc1', 'tc2' => 'tc2', 'tc3' => 'tc3', 'tc4' => 'tc4', 'tc5' => 'tc5', 'tc6' => 'tc6', 'op2' => 'op2', 'op3' => 'op3', 'op4' => 'op4', 'op5' => 'op5', 'op6' => 'op6', 'grup' => 'grup', 'resp' => 'resp', 'activa' => 'activa', 'adjunts' => 'adjunts', 'protegida' => 'protegida', 'color' => 'color', 'gCalendarId' => 'gCalendarId', 'gAccessLevel' => 'gAccessLevel', 'gColor' => 'gColor' ); $table['IWagendas_definition_column_def'] = array( 'daid' => "I NOTNULL AUTO PRIMARY", 'nom_agenda' => "C(50) NOTNULL DEFAULT ''", 'descriu' => "C(50) NOTNULL DEFAULT ''", 'c1' => "C(50) NOTNULL DEFAULT ''", 'c2' => "C(50) NOTNULL DEFAULT ''", 'c3' => "C(50) NOTNULL DEFAULT ''", 'c4' => "C(50) NOTNULL DEFAULT ''", 'c5' => "C(50) NOTNULL DEFAULT ''", 'c6' => "C(50) NOTNULL DEFAULT ''", 'tc1' => "I(1) NOTNULL DEFAULT '0'", 'tc2' => "I(1) NOTNULL DEFAULT '0'", 'tc3' => "I(1) NOTNULL DEFAULT '0'", 'tc4' => "I(1) NOTNULL DEFAULT '0'", 'tc5' => "I(1) NOTNULL DEFAULT '0'", 'tc6' => "I(1) NOTNULL DEFAULT '0'", 'op2' => "C(255) NOTNULL DEFAULT ''", 'op3' => "C(255) NOTNULL DEFAULT ''", 'op4' => "C(255) NOTNULL DEFAULT ''", 'op5' => "C(255) NOTNULL DEFAULT ''", 'op6' => "C(255) NOTNULL DEFAULT ''", 'grup' => "X NOTNULL", 'resp' => "X NOTNULL", 'activa' => "I(1) NOTNULL DEFAULT '0'", 'adjunts' => "I(1) NOTNULL DEFAULT '0'", 'protegida' => "I(1) NOTNULL DEFAULT '0'", 'color' => "C(7) NOTNULL DEFAULT '#FFFFFF'", 'gCalendarId' => "C(150) NOTNULL DEFAULT ''", 'gAccessLevel' => "X NOTNULL", 'gColor' => "X NOTNULL" ); ObjectUtil::addStandardFieldsToTableDefinition($table['IWagendas_definition_column'], 'pn_'); ObjectUtil::addStandardFieldsToTableDataDefinition($table['IWagendas_definition_column_def'], 'iw_'); // IWagendas_subs table definition $table['IWagendas_subs'] = DBUtil::getLimitedTablename('IWagendas_subs'); $table['IWagendas_subs_column'] = array( 'said' => 'said', 'daid' => 'daid', 'uid' => 'uid', 'donadabaixa' => 'donadabaixa', 'llistat' => 'llistat', 'avisos' => 'avisos' ); $table['IWagendas_subs_column_def'] = array( 'said' => "I NOTNULL AUTO PRIMARY", 'daid' => "I NOTNULL DEFAULT '0'", 'uid' => "I NOTNULL DEFAULT '0'", 'donadabaixa' => "I(1) NOTNULL DEFAULT '0'", 'llistat' => "I(1) NOTNULL DEFAULT '-1'", 'avisos' => "I(1) NOTNULL DEFAULT '0'" ); ObjectUtil::addStandardFieldsToTableDefinition($table['IWagendas_subs_column'], 'pn_'); ObjectUtil::addStandardFieldsToTableDataDefinition($table['IWagendas_subs_column_def'], 'iw_'); // returns tables information return $table; }
/** * upgrade the Feeds module from an old version * This function can be called multiple times */ public function upgrade($oldversion) { $dom = ZLanguage::getModuleDomain('Feeds'); // when upgrading let's clear the cache directory CacheUtil::clearLocalDir('feeds'); switch ($oldversion) { // version 1.0 shipped with PN .7x case '1.0': // rename table if upgrading from an earlier version if (in_array(DBUtil::getLimitedTablename('RSS'), DBUtil::MetaTables())) { DBUtil::renameTable('RSS', 'feeds'); } if (in_array(DBUtil::getLimitedTablename('rss'), DBUtil::MetaTables())) { DBUtil::renameTable('rss', 'feeds'); } // create cache directory CacheUtil::createLocalDir('feeds'); // migrate module vars $tables = DBUtil::getTables(); $sql = "UPDATE $tables[module_vars] SET pn_modname = 'Feeds' WHERE pn_modname = 'RSS'"; if (!DBUtil::executeSQL($sql)) { LogUtil::registerError(__('Error! Update attempt failed.', $dom)); return '1.0'; } // create our default category $this->setVar('enablecategorization', true); if (!$this->_feeds_createdefaultcategory()) { LogUtil::registerError(__('Error! Update attempt failed.', $dom)); return '1.0'; } // update table if (!DBUtil::changeTable('feeds')) { return '1.0'; } // update the permalinks $shorturlsep = System::getVar('shorturlsseparator'); $sql = "UPDATE $tables[feeds] SET pn_urltitle = REPLACE(pn_name, ' ', '{$shorturlsep}')"; if (!DBUtil::executeSQL($sql)) { LogUtil::registerError(__('Error! Update attempt failed.', $dom)); return '1.0'; } case '2.1': $modvars = array('multifeedlimit' => 0, 'feedsperpage' => 10, 'usingcronjob' => 0, 'key' => md5(time())); if (!ModUtil::setVars('Feeds', $modvars)) { LogUtil::registerError(__('Error! Update attempt failed.', $dom)); return '2.1'; } // 2.2 -> 2.3 is the Gettext change case '2.2': case '2.3': case '2.4': case '2.5': $prefix = $this->serviceManager['prefix']; $connection = Doctrine_Manager::getInstance()->getConnection('default'); $sqlStatements = array(); // N.B. statements generated with PHPMyAdmin $sqlStatements[] = 'RENAME TABLE ' . $prefix . '_feeds' . " TO `feeds`"; $sqlStatements[] = "ALTER TABLE `feeds` CHANGE `pn_fid` `fid` INT( 10 ) NOT NULL AUTO_INCREMENT , CHANGE `pn_name` `name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `pn_urltitle` `urltitle` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `pn_url` `url` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', CHANGE `pn_obj_status` `obj_status` CHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'A', CHANGE `pn_cr_date` `cr_date` DATETIME NOT NULL DEFAULT '1970-01-01 00:00:00', CHANGE `pn_cr_uid` `cr_uid` INT( 11 ) NOT NULL DEFAULT '0', CHANGE `pn_lu_date` `lu_date` DATETIME NOT NULL DEFAULT '1970-01-01 00:00:00', CHANGE `pn_lu_uid` `lu_uid` INT( 11 ) NOT NULL DEFAULT '0'"; foreach ($sqlStatements as $sql) { $stmt = $connection->prepare($sql); try { $stmt->execute(); } catch (Exception $e) { } } case '2.6.0': $this->delVar('feedsperpage'); case '2.6.1': // further upgrade routine } // update successful return true; }
function EZComments_get76xcolumns_reviews(&$Commentstable, &$Commentscolumn) { $Commentstable = DBUtil::getLimitedTablename('reviews_comments'); $Commentscolumn = array('cid' => 'pn_cid', 'rid' => 'pn_rid', 'userid' => 'pn_userid', 'date' => 'pn_date', 'comments' => 'pn_comments', 'score' => 'pn_score'); }
protected function migrateMessages() { // Migrate any Admin_Messages to blocks $messageTable = DBUtil::getLimitedTablename('message'); $blocksTable = 'blocks'; $messageBlocks = DBUtil::executeSQL("SELECT * FROM $blocksTable WHERE bkey = 'messages'")->fetchAll(Doctrine::FETCH_ASSOC); $result = DBUtil::executeSQL("SELECT * FROM $messageTable"); $data = $result->fetchAll(Doctrine::FETCH_ASSOC); if ($data) { foreach ($data as $key => $value) { foreach ($data[$key] as $k => $v) { unset($data[$key][$k]); $newKey = str_replace('z_', '', $k); $data[$key][$newKey] = $v; } unset($data[$key]['date']); unset($data[$key]['expire']); unset($data[$key]['view']); unset($data[$key]['mid']); if (!$messageBlocks) { $data[$key]['active'] = '0'; } $data[$key]['bkey'] = 'html'; $data[$key]['position'] = 'center'; $data[$key]['refresh'] = '3600'; $data[$key]['mid'] = ModUtil::getIdFromName('Blocks'); $data[$key] = DBUtil::insertObject($data[$key], 'blocks', 'bid'); $placement = array('pid' => 3, 'bid' => $data[$key]['bid']); DBUtil::insertObject($placement, 'block_placements', 'pid', true); } } // Remove Admin_Message table. DBUtil::executeSQL("DROP TABLE $messageTable"); // Remove any Admin_Message blocks $sql = "DELETE FROM $blocksTable WHERE bkey = 'messages'"; DBUtil::executeSQL($sql); }
/** * Populate tables array for News module * * This function is called internally by the core whenever the module is * loaded. It delivers the table information to the core. * It can be loaded explicitly using the ModUtil::dbInfoLoad() API function. * * @return array The table information. */ function News_tables() { // Initialise table array $tables = array(); // Full table definition $tables['news'] = 'news'; $tables['news_column'] = array( 'sid' => 'sid', 'title' => 'title', 'urltitle' => 'urltitle', 'hometext' => 'hometext', 'bodytext' => 'bodytext', 'counter' => 'counter', 'contributor' => 'contributor', 'approver' => 'approver', 'notes' => 'notes', 'displayonindex' => 'displayonindex', 'language' => 'language', 'allowcomments' => 'allowcomments', 'format_type' => 'format_type', 'published_status' => 'published_status', 'from' => 'ffrom', //not a typo! from is a reserved sql word 'to' => 'tto', //not a typo! to is a reserved sql word 'weight' => 'weight', 'pictures' => 'pictures' ); $tables['news_column_def'] = array( 'sid' => 'I NOTNULL AUTO PRIMARY', 'title' => 'C(255) DEFAULT NULL', 'urltitle' => 'C(255) DEFAULT NULL', 'hometext' => 'XL NOTNULL', 'bodytext' => 'XL NOTNULL', 'counter' => 'I DEFAULT 0', 'contributor' => "C(25) NOTNULL DEFAULT ''", 'approver' => 'I DEFAULT 0', 'notes' => 'X NOTNULL', 'displayonindex' => 'I1 NOTNULL DEFAULT 0', 'language' => "C(30) NOTNULL DEFAULT ''", 'allowcomments' => 'I1 NOTNULL DEFAULT 0', 'format_type' => 'I1 NOTNULL DEFAULT 0', 'published_status' => 'I1 DEFAULT 0', 'from' => 'T DEFAULT NULL', 'to' => 'T DEFAULT NULL', 'weight' => 'I1 DEFAULT 0', 'pictures' => 'I DEFAULT 0' ); // Enable categorization services $tables['news_db_extra_enable_categorization'] = ModUtil::getVar('News', 'enablecategorization'); $tables['news_primary_key_column'] = 'sid'; // Enable attribution services $tables['news_db_extra_enable_attribution'] = ModUtil::getVar('News', 'enableattribution'); // add standard data fields ObjectUtil::addStandardFieldsToTableDefinition ($tables['news_column']); ObjectUtil::addStandardFieldsToTableDataDefinition($tables['news_column_def']); // old tables for upgrading $tables['comments'] = DBUtil::getLimitedTablename('comments'); $tables['autonews'] = DBUtil::getLimitedTablename('autonews'); $tables['queue'] = DBUtil::getLimitedTablename('queue'); $tables['stories'] = DBUtil::getLimitedTablename('stories'); $tables['stories_cat'] = DBUtil::getLimitedTablename('stories_cat'); $tables['topics'] = DBUtil::getLimitedTablename('topics'); return $tables; }
/** * Define module tables * @author Albert P�rez Monfort (aperezm@xtec.cat) * @return module tables information */ function IWmain_tables() { // Initialise table array $table = array(); // IWmain table definition $table['IWmain'] = DBUtil::getLimitedTablename('IWmain'); $table['IWmain_column'] = array('id' => 'iw_id', 'module' => 'iw_module', 'name' => 'iw_name', 'value' => 'iw_value', 'uid' => 'iw_uid', 'lifetime' => 'iw_lifetime', 'nult' => 'iw_nult'); $table['IWmain_column_def'] = array('id' => "I NOTNULL AUTO PRIMARY", 'module' => "C(50) NOTNULL DEFAULT ''", 'name' => "C(50) NOTNULL DEFAULT ''", 'value' => "X NOTNULL", 'uid' => "I NOTNULL DEFAULT '0'", 'lifetime' => "C(20) NOTNULL DEFAULT '0'", 'nult' => "I(1) NOTNULL DEFAULT '0'"); ObjectUtil::addStandardFieldsToTableDefinition($table['IWmain_column'], 'pn_'); ObjectUtil::addStandardFieldsToTableDataDefinition($table['IWmain_column_def'], 'iw_'); // logs table definition $table['IWmain_logs'] = DBUtil::getLimitedTablename('IWmain_logs'); $table['IWmain_logs_column'] = array('logId' => 'iw_logId', 'moduleName' => 'iw_moduleName', 'actionType' => 'iw_actionType', // 1 - add / 2 - Edit / 3 - Delete 'visible' => 'iw_visible', // 1 - all users / 0 - only administrators 'actionText' => 'iw_actionText', 'logIp' => 'iw_logIp', 'indexName' => 'iw_indexName', 'indexValue' => 'iw_indexValue', 'indexName1' => 'iw_indexName1', 'indexValue1' => 'iw_indexValue1', 'error' => 'iw_error', ); $table['IWmain_logs_column_def'] = array('logId' => "I NOTNULL AUTO PRIMARY", 'moduleName' => "C(25) NOTNULL DEFAULT ''", 'actionType' => "I(1) NOTNULL DEFAULT '0'", 'visible' => "I(1) NOTNULL DEFAULT '0'", 'actionText' => "C(255) NOTNULL DEFAULT ''", 'logIp' => "C(15) NOTNULL DEFAULT ''", 'indexName' => "C(15) NOTNULL DEFAULT ''", 'indexValue' => "I NOTNULL DEFAULT '0'", 'indexName1' => "C(15) NOTNULL DEFAULT ''", 'indexValue1' => "I NOTNULL DEFAULT '0'", 'error' => "I(1) NOTNULL DEFAULT '0'", ); ObjectUtil::addStandardFieldsToTableDefinition($table['IWmain_logs_column'], ''); ObjectUtil::addStandardFieldsToTableDataDefinition($table['IWmain_logs_column_def']); // IWusers table definition $table['IWusers'] = DBUtil::getLimitedTablename('IWusers'); $table['IWusers_column'] = array('suid' => 'iw_suid', 'uid' => 'iw_uid', 'id' => 'iw_id', 'nom' => 'iw_nom', 'cognom1' => 'iw_cognom1', 'cognom2' => 'iw_cognom2', 'naixement' => 'iw_naixement', 'code' => 'iw_code', 'accio' => 'iw_accio', 'sex' => 'iw_sex', 'description' => 'iw_description', 'avatar' => 'iw_avatar', 'newavatar' => 'iw_newavatar', ); // Return the table information return $table; }
/** * Define module tables * @author Sara Arjona Téllez (sarjona@xtec.cat) * @return module tables information */ function IWqv_tables() { // Initialise table array $tables = array(); // IWqv table definition $tables['IWqv'] = DBUtil::getLimitedTablename('IWqv'); $tables['IWqv_column'] = array('qvid' => 'iw_qvid', 'teacher' => 'iw_teacher', 'groups' => 'iw_groups', 'title' => 'iw_title', 'description' => 'iw_description', 'url' => 'iw_url', 'skin' => 'iw_skin', 'lang' => 'iw_lang', 'maxdeliver' => 'iw_maxdeliver', 'showcorrection' => 'iw_showcorrection', 'showinteraction' => 'iw_showinteraction', 'ordersections' => 'iw_ordersections', 'orderitems' => 'iw_orderitems', 'target' => 'iw_target', 'width' => 'iw_width', 'height' => 'iw_height', 'active' => 'iw_active', 'observations' => 'iw_observations'); $tables['IWqv_column_def'] = array('qvid' => "I NOTNULL AUTO PRIMARY", 'teacher' => "INT(11) NOTNULL", 'groups' => "C(255) NOTNULL", 'title' => "C(255) NOTNULL DEFAULT ''", 'description' => "X NOTNULL DEFAULT ''", 'url' => "C(255) NOTNULL DEFAULT ''", 'skin' => "C(20) NOTNULL DEFAULT ''", 'lang' => "C(10) NOTNULL DEFAULT ''", 'maxdeliver' => "INT(3) NOTNULL DEFAULT '-1'", 'showcorrection' => "INT(1) NOTNULL DEFAULT '1'", 'showinteraction' => "INT(1) NOTNULL DEFAULT '1'", 'ordersections' => "INT(1) NOTNULL DEFAULT '0'", 'orderitems' => "INT(1) NOTNULL DEFAULT '0'", 'target' => "C(10) NOTNULL DEFAULT 'blank'", 'width' => "C(10) NULL", 'height' => "C(10) NULL", 'active' => "INT(1) NOTNULL DEFAULT '1'", 'observations' => "X NOTNULL"); ObjectUtil::addStandardFieldsToTableDefinition($tables['IWqv_column'], 'pn_'); ObjectUtil::addStandardFieldsToTableDataDefinition($tables['IWqv_column_def'], 'iw_'); // IWqv_assignments table definition $tables['IWqv_assignments'] = DBUtil::getLimitedTablename('IWqv_assignments'); $tables['IWqv_assignments_column'] = array('qvaid' => 'iw_qvaid', 'qvid' => 'iw_qvid', 'userid' => 'iw_userid', 'sectionorder' => 'iw_sectionorder', 'itemorder' => 'iw_itemorder', 'teachercomments' => 'iw_teachercomments', 'teacherobservations' => 'iw_teacherobservations'); $tables['IWqv_assignments_column_def'] = array('qvaid' => "I NOTNULL AUTO PRIMARY", 'qvid' => "INT(11) NOTNULL", 'userid' => "INT(11) NOTNULL", 'sectionorder' => "INT(10) NOTNULL DEFAULT '0'", 'itemorder' => "INT(10) NOTNULL DEFAULT '0'", 'teachercomments' => "X NULL", 'teacherobservations' => "X NULL"); ObjectUtil::addStandardFieldsToTableDefinition($tables['IWqv_assignments_column'], 'pn_'); ObjectUtil::addStandardFieldsToTableDataDefinition($tables['IWqv_assignments_column_def'], 'iw_'); // IWqv_sections table definition $tables['IWqv_sections'] = DBUtil::getLimitedTablename('IWqv_sections'); $tables['IWqv_sections_column'] = array('qvsid' => 'iw_qvsid', 'qvaid' => 'iw_qvaid', 'sectionid' => 'iw_sectionid', 'responses' => 'iw_responses', 'scores' => 'iw_scores', 'pendingscores' => 'iw_pendingscores', 'attempts' => 'iw_attempts', 'state' => 'iw_state', 'time' => 'iw_time'); $tables['IWqv_sections_column_def'] = array('qvsid' => "I NOTNULL AUTO PRIMARY", 'qvaid' => "INT(11) NOTNULL", 'sectionid' => "C(255) NOTNULL", 'responses' => "X NULL", 'scores' => "X NULL", 'pendingscores' => "X NULL", 'attempts' => "INT(60) NULL DEFAULT '0'", 'state' => "INT(1) NULL DEFAULT '0'", 'time' => "C(8) NULL DEFAULT '00:00:00'"); ObjectUtil::addStandardFieldsToTableDefinition($tables['IWqv_sections_column'], 'pn_'); ObjectUtil::addStandardFieldsToTableDataDefinition($tables['IWqv_sections_column_def'], 'iw_'); // IWqv_messages table definition $tables['IWqv_messages'] = DBUtil::getLimitedTablename('IWqv_messages'); $tables['IWqv_messages_column'] = array('qvmid' => 'iw_qvmid', 'qvsid' => 'iw_qvsid', 'itemid' => 'iw_itemid', 'userid' => 'iw_userid', 'message' => 'iw_message'); $tables['IWqv_messages_column_def'] = array('qvmid' => "I NOTNULL AUTO PRIMARY", 'qvsid' => "INT(11) NOTNULL", 'itemid' => "C(255) NOTNULL", 'userid' => "INT(11) NOTNULL", 'message' => "X NOTNULL DEFAULT ''"); ObjectUtil::addStandardFieldsToTableDefinition($tables['IWqv_messages_column'], 'pn_'); ObjectUtil::addStandardFieldsToTableDataDefinition($tables['IWqv_messages_column_def'], 'iw_'); // IWqv_messages table definition $tables['IWqv_messages_read'] = DBUtil::getLimitedTablename('IWqv_messages_read'); $tables['IWqv_messages_read_column'] = array('qvmrid' => 'iw_qvmrid', 'qvmid' => 'iw_qvmid', 'userid' => 'iw_userid'); $tables['IWqv_messages_read_column_def'] = array('qvmrid' => "I NOTNULL AUTO PRIMARY", 'qvmid' => "INT(11) NOTNULL", 'userid' => "INT(11) NOTNULL"); ObjectUtil::addStandardFieldsToTableDefinition($tables['IWqv_messages_read_column'], 'pn_'); ObjectUtil::addStandardFieldsToTableDataDefinition($tables['IWqv_messages_read_column_def'], 'iw_'); // IWmain table definition needed in this module $tables['IWmain'] = DBUtil::getLimitedTablename('IWmain'); $tables['IWmain_column'] = array('id' => 'iw_id', 'uid' => 'iw_uid', 'module' => 'iw_module', 'name' => 'iw_name', 'value' => 'iw_value', 'lifetime' => 'iw_lifetime'); // Return the table information return $tables; }