多对多_数据库创建脚本.sql

一款仿msdn聊天程序,用java编写,很好用!

-- 删除表
DROP TABLE person ;
DROP TABLE server ;

CREATE TABLE person
(
	pid VARCHAR(32) NOT NULL PRIMARY KEY ,
	name VARCHAR(20) NOT NULL ,
	age INT
) ;
CREATE TABLE server
(
	sid VARCHAR(32) NOT NULL PRIMARY KEY ,
	name VARCHAR(20) NOT NULL 
) ;
CREATE TABLE person_server
(
	pid VARCHAR(32) ,
	sid VARCHAR(32) ,
	FOREIGN KEY (pid) REFERENCES person(pid) ON DELETE CASCADE ,
	FOREIGN KEY (sid) REFERENCES server(sid) ON DELETE CASCADE
) ;