ColorRecipesExplorer
/
Database-Manager
1
0
Fork 0
Code Issues Pull Requests Projects Releases Wiki Activity

Compare commits

base: ColorRecipesExplorer:release/6.2
Branches Tags
ColorRecipesExplorer:master
ColorRecipesExplorer:develop
ColorRecipesExplorer:release/6.2
ColorRecipesExplorer:release/6.1
ColorRecipesExplorer:release/6.0.0
ColorRecipesExplorer:release/5.2.1
..
compare: ColorRecipesExplorer:master
Branches Tags
ColorRecipesExplorer:develop
ColorRecipesExplorer:release/6.2
ColorRecipesExplorer:release/6.1
ColorRecipesExplorer:master
ColorRecipesExplorer:release/6.0.0
ColorRecipesExplorer:release/5.2.1

2 Commits
release/6. ... master

Author SHA1 Message Date
William Nolin a762d8372f Merge pull request 'Add version 6.0 with new mix types' (#2) from develop into master
continuous-integration/drone Build is passing Details 
Reviewed-on: #2
 2022-04-10 23:46:49 -04:00
William Nolin be6b1941b3 Merge pull request 'Move to Drone CI and Archiva' (#1) from develop into master
continuous-integration/drone/push Build is passing Details 
Reviewed-on: #1
 2021-09-11 23:39:36 -04:00
2 changed files with 1 additions and 68 deletions
Show Stats Expand all files Collapse all files

2
build.gradle.kts
View File

@ -1,7 +1,7 @@
import org.jetbrains.kotlin.gradle.tasks.KotlinCompile
group = "dev.fyloz.colorrecipesexplorer"
version = "6.2"
version = "6.0"
plugins {
kotlin("jvm") version "1.6.20"

67
src/main/resources/changelogs/changelog.6.xml
View File

@ -27,73 +27,6 @@
</changeSet>
<changeSet id="4" author="william">
<sql>
UPDATE mix_type mt
LEFT JOIN material m
ON m.id = mt.material_id
LEFT JOIN material_type mmt ON mmt.id = m.material_type_id
SET mt.material_type_id = mmt.id
</sql>
</changeSet>
<changeSet id="5" author="william">
<dropNotNullConstraint tableName="mix_type" columnName="material_id" columnDataType="bigint"/>
<addNotNullConstraint tableName="mix_type" columnName="material_type_id" columnDataType="bigint"/>
</changeSet>
<changeSet id="6" author="william">
<createTable tableName="mix_mix_type">
<column name="id" type="bigint" autoIncrement="true">
<constraints nullable="false" primaryKey="true"/>
</column>
<column name="quantity" type="double">
<constraints nullable="false"/>
</column>
<column name="position" type="int" defaultOnNull="0">
<constraints nullable="false"/>
</column>
<column name="mix_type_id" type="bigint">
<constraints nullable="false"/>
</column>
<column name="mix_id" type="bigint">
<constraints nullable="false"/>
</column>
</createTable>
<createIndex tableName="mix_mix_type" indexName="ix_mix_mix_type_mix_type_id">
<column name="mix_type_id"/>
</createIndex>
<createIndex tableName="mix_mix_type" indexName="ix_mix_mix_type_mix_id">
<column name="mix_id"/>
</createIndex>
<addForeignKeyConstraint baseColumnNames="mix_type_id" baseTableName="mix_mix_type"
constraintName="fk_mix_mix_type_mix_type_mix_type_id"
referencedColumnNames="id" referencedTableName="mix_type"/>
<addForeignKeyConstraint baseColumnNames="mix_id" baseTableName="mix_mix_type"
constraintName="fk_mix_mix_type_mix_mix_id"
referencedColumnNames="id" referencedTableName="mix"/>
</changeSet>
<changeSet id="7" author="william">
<sql>
INSERT INTO mix_mix_type (mix_type_id, mix_id, quantity, position)
SELECT mm.mix_type_id, mm.mix_id, mm.quantity, mm.position
FROM (SELECT mt.id as mix_type_id, mm.mix_id, mm.quantity, mm.position
FROM mix_material mm
LEFT JOIN mix_type mt ON mt.material_id = mm.material_id) AS mm
WHERE mm.mix_type_id IS NOT NULL;
</sql>
</changeSet>
<changeSet id="8" author="william">
<update tableName="updater_metadata">
<column name="metadata_value" value="6"/>
<where>metadata_key='version'</where>
</update>
<rollback>
<update tableName="updater_metadata">
<column name="metadata_value" value="5"/>
<where>metadata_key='version'</where>
</update>
</rollback>
</changeSet>
</databaseChangeLog>