[Sommaire] [Imprimer]

   1  <?xml version="1.0" encoding="UTF-8"?>
   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    <!-- Version 2.0 beta 2
  24    ===================================================== -->
  25    <test type="version" name="2.0-beta2">
  26      <action silent="1">
  27        alter table {{PREFIX}}user alter user_tz set default 'UTC'
  28      </action>
  29      
  30      <action silent="1">
  31        alter table {{PREFIX}}post add
  32        post_tz varchar(128) not null default 'UTC'
  33      </action>
  34      
  35      <action silent="1">
  36        alter table {{PREFIX}}comment add
  37        comment_tz varchar(128) not null default 'UTC'
  38      </action>
  39      
  40      <action silent="1">
  41        alter table {{PREFIX}}user add
  42        user_desc text null
  43      </action>
  44      
  45      <action silent="1">
  46        alter table {{PREFIX}}setting drop constraint {{PREFIX}}pk_setting
  47      </action>
  48      
  49      <action silent="1">
  50        alter table {{PREFIX}}setting alter blog_id drop not null
  51      </action>
  52      
  53      <action silent="1">
  54        alter table {{PREFIX}}setting
  55        add constraint {{PREFIX}}uk_setting unique (setting_id,blog_id)
  56      </action>
  57    </test>
  58    
  59    <!-- Version 2.0 beta 2.2
  60    ===================================================== -->
  61    <test type="version" name="2.0-beta2.2">
  62      <action silent="1">
  63        ALTER TABLE {{PREFIX}}session ALTER ses_id TYPE varchar(40)
  64      </action>
  65    </test>
  66    
  67    <!-- Version 2.0 beta 2.3
  68    ===================================================== -->
  69    <!-- PostgreSQL specific. Creating new indexes -->
  70    <test type="version" name="2.0-beta2.3">
  71      <action>create index {{PREFIX}}idx_category_blog_id
  72      on {{PREFIX}}category using btree (blog_id)</action>
  73      
  74      <action>create index {{PREFIX}}idx_link_blog_id
  75      on {{PREFIX}}link using btree (blog_id)</action>
  76      
  77      <action>create index {{PREFIX}}idx_setting_blog_id
  78      on {{PREFIX}}setting using btree (blog_id)</action>
  79      
  80      <action>create index {{PREFIX}}idx_user_user_default_blog
  81      on {{PREFIX}}user using btree (user_default_blog)</action>
  82      
  83      <action>create index {{PREFIX}}idx_permissions_blog_id
  84      on {{PREFIX}}permissions using btree (blog_id)</action>
  85      
  86      <action>create index {{PREFIX}}idx_post_cat_id
  87      on {{PREFIX}}post using btree (cat_id)</action>
  88      
  89      <action>create index {{PREFIX}}idx_post_user_id
  90      on {{PREFIX}}post using btree (user_id)</action>
  91      
  92      <action>create index {{PREFIX}}idx_post_blog_id
  93      on {{PREFIX}}post using btree (blog_id)</action>
  94      
  95      <action>create index {{PREFIX}}idx_meta_post_id
  96      on {{PREFIX}}meta using btree (post_id)</action>
  97      
  98      <action>create index {{PREFIX}}idx_media_user_id
  99      on {{PREFIX}}media using btree (user_id)</action>
 100      
 101      <action>create index {{PREFIX}}idx_post_media_post_id
 102      on {{PREFIX}}post_media using btree (post_id)</action>
 103      
 104      <action>create index {{PREFIX}}idx_log_user_id
 105      on {{PREFIX}}log using btree (user_id)</action>
 106      
 107      <action>create index {{PREFIX}}idx_comment_post_id
 108      on {{PREFIX}}comment using btree (post_id)</action>
 109      
 110      <action>create index {{PREFIX}}idx_spamrule_blog_id
 111      on {{PREFIX}}spamrule using btree (blog_id)</action>
 112    </test>
 113    
 114    <!-- Common 2.3 upgrade -->
 115    <test type="version" name="2.0-beta2.3">
 116      <action>create index {{PREFIX}}idx_post_post_dt
 117      on {{PREFIX}}post using btree (post_dt)</action>
 118      
 119      <action>create index {{PREFIX}}idx_blog_blog_upddt
 120      on {{PREFIX}}blog using btree (blog_upddt)</action>
 121    </test>
 122    
 123    <!-- Version 2.0 beta 3.2
 124    ===================================================== -->
 125    <test type="version" name="2.0-beta3.2">
 126      <action>create index {{PREFIX}}idx_user_user_super
 127      on {{PREFIX}}user using btree (user_super)</action>
 128    </test>
 129    
 130    <!-- Version 2.0 beta 3.3
 131    ===================================================== -->
 132    <test type="version" name="2.0-beta3.3">
 133      <action>alter table {{PREFIX}}media add
 134      media_dir varchar(32) not null default '.'</action>
 135    </test>
 136    
 137    <!-- Version 2.0 beta 3.4
 138    ===================================================== -->
 139    <test type="version" name="2.0-beta3.4">
 140      <action>alter table {{PREFIX}}comment add
 141      comment_spam_filter varchar(32) null default null</action>
 142    </test>
 143    
 144    <!-- Version 2.0 beta 5.3
 145    ===================================================== -->
 146    <test type="version" name="2.0-beta5.3">
 147      <action>alter table {{PREFIX}}media alter
 148      media_dir type varchar(255)</action>
 149    </test>
 150    
 151    <!-- Version 2.0 beta 5.4
 152    ===================================================== -->
 153    <test type="version" name="2.0-beta5.4">
 154      <action>create index {{PREFIX}}idx_post_post_dt_post_id
 155      on {{PREFIX}}post using btree(post_dt, post_id);</action>
 156    </test>
 157    
 158    <!-- Version 2.0 beta 5.5
 159    ===================================================== -->
 160    <test type="version" name="2.0-beta5.5">
 161      <action>create index {{PREFIX}}idx_blog_post_post_dt_post_id
 162      on {{PREFIX}}post using btree (blog_id, post_dt, post_id)</action>
 163    </test>
 164  </database>