| Index: branches/wmf/1.16wmf4/extensions/UsabilityInitiative/PrefSwitch/patches/PrefSwitch-addusertext.sql |
| — | — | @@ -0,0 +1,5 @@ |
| | 2 | +-- |
| | 3 | +-- Schema update for OptIn |
| | 4 | +-- |
| | 5 | + |
| | 6 | +ALTER TABLE /*_*/prefswitch_survey ADD COLUMN pss_user_text varchar(255) binary NOT NULL AFTER pss_user; |
| \ No newline at end of file |
| Property changes on: branches/wmf/1.16wmf4/extensions/UsabilityInitiative/PrefSwitch/patches/PrefSwitch-addusertext.sql |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 1 | 7 | + native |
| Index: branches/wmf/1.16wmf4/extensions/UsabilityInitiative/PrefSwitch/patches/PrefSwitch.sql |
| — | — | @@ -0,0 +1,28 @@ |
| | 2 | +-- |
| | 3 | +-- Schema for OptIn |
| | 4 | +-- |
| | 5 | + |
| | 6 | +CREATE TABLE IF NOT EXISTS /*_*/prefswitch_survey ( |
| | 7 | + -- User ID |
| | 8 | + pss_user int NOT NULL, |
| | 9 | + |
| | 10 | + -- User text |
| | 11 | + pss_user_text varchar(255) binary NOT NULL, |
| | 12 | + |
| | 13 | + -- Timestamp |
| | 14 | + pss_timestamp binary(14) NOT NULL, |
| | 15 | + |
| | 16 | + -- Survey name (out, feedback, etc.) |
| | 17 | + pss_name varchar(16) NOT NULL, |
| | 18 | + |
| | 19 | + -- Question ID (key in $wgPrefSwitchSurvey) |
| | 20 | + pss_question varchar(16) NOT NULL, |
| | 21 | + |
| | 22 | + -- Answer ID (key in $wgPrefSwitchSurvey[pss_question]['answers']) |
| | 23 | + pss_answer text NULL, |
| | 24 | + |
| | 25 | + -- Optional text associated with the answer |
| | 26 | + pss_answer_data text NULL |
| | 27 | +) /*$wgDBTableOptions*/; |
| | 28 | + |
| | 29 | +CREATE UNIQUE INDEX /*i*/pss_user_timestamp_name_question ON /*_*/prefswitch_survey (pss_user, pss_timestamp, pss_name, pss_question); |
| Property changes on: branches/wmf/1.16wmf4/extensions/UsabilityInitiative/PrefSwitch/patches/PrefSwitch.sql |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 1 | 30 | + native |