[6] | 1 | <?php |
---|
| 2 | // ----------------------------------------------------------------------------- |
---|
| 3 | // Declaration des tables evenements |
---|
| 4 | // creation 11/03/2006 pour SPIP 1.9 |
---|
| 5 | |
---|
| 6 | include_spip('base/serial'); // pour eviter une reinit posterieure des tables modifiees |
---|
| 7 | |
---|
| 8 | global $tables_principales; |
---|
| 9 | global $tables_auxiliaires; |
---|
| 10 | |
---|
| 11 | //-- Table EVENEMENTS ------------------------------------------ |
---|
| 12 | $evenements = array( |
---|
| 13 | "id_evenement" => "bigint(21) NOT NULL", |
---|
| 14 | "id_article" => "bigint(21) DEFAULT '0' NOT NULL", |
---|
| 15 | "date_debut" => "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL", |
---|
| 16 | "date_fin" => "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL", |
---|
| 17 | "titre" => "text NOT NULL", |
---|
| 18 | "descriptif" => "text NOT NULL", |
---|
| 19 | "lieu" => "text NOT NULL", |
---|
| 20 | "horaire" => "ENUM('oui','non') DEFAULT 'oui' NOT NULL", |
---|
| 21 | "id_evenement_source" => "bigint(21) NOT NULL", |
---|
| 22 | "idx" => "ENUM('', '1', 'non', 'oui', 'idx') DEFAULT '' NOT NULL", |
---|
| 23 | "maj" => "TIMESTAMP" |
---|
| 24 | ); |
---|
| 25 | |
---|
| 26 | $evenements_key = array( |
---|
| 27 | "PRIMARY KEY" => "id_evenement", |
---|
| 28 | "KEY date_debut" => "date_debut", |
---|
| 29 | "KEY date_fin" => "date_fin", |
---|
| 30 | "KEY id_article" => "id_article" |
---|
| 31 | ); |
---|
| 32 | |
---|
| 33 | $tables_principales['spip_evenements'] = |
---|
| 34 | array('field' => &$evenements, 'key' => &$evenements_key); |
---|
| 35 | |
---|
| 36 | |
---|
| 37 | //-- Table de relations MOTS_EVENEMENTS---------------------- |
---|
| 38 | $spip_mots_evenements = array( |
---|
| 39 | "id_mot" => "BIGINT (21) DEFAULT '0' NOT NULL", |
---|
| 40 | "id_evenement" => "BIGINT (21) DEFAULT '0' NOT NULL"); |
---|
| 41 | |
---|
| 42 | $spip_mots_evenements_key = array( |
---|
| 43 | "PRIMARY KEY" => "id_mot, id_evenement", |
---|
| 44 | "KEY id_evenement" => "id_evenement"); |
---|
| 45 | |
---|
| 46 | $tables_auxiliaires['spip_mots_evenements'] = array( |
---|
| 47 | 'field' => &$spip_mots_evenements, |
---|
| 48 | 'key' => &$spip_mots_evenements_key); |
---|
| 49 | |
---|
| 50 | //-- Jointures ---------------------------------------------------- |
---|
| 51 | global $tables_jointures; |
---|
| 52 | $tables_jointures['spip_evenements'][]= 'mots'; // a placer avant la jointure sur articles |
---|
| 53 | $tables_jointures['spip_articles'][]= 'evenements'; |
---|
| 54 | $tables_jointures['spip_evenements'][] = 'articles'; |
---|
| 55 | $tables_jointures['spip_mots'][]= 'mots_evenements'; |
---|
| 56 | $tables_jointures['spip_evenements'][] = 'mots_evenements'; |
---|
| 57 | |
---|
| 58 | global $exceptions_des_tables; |
---|
| 59 | $exceptions_des_tables['evenements']['id_rubrique']=array('spip_articles', 'id_rubrique'); |
---|
| 60 | |
---|
| 61 | global $table_primary; |
---|
| 62 | $table_primary['evenements']="id_evenement"; |
---|
| 63 | |
---|
| 64 | global $table_date; |
---|
| 65 | $table_date['evenements'] = 'date_debut'; |
---|
| 66 | // si on declare les tables dans $table_des_tables, il faut mettre le prefixe |
---|
| 67 | |
---|
| 68 | // 'spip_' dans l'index de $tables_principales |
---|
| 69 | global $table_des_tables; |
---|
| 70 | $table_des_tables['evenements']='evenements'; |
---|
| 71 | $table_des_tables['mots_evenements']='mots_evenements'; |
---|
| 72 | |
---|
| 73 | |
---|
| 74 | |
---|
| 75 | // Extension de la table des groupes de mots cles |
---|
| 76 | $spip_groupes_mots = array( |
---|
| 77 | "id_groupe" => "bigint(21) NOT NULL", |
---|
| 78 | "titre" => "text NOT NULL", |
---|
| 79 | "descriptif" => "text NOT NULL", |
---|
| 80 | "texte" => "longblob NOT NULL", |
---|
| 81 | "unseul" => "varchar(3) NOT NULL", |
---|
| 82 | "obligatoire" => "varchar(3) NOT NULL", |
---|
| 83 | "articles" => "varchar(3) NOT NULL", |
---|
| 84 | "breves" => "varchar(3) NOT NULL", |
---|
| 85 | "rubriques" => "varchar(3) NOT NULL", |
---|
| 86 | "syndic" => "varchar(3) NOT NULL"); |
---|
| 87 | if (isset($GLOBALS['meta']['agenda_base_version'])) |
---|
| 88 | $spip_groupes_mots = array_merge($spip_groupes_mots,array("evenements" => "varchar(3) NOT NULL")); |
---|
| 89 | if (isset($GLOBALS['meta']['pim_agenda_base_version'])) |
---|
| 90 | $spip_groupes_mots = array_merge($spip_groupes_mots,array("pim_agenda" => "varchar(3) NOT NULL")); |
---|
| 91 | $spip_groupes_mots = array_merge($spip_groupes_mots,array( |
---|
| 92 | "minirezo" => "varchar(3) NOT NULL", |
---|
| 93 | "comite" => "varchar(3) NOT NULL", |
---|
| 94 | "forum" => "varchar(3) NOT NULL", |
---|
| 95 | "maj" => "TIMESTAMP")); |
---|
| 96 | |
---|
| 97 | |
---|
| 98 | $spip_groupes_mots_key = array( |
---|
| 99 | "PRIMARY KEY" => "id_groupe"); |
---|
| 100 | |
---|
| 101 | $tables_principales['spip_groupes_mots'] = |
---|
| 102 | array('field' => &$spip_groupes_mots, 'key' => &$spip_groupes_mots_key); |
---|
| 103 | |
---|
| 104 | global $table_des_traitements; |
---|
| 105 | $table_des_traitements['LIEU'][]= 'propre(%s)'; |
---|
| 106 | |
---|
| 107 | ?> |
---|