codes****@googl*****
codes****@googl*****
2009年 4月 6日 (月) 09:54:13 JST
Author: tacahi
Date: Sun Apr 5 17:41:59 2009
New Revision: 1423
Added:
externals/geeklog-1.5.2sr2/sql/
externals/geeklog-1.5.2sr2/sql/mssql_tableanddata.php
externals/geeklog-1.5.2sr2/sql/mysql_tableanddata.php
externals/geeklog-1.5.2sr2/sql/updates/
externals/geeklog-1.5.2sr2/sql/updates/0.1_to_0.2.sql
externals/geeklog-1.5.2sr2/sql/updates/0.2_to_0.3.sql
externals/geeklog-1.5.2sr2/sql/updates/0.3_to_0.4.sql
externals/geeklog-1.5.2sr2/sql/updates/0.4_to_0.5.sql
externals/geeklog-1.5.2sr2/sql/updates/0.5_to_1.0.sql
externals/geeklog-1.5.2sr2/sql/updates/1.0_to_1.1.sql
externals/geeklog-1.5.2sr2/sql/updates/1.1_to_1.2.sql
externals/geeklog-1.5.2sr2/sql/updates/1.2.5-1_to_1.3.NOTES
externals/geeklog-1.5.2sr2/sql/updates/1.2.5-1_to_1.3.sql
externals/geeklog-1.5.2sr2/sql/updates/1.2_to_1.2.2.sql
externals/geeklog-1.5.2sr2/sql/updates/mssql_1.4.1_to_1.5.0.php
externals/geeklog-1.5.2sr2/sql/updates/mssql_1.5.0_to_1.5.1.php
externals/geeklog-1.5.2sr2/sql/updates/mssql_1.5.1_to_1.5.2.php
externals/geeklog-1.5.2sr2/sql/updates/mysql_1.2.5-1_to_1.3.php
externals/geeklog-1.5.2sr2/sql/updates/mysql_1.3.10_to_1.3.11.php
externals/geeklog-1.5.2sr2/sql/updates/mysql_1.3.11_to_1.4.0.php
externals/geeklog-1.5.2sr2/sql/updates/mysql_1.3.1_to_1.3.2.php
externals/geeklog-1.5.2sr2/sql/updates/mysql_1.3.2-1_to_1.3.3.php
externals/geeklog-1.5.2sr2/sql/updates/mysql_1.3.3_to_1.3.4.php
externals/geeklog-1.5.2sr2/sql/updates/mysql_1.3.4_to_1.3.5.php
externals/geeklog-1.5.2sr2/sql/updates/mysql_1.3.5_to_1.3.6.php
externals/geeklog-1.5.2sr2/sql/updates/mysql_1.3.7_to_1.3.8.php
externals/geeklog-1.5.2sr2/sql/updates/mysql_1.3.8_to_1.3.9.php
externals/geeklog-1.5.2sr2/sql/updates/mysql_1.3.9_to_1.3.10.php
externals/geeklog-1.5.2sr2/sql/updates/mysql_1.3_to_1.3.1.php
externals/geeklog-1.5.2sr2/sql/updates/mysql_1.4.0_to_1.4.1.php
externals/geeklog-1.5.2sr2/sql/updates/mysql_1.4.1_to_1.5.0.php
externals/geeklog-1.5.2sr2/sql/updates/mysql_1.5.0_to_1.5.1.php
externals/geeklog-1.5.2sr2/sql/updates/mysql_1.5.1_to_1.5.2.php
Log:
Geeklog 1.5.2sr1を externals/geeklog-1.5.2sr2 に取り込みます。take#4.
Added: externals/geeklog-1.5.2sr2/sql/mssql_tableanddata.php
==============================================================================
--- (empty file)
+++ externals/geeklog-1.5.2sr2/sql/mssql_tableanddata.php Sun Apr 5
17:41:59 2009
@@ -0,0 +1,1802 @@
+<?php
+
+$_SQL = array();
+
+$_SQL[] = "begin tran";
+
+$_SQL[] = "
+CREATE TABLE [dbo].[dateCommandCrossReference] (
+ [id] [int] IDENTITY (1, 1) NOT NULL ,
+ [mysqlCommand] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT
NULL ,
+ [sqlServerCommand] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
+ [isDateName] [bit] NOT NULL ,
+ [isDatePart] [bit] NOT NULL
+) ON [PRIMARY]
+";
+
+$_SQL[] = "ALTER TABLE [dbo].[dateCommandCrossReference] ADD
+ CONSTRAINT [DF_commandCrossReference_isDateName] DEFAULT (0) FOR
[isDateName],
+ CONSTRAINT [DF_commandCrossReference_isDatePart] DEFAULT (1) FOR
[isDatePart],
+ CONSTRAINT [PK_commandCrossReference] PRIMARY KEY CLUSTERED
+ (
+ [id]
+ ) ON [PRIMARY]
+";
+
+$_SQL[] = "
+CREATE TABLE [dbo].[{$_TABLES['access']}] (
+ [acc_ft_id] [int] NOT NULL ,
+ [acc_grp_id] [int] NOT NULL
+) ON [PRIMARY]
+";
+
+$_SQL[] = "
+CREATE TABLE [dbo].[{$_TABLES['article_images']}] (
+ [ai_sid] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+ [ai_img_num] [tinyint] NOT NULL ,
+ [ai_filename] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT
NULL
+) ON [PRIMARY]
+";
+
+$_SQL[] = "
+CREATE TABLE [dbo].[{$_TABLES['blocks']}] (
+ [bid] [numeric](5, 0) IDENTITY (1, 1) NOT NULL ,
+ [is_enabled] [tinyint] NOT NULL ,
+ [name] [varchar] (48) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+ [type] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+ [title] [varchar] (48) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [tid] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+ [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 ,
+ [rdf_last_modified] [varchar] (40) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL ,
+ [rdf_etag] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [rdflimit] [numeric](5, 0) NULL ,
+ [onleft] [tinyint] NULL ,
+ [phpblockfn] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
+ [help] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS 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['commentcodes']}] (
+ [code] [smallint] NOT NULL ,
+ [name] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
+) ON [PRIMARY]
+";
+
+$_SQL[] = "
+CREATE TABLE [dbo].[{$_TABLES['commentmodes']}] (
+ [mode] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+ [name] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
+) ON [PRIMARY]
+";
+
+$_SQL[] = "
+CREATE TABLE [dbo].[{$_TABLES['comments']}] (
+ [cid] [numeric](10, 0) IDENTITY (1, 1) NOT NULL ,
+ [type] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+ [sid] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+ [date] [datetime] NULL ,
+ [title] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [comment] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [score] [smallint] NULL ,
+ [reason] [smallint] NULL ,
+ [pid] [numeric](10, 0) NULL ,
+ [lft] [numeric](10, 0) NULL ,
+ [rht] [numeric](10, 0) NULL ,
+ [indent] [numeric](10, 0) NULL ,
+ [uid] [int] NULL ,
+ [ipaddress] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
+) ON [PRIMARY]
+";
+
+$_SQL[] = "
+CREATE TABLE [dbo].[{$_TABLES['conf_values']}] (
+ [name] [varchar] (50) NULL,
+ [value] [text] NULL,
+ [type] [varchar] (50) NULL,
+ [group_name] [varchar] (50) NULL,
+ [default_value] [text],
+ [subgroup] [int] NULL,
+ [selectionArray] [int] NULL,
+ [sort_order] [int] NULL,
+ [fieldset] [int] NULL )
+ON [PRIMARY]
+";
+
+$_SQL[] = "
+CREATE TABLE [dbo].[{$_TABLES['cookiecodes']}] (
+ [cc_value] [numeric](8, 0) NOT NULL ,
+ [cc_descr] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
+) ON [PRIMARY]
+";
+
+$_SQL[] = "
+CREATE TABLE [dbo].[{$_TABLES['dateformats']}] (
+ [dfid] [smallint] NOT NULL ,
+ [format] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [description] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
+) ON [PRIMARY]
+";
+
+$_SQL[] = "
+CREATE TABLE [dbo].[{$_TABLES['featurecodes']}] (
+ [code] [smallint] NOT NULL ,
+ [name] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
+) ON [PRIMARY]
+";
+
+$_SQL[] = "
+CREATE TABLE [dbo].[{$_TABLES['features']}] (
+ [ft_id] [int] IDENTITY (1, 1) NOT NULL ,
+ [ft_name] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT
NULL ,
+ [ft_descr] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT
NULL ,
+ [ft_gl_core] [smallint] NOT NULL
+) ON [PRIMARY]
+";
+
+$_SQL[] = "
+CREATE TABLE [dbo].[{$_TABLES['frontpagecodes']}] (
+ [code] [smallint] NOT NULL ,
+ [name] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
+) ON [PRIMARY]
+";
+
+$_SQL[] = "
+CREATE TABLE [dbo].[{$_TABLES['group_assignments']}] (
+ [ug_main_grp_id] [int] NOT NULL ,
+ [ug_uid] [numeric](8, 0) NULL ,
+ [ug_grp_id] [numeric](8, 0) NULL
+) ON [PRIMARY]
+";
+
+$_SQL[] = "
+CREATE TABLE [dbo].[{$_TABLES['groups']}] (
+ [grp_id] [int] IDENTITY (1, 1) NOT NULL ,
+ [grp_name] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT
NULL ,
+ [grp_descr] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT
NULL ,
+ [grp_gl_core] [tinyint] NOT NULL
+) ON [PRIMARY]
+";
+
+$_SQL[] = "
+CREATE TABLE [dbo].[{$_TABLES['maillist']}] (
+ [code] [int] NOT NULL ,
+ [name] [char] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
+) ON [PRIMARY]
+";
+
+$_SQL[] = "
+CREATE TABLE [dbo].[{$_TABLES['pingservice']}] (
+ [pid] [numeric](5, 0) IDENTITY (1, 1) NOT NULL ,
+ [name] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [ping_url] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [site_url] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [method] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [is_enabled] [tinyint] NOT NULL
+) ON [PRIMARY]
+";
+
+$_SQL[] = "
+CREATE TABLE [dbo].[{$_TABLES['plugins']}] (
+ [pi_name] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT
NULL ,
+ [pi_version] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT
NULL ,
+ [pi_gl_version] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS
NOT NULL ,
+ [pi_enabled] [tinyint] NOT NULL ,
+ [pi_homepage] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT
NULL
+) ON [PRIMARY]
+";
+
+$_SQL[] = "
+CREATE TABLE [dbo].[{$_TABLES['postmodes']}] (
+ [code] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+ [name] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
+) ON [PRIMARY]
+";
+
+$_SQL[] = "
+CREATE TABLE [dbo].[{$_TABLES['sessions']}] (
+ [sess_id] [numeric](10, 0) NOT NULL ,
+ [start_time] [numeric](10, 0) NOT NULL ,
+ [remote_ip] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT
NULL ,
+ [uid] [int] NOT NULL ,
+ [md5_sess_id] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
+) ON [PRIMARY]
+";
+
+$_SQL[] = "
+CREATE TABLE [dbo].[{$_TABLES['sortcodes']}] (
+ [code] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+ [name] [char] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
+) ON [PRIMARY]
+";
+
+$_SQL[] = "
+CREATE TABLE [dbo].[{$_TABLES['speedlimit']}] (
+ [id] [numeric](10, 0) IDENTITY (1, 1) NOT NULL ,
+ [ipaddress] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT
NULL ,
+ [date] [numeric](10, 0) NULL ,
+ [type] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
+) ON [PRIMARY]
+";
+
+$_SQL[] = "
+CREATE TABLE [dbo].[{$_TABLES['statuscodes']}] (
+ [code] [int] NOT NULL ,
+ [name] [char] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
+) ON [PRIMARY]
+";
+
+$_SQL[] = "
+CREATE TABLE [dbo].[{$_TABLES['stories']}] (
+ [sid] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+ [uid] [int] NOT NULL ,
+ [draft_flag] [tinyint] NULL ,
+ [tid] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+ [date] [datetime] NULL ,
+ [title] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [introtext] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
+ [bodytext] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [hits] [numeric](8, 0) NOT NULL ,
+ [numemails] [numeric](8, 0) NOT NULL ,
+ [comments] [numeric](8, 0) NOT NULL ,
+ [trackbacks] [numeric](8, 0) NOT NULL ,
+ [related] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [featured] [tinyint] NOT NULL ,
+ [show_topic_icon] [tinyint] NOT NULL ,
+ [commentcode] [smallint] NOT NULL ,
+ [trackbackcode] [smallint] NOT NULL ,
+ [statuscode] [smallint] NOT NULL ,
+ [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 ,
+ [owner_id] [int] NOT NULL ,
+ [group_id] [int] 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['storysubmission']}] (
+ [sid] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+ [uid] [int] NOT NULL ,
+ [tid] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+ [title] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [introtext] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
+ [bodytext] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [date] [datetime] NULL ,
+ [postmode] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
+) ON [PRIMARY]
+";
+
+$_SQL[] = "
+CREATE TABLE [dbo].[{$_TABLES['syndication']}] (
+ [fid] [numeric](10, 0) IDENTITY (1, 1) NOT NULL ,
+ [type] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+ [topic] [varchar] (48) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+ [header_tid] [varchar] (48) COLLATE SQL_Latin1_General_CP1_CI_AS NOT
NULL ,
+ [format] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+ [limits] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+ [content_length] [numeric](5, 0) NOT NULL ,
+ [title] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+ [description] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
+ [feedlogo] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [filename] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT
NULL ,
+ [charset] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT
NULL ,
+ [language] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT
NULL ,
+ [is_enabled] [tinyint] NOT NULL ,
+ [updated] [datetime] NULL ,
+ [update_info] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL
+) ON [PRIMARY]
+";
+
+$_SQL[] = "
+CREATE TABLE [dbo].[{$_TABLES['tokens']}] (
+ [token] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
+ [created] [datetime] NOT NULL,
+ [owner_id] [numeric] (8,0) NOT NULL,
+ [urlfor] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT
NULL,
+ [ttl] numeric(8,0) NOT NULL DEFAULT 1
+) ON [PRIMARY]
+";
+
+$_SQL[] = "
+CREATE TABLE [dbo].[{$_TABLES['topics']}] (
+ [tid] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+ [topic] [varchar] (48) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [imageurl] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [sortnum] [smallint] NULL ,
+ [limitnews] [smallint] NULL ,
+ [is_default] [tinyint] NOT NULL ,
+ [archive_flag] [tinyint] 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['trackback']}] (
+ [cid] [numeric](10, 0) IDENTITY (1, 1) NOT NULL ,
+ [sid] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+ [url] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [title] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [blog] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [excerpt] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [date] [datetime] NULL ,
+ [type] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+ [ipaddress] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT
NULL
+) ON [PRIMARY]
+";
+
+$_SQL[] = "
+CREATE TABLE [dbo].[{$_TABLES['trackbackcodes']}] (
+ [code] [smallint] NOT NULL ,
+ [name] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
+) ON [PRIMARY]
+";
+
+$_SQL[] = "
+CREATE TABLE [dbo].[{$_TABLES['usercomment']}] (
+ [uid] [int] NOT NULL ,
+ [commentmode] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
+ [commentorder] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
+ [commentlimit] [numeric](8, 0) NULL
+) ON [PRIMARY]
+";
+
+$_SQL[] = "
+CREATE TABLE [dbo].[{$_TABLES['userindex']}] (
+ [uid] [int] NOT NULL ,
+ [tids] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+ [etids] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT
NULL ,
+ [aids] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+ [boxes] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+ [noboxes] [smallint] NOT NULL ,
+ [maxstories] [smallint] NULL
+) ON [PRIMARY]
+";
+
+$_SQL[] = "
+CREATE TABLE [dbo].[{$_TABLES['userinfo']}] (
+ [uid] [int] NOT NULL ,
+ [about] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [location] [varchar] (96) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [pgpkey] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [userspace] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [tokens] [tinyint] NULL ,
+ [totalcomments] [int] NULL ,
+ [lastgranted] [numeric](10, 0) NULL ,
+ [lastlogin] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
+) ON [PRIMARY]
+";
+
+$_SQL[] = "
+CREATE TABLE [dbo].[{$_TABLES['userprefs']}] (
+ [uid] [int] NOT NULL ,
+ [noicons] [tinyint] NULL ,
+ [willing] [tinyint] NULL ,
+ [dfid] [tinyint] NULL ,
+ [tzid] [varchar] (125) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [emailstories] [smallint] NULL ,
+ [emailfromadmin] [smallint] NULL ,
+ [emailfromuser] [smallint] NULL ,
+ [showonline] [smallint] NULL
+) ON [PRIMARY]
+";
+
+$_SQL[] = "
+CREATE TABLE [dbo].[{$_TABLES['users']}] (
+ [uid] [int] IDENTITY (1, 1) NOT NULL ,
+ [username] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT
NULL ,
+ [remoteusername] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
+ [remoteservice] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
+ [fullname] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [passwd] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [email] [varchar] (96) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [homepage] [varchar] (96) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [sig] [varchar] (160) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [regdate] [datetime] NULL ,
+ [photo] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [cookietimeout] [numeric](8, 0) NULL ,
+ [theme] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
+ [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']}] (
+ [name] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
+ [value] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
+) ON [PRIMARY]
+";
+
+// 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 ,
+ [is_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]
+";
+
+
+$_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['access']}] ADD
+ CONSTRAINT [PK_{$_TABLES['access']}] PRIMARY KEY CLUSTERED
+ (
+ [acc_ft_id],
+ [acc_grp_id]
+ ) ON [PRIMARY]
+";
+
+
+
+$_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['article_images']}] ADD
+ CONSTRAINT [PK_{$_TABLES['article_images']}] PRIMARY KEY CLUSTERED
+ (
+ [ai_sid],
+ [ai_img_num]
+ ) ON [PRIMARY]
+";
+
+
+
+$_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['blocks']}] ADD
+ CONSTRAINT [DF_{$_TABLES['blocks']}_type] DEFAULT ('normal') FOR
[type],
+ CONSTRAINT [DF_{$_TABLES['blocks']}_tid] DEFAULT ('All') FOR [tid],
+ CONSTRAINT [DF_{$_TABLES['blocks']}_blockorder] DEFAULT (1) FOR
[blockorder],
+ CONSTRAINT [DF_{$_TABLES['blocks']}_content] DEFAULT (null) FOR
[content],
+ CONSTRAINT [DF_{$_TABLES['blocks']}_rdfupdated] DEFAULT (getdate())
FOR [rdfupdated],
+ CONSTRAINT [DF_{$_TABLES['blocks']}_rdflimit] DEFAULT (0) FOR
[rdflimit],
+ CONSTRAINT [DF_{$_TABLES['blocks']}_onleft] DEFAULT (1) FOR [onleft],
+ CONSTRAINT [DF_{$_TABLES['blocks']}_owner_id] DEFAULT (1) FOR
[owner_id],
+ CONSTRAINT [DF_{$_TABLES['blocks']}_group_id] DEFAULT (1) FOR
[group_id],
+ CONSTRAINT [DF_{$_TABLES['blocks']}s_perm_owner] DEFAULT (3) FOR
[perm_owner],
+ CONSTRAINT [DF_{$_TABLES['blocks']}_perm_group] DEFAULT (3) FOR
[perm_group],
+ CONSTRAINT [DF_{$_TABLES['blocks']}_perm_members] DEFAULT (2) FOR
[perm_members],
+ CONSTRAINT [DF_{$_TABLES['blocks']}_perm_anon] DEFAULT (2) FOR
[perm_anon],
+ CONSTRAINT [DF_{$_TABLES['blocks']}_allow_autotags] DEFAULT (0) FOR
[allow_autotags],
+ CONSTRAINT [PK_{$_TABLES['blocks']}] PRIMARY KEY CLUSTERED
+ (
+ [bid]
+ ) ON [PRIMARY]
+";
+
+$_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['commentcodes']}] ADD
+ CONSTRAINT [PK_{$_TABLES['commentcodes']}] PRIMARY KEY CLUSTERED
+ (
+ [code]
+ ) ON [PRIMARY]
+";
+
+$_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['commentmodes']}] ADD
+ CONSTRAINT [PK_{$_TABLES['commentmodes']}] PRIMARY KEY CLUSTERED
+ (
+ [mode]
+ ) ON [PRIMARY]
+";
+
+$_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['comments']}] ADD
+ CONSTRAINT [PK_{$_TABLES['comments']}] PRIMARY KEY CLUSTERED
+ (
+ [cid]
+ ) ON [PRIMARY]
+";
+
+$_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['cookiecodes']}] ADD
+ CONSTRAINT [PK_{$_TABLES['cookiecodes']}] PRIMARY KEY CLUSTERED
+ (
+ [cc_value]
+ ) ON [PRIMARY]
+";
+
+$_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['dateformats']}] ADD
+ CONSTRAINT [PK_{$_TABLES['dateformats']}] PRIMARY KEY CLUSTERED
+ (
+ [dfid]
+ ) ON [PRIMARY]
+";
+
+$_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['events']}] ADD
+ CONSTRAINT [PK_{$_TABLES['events']}] PRIMARY KEY CLUSTERED
+ (
+ [eid]
+ ) ON [PRIMARY]
+";
+
+$_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['eventsubmission']}] ADD
+ CONSTRAINT [PK_{$_TABLES['eventsubmission']}] PRIMARY KEY CLUSTERED
+ (
+ [eid]
+ ) ON [PRIMARY]
+";
+
+$_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['featurecodes']}] ADD
+ CONSTRAINT [PK_{$_TABLES['featurecodes']}] PRIMARY KEY CLUSTERED
+ (
+ [code]
+ ) ON [PRIMARY]
+";
+
+$_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['features']}] ADD
+ CONSTRAINT [DF_{$_TABLES['features']}_ft_gl_core] DEFAULT (0) FOR
[ft_gl_core],
+ CONSTRAINT [PK_{$_TABLES['features']}] PRIMARY KEY CLUSTERED
+ (
+ [ft_id]
+ ) ON [PRIMARY]
+";
+
+$_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['frontpagecodes']}] ADD
+ CONSTRAINT [PK_{$_TABLES['frontpagecodes']}] PRIMARY KEY CLUSTERED
+ (
+ [code]
+ ) ON [PRIMARY]
+";
+
+$_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['groups']}] ADD
+ CONSTRAINT [DF_{$_TABLES['groups']}_grp_gl_core] DEFAULT (0) FOR
[grp_gl_core],
+ CONSTRAINT [PK_{$_TABLES['groups']}] PRIMARY KEY CLUSTERED
+ (
+ [grp_id]
+ ) ON [PRIMARY]
+";
+
+$_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['linkcategories']}] ADD
+ CONSTRAINT [PK_{$_TABLES['linkcategories']}] PRIMARY KEY CLUSTERED
+ (
+ [pid]
+ ) ON [PRIMARY]
+";
+
+$_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['links']}] ADD
+ CONSTRAINT [DF_{$_TABLES['links']}_perm_group] DEFAULT (3) FOR
[perm_group],
+ CONSTRAINT [DF_{$_TABLES['links']}_perm_anon] DEFAULT (2) FOR
[perm_anon],
+ CONSTRAINT [DF_{$_TABLES['links']}_perm_members] DEFAULT (2) FOR
[perm_members],
+ CONSTRAINT [DF_{$_TABLES['links']}_perm_owner] DEFAULT (3) FOR
[perm_owner],
+ CONSTRAINT [DF_{$_TABLES['links']}_hits] DEFAULT (0) FOR [hits],
+ CONSTRAINT [PK_{$_TABLES['links']}] PRIMARY KEY CLUSTERED
+ (
+ [lid]
+ ) ON [PRIMARY]
+";
+
+$_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['linksubmission']}] ADD
+ CONSTRAINT [PK_{$_TABLES['linksubmission']}] PRIMARY KEY CLUSTERED
+ (
+ [lid]
+ ) ON [PRIMARY]
+";
+
+$_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['maillist']}] ADD
+ CONSTRAINT [PK_{$_TABLES['maillist']}] PRIMARY KEY CLUSTERED
+ (
+ [code]
+ ) ON [PRIMARY]
+";
+
+$_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['personal_events']}] ADD
+ CONSTRAINT [PK_{$_TABLES['personal_events']}] PRIMARY KEY CLUSTERED
+ (
+ [eid],
+ [uid]
+ ) ON [PRIMARY]
+";
+
+$_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['pingservice']}] ADD
+ CONSTRAINT [PK_{$_TABLES['pingservice']}] PRIMARY KEY CLUSTERED
+ (
+ [pid]
+ ) ON [PRIMARY]
+";
+
+$_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['plugins']}] ADD
+ CONSTRAINT [PK_{$_TABLES['plugins']}] PRIMARY KEY CLUSTERED
+ (
+ [pi_name]
+ ) ON [PRIMARY]
+";
+
+$_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['pollanswers']}] ADD
+ CONSTRAINT [PK_{$_TABLES['pollanswers']}] PRIMARY KEY CLUSTERED
+ (
+ [qid],
+ [aid]
+ ) ON [PRIMARY]
+";
+
+$_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['pollanswers']}] ADD
+ CONSTRAINT [DF_{$_TABLES['pollanswers']}_qid] DEFAULT ('0') FOR [qid]
+";
+
+$_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['pollquestions']}] ADD
+ CONSTRAINT [PK_{$_TABLES['pollquestions']}] PRIMARY KEY CLUSTERED
+ (
+ [qid]
+ ) ON [PRIMARY]
+";
+
+$_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['polltopics']}] ADD
+ CONSTRAINT [PK_{$_TABLES['polltopics']}] PRIMARY KEY CLUSTERED
+ (
+ [pid]
+ ) ON [PRIMARY]
+";
+
+$_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['pollvoters']}] ADD
+ CONSTRAINT [PK_{$_TABLES['pollvoters']}] PRIMARY KEY CLUSTERED
+ (
+ [id]
+ ) ON [PRIMARY]
+";
+
+$_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['postmodes']}] ADD
+ CONSTRAINT [PK_{$_TABLES['postmodes']}] PRIMARY KEY CLUSTERED
+ (
+ [code]
+ ) ON [PRIMARY]
+";
+
+$_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['sessions']}] ADD
+ CONSTRAINT [PK_{$_TABLES['sessions']}] PRIMARY KEY CLUSTERED
+ (
+ [sess_id]
+ ) ON [PRIMARY]
+";
+
+$_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['speedlimit']}] ADD
+ CONSTRAINT [PK_{$_TABLES['speedlimit']}] PRIMARY KEY CLUSTERED
+ (
+ [id]
+ ) ON [PRIMARY]
+";
+
+$_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['staticpage']}] ADD
+ CONSTRAINT [DF_{$_TABLES['staticpage']}] DEFAULT ('html') FOR
[postmode],
+ CONSTRAINT [PK_{$_TABLES['staticpage']}] PRIMARY KEY CLUSTERED
+ (
+ [sp_id]
+ ) ON [PRIMARY]
+";
+
+$_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['statuscodes']}] ADD
+ CONSTRAINT [PK_{$_TABLES['statuscodes']}] PRIMARY KEY CLUSTERED
+ (
+ [code]
+ ) ON [PRIMARY]
+";
+
+$_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['stories']}] ADD
+ CONSTRAINT [DF_{$_TABLES['stories']}_uid] DEFAULT (1) FOR [uid],
+ CONSTRAINT [DF_{$_TABLES['stories']}_draft_flag] DEFAULT (0) FOR
[draft_flag],
+ CONSTRAINT [DF_{$_TABLES['stories']}_tid] DEFAULT ('General') FOR
[tid],
+ CONSTRAINT [DF_{$_TABLES['stories']}_hits] DEFAULT (0) FOR [hits],
+ CONSTRAINT [DF_{$_TABLES['stories']}_comments] DEFAULT (0) FOR
[comments],
+ CONSTRAINT [DF_{$_TABLES['stories']}_trackbacks] DEFAULT (0) FOR
[trackbacks],
+ CONSTRAINT [DF_{$_TABLES['stories']}_featured] DEFAULT (0) FOR
[featured],
+ CONSTRAINT [DF_{$_TABLES['stories']}_show_topic_icon] DEFAULT (1) FOR
[show_topic_icon],
+ CONSTRAINT [DF_{$_TABLES['stories']}_commentcode] DEFAULT (0) FOR
[commentcode],
+ CONSTRAINT [DF_{$_TABLES['stories']}_trackbackcode] DEFAULT (0) FOR
[trackbackcode],
+ CONSTRAINT [DF_{$_TABLES['stories']}_statuscode] DEFAULT (0) FOR
[statuscode],
+ CONSTRAINT [DF_{$_TABLES['stories']}_expire] DEFAULT (getdate()) FOR
[expire],
+ CONSTRAINT [DF_{$_TABLES['stories']}_postmode] DEFAULT ('html') FOR
[postmode],
+ CONSTRAINT [DF_{$_TABLES['stories']}_owner_id] DEFAULT (1) FOR
[owner_id],
+ CONSTRAINT [DF_{$_TABLES['stories']}_group_id] DEFAULT (2) FOR
[group_id],
+ CONSTRAINT [DF_{$_TABLES['stories']}_perm_owner] DEFAULT (3) FOR
[perm_owner],
+ CONSTRAINT [DF_{$_TABLES['stories']}_perm_group] DEFAULT (3) FOR
[perm_group],
+ CONSTRAINT [DF_{$_TABLES['stories']}_perm_members] DEFAULT (2) FOR
[perm_members],
+ CONSTRAINT [DF_{$_TABLES['stories']}_perm_anon] DEFAULT (2) FOR
[perm_anon],
+ CONSTRAINT [DF_{$_TABLES['stories']}_advanced_editor_mode] DEFAULT (0)
FOR [advanced_editor_mode],
+ CONSTRAINT [PK_{$_TABLES['stories']}] PRIMARY KEY CLUSTERED
+ (
+ [sid]
+ ) ON [PRIMARY]
+";
+
+$_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['storysubmission']}] ADD
+ CONSTRAINT [PK_{$_TABLES['storysubmission']}] PRIMARY KEY CLUSTERED
+ (
+ [sid]
+ ) ON [PRIMARY]
+";
+
+$_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['syndication']}] ADD
+ CONSTRAINT [PK_{$_TABLES['syndication']}] PRIMARY KEY CLUSTERED
+ (
+ [fid]
+ ) ON [PRIMARY]
+";
+
+$_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['tokens']}] ADD
+ CONSTRAINT [PK_{$_TABLES['tokens']}] PRIMARY KEY CLUSTERED
+ (
+ [token]
+ ) ON [PRIMARY]
+";
+
+$_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['topics']}] ADD
+ CONSTRAINT [DF_{$_TABLES['topics']}_is_default] DEFAULT (0) FOR
[is_default],
+ CONSTRAINT [PK_{$_TABLES['topics']}] PRIMARY KEY CLUSTERED
+ (
+ [tid]
+ ) ON [PRIMARY]
+";
+
+$_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['trackback']}] ADD
+ CONSTRAINT [PK_{$_TABLES['trackback']}] PRIMARY KEY CLUSTERED
+ (
+ [cid]
+ ) ON [PRIMARY]
+";
+
+$_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['trackbackcodes']}] ADD
+ CONSTRAINT [PK_{$_TABLES['trackbackcodes']}] PRIMARY KEY CLUSTERED
+ (
+ [code]
+ ) ON [PRIMARY]
+";
+
+
+$_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['usercomment']}] ADD
+ CONSTRAINT [PK_{$_TABLES['usercomment']}] PRIMARY KEY CLUSTERED
+ (
+ [uid]
+ ) ON [PRIMARY]
+";
+
+$_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['userindex']}] ADD
+ CONSTRAINT [DF_{$_TABLES['userindex']}_boxes] DEFAULT (0) FOR [boxes],
+ CONSTRAINT [DF_{$_TABLES['userindex']}_noboxes] DEFAULT (0) FOR
[noboxes],
+ CONSTRAINT [DF_{$_TABLES['userindex']}_tids] DEFAULT ('0') FOR [tids],
+ CONSTRAINT [DF_{$_TABLES['userindex']}_etids] DEFAULT ('0') FOR
[etids],
+ CONSTRAINT [DF_{$_TABLES['userindex']}_aids] DEFAULT ('0') FOR [aids],
+ CONSTRAINT [PK_{$_TABLES['userindex']}] PRIMARY KEY CLUSTERED
+ (
+ [uid]
+ ) ON [PRIMARY]
+";
+
+$_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['userinfo']}] ADD
+ CONSTRAINT [PK_{$_TABLES['userinfo']}] PRIMARY KEY CLUSTERED
+ (
+ [uid]
+ ) ON [PRIMARY]
+";
+
+$_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['userprefs']}] ADD
+ CONSTRAINT [DF_{$_TABLES['userprefs']}_noicons] DEFAULT (0) FOR
[noicons],
+ CONSTRAINT [DF_{$_TABLES['userprefs']}_willing] DEFAULT (0) FOR
[willing],
+ CONSTRAINT [DF_{$_TABLES['userprefs']}_dfid] DEFAULT (0) FOR [dfid],
+ CONSTRAINT [DF_{$_TABLES['userprefs']}_emailstories] DEFAULT (0) FOR
[emailstories],
+ CONSTRAINT [DF_{$_TABLES['userprefs']}_emailfromadmin] DEFAULT (0) FOR
[emailfromadmin],
+ CONSTRAINT [DF_{$_TABLES['userprefs']}_emailfromuser] DEFAULT (0) FOR
[emailfromuser],
+ CONSTRAINT [DF_{$_TABLES['userprefs']}_showonline] DEFAULT (0) FOR
[showonline],
+ CONSTRAINT [DF_{$_TABLES['userprefs']}_tzid] DEFAULT ('') FOR [tzid],
+ CONSTRAINT [PK_{$_TABLES['userprefs']}] PRIMARY KEY CLUSTERED
+ (
+ [uid]
+ ) ON [PRIMARY]
+";
+
+
+$_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['users']}] ADD
+ CONSTRAINT [DF_{$_TABLES['users']}_status] DEFAULT ('1') FOR [status],
+ CONSTRAINT [PK_{$_TABLES['users']}] PRIMARY KEY CLUSTERED
+ (
+ [username]
+ ) ON [PRIMARY]
+";
+
+
+$_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['vars']}] ADD
+ CONSTRAINT [PK_{$_TABLES['vars']}] PRIMARY KEY CLUSTERED
+ (
+ [name]
+ ) ON [PRIMARY]
+";
+
+
+
+
+
+
+
+
+
+$_SQL[] = "CREATE VIEW dbo.getPrimaryKey
+AS
+
+SELECT SC.name as colName, SO.name as tableName,
+ case when sc.status=128 then '1' else '0' end as isIdentity
+FROM sysobjects SO,
+ sysobjects SPK,
+ sysindexes SI,
+ sysindexkeys SIK,
+ syscolumns SC
+WHERE
+
+SO.xtype = 'U'
+AND SO.id = SPK.parent_obj
+AND SPK.xtype = 'PK'
+AND SO.id = SI.id
+AND SPK.name = SI.name
+AND SO.id = SIK.id
+AND SI.indid = SIK.indid
+AND SO.id = SC.id
+AND SIK.colid = SC.colid
+
+
+
+
+
+";
+
+
+$_SQL[] = "CREATE VIEW dbo.getdateView
+AS
+SELECT GETUTCDATE() AS getdate
+
+";
+
+
+
+
+
+
+
+
+
+
+$_SQL[] = "CREATE function DATE_FORMAT(@d as varchar(100)='', @f as
varchar(100))
+returns varchar(1000)
+
+BEGIN
+declare
+ ＠ tempVar as varchar(100),
+ ＠ workingString as varchar(100),
+ ＠ mysqlCommand varchar(10),
+ ＠ sqlCommand varchar(10),
+ ＠ isDateName bit,
+ ＠ isDatePart bit,
+ ＠ retval varchar(100),
+ ＠ sql varchar(1000),
+ ＠ currentChar char(1),
+ ＠ nextChar char(1),
+ ＠ procOutput varchar(100),
+ ＠ counter int,
+ ＠ mode int,
+ ＠ count int
+
+
+if @d='' or @d is null --date is null/empty.. fill it in for this
poor person..
+ begin
+ select @d=getdate from getDateView
+ end
+
+set @workingString=@f
+
+--workingString now holds the desired date format
+--we have to loop thru that string, detecting % followed by a command
+--anything that is not a % sign or %% will be represented as a literal and
+--returned to the output string
+
+--if it is a command, due to limitations in UDFs we're going to pass the
sql command
+--to a stored proc for conversion..
+
+
+-------------------------------------------------------------------------------------
+set @retval = ''
+set @mode=0
+set @counter=1
+while @counter<=len(@workingString)
+begin
+ select @currentChar=substring(@workingString, ＠ counter,1)
+
+ if @currentChar='%'--we may have a command here
+ begin
+ select @nextChar=substring(@workingString, ＠ counter+1,1)
+ set @mysqlCommand=@currentChar + @nextChar
+ select @count=count(*) from dateCommandCrossReference where
mysqlCommand=@mysqlCommand COLLATE Latin1_General_CS_AS
+
+ if @count>0 -- there most certainly is a command here.. do the
conversion now...
+ begin
+
+ select @retval = @retval + (case @mysqlCommand COLLATE
Latin1_General_CS_AS
+ when '%a' then datename(weekday, ＠ d)
+ when '%b' then datename(month, ＠ d)
+ when '%c' then cast(datepart(mm, ＠ d) as varchar(25))
+ when '%D' then cast(datepart(d, ＠ d) as varchar(25))
+ when '%d' then cast(datepart(d, ＠ d) as varchar(25))
+ when '%e' then cast(datepart(d, ＠ d) as varchar(25))
+ when '%f' then cast(datepart(ms, ＠ d) as varchar(25))
+ when '%H' then cast(datepart(hh, ＠ d) as varchar(25))
+ when '%h' then cast(datepart(hh, ＠ d) as varchar(25))
+ when '%I' then cast(datepart(mi, ＠ d) as varchar(25))
+ when '%i' then cast(datepart(mi, ＠ d) as varchar(25))
+ when '%j' then cast(datename(dayofyear, ＠ d) as varchar(25))
+ when '%k' then cast(datepart(hh, ＠ d) as varchar(25))
+ when '%l' then cast(datepart(hh, ＠ d) as varchar(25))
+ when '%M' then cast(datename(month, ＠ d) as varchar(25))
+ when '%m' then cast(datepart(mm, ＠ d) as varchar(25))
+ when '%p' then ''
+ when '%r' then ''
+ when '%S' then cast(datepart(s, ＠ d) as varchar(25))
+ when '%s' then cast(datepart(s, ＠ d) as varchar(25))
+ when '%T' then ''
+ when '%U' then cast(datepart(week, ＠ d) as varchar(25))
+ when '%u' then cast(datepart(week, ＠ d) as varchar(25))
+ when '%V' then cast(datepart(week, ＠ d) as varchar(25))
+ when '%v' then cast(datepart(week, ＠ d) as varchar(25))
+ when '%W' then cast(datename(dw, ＠ d) as varchar(25))
+ when '%w' then cast(datepart(dw, ＠ d) as varchar(25))
+ when '%X' then cast(datepart(year, ＠ d) as varchar(25))
+ when '%x' then cast(datepart(year, ＠ d) as varchar(25))
+ when '%Y' then cast(datepart(year, ＠ d) as varchar(25))
+ when '%y' then cast(datepart(year, ＠ d) as varchar(25))
+
+ when '%%' then '%'
+
+
+ end)
+ set @counter=@counter+1
+ end
+ else
+ begin
+
+ select @retval = @retval + @currentChar
+ end
+
+
+
+ end
+ else --no command here..
+ begin
+
+ select @retval=@retval + @currentChar
+ end
+ set @counter=@counter+1
+end
+
+
+
+
+
+return @retval
+END
+
+
+";
+
+
+
+
+
+$_SQL[] = "CREATE function DESCRIBE(@d as varchar(100)='')
+RETURNS table AS
+
+RETURN
+(select top 1000 a.name as Field, c.name +'(' + cast(a.prec as varchar)
+ ')' as Type,
+case when a.status=(0x08) then 'NULL' else '' end as [Null],
+' ' as [Key],
+' ' as [Default],
+' ' as [Extra]
+from syscolumns a
+join sysobjects b on a.id=b.id
+join systypes c on a.xtype=c.xtype
+where b.name = @d
+order by colorder asc)
+
+
+
+
+
+
+
+";
+
+
+
+
+$_SQL[] = "CREATE function FROM_UNIXTIME(@d as varchar(100)='')
+RETURNS varchar(100) AS
+BEGIN
+declare
+ ＠ retval varchar(100),
+ ＠ testDate varchar(100)
+
+
+
+if @d is Null or @d=''
+ begin
+ SELECT @retval=''
+
+ end
+else
+ begin
+
+
+ SELECT @retval=cast(year(dateadd(SECOND, cast( @d as
bigint) ,'19700101') ) as varchar(10)) + '-'
+
+
+
+ select @testDate=cast( month(dateadd(SECOND, cast( @d as
bigint) ,'19700101') ) as varchar(10))
+ if len(@testDate)<2
+ begin
+ select @testDate='0' + @testDate
+ end
+ select @retval = @retval + @testDate + '-'
+
+ select @testDate=cast( day(dateadd(SECOND, cast( @d as
bigint) ,'19700101') ) as varchar(10))
+ if len(@testDate)<2
+ begin
+ select @testDate='0' + @testDate
+ end
+ select @retval = @retval + @testDate + ' '
+
+
+
+ select @testDate=cast( DATEPART(hour, dateadd(SECOND, cast( @d as
bigint) ,'19700101')) as varchar(10))
+ if len(@testDate)<2
+ begin
+ select @testDate='0' + @testDate
+ end
+ select @retval = @retval + @testDate + ':'
+
+
+ select @testDate=cast( DATEPART(mi, dateadd(SECOND, cast( @d as
bigint) ,'19700101')) as varchar(10))
+ if len(@testDate)<2
+ begin
+ select @testDate='0' + @testDate
+ end
+ select @retval = @retval + @testDate + ':'
+
+
+ select @testDate=cast( DATEPART(s, dateadd(SECOND, cast( @d as
bigint) ,'19700101')) as varchar(10))
+ if len(@testDate)<2
+ begin
+ select @testDate='0' + @testDate
+ end
+ select @retval = @retval + @testDate
+
+ end
+
+
+return @retval
+END
+
+
+";
+
+
+
+$_SQL[] = "CREATE function TO_DAYS(@d as varchar(100)='')
+RETURNS int AS
+BEGIN
+declare
+ ＠ retval varchar(100),
+ ＠ testDate varchar(100)
+
+
+if @d is Null or @d=''
+ begin
+ SELECT @retval=NULL
+
+ end
+else
+ begin
+ SELECT @retval=DATEDIFF(day, '19700101', @d)
+ end
+
+
+return cast(@retval as integer)
+END
+
+";
+
+
+$_SQL[] = "CREATE function UNIX_TIMESTAMP(@d as varchar(100)='')
+RETURNS varchar(100) AS
+BEGIN
+declare
+ ＠ retval varchar(100),
+ ＠ testDate dateTime
+
+
+if @d is Null or @d=''
+ begin
+ select @testDate=[getdate] from getdateView
+ SELECT @retval=DATEDIFF(s, '1970-01-01 00:00:00.000', @testDate)
+
+ end
+else
+ begin
+ SELECT @retval=DATEDIFF(SECOND, '1970-01-01 00:00:00.000', @d)
+ end
+
+
+return @retval
+END
+
+";
+
+
+
+
+
+$_SQL[] = "CREATE PROCEDURE dbo.doIndexInsert
+
+ ＠ table varchar(256),
+ ＠ cols varchar(5000),
+ ＠ vals varchar(8000)
+
+AS
+begin
+
+declare
+ ＠ isIdentity int,
+ ＠ sql varchar(8000),
+ ＠ isIdentityListed int,
+ ＠ tempCols varchar(8000)
+
+select @tempCols=replace(@cols,',', ''',''')
+set @sql='select colName from getPrimaryKey where tableName=''' + @table
+ ''' and colname in (''' + @tempCols + ''')'
+exec (@sql)
+set @isIdentityListed=@@ROWCOUNT
+
+
+
+select @isIdentity=isIdentity
+from getPrimaryKey
+where tableName=@table
+select @vals=replace(@vals,'\\\"', '''''')
+select @vals=replace(@vals,'\"', '''')
+
+if @isIdentity=1
+ begin
+ --this is an identity insert
+ if @isIdentityListed>0
+ begin
+ set @sql='set IDENTITY_INSERT ' + @table + ' ON; INSERT
INTO ' + @table + ' (' + @cols + ') values (' + @vals + ')'
+ end
+ else
+ begin
+ set @sql='INSERT INTO ' + @table + ' (' + @cols + ')
values (' + @vals + ')'
+ end
+
+ end
+else
+ begin
+ set @sql='INSERT INTO ' + @table + ' (' + @cols + ') values (' +
@vals + ')'
+ end
+
+print @sql
+
+exec (@sql)
+
+
+end
+
+
+
+
+
+
+";
+
+
+$_SQL[] = "CREATE TRIGGER FixBoxes ON [dbo].[{$_TABLES['userindex']}]
+FOR INSERT, UPDATE
+AS
+update {$_TABLES['userindex']}
+set boxes='0' where boxes=''
+
+
+update {$_TABLES['userindex']}
+set noboxes='0' where noboxes=''
+
+update {$_TABLES['userindex']}
+set aids='0' where aids=''
+
+update {$_TABLES['userindex']}
+set tids='0' where tids=''
+
+";
+
+
+
+$_SQL[] = "CREATE TRIGGER fixContext ON [dbo].[{$_TABLES['blocks']}]
+FOR INSERT, UPDATE
+AS
+
+update {$_TABLES['blocks']}
+set content=NULL
+where content like''
+";
+
+
+
+$_SQL[] = "CREATE TRIGGER fixPhoto ON dbo.{$_TABLES['users']}
+FOR INSERT, UPDATE
+AS
+
+update {$_TABLES['users']}
+set photo=null
+where photo=''
+
+";
+
+
+
+
+$_SQL[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES
(1,3)";
+$_SQL[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES
(2,3)";
+$_SQL[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES
(3,5)";
+$_SQL[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES
(4,5)";
+$_SQL[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES
(5,9)";
+$_SQL[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES
(5,11)";
+$_SQL[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES
(6,9)";
+$_SQL[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES
(6,11)";
+$_SQL[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id)
VALUES(7,12)";
+$_SQL[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES
(8,7)";
+$_SQL[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES
(9,7)";
+$_SQL[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES
(10,4)";
+$_SQL[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES
(11,6)";
+$_SQL[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES
(12,8)";
+$_SQL[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES
(13,10)";
+$_SQL[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES
(14,11)";
+$_SQL[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES
(15,11)";
+$_SQL[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES
(16,4)";
+$_SQL[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES
(17,14)";
+$_SQL[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES
(18,14)";
+$_SQL[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES
(23,15)";
+$_SQL[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES
(24,3)";
+$_SQL[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES
(25,17)";
+$_SQL[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES
(26,18)";
+
+$_SQL[] = "
+set identity_insert {$_TABLES['blocks']} on;
+
+
+INSERT INTO {$_TABLES['blocks']} (bid, is_enabled, name, type, title, tid,
blockorder, content, rdfurl, rdfupdated, onleft, phpblockfn, group_id,
owner_id, perm_owner, perm_group, perm_members, perm_anon) VALUES
(1,1,'user_block','gldefault','User
Functions','all',2,'','',getdate(),1,'',4,2,3,3,2,2);
+INSERT INTO {$_TABLES['blocks']} (bid, is_enabled, name, type, title, tid,
blockorder, content, rdfurl, rdfupdated, onleft, phpblockfn, group_id,
owner_id, perm_owner, perm_group, perm_members, perm_anon) VALUES
(2,1,'admin_block','gldefault','Admins
Only','all',1,'','',getdate(),1,'',4,2,3,3,2,2);
+INSERT INTO {$_TABLES['blocks']} (bid, is_enabled, name, type, title, tid,
blockorder, content, rdfurl, rdfupdated, onleft, phpblockfn, group_id,
owner_id, perm_owner, perm_group, perm_members, perm_anon) VALUES
(3,1,'section_block','gldefault','Topics','all',0,'','',getdate(),1,'',4,2,3,3,2,2);
+INSERT INTO {$_TABLES['blocks']} (bid, is_enabled, name, type, title, tid,
blockorder, content, rdfurl, rdfupdated, onleft, phpblockfn, group_id,
owner_id, perm_owner, perm_group, perm_members, perm_anon) VALUES
(4,1,'polls_block','phpblock','Poll','all',2,'','',getdate(),0,'phpblock_polls',4,2,3,3,2,2);
+INSERT INTO {$_TABLES['blocks']} (bid, is_enabled, name, type, title, tid,
blockorder, content, rdfurl, rdfupdated, onleft, phpblockfn, group_id,
owner_id, perm_owner, perm_group, perm_members, perm_anon) VALUES
(5,1,'events_block','phpblock','Events','all',4,'','',getdate(),1,'phpblock_calendar',1,2,3,3,2,2);
+INSERT INTO {$_TABLES['blocks']} (bid, is_enabled, name, type, title, tid,
blockorder, content, rdfurl, rdfupdated, onleft, phpblockfn, group_id,
owner_id, perm_owner, perm_group, perm_members, perm_anon) VALUES
(6,1,'whats_new_block','gldefault','What''s
New','all',3,'','',getdate(),0,'',4,2,3,3,2,2);
+INSERT INTO {$_TABLES['blocks']} (bid, is_enabled, name, type, title, tid,
blockorder, content, rdfurl, rdfupdated, onleft, phpblockfn, group_id,
owner_id, perm_owner, perm_group, perm_members, perm_anon) VALUES
(7,1,'first_block','normal','About Geeklog','homeonly',1,'<p><b>Welcome to
Geeklog!</b></p><p>If you''re already familiar with Geeklog - and
especially if you''re not: There have been many improvements to Geeklog
since earlier versions that you might want to read up on. Please read the
<a href=\"docs/changes.html\">release notes</a>. If you need help, please
see the <a href=\"docs/support.html\">support
options</a>.</p>','',getdate(),0,'',4,2,3,3,2,2);
+INSERT INTO {$_TABLES['blocks']} (bid, is_enabled, name, type, title, tid,
blockorder, content, rdfurl, rdfupdated, onleft, phpblockfn, group_id,
owner_id, perm_owner, perm_group, perm_members, perm_anon) VALUES
(8,1,'whosonline_block','phpblock','Who''s
Online','all',0,'','',getdate(),0,'phpblock_whosonline',4,2,3,3,2,2);
+INSERT INTO {$_TABLES['blocks']} (bid, is_enabled, name, type, title, tid,
blockorder, content, rdfurl, rdfupdated, onleft, phpblockfn, group_id,
owner_id, perm_owner, perm_group, perm_members, perm_anon) VALUES
(9,1,'older_stories','gldefault','Older
Stories','all',5,'','',getdate(),1,'',4,2,3,3,2,2);
+
+
+set identity_insert {$_TABLES['blocks']} off;
+";
+
+
+$_SQL[] = "INSERT INTO {$_TABLES['commentcodes']} (code, name) VALUES
(0,'Comments Enabled')";
+$_SQL[] = "INSERT INTO {$_TABLES['commentcodes']} (code, name) VALUES
(-1,'Comments Disabled')";
+$_SQL[] = "INSERT INTO {$_TABLES['commentcodes']} (code, name) VALUES
(1,'Comments Closed')";
+
+$_SQL[] = "INSERT INTO {$_TABLES['commentmodes']} (mode, name) VALUES
('flat','Flat')";
+$_SQL[] = "INSERT INTO {$_TABLES['commentmodes']} (mode, name) VALUES
('nested','Nested')";
+$_SQL[] = "INSERT INTO {$_TABLES['commentmodes']} (mode, name) VALUES
('threaded','Threaded')";
+$_SQL[] = "INSERT INTO {$_TABLES['commentmodes']} (mode, name) VALUES
('nocomment','No Comments')";
+
+$_SQL[] = "INSERT INTO {$_TABLES['cookiecodes']} (cc_value, cc_descr)
VALUES (0,'(don''t)')";
+$_SQL[] = "INSERT INTO {$_TABLES['cookiecodes']} (cc_value, cc_descr)
VALUES (3600,'1 Hour')";
+$_SQL[] = "INSERT INTO {$_TABLES['cookiecodes']} (cc_value, cc_descr)
VALUES (7200,'2 Hours')";
+$_SQL[] = "INSERT INTO {$_TABLES['cookiecodes']} (cc_value, cc_descr)
VALUES (10800,'3 Hours')";
+$_SQL[] = "INSERT INTO {$_TABLES['cookiecodes']} (cc_value, cc_descr)
VALUES (28800,'8 Hours')";
+$_SQL[] = "INSERT INTO {$_TABLES['cookiecodes']} (cc_value, cc_descr)
VALUES (86400,'1 Day')";
+$_SQL[] = "INSERT INTO {$_TABLES['cookiecodes']} (cc_value, cc_descr)
VALUES (604800,'1 Week')";
+$_SQL[] = "INSERT INTO {$_TABLES['cookiecodes']} (cc_value, cc_descr)
VALUES (2678400,'1 Month')";
+
+$_SQL[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format,
description) VALUES (0,'','System Default')";
+$_SQL[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format,
description) VALUES (1,'%A %B %d, %Y @%I:%M%p','Sunday March 21, 1999
@10:00PM')";
+$_SQL[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format,
description) VALUES (2,'%A %b %d, %Y @%H:%M','Sunday March 21, 1999
@22:00')";
+$_SQL[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format,
description) VALUES (4,'%A %b %d @%H:%M','Sunday March 21 @22:00')";
+$_SQL[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format,
description) VALUES (5,'%H:%M %d %B %Y','22:00 21 March 1999')";
+$_SQL[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format,
description) VALUES (6,'%H:%M %A %d %B %Y','22:00 Sunday 21 March 1999')";
+$_SQL[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format,
description) VALUES (7,'%I:%M%p - %A %B %d %Y','10:00PM -- Sunday March 21
1999')";
+$_SQL[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format,
description) VALUES (8,'%a %B %d, %I:%M%p','Sun March 21, 10:00PM')";
+$_SQL[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format,
description) VALUES (9,'%a %B %d, %H:%M','Sun March 21, 22:00')";
+$_SQL[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format,
description) VALUES (10,'%m-%d-%y %H:%M','3-21-99 22:00')";
+$_SQL[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format,
description) VALUES (11,'%d-%m-%y %H:%M','21-3-99 22:00')";
+$_SQL[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format,
description) VALUES (12,'%m-%d-%y %I:%M%p','3-21-99 10:00PM')";
+$_SQL[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format,
description) VALUES (13,'%I:%M%p %B %D, %Y','10:00PM March 21st, 1999')";
+$_SQL[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format,
description) VALUES (14,'%a %b %d, ''%y %I:%M%p','Sun Mar 21, ''99
10:00PM')";
+$_SQL[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format,
description) VALUES (15,'Day %j, %I ish','Day 80, 10 ish')";
+$_SQL[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format,
description) VALUES (16,'%y-%m-%d %I:%M','99-03-21 10:00')";
+$_SQL[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format,
description) VALUES (17,'%d/%m/%y %H:%M','21/03/99 22:00')";
+$_SQL[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format,
description) VALUES (18,'%a %d %b %I:%M%p','Sun 21 Mar 10:00PM')";
+
+$_SQL[] = "INSERT INTO {$_TABLES['eventsubmission']} (eid, title,
description, location, datestart, dateend, url, allday, zipcode, state,
city, address2, address1, event_type, timestart, timeend) VALUES
('2005100114064662','Geeklog installed','Today, you successfully installed
this Geeklog site.','Your
webserver',getdate(),getdate(),'http://www.geeklog.net/',1,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL)";
+
+$_SQL[] = "INSERT INTO {$_TABLES['featurecodes']} (code, name) VALUES
(0,'Not Featured')";
+$_SQL[] = "INSERT INTO {$_TABLES['featurecodes']} (code, name) VALUES
(1,'Featured')";
+
+
+
+
+$_SQL[] = "
+set identity_insert {$_TABLES['features']} on
+
+
+INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core)
VALUES (1,'story.edit','Access to story editor',1)
+INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core)
VALUES (2,'story.moderate','Ability to moderate pending stories',1)
+INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core)
VALUES (5,'user.edit','Access to user editor',1)
+INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core)
VALUES (6,'user.delete','Ability to delete a user',1)
+INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core)
VALUES (7,'user.mail','Ability to send email to members',1)
+INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core)
VALUES (8,'calendar.moderate','Ability to moderate pending events',1)
+INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core)
VALUES (9,'calendar.edit','Access to event editor',1)
+INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core)
VALUES (10,'block.edit','Access to block editor',1)
+INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core)
VALUES (11,'topic.edit','Access to topic editor',1)
+INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core)
VALUES (13,'plugin.edit','Access to plugin editor',1)
+INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core)
VALUES (14,'group.edit','Ability to edit groups',1)
+INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core)
VALUES (15,'group.delete','Ability to delete groups',1)
+INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core)
VALUES (16,'block.delete','Ability to delete a block',1)
+INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core)
VALUES (17,'staticpages.edit','Ability to edit a static page',0)
+INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core)
VALUES (18,'staticpages.delete','Ability to delete static pages',0)
+INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core)
VALUES (19,'story.submit','May skip the story submission queue',1)
+INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core)
VALUES (21,'calendar.submit','May skip the event submission queue',1)
+INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core)
VALUES (22,'staticpages.PHP','Ability to use PHP in static pages',0)
+INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core)
VALUES (23,'spamx.admin', 'Full access to Spam-X plugin', 0)
+INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core)
VALUES (24,'story.ping', 'Ability to send pings, pingbacks, or trackbacks
for stories', 1)
+INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core)
VALUES (3,'links.moderate','Ability to moderate pending links',0)
+INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core)
VALUES (4,'links.edit','Access to links editor',0)
+INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core)
VALUES (20,'links.submit','May skip the links submission queue',0)
+INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core)
VALUES (12,'polls.edit','Access to polls editor',0)
+INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core)
VALUES (25,'syndication.edit', 'Access to Content Syndication', 1)
+INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr, ft_gl_core)
VALUES (26,'webservices.atompub', 'May use Atompub Webservices (if
restricted)', 1)
+
+set identity_insert {$_TABLES['features']} off
+";
+
+
+
+$_SQL[] = "INSERT INTO {$_TABLES['frontpagecodes']} (code, name) VALUES
(0,'Show Only in Topic')";
+$_SQL[] = "INSERT INTO {$_TABLES['frontpagecodes']} (code, name) VALUES
(1,'Show on Front Page')";
+
+$_SQL[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (2,1,NULL)";
+$_SQL[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (2,NULL,1)";
+$_SQL[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (3,NULL,1)";
+$_SQL[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (4,NULL,1)";
+$_SQL[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (5,NULL,1)";
+$_SQL[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (6,NULL,1)";
+$_SQL[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (7,NULL,1)";
+$_SQL[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (8,NULL,1)";
+$_SQL[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (9,NULL,1)";
+$_SQL[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (10,NULL,1)";
+$_SQL[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (11,NULL,1)";
+$_SQL[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (13,2,NULL)";
+$_SQL[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (12,2,NULL)";
+$_SQL[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (11,2,NULL)";
+$_SQL[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (2,NULL,12)";
+$_SQL[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (2,NULL,10)";
+$_SQL[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (2,NULL,9)";
+$_SQL[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (2,NULL,8)";
+$_SQL[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (2,NULL,7)";
+$_SQL[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (2,NULL,6)";
+$_SQL[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (2,NULL,5)";
+$_SQL[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (2,NULL,4)";
+$_SQL[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (2,NULL,3)";
+$_SQL[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (12,NULL,1)";
+$_SQL[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (9,NULL,11)";
+$_SQL[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (2,NULL,11)";
+$_SQL[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (10,2,NULL)";
+$_SQL[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (9,2,NULL)";
+$_SQL[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (8,2,NULL)";
+$_SQL[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (7,2,NULL)";
+$_SQL[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (6,2,NULL)";
+$_SQL[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (5,2,NULL)";
+$_SQL[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (4,2,NULL)";
+$_SQL[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (3,2,NULL)";
+$_SQL[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (2,2,NULL)";
+$_SQL[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (1,2,NULL)";
+$_SQL[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (14,NULL,1)";
+$_SQL[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (15,NULL,1)";
+$_SQL[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (17,NULL,1)";
+$_SQL[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (18,NULL,1)";
+
+
+$_SQL[] = "
+set identity_insert {$_TABLES['groups']} on
+
+INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr,
grp_gl_core) VALUES (1,'Root','Has full access to the site',1)
+INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr,
grp_gl_core) VALUES (2,'All Users','Group that a typical user is added
to',1)
+INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr,
grp_gl_core) VALUES (3,'Story Admin','Has full access to story features',1)
+INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr,
grp_gl_core) VALUES (4,'Block Admin','Has full access to block features',1)
+INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr,
grp_gl_core) VALUES (5,'Links Admin','Has full access to links features',0)
+INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr,
grp_gl_core) VALUES (6,'Topic Admin','Has full access to topic features',1)
+INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr,
grp_gl_core) VALUES (7,'Calendar Admin','Has full access to calendar
features',1)
+INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr,
grp_gl_core) VALUES (8,'Polls Admin','Has full access to polls features',0)
+INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr,
grp_gl_core) VALUES (9,'User Admin','Has full access to user features',1)
+INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr,
grp_gl_core) VALUES (10,'Plugin Admin','Has full access to plugin
features',1)
+INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr,
grp_gl_core) VALUES (11,'Group Admin','Is a User Admin with access to
groups, too',1)
+INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr,
grp_gl_core) VALUES (12,'Mail Admin','Can use Mail Utility',1)
+INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr,
grp_gl_core) VALUES (13,'Logged-in Users','All registered members',1)
+INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr,
grp_gl_core) VALUES (14,'Static Page Admin','Can administer static pages',0)
+INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr,
grp_gl_core) VALUES (15,'spamx Admin', 'Users in this group can administer
the Spam-X plugin',0)
+INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr,
grp_gl_core) VALUES (16,'Remote Users', 'Users in this group can have
authenticated against a remote server.',1)
+INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr,
grp_gl_core) VALUES (17,'Syndication Admin', 'Can create and modify web
feeds for the site',1)
+INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr,
grp_gl_core) VALUES (18,'Webservices Users', 'Can use the Webservices API
(if restricted)',0)
+
+set identity_insert {$_TABLES['groups']} off
+";
+
+
+$_SQL[] = "INSERT INTO {$_TABLES['links']} (lid, cid, url, description,
title, date, owner_id, group_id) VALUES ('geeklog.net','Geeklog
Sites','http://www.geeklog.net/','Visit the Geeklog homepage for support,
FAQs, updates, add-ons, and a great community.','Geeklog Project
Homepage',getdate(),1,5)";
+
+$_SQL[] = "INSERT INTO {$_TABLES['maillist']} (code, name) VALUES
(0,'Don''t Email')";
+$_SQL[] = "INSERT INTO {$_TABLES['maillist']} (code, name) VALUES
(1,'Email Headlines Each Night')";
+
+
+$_SQL[] = "
+set identity_insert {$_TABLES['pingservice']} on
+
+INSERT INTO {$_TABLES['pingservice']} (pid, name, site_url, ping_url,
method, is_enabled) VALUES
(1, 'Ping-O-Matic', 'http://pingomatic.com/', 'http://rpc.pingomatic.com/', 'weblogUpdates.ping',
1)
+
+set identity_insert {$_TABLES['pingservice']} off
+";
+
+
+
+$_SQL[] = "INSERT INTO {$_TABLES['plugins']} (pi_name, pi_version,
pi_gl_version, pi_enabled, pi_homepage) VALUES
('staticpages', '1.5.1','1.5.0',1,'http://www.geeklog.net/')";
+$_SQL[] = "INSERT INTO {$_TABLES['plugins']} (pi_name, pi_version,
pi_gl_version, pi_enabled, pi_homepage) VALUES
('spamx', '1.1.2','1.5.0',1,'http://www.pigstye.net/gplugs/staticpages/index.php/spamx')";
+$_SQL[] = "INSERT INTO {$_TABLES['plugins']} (pi_name, pi_version,
pi_gl_version, pi_enabled, pi_homepage) VALUES ('links', '2.0.1', '1.5.0',
1, 'http://www.geeklog.net/')";
+$_SQL[] = "INSERT INTO {$_TABLES['plugins']} (pi_name, pi_version,
pi_gl_version, pi_enabled, pi_homepage) VALUES
('polls', '2.0.2', '1.5.0', '1', 'http://www.geeklog.net/')";
+$_SQL[] = "INSERT INTO {$_TABLES['plugins']} (pi_name, pi_version,
pi_gl_version, pi_enabled, pi_homepage) VALUES
('calendar', '1.0.3', '1.5.0', '1', 'http://www.geeklog.net/')";
+
+$_DATA[] = "INSERT INTO `{$_TABLES['pollquestions']}` (`pid`, `qid`,
`question`) VALUES ('geeklogfeaturepoll', 0, 'What is the best new feature
of Geeklog?');";
+$_DATA[] = "INSERT INTO `{$_TABLES['pollquestions']}` (`pid`, `qid`,
`question`) VALUES ('geeklogfeaturepoll', 1, 'What is the all-time best
feature of Geeklog?');";
+
+$_DATA[] = "INSERT INTO `{$_TABLES['pollanswers']}` (`pid`, `qid`, `aid`,
`answer`, `votes`, `remark`) VALUES ('geeklogfeaturepoll', 0, 1, 'MS SQL
support', 0, '');";
+$_DATA[] = "INSERT INTO `{$_TABLES['pollanswers']}` (`pid`, `qid`, `aid`,
`answer`, `votes`, `remark`) VALUES ('geeklogfeaturepoll', 0,
2, 'Multi-language support', 0, '');";
+$_DATA[] = "INSERT INTO `{$_TABLES['pollanswers']}` (`pid`, `qid`, `aid`,
`answer`, `votes`, `remark`) VALUES ('geeklogfeaturepoll', 0, 3, 'Calendar
as a plugin', 0, '');";
+$_DATA[] = "INSERT INTO `{$_TABLES['pollanswers']}` (`pid`, `qid`, `aid`,
`answer`, `votes`, `remark`) VALUES ('geeklogfeaturepoll', 0, 4, 'SLV spam
protection', 0, '');";
+$_DATA[] = "INSERT INTO `{$_TABLES['pollanswers']}` (`pid`, `qid`, `aid`,
`answer`, `votes`, `remark`) VALUES ('geeklogfeaturepoll', 0,
5, 'Mass-delete users', 0, '');";
+$_DATA[] = "INSERT INTO `{$_TABLES['pollanswers']}` (`pid`, `qid`, `aid`,
`answer`, `votes`, `remark`) VALUES ('geeklogfeaturepoll', 0, 6, 'Other',
0, '');";
+$_DATA[] = "INSERT INTO `{$_TABLES['pollanswers']}` (`pid`, `qid`, `aid`,
`answer`, `votes`, `remark`) VALUES ('geeklogfeaturepoll', 1,
1, 'Story-Images', 0, '');";
+$_DATA[] = "INSERT INTO `{$_TABLES['pollanswers']}` (`pid`, `qid`, `aid`,
`answer`, `votes`, `remark`) VALUES ('geeklogfeaturepoll', 1,
2, 'User-Rights handling', 0, '');";
+$_DATA[] = "INSERT INTO `{$_TABLES['pollanswers']}` (`pid`, `qid`, `aid`,
`answer`, `votes`, `remark`) VALUES ('geeklogfeaturepoll', 1, 3, 'The
Support', 0, '');";
+$_DATA[] = "INSERT INTO `{$_TABLES['pollanswers']}` (`pid`, `qid`, `aid`,
`answer`, `votes`, `remark`) VALUES ('geeklogfeaturepoll', 1, 4, 'Plugin
Availability', 0, '');";
+
+$_SQL[] = "INSERT INTO {$_TABLES['postmodes']} (code, name) VALUES
('plaintext','Plain Old Text')";
+$_SQL[] = "INSERT INTO {$_TABLES['postmodes']} (code, name) VALUES
('html','HTML Formatted')";
+
+$_SQL[] = "INSERT INTO {$_TABLES['sortcodes']} (code, name) VALUES
('ASC','Oldest First')";
+$_SQL[] = "INSERT INTO {$_TABLES['sortcodes']} (code, name) VALUES
('DESC','Newest First')";
+
+$_SQL[] = "INSERT INTO {$_TABLES['statuscodes']} (code, name) VALUES
(1,'Refreshing')";
+$_SQL[] = "INSERT INTO {$_TABLES['statuscodes']} (code, name) VALUES
(0,'Normal')";
+$_SQL[] = "INSERT INTO {$_TABLES['statuscodes']} (code, name) VALUES
(10,'Archive')";
+
+$_SQL[] = "INSERT INTO {$_TABLES['stories']} (sid, uid, draft_flag, tid,
date, title, introtext, bodytext, hits, numemails, comments, related,
featured, commentcode, statuscode, postmode, frontpage, owner_id, group_id,
perm_owner, perm_group, perm_members, perm_anon) VALUES
('welcome',2,0,'Geeklog',getdate(),'Welcome to Geeklog!','<p>Welcome and
let me be the first to congratulate you on installing Geeklog. Please take
the time to read everything in the <a href=\"docs/index.html\">docs
directory</a>. Geeklog now has enhanced, user-based security. You should
thoroughly understand how these work before you run a production Geeklog
Site.\r\r<p>To log into your new Geeklog site, please use this
account:\r<p>Username: <b>Admin</b><br>\rPassword: <b>password</b>
<p><b>And don''t forget to <a href=\"usersettings.php\">change your
password</a> after logging
in!</b>','',100,1,0,'',1,0,0,'html',1,2,3,3,2,2,2)";
+
+$_SQL[] = "INSERT INTO {$_TABLES['storysubmission']} (sid, uid, tid,
title, introtext, date, postmode) VALUES
('security-reminder',2,'Geeklog','Are you secure?','<p>This is a reminder
to secure your site once you have Geeklog up and running. What you should
do:</p>\r\r<ol>\r<li>Change the default password for the Admin
account.</li>\r<li>Remove the install directory (you won''t need it any
more).</li>\r</ol>',getdate(),'html')";
+
+$_SQL[] = "INSERT INTO {$_TABLES['syndication']} (type, topic, header_tid,
format, limits, content_length, title, description, filename, charset,
language, is_enabled, updated, update_info) VALUES
('article', '::all', 'all', 'RSS-2.0', 10, 1, 'Geeklog Site', 'Another
Nifty Geeklog Site', 'geeklog.rss', 'iso-8859-1', 'en-gb', 1, getdate(),
NULL)";
+
+$_SQL[] = "INSERT INTO {$_TABLES['topics']} (tid, topic, imageurl,
sortnum, limitnews, group_id, owner_id, perm_owner, perm_group,
perm_members, perm_anon) VALUES ('General','General
News','/images/topics/topic_news.gif',1,10,6,2,3,2,2,2)";
+$_SQL[] = "INSERT INTO {$_TABLES['topics']} (tid, topic, imageurl,
sortnum, limitnews, group_id, owner_id, perm_owner, perm_group,
perm_members, perm_anon) VALUES
('Geeklog','Geeklog','/images/topics/topic_gl.gif',2,10,6,2,3,2,2,2)";
+
+$_SQL[] = "INSERT INTO {$_TABLES['usercomment']} (uid, commentmode,
commentorder, commentlimit) VALUES (1,'nested','ASC',100)";
+$_SQL[] = "INSERT INTO {$_TABLES['usercomment']} (uid, commentmode,
commentorder, commentlimit) VALUES (2,'threaded','ASC',100)";
+
+$_SQL[] = "INSERT INTO {$_TABLES['userindex']} (uid, tids, etids, aids,
boxes, noboxes, maxstories) VALUES (1,'','-','','',0,NULL)";
+$_SQL[] = "INSERT INTO {$_TABLES['userindex']} (uid, tids, etids, aids,
boxes, noboxes, maxstories) VALUES (2,'','','','',0,NULL)";
+
+$_SQL[] = "INSERT INTO {$_TABLES['userinfo']} (uid, about, pgpkey,
userspace, tokens, totalcomments, lastgranted) VALUES
(1,NULL,NULL,'',0,0,0)";
+$_SQL[] = "INSERT INTO {$_TABLES['userinfo']} (uid, about, pgpkey,
userspace, tokens, totalcomments, lastgranted) VALUES
(2,NULL,NULL,'',0,0,0)";
+
+$_SQL[] = "INSERT INTO {$_TABLES['userprefs']} (uid, noicons, willing,
dfid, tzid, emailstories) VALUES (1,0,0,0,'',0)";
+$_SQL[] = "INSERT INTO {$_TABLES['userprefs']} (uid, noicons, willing,
dfid, tzid, emailstories) VALUES (2,0,1,0,'',1)";
+
+$_SQL[] = "
+set identity_insert {$_TABLES['users']} on
+
+INSERT INTO {$_TABLES['users']} (uid, username, fullname, passwd, email,
homepage, sig, regdate, cookietimeout, theme, status, num_reminders) VALUES
(1,'Anonymous','Anonymous','',NULL,NULL,'',getdate(),0,NULL,3,0)
+INSERT INTO {$_TABLES['users']} (uid, username, fullname, passwd, email,
homepage, sig, regdate, cookietimeout, theme, status, num_reminders) VALUES
(2,'Admin','Geeklog
SuperUser','5f4dcc3b5aa765d61d8327deb882cf99','root ＠ localhost','http://www.geeklog.net/','',getdate(),28800,NULL,3,0)
+
+set identity_insert {$_TABLES['users']} off
+";
+
+
+$_SQL[] = "INSERT INTO {$_TABLES['vars']} (name, value) VALUES
('totalhits','0')";
+$_SQL[] = "INSERT INTO {$_TABLES['vars']} (name, value) VALUES
('lastemailedstories','')";
+$_SQL[] = "INSERT INTO {$_TABLES['vars']} (name, value) VALUES
('last_scheduled_run','')";
+$_SQL[] = "INSERT INTO {$_TABLES['vars']} (name, value) VALUES
('spamx.counter','0')";
+$_SQL[] = "INSERT INTO {$_TABLES['vars']} (name, value) VALUES
('database_version','1.5.1')";
+
+$_SQL[] = "INSERT INTO {$_TABLES['trackbackcodes']} (code, name) VALUES
(0,'Trackback Enabled')";
+$_SQL[] = "INSERT INTO {$_TABLES['trackbackcodes']} (code, name) VALUES
(-1,'Trackback Disabled')";
+
+
+
+
+
+$_SQL[] = "INSERT INTO dateCommandCrossReference (mysqlCommand,
sqlServerCommand,isDateName,isDatePart) values ('%a','weekday','1','0')";
+$_SQL[] = "INSERT INTO dateCommandCrossReference (mysqlCommand,
sqlServerCommand,isDateName,isDatePart) values ('%b','month','1','0')";
+$_SQL[] = "INSERT INTO dateCommandCrossReference (mysqlCommand,
sqlServerCommand,isDateName,isDatePart) values ('%c','mm','0','1')";
+$_SQL[] = "INSERT INTO dateCommandCrossReference (mysqlCommand,
sqlServerCommand,isDateName,isDatePart) values ('%D','d','0','1')";
+$_SQL[] = "INSERT INTO dateCommandCrossReference (mysqlCommand,
sqlServerCommand,isDateName,isDatePart) values ('%d','d','0','1')";
+$_SQL[] = "INSERT INTO dateCommandCrossReference (mysqlCommand,
sqlServerCommand,isDateName,isDatePart) values ('%e','d','0','1')";
+$_SQL[] = "INSERT INTO dateCommandCrossReference (mysqlCommand,
sqlServerCommand,isDateName,isDatePart) values ('%f','ms','0','1')";
+$_SQL[] = "INSERT INTO dateCommandCrossReference (mysqlCommand,
sqlServerCommand,isDateName,isDatePart) values ('%H','hh','0','1')";
+$_SQL[] = "INSERT INTO dateCommandCrossReference (mysqlCommand,
sqlServerCommand,isDateName,isDatePart) values ('%h','hh','0','1')";
+$_SQL[] = "INSERT INTO dateCommandCrossReference (mysqlCommand,
sqlServerCommand,isDateName,isDatePart) values ('%I','mi','0','1')";
+$_SQL[] = "INSERT INTO dateCommandCrossReference (mysqlCommand,
sqlServerCommand,isDateName,isDatePart) values ('%i','mi','0','1')";
+$_SQL[] = "INSERT INTO dateCommandCrossReference (mysqlCommand,
sqlServerCommand,isDateName,isDatePart) values ('%j','dayofyear','1','1')";
+$_SQL[] = "INSERT INTO dateCommandCrossReference (mysqlCommand,
sqlServerCommand,isDateName,isDatePart) values ('%k','hh','0','1')";
+$_SQL[] = "INSERT INTO dateCommandCrossReference (mysqlCommand,
sqlServerCommand,isDateName,isDatePart) values ('%l','hh','0','1')";
+$_SQL[] = "INSERT INTO dateCommandCrossReference (mysqlCommand,
sqlServerCommand,isDateName,isDatePart) values ('%M','month','1','1')";
+$_SQL[] = "INSERT INTO dateCommandCrossReference (mysqlCommand,
sqlServerCommand,isDateName,isDatePart) values ('%m','mm','0','1')";
+$_SQL[] = "INSERT INTO dateCommandCrossReference (mysqlCommand,
sqlServerCommand,isDateName,isDatePart) values ('%p','','0','0')";
+$_SQL[] = "INSERT INTO dateCommandCrossReference (mysqlCommand,
sqlServerCommand,isDateName,isDatePart) values ('%r','','0','0')";
+$_SQL[] = "INSERT INTO dateCommandCrossReference (mysqlCommand,
sqlServerCommand,isDateName,isDatePart) values ('%S','seconds','0','1')";
+$_SQL[] = "INSERT INTO dateCommandCrossReference (mysqlCommand,
sqlServerCommand,isDateName,isDatePart) values ('%s','seconds','0','1')";
+$_SQL[] = "INSERT INTO dateCommandCrossReference (mysqlCommand,
sqlServerCommand,isDateName,isDatePart) values ('%T','','0','1')";
+$_SQL[] = "INSERT INTO dateCommandCrossReference (mysqlCommand,
sqlServerCommand,isDateName,isDatePart) values ('%U','week','0','1')";
+$_SQL[] = "INSERT INTO dateCommandCrossReference (mysqlCommand,
sqlServerCommand,isDateName,isDatePart) values ('%u','week','0','1')";
+$_SQL[] = "INSERT INTO dateCommandCrossReference (mysqlCommand,
sqlServerCommand,isDateName,isDatePart) values ('%V','week','0','1')";
+$_SQL[] = "INSERT INTO dateCommandCrossReference (mysqlCommand,
sqlServerCommand,isDateName,isDatePart) values ('%v','week','0','1')";
+$_SQL[] = "INSERT INTO dateCommandCrossReference (mysqlCommand,
sqlServerCommand,isDateName,isDatePart) values ('%W','dw','1','0')";
+$_SQL[] = "INSERT INTO dateCommandCrossReference (mysqlCommand,
sqlServerCommand,isDateName,isDatePart) values ('%w','dw','0','1')";
+$_SQL[] = "INSERT INTO dateCommandCrossReference (mysqlCommand,
sqlServerCommand,isDateName,isDatePart) values ('%X','year','0','1')";
+$_SQL[] = "INSERT INTO dateCommandCrossReference (mysqlCommand,
sqlServerCommand,isDateName,isDatePart) values ('%x','year','0','1')";
+$_SQL[] = "INSERT INTO dateCommandCrossReference (mysqlCommand,
sqlServerCommand,isDateName,isDatePart) values ('%Y','year','0','1')";
+$_SQL[] = "INSERT INTO dateCommandCrossReference (mysqlCommand,
sqlServerCommand,isDateName,isDatePart) values ('%y','year','0','1')";
+$_SQL[] = "INSERT INTO dateCommandCrossReference (mysqlCommand,
sqlServerCommand,isDateName,isDatePart) values ('%%','','0','1')";
+
+
+
+
+
+
+$_SQL[] = "
+if @@error=0
+begin
+ commit tran
+end
+
+else
+begin
+ rollback tran
+end
+
+";
+
+
+
+$_DATA = array();
+
+?>
Added: externals/geeklog-1.5.2sr2/sql/mysql_tableanddata.php
==============================================================================
--- (empty file)
+++ externals/geeklog-1.5.2sr2/sql/mysql_tableanddata.php Sun Apr 5
17:41:59 2009
@@ -0,0 +1,990 @@
+<?php
+
+$_SQL[] = "
+CREATE TABLE {$_TABLES['access']} (
+ acc_ft_id mediumint(8) NOT NULL default '0',
+ acc_grp_id mediumint(8) NOT NULL default '0',
+ PRIMARY KEY (acc_ft_id,acc_grp_id)
+) TYPE=MyISAM
+";
+
+$_SQL[] = "
+CREATE TABLE {$_TABLES['article_images']} (
+ ai_sid varchar(40) NOT NULL,
+ ai_img_num tinyint(2) unsigned NOT NULL,
+ ai_filename varchar(128) NOT NULL,
+ PRIMARY KEY (ai_sid,ai_img_num)
+) TYPE=MyISAM
+";
+
+$_SQL[] = "
+CREATE TABLE {$_TABLES['blocks']} (
+ bid smallint(5) unsigned NOT NULL auto_increment,
+ is_enabled tinyint(1) unsigned NOT NULL DEFAULT '1',
+ name varchar(48) NOT NULL default '',
+ type varchar(20) NOT NULL default 'normal',
+ title varchar(48) default NULL,
+ tid varchar(20) NOT NULL default 'All',
+ blockorder smallint(5) unsigned NOT NULL default '1',
+ content text,
+ allow_autotags tinyint(1) unsigned NOT NULL DEFAULT '0',
+ rdfurl varchar(255) default NULL,
+ rdfupdated datetime NOT NULL default '0000-00-00 00:00:00',
+ rdf_last_modified varchar(40) default NULL,
+ rdf_etag varchar(40) default NULL,
+ rdflimit smallint(5) unsigned NOT NULL default '0',
+ onleft tinyint(3) unsigned NOT NULL default '1',
+ phpblockfn varchar(128) default '',
+ help varchar(255) default '',
+ owner_id mediumint(8) unsigned NOT NULL default '1',
+ group_id mediumint(8) unsigned NOT NULL default '1',
+ perm_owner tinyint(1) unsigned NOT NULL default '3',
+ perm_group tinyint(1) unsigned NOT NULL default '3',
+ perm_members tinyint(1) unsigned NOT NULL default '2',
+ perm_anon tinyint(1) unsigned NOT NULL default '2',
+ INDEX blocks_bid(bid),
+ INDEX blocks_is_enabled(is_enabled),
+ INDEX blocks_tid(tid),
+ INDEX blocks_type(type),
+ INDEX blocks_name(name),
+ INDEX blocks_onleft(onleft),
+ PRIMARY KEY (bid)
+) TYPE=MyISAM
+";
+
+$_SQL[] = "
+CREATE TABLE {$_TABLES['commentcodes']} (
+ code tinyint(4) NOT NULL default '0',
+ name varchar(32) default NULL,
+ PRIMARY KEY (code)
+) TYPE=MyISAM
+";
+
+$_SQL[] = "
+CREATE TABLE {$_TABLES['commentmodes']} (
+ mode varchar(10) NOT NULL default '',
+ name varchar(32) default NULL,
+ PRIMARY KEY (mode)
+) TYPE=MyISAM
+";
+
+$_SQL[] = "
+CREATE TABLE {$_TABLES['comments']} (
+ cid int(10) unsigned NOT NULL auto_increment,
+ type varchar(30) NOT NULL DEFAULT 'article',
+ sid varchar(40) NOT NULL default '',
+ date datetime default NULL,
+ title varchar(128) default NULL,
+ comment text,
+ score tinyint(4) NOT NULL default '0',
+ reason tinyint(4) NOT NULL default '0',
+ pid int(10) unsigned NOT NULL default '0',
+ lft mediumint(10) unsigned NOT NULL default '0',
+ rht mediumint(10) unsigned NOT NULL default '0',
+ indent mediumint(10) unsigned NOT NULL default '0',
+ uid mediumint(8) NOT NULL default '1',
+ ipaddress varchar(15) NOT NULL default '',
+ INDEX comments_sid(sid),
+ INDEX comments_uid(uid),
+ INDEX comments_lft(lft),
+ INDEX comments_rht(rht),
+ INDEX comments_date(date),
+ PRIMARY KEY (cid)
+) TYPE=MyISAM
+";
+
+$_SQL[] = "
+CREATE TABLE {$_TABLES['conf_values']} (
+ name varchar(50) default NULL,
+ value text,
+ type varchar(50) default NULL,
+ group_name varchar(50) default NULL,
+ default_value text,
+ subgroup int(11) default NULL,
+ selectionArray int(11) default NULL,
+ sort_order int(11) default NULL,
+ fieldset int(11) default NULL
+) TYPE=MyISAM
+";
+
+$_SQL[] = "
+CREATE TABLE {$_TABLES['cookiecodes']} (
+ cc_value int(8) unsigned NOT NULL default '0',
+ cc_descr varchar(20) NOT NULL default '',
+ PRIMARY KEY (cc_value)
+) TYPE=MyISAM
+";
+
+$_SQL[] = "
+CREATE TABLE {$_TABLES['dateformats']} (
+ dfid tinyint(4) NOT NULL default '0',
+ format varchar(32) default NULL,
+ description varchar(64) default NULL,
+ PRIMARY KEY (dfid)
+) TYPE=MyISAM
+";
+
+$_SQL[] = "
+CREATE TABLE {$_TABLES['featurecodes']} (
+ code tinyint(4) NOT NULL default '0',
+ name varchar(32) default NULL,
+ PRIMARY KEY (code)
+) TYPE=MyISAM
+";
+
+$_SQL[] = "
+CREATE TABLE {$_TABLES['features']} (
+ ft_id mediumint(8) NOT NULL auto_increment,
+ ft_name varchar(20) NOT NULL default '',
+ ft_descr varchar(255) NOT NULL default '',
+ ft_gl_core tinyint(1) NOT NULL default '0',
+ PRIMARY KEY (ft_id),
+ KEY ft_name (ft_name)
+) TYPE=MyISAM
+";
+
+$_SQL[] = "
+CREATE TABLE {$_TABLES['frontpagecodes']} (
+ code tinyint(4) NOT NULL default '0',
+ name varchar(32) default NULL,
+ PRIMARY KEY (code)
+) TYPE=MyISAM
+";
+
+$_SQL[] = "
+CREATE TABLE {$_TABLES['group_assignments']} (
+ ug_main_grp_id mediumint(8) NOT NULL default '0',
+ ug_uid mediumint(8) unsigned default NULL,
+ ug_grp_id mediumint(8) unsigned default NULL,
+ INDEX group_assignments_ug_main_grp_id(ug_main_grp_id),
+ INDEX group_assignments_ug_uid(ug_uid),
+ KEY ug_main_grp_id (ug_main_grp_id)
+) TYPE=MyISAM
+";
+
+$_SQL[] = "
+CREATE TABLE {$_TABLES['groups']} (
+ grp_id mediumint(8) NOT NULL auto_increment,
+ grp_name varchar(50) NOT NULL default '',
+ grp_descr varchar(255) NOT NULL default '',
+ grp_gl_core tinyint(1) unsigned NOT NULL default '0',
+ PRIMARY KEY (grp_id),
+ UNIQUE grp_name (grp_name)
+) TYPE=MyISAM
+";
+
+$_SQL[] = "
+CREATE TABLE {$_TABLES['maillist']} (
+ code int(1) NOT NULL default '0',
+ name char(32) default NULL,
+ PRIMARY KEY (code)
+) TYPE=MyISAM
+";
+
+$_SQL[] = "
+CREATE TABLE {$_TABLES['pingservice']} (
+ pid smallint(5) unsigned NOT NULL auto_increment,
+ name varchar(128) default NULL,
+ ping_url varchar(255) default NULL,
+ site_url varchar(255) default NULL,
+ method varchar(80) default NULL,
+ is_enabled tinyint(1) unsigned NOT NULL DEFAULT '1',
+ PRIMARY KEY (pid),
+ INDEX pingservice_is_enabled(is_enabled)
+) TYPE=MyISAM
+";
+
+$_SQL[] = "
+CREATE TABLE {$_TABLES['plugins']} (
+ pi_name varchar(30) NOT NULL default '',
+ pi_version varchar(20) NOT NULL default '',
+ pi_gl_version varchar(20) NOT NULL default '',
+ pi_enabled tinyint(3) unsigned NOT NULL default '1',
+ pi_homepage varchar(128) NOT NULL default '',
+ INDEX plugins_enabled(pi_enabled),
+ PRIMARY KEY (pi_name)
+) TYPE=MyISAM
+";
+
+$_SQL[] = "
+CREATE TABLE {$_TABLES['postmodes']} (
+ code char(10) NOT NULL default '',
+ name char(32) default NULL,
+ PRIMARY KEY (code)
+) TYPE=MyISAM
+";
+
+$_SQL[] = "
+CREATE TABLE {$_TABLES['sessions']} (
+ sess_id int(10) unsigned NOT NULL default '0',
+ start_time int(10) unsigned NOT NULL default '0',
+ remote_ip varchar(15) NOT NULL default '',
+ uid mediumint(8) NOT NULL default '1',
+ md5_sess_id varchar(128) default NULL,
+ PRIMARY KEY (sess_id),
+ KEY sess_id (sess_id),
+ KEY start_time (start_time),
+ KEY remote_ip (remote_ip)
+) TYPE=MyISAM
+";
+
+$_SQL[] = "
+CREATE TABLE {$_TABLES['sortcodes']} (
+ code char(4) NOT NULL default '0',
+ name char(32) default NULL,
+ PRIMARY KEY (code)
+) TYPE=MyISAM
+";
+
+$_SQL[] = "
+CREATE TABLE {$_TABLES['speedlimit']} (
+ id int(10) unsigned NOT NULL auto_increment,
+ ipaddress varchar(15) NOT NULL default '',
+ date int(10) unsigned default NULL,
+ type varchar(30) NOT NULL default 'submit',
+ PRIMARY KEY (id),
+ KEY type_ipaddress (type,ipaddress),
+ KEY date (date)
+) TYPE = MyISAM
+";
+
+$_SQL[] = "
+CREATE TABLE {$_TABLES['statuscodes']} (
+ code int(1) NOT NULL default '0',
+ name char(32) default NULL,
+ PRIMARY KEY (code)
+) TYPE=MyISAM
+";
+
+$_SQL[] = "
+CREATE TABLE {$_TABLES['stories']} (
+ sid varchar(40) NOT NULL default '',
+ uid mediumint(8) NOT NULL default '1',
+ draft_flag tinyint(3) unsigned default '0',
+ tid varchar(20) NOT NULL default 'General',
+ date datetime default NULL,
+ title varchar(128) default NULL,
+ introtext text,
+ bodytext text,
+ hits mediumint(8) unsigned NOT NULL default '0',
+ numemails mediumint(8) unsigned NOT NULL default '0',
+ comments mediumint(8) unsigned NOT NULL default '0',
+ trackbacks mediumint(8) unsigned NOT NULL default '0',
+ related text,
+ featured tinyint(3) unsigned NOT NULL default '0',
+ show_topic_icon tinyint(1) unsigned NOT NULL default '1',
+ commentcode tinyint(4) NOT NULL default '0',
+ trackbackcode tinyint(4) NOT NULL default '0',
+ statuscode tinyint(4) NOT NULL default '0',
+ expire DATETIME NOT NULL default '0000-00-00 00:00:00',
+ postmode varchar(10) NOT NULL default 'html',
+ advanced_editor_mode tinyint(1) unsigned default '0',
+ frontpage tinyint(3) unsigned default '1',
+ in_transit tinyint(1) unsigned default '0',
+ owner_id mediumint(8) NOT NULL default '1',
+ group_id mediumint(8) NOT NULL default '2',
+ perm_owner tinyint(1) unsigned NOT NULL default '3',
+ perm_group tinyint(1) unsigned NOT NULL default '3',
+ perm_members tinyint(1) unsigned NOT NULL default '2',
+ perm_anon tinyint(1) unsigned NOT NULL default '2',
+ INDEX stories_sid(sid),
+ INDEX stories_tid(tid),
+ INDEX stories_uid(uid),
+ INDEX stories_featured(featured),
+ INDEX stories_hits(hits),
+ INDEX stories_statuscode(statuscode),
+ INDEX stories_expire(expire),
+ INDEX stories_date(date),
+ INDEX stories_frontpage(frontpage),
+ INDEX stories_in_transit(in_transit),
+ PRIMARY KEY (sid)
+) TYPE=MyISAM
+";
+
+$_SQL[] = "
+CREATE TABLE {$_TABLES['storysubmission']} (
+ sid varchar(20) NOT NULL default '',
+ uid mediumint(8) NOT NULL default '1',
+ tid varchar(20) NOT NULL default 'General',
+ title varchar(128) default NULL,
+ introtext text,
+ bodytext text,
+ date datetime default NULL,
+ postmode varchar(10) NOT NULL default 'html',
+ PRIMARY KEY (sid)
+) TYPE=MyISAM
+";
+
+$_SQL[] = "
+CREATE TABLE {$_TABLES['syndication']} (
+ fid int(10) unsigned NOT NULL auto_increment,
+ type varchar(30) NOT NULL default 'article',
+ topic varchar(48) NOT NULL default '::all',
+ header_tid varchar(48) NOT NULL default 'none',
+ format varchar(20) NOT NULL default 'RSS-2.0',
+ limits varchar(5) NOT NULL default '10',
+ content_length smallint(5) unsigned NOT NULL default '0',
+ title varchar(40) NOT NULL default '',
+ description text,
+ feedlogo varchar(255),
+ filename varchar(40) NOT NULL default 'geeklog.rss',
+ charset varchar(20) NOT NULL default 'UTF-8',
+ language varchar(20) NOT NULL default 'en-gb',
+ is_enabled tinyint(1) unsigned NOT NULL default '1',
+ updated datetime NOT NULL default '0000-00-00 00:00:00',
+ update_info text,
+ PRIMARY KEY (fid),
+ INDEX syndication_type(type),
+ INDEX syndication_topic(topic),
+ INDEX syndication_is_enabled(is_enabled),
+ INDEX syndication_updated(updated)
+) TYPE=MyISAM
+";
+
+$_SQL[] = "
+CREATE TABLE {$_TABLES['tokens']} (
+ token varchar(32) NOT NULL,
+ created datetime NOT NULL,
+ owner_id mediumint(8) unsigned NOT NULL,
+ urlfor varchar(255) NOT NULL,
+ ttl mediumint(8) unsigned NOT NULL default '1',
+ PRIMARY KEY (token)
+) TYPE=MyISAM
+";
+
+$_SQL[] = "
+CREATE TABLE {$_TABLES['topics']} (
+ tid varchar(20) NOT NULL default '',
+ topic varchar(48) default NULL,
+ imageurl varchar(255) default NULL,
+ sortnum tinyint(3) default NULL,
+ limitnews tinyint(3) default NULL,
+ is_default tinyint(1) unsigned NOT NULL DEFAULT '0',
+ archive_flag tinyint(1) unsigned NOT NULL DEFAULT '0',
+ owner_id mediumint(8) unsigned NOT NULL default '1',
+ group_id mediumint(8) unsigned NOT NULL default '1',
+ perm_owner tinyint(1) unsigned NOT NULL default '3',
+ perm_group tinyint(1) unsigned NOT NULL default '3',
+ perm_members tinyint(1) unsigned NOT NULL default '2',
+ perm_anon tinyint(1) unsigned NOT NULL default '2',
+ PRIMARY KEY (tid)
+) TYPE=MyISAM
+";
+
+$_SQL[] = "
+CREATE TABLE {$_TABLES['trackback']} (
+ cid int(10) unsigned NOT NULL auto_increment,
+ sid varchar(40) NOT NULL,
+ url varchar(255) default NULL,
+ title varchar(128) default NULL,
+ blog varchar(80) default NULL,
+ excerpt text,
+ date datetime default NULL,
+ type varchar(30) NOT NULL default 'article',
+ ipaddress varchar(15) NOT NULL default '',
+ PRIMARY KEY (cid),
+ INDEX trackback_sid(sid),
+ INDEX trackback_url(url),
+ INDEX trackback_type(type),
+ INDEX trackback_date(date)
+) TYPE=MyISAM
+";
+
+$_SQL[] = "
+CREATE TABLE {$_TABLES['trackbackcodes']} (
+ code tinyint(4) NOT NULL default '0',
+ name varchar(32) default NULL,
+ PRIMARY KEY (code)
+) TYPE=MyISAM
+";
+
+$_SQL[] = "
+CREATE TABLE {$_TABLES['usercomment']} (
+ uid mediumint(8) NOT NULL default '1',
+ commentmode varchar(10) NOT NULL default 'threaded',
+ commentorder varchar(4) NOT NULL default 'ASC',
+ commentlimit mediumint(8) unsigned NOT NULL default '100',
+ PRIMARY KEY (uid)
+) TYPE=MyISAM
+";
+
+$_SQL[] = "
+CREATE TABLE {$_TABLES['userindex']} (
+ uid mediumint(8) NOT NULL default '1',
+ tids varchar(255) NOT NULL default '',
+ etids text,
+ aids varchar(255) NOT NULL default '',
+ boxes varchar(255) NOT NULL default '',
+ noboxes tinyint(4) NOT NULL default '0',
+ maxstories tinyint(4) default NULL,
+ INDEX userindex_uid(uid),
+ INDEX userindex_noboxes(noboxes),
+ INDEX userindex_maxstories(maxstories),
+ PRIMARY KEY (uid)
+) TYPE=MyISAM
+";
+
+$_SQL[] = "
+CREATE TABLE {$_TABLES['userinfo']} (
+ uid mediumint(8) NOT NULL default '1',
+ about text,
+ location varchar(96) NOT NULL default '',
+ pgpkey text,
+ userspace varchar(255) NOT NULL default '',
+ tokens tinyint(3) unsigned NOT NULL default '0',
+ totalcomments mediumint(9) NOT NULL default '0',
+ lastgranted int(10) unsigned NOT NULL default '0',
+ lastlogin VARCHAR(10) NOT NULL default '0',
+ PRIMARY KEY (uid)
+) TYPE=MyISAM
+";
+
+$_SQL[] = "
+CREATE TABLE {$_TABLES['userprefs']} (
+ uid mediumint(8) NOT NULL default '1',
+ noicons tinyint(3) unsigned NOT NULL default '0',
+ willing tinyint(3) unsigned NOT NULL default '1',
+ dfid tinyint(3) unsigned NOT NULL default '0',
+ tzid varchar(125) NOT NULL default '',
+ emailstories tinyint(4) NOT NULL default '1',
+ emailfromadmin tinyint(1) NOT NULL default '1',
+ emailfromuser tinyint(1) NOT NULL default '1',
+ showonline tinyint(1) NOT NULL default '1',
+ PRIMARY KEY (uid)
+) TYPE=MyISAM
+";
+
+$_SQL[] = "
+CREATE TABLE {$_TABLES['users']} (
+ uid mediumint(8) NOT NULL auto_increment,
+ username varchar(16) NOT NULL default '',
+ remoteusername varchar(60) NULL,
+ remoteservice varchar(60) NULL,
+ fullname varchar(80) default NULL,
+ passwd varchar(32) NOT NULL default '',
+ email varchar(96) default NULL,
+ homepage varchar(96) default NULL,
+ sig varchar(160) NOT NULL default '',
+ regdate datetime NOT NULL default '0000-00-00 00:00:00',
+ photo varchar(128) DEFAULT NULL,
+ cookietimeout int(8) unsigned default '28800',
+ theme varchar(64) default NULL,
+ language varchar(64) default NULL,
+ pwrequestid varchar(16) default NULL,
+ status smallint(5) unsigned NOT NULL default '1',
+ num_reminders tinyint(1) NOT NULL default 0,
+ PRIMARY KEY (uid),
+ KEY LOGIN (uid,passwd,username),
+ INDEX users_username(username),
+ INDEX users_fullname(fullname),
+ INDEX users_email(email),
+ INDEX users_passwd(passwd),
+ INDEX users_pwrequestid(pwrequestid)
+) TYPE=MyISAM
+";
+
+$_SQL[] = "
+CREATE TABLE {$_TABLES['vars']} (
+ name varchar(20) NOT NULL default '',
+ value varchar(128) default NULL,
+ PRIMARY KEY (name)
+) TYPE=MyISAM
+";
+
+// Tables used by the bundled plugins
+
+// Calendar plugin
+$_SQL[] = "
+CREATE TABLE {$_TABLES['events']} (
+ eid varchar(20) NOT NULL default '',
+ title varchar(128) default NULL,
+ description text,
+ postmode varchar(10) NOT NULL default 'plaintext',
+ datestart date default NULL,
+ dateend date default NULL,
+ url varchar(255) default NULL,
+ hits mediumint(8) unsigned NOT NULL default '0',
+ owner_id mediumint(8) unsigned NOT NULL default '1',
+ group_id mediumint(8) unsigned NOT NULL default '1',
+ perm_owner tinyint(1) unsigned NOT NULL default '3',
+ perm_group tinyint(1) unsigned NOT NULL default '3',
+ perm_members tinyint(1) unsigned NOT NULL default '2',
+ perm_anon tinyint(1) unsigned NOT NULL default '2',
+ address1 varchar(40) default NULL,
+ address2 varchar(40) default NULL,
+ city varchar(60) default NULL,
+ state varchar(40) default NULL,
+ zipcode varchar(5) default NULL,
+ allday tinyint(1) NOT NULL default '0',
+ event_type varchar(40) NOT NULL default '',
+ location varchar(128) default NULL,
+ timestart time default NULL,
+ timeend time default NULL,
+ INDEX events_eid(eid),
+ INDEX events_event_type(event_type),
+ INDEX events_datestart(datestart),
+ INDEX events_dateend(dateend),
+ PRIMARY KEY (eid)
+) TYPE=MyISAM
+";
+
+$_SQL[] = "
+CREATE TABLE {$_TABLES['eventsubmission']} (
+ eid varchar(20) NOT NULL default '',
+ title varchar(128) default NULL,
+ description text,
+ location varchar(128) default NULL,
+ datestart date default NULL,
+ dateend date default NULL,
+ url varchar(255) default NULL,
+ allday tinyint(1) NOT NULL default '0',
+ zipcode varchar(5) default NULL,
+ state varchar(40) default NULL,
+ city varchar(60) default NULL,
+ address2 varchar(40) default NULL,
+ address1 varchar(40) default NULL,
+ event_type varchar(40) NOT NULL default '',
+ timestart time default NULL,
+ timeend time default NULL,
+ PRIMARY KEY (eid)
+) TYPE=MyISAM
+";
+
+$_SQL[] = "
+CREATE TABLE {$_TABLES['personal_events']} (
+ eid varchar(20) NOT NULL default '',
+ title varchar(128) default NULL,
+ event_type varchar(40) NOT NULL default '',
+ datestart date default NULL,
+ dateend date default NULL,
+ address1 varchar(40) default NULL,
+ address2 varchar(40) default NULL,
+ city varchar(60) default NULL,
+ state varchar(40) default NULL,
+ zipcode varchar(5) default NULL,
+ allday tinyint(1) NOT NULL default '0',
+ url varchar(255) default NULL,
+ description text,
+ postmode varchar(10) NOT NULL default 'plaintext',
+ owner_id mediumint(8) unsigned NOT NULL default '1',
+ group_id mediumint(8) unsigned NOT NULL default '1',
+ perm_owner tinyint(1) unsigned NOT NULL default '3',
+ perm_group tinyint(1) unsigned NOT NULL default '3',
+ perm_members tinyint(1) unsigned NOT NULL default '2',
+ perm_anon tinyint(1) unsigned NOT NULL default '2',
+ uid mediumint(8) NOT NULL default '0',
+ location varchar(128) default NULL,
+ timestart time default NULL,
+ timeend time default NULL,
+ PRIMARY KEY (eid,uid)
+) TYPE=MyISAM
+";
+
+// Links plugin
+$_SQL[] = "
+CREATE TABLE {$_TABLES['linkcategories']} (
+ cid varchar(32) NOT NULL,
+ pid varchar(32) NOT NULL,
+ category varchar(32) NOT NULL,
+ description text DEFAULT NULL,
+ tid varchar(20) DEFAULT NULL,
+ created datetime DEFAULT NULL,
+ modified datetime DEFAULT NULL,
+ owner_id mediumint(8) unsigned NOT NULL default '1',
+ group_id mediumint(8) unsigned NOT NULL default '1',
+ perm_owner tinyint(1) unsigned NOT NULL default '3',
+ perm_group tinyint(1) unsigned NOT NULL default '2',
+ perm_members tinyint(1) unsigned NOT NULL default '2',
+ perm_anon tinyint(1) unsigned NOT NULL default '2',
+ PRIMARY KEY (cid),
+ KEY links_pid (pid)
+) TYPE=MyISAM
+";
+
+$_SQL[] = "
+CREATE TABLE {$_TABLES['links']} (
+ lid varchar(40) NOT NULL default '',
+ cid varchar(32) default NULL,
+ url varchar(255) default NULL,
+ description text,
+ title varchar(96) default NULL,
+ hits int(11) NOT NULL default '0',
+ date datetime default NULL,
+ owner_id mediumint(8) unsigned NOT NULL default '1',
+ group_id mediumint(8) unsigned NOT NULL default '1',
+ perm_owner tinyint(1) unsigned NOT NULL default '3',
+ perm_group tinyint(1) unsigned NOT NULL default '2',
+ perm_members tinyint(1) unsigned NOT NULL default '2',
+ perm_anon tinyint(1) unsigned NOT NULL default '2',
+ INDEX links_category(cid),
+ INDEX links_date(date),
+ PRIMARY KEY (lid)
+) TYPE=MyISAM
+";
+
+$_SQL[] = "
+CREATE TABLE {$_TABLES['linksubmission']} (
+ lid varchar(40) NOT NULL default '',
+ cid varchar(32) default NULL,
+ url varchar(255) default NULL,
+ description text,
+ title varchar(96) default NULL,
+ hits int(11) default NULL,
+ date datetime default NULL,
+ owner_id mediumint(8) unsigned NOT NULL default '1',
+ PRIMARY KEY (lid)
+) TYPE=MyISAM
+";
+
+// Polls plugin
+$_SQL[] = "
+CREATE TABLE {$_TABLES['pollanswers']} (
+ pid varchar(20) NOT NULL default '',
+ qid mediumint(9) NOT NULL default '0',
+ aid tinyint(3) unsigned NOT NULL default '0',
+ answer varchar(255) default NULL,
+ votes mediumint(8) unsigned default NULL,
+ remark varchar(255) NULL,
+ PRIMARY KEY (pid, qid, aid)
+) TYPE=MyISAM
+";
+
+$_SQL[] = "
+CREATE TABLE {$_TABLES['pollquestions']} (
+ qid mediumint(9) NOT NULL DEFAULT '0',
+ pid varchar(20) NOT NULL,
+ question varchar(255) NOT NULL,
+ PRIMARY KEY (qid, pid)
+) TYPE=MyISAM
+";
+
+$_SQL[] = "
+CREATE TABLE {$_TABLES['polltopics']} (
+ pid varchar(20) NOT NULL,
+ topic varchar(255) default NULL,
+ voters mediumint(8) unsigned default NULL,
+ questions int(11) NOT NULL default '0',
+ date datetime default NULL,
+ display tinyint(4) NOT NULL default '0',
+ is_open tinyint(1) NOT NULL default '1',
+ hideresults tinyint(1) NOT NULL default '0',
+ commentcode tinyint(4) NOT NULL default '0',
+ statuscode tinyint(4) NOT NULL default '0',
+ owner_id mediumint(8) unsigned NOT NULL default '1',
+ group_id mediumint(8) unsigned NOT NULL default '1',
+ perm_owner tinyint(1) unsigned NOT NULL default '3',
+ perm_group tinyint(1) unsigned NOT NULL default '2',
+ perm_members tinyint(1) unsigned NOT NULL default '2',
+ perm_anon tinyint(1) unsigned NOT NULL default '2',
+ INDEX pollquestions_pid(pid),
+ INDEX pollquestions_date(date),
+ INDEX pollquestions_display(display),
+ INDEX pollquestions_commentcode(commentcode),
+ INDEX pollquestions_statuscode(statuscode),
+ PRIMARY KEY (pid)
+) TYPE=MyISAM
+";
+
+$_SQL[] = "
+CREATE TABLE {$_TABLES['pollvoters']} (
+ id int(10) unsigned NOT NULL auto_increment,
+ pid varchar(20) NOT NULL default '',
+ ipaddress varchar(15) NOT NULL default '',
+ date int(10) unsigned default NULL,
+ PRIMARY KEY (id)
+) TYPE=MyISAM
+";
+
+// Spam-X plugin
+$_SQL[] = "
+CREATE TABLE {$_TABLES['spamx']} (
+ name varchar(20) NOT NULL default '',
+ value varchar(255) NOT NULL default '',
+ INDEX spamx_name(name)
+) TYPE=MyISAM
+";
+
+// Static Pages plugin
+$_SQL[] = "
+CREATE TABLE {$_TABLES['staticpage']} (
+ sp_id varchar(40) NOT NULL default '',
+ sp_uid mediumint(8) NOT NULL default '1',
+ sp_title varchar(128) NOT NULL default '',
+ sp_content text NOT NULL,
+ sp_hits mediumint(8) unsigned NOT NULL default '0',
+ sp_date datetime NOT NULL default '0000-00-00 00:00:00',
+ sp_format varchar(20) NOT NULL default '',
+ sp_onmenu tinyint(1) unsigned NOT NULL default '0',
+ sp_label varchar(64) default NULL,
+ commentcode tinyint(4) NOT NULL default '0',
+ owner_id mediumint(8) unsigned NOT NULL default '1',
+ group_id mediumint(8) unsigned NOT NULL default '1',
+ perm_owner tinyint(1) unsigned NOT NULL default '3',
+ perm_group tinyint(1) unsigned NOT NULL default '2',
+ perm_members tinyint(1) unsigned NOT NULL default '2',
+ perm_anon tinyint(1) unsigned NOT NULL default '2',
+ sp_centerblock tinyint(1) unsigned NOT NULL default '0',
+ sp_help varchar(255) default '',
+ sp_tid varchar(20) NOT NULL default 'none',
+ sp_where tinyint(1) unsigned NOT NULL default '1',
+ sp_php tinyint(1) unsigned NOT NULL default '0',
+ sp_nf tinyint(1) unsigned default '0',
+ sp_inblock tinyint(1) unsigned default '1',
+ postmode varchar(16) NOT NULL default 'html',
+ PRIMARY KEY (sp_id),
+ KEY staticpage_sp_uid (sp_uid),
+ KEY staticpage_sp_date (sp_date),
+ KEY staticpage_sp_onmenu (sp_onmenu),
+ KEY staticpage_sp_centerblock (sp_centerblock),
+ KEY staticpage_sp_tid (sp_tid),
+ KEY staticpage_sp_where (sp_where)
+) TYPE=MyISAM
+";
+
+
+$_DATA[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id)
VALUES (1,3) ";
+$_DATA[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id)
VALUES (2,3) ";
+$_DATA[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id)
VALUES (3,5) ";
+$_DATA[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id)
VALUES (4,5) ";
+$_DATA[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id)
VALUES (5,9) ";
+$_DATA[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id)
VALUES (5,11) ";
+$_DATA[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id)
VALUES (6,9) ";
+$_DATA[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id)
VALUES (6,11) ";
+$_DATA[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id)
VALUES(7,12) ";
+$_DATA[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id)
VALUES (8,7) ";
+$_DATA[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id)
VALUES (9,7) ";
+$_DATA[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id)
VALUES (10,4) ";
+$_DATA[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id)
VALUES (11,6) ";
+$_DATA[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id)
VALUES (12,8) ";
+$_DATA[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id)
VALUES (13,10) ";
+$_DATA[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id)
VALUES (14,11) ";
+$_DATA[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id)
VALUES (15,11) ";
+$_DATA[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id)
VALUES (16,4) ";
+$_DATA[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id)
VALUES (17,14) ";
+$_DATA[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id)
VALUES (18,14) ";
+$_DATA[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id)
VALUES (23,15) ";
+$_DATA[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id)
VALUES (24,3) ";
+$_DATA[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id)
VALUES (25,17) ";
+$_DATA[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id)
VALUES (26,18) ";
+
+$_DATA[] = "INSERT INTO {$_TABLES['blocks']} (bid, is_enabled, name, type,
title, tid, blockorder, content, rdfurl, rdfupdated, onleft, phpblockfn,
group_id, owner_id, perm_owner, perm_group, perm_members, perm_anon) VALUES
(1,1,'user_block','gldefault','User Functions','all',2,'','','0000-00-00
00:00:00',1,'',4,2,3,3,2,2) ";
+$_DATA[] = "INSERT INTO {$_TABLES['blocks']} (bid, is_enabled, name, type,
title, tid, blockorder, content, rdfurl, rdfupdated, onleft, phpblockfn,
group_id, owner_id, perm_owner, perm_group, perm_members, perm_anon) VALUES
(2,1,'admin_block','gldefault','Admins Only','all',1,'','','0000-00-00
00:00:00',1,'',4,2,3,3,2,2) ";
+$_DATA[] = "INSERT INTO {$_TABLES['blocks']} (bid, is_enabled, name, type,
title, tid, blockorder, content, rdfurl, rdfupdated, onleft, phpblockfn,
group_id, owner_id, perm_owner, perm_group, perm_members, perm_anon) VALUES
(3,1,'section_block','gldefault','Topics','all',0,'','','0000-00-00
00:00:00',1,'',4,2,3,3,2,2) ";
+$_DATA[] = "INSERT INTO {$_TABLES['blocks']} (bid, is_enabled, name, type,
title, tid, blockorder, content, rdfurl, rdfupdated, onleft, phpblockfn,
group_id, owner_id, perm_owner, perm_group, perm_members, perm_anon) VALUES
(4,1,'polls_block','phpblock','Poll','all',2,'','','0000-00-00
00:00:00',0,'phpblock_polls',4,2,3,3,2,2) ";
+$_DATA[] = "INSERT INTO {$_TABLES['blocks']} (bid, is_enabled, name, type,
title, tid, blockorder, content, rdfurl, rdfupdated, onleft, phpblockfn,
group_id, owner_id, perm_owner, perm_group, perm_members, perm_anon) VALUES
(5,1,'events_block','phpblock','Events','all',4,'','','0000-00-00
00:00:00',1,'phpblock_calendar',4,2,3,3,2,2) ";
+$_DATA[] = "INSERT INTO {$_TABLES['blocks']} (bid, is_enabled, name, type,
title, tid, blockorder, content, rdfurl, rdfupdated, onleft, phpblockfn,
group_id, owner_id, perm_owner, perm_group, perm_members, perm_anon) VALUES
(6,1,'whats_new_block','gldefault','What\'s New','all',3,'','','0000-00-00
00:00:00',0,'',4,2,3,3,2,2) ";
+$_DATA[] = "INSERT INTO {$_TABLES['blocks']} (bid, is_enabled, name, type,
title, tid, blockorder, content, rdfurl, rdfupdated, onleft, phpblockfn,
group_id, owner_id, perm_owner, perm_group, perm_members, perm_anon) VALUES
(7,1,'first_block','normal','About Geeklog','homeonly',1,'<p><b>Welcome to
Geeklog!</b></p><p>If you\'re already familiar with Geeklog - and
especially if you\'re not: There have been many improvements to Geeklog
since earlier versions that you might want to read up on. Please read the
<a href=\"docs/changes.html\">release notes</a>. If you need help, please
see the <a href=\"docs/support.html\">support
options</a>.</p>','','0000-00-00 00:00:00',0,'',4,2,3,3,2,2) ";
+$_DATA[] = "INSERT INTO {$_TABLES['blocks']} (bid, is_enabled, name, type,
title, tid, blockorder, content, rdfurl, rdfupdated, onleft, phpblockfn,
group_id, owner_id, perm_owner, perm_group, perm_members, perm_anon) VALUES
(8,1,'whosonline_block','phpblock','Who\'s
Online','all',0,'','','0000-00-00
00:00:00',0,'phpblock_whosonline',4,2,3,3,2,2) ";
+$_DATA[] = "INSERT INTO {$_TABLES['blocks']} (bid, is_enabled, name, type,
title, tid, blockorder, content, rdfurl, rdfupdated, onleft, phpblockfn,
group_id, owner_id, perm_owner, perm_group, perm_members, perm_anon) VALUES
(9,1,'older_stories','gldefault','Older Stories','all',5,'','','0000-00-00
00:00:00',1,'',4,2,3,3,2,2) ";
+
+$_DATA[] = "INSERT INTO {$_TABLES['commentcodes']} (code, name) VALUES
(0,'Comments Enabled') ";
+$_DATA[] = "INSERT INTO {$_TABLES['commentcodes']} (code, name) VALUES
(-1,'Comments Disabled') ";
+$_DATA[] = "INSERT INTO {$_TABLES['commentcodes']} (code, name) VALUES
(1,'Comments Closed') ";
+
+$_DATA[] = "INSERT INTO {$_TABLES['commentmodes']} (mode, name) VALUES
('flat','Flat') ";
+$_DATA[] = "INSERT INTO {$_TABLES['commentmodes']} (mode, name) VALUES
('nested','Nested') ";
+$_DATA[] = "INSERT INTO {$_TABLES['commentmodes']} (mode, name) VALUES
('threaded','Threaded') ";
+$_DATA[] = "INSERT INTO {$_TABLES['commentmodes']} (mode, name) VALUES
('nocomment','No Comments') ";
+
+$_DATA[] = "INSERT INTO {$_TABLES['cookiecodes']} (cc_value, cc_descr)
VALUES (0,'(don\'t)') ";
+$_DATA[] = "INSERT INTO {$_TABLES['cookiecodes']} (cc_value, cc_descr)
VALUES (3600,'1 Hour') ";
+$_DATA[] = "INSERT INTO {$_TABLES['cookiecodes']} (cc_value, cc_descr)
VALUES (7200,'2 Hours') ";
+$_DATA[] = "INSERT INTO {$_TABLES['cookiecodes']} (cc_value, cc_descr)
VALUES (10800,'3 Hours') ";
+$_DATA[] = "INSERT INTO {$_TABLES['cookiecodes']} (cc_value, cc_descr)
VALUES (28800,'8 Hours') ";
+$_DATA[] = "INSERT INTO {$_TABLES['cookiecodes']} (cc_value, cc_descr)
VALUES (86400,'1 Day') ";
+$_DATA[] = "INSERT INTO {$_TABLES['cookiecodes']} (cc_value, cc_descr)
VALUES (604800,'1 Week') ";
+$_DATA[] = "INSERT INTO {$_TABLES['cookiecodes']} (cc_value, cc_descr)
VALUES (2678400,'1 Month') ";
+
+$_DATA[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format,
description) VALUES (0,'','System Default') ";
+$_DATA[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format,
description) VALUES (1,'%A %B %d, %Y @%I:%M%p','Sunday March 21, 1999
@10:00PM') ";
+$_DATA[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format,
description) VALUES (2,'%A %b %d, %Y @%H:%M','Sunday March 21, 1999
@22:00') ";
+$_DATA[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format,
description) VALUES (4,'%A %b %d @%H:%M','Sunday March 21 @22:00') ";
+$_DATA[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format,
description) VALUES (5,'%H:%M %d %B %Y','22:00 21 March 1999') ";
+$_DATA[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format,
description) VALUES (6,'%H:%M %A %d %B %Y','22:00 Sunday 21 March 1999') ";
+$_DATA[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format,
description) VALUES (7,'%I:%M%p - %A %B %d %Y','10:00PM -- Sunday March 21
1999') ";
+$_DATA[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format,
description) VALUES (8,'%a %B %d, %I:%M%p','Sun March 21, 10:00PM') ";
+$_DATA[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format,
description) VALUES (9,'%a %B %d, %H:%M','Sun March 21, 22:00') ";
+$_DATA[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format,
description) VALUES (10,'%m-%d-%y %H:%M','3-21-99 22:00') ";
+$_DATA[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format,
description) VALUES (11,'%d-%m-%y %H:%M','21-3-99 22:00') ";
+$_DATA[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format,
description) VALUES (12,'%m-%d-%y %I:%M%p','3-21-99 10:00PM') ";
+$_DATA[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format,
description) VALUES (13,'%I:%M%p %B %D, %Y','10:00PM March 21st, 1999') ";
+$_DATA[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format,
description) VALUES (14,'%a %b %d, \'%y %I:%M%p','Sun Mar 21, \'99
10:00PM') ";
+$_DATA[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format,
description) VALUES (15,'Day %j, %I ish','Day 80, 10 ish') ";
+$_DATA[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format,
description) VALUES (16,'%y-%m-%d %I:%M','99-03-21 10:00') ";
+$_DATA[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format,
description) VALUES (17,'%d/%m/%y %H:%M','21/03/99 22:00') ";
+$_DATA[] = "INSERT INTO {$_TABLES['dateformats']} (dfid, format,
description) VALUES (18,'%a %d %b %I:%M%p','Sun 21 Mar 10:00PM') ";
+
+$_DATA[] = "INSERT INTO {$_TABLES['eventsubmission']} (eid, title,
description, location, datestart, dateend, url, allday, zipcode, state,
city, address2, address1, event_type, timestart, timeend) VALUES
('2006051410130162','Geeklog installed','Today, you successfully installed
this Geeklog site.','Your
webserver',CURDATE(),CURDATE(),'http://www.geeklog.net/',1,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL) ";
+
+$_DATA[] = "INSERT INTO {$_TABLES['featurecodes']} (code, name) VALUES
(0,'Not Featured') ";
+$_DATA[] = "INSERT INTO {$_TABLES['featurecodes']} (code, name) VALUES
(1,'Featured') ";
+
+$_DATA[] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr,
ft_gl_core) VALUES (1,'story.edit','Access to story editor',1) ";
+$_DATA[] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr,
ft_gl_core) VALUES (2,'story.moderate','Ability to moderate pending
stories',1) ";
+$_DATA[] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr,
ft_gl_core) VALUES (3,'links.moderate','Ability to moderate pending
links',0) ";
+$_DATA[] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr,
ft_gl_core) VALUES (4,'links.edit','Access to links editor',0) ";
+$_DATA[] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr,
ft_gl_core) VALUES (5,'user.edit','Access to user editor',1) ";
+$_DATA[] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr,
ft_gl_core) VALUES (6,'user.delete','Ability to delete a user',1) ";
+$_DATA[] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr,
ft_gl_core) VALUES (7,'user.mail','Ability to send email to members',1) ";
+$_DATA[] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr,
ft_gl_core) VALUES (8,'calendar.moderate','Ability to moderate pending
events',1) ";
+$_DATA[] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr,
ft_gl_core) VALUES (9,'calendar.edit','Access to event editor',1) ";
+$_DATA[] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr,
ft_gl_core) VALUES (10,'block.edit','Access to block editor',1) ";
+$_DATA[] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr,
ft_gl_core) VALUES (11,'topic.edit','Access to topic editor',1) ";
+$_DATA[] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr,
ft_gl_core) VALUES (12,'polls.edit','Access to polls editor',0) ";
+$_DATA[] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr,
ft_gl_core) VALUES (13,'plugin.edit','Access to plugin editor',1) ";
+$_DATA[] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr,
ft_gl_core) VALUES (14,'group.edit','Ability to edit groups',1) ";
+$_DATA[] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr,
ft_gl_core) VALUES (15,'group.delete','Ability to delete groups',1) ";
+$_DATA[] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr,
ft_gl_core) VALUES (16,'block.delete','Ability to delete a block',1) ";
+$_DATA[] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr,
ft_gl_core) VALUES (17,'staticpages.edit','Ability to edit a static
page',0) ";
+$_DATA[] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr,
ft_gl_core) VALUES (18,'staticpages.delete','Ability to delete static
pages',0) ";
+$_DATA[] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr,
ft_gl_core) VALUES (19,'story.submit','May skip the story submission
queue',1) ";
+$_DATA[] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr,
ft_gl_core) VALUES (20,'links.submit','May skip the links submission
queue',0) ";
+$_DATA[] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr,
ft_gl_core) VALUES (21,'calendar.submit','May skip the event submission
queue',1) ";
+$_DATA[] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr,
ft_gl_core) VALUES (22,'staticpages.PHP','Ability to use PHP in static
pages',0) ";
+$_DATA[] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr,
ft_gl_core) VALUES (23,'spamx.admin', 'Full access to Spam-X plugin', 0) ";
+$_DATA[] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr,
ft_gl_core) VALUES (24,'story.ping', 'Ability to send pings, pingbacks, or
trackbacks for stories', 1) ";
+$_DATA[] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr,
ft_gl_core) VALUES (25,'syndication.edit', 'Access to Content Syndication',
1) ";
+$_DATA[] = "INSERT INTO {$_TABLES['features']} (ft_id, ft_name, ft_descr,
ft_gl_core) VALUES (26,'webservices.atompub', 'May use Atompub Webservices
(if restricted)', 1) ";
+
+$_DATA[] = "INSERT INTO {$_TABLES['frontpagecodes']} (code, name) VALUES
(0,'Show Only in Topic') ";
+$_DATA[] = "INSERT INTO {$_TABLES['frontpagecodes']} (code, name) VALUES
(1,'Show on Front Page') ";
+
+$_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (2,1,NULL) ";
+$_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (2,NULL,1) ";
+$_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (3,NULL,1) ";
+$_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (4,NULL,1) ";
+$_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (5,NULL,1) ";
+$_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (6,NULL,1) ";
+$_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (7,NULL,1) ";
+$_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (8,NULL,1) ";
+$_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (9,NULL,1) ";
+$_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (10,NULL,1) ";
+$_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (11,NULL,1) ";
+$_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (13,2,NULL) ";
+$_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (12,2,NULL) ";
+$_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (11,2,NULL) ";
+$_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (2,NULL,12) ";
+$_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (2,NULL,10) ";
+$_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (2,NULL,9) ";
+$_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (2,NULL,8) ";
+$_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (2,NULL,7) ";
+$_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (2,NULL,6) ";
+$_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (2,NULL,5) ";
+$_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (2,NULL,4) ";
+$_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (2,NULL,3) ";
+$_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (12,NULL,1) ";
+$_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (9,NULL,11) ";
+$_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (2,NULL,11) ";
+$_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (10,2,NULL) ";
+$_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (9,2,NULL) ";
+$_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (8,2,NULL) ";
+$_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (7,2,NULL) ";
+$_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (6,2,NULL) ";
+$_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (5,2,NULL) ";
+$_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (4,2,NULL) ";
+$_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (3,2,NULL) ";
+$_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (2,2,NULL) ";
+$_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (1,2,NULL) ";
+$_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (14,NULL,1) ";
+$_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (15,NULL,1) ";
+$_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (17,NULL,1) ";
+$_DATA[] = "INSERT INTO {$_TABLES['group_assignments']} (ug_main_grp_id,
ug_uid, ug_grp_id) VALUES (18,NULL,1) ";
+
+$_DATA[] = "INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr,
grp_gl_core) VALUES (1,'Root','Has full access to the site',1) ";
+$_DATA[] = "INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr,
grp_gl_core) VALUES (2,'All Users','Group that a typical user is added
to',1) ";
+$_DATA[] = "INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr,
grp_gl_core) VALUES (3,'Story Admin','Has full access to story
features',1) ";
+$_DATA[] = "INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr,
grp_gl_core) VALUES (4,'Block Admin','Has full access to block
features',1) ";
+$_DATA[] = "INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr,
grp_gl_core) VALUES (5,'Links Admin','Has full access to links
features',0) ";
+$_DATA[] = "INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr,
grp_gl_core) VALUES (6,'Topic Admin','Has full access to topic
features',1) ";
+$_DATA[] = "INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr,
grp_gl_core) VALUES (7,'Calendar Admin','Has full access to calendar
features',0) ";
+$_DATA[] = "INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr,
grp_gl_core) VALUES (8,'Polls Admin','Has full access to polls
features',0) ";
+$_DATA[] = "INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr,
grp_gl_core) VALUES (9,'User Admin','Has full access to user features',1) ";
+$_DATA[] = "INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr,
grp_gl_core) VALUES (10,'Plugin Admin','Has full access to plugin
features',1) ";
+$_DATA[] = "INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr,
grp_gl_core) VALUES (11,'Group Admin','Is a User Admin with access to
groups, too',1) ";
+$_DATA[] = "INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr,
grp_gl_core) VALUES (12,'Mail Admin','Can use Mail Utility',1) ";
+$_DATA[] = "INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr,
grp_gl_core) VALUES (13,'Logged-in Users','All registered members',1) ";
+$_DATA[] = "INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr,
grp_gl_core) VALUES (14,'Static Page Admin','Can administer static
pages',0) ";
+$_DATA[] = "INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr,
grp_gl_core) VALUES (15,'spamx Admin', 'Users in this group can administer
the Spam-X plugin',0) ";
+$_DATA[] = "INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr,
grp_gl_core) VALUES (16,'Remote Users', 'Users in this group can have
authenticated against a remote server.',1) ";
+$_DATA[] = "INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr,
grp_gl_core) VALUES (17,'Syndication Admin', 'Can create and modify web
feeds for the site',1) ";
+$_DATA[] = "INSERT INTO {$_TABLES['groups']} (grp_id, grp_name, grp_descr,
grp_gl_core) VALUES (18,'Webservices Users', 'Can use the Webservices API
(if restricted)',0) ";
+
+$_DATA[] = "INSERT INTO {$_TABLES['linkcategories']} (cid, pid, category,
description, tid, created, modified, owner_id, group_id, perm_owner,
perm_group, perm_members, perm_anon) VALUES
('site', 'root', 'Root', 'Website root', NULL, NOW(), NOW(), 2, 5, 3, 3, 2,
2);";
+$_DATA[] = "INSERT INTO {$_TABLES['linkcategories']} (cid, pid, category,
description, tid, created, modified, owner_id, group_id, perm_owner,
perm_group, perm_members, perm_anon) VALUES
('geeklog-sites', 'site', 'Geeklog Sites', 'Sites using or related to the
Geeklog CMS', NULL, NOW(), NOW(), 2, 5, 3, 3, 2, 2);";
+$_DATA[] = "INSERT INTO {$_TABLES['links']} (lid, cid, url, description,
title, hits, date, owner_id, group_id, perm_owner, perm_group,
perm_members, perm_anon) VALUES
('geeklog.net', 'geeklog-sites', 'http://www.geeklog.net/', 'Visit the
Geeklog homepage for support, FAQs, updates, add-ons, and a great
community.', 'Geeklog Project Homepage', 123, NOW(), 1, 5, 3, 3, 2, 2);";
+
+$_DATA[] = "INSERT INTO {$_TABLES['maillist']} (code, name) VALUES
(0,'Don\'t Email') ";
+$_DATA[] = "INSERT INTO {$_TABLES['maillist']} (code, name) VALUES
(1,'Email Headlines Each Night') ";
+
+$_DATA[] = "INSERT INTO {$_TABLES['pingservice']} (pid, name, site_url,
ping_url, method, is_enabled) VALUES
(1, 'Ping-O-Matic', 'http://pingomatic.com/', 'http://rpc.pingomatic.com/', 'weblogUpdates.ping',
1)";
+
+$_DATA[] = "INSERT INTO {$_TABLES['plugins']} (pi_name, pi_version,
pi_gl_version, pi_enabled, pi_homepage) VALUES
('staticpages', '1.5.1','1.5.0',1,'http://www.geeklog.net/') ";
+$_DATA[] = "INSERT INTO {$_TABLES['plugins']} (pi_name, pi_version,
pi_gl_version, pi_enabled, pi_homepage) VALUES
('spamx', '1.1.2','1.5.0',1,'http://www.pigstye.net/gplugs/staticpages/index.php/spamx') ";
+$_DATA[] = "INSERT INTO {$_TABLES['plugins']} (pi_name, pi_version,
pi_gl_version, pi_enabled, pi_homepage) VALUES ('links', '2.0.1', '1.5.0',
1, 'http://www.geeklog.net/')";
+$_DATA[] = "INSERT INTO {$_TABLES['plugins']} (pi_name, pi_version,
pi_gl_version, pi_enabled, pi_homepage) VALUES
('polls', '2.0.2', '1.5.0', '1', 'http://www.geeklog.net/')";
+$_DATA[] = "INSERT INTO {$_TABLES['plugins']} (pi_name, pi_version,
pi_gl_version, pi_enabled, pi_homepage) VALUES
('calendar', '1.0.3', '1.5.0', '1', 'http://www.geeklog.net/')";
+
+$_DATA[] = "INSERT INTO `{$_TABLES['pollanswers']}` (`pid`, `qid`, `aid`,
`answer`, `votes`, `remark`) VALUES ('geeklogfeaturepoll', 0, 1, 'MS SQL
support', 0, '');";
+$_DATA[] = "INSERT INTO `{$_TABLES['pollanswers']}` (`pid`, `qid`, `aid`,
`answer`, `votes`, `remark`) VALUES ('geeklogfeaturepoll', 0,
2, 'Multi-language support', 0, '');";
+$_DATA[] = "INSERT INTO `{$_TABLES['pollanswers']}` (`pid`, `qid`, `aid`,
`answer`, `votes`, `remark`) VALUES ('geeklogfeaturepoll', 0, 3, 'Calendar
as a plugin', 0, '');";
+$_DATA[] = "INSERT INTO `{$_TABLES['pollanswers']}` (`pid`, `qid`, `aid`,
`answer`, `votes`, `remark`) VALUES ('geeklogfeaturepoll', 0, 4, 'SLV spam
protection', 0, '');";
+$_DATA[] = "INSERT INTO `{$_TABLES['pollanswers']}` (`pid`, `qid`, `aid`,
`answer`, `votes`, `remark`) VALUES ('geeklogfeaturepoll', 0,
5, 'Mass-delete users', 0, '');";
+$_DATA[] = "INSERT INTO `{$_TABLES['pollanswers']}` (`pid`, `qid`, `aid`,
`answer`, `votes`, `remark`) VALUES ('geeklogfeaturepoll', 0, 6, 'Other',
0, '');";
+$_DATA[] = "INSERT INTO `{$_TABLES['pollanswers']}` (`pid`, `qid`, `aid`,
`answer`, `votes`, `remark`) VALUES ('geeklogfeaturepoll', 1,
1, 'Story-Images', 0, '');";
+$_DATA[] = "INSERT INTO `{$_TABLES['pollanswers']}` (`pid`, `qid`, `aid`,
`answer`, `votes`, `remark`) VALUES ('geeklogfeaturepoll', 1,
2, 'User-Rights handling', 0, '');";
+$_DATA[] = "INSERT INTO `{$_TABLES['pollanswers']}` (`pid`, `qid`, `aid`,
`answer`, `votes`, `remark`) VALUES ('geeklogfeaturepoll', 1, 3, 'The
Support', 0, '');";
+$_DATA[] = "INSERT INTO `{$_TABLES['pollanswers']}` (`pid`, `qid`, `aid`,
`answer`, `votes`, `remark`) VALUES ('geeklogfeaturepoll', 1, 4, 'Plugin
Availability', 0, '');";
+
+$_DATA[] = "INSERT INTO `{$_TABLES['pollquestions']}` (`pid`, `qid`,
`question`) VALUES ('geeklogfeaturepoll', 0, 'What is the best new feature
of Geeklog?');";
+$_DATA[] = "INSERT INTO `{$_TABLES['pollquestions']}` (`pid`, `qid`,
`question`) VALUES ('geeklogfeaturepoll', 1, 'What is the all-time best
feature of Geeklog?');";
+
+$_DATA[] = "INSERT INTO `{$_TABLES['polltopics']}` (`pid`, `topic`,
`voters`, `questions`, `date`, `display`, `is_open`, `hideresults`,
`commentcode`, `statuscode`, `owner_id`, `group_id`, `perm_owner`,
`perm_group`, `perm_members`, `perm_anon`) VALUES
('geeklogfeaturepoll', 'Tell us your opinion about Geeklog', 0,
2, '2007-01-16 12:24:22', 1, 1, 1, 0, 0, 2, 8, 3, 2, 2, 2);";
+
+$_DATA[] = "INSERT INTO {$_TABLES['postmodes']} (code, name) VALUES
('plaintext','Plain Old Text') ";
+$_DATA[] = "INSERT INTO {$_TABLES['postmodes']} (code, name) VALUES
('html','HTML Formatted') ";
+
+$_DATA[] = "INSERT INTO {$_TABLES['sortcodes']} (code, name) VALUES
('ASC','Oldest First') ";
+$_DATA[] = "INSERT INTO {$_TABLES['sortcodes']} (code, name) VALUES
('DESC','Newest First') ";
+
+$_DATA[] = "INSERT INTO {$_TABLES['statuscodes']} (code, name) VALUES
(1,'Refreshing') ";
+$_DATA[] = "INSERT INTO {$_TABLES['statuscodes']} (code, name) VALUES
(0,'Normal') ";
+$_DATA[] = "INSERT INTO {$_TABLES['statuscodes']} (code, name) VALUES
(10,'Archive') ";
+
+$_DATA[] = "INSERT INTO {$_TABLES['stories']} (sid, uid, draft_flag, tid,
date, title, introtext, bodytext, hits, numemails, comments, related,
featured, commentcode, statuscode, postmode, frontpage, owner_id, group_id,
perm_owner, perm_group, perm_members, perm_anon) VALUES
('welcome',2,0,'Geeklog',NOW(),'Welcome to Geeklog!','<p>Welcome and let me
be the first to congratulate you on installing Geeklog. Please take the
time to read everything in the <a href=\"docs/index.html\">docs
directory</a>. Geeklog now has enhanced, user-based security. You should
thoroughly understand how these work before you run a production Geeklog
Site.</p>\r<p>To log into your new Geeklog site, please use this
account:</p>\r<p>Username: <b>Admin</b><br />\rPassword:
<b>password</b></p><p><b>And don\'t forget to <a
href=\"usersettings.php\">change your password</a> after logging
in!</b></p>','',100,1,0,'',1,0,0,'html',1,2,3,3,2,2,2) ";
+
+$_DATA[] = "INSERT INTO {$_TABLES['storysubmission']} (sid, uid, tid,
title, introtext, date, postmode) VALUES
('security-reminder',2,'Geeklog','Are you secure?','<p>This is a reminder
to secure your site once you have Geeklog up and running. What you should
do:</p>\r\r<ol>\r<li>Change the default password for the Admin
account.</li>\r<li>Remove the install directory (you won\'t need it any
more).</li>\r</ol>',NOW(),'html') ";
+
+$_DATA[] = "INSERT INTO {$_TABLES['syndication']} (type, topic,
header_tid, format, limits, content_length, title, description, filename,
charset, language, is_enabled, updated, update_info) VALUES
('article', '::all', 'all', 'RSS-2.0', 10, 1, 'Geeklog Site', 'Another
Nifty Geeklog Site', 'geeklog.rss', 'iso-8859-1', 'en-gb', 1, '0000-00-00
00:00:00', NULL)";
+
+$_DATA[] = "INSERT INTO {$_TABLES['topics']} (tid, topic, imageurl,
sortnum, limitnews, group_id, owner_id, perm_owner, perm_group,
perm_members, perm_anon) VALUES ('General','General
News','/images/topics/topic_news.gif',1,10,6,2,3,2,2,2)";
+$_DATA[] = "INSERT INTO {$_TABLES['topics']} (tid, topic, imageurl,
sortnum, limitnews, group_id, owner_id, perm_owner, perm_group,
perm_members, perm_anon) VALUES
('Geeklog','Geeklog','/images/topics/topic_gl.gif',2,10,6,2,3,2,2,2)";
+
+$_DATA[] = "INSERT INTO {$_TABLES['usercomment']} (uid, commentmode,
commentorder, commentlimit) VALUES (1,'nested','ASC',100) ";
+$_DATA[] = "INSERT INTO {$_TABLES['usercomment']} (uid, commentmode,
commentorder, commentlimit) VALUES (2,'threaded','ASC',100) ";
+
+$_DATA[] = "INSERT INTO {$_TABLES['userindex']} (uid, tids, etids, aids,
boxes, noboxes, maxstories) VALUES (1,'','-','','',0,NULL) ";
+$_DATA[] = "INSERT INTO {$_TABLES['userindex']} (uid, tids, etids, aids,
boxes, noboxes, maxstories) VALUES (2,'','','','',0,NULL) ";
+
+$_DATA[] = "INSERT INTO {$_TABLES['userinfo']} (uid, about, pgpkey,
userspace, tokens, totalcomments, lastgranted) VALUES
(1,NULL,NULL,'',0,0,0) ";
+$_DATA[] = "INSERT INTO {$_TABLES['userinfo']} (uid, about, pgpkey,
userspace, tokens, totalcomments, lastgranted) VALUES
(2,NULL,NULL,'',0,0,0) ";
+
+$_DATA[] = "INSERT INTO {$_TABLES['userprefs']} (uid, noicons, willing,
dfid, tzid, emailstories) VALUES (1,0,0,0,'',0) ";
+$_DATA[] = "INSERT INTO {$_TABLES['userprefs']} (uid, noicons, willing,
dfid, tzid, emailstories) VALUES (2,0,1,0,'',1) ";
+
+#
+# Dumping data for table 'users'
+#
+
+$_DATA[] = "INSERT INTO {$_TABLES['users']} (uid, username, fullname,
passwd, email, homepage, sig, regdate, cookietimeout, theme, status) VALUES
(1,'Anonymous','Anonymous','',NULL,NULL,'',NOW(),0,NULL,3) ";
+$_DATA[] = "INSERT INTO {$_TABLES['users']} (uid, username, fullname,
passwd, email, homepage, sig, regdate, cookietimeout, theme, status) VALUES
(2,'Admin','Geeklog
SuperUser','5f4dcc3b5aa765d61d8327deb882cf99','root ＠ localhost','http://www.geeklog.net/','',NOW(),28800,NULL,3) ";
+
+$_DATA[] = "INSERT INTO {$_TABLES['vars']} (name, value) VALUES
('totalhits','0') ";
+$_DATA[] = "INSERT INTO {$_TABLES['vars']} (name, value) VALUES
('lastemailedstories','') ";
+$_DATA[] = "INSERT INTO {$_TABLES['vars']} (name, value) VALUES
('last_scheduled_run','') ";
+$_DATA[] = "INSERT INTO {$_TABLES['vars']} (name, value) VALUES
('spamx.counter','0') ";
+$_DATA[] = "INSERT INTO {$_TABLES['vars']} (name, value) VALUES
('database_version','1.5.1') ";
+
+$_DATA[] = "INSERT INTO {$_TABLES['trackbackcodes']} (code, name) VALUES
(0,'Trackback Enabled') ";
+$_DATA[] = "INSERT INTO {$_TABLES['trackbackcodes']} (code, name) VALUES
(-1,'Trackback Disabled') ";
+
+?>
Added: externals/geeklog-1.5.2sr2/sql/updates/0.1_to_0.2.sql
==============================================================================
--- (empty file)
+++ externals/geeklog-1.5.2sr2/sql/updates/0.1_to_0.2.sql Sun Apr 5
17:41:59 2009
@@ -0,0 +1,5 @@
+ALTER TABLE links MODIFY description text;
+ALTER TABLE stories MODIFY sid varchar(20) DEFAULT '' NOT NULL;
+ALTER TABLE comments MODIFY sid varchar(20) DEFAULT '' NOT NULL;
+ALTER TABLE blocks ADD COLUMN blockorder tinyint unsigned DEFAULT 1 NOT
NULL;
+UPDATE blocks SET blockorder = 1;
Added: externals/geeklog-1.5.2sr2/sql/updates/0.2_to_0.3.sql
==============================================================================
--- (empty file)
+++ externals/geeklog-1.5.2sr2/sql/updates/0.2_to_0.3.sql Sun Apr 5
17:41:59 2009
@@ -0,0 +1,13 @@
+CREATE TABLE calendar (
+ eid varchar(20) DEFAULT '' NOT NULL,
+ title varchar(128),
+ description text,
+ location text,
+ datestart date,
+ dateend date,
+ url varchar(128),
+ PRIMARY KEY (eid)
+);
+
+ALTER TABLE blocks ADD COLUMN rdfupdated datetime DEFAULT '0000-00-00
00:00:00' NOT NULL;
+UPDATE blocks SET rdfupdated = '0000-00-00 00:00:00';
Added: externals/geeklog-1.5.2sr2/sql/updates/0.3_to_0.4.sql
==============================================================================
--- (empty file)
+++ externals/geeklog-1.5.2sr2/sql/updates/0.3_to_0.4.sql Sun Apr 5
17:41:59 2009
@@ -0,0 +1,32 @@
+ALTER TABLE blocks MODIFY COLUMN bid smallint unsigned DEFAULT '0' NOT
NULL auto_increment;
+ALTER TABLE blocks MODIFY COLUMN tid varchar(20) DEFAULT 'All' NOT NULL;
+
+ALTER TABLE comments MODIFY COLUMN cid int unsigned DEFAULT '0' NOT NULL
auto_increment;
+ALTER TABLE comments ADD COLUMN pid int unsigned;
+
+ALTER TABLE calendar RENAME AS events;
+
+ALTER TABLE pollanswers MODIFY COLUMN qid varchar(20) DEFAULT '' NOT NULL;
+ALTER TABLE pollanswers MODIFY COLUMN aid tinyint unsigned DEFAULT '0' NOT
NULL;
+ALTER TABLE pollanswers MODIFY COLUMN answer varchar(255);
+ALTER TABLE pollanswers MODIFY COLUMN votes mediumint unsigned;
+
+ALTER TABLE pollquestions MODIFY COLUMN qid varchar(20) DEFAULT '' NOT
NULL;
+ALTER TABLE pollquestions MODIFY COLUMN question varchar(255);
+ALTER TABLE pollquestions MODIFY COLUMN voters mediumint unsigned;
+
+CREATE TABLE pollvoters (
+ id int unsigned DEFAULT '0' NOT NULL auto_increment,
+ qid varchar(20) DEFAULT '' NOT NULL,
+ ipaddress char(15) DEFAULT '' NOT NULL,
+ date int unsigned,
+ PRIMARY KEY (id)
+);
+
+ALTER TABLE stories MODIFY COLUMN uid mediumint unsigned DEFAULT '0' NOT
NULL;
+ALTER TABLE stories CHANGE COLUMN content introtext text;
+ALTER TABLE stories ADD COLUMN bodytext text;
+ALTER TABLE stories MODIFY COLUMN hits mediumint unsigned DEFAULT '0' NOT
NULL;
+ALTER TABLE stories ADD COLUMN comments mediumint unsigned DEFAULT '0' NOT
NULL;
+
+ALTER TABLE users MODIFY COLUMN uid mediumint unsigned DEFAULT '0' NOT
NULL auto_increment;
\ No newline at end of file
Added: externals/geeklog-1.5.2sr2/sql/updates/0.4_to_0.5.sql
==============================================================================
--- (empty file)
+++ externals/geeklog-1.5.2sr2/sql/updates/0.4_to_0.5.sql Sun Apr 5
17:41:59 2009
@@ -0,0 +1,8 @@
+ALTER TABLE stories ADD COLUMN related text;
+ALTER TABLE stories ADD COLUMN featured tinyint unsigned NOT NULL default
0;
+
+ALTER TABLE users MODIFY passwd char(32);
+UPDATE users SET passwd = '5f4dcc3b5aa765d61d8327deb882cf99';
+
+ALTER TABLE comments CHANGE subject title varchar(128);
+ALTER TABLE comments MODIFY pid int unsigned NOT NULL default 0;
Added: externals/geeklog-1.5.2sr2/sql/updates/0.5_to_1.0.sql
==============================================================================
--- (empty file)
+++ externals/geeklog-1.5.2sr2/sql/updates/0.5_to_1.0.sql Sun Apr 5
17:41:59 2009
@@ -0,0 +1,78 @@
+ALTER TABLE links MODIFY lid varchar(20) DEFAULT '' NOT NULL;
+ALTER TABLE links MODIFY hits int(11) DEFAULT '0' NOT NULL;
+ALTER TABLE comments ADD uid mediumint(8) DEFAULT '-1' NOT NULL;
+ALTER TABLE comments DROP name;
+ALTER TABLE comments DROP email;
+ALTER TABLE comments DROP url;
+ALTER TABLE stories DROP author;
+ALTER TABLE stories DROP authoremail;
+ALTER TABLE stories DROP authorurl;
+ALTER TABLE stories MODIFY uid mediumint(8) DEFAULT '-1' NOT NULL;
+ALTER TABLE users MODIFY uid mediumint(8) DEFAULT '-1' NOT NULL
auto_increment;
+INSERT INTO users VALUES (-1,'Anonymous','Anonymous',NULL,NULL,NULL,NULL);
+INSERT INTO blocks VALUES
(0,'blockheader','all',255,0,'layout','','0000-00-00 00:00:00','<table
border=0 cellpadding=1 cellspacing=0 width=\"100%\"><tr
bgcolor=666666><td>\r\n<table width=\"100%\" border=0 cellspacing=0
cellpadding=2>\r\n<tr bgcolor=666666><td class=blocktitle>%title</td><td
align=right>%help</td></tr>\r\n<tr><td bgcolor=FFFFFF colspan=2>');
+INSERT INTO blocks VALUES
(0,'blockfooter','all',255,0,'layout','','0000-00-00
00:00:00','</td></tr></table>\r\n</td></tr></table><br>');
+
+CREATE TABLE eventsubmission (
+ eid varchar(20) DEFAULT '' NOT NULL,
+ title varchar(128),
+ description text,
+ location text,
+ datestart date,
+ dateend date,
+ url varchar(128),
+ PRIMARY KEY (eid)
+);
+
+CREATE TABLE linksubmission (
+ lid varchar(20) DEFAULT '' NOT NULL,
+ category varchar(32),
+ url varchar(96),
+ description text,
+ title varchar(96),
+ hits int(11),
+ PRIMARY KEY (lid)
+);
+
+CREATE TABLE storysubmission (
+ sid varchar(20) DEFAULT '' NOT NULL,
+ uid mediumint(8) DEFAULT '-1' NOT NULL,
+ tid varchar(20) DEFAULT 'General' NOT NULL,
+ title varchar(128),
+ introtext text,
+ date datetime,
+ PRIMARY KEY (sid)
+);
+
+CREATE TABLE vars (
+ name varchar(20) DEFAULT '' NOT NULL,
+ value varchar(128),
+ PRIMARY KEY (name)
+);
+
+CREATE TABLE userinfo (
+ uid mediumint(8) unsigned DEFAULT '0' NOT NULL,
+ about text,
+ pgpkey text,
+ PRIMARY KEY (uid)
+);
+
+CREATE TABLE userprefs (
+ uid mediumint(8) unsigned DEFAULT '0' NOT NULL,
+ emailstories tinyint(3),
+ PRIMARY KEY (uid)
+);
+
+CREATE TABLE submitspeedlimit (
+ id int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
+ ipaddress varchar(15) DEFAULT '' NOT NULL,
+ date int(10) unsigned,
+ PRIMARY KEY (id)
+);
+
+CREATE TABLE commentspeedlimit (
+ id int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
+ ipaddress varchar(15) DEFAULT '' NOT NULL,
+ date int(10) unsigned,
+ PRIMARY KEY (id)
+);
\ No newline at end of file
Added: externals/geeklog-1.5.2sr2/sql/updates/1.0_to_1.1.sql
==============================================================================
--- (empty file)
+++ externals/geeklog-1.5.2sr2/sql/updates/1.0_to_1.1.sql Sun Apr 5
17:41:59 2009
@@ -0,0 +1,209 @@
+ALTER TABLE userinfo MODIFY uid mediumint DEFAULT '-1' NOT NULL;
+ALTER TABLE userinfo ADD userspace varchar(255) DEFAULT '' NOT NULL;
+ALTER TABLE userinfo ADD tokens tinyint unsigned DEFAULT '0' NOT NULL;
+ALTER TABLE userinfo ADD totalcomments mediumint DEFAULT '0' NOT NULL;
+ALTER TABLE userinfo ADD lastgranted int unsigned DEFAULT '0' NOT NULL;
+ALTER TABLE userprefs DROP emailstories;
+ALTER TABLE userprefs MODIFY uid mediumint DEFAULT '-1' NOT NULL;
+ALTER TABLE userprefs ADD emailstories tinyint DEFAULT '1' NOT NULL;
+ALTER TABLE userprefs ADD noicons tinyint unsigned DEFAULT '0' NOT NULL;
+ALTER TABLE userprefs ADD willing tinyint unsigned DEFAULT '1' NOT NULL;
+ALTER TABLE userprefs ADD dfid tinyint unsigned DEFAULT '0' NOT NULL;
+ALTER TABLE userprefs ADD tzid char(3) DEFAULT 'edt' NOT NULL;
+ALTER TABLE users ADD sig varchar(160) DEFAULT '' NOT NULL;
+ALTER TABLE users MODIFY passwd char(32) DEFAULT '' NOT NULL;
+ALTER TABLE users MODIFY seclev tinyint DEFAULT 0 NOT NULL;
+ALTER TABLE users MODIFY username varchar(16) DEFAULT '' NOT NULL;
+ALTER TABLE users ADD INDEX LOGIN (uid,passwd,username);
+ALTER TABLE stories ADD commentcode tinyint DEFAULT '0' NOT NULL;
+ALTER TABLE stories ADD statuscode tinyint DEFAULT '0' NOT NULL;
+ALTER TABLE stories ADD postmode char(10) DEFAULT 'html' NOT NULL;
+ALTER TABLE storysubmission ADD postmode char(10) DEFAULT 'html' NOT NULL;
+ALTER TABLE pollquestions ADD commentcode tinyint DEFAULT '0' NOT NULL;
+ALTER TABLE pollquestions ADD statuscode tinyint DEFAULT '0' NOT NULL;
+
+INSERT INTO vars VALUES ('totalhits','383');
+INSERT INTO userprefs (uid) SELECT (uid) from users;
+INSERT INTO userinfo (uid) SELECT (uid) from users;
+
+CREATE TABLE usercomment (
+ uid mediumint(8) DEFAULT '0' NOT NULL,
+ commentmode varchar(10) DEFAULT 'threaded' NOT NULL,
+ commentorder char(4) DEFAULT 'ASC' NOT NULL,
+ commentlimit mediumint unsigned DEFAULT '100' NOT NULL,
+ PRIMARY KEY (uid)
+);
+
+INSERT INTO usercomment (uid) SELECT (uid) from users;
+
+CREATE TABLE userindex (
+ uid mediumint(8) DEFAULT '0' NOT NULL,
+ tids varchar(255) DEFAULT '' NOT NULL,
+ aids varchar(255) DEFAULT '' NOT NULL,
+ boxes varchar(255) DEFAULT '' NOT NULL,
+ noboxes tinyint DEFAULT '0' NOT NULL,
+ maxstories tinyint DEFAULT '10' NOT NULL,
+ PRIMARY KEY (uid)
+);
+
+INSERT INTO userindex (uid) SELECT (uid) from users;
+
+CREATE TABLE commentcodes (
+ code tinyint DEFAULT '' NOT NULL,
+ name varchar(32),
+ PRIMARY KEY (code)
+);
+
+INSERT INTO commentcodes VALUES (0,'Comments Enabled');
+INSERT INTO commentcodes VALUES (1,'Read-Only');
+INSERT INTO commentcodes VALUES (-1,'Comments Disabled');
+
+CREATE TABLE featurecodes (
+ code tinyint DEFAULT '' NOT NULL,
+ name varchar(32),
+ PRIMARY KEY (code)
+);
+
+INSERT INTO featurecodes VALUES (0,'Not Featured');
+INSERT INTO featurecodes VALUES (1,'Featured');
+
+CREATE TABLE commentmodes (
+ mode varchar(10) DEFAULT '' NOT NULL,
+ name varchar(32),
+ PRIMARY KEY (mode)
+);
+
+INSERT INTO commentmodes VALUES ('flat','Flat');
+INSERT INTO commentmodes VALUES ('nested','Nested');
+INSERT INTO commentmodes VALUES ('threaded','Threaded');
+INSERT INTO commentmodes VALUES ('nocomment','No Comments');
+
+CREATE TABLE dateformats (
+ dfid tinyint DEFAULT '0' NOT NULL,
+ format varchar(32),
+ description varchar(64),
+ PRIMARY KEY (dfid)
+);
+
+INSERT INTO dateformats VALUES (0,'','System Default');
+INSERT INTO dateformats VALUES (1,'%A %B %d, %Y @%I:%M%p','Sunday March
21, 1999 @10:00PM');
+INSERT INTO dateformats VALUES (2,'%A %b %d, %Y @%H:%M','Sunday March 21,
1999 @22:00');
+INSERT INTO dateformats VALUES (3,'%A %B %d @%I:%M%p','Sunday March 21
@10:00PM');
+INSERT INTO dateformats VALUES (4,'%A %b %d @%H:%M','Sunday March 21
@22:00');
+INSERT INTO dateformats VALUES (5,'%H:%M %d %B %Y','22:00 21 March 1999');
+INSERT INTO dateformats VALUES (6,'%H:%M %A %d %B %Y','22:00 Sunday 21
March 1999');
+INSERT INTO dateformats VALUES (7,'%I:%M%p - %A %B %d %Y','10:00PM --
Sunday March 21 1999');
+INSERT INTO dateformats VALUES (8,'%a %B %d, %I:%M%p','Sun March 21,
10:00PM');
+INSERT INTO dateformats VALUES (9,'%a %B %d, %H:%M','Sun March 21, 22:00');
+INSERT INTO dateformats VALUES (10,'%m-%d-%y %H:%M','3-21-99 22:00');
+INSERT INTO dateformats VALUES (11,'%d-%m-%y %H:%M','21-3-99 22:00');
+INSERT INTO dateformats VALUES (12,'%m-%d-%y %I:%M%p','3-21-99 10:00PM');
+INSERT INTO dateformats VALUES (13,'%I:%M%p %B %D, %Y','10:00PM March
21st, 1999');
+INSERT INTO dateformats VALUES (14,'%a %b %d, \'%y %I:%M%p','Sun Mar 21,
\'99 10:00PM');
+INSERT INTO dateformats VALUES (15,'Day %j, %I ish','Day 80, 10 ish');
+INSERT INTO dateformats VALUES (16,'%y-%m-%d %I:%M','99-03-21 10:00');
+INSERT INTO dateformats VALUES (17,'%d/%m/%y %H:%M','21/03/99 22:00');
+INSERT INTO dateformats VALUES (18,'%a %d %b %I:%M%p','Sun 21 Mar
10:00PM');
+
+CREATE TABLE maillist (
+ code int(1) DEFAULT '0' NOT NULL,
+ name char(32),
+ PRIMARY KEY (code)
+);
+
+INSERT INTO maillist VALUES (0,'Don\'t Email');
+INSERT INTO maillist VALUES (1,'Email Headlines Each Night');
+
+CREATE TABLE postmodes (
+ code char(10) DEFAULT '' NOT NULL,
+ name char(32),
+ PRIMARY KEY (code)
+);
+
+INSERT INTO postmodes VALUES ('html','HTML Formatted');
+INSERT INTO postmodes VALUES ('plaintext','Plain Old Text');
+
+CREATE TABLE sortcodes (
+ code char(4) DEFAULT '0' NOT NULL,
+ name char(32),
+ PRIMARY KEY (code)
+);
+
+INSERT INTO sortcodes VALUES ('ASC','Oldest First');
+INSERT INTO sortcodes VALUES ('DESC','Newest First');
+
+CREATE TABLE statuscodes (
+ code int(1) DEFAULT '0' NOT NULL,
+ name char(32),
+ PRIMARY KEY (code)
+);
+
+INSERT INTO statuscodes VALUES (1,'Refreshing');
+INSERT INTO statuscodes VALUES (0,'Normal');
+INSERT INTO statuscodes VALUES (10,'Archive');
+
+CREATE TABLE tzcodes (
+ tz char(3) DEFAULT '' NOT NULL,
+ offset int(1),
+ description varchar(64),
+ PRIMARY KEY (tz)
+);
+
+INSERT INTO tzcodes VALUES ('ndt',-9000,'Newfoundland Daylight');
+INSERT INTO tzcodes VALUES ('adt',-10800,'Atlantic Daylight');
+INSERT INTO tzcodes VALUES ('edt',-14400,'Eastern Daylight');
+INSERT INTO tzcodes VALUES ('cdt',-18000,'Central Daylight');
+INSERT INTO tzcodes VALUES ('mdt',-21600,'Mountain Daylight');
+INSERT INTO tzcodes VALUES ('pdt',-25200,'Pacific Daylight');
+INSERT INTO tzcodes VALUES ('ydt',-28800,'Yukon Daylight');
+INSERT INTO tzcodes VALUES ('hdt',-32400,'Hawaii Daylight');
+INSERT INTO tzcodes VALUES ('bst',3600,'British Summer');
+INSERT INTO tzcodes VALUES ('mes',7200,'Middle European Summer');
+INSERT INTO tzcodes VALUES ('sst',7200,'Swedish Summer');
+INSERT INTO tzcodes VALUES ('fst',7200,'French Summer');
+INSERT INTO tzcodes VALUES ('wad',28800,'West Australian Daylight');
+INSERT INTO tzcodes VALUES ('cad',37800,'Central Australian Daylight');
+INSERT INTO tzcodes VALUES ('ead',39600,'Eastern Australian Daylight');
+INSERT INTO tzcodes VALUES ('nzd',46800,'New Zealand Daylight');
+INSERT INTO tzcodes VALUES ('gmt',0,'Greenwich Mean');
+INSERT INTO tzcodes VALUES ('utc',0,'Universal (Coordinated)');
+INSERT INTO tzcodes VALUES ('wet',0,'Western European');
+INSERT INTO tzcodes VALUES ('wat',-3600,'West Africa');
+INSERT INTO tzcodes VALUES ('at',-7200,'Azores');
+INSERT INTO tzcodes VALUES ('gst',-10800,'Greenland Standard');
+INSERT INTO tzcodes VALUES ('nft',-12600,'Newfoundland');
+INSERT INTO tzcodes VALUES ('nst',-12600,'Newfoundland Standard');
+INSERT INTO tzcodes VALUES ('ast',-14400,'Atlantic Standard');
+INSERT INTO tzcodes VALUES ('est',-18000,'Eastern Standard');
+INSERT INTO tzcodes VALUES ('cst',-21600,'Central Standard');
+INSERT INTO tzcodes VALUES ('mst',-25200,'Mountain Standard');
+INSERT INTO tzcodes VALUES ('pst',-28800,'Pacific Standard');
+INSERT INTO tzcodes VALUES ('yst',-32400,'Yukon Standard');
+INSERT INTO tzcodes VALUES ('hst',-36000,'Hawaii Standard');
+INSERT INTO tzcodes VALUES ('cat',-36000,'Central Alaska');
+INSERT INTO tzcodes VALUES ('ahs',-36000,'Alaska-Hawaii Standard');
+INSERT INTO tzcodes VALUES ('nt',-39600,'Nome');
+INSERT INTO tzcodes VALUES ('idl',-43200,'International Date Line West');
+INSERT INTO tzcodes VALUES ('cet',3600,'Central European');
+INSERT INTO tzcodes VALUES ('met',3600,'Middle European');
+INSERT INTO tzcodes VALUES ('mew',3600,'Middle European Winter');
+INSERT INTO tzcodes VALUES ('swt',3600,'Swedish Winter');
+INSERT INTO tzcodes VALUES ('fwt',3600,'French Winter');
+INSERT INTO tzcodes VALUES ('eet',7200,'Eastern Europe, USSR Zone 1');
+INSERT INTO tzcodes VALUES ('bt',10800,'Baghdad, USSR Zone 2');
+INSERT INTO tzcodes VALUES ('it',12600,'Iran');
+INSERT INTO tzcodes VALUES ('zp4',14400,'USSR Zone 3');
+INSERT INTO tzcodes VALUES ('zp5',18000,'USSR Zone 4');
+INSERT INTO tzcodes VALUES ('ist',19800,'Indian Standard');
+INSERT INTO tzcodes VALUES ('zp6',21600,'USSR Zone 5');
+INSERT INTO tzcodes VALUES ('was',25200,'West Australian Standard');
+INSERT INTO tzcodes VALUES ('jt',27000,'Java (3pm in Cronusland!)');
+INSERT INTO tzcodes VALUES ('cct',28800,'China Coast, USSR Zone 7');
+INSERT INTO tzcodes VALUES ('jst',32400,'Japan Standard, USSR Zone 8');
+INSERT INTO tzcodes VALUES ('cas',34200,'Central Australian Standard');
+INSERT INTO tzcodes VALUES ('eas',36000,'Eastern Australian Standard');
+INSERT INTO tzcodes VALUES ('nzt',43200,'New Zealand');
+INSERT INTO tzcodes VALUES ('nzs',43200,'New Zealand Standard');
+INSERT INTO tzcodes VALUES ('id2',43200,'International Date Line East');
+INSERT INTO tzcodes VALUES ('idt',10800,'Israel Daylight');
+INSERT INTO tzcodes VALUES ('iss',7200,'Israel Standard');
Added: externals/geeklog-1.5.2sr2/sql/updates/1.1_to_1.2.sql
==============================================================================
--- (empty file)
+++ externals/geeklog-1.5.2sr2/sql/updates/1.1_to_1.2.sql Sun Apr 5
17:41:59 2009
@@ -0,0 +1,31 @@
+CREATE TABLE frontpagecodes (
+ code tinyint(4) DEFAULT '0' NOT NULL,
+ name varchar(32),
+ PRIMARY KEY (code)
+);
+
+CREATE TABLE sessions (
+ sess_id int(10) unsigned DEFAULT '0' NOT NULL,
+ start_time int(10) unsigned DEFAULT '0' NOT NULL,
+ remote_ip varchar(15) DEFAULT '' NOT NULL,
+ uid mediumint(8) DEFAULT '1' NOT NULL,
+ md5_sess_id varchar(128),
+ PRIMARY KEY (sess_id),
+ KEY sess_id (sess_id),
+ KEY start_time (start_time),
+ KEY remote_ip (remote_ip)
+);
+
+CREATE TABLE userevent (
+ uid mediumint(8) DEFAULT '1' NOT NULL,
+ eid varchar(20) DEFAULT '' NOT NULL,
+ PRIMARY KEY (uid,eid)
+);
+
+ALTER TABLE userindex MODIFY maxstories tinyint(4);
+ALTER TABLE stories ADD frontpage tinyint(3) unsigned DEFAULT '0';
+ALTER TABLE topics ADD sortnum tinyint(3);
+ALTER TABLE topics ADD limitnews tinyint(3);
+INSERT INTO frontpagecodes VALUES (0,'Show Only in Topic');
+INSERT INTO frontpagecodes VALUES (1,'Show on Front Page');
+UPDATE stories SET frontpage = 1;
Added: externals/geeklog-1.5.2sr2/sql/updates/1.2.5-1_to_1.3.NOTES
==============================================================================
--- (empty file)
+++ externals/geeklog-1.5.2sr2/sql/updates/1.2.5-1_to_1.3.NOTES Sun Apr 5
17:41:59 2009
@@ -0,0 +1,8 @@
+The upgrade to Geeklog 1.3 is not completely possible through a simple SQL
script. To do a manual
+upgrade you will need to follow these steps:
+1) import the 1.2.5-1_to_1.3.sql
+2) using the your database client or via the administration interface
modify the following users:
+ - Add all users EXCEPT anonymous to the group 'All Users'
and 'Logged-in Users'
+ - Edit all administrators to belong to the groups you see fit
+
+If possible you should avoid doing a manual installation and, instead, use
the installation script
Added: externals/geeklog-1.5.2sr2/sql/updates/1.2.5-1_to_1.3.sql
==============================================================================
--- (empty file)
+++ externals/geeklog-1.5.2sr2/sql/updates/1.2.5-1_to_1.3.sql Sun Apr 5
17:41:59 2009
@@ -0,0 +1,240 @@
+CREATE TABLE access (
+ acc_ft_id mediumint(8) NOT NULL default '0',
+ acc_grp_id mediumint(8) NOT NULL default '0',
+ PRIMARY KEY (acc_ft_id,acc_grp_id)
+) TYPE=MyISAM;
+
+ALTER TABLE blocks ADD name varchar(48) NOT NULL default '';
+ALTER TABLE blocks DROP seclev;
+ALTER TABLE blocks ADD onleft tinyint(3) unsigned NOT NULL default '1';
+ALTER TABLE blocks ADD phpblockfn varchar(64) default '';
+ALTER TABLE blocks ADD group_id mediumint(8) unsigned NOT NULL default '1';
+ALTER TABLE blocks ADD owner_id mediumint(8) unsigned NOT NULL default '0';
+ALTER TABLE blocks ADD perm_owner tinyint(1) unsigned NOT NULL default '3';
+ALTER TABLE blocks ADD perm_group tinyint(1) unsigned NOT NULL default '3';
+ALTER TABLE blocks ADD perm_members tinyint(1) unsigned NOT NULL
default '2';
+ALTER TABLE blocks ADD perm_anon tinyint(1) unsigned NOT NULL default '2';
+
+CREATE TABLE cookiecodes (
+ cc_value int(8) unsigned NOT NULL default '0',
+ cc_descr varchar(20) NOT NULL default '',
+ PRIMARY KEY (cc_value)
+) TYPE=MyISAM;
+
+ALTER TABLE events MODIFY location varchar(128) default NULL;
+ALTER TABLE events ADD event_type varchar(40) NOT NULL default '';
+ALTER TABLE events ADD timestart time default NULL;
+ALTER TABLE events ADD timeend time default NULL;
+ALTER TABLE events ADD allday tinyint(1) NOT NULL default '0';
+ALTER TABLE events ADD address1 varchar(40) default NULL;
+ALTER TABLE events ADD address2 varchar(40) default NULL;
+ALTER TABLE events ADD city varchar(60) default NULL;
+ALTER TABLE events ADD state char(2) default NULL;
+ALTER TABLE events ADD zipcode varchar(5) default NULL;
+ALTER TABLE events ADD group_id mediumint(8) unsigned NOT NULL default '1';
+ALTER TABLE events ADD owner_id mediumint(8) unsigned NOT NULL default '0';
+ALTER TABLE events ADD perm_owner tinyint(1) unsigned NOT NULL default '3';
+ALTER TABLE events ADD perm_group tinyint(1) unsigned NOT NULL default '3';
+ALTER TABLE events ADD perm_members tinyint(1) unsigned NOT NULL
default '2';
+ALTER TABLE events ADD perm_anon tinyint(1) unsigned NOT NULL default '2';
+ALTER TABLE eventsubmission MODIFY location varchar(128) default NULL;
+ALTER TABLE eventsubmission ADD event_type varchar(40) NOT NULL default '';
+ALTER TABLE eventsubmission ADD timestart time default NULL;
+ALTER TABLE eventsubmission ADD timeend time default NULL;
+ALTER TABLE eventsubmission ADD allday tinyint(1) NOT NULL default '0';
+ALTER TABLE eventsubmission ADD address1 varchar(40) default NULL;
+ALTER TABLE eventsubmission ADD address2 varchar(40) default NULL;
+ALTER TABLE eventsubmission ADD city varchar(60) default NULL;
+ALTER TABLE eventsubmission ADD state char(2) default NULL;
+ALTER TABLE eventsubmission ADD zipcode varchar(5) default NULL;
+
+CREATE TABLE features (
+ ft_id mediumint(8) NOT NULL auto_increment,
+ ft_name varchar(20) NOT NULL default '',
+ ft_descr varchar(255) NOT NULL default '',
+ ft_gl_core tinyint(1) NOT NULL default '0',
+ PRIMARY KEY (ft_id),
+ KEY ft_name (ft_name)
+) TYPE=MyISAM;
+
+CREATE TABLE group_assignments (
+ ug_main_grp_id mediumint(8) NOT NULL default '0',
+ ug_uid mediumint(8) unsigned default NULL,
+ ug_grp_id mediumint(8) unsigned default NULL,
+ KEY ug_main_grp_id (ug_main_grp_id)
+) TYPE=MyISAM;
+
+CREATE TABLE groups (
+ grp_id mediumint(8) NOT NULL auto_increment,
+ grp_name varchar(50) NOT NULL default '',
+ grp_descr varchar(255) NOT NULL default '',
+ grp_gl_core tinyint(1) unsigned NOT NULL default '0',
+ PRIMARY KEY (grp_id),
+ KEY grp_name (grp_name)
+) TYPE=MyISAM;
+
+ALTER TABLE links ADD group_id mediumint(8) unsigned NOT NULL default '1';
+ALTER TABLE links ADD owner_id mediumint(8) unsigned NOT NULL default '0';
+ALTER TABLE links ADD perm_owner tinyint(1) unsigned NOT NULL default '3';
+ALTER TABLE links ADD perm_group tinyint(1) unsigned NOT NULL default '3';
+ALTER TABLE links ADD perm_members tinyint(1) unsigned NOT NULL
default '2';
+ALTER TABLE links ADD perm_anon tinyint(1) unsigned NOT NULL default '2';
+
+CREATE TABLE personal_events (
+ eid varchar(20) NOT NULL default '',
+ uid mediumint(8) NOT NULL default '0',
+ title varchar(128) default NULL,
+ event_type varchar(40) NOT NULL default '',
+ datestart date default NULL,
+ timestart time default NULL,
+ dateend date default NULL,
+ timeend time default NULL,
+ location varchar(128) default NULL,
+ address1 varchar(40) default NULL,
+ address2 varchar(40) default NULL,
+ city varchar(60) default NULL,
+ state char(2) default NULL,
+ zipcode varchar(5) default NULL,
+ allday tinyint(1) NOT NULL default '0',
+ url varchar(128) default NULL,
+ description text,
+ group_id mediumint(8) unsigned NOT NULL default '1',
+ owner_id mediumint(8) unsigned NOT NULL default '0',
+ perm_owner tinyint(1) unsigned NOT NULL default '3',
+ perm_group tinyint(1) unsigned NOT NULL default '3',
+ perm_members tinyint(1) unsigned NOT NULL default '2',
+ perm_anon tinyint(1) unsigned NOT NULL default '2',
+ PRIMARY KEY (eid)
+) TYPE=MyISAM;
+
+CREATE TABLE plugins (
+ pi_name varchar(30) NOT NULL default '',
+ pi_version varchar(20) NOT NULL default '',
+ pi_gl_version varchar(20) NOT NULL default '',
+ pi_enabled tinyint(3) unsigned NOT NULL default '1',
+ pi_homepage varchar(128) NOT NULL default '',
+ PRIMARY KEY (pi_name)
+) TYPE=MyISAM;
+
+ALTER TABLE stories ADD numemails mediumint(8) unsigned NOT NULL
default '0';
+ALTER TABLE stories ADD owner_id mediumint(8) NOT NULL default '0';
+ALTER TABLE stories ADD group_id mediumint(8) NOT NULL default '2';
+ALTER TABLE stories ADD perm_owner tinyint(1) unsigned NOT NULL
default '3';
+ALTER TABLE stories ADD perm_group tinyint(1) unsigned NOT NULL
default '3';
+ALTER TABLE stories ADD perm_members tinyint(1) unsigned NOT NULL
default '2';
+ALTER TABLE stories ADD perm_anon tinyint(1) unsigned NOT NULL default '2';
+ALTER TABLE topics ADD group_id mediumint(8) unsigned NOT NULL default '1';
+ALTER TABLE topics ADD owner_id mediumint(8) unsigned NOT NULL default '0';
+ALTER TABLE topics ADD perm_owner tinyint(1) unsigned NOT NULL default '3';
+ALTER TABLE topics ADD perm_group tinyint(1) unsigned NOT NULL default '3';
+ALTER TABLE topics ADD perm_members tinyint(1) unsigned NOT NULL
default '2';
+ALTER TABLE topics ADD perm_anon tinyint(1) unsigned NOT NULL default '2';
+DROP TABLE userevent;
+ALTER TABLE users ADD regdate datetime NOT NULL default '0000-00-00
00:00:00';
+ALTER TABLE users ADD cookietimeout int(8) unsigned default '0';
+ALTER TABLE users ADD theme varchar(64) default NULL;
+ALTER TABLE users ADD language varchar(64) default NULL;
+ALTER TABLE users DROP seclev;
+INSERT INTO access (acc_ft_id, acc_grp_id) VALUES (1,3) ;
+INSERT INTO access (acc_ft_id, acc_grp_id) VALUES (2,3) ;
+INSERT INTO access (acc_ft_id, acc_grp_id) VALUES (3,5) ;
+INSERT INTO access (acc_ft_id, acc_grp_id) VALUES (4,5) ;
+INSERT INTO access (acc_ft_id, acc_grp_id) VALUES (5,9) ;
+INSERT INTO access (acc_ft_id, acc_grp_id) VALUES (5,11) ;
+INSERT INTO access (acc_ft_id, acc_grp_id) VALUES (6,9) ;
+INSERT INTO access (acc_ft_id, acc_grp_id) VALUES (6,11) ;
+INSERT INTO access (acc_ft_id, acc_grp_id) VALUES (8,7) ;
+INSERT INTO access (acc_ft_id, acc_grp_id) VALUES (9,7) ;
+INSERT INTO access (acc_ft_id, acc_grp_id) VALUES (10,4) ;
+INSERT INTO access (acc_ft_id, acc_grp_id) VALUES (11,6) ;
+INSERT INTO access (acc_ft_id, acc_grp_id) VALUES (12,8) ;
+INSERT INTO access (acc_ft_id, acc_grp_id) VALUES (13,10) ;
+INSERT INTO access (acc_ft_id, acc_grp_id) VALUES (14,11) ;
+INSERT INTO access (acc_ft_id, acc_grp_id) VALUES (15,11) ;
+INSERT INTO access (acc_ft_id, acc_grp_id) VALUES (16,4) ;
+INSERT INTO blocks (name, type, title, tid, blockorder, content, rdfurl,
rdfupdated, onleft, phpblockfn, group_id, owner_id, perm_owner, perm_group,
perm_members, perm_anon) VALUES ('user_block','gldefault','User
Block','all',2,'','','0000-00-00 00:00:00',1,'',1,2,3,3,2,2) ;
+INSERT INTO blocks (name, type, title, tid, blockorder, content, rdfurl,
rdfupdated, onleft, phpblockfn, group_id, owner_id, perm_owner, perm_group,
perm_members, perm_anon) VALUES ('admin_block','gldefault','Admin
Block','all',1,'','','0000-00-00 00:00:00',1,'',1,2,3,3,2,2) ;
+INSERT INTO blocks (name, type, title, tid, blockorder, content, rdfurl,
rdfupdated, onleft, phpblockfn, group_id, owner_id, perm_owner, perm_group,
perm_members, perm_anon) VALUES ('section_block','gldefault','Section
Block','all',0,'','','0000-00-00 00:00:00',1,'',1,2,3,3,2,2) ;
+INSERT INTO blocks (name, type, title, tid, blockorder, content, rdfurl,
rdfupdated, onleft, phpblockfn, group_id, owner_id, perm_owner, perm_group,
perm_members, perm_anon) VALUES ('poll_block','gldefault','Poll
Block','all',2,'','','0000-00-00 00:00:00',0,'0',1,2,3,3,2,2) ;
+INSERT INTO blocks (name, type, title, tid, blockorder, content, rdfurl,
rdfupdated, onleft, phpblockfn, group_id, owner_id, perm_owner, perm_group,
perm_members, perm_anon) VALUES ('events_block','gldefault','Events
Block','all',3,'','','0000-00-00 00:00:00',1,'',1,2,3,3,2,2) ;
+INSERT INTO blocks (name, type, title, tid, blockorder, content, rdfurl,
rdfupdated, onleft, phpblockfn, group_id, owner_id, perm_owner, perm_group,
perm_members, perm_anon) VALUES ('whats_new_block','gldefault','Whats New
Block','all',3,'','','0000-00-00 00:00:00',0,'1',1,2,3,3,2,2) ;
+INSERT INTO cookiecodes (cc_value, cc_descr) VALUES (3600,'1 Hour') ;
+INSERT INTO cookiecodes (cc_value, cc_descr) VALUES (7200,'2 Hours') ;
+INSERT INTO cookiecodes (cc_value, cc_descr) VALUES (10800,'3 Hours') ;
+INSERT INTO cookiecodes (cc_value, cc_descr) VALUES (28800,'8 Hours') ;
+INSERT INTO cookiecodes (cc_value, cc_descr) VALUES (86400,'1 Day') ;
+INSERT INTO cookiecodes (cc_value, cc_descr) VALUES (604800,'1 Week') ;
+INSERT INTO cookiecodes (cc_value, cc_descr) VALUES (2678400,'1 Month') ;
+INSERT INTO cookiecodes (cc_value, cc_descr) VALUES (31536000,'1 Year') ;
+INSERT INTO features (ft_id, ft_name, ft_descr, ft_gl_core) VALUES
(1,'story.edit','Access to story editor',1) ;
+INSERT INTO features (ft_id, ft_name, ft_descr, ft_gl_core) VALUES
(2,'story.moderate','Ablility to moderate pending stories',1) ;
+INSERT INTO features (ft_id, ft_name, ft_descr, ft_gl_core) VALUES
(3,'link.moderate','Ablility to moderate pending links',1) ;
+INSERT INTO features (ft_id, ft_name, ft_descr, ft_gl_core) VALUES
(4,'link.edit','Access to link editor',1) ;
+INSERT INTO features (ft_id, ft_name, ft_descr, ft_gl_core) VALUES
(5,'user.edit','Access to user editor',1) ;
+INSERT INTO features (ft_id, ft_name, ft_descr, ft_gl_core) VALUES
(6,'user.delete','Ablility to delete a user',1) ;
+INSERT INTO features (ft_id, ft_name, ft_descr, ft_gl_core) VALUES
(7,'user.mail','Ablility to send email to members',1) ;
+INSERT INTO features (ft_id, ft_name, ft_descr, ft_gl_core) VALUES
(8,'event.moderate','Ablility to moderate pending events',1) ;
+INSERT INTO features (ft_id, ft_name, ft_descr, ft_gl_core) VALUES
(9,'event.edit','Access to event editor',1) ;
+INSERT INTO features (ft_id, ft_name, ft_descr, ft_gl_core) VALUES
(10,'block.edit','Access to block editor',1) ;
+INSERT INTO features (ft_id, ft_name, ft_descr, ft_gl_core) VALUES
(11,'topic.edit','Access to topic editor',1) ;
+INSERT INTO features (ft_id, ft_name, ft_descr, ft_gl_core) VALUES
(12,'poll.edit','Access to poll editor',1) ;
+INSERT INTO features (ft_id, ft_name, ft_descr, ft_gl_core) VALUES
(13,'plugin.edit','Access to plugin editor',1);
+INSERT INTO features (ft_id, ft_name, ft_descr, ft_gl_core) VALUES
(14,'group.edit','Ability to edit groups',1) ;
+INSERT INTO features (ft_id, ft_name, ft_descr, ft_gl_core) VALUES
(15,'group.delete','Ability to delete groups',1) ;
+INSERT INTO features (ft_id, ft_name, ft_descr, ft_gl_core) VALUES
(16,'block.delete','Ability to delete a block',1) ;
+INSERT INTO users (username, fullname, passwd, email, homepage, sig,
regdate, cookietimeout, theme) VALUES ('NewAdmin','Geeklog
SuperUser','5f4dcc3b5aa765d61d8327deb882cf99','root ＠ localhost','http://geekog.sourceforge.net','','0000-00-00
00:00:00',0,NULL) ;
+INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES
(2,1,NULL) ;
+INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES
(2,NULL,1) ;
+INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES
(3,NULL,1) ;
+INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES
(4,NULL,1) ;
+INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES
(5,NULL,1) ;
+INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES
(6,NULL,1) ;
+INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES
(7,NULL,1) ;
+INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES
(8,NULL,1) ;
+INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES
(9,NULL,1) ;
+INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES
(10,NULL,1) ;
+INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES
(11,NULL,1) ;
+INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES
(13,LAST_INSERT_ID(),NULL) ;
+INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES
(12,LAST_INSERT_ID(),NULL) ;
+INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES
(11,LAST_INSERT_ID(),NULL) ;
+INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES
(2,NULL,12) ;
+INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES
(2,NULL,10) ;
+INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES
(2,NULL,9) ;
+INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES
(2,NULL,8) ;
+INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES
(2,NULL,7) ;
+INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES
(2,NULL,6) ;
+INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES
(2,NULL,5) ;
+INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES
(2,NULL,4) ;
+INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES
(2,NULL,3) ;
+INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES
(12,NULL,1) ;
+INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES
(9,NULL,11) ;
+INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES
(2,NULL,11) ;
+INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES
(10,LAST_INSERT_ID(),NULL) ;
+INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES
(9,LAST_INSERT_ID(),NULL) ;
+INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES
(8,LAST_INSERT_ID(),NULL) ;
+INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES
(7,LAST_INSERT_ID(),NULL) ;
+INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES
(6,LAST_INSERT_ID(),NULL) ;
+INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES
(5,LAST_INSERT_ID(),NULL) ;
+INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES
(4,LAST_INSERT_ID(),NULL) ;
+INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES
(3,LAST_INSERT_ID(),NULL) ;
+INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES
(2,LAST_INSERT_ID(),NULL) ;
+INSERT INTO group_assignments (ug_main_grp_id, ug_uid, ug_grp_id) VALUES
(1,LAST_INSERT_ID(),NULL) ;
+INSERT INTO groups (grp_id, grp_name, grp_descr, grp_gl_core) VALUES
(1,'Root','Has full access to the site',1) ;
+INSERT INTO groups (grp_id, grp_name, grp_descr, grp_gl_core) VALUES
(2,'All Users','Group that a typical user is added to',1) ;
+INSERT INTO groups (grp_id, grp_name, grp_descr, grp_gl_core) VALUES
(3,'Story Admin','Has full access to story features',1) ;
+INSERT INTO groups (grp_id, grp_name, grp_descr, grp_gl_core) VALUES
(4,'Block Admin','Has full access to block features',1) ;
+INSERT INTO groups (grp_id, grp_name, grp_descr, grp_gl_core) VALUES
(5,'Link Admin','Has full access to link features',1) ;
+INSERT INTO groups (grp_id, grp_name, grp_descr, grp_gl_core) VALUES
(6,'Topic Admin','Has full access to topic features',1) ;
+INSERT INTO groups (grp_id, grp_name, grp_descr, grp_gl_core) VALUES
(7,'Event Admin','Has full access to event features',1) ;
+INSERT INTO groups (grp_id, grp_name, grp_descr, grp_gl_core) VALUES
(8,'Poll Admin','Has full access to poll features',1) ;
+INSERT INTO groups (grp_id, grp_name, grp_descr, grp_gl_core) VALUES
(9,'User Admin','Has full access to user features',1) ;
+INSERT INTO groups (grp_id, grp_name, grp_descr, grp_gl_core) VALUES
(10,'Plugin Admin','Has full access to plugin features',1) ;
+INSERT INTO groups (grp_id, grp_name, grp_descr, grp_gl_core) VALUES
(11,'Group Admin','Is a User Admin with Acces to Groups too',1) ;
+INSERT INTO groups (grp_id, grp_name, grp_descr, grp_gl_core) VALUES
(12,'Mail Admin','Can Use Mail Utility',1) ;
+INSERT INTO groups (grp_id, grp_name, grp_descr, grp_gl_core) VALUES
(13,'Logged-in Users','All users except anonymous should belong to this
group',1) ;
+ALTER TABLE pollquestions ADD group_id mediumint(8) unsigned NOT NULL
default '1';
+ALTER TABLE pollquestions ADD owner_id mediumint(8) unsigned NOT NULL
default '1';
+ALTER TABLE pollquestions ADD perm_owner tinyint(1) unsigned NOT NULL
default '3';
+ALTER TABLE pollquestions ADD perm_group tinyint(1) unsigned NOT NULL
default '3';
+ALTER TABLE pollquestions ADD perm_members tinyint(1) unsigned NOT NULL
default '2';
+ALTER TABLE pollquestions ADD perm_anon tinyint(1) unsigned NOT NULL
default '2';
Added: externals/geeklog-1.5.2sr2/sql/updates/1.2_to_1.2.2.sql
==============================================================================
--- (empty file)
+++ externals/geeklog-1.5.2sr2/sql/updates/1.2_to_1.2.2.sql Sun Apr 5
17:41:59 2009
@@ -0,0 +1 @@
+ALTER TABLE stories ADD draft_flag tinyint(3) unsigned DEFAULT '0';
Added: externals/geeklog-1.5.2sr2/sql/updates/mssql_1.4.1_to_1.5.0.php
==============================================================================
--- (empty file)
+++ externals/geeklog-1.5.2sr2/sql/updates/mssql_1.4.1_to_1.5.0.php Sun
Apr 5 17:41:59 2009
@@ -0,0 +1,702 @@
+<?php
+
+/* These queries were copied from the mysql 1.5.0 upgrade and
+ * probably need to be rewritten for MS SQL
+ */
+
+// remove time zone table since its included into PEAR now
+$_SQL[] = "DROP TABLE " . $_DB_table_prefix . 'tzcodes';
+$_SQL[] = "ALTER TABLE {$_TABLES['userprefs']} ALTER COLUMN [tzid]
VARCHAR(125) NOT NULL";
+$_SQL[] = "ALTER TABLE {$_TABLES['userprefs']} ADD CONSTRAINT
[DF_{$_TABLES['userprefs']}_tzid] DEFAULT ('') FOR [tzid]";
+// change former default values to '' so users dont all have edt for no
reason
+$_SQL[] = "UPDATE {$_TABLES['userprefs']} set tzid = ''";
+// Add new field to track the number of reminders to login and use the
site or account may be deleted
+$_SQL[] = "ALTER TABLE {$_TABLES['users']} ADD num_reminders TINYINT NOT
NULL default 0";
+// User submissions may have body text.
+$_SQL[] = "ALTER TABLE {$_TABLES['storysubmission']} ADD bodytext TEXT";
+
+// new comment code: close comments
+$_SQL[] = "INSERT INTO {$_TABLES['commentcodes']} (code, name) VALUES
(1,'Comments Closed')";
+
+// Increase block function size to accept arguments:
+$_SQL[] = "ALTER TABLE {$_TABLES['blocks']} ALTER COLUMN [phpblockfn]
VARCHAR(128)";
+
+// New fields to store HTTP Last-Modified and ETag headers
+$_SQL[] = "ALTER TABLE {$_TABLES['blocks']} ADD rdf_last_modified
VARCHAR(40) DEFAULT NULL";
+$_SQL[] = "ALTER TABLE {$_TABLES['blocks']} ADD rdf_etag VARCHAR(40)
DEFAULT NULL";
+
+// new 'webservices.atompub' feature
+$_SQL[] = "INSERT INTO {$_TABLES['features']} (ft_name, ft_descr,
ft_gl_core) VALUES ('webservices.atompub', 'May use Atompub Webservices (if
restricted)', 1)";
+
+// add the 'Webservices Users' group
+$_SQL[] = "INSERT INTO {$_TABLES['groups']} (grp_name, grp_descr,
grp_gl_core) VALUES ('Webservices Users', 'Can use the Webservices API (if
restricted)', 0)";
+
+// add the security tokens table:
+$_SQL[] = "
+CREATE TABLE [dbo].[{$_TABLES['tokens']}] (
+ [token] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
+ [created] [datetime] NOT NULL,
+ [owner_id] [numeric] (8,0) NOT NULL,
+ [urlfor] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT
NULL,
+ [ttl] numeric(8,0) NOT NULL DEFAULT 1
+) ON [PRIMARY]
+";
+
+$_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['tokens']}] ADD
+ CONSTRAINT [PK_{$_TABLES['tokens']}] PRIMARY KEY CLUSTERED
+ (
+ [token]
+ ) ON [PRIMARY]
+";
+
+
+function create_ConfValues()
+{
+ global $_CONF, $_TABLES;
+
+ // Create conf_values table for new configuration system
+ DB_query ("
+ CREATE TABLE [dbo].[{$_TABLES['conf_values']}] (
+ [name] [varchar] (50) NULL,
+ [value] [text] NULL,
+ [type] [varchar] (50) NULL,
+ [group_name] [varchar] (50) NULL,
+ [default_value] [text],
+ [subgroup] [int] NULL,
+ [selectionArray] [int] NULL,
+ [sort_order] [int] NULL,
+ [fieldset] [int] NULL )
+ ON [PRIMARY]
+ ");
+
+ DB_Query ("
+ ALTER function [DESCRIBE](@d as varchar(100)='', @c as
varchar(100)=null)
+ RETURNS table AS
+
+ RETURN
+ (select top 1000 a.name as Field, c.name +'(' + cast(a.prec as
varchar) + ')' as Type,
+ case when a.status=(0x08) then 'NULL' else '' end as [Null],
+ ' ' as [Key],
+ ' ' as [Default],
+ ' ' as [Extra]
+ from syscolumns a
+ join sysobjects b on a.id=b.id
+ join systypes c on a.xtype=c.xtype
+ where b.name = @d
+ AND (a.name=@c OR @c IS NULL)
+ order by colorder asc)
+ ");
+
+ require_once $_CONF['path_system'] . 'classes/config.class.php';
+
+ $c = config::get_instance();
+
+ // Subgroup: Site
+ $c->add('sg_site', NULL, 'subgroup', 0, 0, NULL, 0, TRUE);
+
+ $c->add('fs_site', NULL, 'fieldset', 0, 0, NULL, 0, TRUE);
+ $c->add('site_url','','text',0,0,NULL,20,TRUE);
+ $c->add('site_admin_url','','text',0,0,NULL,30,TRUE);
+ $c->add('site_name','','text',0,0,NULL,60,TRUE);
+ $c->add('site_slogan','','text',0,0,NULL,70,TRUE);
+ $c->add('microsummary_short','GL: ','text',0,0,NULL,80,TRUE);
+ $c->add('site_disabled_msg','Geeklog Site is down. Please come back
soon.','text',0,0,NULL,510,TRUE);
+ $c->add('copyrightyear','2008','text',0,0,NULL,1440,FALSE);
+ $c->add('url_rewrite',FALSE,'select',0,0,1,1800,TRUE);
+
+ $c->add('fs_mail', NULL, 'fieldset', 0, 1, NULL, 0, TRUE);
+ $c->add('site_mail','','text',0,1,NULL,40,TRUE);
+ $c->add('noreply_mail','','text',0,1,NULL,50,TRUE);
+ $c->add('mail_settings',array ('backend' => 'mail', 'sendmail_path'
=> '/usr/bin/sendmail', 'sendmail_args' => '', 'host'
=> 'smtp.example.com','port' => '25', 'auth' => false, 'username'
=> 'smtp-username','password'
=> 'smtp-password'),'@text',0,1,NULL,160,TRUE);
+
+ $c->add('fs_syndication', NULL, 'fieldset', 0, 2, NULL, 0, TRUE);
+ $c->add('backend',1,'select',0,2,0,1380,TRUE);
+ $c->add('rdf_file','','text',0,2,NULL,1390,TRUE);
+ $c->add('rdf_limit',10,'text',0,2,NULL,1400,TRUE);
+ $c->add('rdf_storytext',1,'text',0,2,NULL,1410,TRUE);
+ $c->add('rdf_language','en-gb','text',0,2,NULL,1420,TRUE);
+ $c->add('syndication_max_headlines',0,'text',0,2,NULL,1430,TRUE);
+
+ $c->add('fs_paths', NULL, 'fieldset', 0, 3, NULL, 0, TRUE);
+ $c->add('path_html','','text',0,3,NULL,10,TRUE);
+ $c->add('path_log','','text',0,3,NULL,90,TRUE);
+ $c->add('path_language','','text',0,3,NULL,100,TRUE);
+ $c->add('backup_path','','text',0,3,NULL,110,TRUE);
+ $c->add('path_data','','text',0,3,NULL,120,TRUE);
+ $c->add('path_images','','text',0,3,NULL,130,TRUE);
+
+ $c->add('fs_pear', NULL, 'fieldset', 0, 4, NULL, 0, TRUE);
+ $c->add('have_pear',FALSE,'select',0,4,1,135,TRUE);
+ $c->add('path_pear','','text',0,4,NULL,140,TRUE);
+
+ $c->add('fs_mysql', NULL, 'fieldset', 0, 5, NULL, 0, TRUE);
+ $c->add('allow_mysqldump',1,'select',0,5,0,170,TRUE);
+
$c->add('mysqldump_path','/usr/bin/mysqldump','text',0,5,NULL,175,TRUE);
+ $c->add('mysqldump_options','-Q','text',0,5,NULL,180,TRUE);
+
+ $c->add('fs_search', NULL, 'fieldset', 0, 6, NULL, 0, TRUE);
+ $c->add('num_search_results',10,'text',0,6,NULL,670,TRUE);
+
+ // Subgroup: Stories and Trackback
+ $c->add('sg_stories', NULL, 'subgroup', 1, 0, NULL, 0, TRUE);
+
+ $c->add('fs_story', NULL, 'fieldset', 1, 7, NULL, 0, TRUE);
+ $c->add('maximagesperarticle',5,'text',1,7,NULL,1170,TRUE);
+ $c->add('limitnews',10,'text',1,7,NULL,1180,TRUE);
+ $c->add('minnews',1,'text',1,7,NULL,1190,TRUE);
+ $c->add('contributedbyline',1,'select',1,7,0,1200,TRUE);
+ $c->add('hideviewscount',0,'select',1,7,0,1210,TRUE);
+ $c->add('hideemailicon',0,'select',1,7,0,1220,TRUE);
+ $c->add('hideprintericon',0,'select',1,7,0,1230,TRUE);
+ $c->add('allow_page_breaks',1,'select',1,7,0,1240,TRUE);
+ $c->add('page_break_comments','last','select',1,7,7,1250,TRUE);
+ $c->add('article_image_align','right','select',1,7,8,1260,TRUE);
+ $c->add('show_topic_icon',1,'select',1,7,0,1270,TRUE);
+ $c->add('draft_flag',0,'select',1,7,0,1280,TRUE);
+ $c->add('frontpage',1,'select',1,7,0,1290,TRUE);
+ $c->add('hide_no_news_msg',0,'select',1,7,0,1300,TRUE);
+ $c->add('hide_main_page_navigation',0,'select',1,7,0,1310,TRUE);
+ $c->add('onlyrootfeatures',0,'select',1,7,0,1320,TRUE);
+ $c->add('aftersave_story','list','select',1,7,9,1330,TRUE);
+
+ $c->add('fs_trackback', NULL, 'fieldset', 1, 8, NULL, 0, TRUE);
+ $c->add('trackback_enabled',TRUE,'select',1,8,1,1060,TRUE);
+ $c->add('trackback_code',0,'select',1,8,3,1070,TRUE);
+ $c->add('trackbackspeedlimit',300,'text',1,8,NULL,1080,TRUE);
+ $c->add('check_trackback_link',2,'select',1,8,4,1090,TRUE);
+ $c->add('multiple_trackbacks',0,'select',1,8,2,1100,TRUE);
+
+ $c->add('fs_pingback', NULL, 'fieldset', 1, 9, NULL, 0, TRUE);
+ $c->add('pingback_enabled',TRUE,'select',1,9,1,1110,TRUE);
+ $c->add('pingback_excerpt',TRUE,'select',1,9,1,1120,TRUE);
+ $c->add('pingback_self',0,'select',1,9,13,1130,TRUE);
+ $c->add('ping_enabled',TRUE,'select',1,9,1,1140,TRUE);
+
+ // Subgroup: Theme
+ $c->add('sg_theme', NULL, 'subgroup', 2, 0, NULL, 0, TRUE);
+
+ $c->add('fs_theme', NULL, 'fieldset', 2, 10, NULL, 0, TRUE);
+ $c->add('theme','professional','select',2,10,NULL,190,TRUE);
+
$c->add('menu_elements',array('contribute','search','stats','directory','plugins'),'%text',2,10,NULL,200,TRUE);
+ $c->add('path_themes','','text',2,10,NULL,210,TRUE);
+
+ $c->add('fs_theme_advanced', NULL, 'fieldset', 2, 11, NULL, 0, TRUE);
+ $c->add('show_right_blocks',FALSE,'select',2,11,1,1350,TRUE);
+ $c->add('showfirstasfeatured',0,'select',2,11,0,1360,TRUE);
+
+ // Subgroup: Blocks
+ $c->add('sg_blocks', NULL, 'subgroup', 3, 0, NULL, 0, TRUE);
+
+ $c->add('fs_admin_block', NULL, 'fieldset', 3, 12, NULL, 0, TRUE);
+ $c->add('sort_admin',TRUE,'select',3,12,1,340,TRUE);
+ $c->add('link_documentation',1,'select',3,12,0,1150,TRUE);
+ $c->add('link_versionchecker',1,'select',3,12,0,1160,TRUE);
+
+ $c->add('fs_topics_block', NULL, 'fieldset', 3, 13, NULL, 0, TRUE);
+ $c->add('sortmethod','sortnum','select',3,13,15,870,TRUE);
+ $c->add('showstorycount',1,'select',3,13,0,880,TRUE);
+ $c->add('showsubmissioncount',1,'select',3,13,0,890,TRUE);
+ $c->add('hide_home_link',0,'select',3,13,0,900,TRUE);
+
+ $c->add('fs_whosonline_block', NULL, 'fieldset', 3, 14, NULL, 0, TRUE);
+ $c->add('whosonline_threshold',300,'text',3,14,NULL,910,TRUE);
+ $c->add('whosonline_anonymous',0,'select',3,14,0,920,TRUE);
+
+ $c->add('fs_whatsnew_block', NULL, 'fieldset', 3, 15, NULL, 0, TRUE);
+ $c->add('newstoriesinterval',86400,'text',3,15,NULL,980,TRUE);
+ $c->add('newcommentsinterval',172800,'text',3,15,NULL,990,TRUE);
+ $c->add('newtrackbackinterval',172800,'text',3,15,NULL,1000,TRUE);
+ $c->add('hidenewstories',0,'select',3,15,0,1010,TRUE);
+ $c->add('hidenewcomments',0,'select',3,15,0,1020,TRUE);
+ $c->add('hidenewtrackbacks',0,'select',3,15,0,1030,TRUE);
+ $c->add('hidenewplugins',0,'select',3,15,0,1040,TRUE);
+ $c->add('title_trim_length',20,'text',3,15,NULL,1050,TRUE);
+
+ // Subgroup: Users and Submissions
+ $c->add('sg_users', NULL, 'subgroup', 4, 0, NULL, 0, TRUE);
+
+ $c->add('fs_users', NULL, 'fieldset', 4, 16, NULL, 0, TRUE);
+
$c->add('disable_new_user_registration',FALSE,'select',4,16,0,220,TRUE);
+ $c->add('allow_user_themes',1,'select',4,16,0,230,TRUE);
+ $c->add('allow_user_language',1,'select',4,16,0,240,TRUE);
+ $c->add('allow_user_photo',1,'select',4,16,0,250,TRUE);
+ $c->add('allow_username_change',0,'select',4,16,0,260,TRUE);
+ $c->add('allow_account_delete',0,'select',4,16,0,270,TRUE);
+ $c->add('hide_author_exclusion',0,'select',4,16,0,280,TRUE);
+ $c->add('show_fullname',0,'select',4,16,0,290,TRUE);
+ $c->add('show_servicename',TRUE,'select',4,16,1,300,TRUE);
+ $c->add('custom_registration',FALSE,'select',4,16,1,310,TRUE);
+ $c->add('user_login_method',array('standard' => true, 'openid' =>
false, '3rdparty' => false),'@select',4,16,1,320,TRUE);
+ $c->add('aftersave_user','item','select',4,16,9,1340,TRUE);
+
+ $c->add('fs_spamx', NULL, 'fieldset', 4, 17, NULL, 0, TRUE);
+ $c->add('spamx',128,'text',4,17,NULL,330,TRUE);
+
+ $c->add('fs_login', NULL, 'fieldset', 4, 18, NULL, 0, TRUE);
+ $c->add('lastlogin',TRUE,'select',4,18,1,640,TRUE);
+ $c->add('loginrequired',0,'select',4,18,0,680,TRUE);
+ $c->add('submitloginrequired',0,'select',4,18,0,690,TRUE);
+ $c->add('commentsloginrequired',0,'select',4,18,0,700,TRUE);
+ $c->add('statsloginrequired',0,'select',4,18,0,710,TRUE);
+ $c->add('searchloginrequired',0,'select',4,18,16,720,TRUE);
+ $c->add('profileloginrequired',0,'select',4,18,0,730,TRUE);
+ $c->add('emailuserloginrequired',0,'select',4,18,0,740,TRUE);
+ $c->add('emailstoryloginrequired',0,'select',4,18,0,750,TRUE);
+ $c->add('directoryloginrequired',0,'select',4,18,0,760,TRUE);
+ $c->add('passwordspeedlimit',300,'text',4,18,NULL,1680,TRUE);
+ $c->add('login_attempts',3,'text',4,18,NULL,1690,TRUE);
+ $c->add('login_speedlimit',300,'text',4,18,NULL,1700,TRUE);
+
+ $c->add('fs_user_submission', NULL, 'fieldset', 4, 19, NULL, 0, TRUE);
+ $c->add('usersubmission',0,'select',4,19,0,780,TRUE);
+ $c->add('allow_domains','','text',4,19,NULL,960,TRUE);
+ $c->add('disallow_domains','','text',4,19,NULL,970,TRUE);
+
+ $c->add('fs_submission', NULL, 'fieldset', 4, 20, NULL, 0, TRUE);
+ $c->add('storysubmission',1,'select',4,20,0,770,TRUE);
+ $c->add('listdraftstories',0,'select',4,20,0,790,TRUE);
+ $c->add('postmode','plaintext','select',4,20,5,810,TRUE);
+ $c->add('speedlimit',45,'text',4,20,NULL,820,TRUE);
+ $c->add('skip_preview',0,'select',4,20,0,830,TRUE);
+ $c->add('advanced_editor',FALSE,'select',4,20,1,840,TRUE);
+ $c->add('wikitext_editor',FALSE,'select',4,20,1,850,TRUE);
+
+ $c->add('fs_comments', NULL, 'fieldset', 4, 21, NULL, 0, TRUE);
+ $c->add('commentspeedlimit',45,'text',4,21,NULL,1640,TRUE);
+ $c->add('comment_limit',100,'text',4,21,NULL,1650,TRUE);
+ $c->add('comment_mode','threaded','select',4,21,11,1660,TRUE);
+ $c->add('comment_code',0,'select',4,21,17,1670,TRUE);
+
+ // Subgroup: Images
+ $c->add('sg_images', NULL, 'subgroup', 5, 0, NULL, 0, TRUE);
+
+ $c->add('fs_imagelib', NULL, 'fieldset', 5, 22, NULL, 0, TRUE);
+ $c->add('image_lib','','select',5,22,10,1450,TRUE);
+ $c->add('path_to_mogrify','','text',5,22,NULL,1460,FALSE);
+ $c->add('path_to_netpbm','','text',5,22,NULL,1470,FALSE);
+
+ $c->add('fs_upload', NULL, 'fieldset', 5, 23, NULL, 0, TRUE);
+ $c->add('keep_unscaled_image',0,'select',5,23,0,1480,TRUE);
+ $c->add('allow_user_scaling',1,'select',5,23,0,1490,TRUE);
+ $c->add('debug_image_upload',FALSE,'select',5,23,1,1500,TRUE);
+
+ $c->add('fs_articleimg', NULL, 'fieldset', 5, 24, NULL, 0, TRUE);
+ $c->add('max_image_width',160,'text',5,24,NULL,1510,TRUE);
+ $c->add('max_image_height',160,'text',5,24,NULL,1520,TRUE);
+ $c->add('max_image_size',1048576,'text',5,24,NULL,1530,TRUE);
+
+ $c->add('fs_topicicon', NULL, 'fieldset', 5, 25, NULL, 0, TRUE);
+ $c->add('max_topicicon_width',48,'text',5,25,NULL,1540,TRUE);
+ $c->add('max_topicicon_height',48,'text',5,25,NULL,1550,TRUE);
+ $c->add('max_topicicon_size',65536,'text',5,25,NULL,1560,TRUE);
+
+ $c->add('fs_userphoto', NULL, 'fieldset', 5, 26, NULL, 0, TRUE);
+ $c->add('max_photo_width',128,'text',5,26,NULL,1570,TRUE);
+ $c->add('max_photo_height',128,'text',5,26,NULL,1580,TRUE);
+ $c->add('max_photo_size',65536,'text',5,26,NULL,1590,TRUE);
+ $c->add('force_photo_width',75,'text',5,26,NULL,1620,FALSE);
+
$c->add('default_photo','http://example.com/default.jpg','text',5,26,NULL,1630,FALSE);
+
+ $c->add('fs_gravatar', NULL, 'fieldset', 5, 27, NULL, 0, TRUE);
+ $c->add('use_gravatar',FALSE,'select',5,27,1,1600,TRUE);
+ $c->add('gravatar_rating','R','text',5,27,NULL,1610,FALSE);
+
+ // Subgroup: Languages and Locale
+ $c->add('sg_locale', NULL, 'subgroup', 6, 0, NULL, 0, TRUE);
+
+ $c->add('fs_language', NULL, 'fieldset', 6, 28, NULL, 0, TRUE);
+ $c->add('language','english','select',6,28,NULL,350,TRUE);
+
$c->add('language_files',array('en'=>'english_utf-8', 'de'=>'german_formal_utf-8'),'*text',6,28,NULL,470,FALSE);
+
$c->add('languages',array('en'=>'English', 'de'=>'Deutsch'),'*text',6,28,NULL,480,FALSE);
+
+ $c->add('fs_locale', NULL, 'fieldset', 6, 29, NULL, 0, TRUE);
+ $c->add('locale','en_GB','text',6,29,NULL,360,TRUE);
+ $c->add('date','%A, %B %d %Y @ %I:%M %p %Z','text',6,29,NULL,370,TRUE);
+ $c->add('daytime','%m/%d %I:%M%p','text',6,29,NULL,380,TRUE);
+ $c->add('shortdate','%x','text',6,29,NULL,390,TRUE);
+ $c->add('dateonly','%d-%b','text',6,29,NULL,400,TRUE);
+ $c->add('timeonly','%I:%M%p','text',6,29,NULL,410,TRUE);
+ $c->add('week_start','Sun','select',6,29,14,420,TRUE);
+ $c->add('hour_mode',12,'select',6,29,6,430,TRUE);
+ $c->add('thousand_separator',",",'text',6,29,NULL,440,TRUE);
+ $c->add('decimal_separator',".",'text',6,29,NULL,450,TRUE);
+ $c->add('decimal_count',"2",'text',6,29,NULL,460,TRUE);
+ $c->add('timezone','Etc/GMT-6','text',6,29,NULL,490,FALSE);
+
+ // Subgroup: Miscellaneous
+ $c->add('sg_misc', NULL, 'subgroup', 7, 0, NULL, 0, TRUE);
+
+ $c->add('fs_cookies', NULL, 'fieldset', 7, 30, NULL, 0, TRUE);
+ $c->add('cookie_session','gl_session','text',7,30,NULL,530,TRUE);
+ $c->add('cookie_name','geeklog','text',7,30,NULL,540,TRUE);
+ $c->add('cookie_password','password','text',7,30,NULL,550,TRUE);
+ $c->add('cookie_theme','theme','text',7,30,NULL,560,TRUE);
+ $c->add('cookie_language','language','text',7,30,NULL,570,TRUE);
+ $c->add('cookie_tzid','timezone','text',7,30,NULL,575,TRUE);
+ $c->add('cookie_ip',0,'select',7,30,0,580,TRUE);
+ $c->add('default_perm_cookie_timeout',28800,'text',7,30,NULL,590,TRUE);
+ $c->add('session_cookie_timeout',7200,'text',7,30,NULL,600,TRUE);
+ $c->add('cookie_path','/','text',7,30,NULL,610,TRUE);
+ $c->add('cookiedomain','','text',7,30,NULL,620,TRUE);
+ $c->add('cookiesecure',FALSE,'select',7,30,1,630,TRUE);
+
+ $c->add('fs_misc', NULL, 'fieldset', 7, 31, NULL, 0, TRUE);
+ $c->add('pdf_enabled',0,'select',7,31,0,660,TRUE);
+ $c->add('notification',array(),'%text',7,31,NULL,800,TRUE);
+ $c->add('cron_schedule_interval',86400,'text',7,31,NULL,860,TRUE);
+ $c->add('disable_autolinks',0,'select',7,31,0,1750,TRUE);
+
+ $c->add('fs_debug', NULL, 'fieldset', 7, 32, NULL, 0, TRUE);
+ $c->add('rootdebug',FALSE,'select',7,32,1,520,TRUE);
+
+ $c->add('fs_daily_digest', NULL, 'fieldset', 7, 33, NULL, 0, TRUE);
+ $c->add('emailstories',0,'select',7,33,0,930,TRUE);
+ $c->add('emailstorieslength',1,'text',7,33,NULL,940,TRUE);
+ $c->add('emailstoriesperdefault',0,'select',7,33,0,950,TRUE);
+
+ $c->add('fs_htmlfilter', NULL, 'fieldset', 7, 34, NULL, 0, TRUE);
+ $c->add('user_html',array ('p' => array(), 'b' => array(), 'strong' =>
array(),'i' => array(), 'a' => array('href' => 1, 'title' => 1, 'rel' =>
1),'em' => array(),'br' => array(),'tt' => array(),'hr' =>
array(), 'li' => array(), 'ol' => array(), 'ul' =>
array(), 'code' => array(), 'pre' =>
array()),'**placeholder',7,34,NULL,1710,TRUE);
+ $c->add('admin_html',array ('p' => array('class' => 1, 'id' =>
1, 'align' => 1), 'div' => array('class' => 1, 'id' => 1), 'span' =>
array('class' => 1, 'id' => 1), 'table' => array('class' => 1, 'id' =>
1, 'width' => 1, 'border' => 1, 'cellspacing' => 1, 'cellpadding' =>
1), 'tr' => array('class' => 1, 'id' => 1, 'align' => 1, 'valign' =>
1), 'th' => array('class' => 1, 'id' => 1, 'align' => 1, 'valign' =>
1, 'colspan' => 1, 'rowspan' => 1), 'td' => array('class' => 1, 'id' =>
1, 'align' => 1, 'valign' => 1, 'colspan' => 1, 'rowspan' =>
1)),'**placeholder',7,34,NULL,1720,TRUE);
+ $c->add('skip_html_filter_for_root',0,'select',7,34,0,1730,TRUE);
+
$c->add('allowed_protocols',array('http','ftp','https'),'%text',7,34,NULL,1740,TRUE);
+
+ $c->add('fs_censoring', NULL, 'fieldset', 7, 35, NULL, 0, TRUE);
+ $c->add('censormode',1,'select',7,35,0,1760,TRUE);
+ $c->add('censorreplace','*censormode*','text',7,35,NULL,1770,TRUE);
+ $c->add('censorlist',
array('fuck','cunt','fucker','fucking','pussy','cock','c0ck','
cum ','twat','clit','bitch','fuk','fuking','motherfucker'),'%text',7,35,NULL,1780,TRUE);
+
+ $c->add('fs_iplookup', NULL, 'fieldset', 7, 36, NULL, 0, TRUE);
+
$c->add('ip_lookup','/nettools/whois.php?domain=*','text',7,36,NULL,1790,FALSE);
+
+ $c->add('fs_perm_story', NULL, 'fieldset', 7, 37, NULL, 0, TRUE);
+ $c->add('default_permissions_story',array(3, 2, 2,
2),'@select',7,37,12,1820,TRUE);
+
+ $c->add('fs_perm_topic', NULL, 'fieldset', 7, 38, NULL, 0, TRUE);
+ $c->add('default_permissions_topic',array(3, 2, 2,
2),'@select',7,38,12,1830,TRUE);
+
+ $c->add('fs_perm_block', NULL, 'fieldset', 7, 39, NULL, 0, TRUE);
+ $c->add('default_permissions_block',array(3, 2, 2,
2),'@select',7,39,12,1810,TRUE);
+
+ $c->add('fs_webservices', NULL, 'fieldset', 7, 40, NULL, 0, TRUE);
+ $c->add('disable_webservices', 0, 'select', 7, 40, 0, 1840, TRUE);
+ $c->add('restrict_webservices', 0, 'select', 7, 40, 0, 1850, TRUE);
+ $c->add('atom_max_stories', 10, 'text', 7, 40, 0, 1860, TRUE);
+}
+
+// Polls plugin updates
+function upgrade_PollsPlugin()
+{
+ global $_CONF, $_TABLES;
+
+ require_once $_CONF['path_system'] . 'classes/config.class.php';
+
+ $plugin_path = $_CONF['path'] . 'plugins/polls/';
+ require_once $plugin_path . 'install_defaults.php';
+
+ if (file_exists($plugin_path . 'config.php')) {
+ global $_DB_table_prefix, $_PO_CONF;
+
+ require_once $plugin_path . 'config.php';
+ }
+
+ if (!plugin_initconfig_polls()) {
+ echo 'There was an error upgrading the Polls plugin';
+ return false;
+ }
+
+ $P_SQL = array();
+ //$P_SQL[] = "ALTER TABLE {$_TABLES['polltopics']} RENAME TO
{$_TABLES['pollquestions']};";
+ $P_SQL[] = "ALTER TABLE {$_TABLES['pollquestions']} DROP CONSTRAINT
[PK_gl_pollquestions];";
+ $P_SQL[] = "EXEC
sp_rename '{$_TABLES['pollquestions']}', '{$_TABLES['polltopics']}'";
+ $P_SQL[] = "EXEC
sp_rename '{$_TABLES['polltopics']}.question', 'topic', 'COLUMN'";
+ $P_SQL[] = "ALTER TABLE {$_TABLES['polltopics']} ALTER COLUMN [topic]
VARCHAR( 255 ) NULL";
+ $P_SQL[] = "EXEC
sp_rename '{$_TABLES['polltopics']}.qid', 'pid', 'COLUMN'";
+ $P_SQL[] = "ALTER TABLE {$_TABLES['polltopics']} ADD questions int
default '0' NOT NULL";
+ $P_SQL[] = "ALTER TABLE {$_TABLES['polltopics']} ADD is_open tinyint
NOT NULL default '1'";
+ $P_SQL[] = "ALTER TABLE {$_TABLES['polltopics']} ADD hideresults
tinyint NOT NULL default '0'";
+ $P_SQL[] = "EXEC
sp_rename '{$_TABLES['pollanswers']}.qid', 'pid', 'COLUMN'";
+ $P_SQL[] = "ALTER TABLE {$_TABLES['pollanswers']} ADD qid VARCHAR(20)
NOT NULL default '0'";
+ $P_SQL[] = "ALTER TABLE {$_TABLES['pollanswers']} DROP CONSTRAINT
[PK_gl_pollanswers];";
+ $P_SQL[] = "ALTER TABLE {$_TABLES['pollanswers']} ADD CONSTRAINT
[PK_{$_TABLES['pollanswers']}] PRIMARY KEY CLUSTERED ([pid], [qid], [aid])
ON [PRIMARY];";
+ $P_SQL[] = "EXEC
sp_rename '{$_TABLES['pollvoters']}.qid', 'pid', 'COLUMN'";
+ $P_SQL[] = "ALTER TABLE {$_TABLES['pollvoters']} ALTER COLUMN [pid]
VARCHAR( 20 ) NOT NULL";
+ $P_SQL[] = "CREATE TABLE [dbo].[{$_TABLES['pollquestions']}] (
+ [qid] [int] NOT NULL DEFAULT 0,
+ [pid] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT
NULL ,
+ [question] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
+ CONSTRAINT [PK_{$_TABLES['pollquestions']}] PRIMARY KEY CLUSTERED
+ (
+ [qid]
+ ) ON [PRIMARY]
+ ) ON [PRIMARY]";
+ // in 1.4.1, "don't display poll" was equivalent to "closed"
+ $P_SQL[] = "UPDATE {$_TABLES['polltopics']} SET is_open = 0 WHERE
display = 0";
+ $P_SQL[] = "UPDATE {$_TABLES['plugins']} SET pi_version = '2.0.1',
pi_gl_version = '1.5.0' WHERE pi_name = 'polls'";
+
+ foreach ($P_SQL as $sql) {
+ $rst = DB_query($sql);
+ if (DB_error()) {
+ echo "There was an error upgrading the polls, SQL: $sql<br>";
+ return false;
+ }
+ }
+ $P_SQL = array();
+
+ $move_sql = "SELECT pid, topic FROM {$_TABLES['polltopics']}";
+ $move_rst = DB_query ($move_sql);
+ $count_move = DB_numRows($move_rst);
+ for ($i = 0; $i < $count_move; $i++) {
+ $A = DB_fetchArray($move_rst);
+ $A[1] = str_replace("'", "''", $A[1]);
+ $P_SQL[] = "INSERT INTO {$_TABLES['pollquestions']} (pid,
question) VALUES ('{$A[0]}','{$A[1]}');";
+ }
+
+ foreach ($P_SQL as $sql) {
+ $rst = DB_query($sql);
+ if (DB_error()) {
+ echo "There was an error upgrading the polls, SQL: $sql<br>";
+ return false;
+ }
+ }
+
+ return true;
+}
+
+// Staticpages plugin updates
+function upgrade_StaticpagesPlugin()
+{
+ global $_CONF, $_TABLES;
+
+ require_once $_CONF['path_system'] . 'classes/config.class.php';
+
+ $plugin_path = $_CONF['path'] . 'plugins/staticpages/';
+ require_once $plugin_path . 'install_defaults.php';
+
+ if (file_exists($plugin_path . 'config.php')) {
+ global $_DB_table_prefix, $_SP_CONF;
+
+ require_once $plugin_path . 'config.php';
+ }
+
+ if (!plugin_initconfig_staticpages()) {
+ echo 'There was an error upgrading the Static Pages plugin';
+ return false;
+ }
+
+ $P_SQL = array();
+ $P_SQL[] = "ALTER TABLE {$_TABLES['staticpage']} ADD [commentcode]
TINYINT NOT NULL default '0'";
+ // disable comments on all existing static pages
+ $P_SQL[] = "UPDATE {$_TABLES['staticpage']} SET commentcode = 0";
+ $P_SQL[] = "UPDATE {$_TABLES['plugins']} SET pi_version = '1.5.0',
pi_gl_version = '1.5.0' WHERE pi_name = 'staticpages'";
+
+ foreach ($P_SQL as $sql) {
+ $rst = DB_query($sql);
+ if (DB_error()) {
+ echo "There was an error upgrading the Static Pages plugin,
SQL: $sql<br>";
+ return false;
+ }
+ }
+
+ return true;
+}
+
+// Calendar plugin updates
+function upgrade_CalendarPlugin()
+{
+ global $_CONF, $_TABLES, $_STATES;
+
+ require_once $_CONF['path_system'] . 'classes/config.class.php';
+
+ $plugin_path = $_CONF['path'] . 'plugins/calendar/';
+ require_once $plugin_path . 'install_defaults.php';
+
+ if (file_exists($plugin_path . 'config.php')) {
+ global $_DB_table_prefix, $_CA_CONF;
+
+ require_once $plugin_path . 'config.php';
+ }
+
+ if (!plugin_initconfig_calendar()) {
+ echo 'There was an error upgrading the Polls plugin';
+ return false;
+ }
+
+ $P_SQL[] = "ALTER TABLE {$_TABLES['events']} ALTER COLUMN [state]
varchar(40)";
+ $P_SQL[] = "ALTER TABLE {$_TABLES['eventsubmission']} ALTER COLUMN
[state] varchar(40)";
+ $P_SQL[] = "ALTER TABLE {$_TABLES['personal_events']} ALTER COLUMN
[state] varchar(40)";
+ $P_SQL[] = "UPDATE {$_TABLES['plugins']} SET pi_version = '1.0.2',
pi_gl_version = '1.5.0' WHERE pi_name = 'calendar'";
+
+ foreach ($P_SQL as $sql) {
+ $rst = DB_query($sql);
+ if (DB_error()) {
+ echo "There was an error upgrading the calendar";
+ return false;
+ }
+ }
+
+ if (isset($_STATES) && is_array($_STATES)) {
+ $tables = array($_TABLES['events'], $_TABLES['eventsubmission'],
+ $_TABLES['personal_events']);
+
+ foreach ($_STATES as $key => $state) {
+
==============================================================================
Diff truncated at 200k characters
