Database Design

This tutorial shows one is a classification table and the other is a news table

1, the creation of the classification table

Table name: type

create table type(

id int(11) not null primary key auto_increment,

typename varchar(255) ,

orderid int(11) ,

fid int(11))

##CHARSET=utf8;

2, Creation of news table

Table name: news

create table news(

##content text ,

##posttime int(11))

CHARSET=utf8;