
    alter table ORDER_TOPPING 
        drop constraint FK67434416C186CB36;

    alter table ORDER_TOPPING 
        drop constraint FK674344162344FEF6;

    alter table PIZZA_ORDER 
        drop constraint FKEAB2E89784877E9E;

    drop table ORDER_TOPPING if exists;

    drop table PIZZA_ORDER if exists;

    drop table PIZZA_SIZE if exists;

    drop table SYS_TIME if exists;

    drop table TOPPING if exists;

    create table ORDER_TOPPING (
        ORDER_ID integer not null,
        TOPPING_ID integer not null
    );

    create table PIZZA_ORDER (
        ID integer generated by default as identity (start with 1),
        SIZE_ID integer not null,
        ROOM_NUMBER integer not null,
        DAY integer not null,
        STATUS integer not null,
        primary key (ID)
    );

    create table PIZZA_SIZE (
        ID integer generated by default as identity (start with 1),
        SIZE_NAME varchar(30) not null,
        primary key (ID),
        unique (SIZE_NAME)
    );

    create table SYS_TIME (
        ID integer not null,
        CURRENT_DAY integer not null,
        LAST_REPORT integer not null,
        primary key (ID)
    );

    create table TOPPING (
        ID integer generated by default as identity (start with 1),
        TOPPING_NAME varchar(30) not null,
        primary key (ID),
        unique (TOPPING_NAME)
    );

    alter table ORDER_TOPPING 
        add constraint FK67434416C186CB36 
        foreign key (TOPPING_ID) 
        references TOPPING;

    alter table ORDER_TOPPING 
        add constraint FK674344162344FEF6 
        foreign key (ORDER_ID) 
        references PIZZA_ORDER;

    alter table PIZZA_ORDER 
        add constraint FKEAB2E89784877E9E 
        foreign key (SIZE_ID) 
        references PIZZA_SIZE;
