Advertisement
Guest User

Untitled

a guest
Oct 31st, 2014
140
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.76 KB | None | 0 0
  1. CREATE TABLE IF NOT EXISTS `User_Posts` (
  2. `id` int(11) NOT NULL AUTO_INCREMENT,
  3. `user_id` int(12) NOT NULL,
  4. `wall_id` int(12) NOT NULL,
  5. `text` text COLLATE utf8_bin NOT NULL,
  6. `img` varchar(255) COLLATE utf8_bin NOT NULL,
  7. `time` date NOT NULL
  8. PRIMARY KEY (`id`)
  9. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=7 ;
  10.  
  11. CREATE TABLE IF NOT EXISTS `User_Activity` (
  12. `id` int(11) NOT NULL AUTO_INCREMENT,
  13. `content` varchar(55) COLLATE utf8_bin NOT NULL,
  14. `activity_id` int(12) NOT NULL,
  15. `activity` varchar(88) COLLATE utf8_bin NOT NULL,
  16. `user_id` int(12) NOT NULL,
  17. `time` date NOT NULL,
  18. `value` varchar(12) COLLATE utf8_bin NOT NULL,
  19. PRIMARY KEY (`id`)
  20. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=131 ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement