[Sommaire] [Imprimer]

   1  <?php // $Id: createStatBase.inc.php,v 1.15 2006/10/15 20:18:34 moosh Exp $
   2  if ( count( get_included_files() ) == 1 ) die( '---' );
   3  /**
   4   * CLAROLINE
   5   *
   6   * Create Statistics Tables
   7   * @var $statsTblPrefixForm prefix set during  install, and keep in mainconf
   8   * @private $creationStatementList[] var where build sql request.
   9   *
  10   * @version 1.8 $Revision: 1.15 $
  11   *
  12   * @copyright 2001-2006 Universite catholique de Louvain (UCL)
  13   *
  14   * @license http://www.gnu.org/copyleft/gpl.html (GPL) GENERAL PUBLIC LICENSE
  15   *
  16   * @see http://www.claroline.net/wiki/index.php/Install
  17   *
  18   * @author Claro Team <cvs@claroline.net>
  19   * @author Christophe Gesché <moosh@claroline.net>
  20   *
  21   * @package INSTALL
  22   *
  23   */
  24  
  25  /*         claro_sql_query("DROP TABLE IF EXISTS track_e_default");
  26   *         claro_sql_query("DROP TABLE IF EXISTS track_e_login");
  27   *         claro_sql_query("DROP TABLE IF EXISTS track_e_open");
  28   *
  29   */
  30          $creationStatementList[] = "CREATE TABLE `".$statsTblPrefixForm."track_e_default` (
  31                    `default_id` int(11) NOT NULL auto_increment,
  32                    `default_user_id` int(11)  NOT NULL default '0',
  33                    `default_cours_code` varchar(40) NOT NULL default '',
  34                    `default_date` datetime NOT NULL default '0000-00-00 00:00:00',
  35                    `default_event_type` varchar(20) NOT NULL default '',
  36                    `default_value_type` varchar(20) NOT NULL default '',
  37                    `default_value` tinytext NOT NULL,
  38                    PRIMARY KEY  (`default_id`),
  39                    KEY `default_user_id` (`default_user_id`)
  40                  ) TYPE=MyISAM COMMENT='Use for other developpers users'";
  41  
  42          $creationStatementList[] = "CREATE TABLE `".$statsTblPrefixForm."track_e_login` (
  43                    `login_id` int(11) NOT NULL auto_increment,
  44                    `login_user_id` int(11)  NOT NULL default '0',
  45                    `login_date` datetime NOT NULL default '0000-00-00 00:00:00',
  46                    `login_ip` char(15) NOT NULL default '',
  47                    PRIMARY KEY  (`login_id`),
  48                    KEY `login_user_id` (`login_user_id`)
  49                  ) TYPE=MyISAM COMMENT='Record informations about logins'";
  50  
  51          $creationStatementList[] = "CREATE TABLE `".$statsTblPrefixForm."track_e_open` (
  52                    `open_id` int(11) NOT NULL auto_increment,
  53                    `open_date` datetime NOT NULL default '0000-00-00 00:00:00',
  54                    PRIMARY KEY  (`open_id`)
  55                  ) TYPE=MyISAM COMMENT='Record informations about software used by users'";
  56  
  57  ?>