com web/master: Updated SQL schema for new votes table required for user notes voting features.: note.sql

Commit: 4c9cf5b3a960c47210408b60b4ba603aea7e1fc1 Author: Sherif Ramadan <googleguy@php.net> 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;