[Sommaire] [Imprimer]

   1  <?php
   2  
   3  /* Reminder: always indent with 4 spaces (no tabs). */
   4  // +---------------------------------------------------------------------------+
   5  // | Calendar 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  // $Id: mssql_install.php,v 1.3 2006/10/11 01:36:11 blaine Exp $
  35  
  36  
  37  $_SQL[] = "
  38  CREATE TABLE [dbo].[{$_TABLES['events']}] (
  39      [eid] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
  40      [title] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
  41      [description] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
  42      [postmode] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
  43      [datestart] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
  44      [dateend] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
  45      [url] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
  46      [hits] [numeric](8, 0) NULL ,
  47      [owner_id] [numeric](8, 0) NULL ,
  48      [group_id] [numeric](8, 0) NULL ,
  49      [perm_owner] [tinyint] NULL ,
  50      [perm_group] [tinyint] NULL ,
  51      [perm_members] [tinyint] NULL ,
  52      [perm_anon] [tinyint] NULL ,
  53      [address1] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
  54      [address2] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
  55      [city] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
  56      [state] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
  57      [zipcode] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
  58      [allday] [smallint] NULL ,
  59      [event_type] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
  60      [location] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
  61      [timestart] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
  62      [timeend] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
  63  ) ON [PRIMARY]
  64  ";
  65  
  66  $_SQL[] = "
  67  CREATE TABLE [dbo].[{$_TABLES['eventsubmission']}] (
  68      [eid] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
  69      [title] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
  70      [description] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
  71      [location] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
  72      [datestart] [smalldatetime] NULL ,
  73      [dateend] [smalldatetime] NULL ,
  74      [url] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
  75      [allday] [smallint] NOT NULL ,
  76      [zipcode] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
  77      [state] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
  78      [city] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
  79      [address2] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
  80      [address1] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
  81      [event_type] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
  82      [timestart] [smalldatetime] NULL ,
  83      [timeend] [smalldatetime] NULL
  84  ) ON [PRIMARY] 
  85  ";
  86  
  87  $_SQL[] = "
  88  CREATE TABLE [dbo].[{$_TABLES['personal_events']}] (
  89      [eid] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
  90      [title] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
  91      [event_type] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
  92      [datestart] [smalldatetime] NULL ,
  93      [dateend] [smalldatetime] NULL ,
  94      [address1] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
  95      [address2] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
  96      [city] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
  97      [state] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
  98      [zipcode] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
  99      [allday] [smallint] NOT NULL ,
 100      [url] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
 101      [description] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
 102      [postmode] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
 103      [owner_id] [numeric](8, 0) NOT NULL ,
 104      [group_id] [numeric](8, 0) NOT NULL ,
 105      [perm_owner] [tinyint] NOT NULL ,
 106      [perm_group] [tinyint] NOT NULL ,
 107      [perm_members] [tinyint] NOT NULL ,
 108      [perm_anon] [tinyint] NOT NULL ,
 109      [uid] [int] NOT NULL ,
 110      [location] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
 111      [timestart] [smalldatetime] NULL ,
 112      [timeend] [smalldatetime] NULL
 113  ) ON [PRIMARY] 
 114  ";
 115  
 116  
 117  $_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['events']}] ADD
 118      CONSTRAINT [PK_gl_events] PRIMARY KEY  CLUSTERED
 119      (
 120          [eid]
 121      )  ON [PRIMARY]
 122  ";
 123  
 124  $_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['eventsubmission']}] ADD
 125      CONSTRAINT [PK_gl_eventsubmission] PRIMARY KEY  CLUSTERED
 126      (
 127          [eid]
 128      )  ON [PRIMARY]
 129  ";
 130  
 131  $_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['personal_events']}] ADD
 132      CONSTRAINT [PK_gl_personal_events] PRIMARY KEY  CLUSTERED
 133      (
 134          [eid],
 135          [uid]
 136      )  ON [PRIMARY]
 137  ";
 138  
 139  
 140  $_SQL[] = "INSERT INTO {$_TABLES['eventsubmission']} (eid, title, description, location, datestart, dateend, url, allday, zipcode, state, city, address2, address1, event_type, timestart, timeend) VALUES ('2006051410130162','Installed the Calendar plugin','Today, you successfully installed the Calendar plugin.','Your webserver',getdate(),getdate(),'http://www.geeklog.net/',1,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL)";
 141  $_SQL[] = "INSERT INTO {$_TABLES['blocks']} (is_enabled, name, type, title, tid, blockorder, content, onleft, phpblockfn, owner_id, group_id, perm_owner, perm_group) VALUES (1,'events_block','phpblock','Events','all',4,'',1,'phpblock_calendar',{$_USER['uid']},#group#,3,3)";
 142  
 143  ?>