source:
petify-backend/src/main/resources/db/migration/V5__create_rating_domain.sql
| Last change on this file was 92e7c7a, checked in by , 8 hours ago | |
|---|---|
|
|
| File size: 203 bytes | |
| Line | |
|---|---|
| 1 | CREATE DOMAIN rating_1_5 AS int |
| 2 | CHECK (VALUE BETWEEN 1 AND 5); |
| 3 | |
| 4 | DROP VIEW IF EXISTS v_user_ratings; |
| 5 | DROP VIEW IF EXISTS v_clinic_ratings; |
| 6 | |
| 7 | ALTER TABLE reviews |
| 8 | ALTER COLUMN rating TYPE rating_1_5; |
Note:
See TracBrowser
for help on using the repository browser.
