-- AlterTable
ALTER TABLE "MemberPaycheck" ALTER COLUMN "occurredAt" SET DATA TYPE TIMESTAMP(3);

-- AlterTable
-- Add a column for tracking a pay cycle start at
ALTER TABLE "Organization" ADD COLUMN     "payCycleStartAt" DATE;

-- AlterTable
-- Update default to be BiWeekly
-- Fun fact: 43% of users are paid bi-weekly
-- @see https://www.bls.gov/ces/publications/length-pay-period.htm
ALTER TABLE "Organization" ALTER COLUMN "payCycle" SET DEFAULT 'BiWeekly';

--- Add timezone onto organization
-- CreateEnum
CREATE TYPE "Timezone" AS ENUM ('Alaska', 'Central', 'Eastern', 'HawaiiAleutian', 'Mountain', 'Pacific');

-- AlterTable
ALTER TABLE "Organization" ADD COLUMN     "timezone" "Timezone" NOT NULL DEFAULT 'Central';
