[geeklog-cvs] geeklog: plugin sql files..
geeklog-cvs at lists.geeklog.net
geeklog-cvs at lists.geeklog.net
Tue Jan 26 15:53:33 EST 2010
changeset 7626:7a9577237f9f
url: http://project.geeklog.net/cgi-bin/hgwebdir.cgi/geeklog/rev/7a9577237f9f
user: stan <yankees26an at gmail.com>
date: Sun Jul 05 19:07:41 2009 -0400
description:
plugin sql files..
diffstat:
plugins/calendar/sql/pgsql_install.php | 123 ++++++++++++++++++++++++++++++
plugins/links/sql/pgsql_install.php | 105 ++++++++++++++++++++++++++
plugins/polls/sql/pgsql_install.php | 121 ++++++++++++++++++++++++++++++
plugins/spamx/sql/pgsql_install.php | 43 ++++++++++
plugins/staticpages/sql/pgsql_install.php | 69 +++++++++++++++++
plugins/xmlsitemap/sql/pgsql_install.php | 49 ++++++++++++
6 files changed, 510 insertions(+), 0 deletions(-)
diffs (truncated from 534 to 300 lines):
diff -r 8adc4d41c628 -r 7a9577237f9f plugins/calendar/sql/pgsql_install.php
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/plugins/calendar/sql/pgsql_install.php Sun Jul 05 19:07:41 2009 -0400
@@ -0,0 +1,123 @@
+<?php
+
+/* Reminder: always indent with 4 spaces (no tabs). */
+// +---------------------------------------------------------------------------+
+// | Calendar Plugin 1.1 |
+// +---------------------------------------------------------------------------+
+// | mysql_install.php |
+// +---------------------------------------------------------------------------+
+// | Copyright (C) 2000-2009 by the following authors: |
+// | |
+// | Authors: Tony Bibbs - tony AT tonybibbs DOT com |
+// | Mark Limburg - mlimburg AT users DOT sourceforge DOT net |
+// | Jason Whittenburg - jwhitten AT securitygeeks DOT com |
+// | Dirk Haun - dirk AT haun-online DOT de |
+// | Trinity Bays - trinity93 AT gmail DOT com
+// | Stanislav Palatnik - spalatnikk AT gmail DOT com |
+// +---------------------------------------------------------------------------+
+// | |
+// | This program is licensed under the terms of the GNU General Public License|
+// | as published by the Free Software Foundation; either version 2 |
+// | of the License, or (at your option) any later version. |
+// | |
+// | This program is distributed in the hope that it will be useful, |
+// | but WITHOUT ANY WARRANTY; without even the implied warranty of |
+// | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. |
+// | See the GNU General Public License for more details. |
+// | |
+// | You should have received a copy of the GNU General Public License |
+// | along with this program; if not, write to the Free Software Foundation, |
+// | Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. |
+// | |
+// +---------------------------------------------------------------------------+
+
+$_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 int NOT NULL default '0',
+ owner_id int NOT NULL default '1',
+ group_id int NOT NULL default '1',
+ perm_owner int NOT NULL default '3',
+ perm_group int NOT NULL default '3',
+ perm_members int NOT NULL default '2',
+ perm_anon int 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 int NOT NULL default '0',
+ event_type varchar(40) NOT NULL default '',
+ location varchar(128) default NULL,
+ timestart time default NULL,
+ timeend time default NULL,
+ PRIMARY KEY (eid));
+ CREATE INDEX events_eid ON {$_TABLES['events']}(eid);
+ CREATE INDEX events_event_type ON {$_TABLES['events']}(event_type);
+ CREATE INDEX events_datestart ON {$_TABLES['events']}(datestart);
+ CREATE INDEX events_dateend ON {$_TABLES['events']}(dateend);
+";
+
+$_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 int 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)
+)
+";
+
+$_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 int NOT NULL default '0',
+ url varchar(255) default NULL,
+ description text,
+ postmode varchar(10) NOT NULL default 'plaintext',
+ owner_id int NOT NULL default '1',
+ group_id int NOT NULL default '1',
+ perm_owner int NOT NULL default '3',
+ perm_group int NOT NULL default '3',
+ perm_members int NOT NULL default '2',
+ perm_anon int NOT NULL default '2',
+ uid int NOT NULL default '0',
+ location varchar(128) default NULL,
+ timestart time default NULL,
+ timeend time default NULL,
+ PRIMARY KEY (eid,uid)
+)
+";
+
+$_SQL[] = "INSERT INTO {$_TABLES['eventsubmission']} (eid, title, description, location, datestart, dateend, url, allday, zipcode, state, city, address2, address1, event_type, timestart, timeend) VALUES ('2008050110130162','Installed the Calendar plugin','Today, you successfully installed the Calendar plugin.','Your webserver',CURDATE(),CURDATE(),'http://www.geeklog.net/',1,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL)";
+
+$_SQL[] = "INSERT INTO {$_TABLES['blocks']} (is_enabled, name, type, title, tid, blockorder, content, onleft, phpblockfn, owner_id, group_id, perm_owner, perm_group) VALUES (1,'events_block','phpblock','Events','all',4,'',1,'phpblock_calendar',{$_USER['uid']},#group#,3,3)";
+
+?>
diff -r 8adc4d41c628 -r 7a9577237f9f plugins/links/sql/pgsql_install.php
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/plugins/links/sql/pgsql_install.php Sun Jul 05 19:07:41 2009 -0400
@@ -0,0 +1,105 @@
+<?php
+
+/* Reminder: always indent with 4 spaces (no tabs). */
+// +---------------------------------------------------------------------------+
+// | Links Plugin 2.0 |
+// +---------------------------------------------------------------------------+
+// | Installation SQL |
+// +---------------------------------------------------------------------------+
+// | Copyright (C) 2000-2008 by the following authors: |
+// | |
+// | Authors: Tony Bibbs - tony AT tonybibbs DOT com |
+// | Mark Limburg - mlimburg AT users DOT sourceforge DOT net |
+// | Jason Whittenburg - jwhitten AT securitygeeks DOT com |
+// | Dirk Haun - dirk AT haun-online DOT de |
+// | Trinity Bays - trinity93 AT gmail DOT com |
+// +---------------------------------------------------------------------------+
+// | |
+// | This program is licensed under the terms of the GNU General Public License|
+// | as published by the Free Software Foundation; either version 2 |
+// | of the License, or (at your option) any later version. |
+// | |
+// | This program is distributed in the hope that it will be useful, |
+// | but WITHOUT ANY WARRANTY; without even the implied warranty of |
+// | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. |
+// | See the GNU General Public License for more details. |
+// | |
+// | You should have received a copy of the GNU General Public License |
+// | along with this program; if not, write to the Free Software Foundation, |
+// | Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. |
+// | |
+// +---------------------------------------------------------------------------+
+
+/**
+ * Links plugin Installation SQL
+ *
+ * @package Links
+ * @filesource
+ * @version 2.0
+ * @since GL 1.4.0
+ * @copyright Copyright © 2005-2008
+ * @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2
+ * @author Trinity Bays <trinity93 at gmail.com>
+ * @author Tony Bibbs <tony at tonybibbs.com>
+ * @author Tom Willett <twillett at users.sourceforge.net>
+ * @author Blaine Lang <langmail at sympatico.ca>
+ * @author Dirk Haun <dirk at haun-online.de>
+ *
+ */
+
+
+$_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 timestamp DEFAULT NULL,
+ modified timestamp DEFAULT NULL,
+ owner_id int NOT NULL default '1',
+ group_id int NOT NULL default '1',
+ perm_owner int NOT NULL default '3',
+ perm_group int NOT NULL default '2',
+ perm_members int NOT NULL default '2',
+ perm_anon int NOT NULL default '2',
+ PRIMARY KEY (cid));
+ CREATE INDEX links_pid ON {$_TABLES['linkcategories']}(pid);
+
+";
+
+$_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 NOT NULL default '0',
+ date timestamp default NULL,
+ owner_id int NOT NULL default '1',
+ group_id int NOT NULL default '1',
+ perm_owner int NOT NULL default '3',
+ perm_group int NOT NULL default '2',
+ perm_members int NOT NULL default '2',
+ perm_anon int NOT NULL default '2',
+ PRIMARY KEY (lid));
+ CREATE INDEX links_category ON {$_TABLES['links']}(cid);
+ CREATE INDEX links_date ON {$_TABLES['links']}(date);
+";
+
+$_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 default NULL,
+ date timestamp default NULL,
+ owner_id int NOT NULL default '1',
+ PRIMARY KEY (lid)
+)
+";
+
+?>
diff -r 8adc4d41c628 -r 7a9577237f9f plugins/polls/sql/pgsql_install.php
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/plugins/polls/sql/pgsql_install.php Sun Jul 05 19:07:41 2009 -0400
@@ -0,0 +1,121 @@
+<?php
+
+/* Reminder: always indent with 4 spaces (no tabs). */
+// +---------------------------------------------------------------------------+
+// | Polls Plugin 2.1 |
+// +---------------------------------------------------------------------------+
+// | mysql_install.php |
+// +---------------------------------------------------------------------------+
+// | Copyright (C) 2000-2009 by the following authors: |
+// | |
+// | Authors: Tony Bibbs - tony AT tonybibbs DOT com |
+// | Mark Limburg - mlimburg AT users DOT sourceforge DOT net |
+// | Jason Whittenburg - jwhitten AT securitygeeks DOT com |
+// | Dirk Haun - dirk AT haun-online DOT de |
+// | Trinity Bays - trinity93 AT gmail DOT com
+// | Stansislav Palatnik - spalatnikk AT gmail DOT com |
+// +---------------------------------------------------------------------------+
+// | |
+// | This program is licensed under the terms of the GNU General Public License|
+// | as published by the Free Software Foundation; either version 2 |
+// | of the License, or (at your option) any later version. |
+// | |
+// | This program is distributed in the hope that it will be useful, |
+// | but WITHOUT ANY WARRANTY; without even the implied warranty of |
+// | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. |
+// | See the GNU General Public License for more details. |
+// | |
+// | You should have received a copy of the GNU General Public License |
+// | along with this program; if not, write to the Free Software Foundation, |
+// | Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. |
+// | |
+// +---------------------------------------------------------------------------+
+
+/**
+* MySQL install data and tables
+*
+* @package Polls
+*/
+
+$_SQL[] = "
+CREATE TABLE {$_TABLES['pollanswers']} (
+ pid varchar(40) NOT NULL default '',
+ qid int NOT NULL default 0,
+ aid int NOT NULL default '0',
+ answer varchar(255) default NULL,
+ votes int default NULL,
+ remark varchar(255) NULL,
+ PRIMARY KEY (pid, qid, aid)
+)
+";
+
+$_SQL[] = "
+CREATE TABLE {$_TABLES['pollquestions']} (
+ qid int NOT NULL DEFAULT '0',
+ pid varchar(40) NOT NULL default '',
+ question varchar(255) NOT NULL,
+ PRIMARY KEY (qid, pid)
+)
+";
+
More information about the geeklog-cvs
mailing list