[ Index ]
 

Code source de Plume CMS 1.2.2

Accédez au Source d'autres logiciels libres

Classes | Fonctions | Variables | Constantes | Tables

title

Body

[fermer]

/manager/tools/link/ -> db-create.xml (source)

   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  # - Sébastien Fievet

  25  #

  26  # Alternatively, the contents of this file may be used under the terms of

  27  # either the GNU General Public License Version 2 or later (the "GPL"), or

  28  # the GNU Lesser General Public License Version 2.1 or later (the "LGPL"),

  29  # in which case the provisions of the GPL or the LGPL are applicable instead

  30  # of those above. If you wish to allow use of your version of this file only

  31  # under the terms of either the GPL or the LGPL, and not to allow others to

  32  # use your version of this file under the terms of the MPL, indicate your

  33  # decision by deleting the provisions above and replace them with the notice

  34  # and other provisions required by the GPL or the LGPL. If you do not delete

  35  # the provisions above, a recipient may use your version of this file under

  36  # the terms of any one of the MPL, the GPL or the LGPL.

  37  #

  38  # ***** END LICENSE BLOCK *****

  39  -->
  40  <database>
  41      
  42      <action id="links" label="Create table %s" string="{{PREFIX}}links">
  43          <test eq="neq" value="{{PREFIX}}links" label="Table %s exists"
  44          string="{{PREFIX}}links">SHOW TABLES LIKE '{{PREFIX}}links'</test>
  45          CREATE TABLE {{PREFIX}}links (
  46          link_id int(10) unsigned NOT NULL auto_increment,
  47          website_id varchar(50) NOT NULL default '',
  48          href varchar(250) NOT NULL default '',
  49          label varchar(250) NOT NULL default '',
  50          title varchar(250) NOT NULL default '',
  51          lang char(2) NOT NULL default '',
  52          rel varchar(250) NOT NULL default '',
  53          position int(10) unsigned NOT NULL default '0',
  54          PRIMARY KEY	(link_id),
  55          KEY website_id (website_id)
  56          ) {{TYPE}} {{CHARSET}}
  57      </action>
  58      
  59      <action id="links.insert.plume" label="Creation of link Plume">
  60          INSERT INTO `{{PREFIX}}links` 
  61          (link_id, website_id, href, label, title, lang, rel, position) VALUES 
  62          (1, 'default', 'http://www.plume-cms.net/', 'PLUME CMS', 'Site officiel de Plume CMS', 'en', '', 1)
  63      </action>
  64      <action id="links.insert.fsf" label="Creation of link FSF">
  65          INSERT INTO `{{PREFIX}}links`
  66          (link_id, website_id, href, label, title, lang, rel, position) VALUES 
  67          (2, 'default', 'http://www.fsf.org/', 'FSF', 'Site de la Free Software Foundation', 'en', '', 2);
  68      </action>
  69      <action id="links.insert.yourlink1" label="Creation of link Your link 1">
  70          INSERT INTO `{{PREFIX}}links`
  71          (link_id, website_id, href, label, title, lang, rel, position) VALUES 
  72          (3, 'default', 'http://www.example.com', 'Your link 1', '', '', '', 3);
  73      </action>
  74      <action id="links.insert.yourlink2" label="Creation of link to Your link 2">
  75          INSERT INTO `{{PREFIX}}links` 
  76          (link_id, website_id, href, label, title, lang, rel, position) VALUES 
  77          (4, 'default', 'http://www.example.com', 'Your link 2', '', '', '', 4);
  78      </action>
  79  
  80  </database>


Généré le : Mon Nov 26 11:57:01 2007 par Balluche grâce à PHPXref 0.7
  Clicky Web Analytics