-- ===========================================
-- FireAndSafety — Schema
-- ===========================================
use townofcushingme;

CREATE TABLE IF NOT EXISTS `FireAndSafety` (
  `Id` INT NOT NULL AUTO_INCREMENT,
  `Category`    VARCHAR(150) NULL,           -- e.g., Fire, Cushing Rescue Squad, etc
  `Position`    VARCHAR(150) NULL,           -- e.g., Chief, Director, etc
  `Name`        VARCHAR(150) NOT NULL,
  `Email`       VARCHAR(120) NULL,
  `Url`         VARCHAR(200) NULL,
  `PhoneLocation`  VARCHAR(100) NULL,
  `Phone`        VARCHAR(25) NULL,
  `Notes`       TEXT         NULL,
  `IsActive`    TINYINT(1)   NOT NULL DEFAULT 1,
  `CreatedAt`   DATETIME(3)  NOT NULL,
  `CreatedBy`   VARCHAR(100) NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

SET @now := '2025-12-04 00:00:00';

INSERT INTO FireAndSafety
  (Category, Position, Name, Email, Url, PhoneLocation, Phone, Notes, IsActive, CreatedAt, CreatedBy)
VALUES
  ('Fire', 'Chief', 'Clarence Flanders', '', '', '', '', '',
  1, @now, 'import'
);

INSERT INTO FireAndSafety
  (Category, Position, Name, Email, Url, PhoneLocation, Phone, Notes, IsActive, CreatedAt, CreatedBy)
VALUES
  ('Cushing Rescue Squad', 'Director', 'Andrew Blanchard', 'cushingrescue@roadrunner.com', '', '', '', '',
  1, @now, 'import'
);

INSERT INTO FireAndSafety
  (Category, Position, Name, Email, Url, PhoneLocation, Phone, Notes, IsActive, CreatedAt, CreatedBy)
VALUES
  ('Maine Burn Permit System', '', '', '', 'https://apps1.web.maine.gov/burnpermit/public/index.html', '', '', '',
  1, @now, 'import'
);

INSERT INTO FireAndSafety
  (Category, Position, Name, Email, Url, PhoneLocation, Phone, Notes, IsActive, CreatedAt, CreatedBy)
VALUES
  ('Burning', '', '', '', 'https://www.maine.gov/dacf/mfs/archive/fpd/downloads/openburning.pdf', '', '', '',
  1, @now, 'import'
);

INSERT INTO FireAndSafety
  (Category, Position, Name, Email, Url, PhoneLocation, Phone, Notes, IsActive, CreatedAt, CreatedBy)
VALUES
  ('House Numbering', 'Code Enforcement Officer', 'Rodney Mason', 'ceo@cushing.maine.gov', 'https://www.cushing.maine.gov/wp-content/uploads/2015/01/Cushing_House_Numbering.pdf', 'Town Office', '', 'In compliance with federal regulations, emergency services are now dispatched to an address. Resident’s names are no longer used. With the new procedures it is imperative that every resident have an address conspicuously posted so that emergency services can find the caller.',
  1, @now, 'import'
);