Skip to content

Instantly share code, notes, and snippets.

@cfm

cfm/diff.html

Created July 1, 2022 01:36
Show Gist options
  • Save cfm/6bfc6e9cc3c5db990e8de2cea9b703b1 to your computer and use it in GitHub Desktop.
Save cfm/6bfc6e9cc3c5db990e8de2cea9b703b1 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
diff.html
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8" />
<meta http-equiv="x-ua-compatible" content="IE=edge">
<meta name="referrer" content="no-referrer" />
<meta name="generator" content="diffoscope" />
<link rel="icon" type="image/png" href="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAADdgAAA3YBfdWCzAAAABl0RVh0U29mdHdhcmUAd3d3Lmlua3NjYXBlLm9yZ5vuPBoAAAM8SURBVFiF7dZdaJZlGAfw3/O+e9XNjy3XllZzWImBxIpifqTgsmUHBSIeBNFBdRh0UHQ0xGdb66CFBIERZEFRQRRUw0HkQkLMYQSBdpCFWdgSP6jpNn2393k68Nn2bj3vXtb6UOh/cl/39b/u67mem/913zf/4z9GUDw5xNI8n5WIzW9m/QF2YluJmI8203mALzEvLWAerRs4Pz6vSIkZSlsYk0/GkaB0zEgyDgWMlijyWsJuS2fkQwu8pqpMTA0ypeiShG71Bp0rU8Q+A47MWEDgvHZbZl/Av4SpIgxVYB3IqwZDmoUuYkzosDaNchpAoFqkSmgjGPWzLieF1k3JHVsjvCJQHBYaSy9g1E3m+QImQiK9SbNGqJDzuiDZ0lggQJCsyelDq8BB47sbCWTsnvhG3kqcLL833eqF4hk1EOoTOjZjnnaRdq2l6KtMAyl4/g23bKJrun+Mt9uOq7nvqOVbebWYy9Adc1fM/R/3CO780dONbIeFPHsPw+ULeM5ZHTbXHfUtXpxOZzgT5z02UGsZThRzF/ilht9G+fr4zfbfccIxXIa7uVTup69i7LJXaEEqF3on1d9ludBLpVLOVoT1lky9QYtwQ6p3WAVqSyUslWwSbRrkPJrMtgn0iBVk7BPJ4sGE24EPQKW3jLgdzWKLBTbg0yTuZeGkDsp2gcUGDesHGQ/gK5G8nLMigWiCe3jCrnTRiJ9EYjm1ImsUEq5l8hScPXbpsVtlKhfan+pv0yD0ZqmU5XegGBmnDIo/pylj8oYLOP3Eab/v5Zmi6EtZ3vv1FU/2r7LioYSL2dNybbdiMdptFU57++20Vqh+iq/Tap1WpaWY611wmyWyUzxZDbIWTvEV1Ildn5agfBumoUMTtoisFvhebAAHZWxX0ChwTuScvHdVeVykToysMyJ7ittwbmj31J+6IrRDp5XTfBt1WJ+WYnZdMB0F3xlUgD5uDVj2Sa+a4SrzH+FeyHHmw17V112waBOZgP4WczkLZsILar1fpIliMU4XZoK/poE0XHl+N8v6QcGAUbVymnDIZVnzrTXqGzmnhKLxZX/niyiDjIJgwg4Se1GR/Y8idGPysh6fr0i1i/AHMWHgrwUJgNAAAAAASUVORK5CYII=" />
<title>/home/user/securedrop-client/.venv/bin/diffoscope --html diff.html --no-default-limits old.sql svs.sql</title>
<style>
body.diffoscope {
background: white;
color: black;
}
.diffoscope .footer {
font-size: small;
}
.diffoscope .difference {
border: outset #888 1px;
background: #E8E8E8;
background: rgba(0,0,0,.1);
padding: 0.5em;
margin: 0.5em 0;
}
.diffoscope .difference table {
table-layout: fixed;
width: 100%;
border: 0;
}
.diffoscope .difference th,
.diffoscope .difference td {
border: 0;
}
.diffoscope table.diff {
border: 0;
border-collapse:collapse;
font-size:0.75em;
font-family: 'Lucida Console', monospace;
word-break: break-word;
}
.diffoscope table.diff tr:hover td {
background: #FFFF00;
}
.diffoscope .line {
color:#8080a0
}
.diffoscope th {
background: black;
color: white
}
.diffoscope .diffunmodified td {
background: #D0D0E0
}
.diffoscope .diffhunk td {
background: #A0A0A0
}
.diffoscope .diffadded td {
background: #CCFFCC
}
.diffoscope .diffdeleted td {
background: #FFCCCC
}
.diffoscope .diffchanged td {
background: #FFFFA0
}
.diffoscope ins, del {
background: #E0C880;
text-decoration: none
}
.diffoscope .dp {
color: #B08080
}
.diffoscope .comment {
font-style: italic;
}
.diffoscope .comment.multiline {
font-style: normal;
font-family: monospace;
white-space: pre;
}
.diffoscope .source {
font-weight: bold;
}
.diffoscope .error {
border: solid black 1px;
background: red;
color: white;
padding: 0.2em;
}
.diffoscope .anchor {
margin-left: 0.5em;
font-size: 80%;
color: #333;
text-decoration: none;
display: none;
}
.diffoscope .diffheader:hover .anchor {
display: inline;
}
.diffoscope .diffcontrol, .diffoscope .diffcontrol-nochildren {
float: left;
margin-right: 0.3em;
cursor: pointer;
display: none; /* currently, only available in html-dir output where jquery is enabled */
}
.diffoscope .colines {
width: 3em;
}
.diffoscope .coldiff {
width: 99%;
}
.diffoscope .diffsize {
float: right;
}
.diffoscope table.diff tr.ondemand td, .diffoscope div.ondemand-details {
background: #f99;
text-align: center;
padding: 0.5em 0;
}
.diffoscope table.diff tr.ondemand:hover td, .diffoscope div.ondemand-details:hover {
background: #faa;
cursor: pointer;
}
</style>
</head>
<body class="diffoscope">
<div class="difference">
<div class="diffheader">
<div class="diffcontrol diffcontrol-double">⊟</div>
<div><span class="diffsize">4.39 KB</span></div>
<div><span class="source">old.sql</span> vs.</div>
<div id="top"><span class="source">svs.sql</span>
<a class="anchor" href="#top">¶</a>
</div>
</div>
<table class="diff">
<colgroup><col class="colines"/><col class="coldiff"/>
<col class="colines"/><col class="coldiff"/></colgroup>
<tr style="display:none;"><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td></tr>
<tr class="diffhunk"><td colspan="2">Offset 2, 15 lines modified</td><td colspan="2">Offset 2, 15 lines modified</td></tr>
<tr class="diffunmodified"><td class="diffline">2 </td><td class="diffpresent">BEGIN<span class="dp">·</span>TRANSACTION;</td><td class="diffline">2 </td><td class="diffpresent">BEGIN<span class="dp">·</span>TRANSACTION;</td></tr>
<tr class="diffunmodified"><td class="diffline">3 </td><td class="diffpresent">CREATE<span class="dp">·</span>TABLE<span class="dp">·</span>alembic_version<span class="dp">·</span>(</td><td class="diffline">3 </td><td class="diffpresent">CREATE<span class="dp">·</span>TABLE<span class="dp">·</span>alembic_version<span class="dp">·</span>(</td></tr>
<tr class="diffunmodified"><td class="diffline">4 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>version_num<span class="dp">·</span>VARCHAR(32)<span class="dp">·</span>NOT<span class="dp">·</span>NULL,<span class="dp">·</span></td><td class="diffline">4 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>version_num<span class="dp">·</span>VARCHAR(32)<span class="dp">·</span>NOT<span class="dp">·</span>NULL,<span class="dp">·</span></td></tr>
<tr class="diffunmodified"><td class="diffline">5 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>CONSTRAINT<span class="dp">·</span>alembic_version_pkc<span class="dp">·</span>PRIMARY<span class="dp">·</span>KEY<span class="dp">·</span>(version_num)</td><td class="diffline">5 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>CONSTRAINT<span class="dp">·</span>alembic_version_pkc<span class="dp">·</span>PRIMARY<span class="dp">·</span>KEY<span class="dp">·</span>(version_num)</td></tr>
<tr class="diffunmodified"><td class="diffline">6 </td><td class="diffpresent">);</td><td class="diffline">6 </td><td class="diffpresent">);</td></tr>
<tr class="diffunmodified"><td class="diffline">7 </td><td class="diffpresent">INSERT<span class="dp">·</span>INTO<span class="dp">·</span>alembic_version<span class="dp">·</span></td><td class="diffline">7 </td><td class="diffpresent">INSERT<span class="dp">·</span>INTO<span class="dp">·</span>alembic_version<span class="dp">·</span></td></tr>
<tr class="diffunmodified"><td class="diffline">8 </td><td class="diffpresent">VALUES<span class="dp">·</span></td><td class="diffline">8 </td><td class="diffpresent">VALUES<span class="dp">·</span></td></tr>
<tr class="diffchanged"><td class="diffline">9 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>(&#x27;<del>9ba</del>8<del>d7</del>5<del>24</del>8<del>7</del><del>1</del>&#x27;);</td><td class="diffline">9 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>(&#x27;<ins>d7c</ins>8<ins>a</ins><ins>f9</ins>5<ins>bc</ins>8<ins>e</ins>&#x27;);</td></tr>
<tr class="diffunmodified"><td class="diffline">10 </td><td class="diffpresent">CREATE<span class="dp">·</span>TABLE<span class="dp">·</span>sources<span class="dp">·</span>(</td><td class="diffline">10 </td><td class="diffpresent">CREATE<span class="dp">·</span>TABLE<span class="dp">·</span>sources<span class="dp">·</span>(</td></tr>
<tr class="diffunmodified"><td class="diffline">11 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>id<span class="dp">·</span>INTEGER<span class="dp">·</span>NOT<span class="dp">·</span>NULL,<span class="dp">·</span></td><td class="diffline">11 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>id<span class="dp">·</span>INTEGER<span class="dp">·</span>NOT<span class="dp">·</span>NULL,<span class="dp">·</span></td></tr>
<tr class="diffunmodified"><td class="diffline">12 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>uuid<span class="dp">·</span>VARCHAR(36)<span class="dp">·</span>NOT<span class="dp">·</span>NULL,<span class="dp">·</span></td><td class="diffline">12 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>uuid<span class="dp">·</span>VARCHAR(36)<span class="dp">·</span>NOT<span class="dp">·</span>NULL,<span class="dp">·</span></td></tr>
<tr class="diffunmodified"><td class="diffline">13 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>journalist_designation<span class="dp">·</span>VARCHAR(255)<span class="dp">·</span>NOT<span class="dp">·</span>NULL,<span class="dp">·</span></td><td class="diffline">13 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>journalist_designation<span class="dp">·</span>VARCHAR(255)<span class="dp">·</span>NOT<span class="dp">·</span>NULL,<span class="dp">·</span></td></tr>
<tr class="diffunmodified"><td class="diffline">14 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>document_count<span class="dp">·</span>INTEGER<span class="dp">·</span>DEFAULT<span class="dp">·</span>0<span class="dp">·</span>NOT<span class="dp">·</span>NULL,<span class="dp">·</span></td><td class="diffline">14 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>document_count<span class="dp">·</span>INTEGER<span class="dp">·</span>DEFAULT<span class="dp">·</span>0<span class="dp">·</span>NOT<span class="dp">·</span>NULL,<span class="dp">·</span></td></tr>
<tr class="diffunmodified"><td class="diffline">15 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>is_flagged<span class="dp">·</span>BOOLEAN<span class="dp">·</span>DEFAULT<span class="dp">·</span>0,<span class="dp">·</span></td><td class="diffline">15 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>is_flagged<span class="dp">·</span>BOOLEAN<span class="dp">·</span>DEFAULT<span class="dp">·</span>0,<span class="dp">·</span></td></tr>
<tr class="diffunmodified"><td class="diffline">16 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>public_key<span class="dp">·</span>TEXT,<span class="dp">·</span></td><td class="diffline">16 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>public_key<span class="dp">·</span>TEXT,<span class="dp">·</span></td></tr>
<tr class="diffhunk"><td colspan="2">Offset 89, 25 lines modified</td><td colspan="2">Offset 89, 25 lines modified</td></tr>
<tr class="diffunmodified"><td class="diffline">89 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>download_error_id<span class="dp">·</span>INTEGER,<span class="dp">·</span></td><td class="diffline">89 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>download_error_id<span class="dp">·</span>INTEGER,<span class="dp">·</span></td></tr>
<tr class="diffunmodified"><td class="diffline">90 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>is_read<span class="dp">·</span>BOOLEAN<span class="dp">·</span>DEFAULT<span class="dp">·</span>0<span class="dp">·</span>NOT<span class="dp">·</span>NULL,<span class="dp">·</span></td><td class="diffline">90 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>is_read<span class="dp">·</span>BOOLEAN<span class="dp">·</span>DEFAULT<span class="dp">·</span>0<span class="dp">·</span>NOT<span class="dp">·</span>NULL,<span class="dp">·</span></td></tr>
<tr class="diffunmodified"><td class="diffline">91 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>source_id<span class="dp">·</span>INTEGER<span class="dp">·</span>NOT<span class="dp">·</span>NULL,<span class="dp">·</span></td><td class="diffline">91 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>source_id<span class="dp">·</span>INTEGER<span class="dp">·</span>NOT<span class="dp">·</span>NULL,<span class="dp">·</span></td></tr>
<tr class="diffunmodified"><td class="diffline">92 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>last_updated<span class="dp">·</span>DATETIME<span class="dp">·</span>NOT<span class="dp">·</span>NULL,<span class="dp">·</span></td><td class="diffline">92 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>last_updated<span class="dp">·</span>DATETIME<span class="dp">·</span>NOT<span class="dp">·</span>NULL,<span class="dp">·</span></td></tr>
<tr class="diffunmodified"><td class="diffline">93 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>CONSTRAINT<span class="dp">·</span>pk_files<span class="dp">·</span>PRIMARY<span class="dp">·</span>KEY<span class="dp">·</span>(id),<span class="dp">·</span></td><td class="diffline">93 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>CONSTRAINT<span class="dp">·</span>pk_files<span class="dp">·</span>PRIMARY<span class="dp">·</span>KEY<span class="dp">·</span>(id),<span class="dp">·</span></td></tr>
<tr class="diffunmodified"><td class="diffline">94 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>CONSTRAINT<span class="dp">·</span>uq_messages_source_id_file_counter<span class="dp">·</span>UNIQUE<span class="dp">·</span>(source_id,<span class="dp">·</span>file_counter),<span class="dp">·</span></td><td class="diffline">94 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>CONSTRAINT<span class="dp">·</span>uq_messages_source_id_file_counter<span class="dp">·</span>UNIQUE<span class="dp">·</span>(source_id,<span class="dp">·</span>file_counter),<span class="dp">·</span></td></tr>
<tr class="diffunmodified"><td class="diffline">95 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>CONSTRAINT<span class="dp">·</span>uq_files_uuid<span class="dp">·</span>UNIQUE<span class="dp">·</span>(uuid),<span class="dp">·</span></td><td class="diffline">95 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>CONSTRAINT<span class="dp">·</span>uq_files_uuid<span class="dp">·</span>UNIQUE<span class="dp">·</span>(uuid),<span class="dp">·</span></td></tr>
<tr class="diffadded"><td colspan="2"> </td><td class="diffline">96 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>CONSTRAINT<span class="dp">·</span>fk_files_download_error_id_downloaderrors<span class="dp">·</span>FOREIGN<span class="dp">·</span>KEY(download_error_id)<span class="dp">·</span>REFERENCES<span class="dp">·</span>downloaderrors<span class="dp">·</span>(id),<span class="dp">·</span></td></tr>
<tr class="diffadded"><td colspan="2"> </td><td class="diffline">97 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>CONSTRAINT<span class="dp">·</span>fk_files_source_id_sources<span class="dp">·</span>FOREIGN<span class="dp">·</span>KEY(source_id)<span class="dp">·</span>REFERENCES<span class="dp">·</span>sources<span class="dp">·</span>(id),<span class="dp">·</span></td></tr>
<tr class="diffunmodified"><td class="diffline">96 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>CONSTRAINT<span class="dp">·</span>ck_files_is_downloaded<span class="dp">·</span>CHECK<span class="dp">·</span>(</td><td class="diffline">98 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>CONSTRAINT<span class="dp">·</span>ck_files_is_downloaded<span class="dp">·</span>CHECK<span class="dp">·</span>(</td></tr>
<tr class="diffunmodified"><td class="diffline">97 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span><span class="dp">·</span><span class="dp">·</span>is_downloaded<span class="dp">·</span>IN<span class="dp">·</span>(0,<span class="dp">·</span>1)</td><td class="diffline">99 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span><span class="dp">·</span><span class="dp">·</span>is_downloaded<span class="dp">·</span>IN<span class="dp">·</span>(0,<span class="dp">·</span>1)</td></tr>
<tr class="diffunmodified"><td class="diffline">98 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>),<span class="dp">·</span></td><td class="diffline">100 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>),<span class="dp">·</span></td></tr>
<tr class="diffunmodified"><td class="diffline">99 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>CONSTRAINT<span class="dp">·</span>ck_files_is_decrypted<span class="dp">·</span>CHECK<span class="dp">·</span>(</td><td class="diffline">101 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>CONSTRAINT<span class="dp">·</span>ck_files_is_decrypted<span class="dp">·</span>CHECK<span class="dp">·</span>(</td></tr>
<tr class="diffunmodified"><td class="diffline">100 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span><span class="dp">·</span><span class="dp">·</span>is_decrypted<span class="dp">·</span>IN<span class="dp">·</span>(0,<span class="dp">·</span>1)</td><td class="diffline">102 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span><span class="dp">·</span><span class="dp">·</span>is_decrypted<span class="dp">·</span>IN<span class="dp">·</span>(0,<span class="dp">·</span>1)</td></tr>
<tr class="diffunmodified"><td class="diffline">101 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>),<span class="dp">·</span></td><td class="diffline">103 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>),<span class="dp">·</span></td></tr>
<tr class="diffdeleted"><td class="diffline">102 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>CONSTRAINT<span class="dp">·</span>fk_files_download_error_id_downloaderrors<span class="dp">·</span>FOREIGN<span class="dp">·</span>KEY(download_error_id)<span class="dp">·</span>REFERENCES<span class="dp">·</span>downloaderrors<span class="dp">·</span>(id),<span class="dp">·</span></td><td colspan="2"> </td></tr>
<tr class="diffunmodified"><td class="diffline">103 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>CONSTRAINT<span class="dp">·</span>ck_files_is_read<span class="dp">·</span>CHECK<span class="dp">·</span>(</td><td class="diffline">104 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>CONSTRAINT<span class="dp">·</span>ck_files_is_read<span class="dp">·</span>CHECK<span class="dp">·</span>(</td></tr>
<tr class="diffunmodified"><td class="diffline">104 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span><span class="dp">·</span><span class="dp">·</span>is_read<span class="dp">·</span>IN<span class="dp">·</span>(0,<span class="dp">·</span>1)</td><td class="diffline">105 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span><span class="dp">·</span><span class="dp">·</span>is_read<span class="dp">·</span>IN<span class="dp">·</span>(0,<span class="dp">·</span>1)</td></tr>
<tr class="diffchanged"><td class="diffline">105 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>)<del>,<span class="dp">·</span></del></td><td class="diffline">106 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>)</td></tr>
<tr class="diffdeleted"><td class="diffline">106 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>CONSTRAINT<span class="dp">·</span>fk_files_source_id_sources<span class="dp">·</span>FOREIGN<span class="dp">·</span>KEY(source_id)<span class="dp">·</span>REFERENCES<span class="dp">·</span>sources<span class="dp">·</span>(id)</td><td colspan="2"> </td></tr>
<tr class="diffunmodified"><td class="diffline">107 </td><td class="diffpresent">);</td><td class="diffline">107 </td><td class="diffpresent">);</td></tr>
<tr class="diffunmodified"><td class="diffline">108 </td><td class="diffpresent">CREATE<span class="dp">·</span>TABLE<span class="dp">·</span>messages<span class="dp">·</span>(</td><td class="diffline">108 </td><td class="diffpresent">CREATE<span class="dp">·</span>TABLE<span class="dp">·</span>messages<span class="dp">·</span>(</td></tr>
<tr class="diffunmodified"><td class="diffline">109 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>id<span class="dp">·</span>INTEGER<span class="dp">·</span>NOT<span class="dp">·</span>NULL,<span class="dp">·</span></td><td class="diffline">109 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>id<span class="dp">·</span>INTEGER<span class="dp">·</span>NOT<span class="dp">·</span>NULL,<span class="dp">·</span></td></tr>
<tr class="diffunmodified"><td class="diffline">110 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>uuid<span class="dp">·</span>VARCHAR(36)<span class="dp">·</span>NOT<span class="dp">·</span>NULL,<span class="dp">·</span></td><td class="diffline">110 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>uuid<span class="dp">·</span>VARCHAR(36)<span class="dp">·</span>NOT<span class="dp">·</span>NULL,<span class="dp">·</span></td></tr>
<tr class="diffunmodified"><td class="diffline">111 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>filename<span class="dp">·</span>VARCHAR(255)<span class="dp">·</span>NOT<span class="dp">·</span>NULL,<span class="dp">·</span></td><td class="diffline">111 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>filename<span class="dp">·</span>VARCHAR(255)<span class="dp">·</span>NOT<span class="dp">·</span>NULL,<span class="dp">·</span></td></tr>
<tr class="diffunmodified"><td class="diffline">112 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>file_counter<span class="dp">·</span>INTEGER<span class="dp">·</span>NOT<span class="dp">·</span>NULL,<span class="dp">·</span></td><td class="diffline">112 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>file_counter<span class="dp">·</span>INTEGER<span class="dp">·</span>NOT<span class="dp">·</span>NULL,<span class="dp">·</span></td></tr>
<tr class="diffunmodified"><td class="diffline">113 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>size<span class="dp">·</span>INTEGER<span class="dp">·</span>NOT<span class="dp">·</span>NULL,<span class="dp">·</span></td><td class="diffline">113 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>size<span class="dp">·</span>INTEGER<span class="dp">·</span>NOT<span class="dp">·</span>NULL,<span class="dp">·</span></td></tr>
<tr class="diffhunk"><td colspan="2">Offset 122, 51 lines modified</td><td colspan="2">Offset 122, 49 lines modified</td></tr>
<tr class="diffunmodified"><td class="diffline">122 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span><span class="dp">·</span><span class="dp">·</span>CASE<span class="dp">·</span>WHEN<span class="dp">·</span>is_downloaded<span class="dp">·</span>=<span class="dp">·</span>0<span class="dp">·</span>THEN<span class="dp">·</span>content<span class="dp">·</span>IS<span class="dp">·</span>NULL<span class="dp">·</span>ELSE<span class="dp">·</span>1<span class="dp">·</span>END</td><td class="diffline">122 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span><span class="dp">·</span><span class="dp">·</span>CASE<span class="dp">·</span>WHEN<span class="dp">·</span>is_downloaded<span class="dp">·</span>=<span class="dp">·</span>0<span class="dp">·</span>THEN<span class="dp">·</span>content<span class="dp">·</span>IS<span class="dp">·</span>NULL<span class="dp">·</span>ELSE<span class="dp">·</span>1<span class="dp">·</span>END</td></tr>
<tr class="diffunmodified"><td class="diffline">123 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>),<span class="dp">·</span></td><td class="diffline">123 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>),<span class="dp">·</span></td></tr>
<tr class="diffunmodified"><td class="diffline">124 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>source_id<span class="dp">·</span>INTEGER<span class="dp">·</span>NOT<span class="dp">·</span>NULL,<span class="dp">·</span></td><td class="diffline">124 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>source_id<span class="dp">·</span>INTEGER<span class="dp">·</span>NOT<span class="dp">·</span>NULL,<span class="dp">·</span></td></tr>
<tr class="diffunmodified"><td class="diffline">125 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>last_updated<span class="dp">·</span>DATETIME<span class="dp">·</span>NOT<span class="dp">·</span>NULL,<span class="dp">·</span></td><td class="diffline">125 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>last_updated<span class="dp">·</span>DATETIME<span class="dp">·</span>NOT<span class="dp">·</span>NULL,<span class="dp">·</span></td></tr>
<tr class="diffunmodified"><td class="diffline">126 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>CONSTRAINT<span class="dp">·</span>pk_messages<span class="dp">·</span>PRIMARY<span class="dp">·</span>KEY<span class="dp">·</span>(id),<span class="dp">·</span></td><td class="diffline">126 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>CONSTRAINT<span class="dp">·</span>pk_messages<span class="dp">·</span>PRIMARY<span class="dp">·</span>KEY<span class="dp">·</span>(id),<span class="dp">·</span></td></tr>
<tr class="diffunmodified"><td class="diffline">127 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>CONSTRAINT<span class="dp">·</span>uq_messages_source_id_file_counter<span class="dp">·</span>UNIQUE<span class="dp">·</span>(source_id,<span class="dp">·</span>file_counter),<span class="dp">·</span></td><td class="diffline">127 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>CONSTRAINT<span class="dp">·</span>uq_messages_source_id_file_counter<span class="dp">·</span>UNIQUE<span class="dp">·</span>(source_id,<span class="dp">·</span>file_counter),<span class="dp">·</span></td></tr>
<tr class="diffunmodified"><td class="diffline">128 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>CONSTRAINT<span class="dp">·</span>uq_messages_uuid<span class="dp">·</span>UNIQUE<span class="dp">·</span>(uuid),<span class="dp">·</span></td><td class="diffline">128 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>CONSTRAINT<span class="dp">·</span>uq_messages_uuid<span class="dp">·</span>UNIQUE<span class="dp">·</span>(uuid),<span class="dp">·</span></td></tr>
<tr class="diffadded"><td colspan="2"> </td><td class="diffline">129 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>CONSTRAINT<span class="dp">·</span>fk_messages_download_error_id_downloaderrors<span class="dp">·</span>FOREIGN<span class="dp">·</span>KEY(download_error_id)<span class="dp">·</span>REFERENCES<span class="dp">·</span>downloaderrors<span class="dp">·</span>(id),<span class="dp">·</span></td></tr>
<tr class="diffadded"><td colspan="2"> </td><td class="diffline">130 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>CONSTRAINT<span class="dp">·</span>fk_messages_source_id_sources<span class="dp">·</span>FOREIGN<span class="dp">·</span>KEY(source_id)<span class="dp">·</span>REFERENCES<span class="dp">·</span>sources<span class="dp">·</span>(id),<span class="dp">·</span></td></tr>
<tr class="diffunmodified"><td class="diffline">129 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>CONSTRAINT<span class="dp">·</span>ck_messages_is_downloaded<span class="dp">·</span>CHECK<span class="dp">·</span>(</td><td class="diffline">131 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>CONSTRAINT<span class="dp">·</span>ck_messages_is_downloaded<span class="dp">·</span>CHECK<span class="dp">·</span>(</td></tr>
<tr class="diffunmodified"><td class="diffline">130 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span><span class="dp">·</span><span class="dp">·</span>is_downloaded<span class="dp">·</span>IN<span class="dp">·</span>(0,<span class="dp">·</span>1)</td><td class="diffline">132 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span><span class="dp">·</span><span class="dp">·</span>is_downloaded<span class="dp">·</span>IN<span class="dp">·</span>(0,<span class="dp">·</span>1)</td></tr>
<tr class="diffunmodified"><td class="diffline">131 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>),<span class="dp">·</span></td><td class="diffline">133 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>),<span class="dp">·</span></td></tr>
<tr class="diffunmodified"><td class="diffline">132 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>CONSTRAINT<span class="dp">·</span>ck_messages_is_decrypted<span class="dp">·</span>CHECK<span class="dp">·</span>(</td><td class="diffline">134 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>CONSTRAINT<span class="dp">·</span>ck_messages_is_decrypted<span class="dp">·</span>CHECK<span class="dp">·</span>(</td></tr>
<tr class="diffunmodified"><td class="diffline">133 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span><span class="dp">·</span><span class="dp">·</span>is_decrypted<span class="dp">·</span>IN<span class="dp">·</span>(0,<span class="dp">·</span>1)</td><td class="diffline">135 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span><span class="dp">·</span><span class="dp">·</span>is_decrypted<span class="dp">·</span>IN<span class="dp">·</span>(0,<span class="dp">·</span>1)</td></tr>
<tr class="diffunmodified"><td class="diffline">134 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>),<span class="dp">·</span></td><td class="diffline">136 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>),<span class="dp">·</span></td></tr>
<tr class="diffdeleted"><td class="diffline">135 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>CONSTRAINT<span class="dp">·</span>fk_messages_download_error_id_downloaderrors<span class="dp">·</span>FOREIGN<span class="dp">·</span>KEY(download_error_id)<span class="dp">·</span>REFERENCES<span class="dp">·</span>downloaderrors<span class="dp">·</span>(id),<span class="dp">·</span></td><td colspan="2"> </td></tr>
<tr class="diffunmodified"><td class="diffline">136 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>CONSTRAINT<span class="dp">·</span>ck_messages_is_read<span class="dp">·</span>CHECK<span class="dp">·</span>(</td><td class="diffline">137 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>CONSTRAINT<span class="dp">·</span>ck_messages_is_read<span class="dp">·</span>CHECK<span class="dp">·</span>(</td></tr>
<tr class="diffunmodified"><td class="diffline">137 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span><span class="dp">·</span><span class="dp">·</span>is_read<span class="dp">·</span>IN<span class="dp">·</span>(0,<span class="dp">·</span>1)</td><td class="diffline">138 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span><span class="dp">·</span><span class="dp">·</span>is_read<span class="dp">·</span>IN<span class="dp">·</span>(0,<span class="dp">·</span>1)</td></tr>
<tr class="diffchanged"><td class="diffline">138 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>)<del>,<span class="dp">·</span></del></td><td class="diffline">139 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>)</td></tr>
<tr class="diffdeleted"><td class="diffline">139 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>CONSTRAINT<span class="dp">·</span>fk_messages_source_id_sources<span class="dp">·</span>FOREIGN<span class="dp">·</span>KEY(source_id)<span class="dp">·</span>REFERENCES<span class="dp">·</span>sources<span class="dp">·</span>(id)</td><td colspan="2"> </td></tr>
<tr class="diffunmodified"><td class="diffline">140 </td><td class="diffpresent">);</td><td class="diffline">140 </td><td class="diffpresent">);</td></tr>
<tr class="diffunmodified"><td class="diffline">141 </td><td class="diffpresent">CREATE<span class="dp">·</span>TABLE<span class="dp">·</span>replies<span class="dp">·</span>(</td><td class="diffline">141 </td><td class="diffpresent">CREATE<span class="dp">·</span>TABLE<span class="dp">·</span>replies<span class="dp">·</span>(</td></tr>
<tr class="diffunmodified"><td class="diffline">142 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>id<span class="dp">·</span>INTEGER<span class="dp">·</span>NOT<span class="dp">·</span>NULL,<span class="dp">·</span></td><td class="diffline">142 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>id<span class="dp">·</span>INTEGER<span class="dp">·</span>NOT<span class="dp">·</span>NULL,<span class="dp">·</span></td></tr>
<tr class="diffunmodified"><td class="diffline">143 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>uuid<span class="dp">·</span>VARCHAR(36)<span class="dp">·</span>NOT<span class="dp">·</span>NULL,<span class="dp">·</span></td><td class="diffline">143 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>uuid<span class="dp">·</span>VARCHAR(36)<span class="dp">·</span>NOT<span class="dp">·</span>NULL,<span class="dp">·</span></td></tr>
<tr class="diffunmodified"><td class="diffline">144 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>source_id<span class="dp">·</span>INTEGER<span class="dp">·</span>NOT<span class="dp">·</span>NULL,<span class="dp">·</span></td><td class="diffline">144 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>source_id<span class="dp">·</span>INTEGER<span class="dp">·</span>NOT<span class="dp">·</span>NULL,<span class="dp">·</span></td></tr>
<tr class="diffunmodified"><td class="diffline">145 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>filename<span class="dp">·</span>VARCHAR(255)<span class="dp">·</span>NOT<span class="dp">·</span>NULL,<span class="dp">·</span></td><td class="diffline">145 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>filename<span class="dp">·</span>VARCHAR(255)<span class="dp">·</span>NOT<span class="dp">·</span>NULL,<span class="dp">·</span></td></tr>
<tr class="diffunmodified"><td class="diffline">146 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>file_counter<span class="dp">·</span>INTEGER<span class="dp">·</span>NOT<span class="dp">·</span>NULL,<span class="dp">·</span></td><td class="diffline">146 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>file_counter<span class="dp">·</span>INTEGER<span class="dp">·</span>NOT<span class="dp">·</span>NULL,<span class="dp">·</span></td></tr>
<tr class="diffunmodified"><td class="diffline">147 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>size<span class="dp">·</span>INTEGER,<span class="dp">·</span></td><td class="diffline">147 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>size<span class="dp">·</span>INTEGER,<span class="dp">·</span></td></tr>
<tr class="diffdeleted"><td class="diffline">148 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>content<span class="dp">·</span>TEXT,<span class="dp">·</span></td><td colspan="2"> </td></tr>
<tr class="diffchanged"><td class="diffline">149 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>is_d<del>ecryp</del>te<del>d</del><del><span class="dp">·</span>BOOL</del>E<del>AN,<span class="dp">·</span></del></td><td class="diffline">148 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span><ins>content<span class="dp">·</span>TEXT<span class="dp">·</span>CONSTRAINT<span class="dp">·</span>repl</ins>i<ins>e</ins>s<ins>_compare</ins>_<ins>downloa</ins>d<ins>_v</ins><ins>s_con</ins>te<ins>nt<span class="dp">·</span>CH</ins>E<ins>CK<span class="dp">·</span>(</ins></td></tr>
<tr class="diffadded"><td colspan="2"> </td><td class="diffline">149 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span><span class="dp">·</span><span class="dp">·</span>CASE<span class="dp">·</span>WHEN<span class="dp">·</span>is_downloaded<span class="dp">·</span>=<span class="dp">·</span>0<span class="dp">·</span>THEN<span class="dp">·</span>content<span class="dp">·</span>IS<span class="dp">·</span>NULL<span class="dp">·</span>ELSE<span class="dp">·</span>1<span class="dp">·</span>END</td></tr>
<tr class="diffadded"><td colspan="2"> </td><td class="diffline">150 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>),<span class="dp">·</span></td></tr>
<tr class="diffadded"><td colspan="2"> </td><td class="diffline">151 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>is_decrypted<span class="dp">·</span>BOOLEAN<span class="dp">·</span>CONSTRAINT<span class="dp">·</span>replies_compare_is_downloaded_vs_is_decrypted<span class="dp">·</span>CHECK<span class="dp">·</span>(</td></tr>
<tr class="diffadded"><td colspan="2"> </td><td class="diffline">152 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span><span class="dp">·</span><span class="dp">·</span>CASE<span class="dp">·</span>WHEN<span class="dp">·</span>is_downloaded<span class="dp">·</span>=<span class="dp">·</span>0<span class="dp">·</span>THEN<span class="dp">·</span>is_decrypted<span class="dp">·</span>IS<span class="dp">·</span>NULL<span class="dp">·</span>ELSE<span class="dp">·</span>1<span class="dp">·</span>END</td></tr>
<tr class="diffadded"><td colspan="2"> </td><td class="diffline">153 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>),<span class="dp">·</span></td></tr>
<tr class="diffunmodified"><td class="diffline">150 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>is_downloaded<span class="dp">·</span>BOOLEAN,<span class="dp">·</span></td><td class="diffline">154 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>is_downloaded<span class="dp">·</span>BOOLEAN,<span class="dp">·</span></td></tr>
<tr class="diffunmodified"><td class="diffline">151 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>download_error_id<span class="dp">·</span>INTEGER,<span class="dp">·</span></td><td class="diffline">155 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>download_error_id<span class="dp">·</span>INTEGER,<span class="dp">·</span></td></tr>
<tr class="diffunmodified"><td class="diffline">152 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>journalist_id<span class="dp">·</span>INTEGER,<span class="dp">·</span></td><td class="diffline">156 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>journalist_id<span class="dp">·</span>INTEGER,<span class="dp">·</span></td></tr>
<tr class="diffunmodified"><td class="diffline">153 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>last_updated<span class="dp">·</span>DATETIME<span class="dp">·</span>NOT<span class="dp">·</span>NULL,<span class="dp">·</span></td><td class="diffline">157 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>last_updated<span class="dp">·</span>DATETIME<span class="dp">·</span>NOT<span class="dp">·</span>NULL,<span class="dp">·</span></td></tr>
<tr class="diffunmodified"><td class="diffline">154 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>CONSTRAINT<span class="dp">·</span>pk_replies<span class="dp">·</span>PRIMARY<span class="dp">·</span>KEY<span class="dp">·</span>(id),<span class="dp">·</span></td><td class="diffline">158 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>CONSTRAINT<span class="dp">·</span>pk_replies<span class="dp">·</span>PRIMARY<span class="dp">·</span>KEY<span class="dp">·</span>(id),<span class="dp">·</span></td></tr>
<tr class="diffdeleted"><td class="diffline">155 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>CONSTRAINT<span class="dp">·</span>uq_messages_source_id_file_counter<span class="dp">·</span>UNIQUE<span class="dp">·</span>(source_id,<span class="dp">·</span>file_counter),<span class="dp">·</span></td><td colspan="2"> </td></tr>
<tr class="diffdeleted"><td class="diffline">156 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>CONSTRAINT<span class="dp">·</span>uq_replies_uuid<span class="dp">·</span>UNIQUE<span class="dp">·</span>(uuid),<span class="dp">·</span></td><td colspan="2"> </td></tr>
<tr class="diffdeleted"><td class="diffline">157 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>CONSTRAINT<span class="dp">·</span>fk_replies_source_id_sources<span class="dp">·</span>FOREIGN<span class="dp">·</span>KEY(source_id)<span class="dp">·</span>REFERENCES<span class="dp">·</span>sources<span class="dp">·</span>(id),<span class="dp">·</span></td><td colspan="2"> </td></tr>
<tr class="diffunmodified"><td class="diffline">158 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>CONSTRAINT<span class="dp">·</span>fk_replies_download_error_id_downloaderrors<span class="dp">·</span>FOREIGN<span class="dp">·</span>KEY(download_error_id)<span class="dp">·</span>REFERENCES<span class="dp">·</span>downloaderrors<span class="dp">·</span>(id),<span class="dp">·</span></td><td class="diffline">159 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>CONSTRAINT<span class="dp">·</span>fk_replies_download_error_id_downloaderrors<span class="dp">·</span>FOREIGN<span class="dp">·</span>KEY(download_error_id)<span class="dp">·</span>REFERENCES<span class="dp">·</span>downloaderrors<span class="dp">·</span>(id),<span class="dp">·</span></td></tr>
<tr class="diffunmodified"><td class="diffline">159 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>CONSTRAINT<span class="dp">·</span>fk_replies_journalist_id_users<span class="dp">·</span>FOREIGN<span class="dp">·</span>KEY(journalist_id)<span class="dp">·</span>REFERENCES<span class="dp">·</span>users<span class="dp">·</span>(id),<span class="dp">·</span></td><td class="diffline">160 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>CONSTRAINT<span class="dp">·</span>fk_replies_journalist_id_users<span class="dp">·</span>FOREIGN<span class="dp">·</span>KEY(journalist_id)<span class="dp">·</span>REFERENCES<span class="dp">·</span>users<span class="dp">·</span>(id),<span class="dp">·</span></td></tr>
<tr class="diffadded"><td colspan="2"> </td><td class="diffline">161 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>CONSTRAINT<span class="dp">·</span>fk_replies_source_id_sources<span class="dp">·</span>FOREIGN<span class="dp">·</span>KEY(source_id)<span class="dp">·</span>REFERENCES<span class="dp">·</span>sources<span class="dp">·</span>(id),<span class="dp">·</span></td></tr>
<tr class="diffadded"><td colspan="2"> </td><td class="diffline">162 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>CONSTRAINT<span class="dp">·</span>uq_messages_source_id_file_counter<span class="dp">·</span>UNIQUE<span class="dp">·</span>(source_id,<span class="dp">·</span>file_counter),<span class="dp">·</span></td></tr>
<tr class="diffadded"><td colspan="2"> </td><td class="diffline">163 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>CONSTRAINT<span class="dp">·</span>uq_replies_uuid<span class="dp">·</span>UNIQUE<span class="dp">·</span>(uuid),<span class="dp">·</span></td></tr>
<tr class="diffdeleted"><td class="diffline">160 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>CONSTRAINT<span class="dp">·</span>replies_compare_download_vs_content<span class="dp">·</span>CHECK<span class="dp">·</span>(</td><td colspan="2"> </td></tr>
<tr class="diffdeleted"><td class="diffline">161 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span><span class="dp">·</span><span class="dp">·</span>CASE<span class="dp">·</span>WHEN<span class="dp">·</span>is_downloaded<span class="dp">·</span>=<span class="dp">·</span>0<span class="dp">·</span>THEN<span class="dp">·</span>content<span class="dp">·</span>IS<span class="dp">·</span>NULL<span class="dp">·</span>ELSE<span class="dp">·</span>1<span class="dp">·</span>END</td><td colspan="2"> </td></tr>
<tr class="diffdeleted"><td class="diffline">162 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>),<span class="dp">·</span></td><td colspan="2"> </td></tr>
<tr class="diffdeleted"><td class="diffline">163 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>CONSTRAINT<span class="dp">·</span>replies_compare_is_downloaded_vs_is_decrypted<span class="dp">·</span>CHECK<span class="dp">·</span>(</td><td colspan="2"> </td></tr>
<tr class="diffdeleted"><td class="diffline">164 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span><span class="dp">·</span><span class="dp">·</span>CASE<span class="dp">·</span>WHEN<span class="dp">·</span>is_downloaded<span class="dp">·</span>=<span class="dp">·</span>0<span class="dp">·</span>THEN<span class="dp">·</span>is_decrypted<span class="dp">·</span>IS<span class="dp">·</span>NULL<span class="dp">·</span>ELSE<span class="dp">·</span>1<span class="dp">·</span>END</td><td colspan="2"> </td></tr>
<tr class="diffdeleted"><td class="diffline">165 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>),<span class="dp">·</span></td><td colspan="2"> </td></tr>
<tr class="diffunmodified"><td class="diffline">166 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>CONSTRAINT<span class="dp">·</span>ck_replies_is_decrypted<span class="dp">·</span>CHECK<span class="dp">·</span>(</td><td class="diffline">164 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>CONSTRAINT<span class="dp">·</span>ck_replies_is_decrypted<span class="dp">·</span>CHECK<span class="dp">·</span>(</td></tr>
<tr class="diffunmodified"><td class="diffline">167 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span><span class="dp">·</span><span class="dp">·</span>is_decrypted<span class="dp">·</span>IN<span class="dp">·</span>(0,<span class="dp">·</span>1)</td><td class="diffline">165 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span><span class="dp">·</span><span class="dp">·</span>is_decrypted<span class="dp">·</span>IN<span class="dp">·</span>(0,<span class="dp">·</span>1)</td></tr>
<tr class="diffunmodified"><td class="diffline">168 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>),<span class="dp">·</span></td><td class="diffline">166 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>),<span class="dp">·</span></td></tr>
<tr class="diffunmodified"><td class="diffline">169 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>CONSTRAINT<span class="dp">·</span>ck_replies_is_downloaded<span class="dp">·</span>CHECK<span class="dp">·</span>(</td><td class="diffline">167 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>CONSTRAINT<span class="dp">·</span>ck_replies_is_downloaded<span class="dp">·</span>CHECK<span class="dp">·</span>(</td></tr>
<tr class="diffunmodified"><td class="diffline">170 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span><span class="dp">·</span><span class="dp">·</span>is_downloaded<span class="dp">·</span>IN<span class="dp">·</span>(0,<span class="dp">·</span>1)</td><td class="diffline">168 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span><span class="dp">·</span><span class="dp">·</span>is_downloaded<span class="dp">·</span>IN<span class="dp">·</span>(0,<span class="dp">·</span>1)</td></tr>
<tr class="diffunmodified"><td class="diffline">171 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>)</td><td class="diffline">169 </td><td class="diffpresent"><span class="dp">·</span><span class="dp">·</span>)</td></tr>
<tr class="diffunmodified"><td class="diffline">172 </td><td class="diffpresent">);</td><td class="diffline">170 </td><td class="diffpresent">);</td></tr>
</table></div>
<div class="footer">
Generated by
<a href="https://diffoscope.org" rel="noopener noreferrer" target="_blank">
diffoscope</a> 217
</div>
</body>
</html>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment