CREATE TABLE IF NOT EXISTS relationships (
  id INT AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(100) NOT NULL,
  display_order INT DEFAULT 0,
  is_active BOOLEAN DEFAULT true,
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP
);

INSERT INTO relationships (name, display_order) VALUES
  ('Mom', 1),
  ('Dad', 2),
  ('Sister', 3),
  ('Brother', 4),
  ('Spouse', 5),
  ('Partner', 6),
  ('Best Friend', 7),
  ('Friend', 8),
  ('Grandma', 9),
  ('Grandpa', 10),
  ('Aunt', 11),
  ('Uncle', 12),
  ('Cousin', 13),
  ('Child', 14);
