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(
##id int(11) not null primary key auto_increment,typeid int(11) not null ,
title varchar(255),
source varchar(255),
picurl varchar(255),
##content text ,
##posttime int(11))
CHARSET=utf8;
