流媒体网站开发（一）

一、项目前准备 1.1 数据库设计 SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for comments -- ---------------------------- DROP TABLE IF EXISTS `comments`; CREATE TABLE `comments` ( `id` varchar(64) NOT NULL, `video_id` varchar(64) DEFAULT NULL, `author_id` int(10) unsigned DEFAULT NULL, `content` text, `time` timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for sessions -- ---------------------------- DROP TABLE IF EXISTS `sessions`; CREATE TABLE `sessions` ( `session_id` varchar(255) NOT NULL, `ttl` tinytext, `login_name` varchar(64) DEFAULT NULL, PRIMARY KEY (`session_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for users -- ---------------------------- DROP TABLE IF EXISTS `users`; CREATE TABLE `users` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `login_name` varchar(64) DEFAULT NULL, `pwd` text, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for video_del_rec -- ---------------------------- DROP TABLE IF EXISTS `video_del_rec`; CREATE TABLE `video_del_rec` ( `video_id` varchar(64) NOT NULL, PRIMARY KEY (`video_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for video_info -- ---------------------------- DROP TABLE IF EXISTS `video_info`; CREATE TABLE `video_info` ( `id` varchar(64) NOT NULL, `author_id` int(10) unsigned DEFAULT NULL, `name` text, `display_ctime` text, `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 1.2 模块划分 一、项目前准备 1.1 数据库设计 SET FOREIGN_KEY_CHECKS=0; -- --