[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    <!-- LOG -->
  24    <action id="log" label="Create table %s" string="{{PREFIX}}log">
  25      <test eq="neq" value="{{PREFIX}}log" label="Table %s exists"
  26      string="{{PREFIX}}log" type="wrn">SHOW TABLES LIKE '{{PREFIX}}log'</test>
  27      CREATE TABLE `{{PREFIX}}log` (
  28      `user_id` varchar(32) binary NOT NULL default '',
  29      `table` varchar(255) NOT NULL default '',
  30      `key` varchar(255) NOT NULL default '',
  31      `date` datetime NOT NULL default '0000-00-00 00:00:00',
  32      `ip` varchar(15) default NULL,
  33      `log` varchar(255) NOT NULL default ''
  34      ) TYPE=MyISAM
  35    </action>
  36    
  37    <!-- LINK -->
  38    <action id="link" label="Create table %s" string="{{PREFIX}}link">
  39      <test eq="neq" value="{{PREFIX}}link" label="Table %s exists"
  40      string="{{PREFIX}}link" type="wrn">SHOW TABLES LIKE '{{PREFIX}}link'</test>
  41      CREATE TABLE `{{PREFIX}}link` (
  42      `link_id` int(11) NOT NULL auto_increment,
  43      `href` varchar(255) NOT NULL default '',
  44      `label` varchar(255) NOT NULL default '',
  45      `title` varchar(255) NOT NULL default '',
  46      `lang` char(2) NOT NULL default '',
  47      `position` int(11) NOT NULL default '0',
  48      PRIMARY KEY  (`link_id`)
  49      ) TYPE=MyISAM
  50    </action>
  51    
  52    <action id="link_rel" label="Add field %s" string="{{PREFIX}}link.rel">
  53      <test eq="neq" value="rel" label="Field %s exists"
  54      string="{{PREFIX}}link.rel" type="wrn">
  55        SHOW COLUMNS FROM `{{PREFIX}}link` LIKE 'rel'
  56      </test>
  57      ALTER TABLE `{{PREFIX}}link` ADD `rel` varchar(255)
  58      AFTER `lang`
  59    </action>
  60    
  61    <!-- PING -->
  62    <action id="ping" label="Create table %s" string="{{PREFIX}}ping">
  63      <test eq="neq" value="{{PREFIX}}ping" label="Table %s exists"
  64      string="{{PREFIX}}ping" type="wrn">SHOW TABLES LIKE '{{PREFIX}}ping'</test>
  65      CREATE TABLE `{{PREFIX}}ping` (
  66      `ping_id` int(11) NOT NULL auto_increment,
  67      `post_id` int(11) NOT NULL default '0',
  68      `ping_url` varchar(255) NOT NULL default '0',
  69      `ping_dt` datetime default NULL,
  70      PRIMARY KEY  (`ping_id`)
  71      ) TYPE=MyISAM
  72    </action>
  73    
  74    <!-- SESSION -->
  75    <action id="session" label="Create table %s" string="{{PREFIX}}session">
  76      <test eq="neq" value="{{PREFIX}}session" label="Table %s exists"
  77      string="{{PREFIX}}session" type="wrn">SHOW TABLES LIKE '{{PREFIX}}session'</test>
  78      CREATE TABLE `{{PREFIX}}session` (
  79      `ses_id` varchar(32) NOT NULL default '',
  80      `ses_time` int(11) NOT NULL default '0',
  81      `ses_start` int(11) NOT NULL default '0',
  82      `ses_value` text NOT NULL,
  83      PRIMARY KEY  (`ses_id`)
  84      ) TYPE=MyISAM
  85    </action>
  86    
  87    <!-- USER
  88    ===================================================== -->
  89    <!-- user_lang -->
  90    <action id="user_lang" label="Add field %s" string="{{PREFIX}}user.user_lang">
  91      <test eq="neq" value="user_lang" label="Field %s exists"
  92      string="{{PREFIX}}user.user_lang" type="wrn">
  93        SHOW COLUMNS FROM `{{PREFIX}}user` LIKE 'user_lang'
  94      </test>
  95      ALTER TABLE `{{PREFIX}}user` ADD `user_lang` VARCHAR(3)
  96    </action>
  97    
  98    <!-- user_delta -->
  99    <action id="user_delta" label="Add field %s" string="{{PREFIX}}user.user_delta">
 100      <test eq="neq" value="user_delta" label="Field %s exists"
 101      string="{{PREFIX}}user.user_delta" type="wrn">
 102        SHOW COLUMNS FROM `{{PREFIX}}user` LIKE 'user_delta'
 103      </test>
 104      ALTER TABLE `{{PREFIX}}user` ADD `user_delta` INTEGER(1) NOT NULL DEFAULT 0
 105    </action>
 106    
 107    <!-- user_post_pub -->
 108    <action id="user_post_pub" label="Add field %s" string="{{PREFIX}}user.user_post_pub">
 109      <test eq="neq" value="user_post_pub" label="Field %s exists"
 110      string="{{PREFIX}}user.user_post_pub" type="wrn">
 111        SHOW COLUMNS FROM `{{PREFIX}}user` LIKE 'user_post_pub'
 112      </test>
 113      ALTER TABLE `{{PREFIX}}user` ADD `user_post_pub` INTEGER(1) NOT NULL DEFAULT 0
 114    </action>
 115    
 116    
 117    <!-- POST
 118    ===================================================== -->
 119    <!-- post_notes -->
 120    <action id="post_notes" label="Add field %s" string="{{PREFIX}}post.post_notes">
 121      <test eq="neq" value="post_notes" label="Field %s exists"
 122      string="{{PREFIX}}post.post_notes" type="wrn">
 123        SHOW COLUMNS FROM `{{PREFIX}}post` LIKE 'post_notes'
 124      </test>
 125      ALTER TABLE `{{PREFIX}}post` ADD `post_notes` LONGTEXT
 126      AFTER `post_content_wiki`
 127    </action>
 128    
 129    <!-- post_lang -->
 130    <action id="post_lang" label="Add field %s" string="{{PREFIX}}post.post_lang">
 131      <test eq="neq" value="post_lang" label="Field %s exists"
 132      string="{{PREFIX}}post.post_lang" type="wrn">
 133        SHOW COLUMNS FROM `{{PREFIX}}post` LIKE 'post_lang'
 134      </test>
 135      ALTER TABLE `{{PREFIX}}post` ADD `post_lang` VARCHAR(5)
 136    </action>
 137    
 138    <!-- post_titre_url -->
 139    <action id="post_titre_url" label="Add field %s" string="{{PREFIX}}post.post_titre_url">
 140      <test eq="neq" value="post_titre_url" label="Field %s exists"
 141      string="{{PREFIX}}post.post_titre_url" type="wrn">
 142        SHOW COLUMNS FROM `{{PREFIX}}post` LIKE 'post_titre_url'
 143      </test>
 144      ALTER TABLE `{{PREFIX}}post` ADD `post_titre_url` VARCHAR(255)
 145      AFTER `post_titre`
 146    </action>
 147    
 148    <!-- post_selected -->
 149    <action id="post_selected" label="Add field %s" string="{{PREFIX}}post.post_selected">
 150      <test eq="neq" value="post_selected" label="Field %s exists"
 151      string="{{PREFIX}}post.post_selected" type="wrn">
 152        SHOW COLUMNS FROM `{{PREFIX}}post` LIKE 'post_selected'
 153      </test>
 154      ALTER TABLE `{{PREFIX}}post` ADD `post_selected` INTEGER(1) NOT NULL
 155      DEFAULT 0 AFTER `post_pub`
 156    </action>
 157    
 158    <!-- post_open_tb -->
 159    <action id="post_open_tb" label="Add field %s" string="{{PREFIX}}post.post_open_tb">
 160      <test eq="neq" value="post_open_tb" label="Field %s exists"
 161      string="{{PREFIX}}post.post_open_tb" type="wrn">
 162        SHOW COLUMNS FROM `{{PREFIX}}post` LIKE 'post_open_tb'
 163      </test>
 164      ALTER TABLE `{{PREFIX}}post` ADD `post_open_tb` INTEGER(1) NOT NULL
 165      DEFAULT 0 AFTER `post_open_comment`
 166    </action>
 167    
 168    <!-- nb_trackback -->
 169    <action id="nb_trackback" label="Add field %s" string="{{PREFIX}}post.nb_trackback">
 170      <test eq="neq" value="nb_trackback" label="Field %s exists"
 171      string="{{PREFIX}}post.nb_trackback" type="wrn">
 172        SHOW COLUMNS FROM `{{PREFIX}}post` LIKE 'nb_trackback'
 173      </test>
 174      ALTER TABLE `{{PREFIX}}post` ADD `nb_trackback` INTEGER(11) NOT NULL
 175      DEFAULT 0 AFTER `nb_comment`
 176    </action>
 177    
 178    <!-- post_gupddt -->
 179    <action id="post_gupddt" label="Remove field %s" string="{{PREFIX}}post.post_gupddt">
 180      <test eq="eq" value="post_gupddt" label="Field %s not present"
 181      string="{{PREFIX}}post.post_gupddt" type="wrn">
 182        SHOW COLUMNS FROM `{{PREFIX}}post` LIKE 'post_gupddt'
 183      </test>
 184      ALTER TABLE `{{PREFIX}}post` DROP `post_gupddt`
 185    </action>
 186    
 187    
 188    <!-- CATEGORIE
 189    ===================================================== -->
 190    <!-- cat_ord -->
 191    <action id="cat_ord" label="Add field %s" string="{{PREFIX}}categorie.cat_ord">
 192      <test eq="neq" value="cat_ord" label="Field %s exists"
 193      string="{{PREFIX}}categorie.cat_ord" type="wrn">
 194        SHOW COLUMNS FROM `{{PREFIX}}categorie` LIKE 'cat_ord'
 195      </test>
 196      ALTER TABLE `{{PREFIX}}categorie` ADD `cat_ord` INTEGER
 197    </action>
 198    
 199    <!-- upd_open_tb -->
 200    <action id="upd_open_tb" label="Update %s" string="{{PREFIX}}post.post_open_tb">
 201      UPDATE `{{PREFIX}}post` SET `post_open_tb` = `post_open_comment` 
 202    </action>
 203    
 204    <!-- INDEXES
 205    ====================================================== -->
 206    <action id="fk_post_categorie" type="silent">
 207      ALTER TABLE `{{PREFIX}}post` ADD INDEX `fk_post_categorie` (`cat_id`,`post_pub`)
 208    </action>
 209    <action id="fk_post_user" type="silent">
 210      ALTER TABLE `{{PREFIX}}post` ADD INDEX `fk_post_user` (`user_id`,`post_pub`)
 211    </action>
 212    <action id="fk_comment_post" type="silent">
 213      ALTER TABLE `{{PREFIX}}comment` ADD INDEX `fk_comment_post` (`post_id`)
 214    </action>
 215    <action id="fk_ping_post" type="silent">
 216      ALTER TABLE `{{PREFIX}}ping` ADD INDEX `fk_ping_post` (`post_id`)
 217    </action>
 218  </database>