cvs: docweb /scripts notes_stats.php
| From: | Nuno Lopes | Date: | Wed, 09 Feb 2005 18:26:09 +0000 |
| Subject: | cvs: docweb /scripts notes_stats.php | ||
| Groups: | php.doc.web | ||
| Request: | Send a blank email to doc-web+get-601@lists.php.net to get a copy of this message | ||
nlopess Wed Feb 9 13:26:09 2005 EDT
Modified files:
/docweb/scripts notes_stats.php
Log:
the note id must be PRIMARY KEY, because there are repeated e-mails about the same note. this way,
we prevent having duplicate notes in the DB
http://cvs.php.net/diff.php/docweb/scripts/notes_stats.php?r1=1.6&r2=1.7&ty=u
Index: docweb/scripts/notes_stats.php
diff -u docweb/scripts/notes_stats.php:1.6 docweb/scripts/notes_stats.php:1.7
--- docweb/scripts/notes_stats.php:1.6 Fri Feb 4 17:10:33 2005
+++ docweb/scripts/notes_stats.php Wed Feb 9 13:26:09 2005
@@ -17,7 +17,7 @@
| Vincent Gevers <vincent@php.net> |
| Credits: Sean Coates <sean@php.net> |
+----------------------------------------------------------------------+
-$Id: notes_stats.php,v 1.6 2005/02/04 22:10:33 vincent Exp $
+$Id: notes_stats.php,v 1.7 2005/02/09 18:26:09 nlopess Exp $
*/
require_once '../build-ops.php';
@@ -157,7 +157,7 @@
);
CREATE TABLE notes (
- note INTEGER,
+ note INTEGER PRIMARY KEY,
action TEXT,
manpage TEXT,
who TEXT,