http://www.mediawiki.org/wiki/Special:Code/MediaWiki/89819
Revision: 89819
Author: ashley
Date: 2011-06-10 09:08:34 +0000 (Fri, 10 Jun 2011)
Log Message:
-----------
SocialProfile: remove backticks and add some comments to UserStatus' SQL file
Modified Paths:
--------------
trunk/extensions/SocialProfile/UserStatus/userstatus.sql
Modified: trunk/extensions/SocialProfile/UserStatus/userstatus.sql
===================================================================
--- trunk/extensions/SocialProfile/UserStatus/userstatus.sql 2011-06-10
08:03:35 UTC (rev 89818)
+++ trunk/extensions/SocialProfile/UserStatus/userstatus.sql 2011-06-10
09:08:34 UTC (rev 89819)
@@ -1,7 +1,12 @@
-CREATE TABLE /*_*/`user_status` (
+CREATE TABLE /*_*/user_status (
+ -- Unique status ID number
`us_id` int(11) NOT NULL DEFAULT 0 PRIMARY KEY,
+ -- ID number of the user who wrote this status update
`us_user_id` int(11) NOT NULL default '0',
+ -- Timestamp of the status update
`us_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP,
+ -- Name of the person who wrote the status update
`us_user_text` varchar(255) NOT NULL default '',
+ -- The text of the status update
`us_status` varchar(140) NOT NULL default ''
)/*$wgDBTableOptions*/;
\ No newline at end of file
_______________________________________________
MediaWiki-CVS mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs