| Index: trunk/extensions/Poll/archives/Poll-install-manuel.sql |
| — | — | @@ -1,55 +0,0 @@ |
| 2 | | - |
| 3 | | -CREATE TABLE /*$wgDBprefix*/poll ( |
| 4 | | -`id` INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , |
| 5 | | -`question` VARCHAR( 255 ) NOT NULL , |
| 6 | | -`alternative_1` VARCHAR( 255 ) NOT NULL , |
| 7 | | -`alternative_2` VARCHAR( 255 ) NOT NULL , |
| 8 | | -`alternative_3` VARCHAR( 255 ) NOT NULL , |
| 9 | | -`alternative_4` VARCHAR( 255 ) NOT NULL , |
| 10 | | -`alternative_5` VARCHAR( 255 ) NOT NULL , |
| 11 | | -`alternative_6` VARCHAR( 255 ) NOT NULL |
| 12 | | -) /*$wgDBTableOptions*/; |
| 13 | | - |
| 14 | | -CREATE TABLE /*$wgDBprefix*/poll_answer ( |
| 15 | | -`pid` INT( 10 ) NOT NULL , |
| 16 | | -`uid` INT( 10 ) NOT NULL , |
| 17 | | -`vote` VARCHAR( 255 ) NOT NULL |
| 18 | | -) /*$wgDBTableOptions*/; |
| 19 | | - |
| 20 | | -CREATE TABLE /*$wgDBprefix*/poll_start_log ( |
| 21 | | -`time` INT( 30 ) NOT NULL |
| 22 | | -) /*$wgDBTableOptions*/; |
| 23 | | - |
| 24 | | - |
| 25 | | - |
| 26 | | -ALTER TABLE /*$wgDBprefix*/poll |
| 27 | | -ADD `creater` VARCHAR( 255 ) NOT NULL; |
| 28 | | - |
| 29 | | -ALTER TABLE /*$wgDBprefix*/poll |
| 30 | | -ADD `dis` VARCHAR( 255 ) NOT NULL ; |
| 31 | | - |
| 32 | | -ALTER TABLE /*$wgDBprefix*/poll |
| 33 | | -ADD `multi` INT( 1 ) NOT NULL ; |
| 34 | | - |
| 35 | | -ALTER TABLE /*$wgDBprefix*/poll |
| 36 | | -ADD `ip` INT( 1 ) NOT NULL ; |
| 37 | | - |
| 38 | | - |
| 39 | | - |
| 40 | | -ALTER TABLE /*$wgDBprefix*/poll_answer |
| 41 | | -ADD `user` VARCHAR( 255 ) NOT NULL ; |
| 42 | | - |
| 43 | | -ALTER TABLE /*$wgDBprefix*/poll_answer |
| 44 | | -ADD `isset_vote_other` INT( 1 ) NOT NULL ; |
| 45 | | - |
| 46 | | -ALTER TABLE /*$wgDBprefix*/poll_answer |
| 47 | | -ADD `vote_other` VARCHAR( 255 ) NOT NULL ; |
| 48 | | - |
| 49 | | -ALTER TABLE /*$wgDBprefix*/poll_answer |
| 50 | | -ADD `ip` VARCHAR( 255 ) NOT NULL ; |
| \ No newline at end of file |
| Index: trunk/extensions/Poll/archives/Poll-install-manual.sql |
| — | — | @@ -0,0 +1,55 @@ |
| | 2 | +-- (c) Jan Luca, 2009, CC by-sa 3.0 or later |
| | 3 | +-- Table structure for manual installing |
| | 4 | +-- Replace /*$wgDBprefix*/ with the proper prefix |
| | 5 | +-- Replace /*$wgDBTableOptions*/ with the correct options |
| | 6 | + |
| | 7 | +CREATE TABLE /*$wgDBprefix*/poll ( |
| | 8 | +`id` INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , |
| | 9 | +`question` VARCHAR( 255 ) NOT NULL , |
| | 10 | +`alternative_1` VARCHAR( 255 ) NOT NULL , |
| | 11 | +`alternative_2` VARCHAR( 255 ) NOT NULL , |
| | 12 | +`alternative_3` VARCHAR( 255 ) NOT NULL , |
| | 13 | +`alternative_4` VARCHAR( 255 ) NOT NULL , |
| | 14 | +`alternative_5` VARCHAR( 255 ) NOT NULL , |
| | 15 | +`alternative_6` VARCHAR( 255 ) NOT NULL |
| | 16 | +) /*$wgDBTableOptions*/; |
| | 17 | + |
| | 18 | +CREATE TABLE /*$wgDBprefix*/poll_answer ( |
| | 19 | +`pid` INT( 10 ) NOT NULL , |
| | 20 | +`uid` INT( 10 ) NOT NULL , |
| | 21 | +`vote` VARCHAR( 255 ) NOT NULL |
| | 22 | +) /*$wgDBTableOptions*/; |
| | 23 | + |
| | 24 | +CREATE TABLE /*$wgDBprefix*/poll_start_log ( |
| | 25 | +`time` INT( 30 ) NOT NULL |
| | 26 | +) /*$wgDBTableOptions*/; |
| | 27 | + |
| | 28 | + |
| | 29 | +-- New fields for poll |
| | 30 | + |
| | 31 | +ALTER TABLE /*$wgDBprefix*/poll |
| | 32 | +ADD `creater` VARCHAR( 255 ) NOT NULL; |
| | 33 | + |
| | 34 | +ALTER TABLE /*$wgDBprefix*/poll |
| | 35 | +ADD `dis` VARCHAR( 255 ) NOT NULL ; |
| | 36 | + |
| | 37 | +ALTER TABLE /*$wgDBprefix*/poll |
| | 38 | +ADD `multi` INT( 1 ) NOT NULL ; |
| | 39 | + |
| | 40 | +ALTER TABLE /*$wgDBprefix*/poll |
| | 41 | +ADD `ip` INT( 1 ) NOT NULL ; |
| | 42 | + |
| | 43 | + |
| | 44 | +-- New fields for poll_answer |
| | 45 | + |
| | 46 | +ALTER TABLE /*$wgDBprefix*/poll_answer |
| | 47 | +ADD `user` VARCHAR( 255 ) NOT NULL ; |
| | 48 | + |
| | 49 | +ALTER TABLE /*$wgDBprefix*/poll_answer |
| | 50 | +ADD `isset_vote_other` INT( 1 ) NOT NULL ; |
| | 51 | + |
| | 52 | +ALTER TABLE /*$wgDBprefix*/poll_answer |
| | 53 | +ADD `vote_other` VARCHAR( 255 ) NOT NULL ; |
| | 54 | + |
| | 55 | +ALTER TABLE /*$wgDBprefix*/poll_answer |
| | 56 | +ADD `ip` VARCHAR( 255 ) NOT NULL ; |
| \ No newline at end of file |
| Property changes on: trunk/extensions/Poll/archives/Poll-install-manual.sql |
| ___________________________________________________________________ |
| Name: svn:eol-style |
| 1 | 57 | + native |