[php-blog-cvs] serendipity/sql db_update_0.8-alpha4_0.8-alpha5_mysql.sql,NONE,1.1 db_update_0.8-alpha4_0.8-alpha5_postgres.sql,NONE,1.1 db_update_0.8-alpha4_0.8-alpha5_sqlite.sql,NONE,1.1 db.sql,1.23,1.24

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

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

Modified Files:
	db.sql 
Added Files:
	db_update_0.8-alpha4_0.8-alpha5_mysql.sql 
	db_update_0.8-alpha4_0.8-alpha5_postgres.sql 
	db_update_0.8-alpha4_0.8-alpha5_sqlite.sql 
Log Message:
Save HTTP referrer for a user when entering a comment.
Discussed in http://thread.gmane.org/gmane.comp.serendipity.devel/3215
(I think user-agent logging is not neccessary, can be drawn out of usual access logs...)



--- NEW FILE: db_update_0.8-alpha4_0.8-alpha5_sqlite.sql ---
create table {PREFIX}tempcomments (
  id {AUTOINCREMENT} {PRIMARY},
  entry_id int(10) {UNSIGNED} not null default '0',
  parent_id int(10) {UNSIGNED} not null default '0',
  timestamp int(10) {UNSIGNED} default null,
  title varchar(150) default null,
  author varchar(80) default null,
  email varchar(200) default null,
  url varchar(200) default null,
  ip varchar(15) default null,
  body text,
  type varchar(100) default 'regular',
  subscribed {BOOLEAN},
  status varchar(50) not null
);

INSERT INTO {PREFIX}tempcomments (id, entry_id, parent_id, timestamp, title, author, email, url, ip, body, type, subscribed, status) SELECT id, entry_id, parent_id, timestamp, title, author, email, url, ip, body, type, subscribed, status FROM {PREFIX}comments;
DROP TABLE comments;

create table {PREFIX}comments (
  id {AUTOINCREMENT} {PRIMARY},
  entry_id int(10) {UNSIGNED} not null default '0',
  parent_id int(10) {UNSIGNED} not null default '0',
  timestamp int(10) {UNSIGNED} default null,
  title varchar(150) default null,
  author varchar(80) default null,
  email varchar(200) default null,
  url varchar(200) default null,
  ip varchar(15) default null,
  body text,
  type varchar(100) default 'regular',
  subscribed {BOOLEAN},
  status varchar(50) not null,
  referer varchar(200) default null
);

INSERT INTO {PREFIX}comments (id, entry_id, parent_id, timestamp, title, author, email, url, ip, body, type, subscribed, status) SELECT id, entry_id, parent_id, timestamp, title, author, email, url, ip, body, type, subscribed, status FROM {PREFIX}comments;
DROP TABLE tempcomments;

--- NEW FILE: db_update_0.8-alpha4_0.8-alpha5_mysql.sql ---
ALTER TABLE {PREFIX}comments ADD referer varchar(200) default null;

--- NEW FILE: db_update_0.8-alpha4_0.8-alpha5_postgres.sql ---
ALTER TABLE {PREFIX}comments ADD COLUMN referer varchar(200);
Index: db.sql
===================================================================
RCS file: /cvsroot/php-blog/serendipity/sql/db.sql,v
retrieving revision 1.23
retrieving revision 1.24
diff -u -d -r1.23 -r1.24
--- db.sql	19 Nov 2004 11:06:06 -0000	1.23
+++ db.sql	3 Dec 2004 10:07:43 -0000	1.24
@@ -39,7 +39,8 @@
   body text,
   type varchar(100) default 'regular',
   subscribed {BOOLEAN},
-  status varchar(50) not null
+  status varchar(50) not null,
+  referer varchar(200) default null
 );
 
 CREATE {FULLTEXT} INDEX body_idx on {PREFIX}comments (body);