[php-blog-cvs] serendipity/sql db.sql,1.18.2.2,1.18.2.3 db_update_0.6_0.6.1_mysql.sql,1.2.2.1,1.2.2.2 db_update_0.6_0.6.1_postgres.sql,1.3.2.1,1.3.2.2 db_update_0.8-alpha1_0.8-alpha2_mysql.sql,1.1.2.2,1.1.2.3

[Garvin H. <gar...@us...>]

Update of /cvsroot/php-blog/serendipity/sql
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv19713/sql

Modified Files:
      Tag: branch-smarty
	db.sql db_update_0.6_0.6.1_mysql.sql 
	db_update_0.6_0.6.1_postgres.sql 
	db_update_0.8-alpha1_0.8-alpha2_mysql.sql 
Log Message:
MFH


Index: db_update_0.6_0.6.1_mysql.sql
===================================================================
RCS file: /cvsroot/php-blog/serendipity/sql/db_update_0.6_0.6.1_mysql.sql,v
retrieving revision 1.2.2.1
retrieving revision 1.2.2.2
diff -u -d -r1.2.2.1 -r1.2.2.2
--- db_update_0.6_0.6.1_mysql.sql	13 Oct 2004 09:31:17 -0000	1.2.2.1
+++ db_update_0.6_0.6.1_mysql.sql	2 Nov 2004 09:08:32 -0000	1.2.2.2
@@ -3,13 +3,13 @@
 UPDATE {PREFIX}authors SET userlevel = 1 WHERE authorid > 1;
 
 ALTER TABLE {PREFIX}config  ADD authorid  INT UNSIGNED NOT NULL DEFAULT '0';
-CREATE INDEX authorid_idx ON {PREFIX}config (authorid);
+CREATE INDEX configauthorid_idx ON {PREFIX}config (authorid);
 
 ALTER TABLE {PREFIX}config  DROP PRIMARY KEY;
 ALTER TABLE {PREFIX}config  ADD PRIMARY KEY (name, authorid);
 
 ALTER TABLE {PREFIX}plugins  ADD authorid  INT UNSIGNED DEFAULT '0';
-CREATE INDEX authorid_idx ON {PREFIX}plugins (authorid);
+CREATE INDEX pluginauthorid_idx ON {PREFIX}plugins (authorid);
 
 ALTER TABLE {PREFIX}images  ADD authorid  INT UNSIGNED DEFAULT '0';
-CREATE INDEX authorid_idx ON {PREFIX}images (authorid);
+CREATE INDEX imagesauthorid_idx ON {PREFIX}images (authorid);

Index: db_update_0.6_0.6.1_postgres.sql
===================================================================
RCS file: /cvsroot/php-blog/serendipity/sql/db_update_0.6_0.6.1_postgres.sql,v
retrieving revision 1.3.2.1
retrieving revision 1.3.2.2
diff -u -d -r1.3.2.1 -r1.3.2.2
--- db_update_0.6_0.6.1_postgres.sql	13 Oct 2004 09:31:17 -0000	1.3.2.1
+++ db_update_0.6_0.6.1_postgres.sql	2 Nov 2004 09:08:32 -0000	1.3.2.2
@@ -8,15 +8,15 @@
 UPDATE {PREFIX}config SET authorid=0;
 ALTER TABLE {PREFIX}config  ALTER COLUMN authorid SET NOT NULL;
 ALTER TABLE {PREFIX}config  ALTER COLUMN authorid SET DEFAULT '0';
-CREATE INDEX authorid_idx ON {PREFIX}config (authorid);
+CREATE INDEX configauthorid_idx ON {PREFIX}config (authorid);
 
 ALTER TABLE {PREFIX}config  DROP CONSTRAINT {PREFIX}config_pkey;
 ALTER TABLE {PREFIX}config  ADD PRIMARY KEY (name, authorid);
 
 ALTER TABLE {PREFIX}plugins  ADD COLUMN authorid  INT;
 ALTER TABLE {PREFIX}plugins  ALTER COLUMN authorid SET DEFAULT '0';
-CREATE INDEX authorid_idx ON {PREFIX}plugins (authorid);
+CREATE INDEX pluginsauthorid_idx ON {PREFIX}plugins (authorid);
 
 ALTER TABLE {PREFIX}images  ADD COLUMN authorid  INT;
 ALTER TABLE {PREFIX}images  ALTER COLUMN authorid SET DEFAULT '0';
-CREATE INDEX authorid_idx ON {PREFIX}images (authorid);
+CREATE INDEX imagesauthorid_idx ON {PREFIX}images (authorid);

Index: db.sql
===================================================================
RCS file: /cvsroot/php-blog/serendipity/sql/db.sql,v
retrieving revision 1.18.2.2
retrieving revision 1.18.2.3
diff -u -d -r1.18.2.2 -r1.18.2.3
--- db.sql	13 Oct 2004 09:31:16 -0000	1.18.2.2
+++ db.sql	2 Nov 2004 09:08:31 -0000	1.18.2.3
@@ -65,7 +65,8 @@
   moderate_comments {BOOLEAN}
 );
 
-CREATE {FULLTEXT} INDEX entry_idx on {PREFIX}entries (title,body,extended);
+# FULLTEXT_MYSQL is ignored on all Non-MySQL setups (SQLite, PostgreSQL)
+CREATE {FULLTEXT_MYSQL} INDEX entry_idx on {PREFIX}entries (title,body,extended);
 CREATE INDEX date_idx ON {PREFIX}entries (timestamp);
 CREATE INDEX mod_idx ON {PREFIX}entries (last_modified);
 
@@ -122,7 +123,7 @@
   authorid int(11) default '0'
 );
 
-CREATE INDEX authorid_idx ON {PREFIX}config (authorid);
+CREATE INDEX configauthorid_idx ON {PREFIX}config (authorid);
 
 CREATE TABLE {PREFIX}suppress (
   ip varchar(15) default NULL,
@@ -144,7 +145,7 @@
   PRIMARY KEY(name)
 );
 
-CREATE INDEX authorid_idx ON {PREFIX}config (authorid);
+CREATE INDEX pluginauthorid_idx ON {PREFIX}plugins (authorid);
 
 CREATE TABLE {PREFIX}category (
   categoryid {AUTOINCREMENT} {PRIMARY},
@@ -171,6 +172,7 @@
   path text
 );
 
+CREATE INDEX imagesauthorid_idx ON {PREFIX}images (authorid);
 CREATE {FULLTEXT} INDEX pathkey_idx on {PREFIX}images (path);
 
 CREATE TABLE {PREFIX}entrycat (
@@ -186,5 +188,5 @@
   value text
 );
 
-CREATE INDEX entryid_idx ON {PREFIX}entryproperties (entryid);
+CREATE INDEX entrypropid_idx ON {PREFIX}entryproperties (entryid);
 CREATE UNIQUE INDEX prop_idx ON {PREFIX}entryproperties (entryid, property);

Index: db_update_0.8-alpha1_0.8-alpha2_mysql.sql
===================================================================
RCS file: /cvsroot/php-blog/serendipity/sql/Attic/db_update_0.8-alpha1_0.8-alpha2_mysql.sql,v
retrieving revision 1.1.2.2
retrieving revision 1.1.2.3
diff -u -d -r1.1.2.2 -r1.1.2.3
--- db_update_0.8-alpha1_0.8-alpha2_mysql.sql	13 Oct 2004 09:31:17 -0000	1.1.2.2
+++ db_update_0.8-alpha1_0.8-alpha2_mysql.sql	2 Nov 2004 09:08:32 -0000	1.1.2.3
@@ -5,4 +5,4 @@
 );
 
 CREATE UNIQUE INDEX prop_idx ON {PREFIX}entryproperties (entryid, property);
-CREATE INDEX entryid_idx ON {PREFIX}entryproperties (entryid);
+CREATE INDEX entrypropid_idx ON {PREFIX}entryproperties (entryid);