Index: trunk/extensions/Storyboard/Storyboard.sql |
— | — | @@ -1,13 +1,12 @@ |
2 | 2 | -- MySQL version of the database schema for the Storyboard extension. |
3 | 3 | |
4 | | -CREATE TABLE `/*$wgDBprefix*/storyboard` ( |
5 | | - story_id INT(8) unsigned NOT NULL auto_increment, |
| 4 | +CREATE TABLE /*$wgDBprefix*/storyboard ( |
| 5 | + story_id INT(8) unsigned NOT NULL auto_increment PRIMARY KEY, |
6 | 6 | story_author_id INT unsigned NULL, |
7 | 7 | story_author_name VARCHAR(255) NULL, |
8 | 8 | story_hit_count INT(8) unsigned NOT NULL, |
9 | 9 | story_title VARCHAR(255) NOT NULL, |
10 | 10 | story_text MEDIUMBLOB NULL, |
11 | 11 | story_modified CHAR(14) binary NOT NULL default '', |
12 | | - story_created CHAR(14) binary NOT NULL default '', |
13 | | - PRIMARY KEY (`story_id`) |
14 | | -); |
\ No newline at end of file |
| 12 | + story_created CHAR(14) binary NOT NULL default '' |
| 13 | +) /*$wgDBTableOptions*/; |