| Index: trunk/extensions/Translate/sql/translate_reviews.sql |
| — | — | @@ -1,12 +1,12 @@ |
| 2 | 2 | -- Translation reviews; to store reviews of a page revision by a user. |
| 3 | 3 | CREATE TABLE /*$wgDBprefix*/translate_reviews ( |
| 4 | | - trr_user int not null, |
| | 4 | + trr_user int NOT NULL, |
| 5 | 5 | |
| 6 | 6 | -- Link to page.page_id |
| 7 | | - trr_page int not null, |
| | 7 | + trr_page int NOT NULL, |
| 8 | 8 | |
| 9 | 9 | -- Link to revision.rev_id |
| 10 | | - trr_revision int not null |
| | 10 | + trr_revision int NOT NULL |
| 11 | 11 | ) /*$wgDBTableOptions*/; |
| 12 | 12 | |
| 13 | 13 | CREATE UNIQUE INDEX /*i*/trr_user_page_revision ON /*$wgDBprefix*/translate_reviews |
| Index: trunk/extensions/Translate/sql/revtag.sql |
| — | — | @@ -2,15 +2,15 @@ |
| 3 | 3 | |
| 4 | 4 | -- Revision tags |
| 5 | 5 | CREATE TABLE /*$wgDBprefix*/revtag ( |
| 6 | | - rt_type varbinary(60) not null, |
| | 6 | + rt_type varbinary(60) NOT NULL, |
| 7 | 7 | |
| 8 | 8 | -- Link to page.page_id |
| 9 | | - rt_page int not null, |
| | 9 | + rt_page int NOT NULL, |
| 10 | 10 | |
| 11 | 11 | -- Link to revision.rev_id |
| 12 | | - rt_revision int not null, |
| | 12 | + rt_revision int NOT NULL, |
| 13 | 13 | |
| 14 | | - rt_value blob null |
| | 14 | + rt_value blob NULL |
| 15 | 15 | ) /*$wgDBTableOptions*/; |
| 16 | 16 | -- Index for finding all revisions in a page with a given tag |
| 17 | 17 | CREATE UNIQUE INDEX /*i*/rt_type_page_revision ON /*$wgDBprefix*/revtag |
| Index: trunk/extensions/Translate/sql/translate_groupreviews.sql |
| — | — | @@ -7,7 +7,7 @@ |
| 8 | 8 | tgr_group varchar(200) binary NOT NULL, |
| 9 | 9 | tgr_lang varchar(20) binary NOT NULL, |
| 10 | 10 | -- Any of user configured values from $wgTranslateWorkflowStates |
| 11 | | - tgr_state varbinary(32) not null, |
| | 11 | + tgr_state varbinary(32) NOT NULL, |
| 12 | 12 | |
| 13 | 13 | PRIMARY KEY (tgr_group, tgr_lang) |
| 14 | 14 | ) /*$wgDBTableOptions*/; |