| Index: trunk/extensions/ArticleFeedbackv5/sql/ArticleFeedbackv5.sql |
| — | — | @@ -19,7 +19,7 @@ |
| 20 | 20 | af_page_id integer unsigned NOT NULL, |
| 21 | 21 | -- User Id (0 if anon), and ip address |
| 22 | 22 | af_user_id integer NOT NULL, |
| 23 | | - af_user_ip varchar(32) NOT NULL, |
| | 23 | + af_user_ip varchar(32) NULL, |
| 24 | 24 | -- Unique token for anonymous users (to facilitate ratings from multiple users on the same IP) |
| 25 | 25 | af_user_anon_token varbinary(32) NOT NULL DEFAULT '', |
| 26 | 26 | -- Foreign key to revision.rev_id |
| Index: trunk/extensions/ArticleFeedbackv5/sql/alter.sql |
| — | — | @@ -45,3 +45,6 @@ |
| 46 | 46 | ALTER TABLE aft_article_revision_feedback_select_rollup ADD PRIMARY KEY (arfsr_page_id, arfsr_field_id, arfsr_revision_id, arfsr_option_id); |
| 47 | 47 | ALTER TABLE aft_article_revision_feedback_ratings_rollup DROP PRIMARY KEY; |
| 48 | 48 | ALTER TABLE aft_article_revision_feedback_ratings_rollup ADD PRIMARY KEY (afrr_page_id, afrr_field_id, afrr_revision_id); |
| | 49 | + |
| | 50 | +-- added 12/16 (Roan) |
| | 51 | +ALTER TABLE aft_article_feedback MODIFY COLUMN af_user_ip varchar(32) NULL; |