mirror of
https://gitlab.com/PronounsPage/PronounsPage.git
synced 2025-09-23 04:34:15 -04:00
16 lines
392 B
SQL
16 lines
392 B
SQL
-- Up
|
|
|
|
CREATE TABLE census_deduplication (
|
|
locale TEXT NOT NULL,
|
|
edition TEXT NOT NULL,
|
|
userId TEXT NULL,
|
|
fingerprint TEXT NULL
|
|
);
|
|
|
|
INSERT INTO census_deduplication (locale, edition, userId, fingerprint)
|
|
SELECT locale, edition, userId, fingerprint FROM census WHERE userId IS NOT NULL OR fingerprint IS NOT NULL;
|
|
|
|
UPDATE census SET userId = null, fingerprint = null;
|
|
|
|
-- Down
|