-- INNENT SCHOOL360 | Migration 004: Human-readable numbering (spec sec 104)
CREATE TABLE number_sequences (
  school_id INT UNSIGNED NOT NULL,
  seq_key VARCHAR(30) NOT NULL,          -- admission, receipt, employee ...
  next_value BIGINT UNSIGNED NOT NULL DEFAULT 1,
  PRIMARY KEY (school_id, seq_key),
  CONSTRAINT fk_seq_school FOREIGN KEY (school_id) REFERENCES schools(id)
) ENGINE=InnoDB;

INSERT IGNORE INTO permissions (code, module, is_sensitive) VALUES ('students.guardians','students',0);
INSERT IGNORE INTO role_permissions (role_id, permission_id)
SELECT r.id, p.id FROM roles r JOIN permissions p ON p.code='students.guardians'
WHERE r.code IN ('school_admin','principal');