[Sommaire] [Imprimer]

   1  <?php
   2  
   3  /* Reminder: always indent with 4 spaces (no tabs). */
   4  // +---------------------------------------------------------------------------+
   5  // | Links Plugin 1.0                                                          |
   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  // |          Mark Limburg      - mlimburg AT users DOT sourceforge DOT net    |
  13  // |          Jason Whittenburg - jwhitten AT securitygeeks DOT com            |
  14  // |          Dirk Haun         - dirk AT haun-online DOT de                   |
  15  // |          Trinity Bays      - trinity AT steubentech DOT com               |
  16  // |          Randy Kolenko     - randy AT nextide DOT ca                      |
  17  // +---------------------------------------------------------------------------+
  18  // |                                                                           |
  19  // | This program is licensed under the terms of the GNU General Public License|
  20  // | as published by the Free Software Foundation; either version 2            |
  21  // | of the License, or (at your option) any later version.                    |
  22  // |                                                                           |
  23  // | This program is distributed in the hope that it will be useful,           |
  24  // | but WITHOUT ANY WARRANTY; without even the implied warranty of            |
  25  // | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.                      |
  26  // | See the GNU General Public License for more details.                      |
  27  // |                                                                           |
  28  // | You should have received a copy of the GNU General Public License         |
  29  // | along with this program; if not, write to the Free Software Foundation,   |
  30  // | Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.           |
  31  // |                                                                           |
  32  // +---------------------------------------------------------------------------+
  33  //
  34  
  35  /**
  36   * Links plugin Installation SQL
  37   *
  38   * @package Links
  39   * @filesource
  40   * @version 1.0
  41   * @since GL 1.4.0
  42   * @copyright Copyright &copy; 2005
  43   * @license http://opensource.org/licenses/gpl-license.php GNU Public License
  44   * @author Trinity Bays <trinity93@steubentech.com>
  45   * @author Tony Bibbs <tony@tonybibbs.com>
  46   * @author Tom Willett <twillett@users.sourceforge.net>
  47   * @author Blaine Lang <langmail@sympatico.ca>
  48   * @author Dirk Haun <dirk@haun-online.de>
  49   *
  50   */
  51  
  52  
  53  
  54   $_SQL[] = "
  55  CREATE TABLE [dbo].[{$_TABLES['links']}] (
  56      [lid] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
  57      [category] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
  58      [url] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
  59      [description] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
  60      [title] [varchar] (96) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
  61      [hits] [int] NOT NULL ,
  62      [date] [datetime] NULL ,
  63      [owner_id] [numeric](8, 0) NOT NULL ,
  64      [group_id] [numeric](8, 0) NOT NULL ,
  65      [perm_owner] [tinyint] NOT NULL ,
  66      [perm_group] [tinyint] NOT NULL ,
  67      [perm_members] [tinyint] NOT NULL ,
  68      [perm_anon] [tinyint] NOT NULL
  69  ) ON [PRIMARY] 
  70  ";
  71  
  72  
  73  $_SQL[] = "
  74  CREATE TABLE [dbo].[{$_TABLES['linksubmission']}] (
  75      [lid] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
  76      [category] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
  77      [url] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
  78      [description] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
  79      [title] [varchar] (96) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
  80      [hits] [int] NULL ,
  81      [date] [datetime] NULL
  82  ) ON [PRIMARY] 
  83  ";
  84  
  85  
  86  $_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['links']}] ADD
  87      CONSTRAINT [DF_gl_links_perm_group] DEFAULT (3) FOR [perm_group],
  88      CONSTRAINT [DF_gl_links_perm_anon] DEFAULT (2) FOR [perm_anon],
  89      CONSTRAINT [DF_gl_links_perm_members] DEFAULT (2) FOR [perm_members],
  90      CONSTRAINT [DF_gl_links_perm_owner] DEFAULT (3) FOR [perm_owner],
  91      CONSTRAINT [DF_gl_links_hits] DEFAULT (0) FOR [hits],
  92      CONSTRAINT [PK_gl_links] PRIMARY KEY  CLUSTERED
  93      (
  94          [lid]
  95      )  ON [PRIMARY]
  96  ";
  97  
  98  $_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['linksubmission']}] ADD
  99      CONSTRAINT [PK_gl_linksubmission] PRIMARY KEY  CLUSTERED
 100      (
 101          [lid]
 102      )  ON [PRIMARY]
 103  ";
 104  
 105  ?>