CREATE TABLE `officers` ( `officer_id` int(11) NOT NULL auto_increment, `name_last` varchar(30) collate latin1_general_ci NOT NULL default '', `name_first` varchar(30) collate latin1_general_ci NOT NULL default '', `name_middle` varchar(30) collate latin1_general_ci default NULL, `name_nick` varchar(30) collate latin1_general_ci default NULL, `image_file_name` varchar(30) collate latin1_general_ci NOT NULL default 'none', `birth_date` varchar(20) collate latin1_general_ci NOT NULL default 'unknown', `birth_year` varchar(20) collate latin1_general_ci NOT NULL default 'unknown', `birth_city` varchar(50) collate latin1_general_ci NOT NULL default 'unknown', `birth_state` varchar(30) collate latin1_general_ci NOT NULL default 'unknown', `home_state_code` char(2) collate latin1_general_ci NOT NULL default 'un', `country` varchar(20) collate latin1_general_ci NOT NULL default 'unknown', `rank_at_battle` varchar(20) collate latin1_general_ci NOT NULL default 'unknown', `organization` varchar(10) collate latin1_general_ci NOT NULL default 'CSA', `command_billet` varchar(30) collate latin1_general_ci NOT NULL default 'none', `unit_at_campaign_start` varchar(30) collate latin1_general_ci NOT NULL default 'unknown', `branch_service` varchar(20) collate latin1_general_ci NOT NULL default 'unknown', `college` varchar(255) collate latin1_general_ci default NULL, `usma_class_grad` varchar(4) collate latin1_general_ci default NULL, `usma_class_rank` varchar(20) collate latin1_general_ci default NULL, `pre_battle_text` mediumtext collate latin1_general_ci, `battle_text` mediumtext collate latin1_general_ci, `post_battle_text` mediumtext collate latin1_general_ci, `post_war_text` mediumtext collate latin1_general_ci, `notes` mediumtext collate latin1_general_ci, `web_reference_text` mediumtext collate latin1_general_ci, `death_date` varchar(20) collate latin1_general_ci NOT NULL default 'unknown', `death_year` varchar(4) collate latin1_general_ci NOT NULL default 'unkn', `death_city` varchar(50) collate latin1_general_ci NOT NULL default 'unknown', `death_state` varchar(20) collate latin1_general_ci NOT NULL default 'unknown', `burial_place` varchar(80) collate latin1_general_ci NOT NULL default 'unknown', `got_details` enum('Y','N') collate latin1_general_ci NOT NULL default 'N', PRIMARY KEY (`officer_id`), KEY `name` (`name_last`,`name_first`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1107 ; INSERT INTO `officers` VALUES (1, 'Porter', 'Fitz John', '', '', 'porter', '8/31/1822', '1822', 'Portsmouth', 'NH', 'NH', 'Federal', 'MGen', 'USA', 'Army Corps Commander', 'VCorps', 'Infantry', 'USMA', '1845', '', 'He graduated from the USMA in 1845, served in the Mexican War, as an artillery instructor at West Point, and was on the Utah Expedition. In May 1861 he was Colonel of the 15th US Infantry, and was appointed Brig. Gen. of Volunteers. He served as chief of staff to Patterson in the Shenandoah, and commanded the 1st Division/III Corps in Peninsula campaign and the V Corps at the Seven Days. In July 1862 he was promoted to MGen. of Volunteers and led his Corps at Second Bull Run.', 'He was in command of the Fifth (V) Corps, in reserve on the day of the battle.', 'He was court martialled for insubordination (refusing Pope''s orders to make an apparently impossible attack) for his part at Second Bull Run, and dismissed from the Army in January 1863. The court martial was (probably) politically inspired by (Sec''y of War) Stanton, to harm McClellan. Porter fought to clear his name, and was exonerated and reinstated by an Army review board in 1878.', '', '', 'For more about the court martial see the Court Martial of Fitz John Porter at Shotgun''s Civil War page. Another essay on the subject is Fitz John Porter by Buford.', '5/21/1901', '1901', 'Morristown', 'NJ', '', 'Y'); INSERT INTO `officers` VALUES (2, 'Posey', 'Carnot', '', '', 'posey_c', '8/5/1818', '1818', 'Wilkinson County', 'MS', 'MS', 'Confederate', 'Col', 'CSA', 'Brigade Commander', 'Featherston''s Brig', 'Infantry', 'U of Virginia (Law)', '', '', 'Before the War he was a planter and lawyer. He had served as a Lieutenant in the 1st Mississippi Rifles in the Mexican War (1947-48), and afterward was a US district attorney. In 1861 he organized and recruited the Wilkinson Rifles and was their Captain. In July 1861 he was appointed Colonel of the 16th Mississippi Regiment, and was appointed to command the Brigade August 30 when General Featherston was given command of the division, and continued in command of the brigade through the capture of Harper''s Ferry and battle of Sharpsburg, and until November, when Featherston returned. ', 'He commanded Featherston''s Brigade in Anderson''s Division in Longstreet''s Command.', 'In November 1862 he was promoted to Brigadier General (confirmed January 1863), and commanded Posey''s Brigade in R. H. Anderson''s Division at Fredericksburg, Chancellorsville, Gettysburg, and Bristoe Station. He was wounded in action there on 14 October 1863 and died of the resulting infection at Charlottesville, VA on 13 November.', '', '', '', '11/13/1863', '1863', 'Charlottesville', 'VA', 'University of Virginia cemetery, Charlottesville', 'Y'); INSERT INTO `officers` VALUES (3, 'Pryor', 'Roger', 'Atkinson', '', 'pryor', '', '1828', '', '', 'VA', 'Confederate', 'BGen', 'CSA', 'Brigade Commander', 'Pryor''s Brig', 'Infantry', NULL, '', '', 'Pre-War Profession: Lawyer, newspaper editor, US congressman. In 1861 he accompanied Beauregard at Fort Sumter, then entered the Confederate Congress. He resigned his seat in April 1861 and was appointed Colonel of the 3rd Virginia Regiment, leading them at Williamsburg. In April 1862 he was made BGen., and commanded the 5th (Pryor''s) Brigade/Longstreet''s Division in the Seven Days and at Second Manassas.', 'He commanded Pryor''s Brigade in Anderson''s Division in Longstreet''s Command and assumed command of the Division when MGen Anderson was severely wounded coming up to the Sunken Road on the morning of the 17th.', 'After his Brigade was dismantled due to losses he scouted for Jackson and was captured in November 1864. He was exchanged shortly before Appomattox.', 'Post War Career: Lawyer, newspaperman, and judge.', '', '', '', '1919', '', '', '', 'Y');