schema-export.sql

来自「Hibernate开发及整合应用大全 蔡雪焘编著 本书用典型的示例剖析Hiber」· SQL 代码 · 共 34 行

SQL
34 行
字号
alter table certificate drop foreign key FK745F419798ABF971;alter table student drop foreign key FK8FFE823B24EDBC5F;drop table if exists certificate;drop table if exists student;drop table if exists team;create table certificate (    id varchar(255) not null,    `describe` varchar(100),    primary key (id));create table student (    id varchar(255) not null,    age integer,    name varchar(20),    cardId varchar(30),    team_id varchar(255),    primary key (id));create table team (    id varchar(255) not null,    teamName varchar(20),    primary key (id));alter table certificate     add index FK745F419798ABF971 (id),     add constraint FK745F419798ABF971     foreign key (id)     references student (id);alter table student     add index FK8FFE823B24EDBC5F (team_id),     add constraint FK8FFE823B24EDBC5F     foreign key (team_id)     references team (id);

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?