Commit: 4c9cf5b3a960c47210408b60b4ba603aea7e1fc1 Author: Sherif Ramadan <[email protected]> Wed, 12 Dec 2012 03:06:48 -0500 Parents: 9cb5a2073ba3175e0e94fffa09d4dd1c7c2c7981 Branches: master
Link: http://git.php.net/?p=web/master.git;a=commitdiff;h=4c9cf5b3a960c47210408b60b4ba603aea7e1fc1 Log: Updated SQL schema for new votes table required for user notes voting features. Changed paths: M note.sql Diff: diff --git a/note.sql b/note.sql index bf2fc7d..da8de21 100644 --- a/note.sql +++ b/note.sql @@ -8,6 +8,7 @@ /* used by: master.php.net/entry/user-note.php + master.php.net/entry/user-notes-vote.php master.php.net/fetch/user-notes.php master.php.net/manage/user-notes.php */ @@ -32,3 +33,16 @@ CREATE TABLE IF NOT EXISTS alerts ( sect VARCHAR(80) not NULL default '', updated TIMESTAMP(14) NOT NULL ) TYPE=MyISAM; + +-- New votes table added for keeping track of user notes ratings +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; -- PHP Webmaster List Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
