src/resources/db_update_script.xml

   1 <?xml version="1.0" encoding="UTF-8" standalone="no"?>\r
   2 <databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog/1.9" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog/1.9 http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-1.9.xsd">\r
   3     <changeSet author="yuki (generated)" id="1258025189836-1">\r
   4         <createTable schemaName="PUBLIC" tableName="NICOCONTENT">\r
   5             <column name="ID" type="DECIMAL(19,0)">\r
   6                 <constraints nullable="false" primaryKey="true" primaryKeyName="PRIMARY_KEY_4"/>\r
   7             </column>\r
   8             <column name="CONVERTEDMP4" type="DECIMAL(1,0)">\r
   9                 <constraints nullable="false"/>\r
  10             </column>\r
  11             <column name="NICOID" type="VARCHAR(255)">\r
  12                 <constraints nullable="false"/>\r
  13             </column>\r
  14             <column name="FILENAME" type="VARCHAR(255)"/>\r
  15             <column name="CONVERTEDMP3" type="DECIMAL(1,0)">\r
  16                 <constraints nullable="false"/>\r
  17             </column>\r
  18             <column name="TITLE" type="VARCHAR(255)"/>\r
  19             <column name="PAGELINK" type="VARCHAR(255)"/>\r
  20             <column name="VERSION" type="DECIMAL(19,0)"/>\r
  21             <column name="FAILTIMES" type="DECIMAL(10,0)"/>\r
  22             <column name="STATUS" type="DECIMAL(10,0)">\r
  23                 <constraints nullable="false"/>\r
  24             </column>\r
  25         </createTable>\r
  26     </changeSet>\r
  27     <changeSet author="yuki (generated)" id="1258025189836-2">\r
  28         <createTable schemaName="PUBLIC" tableName="SEQUENCE">\r
  29             <column name="SEQ_NAME" type="VARCHAR(50)">\r
  30                 <constraints nullable="false" primaryKey="true" primaryKeyName="PRIMARY_KEY_7"/>\r
  31             </column>\r
  32             <column name="SEQ_COUNT" type="DECIMAL(19,0)"/>\r
  33         </createTable>\r
  34         <insert schemaName="PUBLIC" tableName="SEQUENCE">\r
  35             <column name="SEQ_NAME" value="SEQ_GEN"/>\r
  36             <column name="SEQ_COUNT" valueNumeric="1"/>\r
  37         </insert>\r
  38     </changeSet>\r
  39     <changeSet author="yuki" id="1">\r
  40         <addColumn schemaName="PUBLIC" tableName="NICOCONTENT">\r
  41             <column name="AUTHOR" type="VARCHAR(255)"/>\r
  42         </addColumn>\r
  43     </changeSet>\r
  44 </databaseChangeLog>\r