mascarpone/migrations/demo.sql

insert into contacts(id, birthday, manually_freshened_at) values
  (0, '--0415', '2000-01-01T12:00:00');
insert into names(contact_id, sort, name) values
  (0, 0, 'Alex Aaronson'),
  (0, 1, 'Alexi'),
  (0, 2, 'Алексей');
insert into groups(contact_id, name, slug) values
  (0, 'ABC', 'abc');

insert into contacts(id, birthday) values
  (1, 'April?');
insert into names(contact_id, sort, name) values
  (1, 0, 'Bazel Bagend'),
  (1, 1, 'Bazel');
insert into groups(contact_id, name, slug) values
  (1, 'ABC', 'abc');

insert into contacts(id, birthday) values
  (2, '19951018');
insert into names(contact_id, sort, name) values
  (2, 0, 'Charlie Certaindate');
insert into groups(contact_id, name, slug) values
  (2, 'ABC', 'abc');

-- D skipped intentionally

insert into contacts(id) values
  (3);
insert into names(contact_id, sort, name) values
  (3, 0, 'Eleanor Edgeworth'),
  (3, 1, 'Eleanor');

insert into contacts(id, lives_with) values (4, '[[Henrietta]]');
insert into names(contact_id, sort, name) values
  (4, 0, 'Felicia Homeowner');

insert into contacts(id, lives_with) values (5, '[[Henrietta]]');
insert into names(contact_id, sort, name) values
  (5, 0, 'Gregory Homeowner');

insert into contacts(id) values (6);
insert into names(contact_id, sort, name) values
  (6, 0, 'Henrietta Homeowner'),
  (6, 1, 'Henrietta');

insert into addresses(contact_id, label, value) values
  (6, null, '123 Main St., Realville, WI 99999');

insert into journal_entries(id, date, value) values
  (0, '2020-02-27', 'Lunch with [[Bazel Bagend]] and his wife'),
  (1, '2025-10-10', 'Dinner with [[Alexi]]'),
  (2, '2022-06-06', 'Movies with [[Daniel Doesn''texist]] et al'),
  (3, '2024-02-02', 'Started a business with [[ABC]]'),
  (4, '2024-02-17', 'Friendship ended with [[Bazel]]. Now [[Eleanor Edgeworth]] is my best friend.'),
  (5, '2024-02-18', 'With [[Bazel]] gone, dissolved [[ABC]] Corp. Start discussions for a potential ACE, Inc. with [[Alexi]] and [[Eleanor]].');

insert into mentions (entity_id, entity_type, input_text, byte_range_start, byte_range_end, url) values
  (0, 0, 'Bazel Bagend', 11, 27, '/contact/1'),
  (1, 0, 'Alexi', 12, 21, '/contact/0'),
  (3, 0, 'ABC', 24, 31, '/group/ABC'),
  (4, 0, 'Bazel', 22, 31, '/contact/1'),
  (4, 0, 'Eleanor Edgeworth', 37, 58, '/contact/3'),
  (5, 0, 'Eleanor', 108, 119, '/contact/3'),
  (5, 0, 'Alexi', 94, 103, '/contact/0'),
  (5, 0, 'Bazel', 5, 14, '/contact/1'),
  (5, 0, 'ABC', 31, 38, '/group/ABC');