server/samserver/src/main/resources/config/liquibase/changelog/20180210112802_added_entity_PolicyType.xml

   1 <?xml version="1.0" encoding="utf-8"?>
   2 <databaseChangeLog
   3     xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
   4     xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext"
   5     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
   6     xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.5.xsd
   7                         http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd">
   8
   9     <property name="now" value="now()" dbms="h2"/>
  10
  11     <property name="now" value="current_timestamp" dbms="postgresql"/>
  12
  13     <property name="floatType" value="float4" dbms="postgresql, h2"/>
  14     <property name="floatType" value="float" dbms="mysql, oracle, mssql"/>
  15
  16     <!--
  17         Added the entity PolicyType.
  18     -->
  19     <changeSet id="20180210112802-1" author="jhipster">
  20         <createTable tableName="policy_type">
  21             <column name="id" type="bigint" autoIncrement="${autoIncrement}">
  22                 <constraints primaryKey="true" nullable="false"/>
  23             </column>
  24             <column name="name" type="varchar(255)">
  25                 <constraints nullable="true" />
  26             </column>
  27
  28             <column name="descr" type="varchar(255)">
  29                 <constraints nullable="true" />
  30             </column>
  31
  32             <column name="category" type="varchar(255)">
  33                 <constraints nullable="true" />
  34             </column>
  35
  36             <column name="opt" type="varchar(255)">
  37                 <constraints nullable="true" />
  38             </column>
  39
  40             <column name="defval" type="varchar(1023)">
  41                 <constraints nullable="true" />
  42             </column>
  43
  44             <column name="supported" type="varchar(1)">
  45                 <constraints nullable="true" />
  46             </column>
  47
  48             <column name="mapping" type="varchar(255)">
  49                 <constraints nullable="true" />
  50             </column>
  51
  52             <column name="uitype" type="varchar(255)">
  53                 <constraints nullable="true" />
  54             </column>
  55
  56             <!-- jhipster-needle-liquibase-add-column - JHipster will add columns here, do not remove-->
  57         </createTable>
  58
  59         <loadData encoding="UTF-8"
  60                   file="config/liquibase/changelog/policytype.csv"
  61                   separator=";"
  62                   tableName="policy_type">
  63         </loadData>
  64
  65     </changeSet>
  66     <!-- jhipster-needle-liquibase-add-changeset - JHipster will add changesets here, do not remove-->
  67 </databaseChangeLog>