tag:github.com,2008:https://github.com/larapulse/migrator/releasesRelease notes from migrator2022-07-07T09:48:08Ztag:github.com,2008:Repository/275391249/v1.2.12022-07-07T09:51:39ZFix COLLATE issue for BLOB<p>Invalid collate for blob lead to an error</p>
<div class="snippet-clipboard-content notranslate position-relative overflow-auto" data-snippet-clipboard-copy-content="Error 1253: COLLATION 'utf8mb4_unicode_ci' is not valid for CHARACTER SET 'binary'"><pre class="notranslate"><code>Error 1253: COLLATION 'utf8mb4_unicode_ci' is not valid for CHARACTER SET 'binary'
</code></pre></div>
<p>It was fixed by removing default COLLATE for BLOB</p>SergeyPodgornyytag:github.com,2008:Repository/275391249/v1.2.02020-08-07T15:57:56ZPrecise timestamp, proper default and exported keys<ul>
<li>precision for <code>Timeable</code>. It enables microseconds for <code>timestamp</code>, <code>datetime</code> and <code>time</code></li>
<li><code>migrations</code> table has been updated to support microseconds</li>
<li>default values for expressions can be used for <code>Enum</code>, <code>JSON</code>, <code>Text</code> and <code>String</code> column types. To make an expression, use curly braces, eg. <code>(UUID())</code></li>
<li>Empty string can be used for default in <code>Enum</code>, <code>JSON</code>, <code>Text</code> and <code>String</code> column types. Use <code><empty></code> or <code><nil></code> as default value</li>
<li><code>Foreign</code> and <code>Key</code> became exported, so they can be used with <code>alterTableCommand</code></li>
</ul>SergeyPodgornyytag:github.com,2008:Repository/275391249/v1.1.32020-07-02T11:15:12ZFix documentation<p>Change <code>DropTable</code> to the <code>DropTableIfExists</code> in examples</p>
<p>Change <code>fmt</code> to <code>log</code> in README</p>SergeyPodgornyytag:github.com,2008:Repository/275391249/v1.1.22020-06-28T15:41:11ZFixed typosNo content.SergeyPodgornyytag:github.com,2008:Repository/275391249/v1.1.12020-06-28T12:37:39ZImprove documentationNo content.SergeyPodgornyytag:github.com,2008:Repository/275391249/v1.1.02020-06-28T12:23:27ZExtend table and schema commands<p>Add <code>schema</code> command:</p>
<ul>
<li><code>DropTableIfExists</code></li>
</ul>
<p>Add helper functions to the <code>table</code> to add columns:</p>
<ul>
<li><code>BinaryID()</code></li>
<li><code>Int()</code></li>
<li><code>BigInt()</code></li>
<li><code>Float()</code></li>
<li><code>FixedFloat()</code></li>
<li><code>Decimal()</code></li>
<li><code>Varchar()</code></li>
<li><code>Char()</code></li>
<li><code>Text()</code></li>
<li><code>Blob()</code></li>
<li><code>JSON()</code></li>
<li><code>Timestamp()</code></li>
<li><code>Date()</code></li>
<li><code>Time()</code></li>
<li><code>Year()</code></li>
<li><code>Binary</code></li>
<li><code>Varbinary()</code></li>
</ul>SergeyPodgornyytag:github.com,2008:Repository/275391249/v1.0.02020-06-27T22:38:28ZInitial deploy<p>Migration setup:</p>
<ul>
<li>Running migration</li>
<li>Reverting migration</li>
<li>Transactional migration</li>
</ul>
<p>Schema commands:</p>
<ul>
<li>Create table</li>
<li>Drop table</li>
<li>Rename table</li>
<li>Alter table</li>
</ul>SergeyPodgornyy