[geeklog-cvs] geeklog: Removed plugins: Tables, default data, plugin registration
geeklog-cvs at lists.geeklog.net
geeklog-cvs at lists.geeklog.net
Sun Oct 12 10:17:28 EDT 2008
details: http://project.geeklog.net/cgi-bin/hgweb.cgi/rev/5383766e37f5
changeset: 6440:5383766e37f5
user: Dirk Haun <dirk at haun-online.de>
date: Sun Oct 12 09:42:22 2008 +0200
description:
Removed plugins: Tables, default data, plugin registration
diffstat:
2 files changed, 8 insertions(+), 611 deletions(-)
sql/mssql_tableanddata.php | 330 --------------------------------------------
sql/mysql_tableanddata.php | 289 --------------------------------------
diffs (truncated from 731 to 300 lines):
diff -r 10d8a479cde9 -r 5383766e37f5 sql/mssql_tableanddata.php
--- a/sql/mssql_tableanddata.php Sun Oct 12 09:02:24 2008 +0200
+++ b/sql/mssql_tableanddata.php Sun Oct 12 09:42:22 2008 +0200
@@ -431,226 +431,6 @@
) 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
@@ -772,44 +552,10 @@
) 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]
";
@@ -824,39 +570,6 @@
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]
-";
More information about the geeklog-cvs
mailing list