<?php
/*-------------------------------------------------------*/
/*---------------- LIEUX DE CONSULTATION ----------------*/

$spip_memo_adr = array(
    "ref"     => "int(11) NOT NULL auto_increment",
    "id"     => "varchar(20) character set latin1 default NULL",
    "org1"     => "varchar(250) character set latin1 default NULL",
    "org2"     => "varchar(250) character set latin1 default NULL",
    "org3"     => "varchar(250) character set latin1 default NULL",
    "l1"     => "varchar(250) character set latin1 default NULL",
    "l2"     => "varchar(250) character set latin1 default NULL",
    "cp"     => "varchar(250) character set latin1 default NULL",
    "ville"     => "varchar(250) character set latin1 default NULL",
    "pays"     => "varchar(250) character set latin1 default NULL",
    "tel"     => "varchar(250) character set latin1 default NULL",
    "fax"     => "varchar(250) character set latin1 default NULL",
    "email"     => "varchar(250) character set latin1 default NULL",
    "contact"     => "varchar(250) character set latin1 default NULL");

$spip_memo_adr_key = array(
    "PRIMARY KEY" => "ref");


$tables_principales['memo_adr'] = array(
    'field' => &$spip_memo_adr,
    'key' => &$spip_memo_adr_key);

/*-------------------------------------------------------*/
/*---------------- RESISTANTS ---------------------------*/

$spip_memo_resist = array(
    "id_res"     => "int(11) NOT NULL auto_increment",
    "nom"     => "varchar(50) default NULL",
    "prenom"     => "varchar(50) default NULL",
    "pseudo1"     => "varchar(50) default NULL",
    "pseudo2"     => "varchar(50) default NULL",
    "pseudo3"     => "varchar(50) default NULL",
    "reseau"     => "varchar(200) default NULL",
    "mouvement"     => "varchar(200) default NULL",
    "datenaiss"     => "date default NULL",
    "datedec"     => "date default NULL",
    "region"     => "char(3) default NULL",
    "departement"     => "char(3) default NULL",
    "action"     => "longlob default NULL",
    "photo1"     => "varchar(50) default NULL",
    "photo2"     => "varchar(50) default NULL",
    "nomauteur"     => "varchar(50) default NULL",
    "prenomauteur"     => "varchar(50) default NULL",
    "comment"     => "longtext NOT NULL",
    "biblio"     => "longtext NOT NULL");

$spip_memo_resist_key = array(
    "PRIMARY KEY" => "id_res");

$tables_principales['memo_resist'] = array(
    'field' => &$spip_memo_resist,
    'key' => &$spip_memo_resist_key);
    
    
/*-------------------------------------------------------*/
/*------------------ LIEUX DE MEMOIRE -------------------*/
    
$spip_memo_lieux = array(
  "ref" => "smallint(6) NOT NULL auto_increment",
  "region" => "char(3) NOT NULL default ''",
  "intitule" => "varchar(100) NOT NULL default ''",
  "resume" => "longtext NOT NULL",
  "images" => "varchar(255) NOT NULL default ''",
  "description" => "longtext NOT NULL",
  "contact" => "varchar(100) NOT NULL default ''",
  "adresse1" => "varchar(100) NOT NULL default ''",
  "adresse2" => "varchar(100) NOT NULL default ''",
  "cp" => "varchar(20) NOT NULL default ''",
  "ville" => "varchar(100) NOT NULL default ''",
  "phone" => "varchar(50) NOT NULL default ''",
  "fax" => "varchar(50) NOT NULL default ''",
  "email" => "varchar(150) NOT NULL default ''",
  "lon" => "varchar(10) default NULL",
  "lat" => "varchar(10) default NULL");

$spip_memo_lieux_key = array(
    "PRIMARY KEY" => "ref");

$tables_principales['memo_lieux'] = array(
    'field' => &$spip_memo_lieux,
    'key' => &$spip_memo_lieux_key);

/*-------------------------------------------------------*/
/*------------------ TRAVAUX UNIVERSITAIRES -------------*/

$spip_memo_fiches = array(
  "ref" => "int(11) NOT NULL auto_increment",
  "langue" => "varchar(20) default NULL",
  "titre" => "varchar(255) default NULL",
  "titremaj" => "varchar(255) default NULL",
  "collation" => "varchar(255) default NULL",
  "notes" => "varchar(255) default NULL",
  "note_th" => "varchar(255) default NULL",
  "resume" => "longtext",
  "chrono" => "varchar(255) default NULL",
  "pays" => "varchar(255) default NULL",
  "idx_region" => "varchar(255) default NULL",
  "num_dept" => "varchar(255) default NULL",
  "ville" => "varchar(255) default NULL",
  "sujets" => "varchar(255) default NULL",
  "auteur" => "varchar(255) default NULL",
  "consult1" => "varchar(255) default NULL",
  "consult2" => "varchar(255) default NULL",
  "consult3" => "varchar(255) default NULL",
  "bib_cote" => "varchar(255) default NULL",
  "bib_cote2" => "varchar(255) default NULL",
  "bib_cote3" => "varchar(255) default NULL",
  "cons_aut" => "varchar(255) default NULL");

$spip_memo_fiches_key = array(
    "PRIMARY KEY" => "ref");

$tables_principales['memo_fiches'] = array(
    'field' => &$spip_memo_fiches,
    'key' => &$spip_memo_fiches_key);
?>