【SQL开源代码栏目提醒】:网学会员SQL开源代码为您提供weblog.sql参考,解决您在weblog.sql学习中工作中的难题,参考学习。
-- SQL script generated by FireStorm/DAO 3.0 (build 192)
-- Visit http://www.codefutures.com/firestorm for more information
CREATE TABLE author(
id INT NOT NULL,
name VARCHAR(50) ,
pass
word VARCHAR(20) ,
primary key (id)
);
CREATE TABLE category(
id INT NOT NULL,
name VARCHAR(50) ,
primary key (id)
);
CREATE TABLE entry(
id INT NOT NULL,
title VARCHAR(50) NOT NULL,
content TEXT NOT NULL,
publish_date DATETIME NOT NULL,
category_id INT NOT NULL,
weblog_id INT NOT NULL,
author_id INT NOT NULL,
primary key (id)
);
ALTER TABLE entry ADD FOREIGN KEY (category_id) REFERENCES category (id);
ALTER TABLE entry ADD FOREIGN KEY (author_id) REFERENCES author (id);