Index: trunk/extensions/Poll/archives/patch-end.sql |
— | — | @@ -0,0 +1,6 @@ |
| 2 | +-- (c) Jan Luca, 2009, CC by-sa 3.0 or later |
| 3 | +-- Table structure for table `Poll` |
| 4 | +-- Replace /*$wgDBprefix*/ with the proper prefix |
| 5 | + |
| 6 | +ALTER TABLE /*$wgDBprefix*/poll |
| 7 | +ADD `end` INT( 1 ) NOT NULL ; |
\ No newline at end of file |
Property changes on: trunk/extensions/Poll/archives/patch-end.sql |
___________________________________________________________________ |
Name: svn:eol-style |
1 | 8 | + native |
Index: trunk/extensions/Poll/archives/Poll-install-manuel.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-manuel.sql |
___________________________________________________________________ |
Name: svn:eol-style |
1 | 57 | + native |
Index: trunk/extensions/Poll/archives/patch-starttime.sql |
— | — | @@ -0,0 +1,6 @@ |
| 2 | +-- (c) Jan Luca, 2009, CC by-sa 3.0 or later |
| 3 | +-- Table structure for table `Poll` |
| 4 | +-- Replace /*$wgDBprefix*/ with the proper prefix |
| 5 | + |
| 6 | +ALTER TABLE /*$wgDBprefix*/poll |
| 7 | +ADD `starttime` INT( 30 ) NOT NULL ; |
\ No newline at end of file |
Property changes on: trunk/extensions/Poll/archives/patch-starttime.sql |
___________________________________________________________________ |
Name: svn:eol-style |
1 | 8 | + native |
Index: trunk/extensions/Poll/archives/Poll-start-log.sql |
— | — | @@ -0,0 +1,8 @@ |
| 2 | +-- (c) Jan Luca, 2009, CC by-sa 3.0 or later |
| 3 | +-- Table structure for table `Poll` |
| 4 | +-- Replace /*$wgDBprefix*/ with the proper prefix |
| 5 | +-- Replace /*$wgDBTableOptions*/ with the correct options |
| 6 | + |
| 7 | +CREATE TABLE /*$wgDBprefix*/poll_start_log ( |
| 8 | +`time` INT( 30 ) NOT NULL |
| 9 | +) /*$wgDBTableOptions*/; |
\ No newline at end of file |
Property changes on: trunk/extensions/Poll/archives/Poll-start-log.sql |
___________________________________________________________________ |
Name: svn:eol-style |
1 | 10 | + native |
Index: trunk/extensions/Poll/archives/patch-runtime.sql |
— | — | @@ -0,0 +1,6 @@ |
| 2 | +-- (c) Jan Luca, 2009, CC by-sa 3.0 or later |
| 3 | +-- Table structure for table `Poll` |
| 4 | +-- Replace /*$wgDBprefix*/ with the proper prefix |
| 5 | + |
| 6 | +ALTER TABLE /*$wgDBprefix*/poll |
| 7 | +ADD `runtime` INT( 10 ) NOT NULL ; |
\ No newline at end of file |
Property changes on: trunk/extensions/Poll/archives/patch-runtime.sql |
___________________________________________________________________ |
Name: svn:eol-style |
1 | 8 | + native |