/**
* 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;
}
