[geeklog-cvs] Geeklog-1.x/sql mssql_tableanddata.php,1.34,1.35
Dirk Haun
dhaun at qs1489.pair.com
Sat Apr 12 10:37:34 EDT 2008
Update of /cvsroot/geeklog/Geeklog-1.x/sql
In directory qs1489.pair.com:/tmp/cvs-serv38458/sql
Modified Files:
mssql_tableanddata.php
Log Message:
An attempt to update the MS SQL tables and data ...
Index: mssql_tableanddata.php
===================================================================
RCS file: /cvsroot/geeklog/Geeklog-1.x/sql/mssql_tableanddata.php,v
retrieving revision 1.34
retrieving revision 1.35
diff -C2 -d -r1.34 -r1.35
*** mssql_tableanddata.php 21 Feb 2008 19:52:52 -0000 1.34
--- mssql_tableanddata.php 12 Apr 2008 14:37:32 -0000 1.35
***************
*** 1,6 ****
<?php
- $_SQL = array();
-
$_SQL[] = "begin tran";
--- 1,5 ----
<?php
+ $_SQL = array();
$_SQL[] = "begin tran";
***************
*** 16,21 ****
";
-
-
$_SQL[] = "ALTER TABLE [dbo].[dateCommandCrossReference] ADD
CONSTRAINT [DF_commandCrossReference_isDateName] DEFAULT (0) FOR [isDateName],
--- 15,18 ----
***************
*** 27,31 ****
";
-
$_SQL[] = "
CREATE TABLE [dbo].[{$_TABLES['access']}] (
--- 24,27 ----
***************
*** 43,48 ****
";
-
-
$_SQL[] = "
CREATE TABLE [dbo].[{$_TABLES['blocks']}] (
--- 39,42 ----
***************
*** 55,58 ****
--- 49,53 ----
[blockorder] [numeric](5, 0) NOT NULL ,
[content] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [allow_autotags] [tinyint] NOT NULL ,
[rdfurl] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[rdfupdated] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
***************
*** 68,73 ****
[perm_group] [tinyint] NOT NULL ,
[perm_members] [tinyint] NOT NULL ,
! [perm_anon] [tinyint] NOT NULL ,
! [allow_autotags] [tinyint] NOT NULL ,
) ON [PRIMARY]
";
--- 63,67 ----
[perm_group] [tinyint] NOT NULL ,
[perm_members] [tinyint] NOT NULL ,
! [perm_anon] [tinyint] NOT NULL
) ON [PRIMARY]
";
***************
*** 87,91 ****
";
-
$_SQL[] = "
CREATE TABLE [dbo].[{$_TABLES['comments']}] (
--- 81,84 ----
***************
*** 137,190 ****
$_SQL[] = "
- CREATE TABLE [dbo].[{$_TABLES['events']}] (
- [eid] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
- [title] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
- [description] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
- [postmode] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
- [datestart] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
- [dateend] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
- [url] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
- [hits] [numeric](8, 0) NULL ,
- [owner_id] [numeric](8, 0) NULL ,
- [group_id] [numeric](8, 0) NULL ,
- [perm_owner] [tinyint] NULL ,
- [perm_group] [tinyint] NULL ,
- [perm_members] [tinyint] NULL ,
- [perm_anon] [tinyint] NULL ,
- [address1] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
- [address2] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
- [city] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
- [state] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
- [zipcode] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
- [allday] [smallint] NULL ,
- [event_type] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
- [location] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
- [timestart] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
- [timeend] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
- ) ON [PRIMARY]
- ";
-
- $_SQL[] = "
- CREATE TABLE [dbo].[{$_TABLES['eventsubmission']}] (
- [eid] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
- [title] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
- [description] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
- [location] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
- [datestart] [smalldatetime] NULL ,
- [dateend] [smalldatetime] NULL ,
- [url] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
- [allday] [smallint] NOT NULL ,
- [zipcode] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
- [state] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
- [city] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
- [address2] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
- [address1] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
- [event_type] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
- [timestart] [smalldatetime] NULL ,
- [timeend] [smalldatetime] NULL
- ) ON [PRIMARY]
- ";
-
- $_SQL[] = "
CREATE TABLE [dbo].[{$_TABLES['featurecodes']}] (
[code] [smallint] NOT NULL ,
--- 130,133 ----
***************
*** 209,213 ****
";
-
$_SQL[] = "
CREATE TABLE [dbo].[{$_TABLES['group_assignments']}] (
--- 152,155 ----
***************
*** 218,222 ****
";
-
$_SQL[] = "
CREATE TABLE [dbo].[{$_TABLES['groups']}] (
--- 160,163 ----
***************
*** 228,267 ****
";
-
-
-
- $_SQL[] = "
- CREATE TABLE [dbo].[{$_TABLES['links']}] (
- [lid] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
- [category] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
- [url] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
- [description] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
- [title] [varchar] (96) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
- [hits] [int] NOT NULL ,
- [date] [datetime] NULL ,
- [owner_id] [numeric](8, 0) NOT NULL ,
- [group_id] [numeric](8, 0) NOT NULL ,
- [perm_owner] [tinyint] NOT NULL ,
- [perm_group] [tinyint] NOT NULL ,
- [perm_members] [tinyint] NOT NULL ,
- [perm_anon] [tinyint] NOT NULL
- ) ON [PRIMARY]
- ";
-
-
- $_SQL[] = "
- CREATE TABLE [dbo].[{$_TABLES['linksubmission']}] (
- [lid] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
- [category] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
- [url] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
- [description] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
- [title] [varchar] (96) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
- [hits] [int] NULL ,
- [date] [datetime] NULL,
- [owner_id] [numeric](8, 0) NOT NULL ,
- ) ON [PRIMARY]
- ";
-
-
$_SQL[] = "
CREATE TABLE [dbo].[{$_TABLES['maillist']}] (
--- 169,172 ----
***************
*** 271,305 ****
";
-
- $_SQL[] = "
- CREATE TABLE [dbo].[{$_TABLES['personal_events']}] (
- [eid] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
- [title] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
- [event_type] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
- [datestart] [smalldatetime] NULL ,
- [dateend] [smalldatetime] NULL ,
- [address1] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
- [address2] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
- [city] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
- [state] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
- [zipcode] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
- [allday] [smallint] NOT NULL ,
- [url] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
- [description] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
- [postmode] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
- [owner_id] [numeric](8, 0) NOT NULL ,
- [group_id] [numeric](8, 0) NOT NULL ,
- [perm_owner] [tinyint] NOT NULL ,
- [perm_group] [tinyint] NOT NULL ,
- [perm_members] [tinyint] NOT NULL ,
- [perm_anon] [tinyint] NOT NULL ,
- [uid] [int] NOT NULL ,
- [location] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
- [timestart] [smalldatetime] NULL ,
- [timeend] [smalldatetime] NULL
- ) ON [PRIMARY]
- ";
-
-
$_SQL[] = "
CREATE TABLE [dbo].[{$_TABLES['pingservice']}] (
--- 176,179 ----
***************
*** 313,317 ****
";
-
$_SQL[] = "
CREATE TABLE [dbo].[{$_TABLES['plugins']}] (
--- 187,190 ----
***************
*** 324,368 ****
";
-
- $_SQL[] = "
- CREATE TABLE [dbo].[{$_TABLES['pollanswers']}] (
- [qid] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
- [aid] [tinyint] NOT NULL ,
- [answer] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
- [votes] [numeric](8, 0) NULL ,
- [remark] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
- ) ON [PRIMARY]
- ";
-
-
- $_SQL[] = "
- CREATE TABLE [dbo].[{$_TABLES['pollquestions']}] (
- [qid] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
- [question] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
- [voters] [numeric](8, 0) NULL ,
- [date] [datetime] NULL ,
- [display] [smallint] NOT NULL ,
- [commentcode] [smallint] NOT NULL ,
- [statuscode] [smallint] NOT NULL ,
- [owner_id] [numeric](8, 0) NOT NULL ,
- [group_id] [numeric](8, 0) NOT NULL ,
- [perm_owner] [tinyint] NOT NULL ,
- [perm_group] [tinyint] NOT NULL ,
- [perm_members] [tinyint] NULL ,
- [perm_anon] [tinyint] NULL
- ) ON [PRIMARY]
- ";
-
-
- $_SQL[] = "
- CREATE TABLE [dbo].[{$_TABLES['pollvoters']}] (
- [id] [numeric](10, 0) IDENTITY (1, 1) NOT NULL ,
- [qid] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
- [ipaddress] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
- [date] [numeric](10, 0) NULL
- ) ON [PRIMARY]
- ";
-
-
$_SQL[] = "
CREATE TABLE [dbo].[{$_TABLES['postmodes']}] (
--- 197,200 ----
***************
*** 372,376 ****
";
-
$_SQL[] = "
CREATE TABLE [dbo].[{$_TABLES['sessions']}] (
--- 204,207 ----
***************
*** 383,387 ****
";
-
$_SQL[] = "
CREATE TABLE [dbo].[{$_TABLES['sortcodes']}] (
--- 214,217 ----
***************
*** 391,403 ****
";
-
- $_SQL[] = "
- CREATE TABLE [dbo].[{$_TABLES['spamx']}] (
- [name] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
- [value] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
- ) ON [PRIMARY]
- ";
-
-
$_SQL[] = "
CREATE TABLE [dbo].[{$_TABLES['speedlimit']}] (
--- 221,224 ----
***************
*** 409,443 ****
";
-
- $_SQL[] = "
- CREATE TABLE [dbo].[{$_TABLES['staticpage']}] (
- [sp_id] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
- [sp_uid] [int] NOT NULL ,
- [sp_title] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
- [sp_content] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
- [sp_hits] [numeric](8, 0) NOT NULL ,
- [sp_date] [datetime] NOT NULL ,
- [sp_format] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
- [sp_onmenu] [tinyint] NOT NULL ,
- [sp_label] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
- [commentcode] [numeric](4, 0) NOT NULL,
- [owner_id] [numeric](8, 0) NOT NULL ,
- [group_id] [numeric](8, 0) NOT NULL ,
- [perm_owner] [tinyint] NOT NULL ,
- [perm_group] [tinyint] NOT NULL ,
- [perm_members] [tinyint] NOT NULL ,
- [perm_anon] [tinyint] NOT NULL ,
- [sp_centerblock] [tinyint] NOT NULL ,
- [sp_help] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
- [sp_tid] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
- [sp_where] [tinyint] NOT NULL ,
- [sp_php] [tinyint] NOT NULL ,
- [sp_nf] [tinyint] NULL ,
- [sp_inblock] [tinyint] NULL ,
- [postmode] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
- ) ON [PRIMARY]
- ";
-
-
$_SQL[] = "
CREATE TABLE [dbo].[{$_TABLES['statuscodes']}] (
--- 230,233 ----
***************
*** 447,451 ****
";
-
$_SQL[] = "
CREATE TABLE [dbo].[{$_TABLES['stories']}] (
--- 237,240 ----
***************
*** 470,473 ****
--- 259,263 ----
[expire] [datetime] NULL ,
[postmode] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+ [advanced_editor_mode] [tinyint] NOT NULL ,
[frontpage] [tinyint] NULL ,
[in_transit] [tinyint] NULL ,
***************
*** 477,482 ****
[perm_group] [tinyint] NOT NULL ,
[perm_members] [tinyint] NOT NULL ,
! [perm_anon] [tinyint] NOT NULL ,
! [advanced_editor_mode] [tinyint] NOT NULL ,
) ON [PRIMARY]
";
--- 267,271 ----
[perm_group] [tinyint] NOT NULL ,
[perm_members] [tinyint] NOT NULL ,
! [perm_anon] [tinyint] NOT NULL
) ON [PRIMARY]
";
***************
*** 495,499 ****
";
-
$_SQL[] = "
CREATE TABLE [dbo].[{$_TABLES['syndication']}] (
--- 284,287 ----
***************
*** 527,531 ****
";
-
$_SQL[] = "
CREATE TABLE [dbo].[{$_TABLES['topics']}] (
--- 315,318 ----
***************
*** 546,550 ****
";
-
$_SQL[] = "
CREATE TABLE [dbo].[{$_TABLES['trackback']}] (
--- 333,336 ----
***************
*** 561,565 ****
";
-
$_SQL[] = "
CREATE TABLE [dbo].[{$_TABLES['trackbackcodes']}] (
--- 347,350 ----
***************
*** 569,573 ****
";
-
$_SQL[] = "
CREATE TABLE [dbo].[{$_TABLES['usercomment']}] (
--- 354,357 ----
***************
*** 579,583 ****
";
-
$_SQL[] = "
CREATE TABLE [dbo].[{$_TABLES['userindex']}] (
--- 363,366 ----
***************
*** 592,596 ****
";
-
$_SQL[] = "
CREATE TABLE [dbo].[{$_TABLES['userinfo']}] (
--- 375,378 ----
***************
*** 607,611 ****
";
-
$_SQL[] = "
CREATE TABLE [dbo].[{$_TABLES['userprefs']}] (
--- 389,392 ----
***************
*** 622,626 ****
";
-
$_SQL[] = "
CREATE TABLE [dbo].[{$_TABLES['users']}] (
--- 403,406 ----
***************
*** 640,649 ****
[language] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[pwrequestid] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
! [status] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
";
-
-
$_SQL[] = "
CREATE TABLE [dbo].[{$_TABLES['vars']}] (
--- 420,428 ----
[language] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[pwrequestid] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
! [status] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
! [num_reminders] [tinyint] NOT NULL
) ON [PRIMARY]
";
$_SQL[] = "
CREATE TABLE [dbo].[{$_TABLES['vars']}] (
***************
*** 653,656 ****
--- 432,654 ----
";
+ // Tables used by the bundled plugins
+
+ // Calendar plugin
+ $_SQL[] = "
+ CREATE TABLE [dbo].[{$_TABLES['events']}] (
+ [eid] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+ [title] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [description] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [postmode] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [datestart] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [dateend] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [url] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [hits] [numeric](8, 0) NULL ,
+ [owner_id] [numeric](8, 0) NULL ,
+ [group_id] [numeric](8, 0) NULL ,
+ [perm_owner] [tinyint] NULL ,
+ [perm_group] [tinyint] NULL ,
+ [perm_members] [tinyint] NULL ,
+ [perm_anon] [tinyint] NULL ,
+ [address1] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [address2] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [city] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [state] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [zipcode] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [allday] [smallint] NULL ,
+ [event_type] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [location] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [timestart] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [timeend] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
+ ) ON [PRIMARY]
+ ";
+
+ $_SQL[] = "
+ CREATE TABLE [dbo].[{$_TABLES['eventsubmission']}] (
+ [eid] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+ [title] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [description] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [location] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [datestart] [smalldatetime] NULL ,
+ [dateend] [smalldatetime] NULL ,
+ [url] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [allday] [smallint] NOT NULL ,
+ [zipcode] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [state] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [city] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [address2] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [address1] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [event_type] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+ [timestart] [smalldatetime] NULL ,
+ [timeend] [smalldatetime] NULL
+ ) ON [PRIMARY]
+ ";
+
+ $_SQL[] = "
+ CREATE TABLE [dbo].[{$_TABLES['personal_events']}] (
+ [eid] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+ [title] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [event_type] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+ [datestart] [smalldatetime] NULL ,
+ [dateend] [smalldatetime] NULL ,
+ [address1] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [address2] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [city] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [state] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [zipcode] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [allday] [smallint] NOT NULL ,
+ [url] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [description] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [postmode] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+ [owner_id] [numeric](8, 0) NOT NULL ,
+ [group_id] [numeric](8, 0) NOT NULL ,
+ [perm_owner] [tinyint] NOT NULL ,
+ [perm_group] [tinyint] NOT NULL ,
+ [perm_members] [tinyint] NOT NULL ,
+ [perm_anon] [tinyint] NOT NULL ,
+ [uid] [int] NOT NULL ,
+ [location] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [timestart] [smalldatetime] NULL ,
+ [timeend] [smalldatetime] NULL
+ ) ON [PRIMARY]
+ ";
+
+ // Links plugin
+ $_SQL[] = "
+ CREATE TABLE [dbo].[{$_TABLES['linkcategories']}] (
+ [cid] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+ [pid] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+ [category] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+ [description] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [tid] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+ [created] [datetime] NULL ,
+ [modified] [datetime] NULL ,
+ [owner_id] [numeric](8, 0) NOT NULL ,
+ [group_id] [numeric](8, 0) NOT NULL ,
+ [perm_owner] [tinyint] NOT NULL ,
+ [perm_group] [tinyint] NOT NULL ,
+ [perm_members] [tinyint] NOT NULL ,
+ [perm_anon] [tinyint] NOT NULL
+ ) ON [PRIMARY]
+ ";
+
+ $_SQL[] = "
+ CREATE TABLE [dbo].[{$_TABLES['links']}] (
+ [lid] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+ [cid] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+ [url] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [description] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [title] [varchar] (96) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [hits] [int] NOT NULL ,
+ [date] [datetime] NULL ,
+ [owner_id] [numeric](8, 0) NOT NULL ,
+ [group_id] [numeric](8, 0) NOT NULL ,
+ [perm_owner] [tinyint] NOT NULL ,
+ [perm_group] [tinyint] NOT NULL ,
+ [perm_members] [tinyint] NOT NULL ,
+ [perm_anon] [tinyint] NOT NULL
+ ) ON [PRIMARY]
+ ";
+
+ $_SQL[] = "
+ CREATE TABLE [dbo].[{$_TABLES['linksubmission']}] (
+ [lid] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+ [cid] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+ [url] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [description] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [title] [varchar] (96) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [hits] [int] NULL ,
+ [date] [datetime] NULL ,
+ [owner_id] [numeric](8, 0) NOT NULL
+ ) ON [PRIMARY]
+ ";
+
+ // Polls plugin
+ $_SQL[] = "
+ CREATE TABLE [dbo].[{$_TABLES['pollanswers']}] (
+ [pid] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+ [qid] [int] NOT NULL ,
+ [aid] [tinyint] NOT NULL ,
+ [answer] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [votes] [numeric](8, 0) NULL ,
+ [remark] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
+ ) ON [PRIMARY]
+ ";
+
+ $_SQL[] = "
+ CREATE TABLE [dbo].[{$_TABLES['pollquestions']}] (
+ [qid] [int] NOT NULL ,
+ [pid] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+ [question] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ ) ON [PRIMARY]
+ ";
+
+ $_SQL[] = "
+ CREATE TABLE [dbo].[{$_TABLES['polltopics']}] (
+ [pid] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+ [topic] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [voters] [numeric](8, 0) NULL ,
+ [questions] [int] NOT NULL ,
+ [date] [datetime] NULL ,
+ [display] [tinyint] NOT NULL ,
+ [open] [tinyint] NOT NULL ,
+ [hideresults] [tinyint] NOT NULL ,
+ [commentcode] [smallint] NOT NULL ,
+ [statuscode] [smallint] NOT NULL ,
+ [owner_id] [numeric](8, 0) NOT NULL ,
+ [group_id] [numeric](8, 0) NOT NULL ,
+ [perm_owner] [tinyint] NOT NULL ,
+ [perm_group] [tinyint] NOT NULL ,
+ [perm_members] [tinyint] NOT NULL ,
+ [perm_anon] [tinyint] NOT NULL
+ ) ON [PRIMARY]
+ ";
+
+ $_SQL[] = "
+ CREATE TABLE [dbo].[{$_TABLES['pollvoters']}] (
+ [id] [numeric](10, 0) IDENTITY (1, 1) NOT NULL ,
+ [pid] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+ [ipaddress] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+ [date] [numeric](10, 0) NULL
+ ) ON [PRIMARY]
+ ";
+
+ // Spam-X plugin
+ $_SQL[] = "
+ CREATE TABLE [dbo].[{$_TABLES['spamx']}] (
+ [name] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+ [value] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
+ ) ON [PRIMARY]
+ ";
+
+ // Static Pages plugin
+ $_SQL[] = "
+ CREATE TABLE [dbo].[{$_TABLES['staticpage']}] (
+ [sp_id] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+ [sp_uid] [int] NOT NULL ,
+ [sp_title] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+ [sp_content] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+ [sp_hits] [numeric](8, 0) NOT NULL ,
+ [sp_date] [datetime] NOT NULL ,
+ [sp_format] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+ [sp_onmenu] [tinyint] NOT NULL ,
+ [sp_label] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [commentcode] [smallint] NOT NULL ,
+ [owner_id] [numeric](8, 0) NOT NULL ,
+ [group_id] [numeric](8, 0) NOT NULL ,
+ [perm_owner] [tinyint] NOT NULL ,
+ [perm_group] [tinyint] NOT NULL ,
+ [perm_members] [tinyint] NOT NULL ,
+ [perm_anon] [tinyint] NOT NULL ,
+ [sp_centerblock] [tinyint] NOT NULL ,
+ [sp_help] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [sp_tid] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+ [sp_where] [tinyint] NOT NULL ,
+ [sp_php] [tinyint] NOT NULL ,
+ [sp_nf] [tinyint] NULL ,
+ [sp_inblock] [tinyint] NULL ,
+ [postmode] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
+ ) ON [PRIMARY]
+ ";
***************
*** 775,778 ****
--- 773,782 ----
";
+ $_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['linkcategories']}] ADD
+ CONSTRAINT [PK_gl_linksubmission] PRIMARY KEY CLUSTERED
+ (
+ [pid]
+ ) ON [PRIMARY]
+ ";
$_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['links']}] ADD
***************
*** 836,839 ****
--- 840,850 ----
(
[qid]
+ ) ON [PRIMARY]
+ ";
+
+ $_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['polltopics']}] ADD
+ CONSTRAINT [PK_gl_pollvoters] PRIMARY KEY CLUSTERED
+ (
+ [pid]
) ON [PRIMARY]
";
More information about the geeklog-cvs
mailing list