r62519 MediaWiki - Code Review archive

Repository:MediaWiki
Revision:r62518‎ | r62519 | r62520 >
Date:14:36, 15 February 2010
Author:catrope
Status:ok
Tags:
Comment:
Storyboard: Lose potentially breaking backticks in SQL, add $wgDBTableOptions, redo PRIMARY KEY for SQLite compat
Modified paths:
  • /trunk/extensions/Storyboard/Storyboard.sql (modified) (history)

Diff [purge]

Index: trunk/extensions/Storyboard/Storyboard.sql
@@ -1,13 +1,12 @@
22 -- MySQL version of the database schema for the Storyboard extension.
33
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,
66 story_author_id INT unsigned NULL,
77 story_author_name VARCHAR(255) NULL,
88 story_hit_count INT(8) unsigned NOT NULL,
99 story_title VARCHAR(255) NOT NULL,
1010 story_text MEDIUMBLOB NULL,
1111 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*/;

Status & tagging log