日期:2014-05-17 浏览次数:21039 次
create table Type(tpid int PRIMARY KEY GENERATED ALWAYS AS IDENTITY (START WITH 1,INCREMENT BY 1),tpname varchar(20) ,UNIQUE(tpname)) create table Servers(id int PRIMARY KEY GENERATED ALWAYS AS IDENTITY (START WITH 1,INCREMENT BY 1),address varchar(20),ip varchar(16),name varchar(20),password varchar(20),type int, dbs long varchar, UNIQUE(ip),FOREIGN KEY(type) references Type(tpid))