[Sommaire] [Imprimer]

   1  <?xml version="1.0" encoding="ISO-8859-1"?>
   2  <!-- 
   3  # ***** BEGIN LICENSE BLOCK *****
   4  # Version: MPL 1.1/GPL 2.0/LGPL 2.1
   5  #
   6  # The contents of this file are subject to the Mozilla Public License Version
   7  # 1.1 (the "License"); you may not use this file except in compliance with
   8  # the License. You may obtain a copy of the License at
   9  # http://www.mozilla.org/MPL/
  10  #
  11  # Software distributed under the License is distributed on an "AS IS" basis,
  12  # WITHOUT WARRANTY OF ANY KIND, either express or implied. See the License
  13  # for the specific language governing rights and limitations under the
  14  # License.
  15  #
  16  # The Original Code is PLUME CMS.
  17  #
  18  # The Initial Developer of the Original Code is
  19  # loic d'Anterroches.
  20  # Portions created by the Initial Developer are Copyright (C) 2003
  21  # the Initial Developer. All Rights Reserved.
  22  #
  23  # Contributor(s):
  24  #
  25  # Alternatively, the contents of this file may be used under the terms of
  26  # either the GNU General Public License Version 2 or later (the "GPL"), or
  27  # the GNU Lesser General Public License Version 2.1 or later (the "LGPL"),
  28  # in which case the provisions of the GPL or the LGPL are applicable instead
  29  # of those above. If you wish to allow use of your version of this file only
  30  # under the terms of either the GPL or the LGPL, and not to allow others to
  31  # use your version of this file under the terms of the MPL, indicate your
  32  # decision by deleting the provisions above and replace them with the notice
  33  # and other provisions required by the GPL or the LGPL. If you do not delete
  34  # the provisions above, a recipient may use your version of this file under
  35  # the terms of any one of the MPL, the GPL or the LGPL.
  36  #
  37  # ***** END LICENSE BLOCK *****
  38  -->
  39  <database>
  40         <!-- comments -->
  41         <action id="comments" label="Create table %s" string="{{PREFIX}}comments">
  42                  <test eq="neq" value="{{PREFIX}}comments" label="The table %s already exists."
  43          string="{{PREFIX}}comments" type="wrn">SHOW TABLES LIKE '{{PREFIX}}comments'</test>
  44                  CREATE TABLE {{PREFIX}}comments (
  45          comment_id int(11) NOT NULL auto_increment,
  46          resource_id int(11) NOT NULL default '0',
  47          comment_user_id int(11) NOT NULL default '0',
  48          comment_author varchar(50) NOT NULL default '',
  49          comment_email varchar(255) NOT NULL default '',
  50          comment_website varchar(255) NOT NULL default '',
  51          comment_creation bigint(20) unsigned NOT NULL default '0',
  52          comment_update bigint(20) unsigned NOT NULL default '0',
  53          comment_status int(11) NOT NULL default '0',
  54          comment_type int(11) NOT NULL default '0',
  55          comment_content text NOT NULL,
  56          comment_ip varchar(200) NOT NULL default '',
  57          PRIMARY KEY  (comment_id),
  58          KEY resource_id (resource_id)
  59          ) {{TYPE}}
  60      </action>
  61  
  62      <!-- smart404 -->
  63      <action id="smart404" label="Creation of the table %s" string="{{PREFIX}}smart404">
  64          <test eq="neq" value="{{PREFIX}}smart404" label="The table %s already exists."
  65          string="{{PREFIX}}smart404" type="wrn">SHOW TABLES LIKE '{{PREFIX}}smart404'</test>
  66          CREATE TABLE {{PREFIX}}smart404 (
  67          website_id varchar(50) NOT NULL default '',
  68          oldpage varchar(255) NOT NULL default '',
  69          newpage varchar(255) NOT NULL default '',
  70          lastroutingdate bigint(20) unsigned NOT NULL default '0',
  71          total bigint(20) unsigned NOT NULL default '0',
  72          PRIMARY KEY  (website_id,oldpage)
  73          ) {{TYPE}}
  74      </action>
  75  
  76      <!-- smart404logs -->
  77      <action id="smart404logs" label="Creation of the table %s" string="{{PREFIX}}smart404logs">
  78          <test eq="neq" value="{{PREFIX}}smart404logs" label="The table %s already exists."
  79          string="{{PREFIX}}smart404logs" type="wrn">SHOW TABLES LIKE '{{PREFIX}}smart404logs'</test>
  80          CREATE TABLE {{PREFIX}}smart404logs (
  81          website_id varchar(50) NOT NULL default '',
  82          page varchar(255) NOT NULL default '',
  83          fromurl varchar(255) NOT NULL default '',
  84          date bigint(20) unsigned NOT NULL default '0',
  85          useragent varchar(255) NOT NULL default '',
  86          KEY website_id (website_id),
  87          KEY page (page),
  88          KEY date (date)
  89          ) {{TYPE}}
  90      </action>
  91  
  92      <!-- smart404logs.fromurl index -->
  93      <action id="smart404logsfromurl" label="Dropping of the index %s" string="{{PREFIX}}smart404logs.fromurl">
  94          <test eq="eq" value="MUL" label="The index %s has already been dropped."
  95          string="{{PREFIX}}smart404logs.fromurl" type="wrn" field="3">SHOW COLUMNS FROM {{PREFIX}}smart404logs LIKE 'fromurl'</test>
  96          DROP INDEX fromurl ON {{PREFIX}}smart404logs
  97      </action>
  98  
  99      <!-- smart404logs.date index -->
 100      <action id="smart404logsdate" label="Creation of the index %s" string="{{PREFIX}}smart404logs.date">
 101          <test eq="neq" value="MUL" label="The index %s already exists."
 102          string="{{PREFIX}}smart404logs.date" type="wrn" field="3">SHOW COLUMNS FROM {{PREFIX}}smart404logs LIKE 'date'</test>
 103          ALTER TABLE {{PREFIX}}smart404logs ADD INDEX (date)
 104      </action>
 105  
 106      <!-- resources.resource_id auto_increment -->
 107      <action id="resource_idauto_increment" label="Set the auto_increment for %s" string="{{PREFIX}}resources.resource_id">
 108          <test eq="neq" value="auto_increment" label="The auto_increment for %s already exists."
 109          string="{{PREFIX}}resources.resource_id" type="wrn" field="5">SHOW COLUMNS FROM {{PREFIX}}resources LIKE 'resource_id'</test>
 110          ALTER TABLE {{PREFIX}}resources CHANGE resource_id resource_id INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL AUTO_INCREMENT
 111      </action>
 112  
 113      <!-- users.user_id auto_increment -->
 114      <action id="users.user_id.auto" label="Set the auto_increment for %s" string="{{PREFIX}}users.user_id">
 115          <test eq="neq" value="auto_increment" label="The auto_increment for %s already exists."
 116          string="{{PREFIX}}users.user_id" type="wrn" field="5">SHOW COLUMNS FROM {{PREFIX}}users LIKE 'user_id'</test>
 117          ALTER TABLE {{PREFIX}}users CHANGE user_id user_id INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL AUTO_INCREMENT
 118      </action>
 119  
 120      <!-- subtypes.subtype_id auto_increment -->
 121      <action id="subtypes.subtype_id.auto" label="Set the auto_increment for %s" string="{{PREFIX}}subtypes.subtype_id">
 122          <test eq="neq" value="auto_increment" label="The auto_increment for %s already exists."
 123          string="{{PREFIX}}subtypes.subtype_id" type="wrn" field="5">SHOW COLUMNS FROM {{PREFIX}}subtypes LIKE 'subtype_id'</test>
 124          ALTER TABLE {{PREFIX}}subtypes CHANGE subtype_id subtype_id INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL AUTO_INCREMENT
 125      </action>
 126  
 127      <!-- categories.category_id auto_increment -->
 128      <action id="categories.category_id.auto" label="Set the auto_increment for %s" string="{{PREFIX}}categories.category_id">
 129          <test eq="neq" value="auto_increment" label="The auto_increment for %s already exists."
 130          string="{{PREFIX}}categories.category_id" type="wrn" field="5">SHOW COLUMNS FROM {{PREFIX}}categories LIKE 'category_id'</test>
 131          ALTER TABLE {{PREFIX}}categories CHANGE category_id category_id INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL AUTO_INCREMENT
 132      </action>
 133  
 134      <!-- searchwords.word_id auto_increment -->
 135      <action id="searchwords.word_id.auto" label="Set the auto_increment for %s" string="{{PREFIX}}searchwords.word_id">
 136          <test eq="neq" value="auto_increment" label="The auto_increment for %s already exists."
 137          string="{{PREFIX}}searchwords.word_id" type="wrn" field="5">SHOW COLUMNS FROM {{PREFIX}}searchwords LIKE 'word_id'</test>
 138          ALTER TABLE {{PREFIX}}searchwords CHANGE word_id word_id INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL AUTO_INCREMENT
 139      </action>
 140      
 141      <!-- articles.page_id auto_increment -->
 142      <action id="articles.page_id.auto" label="Set the auto_increment for %s" string="{{PREFIX}}articles.page_id">
 143          <test eq="neq" value="auto_increment" label="The auto_increment for %s already exists."
 144          string="{{PREFIX}}articles.page_id" type="wrn" field="5">SHOW COLUMNS FROM {{PREFIX}}articles LIKE 'page_id'</test>
 145          ALTER TABLE {{PREFIX}}articles CHANGE page_id page_id INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL AUTO_INCREMENT
 146      </action>
 147  
 148      <!-- drop sequencetable -->
 149      <action id="dropsequencetable" label="Removal of the table %s" string="{{PREFIX}}sequencetable">
 150          <test eq="eq" value="{{PREFIX}}sequencetable" label="The table %s has already been removed."
 151          string="{{PREFIX}}sequencetable" type="wrn">SHOW TABLES LIKE '{{PREFIX}}sequencetable'</test>
 152          DROP TABLE {{PREFIX}}sequencetable
 153      </action>
 154  
 155      <!-- add comment_support column -->
 156      <action id="addcommentsupportcolumn" label="Add the comment support column on table %s" string="{{PREFIX}}resources">
 157          <test eq="neq" value="comment_support" label="The column %s has already been added."
 158          string="comment_support" type="wrn" field="0">SHOW COLUMNS FROM {{PREFIX}}resources LIKE 'comment_support'</test>
 159          ALTER TABLE {{PREFIX}}resources ADD comment_support INT( 11 ) NOT NULL DEFAULT '1' AFTER subtype_id
 160      </action>
 161  
 162      <!-- categoryasso.identifier key -->
 163      <action id="categoryasso.identifier" label="Set index on the column for %s" string="{{PREFIX}}categoryasso.identifier">
 164          <test eq="neq" value="1" label="The index for %s already exists."
 165          string="{{PREFIX}}categoryasso.identifier" type="wrn" field="3">SHOW INDEXES FROM {{PREFIX}}categoryasso WHERE key_name LIKE 'identifier_idx'</test>
 166      ALTER TABLE {{PREFIX}}categoryasso ADD INDEX identifier_idx (identifier) 
 167      </action>
 168  
 169  </database>
 170  
 171