QAg6qB2s

1--liquibase formatted sql
2--changeset aleksandra.kopera:4
3
4CREATE TABLE rooms (
5id BIGINT PRIMARY KEY ,
6room_number VARCHAR (20) NOT NULL,
7hotel_id BIGINT REFERENCES hotels(id),
8price_per_day NUMERIC(20,2) CHECK(price_per_day>=0),
9amount_of_people INTEGER NOT NULL,
10room_state INT NOT NULL DEFAULT 0 CHECK(room_state IN (0,1,2,3))
11);
12
13CREATE INDEX idx_room_amount_of_people ON rooms(amount_of_people);
14CREATE INDEX idx_room_hotel_id ON rooms(hotel_id);
15CREATE INDEX idx_room_price_per_day ON rooms(price_per_day);
16
17--rollback drop index if exists idx_room_amount_of_people;
18--rollback drop index if exists idx_room_hotel_id;
19--rollback drop index if exists idx_room_price_per_day;
20--rollback drop table rooms;