Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
- xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
- xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-2.0.xsd">
- <changeSet author="Filip Komljenovic" id="insert-example">
- <insert tableName="STRATEGIES">
- <column name="NAME" type="VARCHAR(128)">AGGRESSIVE</column>
- </insert>
- <insert tableName="STRATEGIES">
- <column name="NAME" type="VARCHAR(128)">CHILLY</column>
- </insert>
- <insert tableName="CITIES">
- <column name="NAME" type="VARCHAR(128)">Zagreb</column>
- </insert>
- <insert tableName="CITIES">
- <column name="NAME" type="VARCHAR(128)">Rijeka</column>
- </insert>
- <insert tableName="CITIES">
- <column name="NAME" type="VARCHAR(128)">Dubrovnik</column>
- </insert>
- <insert tableName="CITIES">
- <column name="NAME" type="VARCHAR(128)">Split</column>
- </insert>
- <insert tableName="GARAGES">
- <column name="ID" type="UUID">f6801a10-9c6e-11e8-98d0-529269fb1459</column>
- <column name="NAME" type="VARCHAR(128)">CROZ garaža</column>
- <column name="LONGITUDE" type="FLOAT8">45.7941076</column>
- <column name="LATITUDE" type="FLOAT8">15.9991855</column>
- <column name="CAPACITY" type="SMALLINT">200</column>
- <column name="USER_UUID" type="UUID">f6801a10-9c6e-11e8-98d0-529269fb1459</column>
- <column name="ADDRESS" type="VARCHAR(128)">Lastovska 23</column>
- <column name="FIXED_PRICE" type="BOOLEAN">true</column>
- <column name="WORKING_TIME_START" type="TIME">00:00:00</column>
- <column name="WORKING_TIME_END" type="TIME">23:59:59</column>
- <column name="RESERVATION" type="BOOLEAN">false</column>
- <column name="STRATEGY_ID" type="BIGINT">1</column>
- <column name="CITY_ID" type="BIGINT">1</column>
- <column name="IBAN" type="VARCHAR(40)">HR1723600001101234565</column>
- </insert>
- <insert tableName="GARAGES">
- <column name="ID" type="UUID">f6801a10-9c6e-11e8-98d0-529269fb1450</column>
- <column name="NAME" type="VARCHAR(128)">Langov Trg Garage</column>
- <column name="LONGITUDE" type="FLOAT8">45.8146548</column>
- <column name="LATITUDE" type="FLOAT8">15.9819337</column>
- <column name="CAPACITY" type="SMALLINT">150</column>
- <column name="USER_UUID" type="UUID">f6801a10-9c6e-11e8-98d0-529269fb1459</column>
- <column name="ADDRESS" type="VARCHAR(128)">Trg Josipa Langa 13</column>
- <column name="FIXED_PRICE" type="BOOLEAN">true</column>
- <column name="WORKING_TIME_START" type="TIME">00:00:00</column>
- <column name="WORKING_TIME_END" type="TIME">23:59:59</column>
- <column name="RESERVATION" type="BOOLEAN">false</column>
- <column name="STRATEGY_ID" type="BIGINT">1</column>
- <column name="CITY_ID" type="BIGINT">1</column>
- <column name="IBAN" type="VARCHAR(40)">HR1723600001101234565</column>
- </insert>
- <insert tableName="GARAGES">
- <column name="ID" type="UUID">f6801a10-9c6e-11e8-98d0-529269fb1452</column>
- <column name="NAME" type="VARCHAR(128)">Green gold Parking garage</column>
- <column name="LONGITUDE" type="FLOAT8">45.8022853</column>
- <column name="LATITUDE" type="FLOAT8">16.0025132</column>
- <column name="CAPACITY" type="SMALLINT">300</column>
- <column name="USER_UUID" type="UUID">f6801a10-9c6e-11e8-98d0-529269fb1459</column>
- <column name="ADDRESS" type="VARCHAR(128)">Radnička cesta 52</column>
- <column name="FIXED_PRICE" type="BOOLEAN">false</column>
- <column name="WORKING_TIME_START" type="TIME">00:00:00</column>
- <column name="WORKING_TIME_END" type="TIME">23:59:59</column>
- <column name="RESERVATION" type="BOOLEAN">true</column>
- <column name="STRATEGY_ID" type="BIGINT">2</column>
- <column name="CITY_ID" type="BIGINT">1</column>
- <column name="IBAN" type="VARCHAR(40)">BR1500000000000010932840814P2</column>
- </insert>
- <insert tableName="GARAGES">
- <column name="ID" type="UUID">f6801a10-9c6e-11e8-98d0-529269fb1451</column>
- <column name="NAME" type="VARCHAR(128)">Best in Parking</column>
- <column name="LONGITUDE" type="FLOAT8">12.1123</column>
- <column name="LATITUDE" type="FLOAT8">99.0012</column>
- <column name="CAPACITY" type="SMALLINT">300</column>
- <column name="USER_UUID" type="UUID">f6801a10-9c6e-11e8-98d0-529269fb1459</column>
- <column name="ADDRESS" type="VARCHAR(128)">Trg Petra Preradovića</column>
- <column name="FIXED_PRICE" type="BOOLEAN">true</column>
- <column name="WORKING_TIME_START" type="TIME">00:00:00</column>
- <column name="WORKING_TIME_END" type="TIME">23:59:59</column>
- <column name="RESERVATION" type="BOOLEAN">false</column>
- <column name="STRATEGY_ID" type="BIGINT">2</column>
- <column name="CITY_ID" type="BIGINT">3</column>
- <column name="IBAN" type="VARCHAR(40)">BA275680000123456789</column>
- </insert>
- <insert tableName="PRICES">
- <column name="GARAGE_ID" type="UUID">f6801a10-9c6e-11e8-98d0-529269fb1459</column>
- <column name="TIME_START" type="TIME">00:00:00</column>
- <column name="TIME_END" type="TIME">23:59:59</column>
- <column name="AMOUNT" type="DECIMAL(19,2)">5.45</column>
- <column name="CURRENCY" type="VARCHAR(3)">HRK</column>
- </insert>
- <insert tableName="PRICES">
- <column name="GARAGE_ID" type="UUID">f6801a10-9c6e-11e8-98d0-529269fb1450</column>
- <column name="TIME_START" type="TIME">00:00:00</column>
- <column name="TIME_END" type="TIME">23:59:59</column>
- <column name="AMOUNT" type="DECIMAL(19,2)">4</column>
- <column name="CURRENCY" type="VARCHAR(3)">USD</column>
- </insert>
- <insert tableName="PRICES">
- <column name="GARAGE_ID" type="UUID">f6801a10-9c6e-11e8-98d0-529269fb1451</column>
- <column name="TIME_START" type="TIME">00:00:00</column>
- <column name="TIME_END" type="TIME">23:59:59</column>
- <column name="AMOUNT" type="DECIMAL(19,2)">8</column>
- <column name="CURRENCY" type="VARCHAR(3)">EUR</column>
- </insert>
- <insert tableName="PRICES_OPTIMISED">
- <column name="GARAGE_ID" type="UUID">f6801a10-9c6e-11e8-98d0-529269fb1452</column>
- <column name="TIME_START" type="TIME">00:00:00</column>
- <column name="TIME_END" type="TIME">23:59:59</column>
- <column name="CURRENT_PRICE_AMOUNT" type="DECIMAL(19,2)">4.50</column>
- <column name="MIN_PRICE_AMOUNT" type="DECIMAL(19,2)">1</column>
- <column name="MAX_PRICE_AMOUNT" type="DECIMAL(19,2)">10</column>
- <column name="CURRENCY" type="VARCHAR(3)">HRK</column>
- </insert>
- <insert tableName="RESERVATIONS">
- <column name="VEHICLE_ID" type="BIGINT">1</column>
- <column name="GARAGE_ID" type="UUID">f6801a10-9c6e-11e8-98d0-529269fb1452</column>
- <column name="TIME_START" type="TIME">16:00:00</column>
- <column name="TIME_END" type="TIME">16:30:00</column>
- <column name="PRICE" type="SMALLINT">5</column>
- </insert>
- <insert tableName="VEHICLE_TYPES">
- <column name="TYPE" type="VARCHAR(128)">CAR</column>
- </insert>
- <insert tableName="VEHICLE_TYPES">
- <column name="TYPE" type="VARCHAR(128)">VAN</column>
- </insert>
- <insert tableName="VEHICLE_TYPES">
- <column name="TYPE" type="VARCHAR(128)">MOTORCYCLE</column>
- </insert>
- <insert tableName="VEHICLE_TYPES">
- <column name="TYPE" type="VARCHAR(128)">BUS</column>
- </insert>
- <insert tableName="REVIEWS">
- <column name="EMAIL" type="VARCHAR(128)">ivovlasnik@gmail.com</column>
- <column name="GARAGE_ID" type="BIGINT">f6801a10-9c6e-11e8-98d0-529269fb1459</column>
- <column name="TIME" type="TIME">16:00:00</column>
- <column name="TEXT" type="CLOB">Super kul garaža</column>
- <column name="GRADE" type="SMALLINT">3</column>
- </insert>
- <insert tableName="REVIEWS">
- <column name="EMAIL" type="VARCHAR(128)">ivovlasnik@gmail.com</column>
- <column name="GARAGE_ID" type="BIGINT">f6801a10-9c6e-11e8-98d0-529269fb1451</column>
- <column name="TIME" type="TIME">16:00:00</column>
- <column name="TEXT" type="CLOB">The best</column>
- <column name="GRADE" type="SMALLINT">5</column>
- </insert>
- <insert tableName="REVIEWS">
- <column name="EMAIL" type="VARCHAR(128)">ivovlasnik@gmail.com</column>
- <column name="GARAGE_ID" type="BIGINT">f6801a10-9c6e-11e8-98d0-529269fb1451</column>
- <column name="TIME" type="TIME">16:00:00</column>
- <column name="TEXT" type="CLOB">Super kul garaža</column>
- <column name="GRADE" type="SMALLINT">4</column>
- </insert>
- <insert tableName="REVIEWS">
- <column name="EMAIL" type="VARCHAR(128)">j@j.com</column>
- <column name="GARAGE_ID" type="BIGINT">f6801a10-9c6e-11e8-98d0-529269fb1452</column>
- <column name="TIME" type="TIME">16:00:00</column>
- <column name="TEXT" type="CLOB">Not the best</column>
- <column name="GRADE" type="SMALLINT">5</column>
- </insert>
- <insert tableName="GARAGES_VEHICLE_TYPES">
- <column name="GARAGE_ID" type="UUID">f6801a10-9c6e-11e8-98d0-529269fb1459</column>
- <column name="VEHICLE_TYPE_ID" type="BIGINT">1</column>
- </insert>
- <insert tableName="GARAGES_VEHICLE_TYPES">
- <column name="GARAGE_ID" type="UUID">f6801a10-9c6e-11e8-98d0-529269fb1450</column>
- <column name="VEHICLE_TYPE_ID" type="BIGINT">2</column>
- </insert>
- <insert tableName="GARAGES_VEHICLE_TYPES">
- <column name="GARAGE_ID" type="UUID">f6801a10-9c6e-11e8-98d0-529269fb1451</column>
- <column name="VEHICLE_TYPE_ID" type="BIGINT">3</column>
- </insert>
- <insert tableName="GARAGES_VEHICLE_TYPES">
- <column name="GARAGE_ID" type="UUID">f6801a10-9c6e-11e8-98d0-529269fb1452</column>
- <column name="VEHICLE_TYPE_ID" type="BIGINT">1</column>
- </insert>
- </changeSet>
- </databaseChangeLog>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement