[Sommaire] [Imprimer]

   1  <?php
   2  /* 
   3   * phpMyVisites : website statistics and audience measurements
   4   * Copyright (C) 2002 - 2006
   5   * http://www.phpmyvisites.net/ 
   6   * phpMyVisites is free software (license GNU/GPL)
   7   * Authors : phpMyVisites team
   8  */
   9  
  10  // $Id: installSql.php 215 2007-05-01 13:03:34Z matthieu_ $
  11  
  12  if(!defined("DB_TABLES_PREFIX"))
  13  {
  14      trigger_error("Error, tables name constants are not defined properly. Please go back and try to set a prefix for the tables name.", E_USER_ERROR);
  15  }
  16  
  17  $create['a_category'] = 
  18  "CREATE TABLE ".DB_TABLES_PREFIX.'a_category'." (
  19    id int(10) unsigned NOT NULL auto_increment,
  20    name varchar(100) default NULL,
  21    PRIMARY KEY  (id)
  22  ) TYPE=MyISAM
  23  ";
  24  
  25  $create['a_config'] = 
  26  "CREATE TABLE ".DB_TABLES_PREFIX.'a_config'." (
  27    id int(10) unsigned NOT NULL auto_increment,
  28    name varchar(100) default NULL,
  29    PRIMARY KEY  (id)
  30  ) TYPE=MyISAM
  31  ";
  32  
  33  
  34  $create['a_keyword'] = 
  35  "CREATE TABLE ".DB_TABLES_PREFIX.'a_keyword'." (
  36    id int(10) unsigned NOT NULL auto_increment,
  37    name text,
  38    PRIMARY KEY  (id)
  39  ) TYPE=MyISAM
  40  ";
  41  
  42  
  43  $create['a_newsletter'] = 
  44  "CREATE TABLE ".DB_TABLES_PREFIX.'a_newsletter'." (
  45    id int(11) NOT NULL auto_increment,
  46    name varchar(60) NOT NULL default '',
  47    PRIMARY KEY  (id)
  48  ) TYPE=MyISAM
  49  ";
  50  
  51  $create['a_page'] = 
  52  "CREATE TABLE ".DB_TABLES_PREFIX.'a_page'." (
  53    id int(10) unsigned NOT NULL auto_increment,
  54    name text,
  55    PRIMARY KEY  (id)
  56  ) TYPE=MyISAM
  57  ";
  58  
  59  $create['a_file'] = 
  60  "CREATE TABLE ".DB_TABLES_PREFIX.'a_file'." (
  61    id int(10) unsigned NOT NULL auto_increment,
  62    name text,
  63    PRIMARY KEY (id)
  64  ) TYPE=MyISAM
  65  ";
  66  
  67  
  68  $create['a_partner_name'] = 
  69  "CREATE TABLE ".DB_TABLES_PREFIX.'a_partner_name'." (
  70    id int(10) unsigned NOT NULL auto_increment,
  71    name varchar(100) default NULL,
  72    PRIMARY KEY  (id)
  73  ) TYPE=MyISAM
  74  ";
  75  
  76  
  77  $create['a_partner_url'] = 
  78  "CREATE TABLE ".DB_TABLES_PREFIX.'a_partner_url'." (
  79    id int(11) NOT NULL auto_increment,
  80    name text NOT NULL,
  81    PRIMARY KEY  (id)
  82  ) TYPE=MyISAM
  83  ";
  84  
  85  
  86  $create['a_provider'] = 
  87  "CREATE TABLE ".DB_TABLES_PREFIX.'a_provider'." (
  88    id int(10) unsigned NOT NULL auto_increment,
  89    name varchar(100) default NULL,
  90    PRIMARY KEY  (id),
  91    KEY name (name)
  92  ) TYPE=MyISAM
  93  ";
  94  
  95  
  96  $create['a_resolution'] = 
  97  "CREATE TABLE ".DB_TABLES_PREFIX.'a_resolution'." (
  98    id int(11) NOT NULL auto_increment,
  99    name varchar(20) NOT NULL default '',
 100    PRIMARY KEY  (id)
 101  ) TYPE=MyISAM
 102  ";
 103  
 104  
 105  $create['a_search_engine'] = 
 106  "CREATE TABLE ".DB_TABLES_PREFIX.'a_search_engine'." (
 107    id int(10) unsigned NOT NULL auto_increment,
 108    name varchar(100) default NULL,
 109    PRIMARY KEY  (id)
 110  ) TYPE=MyISAM
 111  ";
 112  
 113  
 114  $create['a_site'] = 
 115  "CREATE TABLE ".DB_TABLES_PREFIX.'a_site'." (
 116    id int(10) unsigned NOT NULL auto_increment,
 117    name text,
 118    PRIMARY KEY  (id)
 119  ) TYPE=MyISAM
 120  ";
 121  
 122  
 123  $create['a_vars_name'] = 
 124  "CREATE TABLE ".DB_TABLES_PREFIX.'a_vars_name'." (
 125    id int(11) NOT NULL auto_increment,
 126    name varchar(255) NOT NULL default '',
 127    PRIMARY KEY  (id)
 128  ) TYPE=MyISAM
 129  ";
 130  
 131  
 132  $create['a_vars_value'] = 
 133  "CREATE TABLE ".DB_TABLES_PREFIX.'a_vars_value'." (
 134    id int(11) NOT NULL auto_increment,
 135    name varchar(255) NOT NULL default '',
 136    PRIMARY KEY  (id)
 137  ) TYPE=MyISAM
 138  ";
 139  
 140  $create['archives'] = 
 141  "CREATE TABLE ".DB_TABLES_PREFIX.'archives'." (
 142    idarchives int(10) unsigned NOT NULL auto_increment,
 143    idsite int(10) unsigned NOT NULL default '0',
 144    done tinyint(4) NOT NULL default '0',
 145    period tinyint(1) NOT NULL default '0',
 146    `simple` tinyint(4) NOT NULL default '0',
 147    date1 varchar(10) NOT NULL default '00:00:00',
 148    date2 varchar(10) NOT NULL default '00:00:00',
 149    nb_uniq_vis mediumint(8) unsigned NOT NULL default '0',
 150    nb_vis mediumint(8) unsigned NOT NULL default '0',
 151    nb_vis_returning int(8) NOT NULL default '0',
 152    nb_uniq_vis_returning int(11) NOT NULL default '0',
 153    nb_pag mediumint(8) unsigned NOT NULL default '0',
 154    nb_pag_returning int(8) NOT NULL default '0',
 155    nb_uniq_pag smallint(5) unsigned NOT NULL default '0',
 156    nb_max_pag smallint(5) unsigned NOT NULL default '0',
 157    nb_vis_1pag mediumint(8) unsigned NOT NULL default '0',
 158    nb_vis_1pag_returning mediumint(8) NOT NULL default '0',
 159    sum_vis_lth int(10) unsigned NOT NULL default '0',
 160    sum_vis_lth_returning int(10) NOT NULL default '0',
 161    nb_direct mediumint(8) unsigned NOT NULL default '0',
 162    nb_search_engine mediumint(8) unsigned NOT NULL default '0',
 163    nb_site mediumint(8) unsigned NOT NULL default '0',
 164    nb_newsletter mediumint(8) unsigned NOT NULL default '0',
 165    nb_partner mediumint(8) unsigned NOT NULL default '0',
 166    vis_period longblob,
 167    vis_nb_vis blob,
 168    vis_st blob,
 169    vis_lt blob,
 170    pag_st blob,
 171    pag_lt blob,
 172    vis_lth blob,
 173    vis_nb_pag blob,
 174    vis_pag_grp longblob,
 175    vis_country blob,
 176    vis_continent blob,
 177    vis_provider longblob,
 178    vis_config longblob,
 179    vis_os blob,
 180    vis_browser blob,
 181    vis_browser_type blob,
 182    vis_resolution longblob,
 183    vis_plugin blob,
 184    vis_search_engine longblob,
 185    vis_keyword longblob,
 186    vis_site longblob,
 187    vis_partner longblob,
 188    vis_newsletter longblob,
 189    int_lt blob,
 190    int_st blob,
 191    int_referer_type longblob,
 192    int_search_engine longblob,
 193    int_keyword longblob,
 194    int_site longblob,
 195    int_partner longblob,
 196    int_newsletter longblob,
 197    int_country longblob,
 198    int_continent longblob,
 199    int_config longblob,
 200    int_os longblob,
 201    int_browser longblob,
 202    int_resolution longblob,
 203    `compressed` tinyint(4) NOT NULL default '0',
 204    PRIMARY KEY  (idarchives),
 205    KEY pmvindex1 (idsite),
 206    KEY pmvindex2 (done)
 207  ) TYPE=MyISAM
 208  ";
 209  
 210  
 211  $create['category'] = 
 212  "CREATE TABLE ".DB_TABLES_PREFIX.'category'." (
 213    idcategory int(10) unsigned NOT NULL auto_increment,
 214    complete_name varchar(255) NOT NULL default '',
 215    name varchar(100) default NULL,
 216    level smallint(5) unsigned NOT NULL default '0',
 217    idparent smallint(5) unsigned NOT NULL default '0',
 218    PRIMARY KEY  (idcategory)
 219  ) TYPE=MyISAM
 220  ";
 221  
 222  
 223  $create['ip_ignore'] = 
 224  "CREATE TABLE ".DB_TABLES_PREFIX.'ip_ignore'." (
 225    idip_ignore int(10) unsigned NOT NULL auto_increment,
 226    idsite int(10) unsigned NOT NULL default '0',
 227    ip_min bigint(11) default NULL,
 228    ip_max bigint(11) default NULL,
 229    PRIMARY KEY  (idip_ignore),
 230    KEY pmvindex (idsite)
 231  ) TYPE=MyISAM
 232  ";
 233  
 234  
 235  $create['link_vp'] = 
 236  "CREATE TABLE ".DB_TABLES_PREFIX.'link_vp'." (
 237    idlink_vp int(11) NOT NULL auto_increment,
 238    idvisit int(10) unsigned NOT NULL default '0',
 239    idpage int(10) unsigned NOT NULL default '0',
 240    idpage_ref int(11) unsigned NOT NULL default '0',
 241    total_time_page_ref int(10) unsigned default NULL,
 242    PRIMARY KEY  (idlink_vp),
 243    KEY pmvindex (idvisit,idpage)
 244  ) TYPE=MyISAM
 245  ";
 246  
 247  
 248  $create['link_vpv'] = 
 249  "CREATE TABLE ".DB_TABLES_PREFIX.'link_vpv'." (
 250    idlink_vp int(11) NOT NULL default '0',
 251    idvars int(11) NOT NULL default '0',
 252    PRIMARY KEY  (idlink_vp,idvars)
 253  ) TYPE=MyISAM
 254  ";
 255  
 256  
 257  $create['newsletter'] = 
 258  "CREATE TABLE ".DB_TABLES_PREFIX.'newsletter'." (
 259    idnewsletter int(10) unsigned NOT NULL auto_increment,
 260    idsite int(10) unsigned NOT NULL default '0',
 261    name varchar(90) default NULL,
 262    PRIMARY KEY  (idnewsletter),
 263    KEY pmvindex (idsite)
 264  ) TYPE=MyISAM
 265  ";
 266  
 267  
 268  $create['page'] = 
 269  "CREATE TABLE ".DB_TABLES_PREFIX.'page'." (
 270    idpage int(10) unsigned NOT NULL auto_increment,
 271    idcategory int(10) unsigned NOT NULL default '0',
 272    name varchar(255) default NULL,
 273    PRIMARY KEY  (idpage),
 274    KEY pmvindex (idcategory)
 275  ) TYPE=MyISAM
 276  ";
 277  
 278  $create['page_md5url'] = 
 279  "CREATE TABLE ".DB_TABLES_PREFIX.'page_md5url'." (
 280    idpage_md5url int(10) unsigned NOT NULL auto_increment,
 281    idpage int(10) unsigned NOT NULL default '0',
 282    md5url char(32) default NULL,
 283    idpage_url int(11) unsigned NOT NULL default '0',
 284    PRIMARY KEY  (idpage_md5url),
 285    KEY idpage (idpage),
 286    KEY url (md5url)
 287  ) TYPE=MyISAM 
 288  ";
 289  
 290  $create['page_url'] = 
 291  "CREATE TABLE ".DB_TABLES_PREFIX.'page_url'." (
 292    idpage_url int(10) unsigned NOT NULL auto_increment,
 293    url text,
 294    PRIMARY KEY  (idpage_url)
 295  ) TYPE=MyISAM
 296  ";
 297  
 298  
 299  
 300  $create['query_log'] = 
 301  "CREATE TABLE ".DB_TABLES_PREFIX.'query_log'." (
 302    idquery_log int(11) NOT NULL auto_increment,
 303    idsite int(11) NOT NULL default '0',
 304    query smallint(6) NOT NULL default '0',
 305    time float NOT NULL default '0',
 306    date date NOT NULL default '0000-00-00',
 307    daytime time NOT NULL default '00:00:00',
 308    PRIMARY KEY  (idquery_log)
 309  ) TYPE=MyISAM
 310  ";
 311  
 312  
 313  $create['site'] = 
 314  "CREATE TABLE ".DB_TABLES_PREFIX.'site'." (
 315    idsite int(10) unsigned NOT NULL auto_increment,
 316    name varchar(90) default NULL,
 317    logo varchar(15) default NULL,
 318    params_choice varchar(6) NOT NULL default 'all',
 319    params_names varchar(255) NOT NULL default '',
 320    idpdf int(10) NOT NULL default '-1' ,
 321    path_theme varchar(255) NOT NULL default 'default' ,
 322    PRIMARY KEY  (idsite)
 323  ) TYPE=MyISAM
 324  ";
 325  
 326  
 327  $create['site_partner'] = 
 328  "CREATE TABLE ".DB_TABLES_PREFIX.'site_partner'." (
 329    idsite_partner int(10) unsigned NOT NULL auto_increment,
 330    idsite int(10) unsigned NOT NULL default '0',
 331    name varchar(90) default NULL,
 332    PRIMARY KEY  (idsite_partner),
 333    KEY pmvindex (idsite)
 334  ) TYPE=MyISAM
 335  ";
 336  
 337  
 338  $create['site_partner_url'] = 
 339  "CREATE TABLE ".DB_TABLES_PREFIX.'site_partner_url'." (
 340    idsite_partner_url int(10) unsigned NOT NULL auto_increment,
 341    idsite_partner int(10) unsigned NOT NULL default '0',
 342    url varchar(200) default NULL,
 343    PRIMARY KEY  (idsite_partner_url)
 344  ) TYPE=MyISAM
 345  ";
 346  
 347  
 348  $create['site_url'] = 
 349  "CREATE TABLE ".DB_TABLES_PREFIX.'site_url'." (
 350    idsite_url int(10) unsigned NOT NULL auto_increment,
 351    idsite int(10) unsigned NOT NULL default '0',
 352    url varchar(255) default NULL,
 353    PRIMARY KEY  (idsite_url),
 354    KEY pmvindex (idsite)
 355  ) TYPE=MyISAM
 356  ";
 357  
 358  
 359  $create['vars'] = 
 360  "CREATE TABLE ".DB_TABLES_PREFIX.'vars'." (
 361    idvars int(10) unsigned NOT NULL auto_increment,
 362    name varchar(255) NOT NULL default '',
 363    int_value int(10) default NULL,
 364    varchar_value varchar(255) default NULL,
 365    PRIMARY KEY  (idvars),
 366    KEY pmvindex (name)
 367  ) TYPE=MyISAM
 368  ";
 369  
 370  
 371  $create['version'] = 
 372  "CREATE TABLE ".DB_TABLES_PREFIX.'version'." (
 373    `version` varchar(255) NOT NULL default ''
 374  ) TYPE=MyISAM
 375  ";
 376  
 377  
 378  $create['visit'] = 
 379  "CREATE TABLE ".DB_TABLES_PREFIX.'visit'." (
 380    idvisit int(10) unsigned NOT NULL auto_increment,
 381    idsite int(10) unsigned NOT NULL default '0',
 382    idcookie varchar(32) default NULL,
 383    returning tinyint(1) NOT NULL default '0',
 384    last_visit_time time NOT NULL default '00:00:00',
 385    server_date date default NULL,
 386    server_time time NOT NULL default '00:00:00',
 387    referer text,
 388    os char(3) default NULL,
 389    browser_name varchar(10) NOT NULL default '',
 390    browser_version varchar(20) NOT NULL default '',
 391    resolution varchar(9) default NULL,
 392    color_depth tinyint(2) unsigned default NULL,
 393    pdf tinyint(1) NOT NULL default '0',
 394    flash tinyint(1) NOT NULL default '0',
 395    java tinyint(1) NOT NULL default '0',
 396    javascript tinyint(1) NOT NULL default '0',
 397    director tinyint(1) NOT NULL default '0',
 398    quicktime tinyint(1) NOT NULL default '0',
 399    realplayer tinyint(1) NOT NULL default '0',
 400    windowsmedia tinyint(1) NOT NULL default '0',
 401    cookie tinyint(1) NOT NULL default '0',
 402    local_time time NOT NULL default '00:00:00',
 403    ip int(10) default NULL,
 404    hostname_ext varchar(100) default NULL,
 405    browser_lang varchar(60) default NULL,
 406    total_pages smallint(5) unsigned default NULL,
 407    total_time smallint(5) unsigned default NULL,
 408    country char(3) default NULL,
 409    continent char(3) default NULL,
 410    exit_idpage int(11) NOT NULL default '0',
 411    entry_idpage int(11) NOT NULL default '0',
 412    entry_idpageurl int(11) NOT NULL default '0',
 413    md5config varchar(32) NOT NULL default '',
 414    PRIMARY KEY  (idvisit),
 415    KEY idsite (idsite),
 416    KEY server_date (server_date),
 417    KEY md5config (md5config)
 418  ) TYPE=MyISAM 
 419  ";
 420  
 421  
 422  $create['groups'] = 
 423  "CREATE TABLE ".DB_TABLES_PREFIX.'groups'." (
 424    `idgroups` int(10) unsigned NOT NULL auto_increment,
 425    `name` varchar(40) default NULL,
 426    `view` tinyint(1) unsigned default '0',
 427    `admin` tinyint(3) unsigned default '0',
 428    PRIMARY KEY  (`idgroups`)
 429  ) TYPE=MyISAM
 430  ";
 431  
 432  
 433  $create['users'] = 
 434  "CREATE TABLE ".DB_TABLES_PREFIX.'users'." (
 435    `login` varchar(20) NOT NULL default '',
 436    `password` varchar(255) default NULL,
 437    `alias` varchar(45) default NULL,
 438    `email` varchar(100) NOT NULL default '',
 439    `send_mail` int( 10 ) default NULL,
 440    `rss_hash` varchar(100) NOT NULL default '',
 441    `date_registered` int(11) default NULL,
 442    PRIMARY KEY  (`login`)
 443  ) TYPE=MyISAM
 444  ";
 445  
 446  
 447  
 448  $create['users_link_groups'] = 
 449  "CREATE TABLE ".DB_TABLES_PREFIX.'users_link_groups'." (
 450    `idsite` int(10) unsigned NOT NULL default '0',
 451    `idgroups` int(10) unsigned NOT NULL default '0',
 452    `login` varchar(20) NOT NULL default '0',
 453    PRIMARY KEY  (`idsite`,`idgroups`,`login`)
 454  ) TYPE=MyISAM
 455  ";
 456  
 457  $create['pdf_config'] = 
 458  "CREATE TABLE ".DB_TABLES_PREFIX.'pdf_config'." (
 459    idpdf int(10) unsigned NOT NULL auto_increment,
 460    name_pdf varchar(90) default NULL,
 461    params_pdf longblob,
 462    PRIMARY KEY  (idpdf)
 463  ) TYPE=MyISAM
 464  ";
 465  
 466  $create['pdf_site_user'] = 
 467  "CREATE TABLE ".DB_TABLES_PREFIX.'pdf_site_user'." (
 468    `idsite` int(10) unsigned NOT NULL default '0',
 469    `login` varchar(20) NOT NULL default '0',
 470    `idpdf` int(10) unsigned NOT NULL,
 471    PRIMARY KEY  (`idsite`,`login`,`idpdf`)
 472  ) TYPE=MyISAM
 473  ";
 474  
 475  $create['plugin_version'] = 
 476  "CREATE TABLE ".DB_TABLES_PREFIX.'plugin_version'." (
 477    `code` varchar(255) NOT NULL,
 478    `version` varchar(255) NOT NULL,
 479    PRIMARY KEY  (code)
 480  ) TYPE=MyISAM
 481  ";
 482  
 483  $createRecords[] = 
 484      "INSERT INTO ".DB_TABLES_PREFIX.'groups'." VALUES (1, 'admin', 1, 1)"
 485  ;
 486  
 487  $createRecords[] = 
 488      "INSERT INTO ".DB_TABLES_PREFIX.'groups'." VALUES (2, 'view', 1, 0)"
 489  ;
 490  
 491  $createRecords[] = 
 492      "INSERT INTO ".DB_TABLES_PREFIX.'users'." VALUES ('anonymous', NULL, 'Anonymous user', '', 0, 'ffffffffffffff493e8d55a4a75de3f90a1', NULL)"
 493      ;
 494      
 495  $createRecords[] = 
 496      "INSERT INTO ".DB_TABLES_PREFIX.'version'." VALUES ( '".PHPMV_VERSION."')"
 497      ;
 498  
 499  
 500  ?>