ddl.sql

来自「Hibernate (著译者: 陈天河等)项目开发宝典本书以Hibernate为」· SQL 代码 · 共 30 行

    alter table MESSAGE 
        drop 
        foreign key FK63B68BE75F12BC76;

    drop table if exists MESSAGE;

    drop table if exists USERINFO;

    create table MESSAGE (
        ID varchar(255) not null,
        TITLE varchar(255),
        CONTENT varchar(255),
        USER_ID varchar(255),
        primary key (ID)
    );

    create table USERINFO (
        ID varchar(255) not null,
        NAME varchar(255),
        PASSWORD varchar(255),
        primary key (ID)
    );

    alter table MESSAGE 
        add index FK63B68BE75F12BC76 (USER_ID), 
        add constraint FK63B68BE75F12BC76 
        foreign key (USER_ID) 
        references USERINFO (ID);