[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  
  41      <action id="articles" label="Create table %s" string="{{PREFIX}}articles">
  42          <test eq="neq" value="{{PREFIX}}articles" label="Table %s exists"
  43          string="{{PREFIX}}articles">SHOW TABLES LIKE '{{PREFIX}}articles'</test>
  44          CREATE TABLE {{PREFIX}}articles (
  45          page_id int(10) unsigned NOT NULL auto_increment,
  46          resource_id int(10) unsigned NOT NULL default '0',
  47          page_number int(10) unsigned NOT NULL default '0',
  48          page_title varchar(250) NOT NULL default '',
  49          page_content text NOT NULL,
  50          page_creationdate bigint(20) unsigned NOT NULL default '0',
  51          page_modifdate bigint(20) unsigned NOT NULL default '0',
  52          PRIMARY KEY	(page_id),
  53          KEY resource_id (resource_id)
  54          ) {{TYPE}} {{CHARSET}}
  55      </action>
  56  
  57      <action id="authorasso" label="Create table %s" string="{{PREFIX}}authorasso">
  58          <test eq="neq" value="{{PREFIX}}authorasso" label="Table %s exists"
  59          string="{{PREFIX}}authorasso">SHOW TABLES LIKE '{{PREFIX}}authorasso'</test>
  60          CREATE TABLE {{PREFIX}}authorasso (
  61          user_id int(10) unsigned NOT NULL default '0',
  62          resource_id int(10) unsigned NOT NULL default '0',
  63          authorasso_type int(11) NOT NULL default '0',
  64          authorasso_date bigint(20) unsigned NOT NULL default '0',
  65          PRIMARY KEY	(user_id,resource_id,authorasso_type)
  66          ) {{TYPE}} {{CHARSET}}
  67      </action>
  68  
  69      <action id="categories" label="Create table %s" string="{{PREFIX}}categories">
  70          <test eq="neq" value="{{PREFIX}}categories" label="Table %s exists"
  71          string="{{PREFIX}}categories">SHOW TABLES LIKE '{{PREFIX}}categories'</test>
  72          CREATE TABLE {{PREFIX}}categories (
  73          category_id int(10) unsigned NOT NULL auto_increment,
  74          category_parentid int(10) unsigned NOT NULL default '0',
  75          website_id varchar(50) NOT NULL default '',
  76          category_name varchar(250) NOT NULL default '',
  77          category_description text NOT NULL,
  78          category_keywords text NOT NULL,
  79          category_path varchar(250) NOT NULL default '',
  80          category_publicationdate bigint(20) NOT NULL default '0',
  81          category_creationdate bigint(20) NOT NULL default '0',
  82          category_enddate bigint(20) NOT NULL default '0',
  83          category_template varchar(250) NOT NULL default '',
  84          category_type varchar(50) NOT NULL default '',
  85          category_cachetime int(10) unsigned NOT NULL default '0',
  86          image_id int(10) unsigned NOT NULL default '0',
  87          icon_id int(10) unsigned NOT NULL default '0',
  88          forum_id int(10) unsigned NOT NULL default '0',
  89          PRIMARY KEY	(category_id),
  90          KEY category_parentid (category_parentid),
  91          KEY website_id (website_id),
  92          KEY category_path (category_path),
  93          KEY category_publicationdate (category_publicationdate),
  94          KEY category_enddate (category_enddate)
  95          ) {{TYPE}} {{CHARSET}}
  96      </action>
  97  
  98      <action id="categoryasso" label="Create table %s" string="{{PREFIX}}categoryasso">
  99          <test eq="neq" value="{{PREFIX}}categoryasso" label="Table %s exists"
 100          string="{{PREFIX}}categoryasso">SHOW TABLES LIKE '{{PREFIX}}categoryasso'</test>
 101          CREATE TABLE {{PREFIX}}categoryasso (
 102          category_id int(10) unsigned NOT NULL default '0',
 103          identifier varchar(50) NOT NULL default '',
 104          categoryasso_type int(11) NOT NULL default '0',
 105          template varchar(255) NOT NULL default '',
 106          priority int(11) NOT NULL default '0',
 107          PRIMARY KEY (category_id,identifier),
 108                  KEY identifier_idx (identifier)
 109          ) {{TYPE}} {{CHARSET}}
 110      </action>
 111  
 112      <action id="grants" label="Create table %s" string="{{PREFIX}}grants">
 113          <test eq="neq" value="{{PREFIX}}grants" label="Table %s exists"
 114          string="{{PREFIX}}grants">SHOW TABLES LIKE '{{PREFIX}}grants'</test>
 115          CREATE TABLE {{PREFIX}}grants (
 116          user_id int(10) unsigned NOT NULL default '0',
 117          website_id varchar(50) NOT NULL default '',
 118          level int(11) NOT NULL default '0',
 119          PRIMARY KEY	(user_id,website_id)
 120          ) {{TYPE}} {{CHARSET}}
 121      </action>
 122  
 123      <action id="news" label="Create table %s" string="{{PREFIX}}news">
 124          <test eq="neq" value="{{PREFIX}}news" label="Table %s exists"
 125          string="{{PREFIX}}news">SHOW TABLES LIKE '{{PREFIX}}news'</test>
 126          CREATE TABLE {{PREFIX}}news (
 127          resource_id int(10) unsigned NOT NULL default '0',
 128          news_serial varchar(32) NOT NULL default '',
 129          news_titlewebsite varchar(250) NOT NULL default '',
 130          news_linkwebsite varchar(250) NOT NULL default '',
 131          feed_id int(10) unsigned NOT NULL default '0',
 132          PRIMARY KEY	(resource_id),
 133          KEY news_serial (news_serial),
 134          KEY feed_id (feed_id)
 135          ) {{TYPE}} {{CHARSET}}
 136      </action>
 137  
 138      <action id="resources" label="Create table %s" string="{{PREFIX}}resources">
 139          <test eq="neq" value="{{PREFIX}}resources" label="Table %s exists"
 140          string="{{PREFIX}}resources">SHOW TABLES LIKE '{{PREFIX}}resources'</test>
 141          CREATE TABLE {{PREFIX}}resources (
 142          resource_id int(10) unsigned NOT NULL auto_increment,
 143          website_id varchar(50) NOT NULL default '',
 144          type_id varchar(50) NOT NULL default '',
 145          subtype_id int(11) NOT NULL default '0',
 146          comment_support int(11) NOT NULL default '1',
 147          user_id int(10) unsigned NOT NULL default '0',
 148          identifier varchar(50) NOT NULL default '',
 149          subject text NOT NULL,
 150          creatorname varchar(250) NOT NULL default '',
 151          creatoremail varchar(250) NOT NULL default '',
 152          creatorwebsite varchar(250) NOT NULL default '',
 153          publisher varchar(250) NOT NULL default '',
 154          lang_id varchar(20) NOT NULL default '',
 155          title varchar(250) NOT NULL default '',
 156          description text NOT NULL,
 157          path varchar(250) NOT NULL default '',
 158          creationdate bigint(20) unsigned NOT NULL default '0',
 159          publicationdate bigint(20) unsigned NOT NULL default '0',
 160          modifdate bigint(20) unsigned NOT NULL default '0',
 161          enddate bigint(20) unsigned NOT NULL default '0',
 162          status int(11) NOT NULL default '0',
 163          size varchar(50) NOT NULL default '',
 164          version varchar(50) NOT NULL default '',
 165          metadata text NOT NULL,
 166          comment text NOT NULL,
 167          misc text NOT NULL,
 168          format varchar(100) NOT NULL default '',
 169          dctype varchar(100) NOT NULL default '',
 170          dccoverage varchar(250) NOT NULL default '',
 171          rights varchar(250) NOT NULL default '',
 172          PRIMARY KEY	(resource_id),
 173          KEY path (path),
 174          KEY publicationdate (publicationdate),
 175          KEY enddate (enddate),
 176          KEY status (status),
 177          KEY website_id (website_id),
 178          KEY identifier (identifier)
 179          ) {{TYPE}} {{CHARSET}}
 180      </action>
 181  
 182  <!--    <action id="sequencetable" label="Create table %s" string="{{PREFIX}}sequencetable">
 183          <test eq="neq" value="{{PREFIX}}sequencetable" label="Table %s exists"
 184          string="{{PREFIX}}sequencetable">SHOW TABLES LIKE '{{PREFIX}}sequencetable'</test>
 185          CREATE TABLE {{PREFIX}}sequencetable (
 186          seq_name varchar(250) NOT NULL default '',
 187          nextid bigint(20) NOT NULL default '0',
 188          PRIMARY KEY	(seq_name)
 189          ) {{TYPE}} {{CHARSET}}
 190      </action> -->
 191  
 192      <action id="userprefs" label="Create table %s" string="{{PREFIX}}userprefs">
 193          <test eq="neq" value="{{PREFIX}}userprefs" label="Table %s exists"
 194          string="{{PREFIX}}userprefs">SHOW TABLES LIKE '{{PREFIX}}userprefs'</test>
 195          CREATE TABLE {{PREFIX}}userprefs (
 196          user_id int(11) NOT NULL default '0',
 197          website_id varchar(50) NOT NULL default '',
 198          keyname varchar(50) NOT NULL default '',
 199          data varchar(255) NOT NULL default '',
 200          PRIMARY KEY	(user_id,website_id,keyname)
 201          ) {{TYPE}} {{CHARSET}}
 202      </action>
 203  
 204      <action id="users" label="Create table %s" string="{{PREFIX}}users">
 205          <test eq="neq" value="{{PREFIX}}users" label="Table %s exists"
 206          string="{{PREFIX}}users">SHOW TABLES LIKE '{{PREFIX}}users'</test>
 207          CREATE TABLE {{PREFIX}}users (
 208          user_id int(10) unsigned NOT NULL auto_increment,
 209          user_username varchar(25) NOT NULL default '',
 210          user_password varchar(32) NOT NULL default '',
 211          user_realname varchar(50) NOT NULL default '',
 212          user_email varchar(128) NOT NULL default '',
 213          user_pubemail varchar(128) NOT NULL default '',
 214          user_website varchar(128) NOT NULL default '',
 215          user_company varchar(255) NOT NULL default '',
 216          lang_id varchar(7) NOT NULL default 'en',
 217          country_id char(2) NOT NULL default 'us',
 218          user_lastconnect bigint(20) unsigned NOT NULL default '0',
 219          user_creationdate bigint(20) NOT NULL default '0',
 220          user_active int(10) unsigned NOT NULL default '0',
 221          user_status varchar(255) NOT NULL default '',
 222          user_firstlogin int(10) unsigned NOT NULL default '0',
 223          user_birthdate bigint(20) NOT NULL default '0',
 224          user_gender enum('M','F','NA') NOT NULL default 'NA',
 225          user_image varchar(200) NOT NULL default '',
 226          user_icq varchar(50) NOT NULL default '',
 227          user_aol varchar(50) NOT NULL default '',
 228          user_yahoo varchar(50) NOT NULL default '',
 229          user_msn varchar(50) NOT NULL default '',
 230          user_jabber varchar(50) NOT NULL default '',
 231          user_signature varchar(250) NOT NULL default '',
 232          PRIMARY KEY	(user_id),
 233          UNIQUE KEY user_realname (user_realname),
 234          UNIQUE KEY user_username (user_username),
 235          KEY user_creationdate (user_creationdate),
 236          KEY user_status (user_status)
 237          ) {{TYPE}} {{CHARSET}}
 238      </action>
 239  
 240      <action id="websites" label="Create table %s" string="{{PREFIX}}websites">
 241          <test eq="neq" value="{{PREFIX}}websites" label="Table %s exists"
 242          string="{{PREFIX}}websites">SHOW TABLES LIKE '{{PREFIX}}websites'</test>
 243          CREATE TABLE {{PREFIX}}websites (
 244          website_id varchar(50) NOT NULL default '',
 245          website_name varchar(120) NOT NULL default '',
 246          website_url varchar(250) NOT NULL default '',
 247          website_reurl varchar(50) NOT NULL default '',
 248          website_path varchar(100) NOT NULL default '',
 249          website_xmedia_reurl varchar(250) NOT NULL default '',
 250          website_xmedia_path varchar(100) NOT NULL default '',
 251          website_description text NOT NULL,
 252          website_default int(11) NOT NULL default '0',
 253          website_startdate bigint(20) NOT NULL default '0',
 254          website_active int(11) NOT NULL default '0',
 255          website_color varchar(10) NOT NULL default '',
 256          PRIMARY KEY	(website_id)
 257          ) {{TYPE}} {{CHARSET}}
 258      </action>
 259  
 260      <action id="subtypes" label="Create table %s" string="{{PREFIX}}subtypes">
 261          <test eq="neq" value="{{PREFIX}}subtypes" label="Table %s exists"
 262          string="{{PREFIX}}subtypes">SHOW TABLES LIKE '{{PREFIX}}subtypes'</test>
 263          CREATE TABLE {{PREFIX}}subtypes (
 264          subtype_id int(10) unsigned NOT NULL auto_increment,
 265          type_id varchar(50) NOT NULL default '',
 266          website_id varchar(50) NOT NULL default '',
 267          subtype_name varchar(100) NOT NULL default '',
 268          subtype_template varchar(250) NOT NULL default '',
 269          subtype_cachetime int(11) NOT NULL default '0',
 270          subtype_extra1 varchar(250) NOT NULL default '',
 271          subtype_extra2 varchar(250) NOT NULL default '',
 272          PRIMARY KEY	(subtype_id,type_id,website_id)) {{TYPE}} {{CHARSET}}
 273      </action>
 274  
 275      <action id="searchwords" label="Create table %s" string="{{PREFIX}}searchwords">
 276          <test eq="neq" value="{{PREFIX}}searchwords" label="Table %s exists"
 277          string="{{PREFIX}}searchwords">SHOW TABLES LIKE '{{PREFIX}}searchwords'</test>
 278          CREATE TABLE {{PREFIX}}searchwords (
 279          word_id int(10) unsigned NOT NULL auto_increment,
 280          word VARCHAR( 250 ) NOT NULL ,
 281          PRIMARY KEY ( word_id ) ,
 282          INDEX ( word )) {{TYPE}} {{CHARSET}}
 283      </action>
 284  
 285      <action id="searchocc" label="Create table %s" string="{{PREFIX}}searchocc">
 286          <test eq="neq" value="{{PREFIX}}searchocc" label="Table %s exists"
 287          string="{{PREFIX}}searchocc">SHOW TABLES LIKE '{{PREFIX}}searchocc'</test>
 288          CREATE TABLE {{PREFIX}}searchocc (
 289          word_id int(10) unsigned NOT NULL auto_increment,
 290          resource_id int(10) unsigned NOT NULL default '0',
 291          website_id varchar(50) NOT NULL default '',
 292          occ int(11) NOT NULL default '0',
 293          pondocc float NOT NULL default '0',
 294          PRIMARY KEY	(word_id,resource_id,website_id)
 295          ) {{TYPE}} {{CHARSET}}
 296      </action>
 297  
 298      <action id="search" label="Create table %s" string="{{PREFIX}}search">
 299          <test eq="neq" value="{{PREFIX}}search" label="Table %s exists"
 300          string="{{PREFIX}}search">SHOW TABLES LIKE '{{PREFIX}}search'</test>
 301          CREATE TABLE {{PREFIX}}search (
 302          resource_id int(10) unsigned NOT NULL default '0',
 303          website_id varchar(50) NOT NULL default '',
 304          lastindex bigint(20) unsigned NOT NULL default '0',
 305          nbindex int(10) unsigned NOT NULL default '0',
 306          PRIMARY KEY	(resource_id,website_id),
 307          KEY lastindex (lastindex))    {{TYPE}} {{CHARSET}}
 308      </action>
 309  
 310      <!-- smart404 -->
 311      <action id="smart404" label="Create table %s" string="{{PREFIX}}smart404">
 312          <test eq="neq" value="{{PREFIX}}smart404" label="Table %s exists"
 313          string="{{PREFIX}}smart404">SHOW TABLES LIKE '{{PREFIX}}smart404'</test>
 314          CREATE TABLE {{PREFIX}}smart404 (
 315          website_id varchar(50) NOT NULL default '',
 316          oldpage varchar(255) NOT NULL default '',
 317          newpage varchar(255) NOT NULL default '',
 318          lastroutingdate bigint(20) unsigned NOT NULL default '0',
 319          total int(10) unsigned NOT NULL default '0',
 320          PRIMARY KEY  (website_id,oldpage)
 321          ) {{TYPE}} {{CHARSET}}
 322      </action>
 323  
 324      <!-- smart404logs -->
 325      <action id="smart404logs" label="Create table %s" string="{{PREFIX}}smart404logs">
 326          <test eq="neq" value="{{PREFIX}}smart404logs" label="Table %s exists"
 327          string="{{PREFIX}}smart404logs">SHOW TABLES LIKE '{{PREFIX}}smart404logs'</test>
 328          CREATE TABLE {{PREFIX}}smart404logs (
 329          website_id varchar(50) NOT NULL default '',
 330          page varchar(255) NOT NULL default '',
 331          fromurl varchar(255) NOT NULL default '',
 332          date bigint(20) unsigned NOT NULL default '0',
 333          useragent varchar(255) NOT NULL default '',
 334          KEY website_id (website_id),
 335          KEY page (page),
 336          KEY date (date)
 337          ) {{TYPE}} {{CHARSET}}
 338      </action>
 339  
 340         <!-- comments -->
 341         <action id="comments" label="Create table %s" string="{{PREFIX}}comments">
 342                  <test eq="neq" value="{{PREFIX}}comments" label="Table %s exists."
 343          string="{{PREFIX}}comments">SHOW TABLES LIKE '{{PREFIX}}comments'</test>
 344                  CREATE TABLE {{PREFIX}}comments (
 345          comment_id int(11) NOT NULL auto_increment,
 346          resource_id int(11) NOT NULL default '0',
 347          comment_user_id int(11) NOT NULL default '0',
 348          comment_author varchar(50) NOT NULL default '',
 349          comment_email varchar(255) NOT NULL default '',
 350          comment_website varchar(255) NOT NULL default '',
 351          comment_creation bigint(20) unsigned NOT NULL default '0',
 352          comment_update bigint(20) unsigned NOT NULL default '0',
 353          comment_status int(11) NOT NULL default '0',
 354          comment_type int(11) NOT NULL default '0',
 355          comment_content text NOT NULL,
 356          comment_ip varchar(200) NOT NULL default '',
 357          PRIMARY KEY  (comment_id),
 358          KEY resource_id (resource_id)
 359          ) {{TYPE}} {{CHARSET}}
 360      </action>
 361  
 362  </database>