www/plugins/menus_1/base/menus_tables.php

   1 <?php
   2
   3 // Sécurité
   4 if (!defined('_ECRIRE_INC_VERSION')) {
   5         return;
   6 }
   7
   8 function menus_declarer_tables_interfaces($interface) {
   9         // 'spip_' dans l'index de $tables_principales
  10         $interface['table_des_tables']['menus']='menus';
  11         $interface['table_des_tables']['menus_entrees']='menus_entrees';
  12
  13         // Titres
  14         $interface['table_titre']['menus'] = 'titre, "" as lang';
  15
  16         return $interface;
  17 }
  18
  19 function menus_declarer_tables_principales($tables_principales) {
  20         //-- Table menus -----------------------------------------------------------
  21         $menus = array(
  22                 'id_menu' => 'bigint(21) NOT NULL',
  23                 'id_menus_entree' => "bigint(21) DEFAULT '0' NOT NULL",
  24                 'titre' => "text DEFAULT '' NOT NULL",
  25                 'identifiant' => "varchar(255) default '' not null",
  26                 'css' => "tinytext DEFAULT '' NOT NULL"
  27         );
  28
  29         $menus_cles = array(
  30                 'PRIMARY KEY' => 'id_menu',
  31                 'KEY id_menus_entree' => 'id_menus_entree'
  32         );
  33
  34         $tables_principales['spip_menus'] = array(
  35                 'field' => &$menus,
  36                 'key' => &$menus_cles
  37         );
  38
  39         // Table menus_elements ----------------------------------------------------
  40         $menus_entrees = array(
  41                 'id_menus_entree' => 'bigint(21) NOT NULL',
  42                 'id_menu' => "bigint(21) DEFAULT '0' NOT NULL",
  43                 'rang' => "smallint DEFAULT '1' NOT NULL",
  44                 'type_entree' => "tinytext DEFAULT '' NOT NULL",
  45                 'parametres' => "text DEFAULT '' NOT NULL"
  46         );
  47
  48         $menus_entrees_cles = array(
  49                 'PRIMARY KEY' => 'id_menus_entree',
  50                 'KEY id_menu' => 'id_menu'
  51         );
  52
  53         $tables_principales['spip_menus_entrees'] = array(
  54                 'field' => &$menus_entrees,
  55                 'key' => &$menus_entrees_cles
  56         );
  57
  58         return $tables_principales;
  59 }