-- The Affluent Man Order Management System
-- Database Installation Script

CREATE TABLE IF NOT EXISTS `orders` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `customer_name` varchar(255) NOT NULL,
  `order_number` varchar(100) NOT NULL,
  `number_of_items` varchar(50) DEFAULT NULL,
  `item_number` varchar(50) DEFAULT NULL,
  
  -- Measurements
  `full_shoulder` varchar(50) DEFAULT NULL,
  `sleeves` varchar(50) DEFAULT NULL,
  `full_chest` varchar(50) DEFAULT NULL,
  `full_stomach` varchar(50) DEFAULT NULL,
  `hips` varchar(50) DEFAULT NULL,
  `front_chest` varchar(50) DEFAULT NULL,
  `chest_back` varchar(50) DEFAULT NULL,
  `length_of_jacket` varchar(50) DEFAULT NULL,
  `length_of_shirt` varchar(50) DEFAULT NULL,
  `length_of_vest` varchar(50) DEFAULT NULL,
  `waist_for_pants` varchar(50) DEFAULT NULL,
  `thigh` varchar(50) DEFAULT NULL,
  `full_crouch` varchar(50) DEFAULT NULL,
  `pants_length` varchar(50) DEFAULT NULL,
  `cuffs` varchar(50) DEFAULT NULL,
  `neck` varchar(50) DEFAULT NULL,
  `biceps` varchar(50) DEFAULT NULL,
  
  -- Suit Details
  `suit_type` varchar(100) DEFAULT NULL,
  `jacket_fit` varchar(100) DEFAULT NULL,
  `jacket_fabric_color` varchar(100) DEFAULT NULL,
  `jacket_fabric_number` varchar(100) DEFAULT NULL,
  `lapel_type` varchar(100) DEFAULT NULL,
  `lapel_width` varchar(100) DEFAULT NULL,
  `lapel_width_inches` varchar(50) DEFAULT NULL,
  `jacket_stitching` varchar(100) DEFAULT NULL,
  `stitch_color` varchar(100) DEFAULT NULL,
  `lapel_button_hole_color` varchar(100) DEFAULT NULL,
  `jacket_button_type` varchar(100) DEFAULT NULL,
  `jacket_vent_type` varchar(100) DEFAULT NULL,
  `jacket_pocket_type` varchar(100) DEFAULT NULL,
  `jacket_ticket_pocket` varchar(50) DEFAULT NULL,
  `under_collar_felt_color` varchar(100) DEFAULT NULL,
  `jacket_sleeve_button_type` varchar(100) DEFAULT NULL,
  `jacket_sleeve_button_hole_color` varchar(100) DEFAULT NULL,
  `jacket_liner` varchar(100) DEFAULT NULL,
  `inside_left_message` text DEFAULT NULL,
  `inside_right_message` text DEFAULT NULL,
  `suit_notes` text DEFAULT NULL,
  
  -- Pant Details
  `pants_fabric` varchar(100) DEFAULT NULL,
  `pants_back_pockets` varchar(100) DEFAULT NULL,
  `pockets` varchar(100) DEFAULT NULL,
  `suspender_buttons` varchar(50) DEFAULT NULL,
  `pleat_type` varchar(100) DEFAULT NULL,
  `pants_fit` varchar(100) DEFAULT NULL,
  `bottoms` varchar(100) DEFAULT NULL,
  `cuff_height` varchar(50) DEFAULT NULL,
  `pants_notes` text DEFAULT NULL,
  
  -- Vest Details
  `vest_style` varchar(100) DEFAULT NULL,
  `vest_fabric_color` varchar(100) DEFAULT NULL,
  `vest_fabric_number` varchar(100) DEFAULT NULL,
  `vest_notes` text DEFAULT NULL,
  
  -- System fields
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` varchar(50) DEFAULT 'pending',
  
  PRIMARY KEY (`id`),
  KEY `order_number` (`order_number`),
  KEY `customer_name` (`customer_name`),
  KEY `created_at` (`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

• [F] install.sql
  Delete