components/test/data/password_manager/affiliation_db_v1.sql

PRAGMA foreign_keys=1;
BEGIN TRANSACTION;

CREATE TABLE meta(key LONGVARCHAR NOT NULL UNIQUE PRIMARY KEY, value LONGVARCHAR);
INSERT INTO "meta" VALUES('last_compatible_version','1');
INSERT INTO "meta" VALUES('version','1');

CREATE TABLE eq_classes(
  id INTEGER PRIMARY KEY,
  last_update_time INTEGER);

CREATE TABLE eq_class_members(
  id INTEGER PRIMARY KEY,
  facet_uri LONGVARCHAR UNIQUE NOT NULL,
  set_id INTEGER NOT NULL REFERENCES eq_classes(id) ON DELETE CASCADE);

CREATE INDEX index_on_eq_class_members_set_id ON eq_class_members (set_id);

INSERT INTO eq_classes(id, last_update_time) VALUES (1, 1000000);
INSERT INTO eq_class_members(facet_uri, set_id) VALUES ('https://alpha.example.com', 1);
INSERT INTO eq_class_members(facet_uri, set_id) VALUES ('https://beta.example.com', 1);
INSERT INTO eq_class_members(facet_uri, set_id) VALUES ('https://gamma.example.com', 1);

INSERT INTO eq_classes(id, last_update_time) VALUES (2, 2000000);
INSERT INTO eq_class_members(facet_uri, set_id) VALUES ('https://delta.example.com', 2);
INSERT INTO eq_class_members(facet_uri, set_id) VALUES ('https://epsilon.example.com', 2);

INSERT INTO eq_classes(id, last_update_time) VALUES (3, 3000000);
INSERT INTO eq_class_members(facet_uri, set_id) VALUES ('android://hash@com.example.android', 3);

COMMIT;