this repo has no description
1-- One-time backfill: set client metadata on all existing rows.
2-- All existing data originates from IRC, #soggies channel on jameswhite.org.
3-- Run this manually after deploying the client fields migration.
4--
5-- Usage (SQLite): sqlite3 tumble.db < sql/backfill_clients.sql
6-- Usage (MySQL): mysql -u user -p tumble < sql/backfill_clients.sql
7
8UPDATE ircLink
9SET client_type = 'irc',
10 client_network = 'jameswhite.org',
11 client_channel = '#soggies'
12WHERE client_type IS NULL;
13
14UPDATE quote
15SET client_type = 'irc',
16 client_network = 'jameswhite.org',
17 client_channel = '#soggies'
18WHERE client_type IS NULL;
19
20UPDATE image
21SET client_type = 'irc',
22 client_network = 'jameswhite.org',
23 client_channel = '#soggies'
24WHERE client_type IS NULL;