www/plugins/auto/noiZetier/base/noizetier_tables.php

   1 <?php
   2
   3 // Sécurité
   4 if (!defined("_ECRIRE_INC_VERSION")) return;
   5
   6 function noizetier_declarer_tables_interfaces($interface){
   7         // 'spip_' dans l'index de $tables_principales
   8         $interface['table_des_tables']['noisettes']='noisettes';
   9
  10         return $interface;
  11 }
  12
  13 function noizetier_declarer_tables_principales($tables_principales){
  14         //-- Table noisettes -----------------------------------------------------------
  15         $noisettes = array(
  16                 "id_noisette" => "bigint(21) NOT NULL",
  17                 "rang" => "smallint DEFAULT '1' NOT NULL",
  18                 "type" => "tinytext DEFAULT '' NOT NULL",
  19                 "composition" => "tinytext DEFAULT '' NOT NULL",
  20                 "bloc" => "tinytext DEFAULT '' NOT NULL",
  21                 "noisette" => "tinytext DEFAULT '' NOT NULL",
  22                 "parametres" => "text DEFAULT '' NOT NULL",
  23                 "css" => "tinytext DEFAULT '' NOT NULL"
  24         );
  25
  26         $noisettes_cles = array(
  27                 "PRIMARY KEY" => "id_noisette"
  28         );
  29
  30         $tables_principales['spip_noisettes'] = array(
  31                 'field' => &$noisettes,
  32                 'key' => &$noisettes_cles
  33         );
  34
  35         return $tables_principales;
  36 }
  37
  38 ?>