Earlier we created the vidoe database and created the administrator login form.
Now that we are going to start implementing the functions of the main page, we need to create a table for managing content and a table for managing categories.
First create a content management table: list Table
Set the following fields:
id: It is unique, type is int, and Select the primary key.
name: Video name, type is varchar, length is 20.
title: Video introduction, type is varchar, length is 200.
video: Video, type is varchar, length is 100.
time: Timestamp, type is int, length is 20.
cate_id: Category id, type is int, length is 10.
<?php $SQL = " CREATE TABLE IF NOT EXISTS `list` ( `id` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(20) NOT NULL, `title` varchar(200) NOT NULL, `video` varchar(100) NOT NULL COMMENT '视频存放路径', `time` int(20) NOT NULL COMMENT '视频上架时间', `cate_id` int(10) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=45 DEFAULT CHARSET=utf8 COMMENT='视频展示表'"; ?>
Create a classification table: cate Table
Set the following fields:
id: It is unique, type is int, and Select the primary key.
pid: Parent class id, type is int, length is 10.
cate_name: Category name, type is varchar, length is 30.
rank: Classification level, type is int, length is 10.
<?php $SQL = " CREATE TABLE IF NOT EXISTS `cate` ( `id` int(10) NOT NULL AUTO_INCREMENT, `pid` int(10) NOT NULL COMMENT '父类id', `cate_name` varchar(30) NOT NULL, `rank` int(10) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COMMENT='分类表'"; ?>
