PHP DBUtil::getLimitedTablename方法代码示例

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