Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
branch: master
Fetching contributors…

Cannot retrieve contributors at this time

23 lines (21 sloc) 0.757 kb
CREATE TABLE IF NOT EXISTS `Liwu_Items` (
`ItemId` bigint(20) NOT NULL,
`UserSinaUserId` bigint(20) NOT NULL,
`Text` varchar(512) NOT NULL,
`SinaUserName` varchar(64) NOT NULL,
`CreateTime` datetime NOT NULL,
`ThumbnailPic` varchar(512) NOT NULL,
`BmiddlePic` varchar(512) NOT NULL,
`OriginalPc` varchar(512) NOT NULL,
`UserHeaderPic` varchar(512) NOT NULL,
`Hits` int(11) NOT NULL,
`Sell` tinyint(1) NOT NULL,
`Recommend` tinyint(1) NOT NULL,
UNIQUE KEY `ItemId` (`ItemId`),
KEY `CreateTime` (`CreateTime`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `Liwu_Likes` (
`SinaUserId` bigint(20) NOT NULL,
`ItemId` bigint(20) NOT NULL,
KEY `SinaUserId` (`SinaUserId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Jump to Line
Something went wrong with that request. Please try again.