[geeklog-cvs] geeklog: Fixed PostgreSQL install

[geeklog-cvs at lists.geeklog.net]

changeset 7764:cec75ce5daab
url:  http://project.geeklog.net/cgi-bin/hgwebdir.cgi/geeklog/rev/cec75ce5daab
user: Dirk Haun <dirk at haun-online.de>
date: Sun Feb 28 19:08:46 2010 +0100
description:
Fixed PostgreSQL install

diffstat:

 plugins/polls/sql/pgsql_install.php       |   2 +-
 plugins/staticpages/sql/pgsql_install.php |  19 ++++++++++---------
 2 files changed, 11 insertions(+), 10 deletions(-)

diffs (59 lines):

diff -r cdae3ad46f50 -r cec75ce5daab plugins/polls/sql/pgsql_install.php
--- a/plugins/polls/sql/pgsql_install.php	Sun Feb 28 16:33:06 2010 +0100
+++ b/plugins/polls/sql/pgsql_install.php	Sun Feb 28 19:08:46 2010 +0100
@@ -74,7 +74,7 @@
   perm_anon int  NOT NULL default '2',
   PRIMARY KEY  (pid));
   CREATE INDEX  pollquestions_qid ON {$_TABLES['polltopics']}(pid);
-  CREATE INDEX pollquestions_date ON {$_TABLES['polltopics']}(date);
+  CREATE INDEX pollquestions_created ON {$_TABLES['polltopics']}(created);
   CREATE INDEX pollquestions_display ON {$_TABLES['polltopics']}(display);
   CREATE INDEX pollquestions_commentcode ON {$_TABLES['polltopics']}(commentcode);
   CREATE INDEX pollquestions_statuscode ON {$_TABLES['polltopics']}(statuscode);
diff -r cdae3ad46f50 -r cec75ce5daab plugins/staticpages/sql/pgsql_install.php
--- a/plugins/staticpages/sql/pgsql_install.php	Sun Feb 28 16:33:06 2010 +0100
+++ b/plugins/staticpages/sql/pgsql_install.php	Sun Feb 28 19:08:46 2010 +0100
@@ -2,16 +2,13 @@
 
 /* Reminder: always indent with 4 spaces (no tabs). */
 // +---------------------------------------------------------------------------+
-// | Static Pages Plugin 1.4.2                                                 |
+// | Static Pages Plugin 1.6                                                   |
 // +---------------------------------------------------------------------------+
 // | Installation SQL                                                          |
 // +---------------------------------------------------------------------------+
-// | Copyright (C) 2000-2006 by the following authors:                         |
+// | Copyright (C) 2009-2010 by the following authors:                         |
 // |                                                                           |
-// | Authors: Tony Bibbs       - tony AT tonybibbs DOT com                     |
-// |          Tom Willett      - twillett AT users DOT sourceforge DOT net     |
-// |          Blaine Lang      - langmail AT sympatico DOT ca                  |
-// |          Dirk Haun        - dirk AT haun-online DOT de                    |
+// | Authors: Stansislav Palatnik - spalatnikk AT gmail DOT com                |
 // +---------------------------------------------------------------------------+
 // |                                                                           |
 // | This program is licensed under the terms of the GNU General Public License|
@@ -28,8 +25,12 @@
 // | Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.           |
 // |                                                                           |
 // +---------------------------------------------------------------------------+
-//
-// $Id: pgsql_install.php,v 1.1 2010/01/26 18:29:34 dhaun Exp $
+
+/**
+* PostgreSQL install data and tables
+*
+* @package StaticPages
+*/
 
 $_SQL[] = "
 CREATE TABLE {$_TABLES['staticpage']} (
@@ -61,7 +62,7 @@
   postmode varchar(16) NOT NULL default 'html',
   PRIMARY KEY  (sp_id));
   CREATE INDEX staticpage_sp_uid ON {$_TABLES['staticpage']}(sp_uid);
-  CREATE INDEX staticpage_sp_date ON {$_TABLES['staticpage']}(sp_date);
+  CREATE INDEX staticpage_created ON {$_TABLES['staticpage']}(created);
   CREATE INDEX staticpage_sp_onmenu ON {$_TABLES['staticpage']}(sp_onmenu);
   CREATE INDEX staticpage_sp_centerblock ON {$_TABLES['staticpage']}(sp_centerblock);
   CREATE INDEX staticpage_sp_tid ON {$_TABLES['staticpage']}(sp_tid);