[Sommaire] [Imprimer]

   1  <?php
   2  
   3  if (isset($CMS_INSTALL_DROP_TABLES)) {
   4  
   5      $db->DropSequence($db_prefix."additional_htmlblob_users_seq");
   6      $db->DropSequence($db_prefix."additional_users_seq");
   7      $db->DropSequence($db_prefix."admin_bookmarks_seq");
   8      $db->DropSequence($db_prefix."admin_recent_pages_seq");
   9      $db->DropSequence($db_prefix."additional_users_seq");
  10      $db->DropSequence($db_prefix."content_seq");
  11      $db->DropSequence($db_prefix."content_props_seq");
  12      $db->DropSequence($db_prefix."css_seq");
  13      $db->DropSequence($db_prefix."events_seq");
  14      $db->DropSequence($db_prefix."event_handler_seq");
  15      $db->DropSequence($db_prefix."group_perms_seq");
  16      $db->DropSequence($db_prefix."groups_seq");
  17      $db->DropSequence($db_prefix."htmlblobs_seq");
  18      $db->DropSequence($db_prefix."module_deps_seq");
  19      $db->DropSequence($db_prefix."module_templates_seq");
  20      $db->DropSequence($db_prefix."permissions_seq");
  21      $db->DropSequence($db_prefix."templates_seq");
  22      #$db->DropSequence($db_prefix."sequence_seq");
  23      $db->DropSequence($db_prefix."users_seq");
  24      $db->DropSequence($db_prefix."userplugins_seq");
  25  
  26      $dbdict = NewDataDictionary($db);
  27  
  28      $sqlarray = $dbdict->DropIndexSQL("idx_template_id_modified_date");
  29      $dbdict->ExecuteSQLArray($sqlarray);
  30  
  31      $sqlarray = $dbdict->DropTableSQL($db_prefix."additional_users");
  32      $dbdict->ExecuteSQLArray($sqlarray);
  33      $sqlarray = $dbdict->DropTableSQL($db_prefix."additional_htmlblob_users");
  34      $dbdict->ExecuteSQLArray($sqlarray);
  35      $sqlarray = $dbdict->DropTableSQL($db_prefix."adminlog");
  36      $dbdict->ExecuteSQLArray($sqlarray);
  37      $sqlarray = $dbdict->DropTableSQL($db_prefix."admin_bookmarks");
  38      $dbdict->ExecuteSQLArray($sqlarray);
  39      $sqlarray = $dbdict->DropTableSQL($db_prefix."admin_recent_pages");
  40      $dbdict->ExecuteSQLArray($sqlarray);
  41      $sqlarray = $dbdict->DropTableSQL($db_prefix."content");
  42      $dbdict->ExecuteSQLArray($sqlarray);
  43      $sqlarray = $dbdict->DropTableSQL($db_prefix."content_props");
  44      $dbdict->ExecuteSQLArray($sqlarray);
  45      $sqlarray = $dbdict->DropTableSQL($db_prefix."crossref");
  46      $dbdict->ExecuteSQLArray($sqlarray);
  47      $sqlarray = $dbdict->DropTableSQL($db_prefix."css");
  48      $dbdict->ExecuteSQLArray($sqlarray);
  49      $sqlarray = $dbdict->DropTableSQL($db_prefix."css_assoc");
  50      $dbdict->ExecuteSQLArray($sqlarray);
  51      $sqlarray = $dbdict->DropTableSQL($db_prefix."events");
  52      $dbdict->ExecuteSQLArray($sqlarray);
  53      $sqlarray = $dbdict->DropTableSQL($db_prefix."event_handlers");
  54      $dbdict->ExecuteSQLArray($sqlarray);
  55      $sqlarray = $dbdict->DropTableSQL($db_prefix."group_perms");
  56      $dbdict->ExecuteSQLArray($sqlarray);
  57      $sqlarray = $dbdict->DropTableSQL($db_prefix."groups");
  58      $dbdict->ExecuteSQLArray($sqlarray);
  59      $sqlarray = $dbdict->DropTableSQL($db_prefix."htmlblobs");
  60      $dbdict->ExecuteSQLArray($sqlarray);
  61      $sqlarray = $dbdict->DropTableSQL($db_prefix."modules");
  62      $dbdict->ExecuteSQLArray($sqlarray);
  63      $sqlarray = $dbdict->DropTableSQL($db_prefix."module_deps");
  64      $dbdict->ExecuteSQLArray($sqlarray);
  65      $sqlarray = $dbdict->DropTableSQL($db_prefix."module_templates");
  66      $dbdict->ExecuteSQLArray($sqlarray);
  67      $sqlarray = $dbdict->DropTableSQL($db_prefix."permissions");
  68      $dbdict->ExecuteSQLArray($sqlarray);
  69      $sqlarray = $dbdict->DropTableSQL($db_prefix."siteprefs");
  70      $dbdict->ExecuteSQLArray($sqlarray);
  71      $sqlarray = $dbdict->DropTableSQL($db_prefix."templates");
  72      $dbdict->ExecuteSQLArray($sqlarray);
  73      #$sqlarray = $dbdict->DropTableSQL($db_prefix."sequence");
  74      #$dbdict->ExecuteSQLArray($sqlarray);
  75      $sqlarray = $dbdict->DropTableSQL($db_prefix."user_groups");
  76      $dbdict->ExecuteSQLArray($sqlarray);
  77      $sqlarray = $dbdict->DropTableSQL($db_prefix."userprefs");
  78      $dbdict->ExecuteSQLArray($sqlarray);
  79      $sqlarray = $dbdict->DropTableSQL($db_prefix."users");
  80      $dbdict->ExecuteSQLArray($sqlarray);
  81      $sqlarray = $dbdict->DropTableSQL($db_prefix."userplugins");
  82      $dbdict->ExecuteSQLArray($sqlarray);
  83      $sqlarray = $dbdict->DropTableSQL($db_prefix."version");
  84      $dbdict->ExecuteSQLArray($sqlarray);
  85  
  86  }
  87  
  88  if (isset($CMS_INSTALL_CREATE_TABLES)) {
  89  
  90      echo "<p>Creating additional_users table...";
  91  
  92      $dbdict = NewDataDictionary($db);
  93      $flds = "
  94          additional_users_id I KEY,
  95          user_id I,
  96          page_id I,
  97          content_id I
  98      ";
  99      $taboptarray = array('mysql' => 'TYPE=MyISAM');
 100      $sqlarray = $dbdict->CreateTableSQL($db_prefix."additional_users", $flds, $taboptarray);
 101      $dbdict->ExecuteSQLArray($sqlarray);
 102  
 103      echo "[done]</p>";
 104  
 105      echo "<p>Adding admin_bookmarks table...";
 106  
 107      $dbdict = NewDataDictionary($db);
 108      $flds = "
 109          bookmark_id I KEY,
 110          user_id I,
 111          title C(255),
 112          url C(255)
 113      ";
 114      $taboptarray = array('mysql' => 'TYPE=MyISAM');
 115      $sqlarray = $dbdict->CreateTableSQL($db_prefix."admin_bookmarks", $flds, $taboptarray);
 116      $dbdict->ExecuteSQLArray($sqlarray);
 117  
 118      $db->Execute("ALTER TABLE ".$db_prefix."admin_bookmarks ADD INDEX (user_id)");
 119  
 120      echo '[done]</p>';
 121  
 122      echo "<p>Creating adminlog table...";
 123  
 124      $dbdict = NewDataDictionary($db);
 125      $flds = "
 126          timestamp I,
 127          user_id I,
 128          username C(25),
 129          item_id I,
 130          item_name C(50),
 131          action C(255)
 132      ";
 133      $taboptarray = array('mysql' => 'TYPE=MyISAM');
 134      $sqlarray = $dbdict->CreateTableSQL($db_prefix."adminlog", $flds, $taboptarray);
 135      $dbdict->ExecuteSQLArray($sqlarray);
 136  
 137      echo "[done]</p>";
 138  
 139      echo "<p>Adding admin_recent_pages table...";
 140  
 141      $dbdict = NewDataDictionary($db);
 142      $flds = "
 143          id I KEY,
 144          user_id I,
 145          title C(255),
 146          url C(255),
 147          access_time DT
 148      ";
 149      $taboptarray = array('mysql' => 'TYPE=MyISAM');
 150      $sqlarray = $dbdict->CreateTableSQL($db_prefix."admin_recent_pages", $flds, $taboptarray);
 151      $dbdict->ExecuteSQLArray($sqlarray);
 152  
 153      echo '[done]</p>';
 154  
 155      echo "<p>Creating content table...";
 156  
 157      $dbdict = NewDataDictionary($db);
 158      $flds = "
 159          content_id I KEY,
 160          content_name C(255),
 161          type C(25),
 162          owner_id I,
 163          parent_id I,
 164          template_id I,
 165          item_order I,
 166          hierarchy C(255),
 167          default_content I1,
 168          menu_text C(255),
 169          content_alias C(255),
 170          show_in_menu I1,
 171          collapsed I1,
 172          markup C(25),
 173          active I1,
 174          cachable I1,
 175          id_hierarchy C(255),
 176          hierarchy_path X,
 177          prop_names X,
 178          metadata X,
 179          titleattribute C(255),
 180          tabindex C(10),
 181          accesskey C(5),
 182          last_modified_by I,
 183          create_date DT,
 184          modified_date DT
 185      ";
 186      $taboptarray = array('mysql' => 'TYPE=MyISAM');
 187      $sqlarray = $dbdict->CreateTableSQL($db_prefix."content", $flds, $taboptarray);
 188      $dbdict->ExecuteSQLArray($sqlarray);
 189  
 190      $db->Execute("ALTER TABLE ".$db_prefix."content ADD INDEX (content_alias, active)");
 191      $db->Execute("ALTER TABLE ".$db_prefix."content ADD INDEX (default_content)");
 192      $db->Execute("ALTER TABLE ".$db_prefix."content ADD INDEX (parent_id)");
 193  
 194      echo "[done]</p>";
 195  
 196      echo "<p>Creating content_props table...";
 197  
 198      $dbdict = NewDataDictionary($db);
 199      $flds = "
 200          content_id I,
 201          type C(25),
 202          prop_name C(255),
 203          param1 C(255),
 204          param2 C(255),
 205          param3 C(255),
 206          content X,
 207          create_date DT,
 208          modified_date DT
 209      ";
 210      $taboptarray = array('mysql' => 'TYPE=MyISAM');
 211      $sqlarray = $dbdict->CreateTableSQL($db_prefix."content_props", $flds, $taboptarray);
 212      $dbdict->ExecuteSQLArray($sqlarray);
 213  
 214      $db->Execute("ALTER TABLE ".$db_prefix."content_props ADD INDEX (content_id)");
 215  
 216      echo "[done]</p>";
 217      
 218      echo "<p>Adding crossref table...";
 219  
 220      $dbdict = NewDataDictionary($db);
 221      $flds = '
 222          child_type C(100),
 223          child_id I,
 224          parent_type C(100),
 225          parent_id I,
 226          create_date DT,
 227          modified_date DT
 228      ';
 229  
 230      $taboptarray = array('mysql' => 'TYPE=MyISAM');
 231      $sqlarray = $dbdict->CreateTableSQL($db_prefix."crossref", $flds, $taboptarray);
 232      $dbdict->ExecuteSQLArray($sqlarray);
 233  
 234      $db->Execute("ALTER TABLE ".$db_prefix."crossref ADD INDEX (child_type, child_id)");
 235      $db->Execute("ALTER TABLE ".$db_prefix."crossref ADD INDEX (parent_type, parent_id)");
 236  
 237      echo '[done]</p>';
 238  
 239      echo "<p>Creating css table...";
 240  
 241      $dbdict = NewDataDictionary($db);
 242      $flds = "
 243          css_id I KEY,
 244          css_name C(255),
 245          css_text X,
 246          media_type C(255),
 247          create_date DT,
 248          modified_date DT
 249      ";
 250      $taboptarray = array('mysql' => 'TYPE=MyISAM');
 251      $sqlarray = $dbdict->CreateTableSQL($db_prefix."css", $flds, $taboptarray);
 252      $dbdict->ExecuteSQLArray($sqlarray);
 253  
 254      $db->Execute("ALTER TABLE ".$db_prefix."css ADD INDEX (css_name)");
 255  
 256      echo "[done]</p>";
 257  
 258      echo "<p>Creating css_assoc table...";
 259  
 260      $dbdict = NewDataDictionary($db);
 261      $flds = "
 262          assoc_to_id I,
 263          assoc_css_id I,
 264          assoc_type C(80),
 265          create_date DT,
 266          modified_date DT
 267      ";
 268      $taboptarray = array('mysql' => 'TYPE=MyISAM');
 269      $sqlarray = $dbdict->CreateTableSQL($db_prefix."css_assoc", $flds, $taboptarray);
 270      $dbdict->ExecuteSQLArray($sqlarray);
 271  
 272      $db->Execute("ALTER TABLE ".$db_prefix."css_assoc ADD INDEX (assoc_to_id)");
 273      $db->Execute("ALTER TABLE ".$db_prefix."css_assoc ADD INDEX (assoc_css_id)");
 274  
 275      echo "[done]</p>";
 276      
 277      echo "<p>Creating event_handlers table...";
 278  
 279      $dbdict = NewDataDictionary($db);
 280  
 281      $flds = "
 282                event_id      I,
 283                tag_name      c(255),
 284                module_name   c(255),
 285                removable     I,
 286                handler_order I,
 287                handler_id    I KEY
 288              ";
 289  
 290      $taboptarray = array('mysql' => 'TYPE=MyISAM');
 291      $sqlarray = $dbdict->CreateTableSQL($db_prefix."event_handlers", $flds, $taboptarray);
 292      $dbdict->ExecuteSQLArray($sqlarray);
 293      
 294      echo "[done]</p>";
 295      
 296      echo "<p>Creating events table...";
 297  
 298      $flds = "
 299                originator   c(200) NOTNULL,
 300                event_name   c(200) NOTNULL,
 301                event_id     I KEY
 302              ";
 303  
 304      $taboptarray = array('mysql' => 'TYPE=MyISAM');
 305      $sqlarray = $dbdict->CreateTableSQL($db_prefix."events", $flds, $taboptarray);
 306      $dbdict->ExecuteSQLArray($sqlarray);
 307      
 308      $sqlarray = $dbdict->CreateIndexSQL('originator', $db_prefix."events", 'originator');
 309      $dbdict->ExecuteSQLArray($sqlarray);
 310      
 311      $sqlarray = $dbdict->CreateIndexSQL('event_name', $db_prefix."events", 'event_name');
 312      $dbdict->ExecuteSQLArray($sqlarray);
 313      
 314      echo "[done]</p>";
 315      
 316      echo "<p>Creating group_perms table...";
 317  
 318      $dbdict = NewDataDictionary($db);
 319      $flds = "
 320          group_perm_id I KEY,
 321          group_id I,
 322          permission_id I,
 323          create_date DT,
 324          modified_date DT
 325      ";
 326      $taboptarray = array('mysql' => 'TYPE=MyISAM');
 327      $sqlarray = $dbdict->CreateTableSQL($db_prefix."group_perms", $flds, $taboptarray);
 328      $dbdict->ExecuteSQLArray($sqlarray);
 329  
 330      $db->Execute("ALTER TABLE ".$db_prefix."group_perms ADD INDEX (group_id, permission_id)");
 331  
 332      echo "[done]</p>";
 333  
 334      echo "<p>Creating groups table...";
 335  
 336      $dbdict = NewDataDictionary($db);
 337      $flds = "
 338          group_id I KEY,
 339          group_name C(25),
 340          active I1,
 341          create_date DT,
 342          modified_date DT
 343      ";
 344      $taboptarray = array('mysql' => 'TYPE=MyISAM');
 345      $sqlarray = $dbdict->CreateTableSQL($db_prefix."groups", $flds, $taboptarray);
 346      $dbdict->ExecuteSQLArray($sqlarray);
 347  
 348      echo "[done]</p>";
 349  
 350      echo "<p>Creating htmlblobs table...";
 351  
 352      $dbdict = NewDataDictionary($db);
 353      $flds = "
 354          htmlblob_id I KEY,
 355          htmlblob_name C(255),
 356          html X,
 357          owner I,
 358          create_date DT,
 359          modified_date DT
 360      ";
 361      $taboptarray = array('mysql' => 'TYPE=MyISAM');
 362      $sqlarray = $dbdict->CreateTableSQL($db_prefix."htmlblobs", $flds, $taboptarray);
 363      $dbdict->ExecuteSQLArray($sqlarray);
 364  
 365      $db->Execute("ALTER TABLE ".$db_prefix."htmlblobs ADD INDEX (htmlblob_name)");
 366  
 367      echo "[done]</p>";
 368  
 369      echo "<p>Creating additional_htmlblob_users table...";
 370  
 371      $dbdict = NewDataDictionary($db);
 372      $flds = "
 373          additional_htmlblob_users_id I KEY,
 374          user_id I,
 375          htmlblob_id I
 376      ";
 377      $taboptarray = array('mysql' => 'TYPE=MyISAM');
 378      $sqlarray = $dbdict->CreateTableSQL($db_prefix."additional_htmlblob_users", $flds, $taboptarray);
 379      $dbdict->ExecuteSQLArray($sqlarray);
 380  
 381      echo "[done]</p>";
 382  
 383      echo "<p>Creating modules table...";
 384  
 385      $dbdict = NewDataDictionary($db);
 386      $flds = "
 387          module_name C(255),
 388          status C(255),
 389          version C(255),
 390          admin_only I1 DEFAULT 0,
 391          active I1
 392      ";
 393      $taboptarray = array('mysql' => 'TYPE=MyISAM');
 394      $sqlarray = $dbdict->CreateTableSQL($db_prefix."modules", $flds, $taboptarray);
 395      $dbdict->ExecuteSQLArray($sqlarray);
 396  
 397      $db->Execute("ALTER TABLE ".$db_prefix."modules ADD INDEX (module_name)");
 398  
 399      echo "[done]</p>";
 400  
 401      echo '<p>Creating module_deps table...';
 402  
 403      $dbdict = NewDataDictionary($db);
 404      $flds = "
 405          parent_module C(25),
 406          child_module C(25),
 407          minimum_version C(25),
 408          create_date DT,
 409          modified_date DT
 410      ";
 411      $taboptarray = array('mysql' => 'TYPE=MyISAM');
 412      $sqlarray = $dbdict->CreateTableSQL($db_prefix."module_deps", $flds, $taboptarray);
 413      $dbdict->ExecuteSQLArray($sqlarray);
 414  
 415      echo '[done]</p>';
 416  
 417      echo "<p>Adding module_templates table...";
 418  
 419      $dbdict = NewDataDictionary($db);
 420      $flds = "
 421          module_name C(200),
 422          template_name C(200),
 423          content X,
 424          create_date DT,
 425          modified_date DT
 426      ";
 427      $taboptarray = array('mysql' => 'TYPE=MyISAM');
 428      $sqlarray = $dbdict->CreateTableSQL($db_prefix."module_templates", $flds, $taboptarray);
 429      $dbdict->ExecuteSQLArray($sqlarray);
 430  
 431      $db->Execute("ALTER TABLE ".$db_prefix."module_templates ADD INDEX (module_name, template_name)");
 432  
 433      echo "[done]</p>";
 434  
 435      echo "<p>Creating permissions table...";
 436  
 437      $dbdict = NewDataDictionary($db);
 438      $flds = "
 439          permission_id I KEY,
 440          permission_name C(255),
 441          permission_text C(255),
 442          create_date DT,
 443          modified_date DT
 444      ";
 445      $taboptarray = array('mysql' => 'TYPE=MyISAM');
 446      $sqlarray = $dbdict->CreateTableSQL($db_prefix."permissions", $flds, $taboptarray);
 447      $dbdict->ExecuteSQLArray($sqlarray);
 448  
 449      echo "[done]</p>";
 450  
 451      echo "<p>Creating siteprefs table...";
 452  
 453      $dbdict = NewDataDictionary($db);
 454      $flds = "
 455          sitepref_name C(255) KEY,
 456          sitepref_value text,
 457          create_date DT,
 458          modified_date DT
 459      ";
 460      $taboptarray = array('mysql' => 'TYPE=MyISAM');
 461      $sqlarray = $dbdict->CreateTableSQL($db_prefix."siteprefs", $flds, $taboptarray);
 462      $dbdict->ExecuteSQLArray($sqlarray);
 463  
 464      echo "[done]</p>";
 465  
 466      echo "<p>Creating templates table...";
 467  
 468      $dbdict = NewDataDictionary($db);
 469      $flds = "
 470          template_id I KEY,
 471          template_name C(255),
 472          template_content X,
 473          stylesheet X,
 474          encoding C(25),
 475          active I1,
 476          default_template I1,
 477          create_date DT,
 478          modified_date DT
 479      ";
 480      $taboptarray = array('mysql' => 'TYPE=MyISAM');
 481      $sqlarray = $dbdict->CreateTableSQL($db_prefix."templates", $flds, $taboptarray);
 482      $dbdict->ExecuteSQLArray($sqlarray);
 483  
 484      $db->Execute("ALTER TABLE ".$db_prefix."templates ADD INDEX (template_name)");
 485  
 486      echo "[done]</p>";
 487  
 488      echo "<p>Creating user_groups table...";
 489  
 490      $dbdict = NewDataDictionary($db);
 491      $flds = "
 492          group_id I,
 493          user_id I,
 494          create_date DT,
 495          modified_date DT
 496      ";
 497      $taboptarray = array('mysql' => 'TYPE=MyISAM');
 498      $sqlarray = $dbdict->CreateTableSQL($db_prefix."user_groups", $flds, $taboptarray);
 499      $dbdict->ExecuteSQLArray($sqlarray);
 500  
 501      echo "[done]</p>";
 502  
 503      echo "<p>Creating userprefs table...";
 504  
 505      $dbdict = NewDataDictionary($db);
 506      $flds = "
 507          user_id I,
 508          preference C(50),
 509          value X,
 510          type C(25)
 511      ";
 512      $taboptarray = array('mysql' => 'TYPE=MyISAM');
 513      $sqlarray = $dbdict->CreateTableSQL($db_prefix."userprefs", $flds, $taboptarray);
 514      $dbdict->ExecuteSQLArray($sqlarray);
 515  
 516      $db->Execute("ALTER TABLE ".$db_prefix."userprefs ADD INDEX (user_id)");
 517  
 518      echo "[done]</p>";
 519  
 520      echo "<p>Creating users table...";
 521  
 522      $dbdict = NewDataDictionary($db);
 523      $flds = "
 524          user_id I KEY,
 525          username C(25),
 526          password C(40),
 527          admin_access I1,
 528          first_name C(50),
 529          last_name C(50),
 530          email C(255),
 531          active I1,
 532          create_date DT,
 533          modified_date DT
 534      ";
 535      $taboptarray = array('mysql' => 'TYPE=MyISAM');
 536      $sqlarray = $dbdict->CreateTableSQL($db_prefix."users", $flds, $taboptarray);
 537      $dbdict->ExecuteSQLArray($sqlarray);
 538  
 539      echo "[done]</p>";
 540  
 541      echo "<p>Creating userplugins table...";
 542  
 543      $dbdict = NewDataDictionary($db);
 544      $flds = "
 545          userplugin_id I KEY,
 546          userplugin_name C(255),
 547          code X,
 548          create_date DT,
 549          modified_date DT
 550      ";
 551      $taboptarray = array('mysql' => 'TYPE=MyISAM');
 552      $sqlarray = $dbdict->CreateTableSQL($db_prefix."userplugins", $flds, $taboptarray);
 553      $dbdict->ExecuteSQLArray($sqlarray);
 554  
 555      echo "[done]</p>";
 556  
 557      echo "<p>Creating version table...";
 558  
 559      $dbdict = NewDataDictionary($db);
 560      $flds = "
 561          version I
 562      ";
 563      $taboptarray = array('mysql' => 'TYPE=MyISAM');
 564      $sqlarray = $dbdict->CreateTableSQL($db_prefix."version", $flds, $taboptarray);
 565      $dbdict->ExecuteSQLArray($sqlarray);
 566  
 567      echo "[done]</p>";
 568      
 569      /*
 570      echo "<p>Creating sequence table...";
 571  
 572      $dbdict = NewDataDictionary($db);
 573      $flds = "
 574          sequence_id I KEY,
 575          sequence_name C(25),
 576          sequence_actions X,
 577          sequence_panic X,
 578          active I1,
 579          create_date DT,
 580          modified_date DT
 581      ";
 582      $taboptarray = array('mysql' => 'TYPE=MyISAM');
 583      $sqlarray = $dbdict->CreateTableSQL($db_prefix."sequence", $flds, $taboptarray);
 584      $dbdict->ExecuteSQLArray($sqlarray);
 585  
 586      echo "[done]</p>";
 587      */
 588  }
 589  
 590  # vim:ts=4 sw=4 noet
 591  ?>