-- add-member-profile-fields.sql
-- ONLY for a database that already has subscribers. Adds the member-profile columns; nothing is removed.
-- Run ONCE. If you import database-final.sql into a new database, do NOT run this.
-- "Duplicate column name" means that column already exists; it is safe to ignore.

ALTER TABLE `subscribers`
  ADD COLUMN `pdp_father_name` varchar(255) NULL,
  ADD COLUMN `pdp_mother_name` varchar(255) NULL,
  ADD COLUMN `pdp_spouse_name` varchar(255) NULL,
  ADD COLUMN `pdp_child1_name` varchar(255) NULL,
  ADD COLUMN `pdp_child2_name` varchar(255) NULL,
  ADD COLUMN `pdp_child3_name` varchar(255) NULL,
  ADD COLUMN `pdp_child4_name` varchar(255) NULL,
  ADD COLUMN `pdp_emergency_phone` varchar(11) NULL,
  ADD COLUMN `pdp_present_village` varchar(255) NULL,
  ADD COLUMN `pdp_present_post_office` varchar(255) NULL,
  ADD COLUMN `pdp_permanent_village` varchar(255) NULL,
  ADD COLUMN `pdp_permanent_post_office` varchar(255) NULL,
  ADD COLUMN `pdp_ssc_school` varchar(255) NULL,
  ADD COLUMN `pdp_profession_type` varchar(255) NULL,
  ADD COLUMN `pdp_workplace` varchar(255) NULL,
  ADD COLUMN `pdp_tshirt_size` varchar(10) NULL,
  ADD COLUMN `pdp_blood_group` varchar(10) NULL,
  ADD COLUMN `pdp_photo` varchar(255) NULL,
  ADD COLUMN `pdp_comments` text NULL;