[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  // |          Randy Kolenko     - randy AT nextide DOT ca                      |
  16  // +---------------------------------------------------------------------------+
  17  // |                                                                           |
  18  // | This program is licensed under the terms of the GNU General Public License|
  19  // | as published by the Free Software Foundation; either version 2            |
  20  // | of the License, or (at your option) any later version.                    |
  21  // |                                                                           |
  22  // | This program is distributed in the hope that it will be useful,           |
  23  // | but WITHOUT ANY WARRANTY; without even the implied warranty of            |
  24  // | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.                      |
  25  // | See the GNU General Public License for more details.                      |
  26  // |                                                                           |
  27  // | You should have received a copy of the GNU General Public License         |
  28  // | along with this program; if not, write to the Free Software Foundation,   |
  29  // | Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.           |
  30  // |                                                                           |
  31  // +---------------------------------------------------------------------------+
  32  //
  33  // $Id: mssql_install.php,v 1.3 2006/10/11 01:36:11 blaine Exp $
  34  
  35  
  36  
  37  $_SQL[] = "
  38  CREATE TABLE [dbo].[{$_TABLES['staticpage']}] (
  39      [sp_id] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
  40      [sp_uid] [int] NOT NULL ,
  41      [sp_title] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
  42      [sp_content] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
  43      [sp_hits] [numeric](8, 0) NOT NULL ,
  44      [sp_date] [datetime] NOT NULL ,
  45      [sp_format] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
  46      [sp_onmenu] [tinyint] NOT NULL ,
  47      [sp_label] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
  48      [owner_id] [numeric](8, 0) NOT NULL ,
  49      [group_id] [numeric](8, 0) NOT NULL ,
  50      [perm_owner] [tinyint] NOT NULL ,
  51      [perm_group] [tinyint] NOT NULL ,
  52      [perm_members] [tinyint] NOT NULL ,
  53      [perm_anon] [tinyint] NOT NULL ,
  54      [sp_centerblock] [tinyint] NOT NULL ,
  55      [sp_help] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
  56      [sp_tid] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
  57      [sp_where] [tinyint] NOT NULL ,
  58      [sp_php] [tinyint] NOT NULL ,
  59      [sp_nf] [tinyint] NULL ,
  60      [sp_inblock] [tinyint] NULL  ,
  61      [postmode] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
  62  ) ON [PRIMARY] 
  63  ";
  64  
  65  $_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['staticpage']}] ADD
  66      CONSTRAINT [DF_gl_staticpage] DEFAULT ('html') FOR [postmode],
  67      CONSTRAINT [PK_gl_staticpage] PRIMARY KEY  CLUSTERED
  68      (
  69          [sp_id]
  70      )  ON [PRIMARY]
  71  ";
  72  
  73  ?>