cyberpresidentvanellope/tgstation-server
1
0
Fork 0
mirror of https://github.com/tgstation/tgstation-server.git synced 2026-08-24 21:46:52 +01:00
Code Issues Packages Projects Releases Wiki Activity
Files
gh-pages
tgstation-server/20180906135553___m_s_initial_create_8cs_source.html
T

753 lines
113 KiB
HTML
Raw Permalink Blame History

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "https://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="en-US">
<head>
<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
<meta http-equiv="X-UA-Compatible" content="IE=11"/>
<meta name="generator" content="Doxygen 1.9.8"/>
<meta name="viewport" content="width=device-width, initial-scale=1"/>
<title>tgstation-server: src/Tgstation.Server.Host/Database/Migrations/20180906135553_MSInitialCreate.cs Source File</title>
<link href="tabs.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="dynsections.js"></script>
<link href="search/search.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="search/searchdata.js"></script>
<script type="text/javascript" src="search/search.js"></script>
<link href="doxygen.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div id="top"><!-- do not remove this div, it is closed by doxygen! -->
<div id="titlearea">
<table cellspacing="0" cellpadding="0">
<tbody>
<tr id="projectrow">
<td id="projectalign">
<div id="projectname">tgstation-server<span id="projectnumber">&#160;6.19.3</span>
</div>
<div id="projectbrief">The /tg/station 13 server suite</div>
</td>
</tr>
</tbody>
</table>
</div>
<!-- end header part -->
<!-- Generated by Doxygen 1.9.8 -->
<script type="text/javascript">
/* @license magnet:?xt=urn:btih:d3d9a9a6595521f9666a5e94cc830dab83b65699&amp;dn=expat.txt MIT */
var searchBox = new SearchBox("searchBox", "search/",'.html');
/* @license-end */
</script>
<script type="text/javascript" src="menudata.js"></script>
<script type="text/javascript" src="menu.js"></script>
<script type="text/javascript">
/* @license magnet:?xt=urn:btih:d3d9a9a6595521f9666a5e94cc830dab83b65699&amp;dn=expat.txt MIT */
$(function() {
initMenu('',true,false,'search.php','Search');
$(document).ready(function() { init_search(); });
});
/* @license-end */
</script>
<div id="main-nav"></div>
<script type="text/javascript">
/* @license magnet:?xt=urn:btih:d3d9a9a6595521f9666a5e94cc830dab83b65699&amp;dn=expat.txt MIT */
$(document).ready(function() { init_codefold(0); });
/* @license-end */
</script>
<!-- window showing the filter options -->
<div id="MSearchSelectWindow"
onmouseover="return searchBox.OnSearchSelectShow()"
onmouseout="return searchBox.OnSearchSelectHide()"
onkeydown="return searchBox.OnSearchSelectKey(event)">
</div>
<!-- iframe showing the search results (closed by default) -->
<div id="MSearchResultsWindow">
<div id="MSearchResults">
<div class="SRPage">
<div id="SRIndex">
<div id="SRResults"></div>
<div class="SRStatus" id="Loading">Loading...</div>
<div class="SRStatus" id="Searching">Searching...</div>
<div class="SRStatus" id="NoMatches">No Matches</div>
</div>
</div>
</div>
</div>
<div id="nav-path" class="navpath">
<ul>
<li class="navelem"><a class="el" href="dir_68267d1309a1af8e8297ef4c3efbcdba.html">src</a></li><li class="navelem"><a class="el" href="dir_34761767c1c3cd212f9d2f80ea0828a8.html">Tgstation.Server.Host</a></li><li class="navelem"><a class="el" href="dir_3a3ab2f663730d5bed7026cf41734e8a.html">Database</a></li><li class="navelem"><a class="el" href="dir_6a8d19239e99965ecc1391ebd049009a.html">Migrations</a></li> </ul>
</div>
</div><!-- top -->
<div class="header">
<div class="headertitle"><div class="title">20180906135553_MSInitialCreate.cs</div></div>
</div><!--header-->
<div class="contents">
<a href="20180906135553___m_s_initial_create_8cs.html">Go to the documentation of this file.</a><div class="fragment"><div class="line"><a id="l00001" name="l00001"></a><span class="lineno"> 1</span><span class="keyword">using </span>System;</div>
<div class="line"><a id="l00002" name="l00002"></a><span class="lineno"> 2</span> </div>
<div class="line"><a id="l00003" name="l00003"></a><span class="lineno"> 3</span><span class="keyword">using </span>Microsoft.EntityFrameworkCore.Metadata;</div>
<div class="line"><a id="l00004" name="l00004"></a><span class="lineno"> 4</span><span class="keyword">using </span>Microsoft.EntityFrameworkCore.Migrations;</div>
<div class="line"><a id="l00005" name="l00005"></a><span class="lineno"> 5</span> </div>
<div class="foldopen" id="foldopen00006" data-start="{" data-end="}">
<div class="line"><a id="l00006" name="l00006"></a><span class="lineno"><a class="line" href="namespace_tgstation_1_1_server_1_1_host_1_1_database_1_1_migrations.html"> 6</a></span><span class="keyword">namespace </span><a class="code hl_namespace" href="namespace_tgstation_1_1_server_1_1_host_1_1_database_1_1_migrations.html">Tgstation.Server.Host.Database.Migrations</a></div>
<div class="line"><a id="l00007" name="l00007"></a><span class="lineno"> 7</span>{</div>
<div class="line"><a id="l00011" name="l00011"></a><span class="lineno"> 11</span><span class="preprocessor">#pragma warning disable CA1506</span></div>
<div class="foldopen" id="foldopen00012" data-start="{" data-end="};">
<div class="line"><a id="l00012" name="l00012"></a><span class="lineno"><a class="line" href="class_tgstation_1_1_server_1_1_host_1_1_database_1_1_migrations_1_1_m_s_initial_create.html"> 12</a></span> <span class="keyword">public</span> <span class="keyword">partial class </span><a class="code hl_class" href="class_tgstation_1_1_server_1_1_host_1_1_database_1_1_migrations_1_1_m_s_initial_create.html">MSInitialCreate</a> : <a class="code hl_class" href="class_migration.html">Migration</a></div>
<div class="line"><a id="l00013" name="l00013"></a><span class="lineno"> 13</span> {</div>
<div class="foldopen" id="foldopen00015" data-start="{" data-end="}">
<div class="line"><a id="l00015" name="l00015"></a><span class="lineno"><a class="line" href="class_tgstation_1_1_server_1_1_host_1_1_database_1_1_migrations_1_1_m_s_initial_create.html#a7df7a394603b58660e31804151c6b596"> 15</a></span> <span class="keyword">protected</span> <span class="keyword">override</span> <span class="keywordtype">void</span> <a class="code hl_function" href="class_tgstation_1_1_server_1_1_host_1_1_database_1_1_migrations_1_1_m_s_initial_create.html#a7df7a394603b58660e31804151c6b596">Up</a>(MigrationBuilder migrationBuilder)</div>
<div class="line"><a id="l00016" name="l00016"></a><span class="lineno"> 16</span> {</div>
<div class="line"><a id="l00017" name="l00017"></a><span class="lineno"> 17</span> ArgumentNullException.ThrowIfNull(migrationBuilder);</div>
<div class="line"><a id="l00018" name="l00018"></a><span class="lineno"> 18</span> </div>
<div class="line"><a id="l00019" name="l00019"></a><span class="lineno"> 19</span> migrationBuilder.CreateTable(</div>
<div class="line"><a id="l00020" name="l00020"></a><span class="lineno"> 20</span> name: <span class="stringliteral">&quot;Users&quot;</span>,</div>
<div class="line"><a id="l00021" name="l00021"></a><span class="lineno"> 21</span> columns: table =&gt; <span class="keyword">new</span></div>
<div class="line"><a id="l00022" name="l00022"></a><span class="lineno"> 22</span> {</div>
<div class="line"><a id="l00023" name="l00023"></a><span class="lineno"> 23</span> Id = table.Column&lt;<span class="keywordtype">long</span>&gt;(nullable: <span class="keyword">false</span>)</div>
<div class="line"><a id="l00024" name="l00024"></a><span class="lineno"> 24</span> .Annotation(<span class="stringliteral">&quot;SqlServer:ValueGenerationStrategy&quot;</span>, SqlServerValueGenerationStrategy.IdentityColumn),</div>
<div class="line"><a id="l00025" name="l00025"></a><span class="lineno"> 25</span> <a class="code hl_enumvalue" href="namespace_tgstation_1_1_server_1_1_host.html#a71712cdd4f38be5482e1d08905c0c308a00d23a76e43b46dae9ec7aa9dcbebb32">Enabled</a> = table.Column&lt;<span class="keywordtype">bool</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00026" name="l00026"></a><span class="lineno"> 26</span> CreatedAt = table.Column&lt;DateTimeOffset&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00027" name="l00027"></a><span class="lineno"> 27</span> SystemIdentifier = table.Column&lt;<span class="keywordtype">string</span>&gt;(nullable: <span class="keyword">true</span>),</div>
<div class="line"><a id="l00028" name="l00028"></a><span class="lineno"> 28</span> Name = table.Column&lt;<span class="keywordtype">string</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00029" name="l00029"></a><span class="lineno"> 29</span> AdministrationRights = table.Column&lt;decimal&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00030" name="l00030"></a><span class="lineno"> 30</span> InstanceManagerRights = table.Column&lt;decimal&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00031" name="l00031"></a><span class="lineno"> 31</span> PasswordHash = table.Column&lt;<span class="keywordtype">string</span>&gt;(nullable: <span class="keyword">true</span>),</div>
<div class="line"><a id="l00032" name="l00032"></a><span class="lineno"> 32</span> CreatedById = table.Column&lt;<span class="keywordtype">long</span>&gt;(nullable: <span class="keyword">true</span>),</div>
<div class="line"><a id="l00033" name="l00033"></a><span class="lineno"> 33</span> CanonicalName = table.Column&lt;<span class="keywordtype">string</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00034" name="l00034"></a><span class="lineno"> 34</span> LastPasswordUpdate = table.Column&lt;DateTimeOffset&gt;(nullable: <span class="keyword">true</span>),</div>
<div class="line"><a id="l00035" name="l00035"></a><span class="lineno"> 35</span> },</div>
<div class="line"><a id="l00036" name="l00036"></a><span class="lineno"> 36</span> constraints: table =&gt;</div>
<div class="line"><a id="l00037" name="l00037"></a><span class="lineno"> 37</span> {</div>
<div class="line"><a id="l00038" name="l00038"></a><span class="lineno"> 38</span> table.PrimaryKey(<span class="stringliteral">&quot;PK_Users&quot;</span>, x =&gt; x.Id);</div>
<div class="line"><a id="l00039" name="l00039"></a><span class="lineno"> 39</span> table.ForeignKey(</div>
<div class="line"><a id="l00040" name="l00040"></a><span class="lineno"> 40</span> name: <span class="stringliteral">&quot;FK_Users_Users_CreatedById&quot;</span>,</div>
<div class="line"><a id="l00041" name="l00041"></a><span class="lineno"> 41</span> column: x =&gt; x.CreatedById,</div>
<div class="line"><a id="l00042" name="l00042"></a><span class="lineno"> 42</span> principalTable: <span class="stringliteral">&quot;Users&quot;</span>,</div>
<div class="line"><a id="l00043" name="l00043"></a><span class="lineno"> 43</span> principalColumn: <span class="stringliteral">&quot;Id&quot;</span>,</div>
<div class="line"><a id="l00044" name="l00044"></a><span class="lineno"> 44</span> onDelete: ReferentialAction.Restrict);</div>
<div class="line"><a id="l00045" name="l00045"></a><span class="lineno"> 45</span> });</div>
<div class="line"><a id="l00046" name="l00046"></a><span class="lineno"> 46</span> </div>
<div class="line"><a id="l00047" name="l00047"></a><span class="lineno"> 47</span> migrationBuilder.CreateTable(</div>
<div class="line"><a id="l00048" name="l00048"></a><span class="lineno"> 48</span> name: <span class="stringliteral">&quot;ChatChannels&quot;</span>,</div>
<div class="line"><a id="l00049" name="l00049"></a><span class="lineno"> 49</span> columns: table =&gt; <span class="keyword">new</span></div>
<div class="line"><a id="l00050" name="l00050"></a><span class="lineno"> 50</span> {</div>
<div class="line"><a id="l00051" name="l00051"></a><span class="lineno"> 51</span> IrcChannel = table.Column&lt;<span class="keywordtype">string</span>&gt;(nullable: <span class="keyword">true</span>),</div>
<div class="line"><a id="l00052" name="l00052"></a><span class="lineno"> 52</span> DiscordChannelId = table.Column&lt;decimal&gt;(nullable: <span class="keyword">true</span>),</div>
<div class="line"><a id="l00053" name="l00053"></a><span class="lineno"> 53</span> IsAdminChannel = table.Column&lt;<span class="keywordtype">bool</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00054" name="l00054"></a><span class="lineno"> 54</span> IsWatchdogChannel = table.Column&lt;<span class="keywordtype">bool</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00055" name="l00055"></a><span class="lineno"> 55</span> IsUpdatesChannel = table.Column&lt;<span class="keywordtype">bool</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00056" name="l00056"></a><span class="lineno"> 56</span> Tag = table.Column&lt;<span class="keywordtype">string</span>&gt;(nullable: <span class="keyword">true</span>),</div>
<div class="line"><a id="l00057" name="l00057"></a><span class="lineno"> 57</span> Id = table.Column&lt;<span class="keywordtype">long</span>&gt;(nullable: <span class="keyword">false</span>)</div>
<div class="line"><a id="l00058" name="l00058"></a><span class="lineno"> 58</span> .Annotation(<span class="stringliteral">&quot;SqlServer:ValueGenerationStrategy&quot;</span>, SqlServerValueGenerationStrategy.IdentityColumn),</div>
<div class="line"><a id="l00059" name="l00059"></a><span class="lineno"> 59</span> ChatSettingsId = table.Column&lt;<span class="keywordtype">long</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00060" name="l00060"></a><span class="lineno"> 60</span> },</div>
<div class="line"><a id="l00061" name="l00061"></a><span class="lineno"> 61</span> constraints: table =&gt;</div>
<div class="line"><a id="l00062" name="l00062"></a><span class="lineno"> 62</span> {</div>
<div class="line"><a id="l00063" name="l00063"></a><span class="lineno"> 63</span> table.PrimaryKey(<span class="stringliteral">&quot;PK_ChatChannels&quot;</span>, x =&gt; x.Id);</div>
<div class="line"><a id="l00064" name="l00064"></a><span class="lineno"> 64</span> });</div>
<div class="line"><a id="l00065" name="l00065"></a><span class="lineno"> 65</span> </div>
<div class="line"><a id="l00066" name="l00066"></a><span class="lineno"> 66</span> migrationBuilder.CreateTable(</div>
<div class="line"><a id="l00067" name="l00067"></a><span class="lineno"> 67</span> name: <span class="stringliteral">&quot;ReattachInformations&quot;</span>,</div>
<div class="line"><a id="l00068" name="l00068"></a><span class="lineno"> 68</span> columns: table =&gt; <span class="keyword">new</span></div>
<div class="line"><a id="l00069" name="l00069"></a><span class="lineno"> 69</span> {</div>
<div class="line"><a id="l00070" name="l00070"></a><span class="lineno"> 70</span> ChatCommandsJson = table.Column&lt;<span class="keywordtype">string</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00071" name="l00071"></a><span class="lineno"> 71</span> ChatChannelsJson = table.Column&lt;<span class="keywordtype">string</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00072" name="l00072"></a><span class="lineno"> 72</span> ServerCommandsJson = table.Column&lt;<span class="keywordtype">string</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00073" name="l00073"></a><span class="lineno"> 73</span> AccessIdentifier = table.Column&lt;<span class="keywordtype">string</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00074" name="l00074"></a><span class="lineno"> 74</span> ProcessId = table.Column&lt;<span class="keywordtype">int</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00075" name="l00075"></a><span class="lineno"> 75</span> IsPrimary = table.Column&lt;<span class="keywordtype">bool</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00076" name="l00076"></a><span class="lineno"> 76</span> Port = table.Column&lt;<span class="keywordtype">int</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00077" name="l00077"></a><span class="lineno"> 77</span> RebootState = table.Column&lt;<span class="keywordtype">int</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00078" name="l00078"></a><span class="lineno"> 78</span> Id = table.Column&lt;<span class="keywordtype">long</span>&gt;(nullable: <span class="keyword">false</span>)</div>
<div class="line"><a id="l00079" name="l00079"></a><span class="lineno"> 79</span> .Annotation(<span class="stringliteral">&quot;SqlServer:ValueGenerationStrategy&quot;</span>, SqlServerValueGenerationStrategy.IdentityColumn),</div>
<div class="line"><a id="l00080" name="l00080"></a><span class="lineno"> 80</span> CompileJobId = table.Column&lt;<span class="keywordtype">long</span>&gt;(nullable: <span class="keyword">true</span>),</div>
<div class="line"><a id="l00081" name="l00081"></a><span class="lineno"> 81</span> },</div>
<div class="line"><a id="l00082" name="l00082"></a><span class="lineno"> 82</span> constraints: table =&gt;</div>
<div class="line"><a id="l00083" name="l00083"></a><span class="lineno"> 83</span> {</div>
<div class="line"><a id="l00084" name="l00084"></a><span class="lineno"> 84</span> table.PrimaryKey(<span class="stringliteral">&quot;PK_ReattachInformations&quot;</span>, x =&gt; x.Id);</div>
<div class="line"><a id="l00085" name="l00085"></a><span class="lineno"> 85</span> });</div>
<div class="line"><a id="l00086" name="l00086"></a><span class="lineno"> 86</span> </div>
<div class="line"><a id="l00087" name="l00087"></a><span class="lineno"> 87</span> migrationBuilder.CreateTable(</div>
<div class="line"><a id="l00088" name="l00088"></a><span class="lineno"> 88</span> name: <span class="stringliteral">&quot;WatchdogReattachInformations&quot;</span>,</div>
<div class="line"><a id="l00089" name="l00089"></a><span class="lineno"> 89</span> columns: table =&gt; <span class="keyword">new</span></div>
<div class="line"><a id="l00090" name="l00090"></a><span class="lineno"> 90</span> {</div>
<div class="line"><a id="l00091" name="l00091"></a><span class="lineno"> 91</span> AlphaIsActive = table.Column&lt;<span class="keywordtype">bool</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00092" name="l00092"></a><span class="lineno"> 92</span> Id = table.Column&lt;<span class="keywordtype">long</span>&gt;(nullable: <span class="keyword">false</span>)</div>
<div class="line"><a id="l00093" name="l00093"></a><span class="lineno"> 93</span> .Annotation(<span class="stringliteral">&quot;SqlServer:ValueGenerationStrategy&quot;</span>, SqlServerValueGenerationStrategy.IdentityColumn),</div>
<div class="line"><a id="l00094" name="l00094"></a><span class="lineno"> 94</span> AlphaId = table.Column&lt;<span class="keywordtype">long</span>&gt;(nullable: <span class="keyword">true</span>),</div>
<div class="line"><a id="l00095" name="l00095"></a><span class="lineno"> 95</span> BravoId = table.Column&lt;<span class="keywordtype">long</span>&gt;(nullable: <span class="keyword">true</span>),</div>
<div class="line"><a id="l00096" name="l00096"></a><span class="lineno"> 96</span> },</div>
<div class="line"><a id="l00097" name="l00097"></a><span class="lineno"> 97</span> constraints: table =&gt;</div>
<div class="line"><a id="l00098" name="l00098"></a><span class="lineno"> 98</span> {</div>
<div class="line"><a id="l00099" name="l00099"></a><span class="lineno"> 99</span> table.PrimaryKey(<span class="stringliteral">&quot;PK_WatchdogReattachInformations&quot;</span>, x =&gt; x.Id);</div>
<div class="line"><a id="l00100" name="l00100"></a><span class="lineno"> 100</span> table.ForeignKey(</div>
<div class="line"><a id="l00101" name="l00101"></a><span class="lineno"> 101</span> name: <span class="stringliteral">&quot;FK_WatchdogReattachInformations_ReattachInformations_AlphaId&quot;</span>,</div>
<div class="line"><a id="l00102" name="l00102"></a><span class="lineno"> 102</span> column: x =&gt; x.AlphaId,</div>
<div class="line"><a id="l00103" name="l00103"></a><span class="lineno"> 103</span> principalTable: <span class="stringliteral">&quot;ReattachInformations&quot;</span>,</div>
<div class="line"><a id="l00104" name="l00104"></a><span class="lineno"> 104</span> principalColumn: <span class="stringliteral">&quot;Id&quot;</span>,</div>
<div class="line"><a id="l00105" name="l00105"></a><span class="lineno"> 105</span> onDelete: ReferentialAction.Restrict);</div>
<div class="line"><a id="l00106" name="l00106"></a><span class="lineno"> 106</span> table.ForeignKey(</div>
<div class="line"><a id="l00107" name="l00107"></a><span class="lineno"> 107</span> name: <span class="stringliteral">&quot;FK_WatchdogReattachInformations_ReattachInformations_BravoId&quot;</span>,</div>
<div class="line"><a id="l00108" name="l00108"></a><span class="lineno"> 108</span> column: x =&gt; x.BravoId,</div>
<div class="line"><a id="l00109" name="l00109"></a><span class="lineno"> 109</span> principalTable: <span class="stringliteral">&quot;ReattachInformations&quot;</span>,</div>
<div class="line"><a id="l00110" name="l00110"></a><span class="lineno"> 110</span> principalColumn: <span class="stringliteral">&quot;Id&quot;</span>,</div>
<div class="line"><a id="l00111" name="l00111"></a><span class="lineno"> 111</span> onDelete: ReferentialAction.Restrict);</div>
<div class="line"><a id="l00112" name="l00112"></a><span class="lineno"> 112</span> });</div>
<div class="line"><a id="l00113" name="l00113"></a><span class="lineno"> 113</span> </div>
<div class="line"><a id="l00114" name="l00114"></a><span class="lineno"> 114</span> migrationBuilder.CreateTable(</div>
<div class="line"><a id="l00115" name="l00115"></a><span class="lineno"> 115</span> name: <span class="stringliteral">&quot;Instances&quot;</span>,</div>
<div class="line"><a id="l00116" name="l00116"></a><span class="lineno"> 116</span> columns: table =&gt; <span class="keyword">new</span></div>
<div class="line"><a id="l00117" name="l00117"></a><span class="lineno"> 117</span> {</div>
<div class="line"><a id="l00118" name="l00118"></a><span class="lineno"> 118</span> Id = table.Column&lt;<span class="keywordtype">long</span>&gt;(nullable: <span class="keyword">false</span>)</div>
<div class="line"><a id="l00119" name="l00119"></a><span class="lineno"> 119</span> .Annotation(<span class="stringliteral">&quot;SqlServer:ValueGenerationStrategy&quot;</span>, SqlServerValueGenerationStrategy.IdentityColumn),</div>
<div class="line"><a id="l00120" name="l00120"></a><span class="lineno"> 120</span> Name = table.Column&lt;<span class="keywordtype">string</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00121" name="l00121"></a><span class="lineno"> 121</span> Path = table.Column&lt;<span class="keywordtype">string</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00122" name="l00122"></a><span class="lineno"> 122</span> Online = table.Column&lt;<span class="keywordtype">bool</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00123" name="l00123"></a><span class="lineno"> 123</span> ConfigurationType = table.Column&lt;<span class="keywordtype">int</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00124" name="l00124"></a><span class="lineno"> 124</span> AutoUpdateInterval = table.Column&lt;<span class="keywordtype">long</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00125" name="l00125"></a><span class="lineno"> 125</span> WatchdogReattachInformationId = table.Column&lt;<span class="keywordtype">long</span>&gt;(nullable: <span class="keyword">true</span>),</div>
<div class="line"><a id="l00126" name="l00126"></a><span class="lineno"> 126</span> },</div>
<div class="line"><a id="l00127" name="l00127"></a><span class="lineno"> 127</span> constraints: table =&gt;</div>
<div class="line"><a id="l00128" name="l00128"></a><span class="lineno"> 128</span> {</div>
<div class="line"><a id="l00129" name="l00129"></a><span class="lineno"> 129</span> table.PrimaryKey(<span class="stringliteral">&quot;PK_Instances&quot;</span>, x =&gt; x.Id);</div>
<div class="line"><a id="l00130" name="l00130"></a><span class="lineno"> 130</span> table.ForeignKey(</div>
<div class="line"><a id="l00131" name="l00131"></a><span class="lineno"> 131</span> name: <span class="stringliteral">&quot;FK_Instances_WatchdogReattachInformations_WatchdogReattachInformationId&quot;</span>,</div>
<div class="line"><a id="l00132" name="l00132"></a><span class="lineno"> 132</span> column: x =&gt; x.WatchdogReattachInformationId,</div>
<div class="line"><a id="l00133" name="l00133"></a><span class="lineno"> 133</span> principalTable: <span class="stringliteral">&quot;WatchdogReattachInformations&quot;</span>,</div>
<div class="line"><a id="l00134" name="l00134"></a><span class="lineno"> 134</span> principalColumn: <span class="stringliteral">&quot;Id&quot;</span>,</div>
<div class="line"><a id="l00135" name="l00135"></a><span class="lineno"> 135</span> onDelete: ReferentialAction.Restrict);</div>
<div class="line"><a id="l00136" name="l00136"></a><span class="lineno"> 136</span> });</div>
<div class="line"><a id="l00137" name="l00137"></a><span class="lineno"> 137</span> </div>
<div class="line"><a id="l00138" name="l00138"></a><span class="lineno"> 138</span> migrationBuilder.CreateTable(</div>
<div class="line"><a id="l00139" name="l00139"></a><span class="lineno"> 139</span> name: <span class="stringliteral">&quot;ChatBots&quot;</span>,</div>
<div class="line"><a id="l00140" name="l00140"></a><span class="lineno"> 140</span> columns: table =&gt; <span class="keyword">new</span></div>
<div class="line"><a id="l00141" name="l00141"></a><span class="lineno"> 141</span> {</div>
<div class="line"><a id="l00142" name="l00142"></a><span class="lineno"> 142</span> Id = table.Column&lt;<span class="keywordtype">long</span>&gt;(nullable: <span class="keyword">false</span>)</div>
<div class="line"><a id="l00143" name="l00143"></a><span class="lineno"> 143</span> .Annotation(<span class="stringliteral">&quot;SqlServer:ValueGenerationStrategy&quot;</span>, SqlServerValueGenerationStrategy.IdentityColumn),</div>
<div class="line"><a id="l00144" name="l00144"></a><span class="lineno"> 144</span> Name = table.Column&lt;<span class="keywordtype">string</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00145" name="l00145"></a><span class="lineno"> 145</span> <a class="code hl_enumvalue" href="namespace_tgstation_1_1_server_1_1_host.html#a71712cdd4f38be5482e1d08905c0c308a00d23a76e43b46dae9ec7aa9dcbebb32">Enabled</a> = table.Column&lt;<span class="keywordtype">bool</span>&gt;(nullable: <span class="keyword">true</span>),</div>
<div class="line"><a id="l00146" name="l00146"></a><span class="lineno"> 146</span> Provider = table.Column&lt;<span class="keywordtype">int</span>&gt;(nullable: <span class="keyword">true</span>),</div>
<div class="line"><a id="l00147" name="l00147"></a><span class="lineno"> 147</span> ConnectionString = table.Column&lt;<span class="keywordtype">string</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00148" name="l00148"></a><span class="lineno"> 148</span> InstanceId = table.Column&lt;<span class="keywordtype">long</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00149" name="l00149"></a><span class="lineno"> 149</span> },</div>
<div class="line"><a id="l00150" name="l00150"></a><span class="lineno"> 150</span> constraints: table =&gt;</div>
<div class="line"><a id="l00151" name="l00151"></a><span class="lineno"> 151</span> {</div>
<div class="line"><a id="l00152" name="l00152"></a><span class="lineno"> 152</span> table.PrimaryKey(<span class="stringliteral">&quot;PK_ChatBots&quot;</span>, x =&gt; x.Id);</div>
<div class="line"><a id="l00153" name="l00153"></a><span class="lineno"> 153</span> table.ForeignKey(</div>
<div class="line"><a id="l00154" name="l00154"></a><span class="lineno"> 154</span> name: <span class="stringliteral">&quot;FK_ChatBots_Instances_InstanceId&quot;</span>,</div>
<div class="line"><a id="l00155" name="l00155"></a><span class="lineno"> 155</span> column: x =&gt; x.InstanceId,</div>
<div class="line"><a id="l00156" name="l00156"></a><span class="lineno"> 156</span> principalTable: <span class="stringliteral">&quot;Instances&quot;</span>,</div>
<div class="line"><a id="l00157" name="l00157"></a><span class="lineno"> 157</span> principalColumn: <span class="stringliteral">&quot;Id&quot;</span>,</div>
<div class="line"><a id="l00158" name="l00158"></a><span class="lineno"> 158</span> onDelete: ReferentialAction.Cascade);</div>
<div class="line"><a id="l00159" name="l00159"></a><span class="lineno"> 159</span> });</div>
<div class="line"><a id="l00160" name="l00160"></a><span class="lineno"> 160</span> </div>
<div class="line"><a id="l00161" name="l00161"></a><span class="lineno"> 161</span> migrationBuilder.CreateTable(</div>
<div class="line"><a id="l00162" name="l00162"></a><span class="lineno"> 162</span> name: <span class="stringliteral">&quot;DreamDaemonSettings&quot;</span>,</div>
<div class="line"><a id="l00163" name="l00163"></a><span class="lineno"> 163</span> columns: table =&gt; <span class="keyword">new</span></div>
<div class="line"><a id="l00164" name="l00164"></a><span class="lineno"> 164</span> {</div>
<div class="line"><a id="l00165" name="l00165"></a><span class="lineno"> 165</span> AllowWebClient = table.Column&lt;<span class="keywordtype">bool</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00166" name="l00166"></a><span class="lineno"> 166</span> SecurityLevel = table.Column&lt;<span class="keywordtype">int</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00167" name="l00167"></a><span class="lineno"> 167</span> PrimaryPort = table.Column&lt;<span class="keywordtype">int</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00168" name="l00168"></a><span class="lineno"> 168</span> SecondaryPort = table.Column&lt;<span class="keywordtype">int</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00169" name="l00169"></a><span class="lineno"> 169</span> StartupTimeout = table.Column&lt;<span class="keywordtype">long</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00170" name="l00170"></a><span class="lineno"> 170</span> AutoStart = table.Column&lt;<span class="keywordtype">bool</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00171" name="l00171"></a><span class="lineno"> 171</span> SoftRestart = table.Column&lt;<span class="keywordtype">bool</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00172" name="l00172"></a><span class="lineno"> 172</span> SoftShutdown = table.Column&lt;<span class="keywordtype">bool</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00173" name="l00173"></a><span class="lineno"> 173</span> Id = table.Column&lt;<span class="keywordtype">long</span>&gt;(nullable: <span class="keyword">false</span>)</div>
<div class="line"><a id="l00174" name="l00174"></a><span class="lineno"> 174</span> .Annotation(<span class="stringliteral">&quot;SqlServer:ValueGenerationStrategy&quot;</span>, SqlServerValueGenerationStrategy.IdentityColumn),</div>
<div class="line"><a id="l00175" name="l00175"></a><span class="lineno"> 175</span> ProcessId = table.Column&lt;<span class="keywordtype">int</span>&gt;(nullable: <span class="keyword">true</span>),</div>
<div class="line"><a id="l00176" name="l00176"></a><span class="lineno"> 176</span> AccessToken = table.Column&lt;<span class="keywordtype">string</span>&gt;(nullable: <span class="keyword">true</span>),</div>
<div class="line"><a id="l00177" name="l00177"></a><span class="lineno"> 177</span> InstanceId = table.Column&lt;<span class="keywordtype">long</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00178" name="l00178"></a><span class="lineno"> 178</span> },</div>
<div class="line"><a id="l00179" name="l00179"></a><span class="lineno"> 179</span> constraints: table =&gt;</div>
<div class="line"><a id="l00180" name="l00180"></a><span class="lineno"> 180</span> {</div>
<div class="line"><a id="l00181" name="l00181"></a><span class="lineno"> 181</span> table.PrimaryKey(<span class="stringliteral">&quot;PK_DreamDaemonSettings&quot;</span>, x =&gt; x.Id);</div>
<div class="line"><a id="l00182" name="l00182"></a><span class="lineno"> 182</span> table.ForeignKey(</div>
<div class="line"><a id="l00183" name="l00183"></a><span class="lineno"> 183</span> name: <span class="stringliteral">&quot;FK_DreamDaemonSettings_Instances_InstanceId&quot;</span>,</div>
<div class="line"><a id="l00184" name="l00184"></a><span class="lineno"> 184</span> column: x =&gt; x.InstanceId,</div>
<div class="line"><a id="l00185" name="l00185"></a><span class="lineno"> 185</span> principalTable: <span class="stringliteral">&quot;Instances&quot;</span>,</div>
<div class="line"><a id="l00186" name="l00186"></a><span class="lineno"> 186</span> principalColumn: <span class="stringliteral">&quot;Id&quot;</span>,</div>
<div class="line"><a id="l00187" name="l00187"></a><span class="lineno"> 187</span> onDelete: ReferentialAction.Cascade);</div>
<div class="line"><a id="l00188" name="l00188"></a><span class="lineno"> 188</span> });</div>
<div class="line"><a id="l00189" name="l00189"></a><span class="lineno"> 189</span> </div>
<div class="line"><a id="l00190" name="l00190"></a><span class="lineno"> 190</span> migrationBuilder.CreateTable(</div>
<div class="line"><a id="l00191" name="l00191"></a><span class="lineno"> 191</span> name: <span class="stringliteral">&quot;DreamMakerSettings&quot;</span>,</div>
<div class="line"><a id="l00192" name="l00192"></a><span class="lineno"> 192</span> columns: table =&gt; <span class="keyword">new</span></div>
<div class="line"><a id="l00193" name="l00193"></a><span class="lineno"> 193</span> {</div>
<div class="line"><a id="l00194" name="l00194"></a><span class="lineno"> 194</span> ProjectName = table.Column&lt;<span class="keywordtype">string</span>&gt;(nullable: <span class="keyword">true</span>),</div>
<div class="line"><a id="l00195" name="l00195"></a><span class="lineno"> 195</span> ApiValidationPort = table.Column&lt;<span class="keywordtype">int</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00196" name="l00196"></a><span class="lineno"> 196</span> Id = table.Column&lt;<span class="keywordtype">long</span>&gt;(nullable: <span class="keyword">false</span>)</div>
<div class="line"><a id="l00197" name="l00197"></a><span class="lineno"> 197</span> .Annotation(<span class="stringliteral">&quot;SqlServer:ValueGenerationStrategy&quot;</span>, SqlServerValueGenerationStrategy.IdentityColumn),</div>
<div class="line"><a id="l00198" name="l00198"></a><span class="lineno"> 198</span> InstanceId = table.Column&lt;<span class="keywordtype">long</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00199" name="l00199"></a><span class="lineno"> 199</span> },</div>
<div class="line"><a id="l00200" name="l00200"></a><span class="lineno"> 200</span> constraints: table =&gt;</div>
<div class="line"><a id="l00201" name="l00201"></a><span class="lineno"> 201</span> {</div>
<div class="line"><a id="l00202" name="l00202"></a><span class="lineno"> 202</span> table.PrimaryKey(<span class="stringliteral">&quot;PK_DreamMakerSettings&quot;</span>, x =&gt; x.Id);</div>
<div class="line"><a id="l00203" name="l00203"></a><span class="lineno"> 203</span> table.ForeignKey(</div>
<div class="line"><a id="l00204" name="l00204"></a><span class="lineno"> 204</span> name: <span class="stringliteral">&quot;FK_DreamMakerSettings_Instances_InstanceId&quot;</span>,</div>
<div class="line"><a id="l00205" name="l00205"></a><span class="lineno"> 205</span> column: x =&gt; x.InstanceId,</div>
<div class="line"><a id="l00206" name="l00206"></a><span class="lineno"> 206</span> principalTable: <span class="stringliteral">&quot;Instances&quot;</span>,</div>
<div class="line"><a id="l00207" name="l00207"></a><span class="lineno"> 207</span> principalColumn: <span class="stringliteral">&quot;Id&quot;</span>,</div>
<div class="line"><a id="l00208" name="l00208"></a><span class="lineno"> 208</span> onDelete: ReferentialAction.Cascade);</div>
<div class="line"><a id="l00209" name="l00209"></a><span class="lineno"> 209</span> });</div>
<div class="line"><a id="l00210" name="l00210"></a><span class="lineno"> 210</span> </div>
<div class="line"><a id="l00211" name="l00211"></a><span class="lineno"> 211</span> migrationBuilder.CreateTable(</div>
<div class="line"><a id="l00212" name="l00212"></a><span class="lineno"> 212</span> name: <span class="stringliteral">&quot;InstanceUsers&quot;</span>,</div>
<div class="line"><a id="l00213" name="l00213"></a><span class="lineno"> 213</span> columns: table =&gt; <span class="keyword">new</span></div>
<div class="line"><a id="l00214" name="l00214"></a><span class="lineno"> 214</span> {</div>
<div class="line"><a id="l00215" name="l00215"></a><span class="lineno"> 215</span> UserId = table.Column&lt;<span class="keywordtype">long</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00216" name="l00216"></a><span class="lineno"> 216</span> InstanceUserRights = table.Column&lt;decimal&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00217" name="l00217"></a><span class="lineno"> 217</span> ByondRights = table.Column&lt;decimal&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00218" name="l00218"></a><span class="lineno"> 218</span> DreamDaemonRights = table.Column&lt;decimal&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00219" name="l00219"></a><span class="lineno"> 219</span> DreamMakerRights = table.Column&lt;decimal&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00220" name="l00220"></a><span class="lineno"> 220</span> RepositoryRights = table.Column&lt;decimal&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00221" name="l00221"></a><span class="lineno"> 221</span> ChatBotRights = table.Column&lt;decimal&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00222" name="l00222"></a><span class="lineno"> 222</span> ConfigurationRights = table.Column&lt;decimal&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00223" name="l00223"></a><span class="lineno"> 223</span> Id = table.Column&lt;<span class="keywordtype">long</span>&gt;(nullable: <span class="keyword">false</span>)</div>
<div class="line"><a id="l00224" name="l00224"></a><span class="lineno"> 224</span> .Annotation(<span class="stringliteral">&quot;SqlServer:ValueGenerationStrategy&quot;</span>, SqlServerValueGenerationStrategy.IdentityColumn),</div>
<div class="line"><a id="l00225" name="l00225"></a><span class="lineno"> 225</span> InstanceId = table.Column&lt;<span class="keywordtype">long</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00226" name="l00226"></a><span class="lineno"> 226</span> },</div>
<div class="line"><a id="l00227" name="l00227"></a><span class="lineno"> 227</span> constraints: table =&gt;</div>
<div class="line"><a id="l00228" name="l00228"></a><span class="lineno"> 228</span> {</div>
<div class="line"><a id="l00229" name="l00229"></a><span class="lineno"> 229</span> table.PrimaryKey(<span class="stringliteral">&quot;PK_InstanceUsers&quot;</span>, x =&gt; x.Id);</div>
<div class="line"><a id="l00230" name="l00230"></a><span class="lineno"> 230</span> table.ForeignKey(</div>
<div class="line"><a id="l00231" name="l00231"></a><span class="lineno"> 231</span> name: <span class="stringliteral">&quot;FK_InstanceUsers_Instances_InstanceId&quot;</span>,</div>
<div class="line"><a id="l00232" name="l00232"></a><span class="lineno"> 232</span> column: x =&gt; x.InstanceId,</div>
<div class="line"><a id="l00233" name="l00233"></a><span class="lineno"> 233</span> principalTable: <span class="stringliteral">&quot;Instances&quot;</span>,</div>
<div class="line"><a id="l00234" name="l00234"></a><span class="lineno"> 234</span> principalColumn: <span class="stringliteral">&quot;Id&quot;</span>,</div>
<div class="line"><a id="l00235" name="l00235"></a><span class="lineno"> 235</span> onDelete: ReferentialAction.Cascade);</div>
<div class="line"><a id="l00236" name="l00236"></a><span class="lineno"> 236</span> table.ForeignKey(</div>
<div class="line"><a id="l00237" name="l00237"></a><span class="lineno"> 237</span> name: <span class="stringliteral">&quot;FK_InstanceUsers_Users_UserId&quot;</span>,</div>
<div class="line"><a id="l00238" name="l00238"></a><span class="lineno"> 238</span> column: x =&gt; x.UserId,</div>
<div class="line"><a id="l00239" name="l00239"></a><span class="lineno"> 239</span> principalTable: <span class="stringliteral">&quot;Users&quot;</span>,</div>
<div class="line"><a id="l00240" name="l00240"></a><span class="lineno"> 240</span> principalColumn: <span class="stringliteral">&quot;Id&quot;</span>,</div>
<div class="line"><a id="l00241" name="l00241"></a><span class="lineno"> 241</span> onDelete: ReferentialAction.Cascade);</div>
<div class="line"><a id="l00242" name="l00242"></a><span class="lineno"> 242</span> });</div>
<div class="line"><a id="l00243" name="l00243"></a><span class="lineno"> 243</span> </div>
<div class="line"><a id="l00244" name="l00244"></a><span class="lineno"> 244</span> migrationBuilder.CreateTable(</div>
<div class="line"><a id="l00245" name="l00245"></a><span class="lineno"> 245</span> name: <span class="stringliteral">&quot;Jobs&quot;</span>,</div>
<div class="line"><a id="l00246" name="l00246"></a><span class="lineno"> 246</span> columns: table =&gt; <span class="keyword">new</span></div>
<div class="line"><a id="l00247" name="l00247"></a><span class="lineno"> 247</span> {</div>
<div class="line"><a id="l00248" name="l00248"></a><span class="lineno"> 248</span> Id = table.Column&lt;<span class="keywordtype">long</span>&gt;(nullable: <span class="keyword">false</span>)</div>
<div class="line"><a id="l00249" name="l00249"></a><span class="lineno"> 249</span> .Annotation(<span class="stringliteral">&quot;SqlServer:ValueGenerationStrategy&quot;</span>, SqlServerValueGenerationStrategy.IdentityColumn),</div>
<div class="line"><a id="l00250" name="l00250"></a><span class="lineno"> 250</span> Description = table.Column&lt;<span class="keywordtype">string</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00251" name="l00251"></a><span class="lineno"> 251</span> ExceptionDetails = table.Column&lt;<span class="keywordtype">string</span>&gt;(nullable: <span class="keyword">true</span>),</div>
<div class="line"><a id="l00252" name="l00252"></a><span class="lineno"> 252</span> StartedAt = table.Column&lt;DateTimeOffset&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00253" name="l00253"></a><span class="lineno"> 253</span> StoppedAt = table.Column&lt;DateTimeOffset&gt;(nullable: <span class="keyword">true</span>),</div>
<div class="line"><a id="l00254" name="l00254"></a><span class="lineno"> 254</span> Cancelled = table.Column&lt;<span class="keywordtype">bool</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00255" name="l00255"></a><span class="lineno"> 255</span> CancelRightsType = table.Column&lt;decimal&gt;(nullable: <span class="keyword">true</span>),</div>
<div class="line"><a id="l00256" name="l00256"></a><span class="lineno"> 256</span> CancelRight = table.Column&lt;decimal&gt;(nullable: <span class="keyword">true</span>),</div>
<div class="line"><a id="l00257" name="l00257"></a><span class="lineno"> 257</span> StartedById = table.Column&lt;<span class="keywordtype">long</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00258" name="l00258"></a><span class="lineno"> 258</span> CancelledById = table.Column&lt;<span class="keywordtype">long</span>&gt;(nullable: <span class="keyword">true</span>),</div>
<div class="line"><a id="l00259" name="l00259"></a><span class="lineno"> 259</span> InstanceId = table.Column&lt;<span class="keywordtype">long</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00260" name="l00260"></a><span class="lineno"> 260</span> },</div>
<div class="line"><a id="l00261" name="l00261"></a><span class="lineno"> 261</span> constraints: table =&gt;</div>
<div class="line"><a id="l00262" name="l00262"></a><span class="lineno"> 262</span> {</div>
<div class="line"><a id="l00263" name="l00263"></a><span class="lineno"> 263</span> table.PrimaryKey(<span class="stringliteral">&quot;PK_Jobs&quot;</span>, x =&gt; x.Id);</div>
<div class="line"><a id="l00264" name="l00264"></a><span class="lineno"> 264</span> table.ForeignKey(</div>
<div class="line"><a id="l00265" name="l00265"></a><span class="lineno"> 265</span> name: <span class="stringliteral">&quot;FK_Jobs_Users_CancelledById&quot;</span>,</div>
<div class="line"><a id="l00266" name="l00266"></a><span class="lineno"> 266</span> column: x =&gt; x.CancelledById,</div>
<div class="line"><a id="l00267" name="l00267"></a><span class="lineno"> 267</span> principalTable: <span class="stringliteral">&quot;Users&quot;</span>,</div>
<div class="line"><a id="l00268" name="l00268"></a><span class="lineno"> 268</span> principalColumn: <span class="stringliteral">&quot;Id&quot;</span>,</div>
<div class="line"><a id="l00269" name="l00269"></a><span class="lineno"> 269</span> onDelete: ReferentialAction.Restrict);</div>
<div class="line"><a id="l00270" name="l00270"></a><span class="lineno"> 270</span> table.ForeignKey(</div>
<div class="line"><a id="l00271" name="l00271"></a><span class="lineno"> 271</span> name: <span class="stringliteral">&quot;FK_Jobs_Instances_InstanceId&quot;</span>,</div>
<div class="line"><a id="l00272" name="l00272"></a><span class="lineno"> 272</span> column: x =&gt; x.InstanceId,</div>
<div class="line"><a id="l00273" name="l00273"></a><span class="lineno"> 273</span> principalTable: <span class="stringliteral">&quot;Instances&quot;</span>,</div>
<div class="line"><a id="l00274" name="l00274"></a><span class="lineno"> 274</span> principalColumn: <span class="stringliteral">&quot;Id&quot;</span>,</div>
<div class="line"><a id="l00275" name="l00275"></a><span class="lineno"> 275</span> onDelete: ReferentialAction.Cascade);</div>
<div class="line"><a id="l00276" name="l00276"></a><span class="lineno"> 276</span> table.ForeignKey(</div>
<div class="line"><a id="l00277" name="l00277"></a><span class="lineno"> 277</span> name: <span class="stringliteral">&quot;FK_Jobs_Users_StartedById&quot;</span>,</div>
<div class="line"><a id="l00278" name="l00278"></a><span class="lineno"> 278</span> column: x =&gt; x.StartedById,</div>
<div class="line"><a id="l00279" name="l00279"></a><span class="lineno"> 279</span> principalTable: <span class="stringliteral">&quot;Users&quot;</span>,</div>
<div class="line"><a id="l00280" name="l00280"></a><span class="lineno"> 280</span> principalColumn: <span class="stringliteral">&quot;Id&quot;</span>,</div>
<div class="line"><a id="l00281" name="l00281"></a><span class="lineno"> 281</span> onDelete: ReferentialAction.Cascade);</div>
<div class="line"><a id="l00282" name="l00282"></a><span class="lineno"> 282</span> });</div>
<div class="line"><a id="l00283" name="l00283"></a><span class="lineno"> 283</span> </div>
<div class="line"><a id="l00284" name="l00284"></a><span class="lineno"> 284</span> migrationBuilder.CreateTable(</div>
<div class="line"><a id="l00285" name="l00285"></a><span class="lineno"> 285</span> name: <span class="stringliteral">&quot;RepositorySettings&quot;</span>,</div>
<div class="line"><a id="l00286" name="l00286"></a><span class="lineno"> 286</span> columns: table =&gt; <span class="keyword">new</span></div>
<div class="line"><a id="l00287" name="l00287"></a><span class="lineno"> 287</span> {</div>
<div class="line"><a id="l00288" name="l00288"></a><span class="lineno"> 288</span> CommitterName = table.Column&lt;<span class="keywordtype">string</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00289" name="l00289"></a><span class="lineno"> 289</span> CommitterEmail = table.Column&lt;<span class="keywordtype">string</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00290" name="l00290"></a><span class="lineno"> 290</span> AccessUser = table.Column&lt;<span class="keywordtype">string</span>&gt;(nullable: <span class="keyword">true</span>),</div>
<div class="line"><a id="l00291" name="l00291"></a><span class="lineno"> 291</span> AccessToken = table.Column&lt;<span class="keywordtype">string</span>&gt;(nullable: <span class="keyword">true</span>),</div>
<div class="line"><a id="l00292" name="l00292"></a><span class="lineno"> 292</span> PushTestMergeCommits = table.Column&lt;<span class="keywordtype">bool</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00293" name="l00293"></a><span class="lineno"> 293</span> ShowTestMergeCommitters = table.Column&lt;<span class="keywordtype">bool</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00294" name="l00294"></a><span class="lineno"> 294</span> AutoUpdatesKeepTestMerges = table.Column&lt;<span class="keywordtype">bool</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00295" name="l00295"></a><span class="lineno"> 295</span> AutoUpdatesSynchronize = table.Column&lt;<span class="keywordtype">bool</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00296" name="l00296"></a><span class="lineno"> 296</span> Id = table.Column&lt;<span class="keywordtype">long</span>&gt;(nullable: <span class="keyword">false</span>)</div>
<div class="line"><a id="l00297" name="l00297"></a><span class="lineno"> 297</span> .Annotation(<span class="stringliteral">&quot;SqlServer:ValueGenerationStrategy&quot;</span>, SqlServerValueGenerationStrategy.IdentityColumn),</div>
<div class="line"><a id="l00298" name="l00298"></a><span class="lineno"> 298</span> InstanceId = table.Column&lt;<span class="keywordtype">long</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00299" name="l00299"></a><span class="lineno"> 299</span> },</div>
<div class="line"><a id="l00300" name="l00300"></a><span class="lineno"> 300</span> constraints: table =&gt;</div>
<div class="line"><a id="l00301" name="l00301"></a><span class="lineno"> 301</span> {</div>
<div class="line"><a id="l00302" name="l00302"></a><span class="lineno"> 302</span> table.PrimaryKey(<span class="stringliteral">&quot;PK_RepositorySettings&quot;</span>, x =&gt; x.Id);</div>
<div class="line"><a id="l00303" name="l00303"></a><span class="lineno"> 303</span> table.ForeignKey(</div>
<div class="line"><a id="l00304" name="l00304"></a><span class="lineno"> 304</span> name: <span class="stringliteral">&quot;FK_RepositorySettings_Instances_InstanceId&quot;</span>,</div>
<div class="line"><a id="l00305" name="l00305"></a><span class="lineno"> 305</span> column: x =&gt; x.InstanceId,</div>
<div class="line"><a id="l00306" name="l00306"></a><span class="lineno"> 306</span> principalTable: <span class="stringliteral">&quot;Instances&quot;</span>,</div>
<div class="line"><a id="l00307" name="l00307"></a><span class="lineno"> 307</span> principalColumn: <span class="stringliteral">&quot;Id&quot;</span>,</div>
<div class="line"><a id="l00308" name="l00308"></a><span class="lineno"> 308</span> onDelete: ReferentialAction.Cascade);</div>
<div class="line"><a id="l00309" name="l00309"></a><span class="lineno"> 309</span> });</div>
<div class="line"><a id="l00310" name="l00310"></a><span class="lineno"> 310</span> </div>
<div class="line"><a id="l00311" name="l00311"></a><span class="lineno"> 311</span> migrationBuilder.CreateTable(</div>
<div class="line"><a id="l00312" name="l00312"></a><span class="lineno"> 312</span> name: <span class="stringliteral">&quot;RevisionInformations&quot;</span>,</div>
<div class="line"><a id="l00313" name="l00313"></a><span class="lineno"> 313</span> columns: table =&gt; <span class="keyword">new</span></div>
<div class="line"><a id="l00314" name="l00314"></a><span class="lineno"> 314</span> {</div>
<div class="line"><a id="l00315" name="l00315"></a><span class="lineno"> 315</span> CommitSha = table.Column&lt;<span class="keywordtype">string</span>&gt;(maxLength: 40, nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00316" name="l00316"></a><span class="lineno"> 316</span> OriginCommitSha = table.Column&lt;<span class="keywordtype">string</span>&gt;(maxLength: 40, nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00317" name="l00317"></a><span class="lineno"> 317</span> Id = table.Column&lt;<span class="keywordtype">long</span>&gt;(nullable: <span class="keyword">false</span>)</div>
<div class="line"><a id="l00318" name="l00318"></a><span class="lineno"> 318</span> .Annotation(<span class="stringliteral">&quot;SqlServer:ValueGenerationStrategy&quot;</span>, SqlServerValueGenerationStrategy.IdentityColumn),</div>
<div class="line"><a id="l00319" name="l00319"></a><span class="lineno"> 319</span> InstanceId = table.Column&lt;<span class="keywordtype">long</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00320" name="l00320"></a><span class="lineno"> 320</span> },</div>
<div class="line"><a id="l00321" name="l00321"></a><span class="lineno"> 321</span> constraints: table =&gt;</div>
<div class="line"><a id="l00322" name="l00322"></a><span class="lineno"> 322</span> {</div>
<div class="line"><a id="l00323" name="l00323"></a><span class="lineno"> 323</span> table.PrimaryKey(<span class="stringliteral">&quot;PK_RevisionInformations&quot;</span>, x =&gt; x.Id);</div>
<div class="line"><a id="l00324" name="l00324"></a><span class="lineno"> 324</span> table.ForeignKey(</div>
<div class="line"><a id="l00325" name="l00325"></a><span class="lineno"> 325</span> name: <span class="stringliteral">&quot;FK_RevisionInformations_Instances_InstanceId&quot;</span>,</div>
<div class="line"><a id="l00326" name="l00326"></a><span class="lineno"> 326</span> column: x =&gt; x.InstanceId,</div>
<div class="line"><a id="l00327" name="l00327"></a><span class="lineno"> 327</span> principalTable: <span class="stringliteral">&quot;Instances&quot;</span>,</div>
<div class="line"><a id="l00328" name="l00328"></a><span class="lineno"> 328</span> principalColumn: <span class="stringliteral">&quot;Id&quot;</span>,</div>
<div class="line"><a id="l00329" name="l00329"></a><span class="lineno"> 329</span> onDelete: ReferentialAction.Cascade);</div>
<div class="line"><a id="l00330" name="l00330"></a><span class="lineno"> 330</span> });</div>
<div class="line"><a id="l00331" name="l00331"></a><span class="lineno"> 331</span> </div>
<div class="line"><a id="l00332" name="l00332"></a><span class="lineno"> 332</span> migrationBuilder.CreateTable(</div>
<div class="line"><a id="l00333" name="l00333"></a><span class="lineno"> 333</span> name: <span class="stringliteral">&quot;CompileJobs&quot;</span>,</div>
<div class="line"><a id="l00334" name="l00334"></a><span class="lineno"> 334</span> columns: table =&gt; <span class="keyword">new</span></div>
<div class="line"><a id="l00335" name="l00335"></a><span class="lineno"> 335</span> {</div>
<div class="line"><a id="l00336" name="l00336"></a><span class="lineno"> 336</span> Id = table.Column&lt;<span class="keywordtype">long</span>&gt;(nullable: <span class="keyword">false</span>)</div>
<div class="line"><a id="l00337" name="l00337"></a><span class="lineno"> 337</span> .Annotation(<span class="stringliteral">&quot;SqlServer:ValueGenerationStrategy&quot;</span>, SqlServerValueGenerationStrategy.IdentityColumn),</div>
<div class="line"><a id="l00338" name="l00338"></a><span class="lineno"> 338</span> DmeName = table.Column&lt;<span class="keywordtype">string</span>&gt;(nullable: <span class="keyword">true</span>),</div>
<div class="line"><a id="l00339" name="l00339"></a><span class="lineno"> 339</span> Output = table.Column&lt;<span class="keywordtype">string</span>&gt;(nullable: <span class="keyword">true</span>),</div>
<div class="line"><a id="l00340" name="l00340"></a><span class="lineno"> 340</span> DirectoryName = table.Column&lt;Guid&gt;(nullable: <span class="keyword">true</span>),</div>
<div class="line"><a id="l00341" name="l00341"></a><span class="lineno"> 341</span> JobId = table.Column&lt;<span class="keywordtype">long</span>&gt;(nullable: <span class="keyword">true</span>),</div>
<div class="line"><a id="l00342" name="l00342"></a><span class="lineno"> 342</span> RevisionInformationId = table.Column&lt;<span class="keywordtype">long</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00343" name="l00343"></a><span class="lineno"> 343</span> ByondVersion = table.Column&lt;<span class="keywordtype">string</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00344" name="l00344"></a><span class="lineno"> 344</span> },</div>
<div class="line"><a id="l00345" name="l00345"></a><span class="lineno"> 345</span> constraints: table =&gt;</div>
<div class="line"><a id="l00346" name="l00346"></a><span class="lineno"> 346</span> {</div>
<div class="line"><a id="l00347" name="l00347"></a><span class="lineno"> 347</span> table.PrimaryKey(<span class="stringliteral">&quot;PK_CompileJobs&quot;</span>, x =&gt; x.Id);</div>
<div class="line"><a id="l00348" name="l00348"></a><span class="lineno"> 348</span> table.ForeignKey(</div>
<div class="line"><a id="l00349" name="l00349"></a><span class="lineno"> 349</span> name: <span class="stringliteral">&quot;FK_CompileJobs_Jobs_JobId&quot;</span>,</div>
<div class="line"><a id="l00350" name="l00350"></a><span class="lineno"> 350</span> column: x =&gt; x.JobId,</div>
<div class="line"><a id="l00351" name="l00351"></a><span class="lineno"> 351</span> principalTable: <span class="stringliteral">&quot;Jobs&quot;</span>,</div>
<div class="line"><a id="l00352" name="l00352"></a><span class="lineno"> 352</span> principalColumn: <span class="stringliteral">&quot;Id&quot;</span>,</div>
<div class="line"><a id="l00353" name="l00353"></a><span class="lineno"> 353</span> onDelete: ReferentialAction.Restrict);</div>
<div class="line"><a id="l00354" name="l00354"></a><span class="lineno"> 354</span> table.ForeignKey(</div>
<div class="line"><a id="l00355" name="l00355"></a><span class="lineno"> 355</span> name: <span class="stringliteral">&quot;FK_CompileJobs_RevisionInformations_RevisionInformationId&quot;</span>,</div>
<div class="line"><a id="l00356" name="l00356"></a><span class="lineno"> 356</span> column: x =&gt; x.RevisionInformationId,</div>
<div class="line"><a id="l00357" name="l00357"></a><span class="lineno"> 357</span> principalTable: <span class="stringliteral">&quot;RevisionInformations&quot;</span>,</div>
<div class="line"><a id="l00358" name="l00358"></a><span class="lineno"> 358</span> principalColumn: <span class="stringliteral">&quot;Id&quot;</span>,</div>
<div class="line"><a id="l00359" name="l00359"></a><span class="lineno"> 359</span> onDelete: ReferentialAction.Cascade);</div>
<div class="line"><a id="l00360" name="l00360"></a><span class="lineno"> 360</span> });</div>
<div class="line"><a id="l00361" name="l00361"></a><span class="lineno"> 361</span> </div>
<div class="line"><a id="l00362" name="l00362"></a><span class="lineno"> 362</span> migrationBuilder.CreateTable(</div>
<div class="line"><a id="l00363" name="l00363"></a><span class="lineno"> 363</span> name: <span class="stringliteral">&quot;TestMerges&quot;</span>,</div>
<div class="line"><a id="l00364" name="l00364"></a><span class="lineno"> 364</span> columns: table =&gt; <span class="keyword">new</span></div>
<div class="line"><a id="l00365" name="l00365"></a><span class="lineno"> 365</span> {</div>
<div class="line"><a id="l00366" name="l00366"></a><span class="lineno"> 366</span> Number = table.Column&lt;<span class="keywordtype">int</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00367" name="l00367"></a><span class="lineno"> 367</span> PullRequestRevision = table.Column&lt;<span class="keywordtype">string</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00368" name="l00368"></a><span class="lineno"> 368</span> Comment = table.Column&lt;<span class="keywordtype">string</span>&gt;(nullable: <span class="keyword">true</span>),</div>
<div class="line"><a id="l00369" name="l00369"></a><span class="lineno"> 369</span> TitleAtMerge = table.Column&lt;<span class="keywordtype">string</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00370" name="l00370"></a><span class="lineno"> 370</span> BodyAtMerge = table.Column&lt;<span class="keywordtype">string</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00371" name="l00371"></a><span class="lineno"> 371</span> Url = table.Column&lt;<span class="keywordtype">string</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00372" name="l00372"></a><span class="lineno"> 372</span> Author = table.Column&lt;<span class="keywordtype">string</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00373" name="l00373"></a><span class="lineno"> 373</span> Id = table.Column&lt;<span class="keywordtype">long</span>&gt;(nullable: <span class="keyword">false</span>)</div>
<div class="line"><a id="l00374" name="l00374"></a><span class="lineno"> 374</span> .Annotation(<span class="stringliteral">&quot;SqlServer:ValueGenerationStrategy&quot;</span>, SqlServerValueGenerationStrategy.IdentityColumn),</div>
<div class="line"><a id="l00375" name="l00375"></a><span class="lineno"> 375</span> MergedAt = table.Column&lt;DateTimeOffset&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00376" name="l00376"></a><span class="lineno"> 376</span> MergedById = table.Column&lt;<span class="keywordtype">long</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00377" name="l00377"></a><span class="lineno"> 377</span> PrimaryRevisionInformationId = table.Column&lt;<span class="keywordtype">long</span>&gt;(nullable: <span class="keyword">true</span>),</div>
<div class="line"><a id="l00378" name="l00378"></a><span class="lineno"> 378</span> },</div>
<div class="line"><a id="l00379" name="l00379"></a><span class="lineno"> 379</span> constraints: table =&gt;</div>
<div class="line"><a id="l00380" name="l00380"></a><span class="lineno"> 380</span> {</div>
<div class="line"><a id="l00381" name="l00381"></a><span class="lineno"> 381</span> table.PrimaryKey(<span class="stringliteral">&quot;PK_TestMerges&quot;</span>, x =&gt; x.Id);</div>
<div class="line"><a id="l00382" name="l00382"></a><span class="lineno"> 382</span> table.ForeignKey(</div>
<div class="line"><a id="l00383" name="l00383"></a><span class="lineno"> 383</span> name: <span class="stringliteral">&quot;FK_TestMerges_Users_MergedById&quot;</span>,</div>
<div class="line"><a id="l00384" name="l00384"></a><span class="lineno"> 384</span> column: x =&gt; x.MergedById,</div>
<div class="line"><a id="l00385" name="l00385"></a><span class="lineno"> 385</span> principalTable: <span class="stringliteral">&quot;Users&quot;</span>,</div>
<div class="line"><a id="l00386" name="l00386"></a><span class="lineno"> 386</span> principalColumn: <span class="stringliteral">&quot;Id&quot;</span>,</div>
<div class="line"><a id="l00387" name="l00387"></a><span class="lineno"> 387</span> onDelete: ReferentialAction.Restrict);</div>
<div class="line"><a id="l00388" name="l00388"></a><span class="lineno"> 388</span> table.ForeignKey(</div>
<div class="line"><a id="l00389" name="l00389"></a><span class="lineno"> 389</span> name: <span class="stringliteral">&quot;FK_TestMerges_RevisionInformations_PrimaryRevisionInformationId&quot;</span>,</div>
<div class="line"><a id="l00390" name="l00390"></a><span class="lineno"> 390</span> column: x =&gt; x.PrimaryRevisionInformationId,</div>
<div class="line"><a id="l00391" name="l00391"></a><span class="lineno"> 391</span> principalTable: <span class="stringliteral">&quot;RevisionInformations&quot;</span>,</div>
<div class="line"><a id="l00392" name="l00392"></a><span class="lineno"> 392</span> principalColumn: <span class="stringliteral">&quot;Id&quot;</span>,</div>
<div class="line"><a id="l00393" name="l00393"></a><span class="lineno"> 393</span> onDelete: ReferentialAction.SetNull);</div>
<div class="line"><a id="l00394" name="l00394"></a><span class="lineno"> 394</span> });</div>
<div class="line"><a id="l00395" name="l00395"></a><span class="lineno"> 395</span> </div>
<div class="line"><a id="l00396" name="l00396"></a><span class="lineno"> 396</span> migrationBuilder.CreateTable(</div>
<div class="line"><a id="l00397" name="l00397"></a><span class="lineno"> 397</span> name: <span class="stringliteral">&quot;RevInfoTestMerges&quot;</span>,</div>
<div class="line"><a id="l00398" name="l00398"></a><span class="lineno"> 398</span> columns: table =&gt; <span class="keyword">new</span></div>
<div class="line"><a id="l00399" name="l00399"></a><span class="lineno"> 399</span> {</div>
<div class="line"><a id="l00400" name="l00400"></a><span class="lineno"> 400</span> Id = table.Column&lt;<span class="keywordtype">long</span>&gt;(nullable: <span class="keyword">false</span>)</div>
<div class="line"><a id="l00401" name="l00401"></a><span class="lineno"> 401</span> .Annotation(<span class="stringliteral">&quot;SqlServer:ValueGenerationStrategy&quot;</span>, SqlServerValueGenerationStrategy.IdentityColumn),</div>
<div class="line"><a id="l00402" name="l00402"></a><span class="lineno"> 402</span> TestMergeId = table.Column&lt;<span class="keywordtype">long</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00403" name="l00403"></a><span class="lineno"> 403</span> RevisionInformationId = table.Column&lt;<span class="keywordtype">long</span>&gt;(nullable: <span class="keyword">false</span>),</div>
<div class="line"><a id="l00404" name="l00404"></a><span class="lineno"> 404</span> },</div>
<div class="line"><a id="l00405" name="l00405"></a><span class="lineno"> 405</span> constraints: table =&gt;</div>
<div class="line"><a id="l00406" name="l00406"></a><span class="lineno"> 406</span> {</div>
<div class="line"><a id="l00407" name="l00407"></a><span class="lineno"> 407</span> table.PrimaryKey(<span class="stringliteral">&quot;PK_RevInfoTestMerges&quot;</span>, x =&gt; x.Id);</div>
<div class="line"><a id="l00408" name="l00408"></a><span class="lineno"> 408</span> table.ForeignKey(</div>
<div class="line"><a id="l00409" name="l00409"></a><span class="lineno"> 409</span> name: <span class="stringliteral">&quot;FK_RevInfoTestMerges_RevisionInformations_RevisionInformationId&quot;</span>,</div>
<div class="line"><a id="l00410" name="l00410"></a><span class="lineno"> 410</span> column: x =&gt; x.RevisionInformationId,</div>
<div class="line"><a id="l00411" name="l00411"></a><span class="lineno"> 411</span> principalTable: <span class="stringliteral">&quot;RevisionInformations&quot;</span>,</div>
<div class="line"><a id="l00412" name="l00412"></a><span class="lineno"> 412</span> principalColumn: <span class="stringliteral">&quot;Id&quot;</span>,</div>
<div class="line"><a id="l00413" name="l00413"></a><span class="lineno"> 413</span> onDelete: ReferentialAction.Cascade);</div>
<div class="line"><a id="l00414" name="l00414"></a><span class="lineno"> 414</span> table.ForeignKey(</div>
<div class="line"><a id="l00415" name="l00415"></a><span class="lineno"> 415</span> name: <span class="stringliteral">&quot;FK_RevInfoTestMerges_TestMerges_TestMergeId&quot;</span>,</div>
<div class="line"><a id="l00416" name="l00416"></a><span class="lineno"> 416</span> column: x =&gt; x.TestMergeId,</div>
<div class="line"><a id="l00417" name="l00417"></a><span class="lineno"> 417</span> principalTable: <span class="stringliteral">&quot;TestMerges&quot;</span>,</div>
<div class="line"><a id="l00418" name="l00418"></a><span class="lineno"> 418</span> principalColumn: <span class="stringliteral">&quot;Id&quot;</span>,</div>
<div class="line"><a id="l00419" name="l00419"></a><span class="lineno"> 419</span> onDelete: ReferentialAction.Cascade);</div>
<div class="line"><a id="l00420" name="l00420"></a><span class="lineno"> 420</span> });</div>
<div class="line"><a id="l00421" name="l00421"></a><span class="lineno"> 421</span> </div>
<div class="line"><a id="l00422" name="l00422"></a><span class="lineno"> 422</span> migrationBuilder.CreateIndex(</div>
<div class="line"><a id="l00423" name="l00423"></a><span class="lineno"> 423</span> name: <span class="stringliteral">&quot;IX_ChatBots_InstanceId&quot;</span>,</div>
<div class="line"><a id="l00424" name="l00424"></a><span class="lineno"> 424</span> table: <span class="stringliteral">&quot;ChatBots&quot;</span>,</div>
<div class="line"><a id="l00425" name="l00425"></a><span class="lineno"> 425</span> column: <span class="stringliteral">&quot;InstanceId&quot;</span>);</div>
<div class="line"><a id="l00426" name="l00426"></a><span class="lineno"> 426</span> </div>
<div class="line"><a id="l00427" name="l00427"></a><span class="lineno"> 427</span> migrationBuilder.CreateIndex(</div>
<div class="line"><a id="l00428" name="l00428"></a><span class="lineno"> 428</span> name: <span class="stringliteral">&quot;IX_ChatBots_Name&quot;</span>,</div>
<div class="line"><a id="l00429" name="l00429"></a><span class="lineno"> 429</span> table: <span class="stringliteral">&quot;ChatBots&quot;</span>,</div>
<div class="line"><a id="l00430" name="l00430"></a><span class="lineno"> 430</span> column: <span class="stringliteral">&quot;Name&quot;</span>,</div>
<div class="line"><a id="l00431" name="l00431"></a><span class="lineno"> 431</span> unique: <span class="keyword">true</span>);</div>
<div class="line"><a id="l00432" name="l00432"></a><span class="lineno"> 432</span> </div>
<div class="line"><a id="l00433" name="l00433"></a><span class="lineno"> 433</span> migrationBuilder.CreateIndex(</div>
<div class="line"><a id="l00434" name="l00434"></a><span class="lineno"> 434</span> name: <span class="stringliteral">&quot;IX_ChatChannels_ChatSettingsId_DiscordChannelId&quot;</span>,</div>
<div class="line"><a id="l00435" name="l00435"></a><span class="lineno"> 435</span> table: <span class="stringliteral">&quot;ChatChannels&quot;</span>,</div>
<div class="line"><a id="l00436" name="l00436"></a><span class="lineno"> 436</span> columns: <span class="keyword">new</span>[] { <span class="stringliteral">&quot;ChatSettingsId&quot;</span>, <span class="stringliteral">&quot;DiscordChannelId&quot;</span> },</div>
<div class="line"><a id="l00437" name="l00437"></a><span class="lineno"> 437</span> unique: <span class="keyword">true</span>,</div>
<div class="line"><a id="l00438" name="l00438"></a><span class="lineno"> 438</span> filter: <span class="stringliteral">&quot;[DiscordChannelId] IS NOT NULL&quot;</span>);</div>
<div class="line"><a id="l00439" name="l00439"></a><span class="lineno"> 439</span> </div>
<div class="line"><a id="l00440" name="l00440"></a><span class="lineno"> 440</span> migrationBuilder.CreateIndex(</div>
<div class="line"><a id="l00441" name="l00441"></a><span class="lineno"> 441</span> name: <span class="stringliteral">&quot;IX_ChatChannels_ChatSettingsId_IrcChannel&quot;</span>,</div>
<div class="line"><a id="l00442" name="l00442"></a><span class="lineno"> 442</span> table: <span class="stringliteral">&quot;ChatChannels&quot;</span>,</div>
<div class="line"><a id="l00443" name="l00443"></a><span class="lineno"> 443</span> columns: <span class="keyword">new</span>[] { <span class="stringliteral">&quot;ChatSettingsId&quot;</span>, <span class="stringliteral">&quot;IrcChannel&quot;</span> },</div>
<div class="line"><a id="l00444" name="l00444"></a><span class="lineno"> 444</span> unique: <span class="keyword">true</span>,</div>
<div class="line"><a id="l00445" name="l00445"></a><span class="lineno"> 445</span> filter: <span class="stringliteral">&quot;[IrcChannel] IS NOT NULL&quot;</span>);</div>
<div class="line"><a id="l00446" name="l00446"></a><span class="lineno"> 446</span> </div>
<div class="line"><a id="l00447" name="l00447"></a><span class="lineno"> 447</span> migrationBuilder.CreateIndex(</div>
<div class="line"><a id="l00448" name="l00448"></a><span class="lineno"> 448</span> name: <span class="stringliteral">&quot;IX_CompileJobs_DirectoryName&quot;</span>,</div>
<div class="line"><a id="l00449" name="l00449"></a><span class="lineno"> 449</span> table: <span class="stringliteral">&quot;CompileJobs&quot;</span>,</div>
<div class="line"><a id="l00450" name="l00450"></a><span class="lineno"> 450</span> column: <span class="stringliteral">&quot;DirectoryName&quot;</span>);</div>
<div class="line"><a id="l00451" name="l00451"></a><span class="lineno"> 451</span> </div>
<div class="line"><a id="l00452" name="l00452"></a><span class="lineno"> 452</span> migrationBuilder.CreateIndex(</div>
<div class="line"><a id="l00453" name="l00453"></a><span class="lineno"> 453</span> name: <span class="stringliteral">&quot;IX_CompileJobs_JobId&quot;</span>,</div>
<div class="line"><a id="l00454" name="l00454"></a><span class="lineno"> 454</span> table: <span class="stringliteral">&quot;CompileJobs&quot;</span>,</div>
<div class="line"><a id="l00455" name="l00455"></a><span class="lineno"> 455</span> column: <span class="stringliteral">&quot;JobId&quot;</span>);</div>
<div class="line"><a id="l00456" name="l00456"></a><span class="lineno"> 456</span> </div>
<div class="line"><a id="l00457" name="l00457"></a><span class="lineno"> 457</span> migrationBuilder.CreateIndex(</div>
<div class="line"><a id="l00458" name="l00458"></a><span class="lineno"> 458</span> name: <span class="stringliteral">&quot;IX_CompileJobs_RevisionInformationId&quot;</span>,</div>
<div class="line"><a id="l00459" name="l00459"></a><span class="lineno"> 459</span> table: <span class="stringliteral">&quot;CompileJobs&quot;</span>,</div>
<div class="line"><a id="l00460" name="l00460"></a><span class="lineno"> 460</span> column: <span class="stringliteral">&quot;RevisionInformationId&quot;</span>);</div>
<div class="line"><a id="l00461" name="l00461"></a><span class="lineno"> 461</span> </div>
<div class="line"><a id="l00462" name="l00462"></a><span class="lineno"> 462</span> migrationBuilder.CreateIndex(</div>
<div class="line"><a id="l00463" name="l00463"></a><span class="lineno"> 463</span> name: <span class="stringliteral">&quot;IX_DreamDaemonSettings_InstanceId&quot;</span>,</div>
<div class="line"><a id="l00464" name="l00464"></a><span class="lineno"> 464</span> table: <span class="stringliteral">&quot;DreamDaemonSettings&quot;</span>,</div>
<div class="line"><a id="l00465" name="l00465"></a><span class="lineno"> 465</span> column: <span class="stringliteral">&quot;InstanceId&quot;</span>,</div>
<div class="line"><a id="l00466" name="l00466"></a><span class="lineno"> 466</span> unique: <span class="keyword">true</span>);</div>
<div class="line"><a id="l00467" name="l00467"></a><span class="lineno"> 467</span> </div>
<div class="line"><a id="l00468" name="l00468"></a><span class="lineno"> 468</span> migrationBuilder.CreateIndex(</div>
<div class="line"><a id="l00469" name="l00469"></a><span class="lineno"> 469</span> name: <span class="stringliteral">&quot;IX_DreamMakerSettings_InstanceId&quot;</span>,</div>
<div class="line"><a id="l00470" name="l00470"></a><span class="lineno"> 470</span> table: <span class="stringliteral">&quot;DreamMakerSettings&quot;</span>,</div>
<div class="line"><a id="l00471" name="l00471"></a><span class="lineno"> 471</span> column: <span class="stringliteral">&quot;InstanceId&quot;</span>,</div>
<div class="line"><a id="l00472" name="l00472"></a><span class="lineno"> 472</span> unique: <span class="keyword">true</span>);</div>
<div class="line"><a id="l00473" name="l00473"></a><span class="lineno"> 473</span> </div>
<div class="line"><a id="l00474" name="l00474"></a><span class="lineno"> 474</span> migrationBuilder.CreateIndex(</div>
<div class="line"><a id="l00475" name="l00475"></a><span class="lineno"> 475</span> name: <span class="stringliteral">&quot;IX_Instances_Path&quot;</span>,</div>
<div class="line"><a id="l00476" name="l00476"></a><span class="lineno"> 476</span> table: <span class="stringliteral">&quot;Instances&quot;</span>,</div>
<div class="line"><a id="l00477" name="l00477"></a><span class="lineno"> 477</span> column: <span class="stringliteral">&quot;Path&quot;</span>,</div>
<div class="line"><a id="l00478" name="l00478"></a><span class="lineno"> 478</span> unique: <span class="keyword">true</span>);</div>
<div class="line"><a id="l00479" name="l00479"></a><span class="lineno"> 479</span> </div>
<div class="line"><a id="l00480" name="l00480"></a><span class="lineno"> 480</span> migrationBuilder.CreateIndex(</div>
<div class="line"><a id="l00481" name="l00481"></a><span class="lineno"> 481</span> name: <span class="stringliteral">&quot;IX_Instances_WatchdogReattachInformationId&quot;</span>,</div>
<div class="line"><a id="l00482" name="l00482"></a><span class="lineno"> 482</span> table: <span class="stringliteral">&quot;Instances&quot;</span>,</div>
<div class="line"><a id="l00483" name="l00483"></a><span class="lineno"> 483</span> column: <span class="stringliteral">&quot;WatchdogReattachInformationId&quot;</span>);</div>
<div class="line"><a id="l00484" name="l00484"></a><span class="lineno"> 484</span> </div>
<div class="line"><a id="l00485" name="l00485"></a><span class="lineno"> 485</span> migrationBuilder.CreateIndex(</div>
<div class="line"><a id="l00486" name="l00486"></a><span class="lineno"> 486</span> name: <span class="stringliteral">&quot;IX_InstanceUsers_InstanceId&quot;</span>,</div>
<div class="line"><a id="l00487" name="l00487"></a><span class="lineno"> 487</span> table: <span class="stringliteral">&quot;InstanceUsers&quot;</span>,</div>
<div class="line"><a id="l00488" name="l00488"></a><span class="lineno"> 488</span> column: <span class="stringliteral">&quot;InstanceId&quot;</span>);</div>
<div class="line"><a id="l00489" name="l00489"></a><span class="lineno"> 489</span> </div>
<div class="line"><a id="l00490" name="l00490"></a><span class="lineno"> 490</span> migrationBuilder.CreateIndex(</div>
<div class="line"><a id="l00491" name="l00491"></a><span class="lineno"> 491</span> name: <span class="stringliteral">&quot;IX_InstanceUsers_UserId_InstanceId&quot;</span>,</div>
<div class="line"><a id="l00492" name="l00492"></a><span class="lineno"> 492</span> table: <span class="stringliteral">&quot;InstanceUsers&quot;</span>,</div>
<div class="line"><a id="l00493" name="l00493"></a><span class="lineno"> 493</span> columns: <span class="keyword">new</span>[] { <span class="stringliteral">&quot;UserId&quot;</span>, <span class="stringliteral">&quot;InstanceId&quot;</span> },</div>
<div class="line"><a id="l00494" name="l00494"></a><span class="lineno"> 494</span> unique: <span class="keyword">true</span>);</div>
<div class="line"><a id="l00495" name="l00495"></a><span class="lineno"> 495</span> </div>
<div class="line"><a id="l00496" name="l00496"></a><span class="lineno"> 496</span> migrationBuilder.CreateIndex(</div>
<div class="line"><a id="l00497" name="l00497"></a><span class="lineno"> 497</span> name: <span class="stringliteral">&quot;IX_Jobs_CancelledById&quot;</span>,</div>
<div class="line"><a id="l00498" name="l00498"></a><span class="lineno"> 498</span> table: <span class="stringliteral">&quot;Jobs&quot;</span>,</div>
<div class="line"><a id="l00499" name="l00499"></a><span class="lineno"> 499</span> column: <span class="stringliteral">&quot;CancelledById&quot;</span>);</div>
<div class="line"><a id="l00500" name="l00500"></a><span class="lineno"> 500</span> </div>
<div class="line"><a id="l00501" name="l00501"></a><span class="lineno"> 501</span> migrationBuilder.CreateIndex(</div>
<div class="line"><a id="l00502" name="l00502"></a><span class="lineno"> 502</span> name: <span class="stringliteral">&quot;IX_Jobs_InstanceId&quot;</span>,</div>
<div class="line"><a id="l00503" name="l00503"></a><span class="lineno"> 503</span> table: <span class="stringliteral">&quot;Jobs&quot;</span>,</div>
<div class="line"><a id="l00504" name="l00504"></a><span class="lineno"> 504</span> column: <span class="stringliteral">&quot;InstanceId&quot;</span>);</div>
<div class="line"><a id="l00505" name="l00505"></a><span class="lineno"> 505</span> </div>
<div class="line"><a id="l00506" name="l00506"></a><span class="lineno"> 506</span> migrationBuilder.CreateIndex(</div>
<div class="line"><a id="l00507" name="l00507"></a><span class="lineno"> 507</span> name: <span class="stringliteral">&quot;IX_Jobs_StartedById&quot;</span>,</div>
<div class="line"><a id="l00508" name="l00508"></a><span class="lineno"> 508</span> table: <span class="stringliteral">&quot;Jobs&quot;</span>,</div>
<div class="line"><a id="l00509" name="l00509"></a><span class="lineno"> 509</span> column: <span class="stringliteral">&quot;StartedById&quot;</span>);</div>
<div class="line"><a id="l00510" name="l00510"></a><span class="lineno"> 510</span> </div>
<div class="line"><a id="l00511" name="l00511"></a><span class="lineno"> 511</span> migrationBuilder.CreateIndex(</div>
<div class="line"><a id="l00512" name="l00512"></a><span class="lineno"> 512</span> name: <span class="stringliteral">&quot;IX_ReattachInformations_CompileJobId&quot;</span>,</div>
<div class="line"><a id="l00513" name="l00513"></a><span class="lineno"> 513</span> table: <span class="stringliteral">&quot;ReattachInformations&quot;</span>,</div>
<div class="line"><a id="l00514" name="l00514"></a><span class="lineno"> 514</span> column: <span class="stringliteral">&quot;CompileJobId&quot;</span>);</div>
<div class="line"><a id="l00515" name="l00515"></a><span class="lineno"> 515</span> </div>
<div class="line"><a id="l00516" name="l00516"></a><span class="lineno"> 516</span> migrationBuilder.CreateIndex(</div>
<div class="line"><a id="l00517" name="l00517"></a><span class="lineno"> 517</span> name: <span class="stringliteral">&quot;IX_RepositorySettings_InstanceId&quot;</span>,</div>
<div class="line"><a id="l00518" name="l00518"></a><span class="lineno"> 518</span> table: <span class="stringliteral">&quot;RepositorySettings&quot;</span>,</div>
<div class="line"><a id="l00519" name="l00519"></a><span class="lineno"> 519</span> column: <span class="stringliteral">&quot;InstanceId&quot;</span>,</div>
<div class="line"><a id="l00520" name="l00520"></a><span class="lineno"> 520</span> unique: <span class="keyword">true</span>);</div>
<div class="line"><a id="l00521" name="l00521"></a><span class="lineno"> 521</span> </div>
<div class="line"><a id="l00522" name="l00522"></a><span class="lineno"> 522</span> migrationBuilder.CreateIndex(</div>
<div class="line"><a id="l00523" name="l00523"></a><span class="lineno"> 523</span> name: <span class="stringliteral">&quot;IX_RevInfoTestMerges_RevisionInformationId&quot;</span>,</div>
<div class="line"><a id="l00524" name="l00524"></a><span class="lineno"> 524</span> table: <span class="stringliteral">&quot;RevInfoTestMerges&quot;</span>,</div>
<div class="line"><a id="l00525" name="l00525"></a><span class="lineno"> 525</span> column: <span class="stringliteral">&quot;RevisionInformationId&quot;</span>);</div>
<div class="line"><a id="l00526" name="l00526"></a><span class="lineno"> 526</span> </div>
<div class="line"><a id="l00527" name="l00527"></a><span class="lineno"> 527</span> migrationBuilder.CreateIndex(</div>
<div class="line"><a id="l00528" name="l00528"></a><span class="lineno"> 528</span> name: <span class="stringliteral">&quot;IX_RevInfoTestMerges_TestMergeId&quot;</span>,</div>
<div class="line"><a id="l00529" name="l00529"></a><span class="lineno"> 529</span> table: <span class="stringliteral">&quot;RevInfoTestMerges&quot;</span>,</div>
<div class="line"><a id="l00530" name="l00530"></a><span class="lineno"> 530</span> column: <span class="stringliteral">&quot;TestMergeId&quot;</span>);</div>
<div class="line"><a id="l00531" name="l00531"></a><span class="lineno"> 531</span> </div>
<div class="line"><a id="l00532" name="l00532"></a><span class="lineno"> 532</span> migrationBuilder.CreateIndex(</div>
<div class="line"><a id="l00533" name="l00533"></a><span class="lineno"> 533</span> name: <span class="stringliteral">&quot;IX_RevisionInformations_CommitSha&quot;</span>,</div>
<div class="line"><a id="l00534" name="l00534"></a><span class="lineno"> 534</span> table: <span class="stringliteral">&quot;RevisionInformations&quot;</span>,</div>
<div class="line"><a id="l00535" name="l00535"></a><span class="lineno"> 535</span> column: <span class="stringliteral">&quot;CommitSha&quot;</span>,</div>
<div class="line"><a id="l00536" name="l00536"></a><span class="lineno"> 536</span> unique: <span class="keyword">true</span>);</div>
<div class="line"><a id="l00537" name="l00537"></a><span class="lineno"> 537</span> </div>
<div class="line"><a id="l00538" name="l00538"></a><span class="lineno"> 538</span> migrationBuilder.CreateIndex(</div>
<div class="line"><a id="l00539" name="l00539"></a><span class="lineno"> 539</span> name: <span class="stringliteral">&quot;IX_RevisionInformations_InstanceId&quot;</span>,</div>
<div class="line"><a id="l00540" name="l00540"></a><span class="lineno"> 540</span> table: <span class="stringliteral">&quot;RevisionInformations&quot;</span>,</div>
<div class="line"><a id="l00541" name="l00541"></a><span class="lineno"> 541</span> column: <span class="stringliteral">&quot;InstanceId&quot;</span>);</div>
<div class="line"><a id="l00542" name="l00542"></a><span class="lineno"> 542</span> </div>
<div class="line"><a id="l00543" name="l00543"></a><span class="lineno"> 543</span> migrationBuilder.CreateIndex(</div>
<div class="line"><a id="l00544" name="l00544"></a><span class="lineno"> 544</span> name: <span class="stringliteral">&quot;IX_TestMerges_MergedById&quot;</span>,</div>
<div class="line"><a id="l00545" name="l00545"></a><span class="lineno"> 545</span> table: <span class="stringliteral">&quot;TestMerges&quot;</span>,</div>
<div class="line"><a id="l00546" name="l00546"></a><span class="lineno"> 546</span> column: <span class="stringliteral">&quot;MergedById&quot;</span>);</div>
<div class="line"><a id="l00547" name="l00547"></a><span class="lineno"> 547</span> </div>
<div class="line"><a id="l00548" name="l00548"></a><span class="lineno"> 548</span> migrationBuilder.CreateIndex(</div>
<div class="line"><a id="l00549" name="l00549"></a><span class="lineno"> 549</span> name: <span class="stringliteral">&quot;IX_TestMerges_PrimaryRevisionInformationId&quot;</span>,</div>
<div class="line"><a id="l00550" name="l00550"></a><span class="lineno"> 550</span> table: <span class="stringliteral">&quot;TestMerges&quot;</span>,</div>
<div class="line"><a id="l00551" name="l00551"></a><span class="lineno"> 551</span> column: <span class="stringliteral">&quot;PrimaryRevisionInformationId&quot;</span>,</div>
<div class="line"><a id="l00552" name="l00552"></a><span class="lineno"> 552</span> unique: <span class="keyword">true</span>,</div>
<div class="line"><a id="l00553" name="l00553"></a><span class="lineno"> 553</span> filter: <span class="stringliteral">&quot;[PrimaryRevisionInformationId] IS NOT NULL&quot;</span>);</div>
<div class="line"><a id="l00554" name="l00554"></a><span class="lineno"> 554</span> </div>
<div class="line"><a id="l00555" name="l00555"></a><span class="lineno"> 555</span> migrationBuilder.CreateIndex(</div>
<div class="line"><a id="l00556" name="l00556"></a><span class="lineno"> 556</span> name: <span class="stringliteral">&quot;IX_Users_CanonicalName&quot;</span>,</div>
<div class="line"><a id="l00557" name="l00557"></a><span class="lineno"> 557</span> table: <span class="stringliteral">&quot;Users&quot;</span>,</div>
<div class="line"><a id="l00558" name="l00558"></a><span class="lineno"> 558</span> column: <span class="stringliteral">&quot;CanonicalName&quot;</span>,</div>
<div class="line"><a id="l00559" name="l00559"></a><span class="lineno"> 559</span> unique: <span class="keyword">true</span>);</div>
<div class="line"><a id="l00560" name="l00560"></a><span class="lineno"> 560</span> </div>
<div class="line"><a id="l00561" name="l00561"></a><span class="lineno"> 561</span> migrationBuilder.CreateIndex(</div>
<div class="line"><a id="l00562" name="l00562"></a><span class="lineno"> 562</span> name: <span class="stringliteral">&quot;IX_Users_CreatedById&quot;</span>,</div>
<div class="line"><a id="l00563" name="l00563"></a><span class="lineno"> 563</span> table: <span class="stringliteral">&quot;Users&quot;</span>,</div>
<div class="line"><a id="l00564" name="l00564"></a><span class="lineno"> 564</span> column: <span class="stringliteral">&quot;CreatedById&quot;</span>);</div>
<div class="line"><a id="l00565" name="l00565"></a><span class="lineno"> 565</span> </div>
<div class="line"><a id="l00566" name="l00566"></a><span class="lineno"> 566</span> migrationBuilder.CreateIndex(</div>
<div class="line"><a id="l00567" name="l00567"></a><span class="lineno"> 567</span> name: <span class="stringliteral">&quot;IX_WatchdogReattachInformations_AlphaId&quot;</span>,</div>
<div class="line"><a id="l00568" name="l00568"></a><span class="lineno"> 568</span> table: <span class="stringliteral">&quot;WatchdogReattachInformations&quot;</span>,</div>
<div class="line"><a id="l00569" name="l00569"></a><span class="lineno"> 569</span> column: <span class="stringliteral">&quot;AlphaId&quot;</span>);</div>
<div class="line"><a id="l00570" name="l00570"></a><span class="lineno"> 570</span> </div>
<div class="line"><a id="l00571" name="l00571"></a><span class="lineno"> 571</span> migrationBuilder.CreateIndex(</div>
<div class="line"><a id="l00572" name="l00572"></a><span class="lineno"> 572</span> name: <span class="stringliteral">&quot;IX_WatchdogReattachInformations_BravoId&quot;</span>,</div>
<div class="line"><a id="l00573" name="l00573"></a><span class="lineno"> 573</span> table: <span class="stringliteral">&quot;WatchdogReattachInformations&quot;</span>,</div>
<div class="line"><a id="l00574" name="l00574"></a><span class="lineno"> 574</span> column: <span class="stringliteral">&quot;BravoId&quot;</span>);</div>
<div class="line"><a id="l00575" name="l00575"></a><span class="lineno"> 575</span> </div>
<div class="line"><a id="l00576" name="l00576"></a><span class="lineno"> 576</span> migrationBuilder.AddForeignKey(</div>
<div class="line"><a id="l00577" name="l00577"></a><span class="lineno"> 577</span> name: <span class="stringliteral">&quot;FK_ChatChannels_ChatBots_ChatSettingsId&quot;</span>,</div>
<div class="line"><a id="l00578" name="l00578"></a><span class="lineno"> 578</span> table: <span class="stringliteral">&quot;ChatChannels&quot;</span>,</div>
<div class="line"><a id="l00579" name="l00579"></a><span class="lineno"> 579</span> column: <span class="stringliteral">&quot;ChatSettingsId&quot;</span>,</div>
<div class="line"><a id="l00580" name="l00580"></a><span class="lineno"> 580</span> principalTable: <span class="stringliteral">&quot;ChatBots&quot;</span>,</div>
<div class="line"><a id="l00581" name="l00581"></a><span class="lineno"> 581</span> principalColumn: <span class="stringliteral">&quot;Id&quot;</span>,</div>
<div class="line"><a id="l00582" name="l00582"></a><span class="lineno"> 582</span> onDelete: ReferentialAction.Cascade);</div>
<div class="line"><a id="l00583" name="l00583"></a><span class="lineno"> 583</span> </div>
<div class="line"><a id="l00584" name="l00584"></a><span class="lineno"> 584</span> migrationBuilder.AddForeignKey(</div>
<div class="line"><a id="l00585" name="l00585"></a><span class="lineno"> 585</span> name: <span class="stringliteral">&quot;FK_ReattachInformations_CompileJobs_CompileJobId&quot;</span>,</div>
<div class="line"><a id="l00586" name="l00586"></a><span class="lineno"> 586</span> table: <span class="stringliteral">&quot;ReattachInformations&quot;</span>,</div>
<div class="line"><a id="l00587" name="l00587"></a><span class="lineno"> 587</span> column: <span class="stringliteral">&quot;CompileJobId&quot;</span>,</div>
<div class="line"><a id="l00588" name="l00588"></a><span class="lineno"> 588</span> principalTable: <span class="stringliteral">&quot;CompileJobs&quot;</span>,</div>
<div class="line"><a id="l00589" name="l00589"></a><span class="lineno"> 589</span> principalColumn: <span class="stringliteral">&quot;Id&quot;</span>,</div>
<div class="line"><a id="l00590" name="l00590"></a><span class="lineno"> 590</span> onDelete: ReferentialAction.Restrict);</div>
<div class="line"><a id="l00591" name="l00591"></a><span class="lineno"> 591</span> }</div>
</div>
<div class="line"><a id="l00592" name="l00592"></a><span class="lineno"> 592</span> </div>
<div class="foldopen" id="foldopen00594" data-start="{" data-end="}">
<div class="line"><a id="l00594" name="l00594"></a><span class="lineno"><a class="line" href="class_tgstation_1_1_server_1_1_host_1_1_database_1_1_migrations_1_1_m_s_initial_create.html#ae0f4cc2dd9b29f92f03b254d9411140b"> 594</a></span> <span class="keyword">protected</span> <span class="keyword">override</span> <span class="keywordtype">void</span> <a class="code hl_function" href="class_tgstation_1_1_server_1_1_host_1_1_database_1_1_migrations_1_1_m_s_initial_create.html#ae0f4cc2dd9b29f92f03b254d9411140b">Down</a>(MigrationBuilder migrationBuilder)</div>
<div class="line"><a id="l00595" name="l00595"></a><span class="lineno"> 595</span> {</div>
<div class="line"><a id="l00596" name="l00596"></a><span class="lineno"> 596</span> ArgumentNullException.ThrowIfNull(migrationBuilder);</div>
<div class="line"><a id="l00597" name="l00597"></a><span class="lineno"> 597</span> </div>
<div class="line"><a id="l00598" name="l00598"></a><span class="lineno"> 598</span> migrationBuilder.DropForeignKey(</div>
<div class="line"><a id="l00599" name="l00599"></a><span class="lineno"> 599</span> name: <span class="stringliteral">&quot;FK_Jobs_Instances_InstanceId&quot;</span>,</div>
<div class="line"><a id="l00600" name="l00600"></a><span class="lineno"> 600</span> table: <span class="stringliteral">&quot;Jobs&quot;</span>);</div>
<div class="line"><a id="l00601" name="l00601"></a><span class="lineno"> 601</span> </div>
<div class="line"><a id="l00602" name="l00602"></a><span class="lineno"> 602</span> migrationBuilder.DropForeignKey(</div>
<div class="line"><a id="l00603" name="l00603"></a><span class="lineno"> 603</span> name: <span class="stringliteral">&quot;FK_RevisionInformations_Instances_InstanceId&quot;</span>,</div>
<div class="line"><a id="l00604" name="l00604"></a><span class="lineno"> 604</span> table: <span class="stringliteral">&quot;RevisionInformations&quot;</span>);</div>
<div class="line"><a id="l00605" name="l00605"></a><span class="lineno"> 605</span> </div>
<div class="line"><a id="l00606" name="l00606"></a><span class="lineno"> 606</span> migrationBuilder.DropTable(</div>
<div class="line"><a id="l00607" name="l00607"></a><span class="lineno"> 607</span> name: <span class="stringliteral">&quot;ChatChannels&quot;</span>);</div>
<div class="line"><a id="l00608" name="l00608"></a><span class="lineno"> 608</span> </div>
<div class="line"><a id="l00609" name="l00609"></a><span class="lineno"> 609</span> migrationBuilder.DropTable(</div>
<div class="line"><a id="l00610" name="l00610"></a><span class="lineno"> 610</span> name: <span class="stringliteral">&quot;DreamDaemonSettings&quot;</span>);</div>
<div class="line"><a id="l00611" name="l00611"></a><span class="lineno"> 611</span> </div>
<div class="line"><a id="l00612" name="l00612"></a><span class="lineno"> 612</span> migrationBuilder.DropTable(</div>
<div class="line"><a id="l00613" name="l00613"></a><span class="lineno"> 613</span> name: <span class="stringliteral">&quot;DreamMakerSettings&quot;</span>);</div>
<div class="line"><a id="l00614" name="l00614"></a><span class="lineno"> 614</span> </div>
<div class="line"><a id="l00615" name="l00615"></a><span class="lineno"> 615</span> migrationBuilder.DropTable(</div>
<div class="line"><a id="l00616" name="l00616"></a><span class="lineno"> 616</span> name: <span class="stringliteral">&quot;InstanceUsers&quot;</span>);</div>
<div class="line"><a id="l00617" name="l00617"></a><span class="lineno"> 617</span> </div>
<div class="line"><a id="l00618" name="l00618"></a><span class="lineno"> 618</span> migrationBuilder.DropTable(</div>
<div class="line"><a id="l00619" name="l00619"></a><span class="lineno"> 619</span> name: <span class="stringliteral">&quot;RepositorySettings&quot;</span>);</div>
<div class="line"><a id="l00620" name="l00620"></a><span class="lineno"> 620</span> </div>
<div class="line"><a id="l00621" name="l00621"></a><span class="lineno"> 621</span> migrationBuilder.DropTable(</div>
<div class="line"><a id="l00622" name="l00622"></a><span class="lineno"> 622</span> name: <span class="stringliteral">&quot;RevInfoTestMerges&quot;</span>);</div>
<div class="line"><a id="l00623" name="l00623"></a><span class="lineno"> 623</span> </div>
<div class="line"><a id="l00624" name="l00624"></a><span class="lineno"> 624</span> migrationBuilder.DropTable(</div>
<div class="line"><a id="l00625" name="l00625"></a><span class="lineno"> 625</span> name: <span class="stringliteral">&quot;ChatBots&quot;</span>);</div>
<div class="line"><a id="l00626" name="l00626"></a><span class="lineno"> 626</span> </div>
<div class="line"><a id="l00627" name="l00627"></a><span class="lineno"> 627</span> migrationBuilder.DropTable(</div>
<div class="line"><a id="l00628" name="l00628"></a><span class="lineno"> 628</span> name: <span class="stringliteral">&quot;TestMerges&quot;</span>);</div>
<div class="line"><a id="l00629" name="l00629"></a><span class="lineno"> 629</span> </div>
<div class="line"><a id="l00630" name="l00630"></a><span class="lineno"> 630</span> migrationBuilder.DropTable(</div>
<div class="line"><a id="l00631" name="l00631"></a><span class="lineno"> 631</span> name: <span class="stringliteral">&quot;Instances&quot;</span>);</div>
<div class="line"><a id="l00632" name="l00632"></a><span class="lineno"> 632</span> </div>
<div class="line"><a id="l00633" name="l00633"></a><span class="lineno"> 633</span> migrationBuilder.DropTable(</div>
<div class="line"><a id="l00634" name="l00634"></a><span class="lineno"> 634</span> name: <span class="stringliteral">&quot;WatchdogReattachInformations&quot;</span>);</div>
<div class="line"><a id="l00635" name="l00635"></a><span class="lineno"> 635</span> </div>
<div class="line"><a id="l00636" name="l00636"></a><span class="lineno"> 636</span> migrationBuilder.DropTable(</div>
<div class="line"><a id="l00637" name="l00637"></a><span class="lineno"> 637</span> name: <span class="stringliteral">&quot;ReattachInformations&quot;</span>);</div>
<div class="line"><a id="l00638" name="l00638"></a><span class="lineno"> 638</span> </div>
<div class="line"><a id="l00639" name="l00639"></a><span class="lineno"> 639</span> migrationBuilder.DropTable(</div>
<div class="line"><a id="l00640" name="l00640"></a><span class="lineno"> 640</span> name: <span class="stringliteral">&quot;CompileJobs&quot;</span>);</div>
<div class="line"><a id="l00641" name="l00641"></a><span class="lineno"> 641</span> </div>
<div class="line"><a id="l00642" name="l00642"></a><span class="lineno"> 642</span> migrationBuilder.DropTable(</div>
<div class="line"><a id="l00643" name="l00643"></a><span class="lineno"> 643</span> name: <span class="stringliteral">&quot;Jobs&quot;</span>);</div>
<div class="line"><a id="l00644" name="l00644"></a><span class="lineno"> 644</span> </div>
<div class="line"><a id="l00645" name="l00645"></a><span class="lineno"> 645</span> migrationBuilder.DropTable(</div>
<div class="line"><a id="l00646" name="l00646"></a><span class="lineno"> 646</span> name: <span class="stringliteral">&quot;RevisionInformations&quot;</span>);</div>
<div class="line"><a id="l00647" name="l00647"></a><span class="lineno"> 647</span> </div>
<div class="line"><a id="l00648" name="l00648"></a><span class="lineno"> 648</span> migrationBuilder.DropTable(</div>
<div class="line"><a id="l00649" name="l00649"></a><span class="lineno"> 649</span> name: <span class="stringliteral">&quot;Users&quot;</span>);</div>
<div class="line"><a id="l00650" name="l00650"></a><span class="lineno"> 650</span> }</div>
</div>
<div class="line"><a id="l00651" name="l00651"></a><span class="lineno"> 651</span> }</div>
</div>
<div class="line"><a id="l00652" name="l00652"></a><span class="lineno"> 652</span>}</div>
</div>
<div class="ttc" id="aclass_migration_html"><div class="ttname"><a href="class_migration.html">Migration</a></div></div>
<div class="ttc" id="aclass_tgstation_1_1_server_1_1_host_1_1_database_1_1_migrations_1_1_m_s_initial_create_html"><div class="ttname"><a href="class_tgstation_1_1_server_1_1_host_1_1_database_1_1_migrations_1_1_m_s_initial_create.html">Tgstation.Server.Host.Database.Migrations.MSInitialCreate</a></div><div class="ttdoc">The initial database migration for MSSQL.</div><div class="ttdef"><b>Definition</b> <a href="20180906135553___m_s_initial_create_8cs_source.html#l00012">20180906135553_MSInitialCreate.cs:13</a></div></div>
<div class="ttc" id="aclass_tgstation_1_1_server_1_1_host_1_1_database_1_1_migrations_1_1_m_s_initial_create_html_a7df7a394603b58660e31804151c6b596"><div class="ttname"><a href="class_tgstation_1_1_server_1_1_host_1_1_database_1_1_migrations_1_1_m_s_initial_create.html#a7df7a394603b58660e31804151c6b596">Tgstation.Server.Host.Database.Migrations.MSInitialCreate.Up</a></div><div class="ttdeci">override void Up(MigrationBuilder migrationBuilder)</div><div class="ttdef"><b>Definition</b> <a href="20180906135553___m_s_initial_create_8cs_source.html#l00015">20180906135553_MSInitialCreate.cs:15</a></div></div>
<div class="ttc" id="aclass_tgstation_1_1_server_1_1_host_1_1_database_1_1_migrations_1_1_m_s_initial_create_html_ae0f4cc2dd9b29f92f03b254d9411140b"><div class="ttname"><a href="class_tgstation_1_1_server_1_1_host_1_1_database_1_1_migrations_1_1_m_s_initial_create.html#ae0f4cc2dd9b29f92f03b254d9411140b">Tgstation.Server.Host.Database.Migrations.MSInitialCreate.Down</a></div><div class="ttdeci">override void Down(MigrationBuilder migrationBuilder)</div><div class="ttdef"><b>Definition</b> <a href="20180906135553___m_s_initial_create_8cs_source.html#l00594">20180906135553_MSInitialCreate.cs:594</a></div></div>
<div class="ttc" id="anamespace_tgstation_1_1_server_1_1_host_1_1_database_1_1_migrations_html"><div class="ttname"><a href="namespace_tgstation_1_1_server_1_1_host_1_1_database_1_1_migrations.html">Tgstation.Server.Host.Database.Migrations</a></div><div class="ttdef"><b>Definition</b> <a href="20180906135553___m_s_initial_create_8cs_source.html#l00006">20180906135553_MSInitialCreate.cs:7</a></div></div>
<div class="ttc" id="anamespace_tgstation_1_1_server_1_1_host_html_a71712cdd4f38be5482e1d08905c0c308a00d23a76e43b46dae9ec7aa9dcbebb32"><div class="ttname"><a href="namespace_tgstation_1_1_server_1_1_host.html#a71712cdd4f38be5482e1d08905c0c308a00d23a76e43b46dae9ec7aa9dcbebb32">Tgstation.Server.Host.OAuthGatewayStatus.Enabled</a></div><div class="ttdeci">@ Enabled</div><div class="ttdoc">The OAuth Gateway is enabled.</div></div>
</div><!-- fragment --></div><!-- contents -->
<!-- start footer part -->
<hr class="footer"/><address class="footer"><small>
Generated by&#160;<a href="https://www.doxygen.org/index.html"><img class="footer" src="doxygen.svg" width="104" height="31" alt="doxygen"/></a> 1.9.8
</small></address>
</body>
</html>
Reference in New Issue View Git Blame Copy Permalink