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 | ?> |
---|