[Sommaire] [Imprimer]

   1  <?php
   2  
   3  /* Reminder: always indent with 4 spaces (no tabs). */
   4  // +---------------------------------------------------------------------------+
   5  // | Static Pages Plugin 1.4.2                                                 |
   6  // +---------------------------------------------------------------------------+
   7  // | Installation SQL                                                          |
   8  // +---------------------------------------------------------------------------+
   9  // | Copyright (C) 2000-2006 by the following authors:                         |
  10  // |                                                                           |
  11  // | Authors: Tony Bibbs       - tony AT tonybibbs DOT com                     |
  12  // |          Tom Willett      - twillett AT users DOT sourceforge DOT net     |
  13  // |          Blaine Lang      - langmail AT sympatico DOT ca                  |
  14  // |          Dirk Haun        - dirk AT haun-online DOT de                    |
  15  // +---------------------------------------------------------------------------+
  16  // |                                                                           |
  17  // | This program is licensed under the terms of the GNU General Public License|
  18  // | as published by the Free Software Foundation; either version 2            |
  19  // | of the License, or (at your option) any later version.                    |
  20  // |                                                                           |
  21  // | This program is distributed in the hope that it will be useful,           |
  22  // | but WITHOUT ANY WARRANTY; without even the implied warranty of            |
  23  // | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.                      |
  24  // | See the GNU General Public License for more details.                      |
  25  // |                                                                           |
  26  // | You should have received a copy of the GNU General Public License         |
  27  // | along with this program; if not, write to the Free Software Foundation,   |
  28  // | Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.           |
  29  // |                                                                           |
  30  // +---------------------------------------------------------------------------+
  31  //
  32  // $Id: mysql_install.php,v 1.2 2006/08/24 07:31:49 ospiess Exp $
  33  
  34  $_SQL[] = "
  35  CREATE TABLE {$_TABLES['staticpage']} (
  36    sp_id varchar(40) NOT NULL default '',
  37    sp_uid mediumint(8) NOT NULL default '1',
  38    sp_title varchar(128) NOT NULL default '',
  39    sp_content text NOT NULL,
  40    sp_hits mediumint(8) unsigned NOT NULL default '0',
  41    sp_date datetime NOT NULL default '0000-00-00 00:00:00',
  42    sp_format varchar(20) NOT NULL default '',
  43    sp_onmenu tinyint(1) unsigned NOT NULL default '0',
  44    sp_label varchar(64) default NULL,
  45    owner_id mediumint(8) unsigned NOT NULL default '1',
  46    group_id mediumint(8) unsigned NOT NULL default '1',
  47    perm_owner tinyint(1) unsigned NOT NULL default '3',
  48    perm_group tinyint(1) unsigned NOT NULL default '2',
  49    perm_members tinyint(1) unsigned NOT NULL default '2',
  50    perm_anon tinyint(1) unsigned NOT NULL default '2',
  51    sp_centerblock tinyint(1) unsigned NOT NULL default '0',
  52    sp_help varchar(255) default '',
  53    sp_tid varchar(20) NOT NULL default 'none',
  54    sp_where tinyint(1) unsigned NOT NULL default '1',
  55    sp_php tinyint(1) unsigned NOT NULL default '0',
  56    sp_nf tinyint(1) unsigned default '0',
  57    sp_inblock tinyint(1) unsigned default '1',
  58    postmode varchar(16) NOT NULL default 'html',
  59    PRIMARY KEY  (sp_id),
  60    KEY staticpage_sp_uid (sp_uid),
  61    KEY staticpage_sp_date (sp_date),
  62    KEY staticpage_sp_onmenu (sp_onmenu),
  63    KEY staticpage_sp_centerblock (sp_centerblock),
  64    KEY staticpage_sp_tid (sp_tid),
  65    KEY staticpage_sp_where (sp_where)
  66  ) TYPE=MyISAM
  67  ";
  68  
  69  ?>