cvs: docweb /scripts notes_stats.php
[email protected] ("Nuno Lopes")
| Newsgroups | php.doc.web |
|---|---|
| Message-ID | <cvsnlopess1107973569@cvsserver> |
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 <[email protected]> |
| Credits: Sean Coates <[email protected]> |
+----------------------------------------------------------------------+
-$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,