--- /dev/null
+<?php
+
+/* * * * * * * * * * * * * * * * * * * *
+ *
+ * - FullCalendar pour SPIP -
+ *
+ * Description des tables à créer dans MySQL
+ *
+ * Auteur : Grégory PASCAL - ngombe at gmail dot com
+ * Modifs : 05/04/2011
+ *
+ */
+
+global $tables_principales;
+
+/*
+ * spip_fullcalendar_main
+ *
+ * +-----------------+------------+------+-----+---------+----------------+
+ * | Field | Type | Null | Key | Default | Extra |
+ * +-----------------+------------+------+-----+---------+----------------+
+ * | id_fullcalendar | int(11) | NO | PRI | NULL | auto_increment |
+ * | type | varchar(7) | NO | | NULL | |
+ * | nom | text | NO | | NULL | |
+ * +-----------------+------------+------+-----+---------+----------------+
+ */
+
+$spip_fullcalendar_main = array(
+ "id_fullcalendar" => "BIGINT(21) NOT NULL auto_increment",
+ "type" => "VARCHAR(7) NOT NULL",
+ "nom" => "TEXT NOT NULL"
+);
+
+$spip_fullcalendar_key = array(
+ "PRIMARY KEY" => "id_fullcalendar"
+);
+
+$tables_principales['spip_fullcalendar_main'] = array(
+ 'field' => &$spip_fullcalendar_main,
+ 'key' => &$spip_fullcalendar_key
+);
+
+/*
+ * spip_fullcalendar_events
+ *
+ * +-----------------+----------+------+-----+---------+----------------+
+ * | Field | Type | Null | Key | Default | Extra |
+ * +-----------------+----------+------+-----+---------+----------------+
+ * | id_event | int(11) | NO | PRI | NULL | auto_increment |
+ * | id_fullcalendar | int(11) | NO | | NULL | |
+ * | id_style | int(11) | NO | | NULL | |
+ * | titre | text | NO | | NULL | |
+ * | lien | text | NO | | NULL | |
+ * | start | datetime | NO | | NULL | |
+ * | end | datetime | NO | | NULL | |
+ * +-----------------+----------+------+-----+---------+----------------+
+ */
+
+$spip_fullcalendar_events = array(
+ "id_event" => "BIGINT(21) NOT NULL auto_increment",
+ "id_fullcalendar" => "BIGINT(21) NOT NULL",
+ "id_style" => "BIGINT(21) NOT NULL",
+ "titre" => "TEXT NOT NULL",
+ "lien" => "TEXT NOT NULL",
+ "start" => "DATETIME NOT NULL",
+ "end" => "DATETIME NOT NULL"
+);
+
+$spip_fullcalendar_events_key = array(
+ "PRIMARY KEY" => "id_event"
+);
+
+$tables_principales['spip_fullcalendar_events'] = array(
+ 'field' => &$spip_fullcalendar_events,
+ 'key' => &$spip_fullcalendar_events_key
+);
+
+
+/*
+ * spip_fullcalendar_styles
+ *
+ * +-----------------+------------+------+-----+---------+----------------+
+ * | Field | Type | Null | Key | Default | Extra |
+ * +-----------------+------------+------+-----+---------+----------------+
+ * | id_style | int(11) | NO | PRI | NULL | auto_increment |
+ * | titre | text | NO | | NULL | |
+ * | bordercolor | varchar(7) | NO | | NULL | |
+ * | bgcolor | varchar(7) | NO | | NULL | |
+ * | textcolor | varchar(7) | NO | | NULL | |
+ * +-----------------+------------+------+-----+---------+----------------+
+ */
+
+$spip_fullcalendar_styles = array(
+ "id_style" => "BIGINT(21) NOT NULL auto_increment",
+ "titre" => "TEXT NOT NULL",
+ "bordercolor" => "VARCHAR(7) NOT NULL",
+ "bgcolor" => "VARCHAR(7) NOT NULL",
+ "textcolor" => "VARCHAR(7) NOT NULL"
+);
+
+$spip_fullcalendar_styles_key = array(
+ "PRIMARY KEY" => "id_style"
+);
+
+$tables_principales['spip_fullcalendar_styles'] = array(
+ 'field' => &$spip_fullcalendar_styles,
+ 'key' => &$spip_fullcalendar_styles_key
+);
+
+/*
+ function boucle_fullcalendar_dist($id_boucle, &$boucles) {
+ $boucle = &$boucles[$id_boucle];
+ $id_table = $boucle->id_table;
+ $boucle->from[$id_table] = "spip_fullcalendar";
+
+ if (!$GLOBALS['var_preview']) {
+ if (!$boucle->statut) {
+ $boucle->where[]= array("'IN'", "'$id_table.id_fullcalendar'", "''");
+ }
+ }
+ return calculer_boucle($id_boucle, $boucles);
+}
+*/
+
+?>