Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE IF NOT EXISTS `User_Posts` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `user_id` int(12) NOT NULL,
- `wall_id` int(12) NOT NULL,
- `text` text COLLATE utf8_bin NOT NULL,
- `img` varchar(255) COLLATE utf8_bin NOT NULL,
- `time` date NOT NULL
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=7 ;
- CREATE TABLE IF NOT EXISTS `User_Activity` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `content` varchar(55) COLLATE utf8_bin NOT NULL,
- `activity_id` int(12) NOT NULL,
- `activity` varchar(88) COLLATE utf8_bin NOT NULL,
- `user_id` int(12) NOT NULL,
- `time` date NOT NULL,
- `value` varchar(12) COLLATE utf8_bin NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=131 ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement