Update of /cvsroot/php-blog/serendipity/sql
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv4992/sql
Modified Files:
db.sql db_update_0.6.2_0.6.3_mysql.sql
db_update_0.6.2_0.6.3_postgres.sql
Added Files:
db_update_0.6.3_0.6.4_mysql.sql
db_update_0.6.3_0.6.4_postgres.sql
Log Message:
User manager: New user right 'publish' which controls whether a user is allowed to publish entries or only drafts.
NOTICE: requires DB layout upgrade.
--- NEW FILE: db_update_0.6.3_0.6.4_mysql.sql ---
ALTER TABLE {PREFIX}authors ADD right_publish INT(1) DEFAULT '1';
Index: db_update_0.6.2_0.6.3_mysql.sql
===================================================================
RCS file: /cvsroot/php-blog/serendipity/sql/db_update_0.6.2_0.6.3_mysql.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- db_update_0.6.2_0.6.3_mysql.sql 26 May 2004 15:26:55 -0000 1.2
+++ db_update_0.6.2_0.6.3_mysql.sql 26 May 2004 17:02:35 -0000 1.3
@@ -1,2 +1,2 @@
ALTER TABLE {PREFIX}images ADD COLUMN path text;
-CREATE FULLTEXT INDEX pathkey on {PREFIX}images (path);
+CREATE {FULLTEXT} INDEX pathkey on {PREFIX}images (path);
--- NEW FILE: db_update_0.6.3_0.6.4_postgres.sql ---
ALTER TABLE {PREFIX}authors ADD COLUMN right_publish int(1);
ALTER TABLE {PREFIX}authors ALTER COLUMN right_publish SET DEFAULT '1';
UPDATE {PREFIX}authors SET right_publish=1;
Index: db.sql
===================================================================
RCS file: /cvsroot/php-blog/serendipity/sql/db.sql,v
retrieving revision 1.8
retrieving revision 1.9
diff -u -d -r1.8 -r1.9
--- db.sql 25 May 2004 16:16:16 -0000 1.8
+++ db.sql 26 May 2004 17:02:35 -0000 1.9
@@ -9,7 +9,8 @@
mail_comments int(1) default '1',
mail_trackbacks int(1) default '1',
email varchar(128) not null default '',
- userlevel int(4) {UNSIGNED} not null default '0'
+ userlevel int(4) {UNSIGNED} not null default '0',
+ right_publish int(1) default '1'
);
#
Index: db_update_0.6.2_0.6.3_postgres.sql
===================================================================
RCS file: /cvsroot/php-blog/serendipity/sql/db_update_0.6.2_0.6.3_postgres.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- db_update_0.6.2_0.6.3_postgres.sql 26 May 2004 15:26:55 -0000 1.2
+++ db_update_0.6.2_0.6.3_postgres.sql 26 May 2004 17:02:35 -0000 1.3
@@ -1,2 +1,2 @@
ALTER TABLE {PREFIX}images ADD COLUMN path text DEFAULT '/';
-CREATE INDEX pathkey on {PREFIX}images (path);
+CREATE {FULLTEXT} INDEX pathkey on {PREFIX}images (path);
|
