[Sommaire] [Imprimer]

   1  <?xml version="1.0" encoding="ISO-8859-1"?>
   2  <!-- ***** BEGIN LICENSE BLOCK *****
   3     - This file is part of DotClear.
   4     - Copyright (c) 2004 Olivier Meunier and contributors. All rights
   5     - reserved.
   6     -
   7     - DotClear is free software; you can redistribute it and/or modify
   8     - it under the terms of the GNU General Public License as published by
   9     - the Free Software Foundation; either version 2 of the License, or
  10     - (at your option) any later version.
  11     - 
  12     - DotClear is distributed in the hope that it will be useful,
  13     - but WITHOUT ANY WARRANTY; without even the implied warranty of
  14     - MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  15     - GNU General Public License for more details.
  16     - 
  17     - You should have received a copy of the GNU General Public License
  18     - along with DotClear; if not, write to the Free Software
  19     - Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
  20     -
  21     - ***** END LICENSE BLOCK ***** -->
  22  <database>
  23    
  24    <!--
  25    Suppression des tables, UNIQUEMENT POUR TEST. NE PAS DECOMMENTER.
  26    
  27    <action id="droptables" label="Drop tables">
  28    DROP TABLE IF EXISTS `{{PREFIX}}categorie`, `{{PREFIX}}comment`,
  29    `{{PREFIX}}log`, `{{PREFIX}}ping`, `{{PREFIX}}post`, `{{PREFIX}}user`
  30    </action>
  31    
  32    -->
  33    
  34    <!-- USER -->
  35    <action id="user" label="Create table %s" string="{{PREFIX}}user">
  36      <test eq="neq" value="{{PREFIX}}user" label="Table %s exists"
  37      string="{{PREFIX}}user">SHOW TABLES LIKE '{{PREFIX}}user'</test>
  38      
  39      CREATE TABLE `{{PREFIX}}user` (
  40      `user_id` varchar(32) binary NOT NULL default '',
  41      `user_level` int(11) NOT NULL default '0',
  42      `user_pwd` varchar(32) binary NOT NULL default '',
  43      `user_nom` varchar(255) binary default NULL,
  44      `user_prenom` varchar(255) binary default NULL,
  45      `user_pseudo` varchar(255) binary default NULL,
  46      `user_email` varchar(255) default NULL,
  47      `user_post_format` varchar(5) NOT NULL default 'wiki',
  48      `user_edit_size` int(11) NOT NULL default '10',
  49      `user_pref_cat` int(11) default NULL,
  50      `user_lang` char(3) default NULL,
  51      `user_delta` int(1) NOT NULL default '0',
  52      `user_post_pub` int(1) NOT NULL default '0',
  53      PRIMARY KEY  (`user_id`)
  54      ) TYPE=MyISAM
  55    </action>
  56    
  57    <!-- CATEGORIE -->
  58    <action id="categorie" label="Create table %s" string="{{PREFIX}}categorie">
  59      <test eq="neq" value="{{PREFIX}}categorie" label="Table %s exists"
  60      string="{{PREFIX}}categorie">SHOW TABLES LIKE '{{PREFIX}}categorie'</test>
  61      
  62      CREATE TABLE `{{PREFIX}}categorie` (
  63      `cat_id` int(11) NOT NULL auto_increment,
  64      `cat_libelle` varchar(255) NOT NULL default '',
  65      `cat_desc` longtext,
  66      `cat_libelle_url` varchar(255) NOT NULL default '',
  67      `cat_ord` int(11) default NULL,
  68      PRIMARY KEY  (`cat_id`),
  69      UNIQUE KEY `cat_libelle_url` (`cat_libelle_url`),
  70      UNIQUE KEY `cat_libelle` (`cat_libelle`)
  71      ) TYPE=MyISAM
  72    </action>
  73    
  74    <!-- POST -->
  75    <action id="post" label="Create table %s" string="{{PREFIX}}post">
  76      <test eq="neq" value="{{PREFIX}}post" label="Table %s exists"
  77      string="{{PREFIX}}post">SHOW TABLES LIKE '{{PREFIX}}post'</test>
  78      
  79      CREATE TABLE `{{PREFIX}}post` (
  80      `post_id` int(11) NOT NULL auto_increment,
  81      `user_id` varchar(32) binary NOT NULL default '',
  82      `cat_id` int(11) default NULL,
  83      `post_dt` datetime default NULL,
  84      `post_creadt` datetime default NULL,
  85      `post_upddt` datetime default NULL,
  86      `post_titre` varchar(255) default NULL,
  87      `post_titre_url` varchar(255) default NULL,
  88      `post_chapo` longtext,
  89      `post_chapo_wiki` longtext,
  90      `post_content` longtext,
  91      `post_content_wiki` longtext,
  92      `post_notes` longtext,
  93      `post_pub` int(1) NOT NULL default '0',
  94      `post_selected` int(1) NOT NULL default '0',
  95      `post_open_comment` int(1) NOT NULL default '0',
  96      `post_open_tb` int(1) NOT NULL default '0',
  97      `nb_comment` int(11) NOT NULL default '0',
  98      `nb_trackback` int(11) NOT NULL default '0',
  99      `post_lang` varchar(5) default NULL,
 100      PRIMARY KEY  (`post_id`)
 101      ) TYPE=MyISAM
 102    </action>
 103    
 104    <!-- COMMENT -->
 105    <action id="comment" label="Create table %s" string="{{PREFIX}}comment">
 106      <test eq="neq" value="{{PREFIX}}comment" label="Table %s exists"
 107      string="{{PREFIX}}comment">SHOW TABLES LIKE '{{PREFIX}}comment'</test>
 108      
 109      CREATE TABLE `{{PREFIX}}comment` (
 110      `comment_id` int(11) NOT NULL auto_increment,
 111      `post_id` int(11) NOT NULL default '0',
 112      `comment_dt` datetime default NULL,
 113      `comment_upddt` datetime default NULL,
 114      `comment_auteur` varchar(255) default NULL,
 115      `comment_email` varchar(255) default NULL,
 116      `comment_site` varchar(255) default NULL,
 117      `comment_content` longtext,
 118      `comment_ip` varchar(15) default NULL,
 119      `comment_pub` int(1) default '0',
 120      `comment_trackback` int(1) NOT NULL default '0',
 121      PRIMARY KEY  (`comment_id`)
 122      ) TYPE=MyISAM
 123    </action>
 124    
 125    <!-- PING -->
 126    <action id="ping" label="Create table %s" string="{{PREFIX}}ping">
 127      <test eq="neq" value="{{PREFIX}}ping" label="Table %s exists"
 128      string="{{PREFIX}}ping">SHOW TABLES LIKE '{{PREFIX}}ping'</test>
 129      CREATE TABLE `{{PREFIX}}ping` (
 130      `ping_id` int(11) NOT NULL auto_increment,
 131      `post_id` int(11) NOT NULL default '0',
 132      `ping_url` varchar(255) NOT NULL default '0',
 133      `ping_dt` datetime default NULL,
 134      PRIMARY KEY  (`ping_id`)
 135      ) TYPE=MyISAM
 136    </action>
 137    
 138    <!-- LOG -->
 139    <action id="log" label="Create table %s" string="{{PREFIX}}log">
 140      <test eq="neq" value="{{PREFIX}}log" label="Table %s exists"
 141      string="{{PREFIX}}log">SHOW TABLES LIKE '{{PREFIX}}log'</test>
 142      CREATE TABLE `{{PREFIX}}log` (
 143      `user_id` varchar(32) binary NOT NULL default '',
 144      `table` varchar(255) NOT NULL default '',
 145      `key` varchar(255) NOT NULL default '',
 146      `date` datetime NOT NULL default '0000-00-00 00:00:00',
 147      `ip` varchar(15) default NULL,
 148      `log` varchar(255) NOT NULL default ''
 149      ) TYPE=MyISAM
 150    </action>
 151    
 152    <!-- LINK -->
 153    <action id="link" label="Create table %s" string="{{PREFIX}}link">
 154      <test eq="neq" value="{{PREFIX}}link" label="Table %s exists"
 155      string="{{PREFIX}}link">SHOW TABLES LIKE '{{PREFIX}}link'</test>
 156      CREATE TABLE `{{PREFIX}}link` (
 157      `link_id` int(11) NOT NULL auto_increment,
 158      `href` varchar(255) NOT NULL default '',
 159      `label` varchar(255) NOT NULL default '',
 160      `title` varchar(255) NOT NULL default '',
 161      `lang` char(2) NOT NULL default '',
 162      `rel` varchar(255) default NULL,
 163      `position` int(11) NOT NULL default '0',
 164      PRIMARY KEY  (`link_id`)
 165      ) TYPE=MyISAM
 166    </action>
 167    
 168    <!-- SESSION -->
 169    <action id="session" label="Create table %s" string="{{PREFIX}}session">
 170      <test eq="neq" value="{{PREFIX}}session" label="Table %s exists"
 171      string="{{PREFIX}}session">SHOW TABLES LIKE '{{PREFIX}}session'</test>
 172      CREATE TABLE `{{PREFIX}}session` (
 173      `ses_id` varchar(32) NOT NULL default '',
 174      `ses_time` int(11) NOT NULL default '0',
 175      `ses_start` int(11) NOT NULL default '0',
 176      `ses_value` text NOT NULL,
 177      PRIMARY KEY  (`ses_id`)
 178      ) TYPE=MyISAM
 179    </action>
 180    
 181    
 182    <!-- FULLTEXT KEYS -->
 183    <action id="fulltitle" label="Add fulltext key %s" string="full_post_titre">
 184      <test eq="eq" value="1" label="MySQL version too old" type="wrn">
 185      SELECT REPLACE(VERSION(),'-log','') >= '3.23.23'
 186      </test>
 187      ALTER TABLE `{{PREFIX}}post` ADD FULLTEXT `full_post_titre` (`post_titre`)
 188    </action>
 189    
 190    <action id="fullcontent" label="Add fulltext key %s" string="full_post_content">
 191      <test eq="eq" value="1" label="MySQL version too old" type="wrn">
 192      SELECT REPLACE(VERSION(),'-log','') >= '3.23.23'
 193      </test>
 194      ALTER TABLE `{{PREFIX}}post` ADD FULLTEXT `full_post_content` (`post_content`)
 195    </action>
 196    
 197    <action id="fullchapo" label="Add fulltext key %s" string="full_post_chapo">
 198      <test eq="eq" value="1" label="MySQL version too old" type="wrn">
 199      SELECT REPLACE(VERSION(),'-log','') >= '3.23.23'
 200      </test>
 201      ALTER TABLE `{{PREFIX}}post` ADD FULLTEXT `full_post_chapo` (`post_chapo`)
 202    </action>
 203    
 204    <!-- FIRST CATEGORY -->
 205    <action id="firstcat" label="Creation of first category">
 206    INSERT INTO `{{PREFIX}}categorie`
 207    (`cat_id`, `cat_libelle`, `cat_libelle_url`, `cat_ord`) VALUES
 208    (1, 'General', 'General', 0)
 209    </action>
 210    
 211    <!-- INDEXES
 212    ====================================================== -->
 213    <action id="fk_post_categorie" type="silent">
 214      ALTER TABLE `{{PREFIX}}post` ADD INDEX `fk_post_categorie` (`cat_id`,`post_pub`)
 215    </action>
 216    <action id="fk_post_user" type="silent">
 217      ALTER TABLE `{{PREFIX}}post` ADD INDEX `fk_post_user` (`user_id`,`post_pub`)
 218    </action>
 219    <action id="fk_comment_post" type="silent">
 220      ALTER TABLE `{{PREFIX}}comment` ADD INDEX `fk_comment_post` (`post_id`)
 221    </action>
 222    <action id="fk_ping_post" type="silent">
 223      ALTER TABLE `{{PREFIX}}ping` ADD INDEX `fk_ping_post` (`post_id`)
 224    </action>
 225  </database>