r93254 MediaWiki - Code Review archive

Repository:MediaWiki
Revision:r93253‎ | r93254 | r93255 >
Date:23:42, 26 July 2011
Author:hashar
Status:deferred
Tags:
Comment:
put auto_increment at the end of declaration.

stil have to figur eout the ON UPDATE CURRENT_TIMESTAMP error I am facing.
Modified paths:
  • /trunk/extensions/SocialProfile/UserStatus/userstatus.sql (modified) (history)

Diff [purge]

Index: trunk/extensions/SocialProfile/UserStatus/userstatus.sql
@@ -1,6 +1,6 @@
22 CREATE TABLE /*_*/user_status (
33 -- Unique status ID number
4 - `us_id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 4+ `us_id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
55 -- ID number of the user who wrote this status update
66 `us_user_id` int(11) NOT NULL default '0',
77 -- Timestamp of the status update
@@ -10,8 +10,8 @@
1111 )/*$wgDBTableOptions*/;
1212
1313 CREATE TABLE /*_*/user_status_history (
14 - `ush_id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 14+ `ush_id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
1515 `ush_user_id` int(11) NOT NULL default '0',
1616 `ush_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1717 `ush_status` varchar(140) NOT NULL default ''
18 -)/*$wgDBTableOptions*/;
\ No newline at end of file
 18+)/*$wgDBTableOptions*/;

Status & tagging log