Re: [PHP-DOC] Improving User Notes In The Manual -- First Steps

[Sherif Ramadan]

Here's the SQL patch.

From dc2413b5ef33ced0fe48cabf1f85129b881d8330 Mon Sep 17 00:00:00 2001
From: Sherif Ramadan <google...@php.net>
Date: Sun, 9 Sep 2012 14:19:51 -0400
Subject: [PATCH] Updated SQL schema for new user notes features
 voting/flagging.

---
 note.sql |   30 ++++++++++++++++++++++++++++++
 1 files changed, 30 insertions(+), 0 deletions(-)

diff --git a/note.sql b/note.sql
index bf2fc7d..c7b12d8 100644
--- a/note.sql
+++ b/note.sql
@@ -10,6 +10,8 @@
    master.php.net/entry/user-note.php
    master.php.net/fetch/user-notes.php
    master.php.net/manage/user-notes.php
+   master.php.net/entry/user-notes-vote.php
+   master.php.net/entry/user-notes-flag.php
 */
 
 CREATE TABLE IF NOT EXISTS note (
@@ -32,3 +34,31 @@ CREATE TABLE IF NOT EXISTS alerts (
   sect VARCHAR(80) not NULL default '',
   updated TIMESTAMP(14) NOT NULL
 ) TYPE=MyISAM;
+
+-- New votes table added by Sherif
+CREATE TABLE IF NOT EXISTS `votes` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `note_id` mediumint(9) NOT NULL,
+  `ip` bigint(20) unsigned NOT NULL DEFAULT '0',
+  `hostip` bigint(20) unsigned NOT NULL DEFAULT '0',
+  `ts` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+  `vote` tinyint(1) unsigned NOT NULL DEFAULT '0',
+  PRIMARY KEY (`id`),
+  KEY `note_id` (`note_id`,`ip`,`vote`),
+  KEY `hostip` (`hostip`)
+) TYPE=MyISAM AUTO_INCREMENT=1;
+
+-- New flags table added by Sherif
+CREATE TABLE IF NOT EXISTS `flags` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `note_id` mediumint(9) NOT NULL,
+  `ip` bigint(20) unsigned NOT NULL DEFAULT '0',
+  `hostip` bigint(20) unsigned NOT NULL DEFAULT '0',
+  `ts` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+  `flag` varchar(80) NOT NULL DEFAULT '',
+  `email` varchar(120) NOT NULL DEFAULT '',
+  `info` text,
+  PRIMARY KEY (`id`),
+  KEY `note_id` (`note_id`,`ip`,`flag`),
+  KEY `hostip` (`hostip`)
+) TYPE=MyISAM AUTO_INCREMENT=1;
-- 
1.7.5.4