-- phpMyAdmin SQL Dump -- version 3.3.8.1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jan 24, 2011 at 07:39 PM -- Server version: 5.0.91 -- PHP Version: 5.2.9 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `wcarc_vault` -- -- -------------------------------------------------------- -- -- Table structure for table `authorization` -- CREATE TABLE IF NOT EXISTS `authorization` ( `auth_id` int(11) NOT NULL auto_increment, `personid` int(11) NOT NULL, `pwstring` varchar(30) NOT NULL COMMENT 'password', `must_change_pw` tinyint(1) NOT NULL default '0' COMMENT 'true when user is required to change password at next login', `action_view` tinyint(1) NOT NULL default '0' COMMENT 'user may view documents', `action_reports` tinyint(1) NOT NULL default '0' COMMENT 'user may see and submit ec-dec reports', `action_approve` tinyint(1) NOT NULL default '0' COMMENT 'user may approve new applicant users', `action_master` tinyint(1) NOT NULL default '0' COMMENT 'user may do any action', `authorization_time` datetime NOT NULL COMMENT 'time of application, then approval', `approver` int(11) NOT NULL COMMENT 'recnum for approver', PRIMARY KEY (`auth_id`), KEY `fk_person` (`personid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='STX document vault gateway authorization' AUTO_INCREMENT=431 ; -- -- Dumping data for table `authorization` -- INSERT INTO `authorization` (`auth_id`, `personid`, `pwstring`, `must_change_pw`, `action_view`, `action_reports`, `action_approve`, `action_master`, `authorization_time`, `approver`) VALUES (1, 171, 's0litary', 0, 1, 1, 1, 1, '2010-03-29 10:52:58', 171), (96, 172, 'niklas12345', 0, 1, 1, 0, 0, '2010-04-10 10:50:00', 231), (98, 173, 'arrlstx1', 0, 1, 0, 0, 0, '2010-04-10 10:50:00', 231), (99, 174, 'one3five7nine', 1, 1, 1, 1, 0, '2010-04-10 10:50:00', 231), (100, 175, 'Ldeere2269', 0, 1, 1, 1, 0, '2010-04-10 10:50:00', 231), (104, 176, 'one3five7nine', 1, 1, 1, 1, 0, '2010-04-10 10:50:00', 231), (105, 177, 'one3five7nine', 1, 1, 0, 0, 0, '2010-04-10 10:50:00', 231), (108, 178, '1418diana', 0, 1, 1, 1, 0, '2010-04-10 10:50:00', 231), (109, 179, 'shasta1941', 0, 1, 1, 1, 0, '2010-04-10 10:50:00', 231), (112, 180, 'doitnow52', 0, 1, 1, 1, 0, '2010-04-10 10:50:00', 231), (115, 181, '1584nq5b2217', 0, 1, 1, 1, 0, '2010-04-10 10:50:00', 231), (117, 182, 'smokeycat1', 0, 1, 1, 1, 0, '2010-04-10 10:50:00', 231), (118, 183, 'n0wnh1', 0, 1, 1, 1, 0, '2010-04-10 10:50:00', 231), (128, 185, 'k5ddmk5ddm', 0, 1, 1, 1, 0, '2010-04-10 10:50:00', 231), (130, 186, 'one3five7nine', 1, 1, 1, 1, 0, '2010-04-10 10:50:00', 231), (131, 187, 'one3five7nine', 1, 1, 1, 1, 0, '2010-04-10 10:50:00', 231), (132, 188, 'ac512yk7', 0, 1, 1, 1, 0, '2010-04-10 10:50:00', 231), (133, 189, 'n5qwg1', 0, 1, 1, 1, 0, '2010-04-10 10:50:00', 231), (134, 190, 'alley999', 0, 1, 1, 1, 0, '2010-04-10 10:50:00', 231), (136, 191, 'one3five7nine', 1, 1, 1, 1, 0, '2010-04-10 10:50:00', 231), (137, 192, 'gb3647', 0, 1, 1, 1, 0, '2010-04-10 10:50:00', 231), (138, 193, 'kingdavid2000', 0, 1, 1, 1, 0, '2010-04-10 10:50:00', 231), (140, 194, 'ke5amb', 0, 1, 1, 1, 0, '2010-04-10 10:50:00', 231), (141, 195, 'yow7senr', 0, 1, 1, 1, 0, '2010-04-10 10:50:00', 231), (143, 196, 'w5los1', 0, 1, 1, 1, 0, '2010-04-10 10:50:00', 231), (144, 197, 'one3five7nine', 1, 1, 0, 0, 0, '2010-04-10 10:50:00', 231), (145, 198, 'justmine1', 0, 1, 1, 1, 0, '2010-04-10 10:50:00', 231), (176, 199, 'Samantha44', 0, 1, 1, 1, 0, '2010-04-10 10:50:00', 231), (178, 200, '690014809j', 0, 1, 1, 1, 0, '2010-04-10 10:50:00', 231), (181, 201, 'jotas123', 0, 1, 1, 1, 0, '2010-04-10 10:50:00', 231), (182, 202, 'ad5ca8711', 0, 1, 1, 1, 0, '2010-04-10 10:50:00', 231), (185, 203, '3D5pass', 0, 1, 1, 1, 0, '2010-04-10 10:50:00', 231), (195, 204, 'mickeym1@peoplepc.com', 0, 1, 1, 1, 0, '2010-04-10 10:50:00', 231), (197, 206, 'wb5izd', 0, 1, 1, 1, 0, '2010-04-10 10:50:00', 231), (199, 207, 'Satellite10', 0, 1, 1, 1, 0, '2010-04-10 10:50:00', 231), (200, 208, 'parts111', 0, 1, 1, 1, 0, '2010-04-10 10:50:00', 231), (204, 210, 's0rrel', 0, 1, 1, 1, 0, '2010-04-10 10:50:00', 231), (210, 211, 'g8787f', 0, 1, 1, 1, 0, '2010-04-10 10:50:00', 231), (214, 212, 'JocKo001', 0, 1, 1, 1, 0, '2010-04-10 10:50:00', 231), (221, 214, 'freedom23', 0, 1, 1, 0, 0, '2010-04-10 10:50:00', 231), (222, 215, 'rocky814', 0, 1, 1, 1, 0, '2010-04-10 10:50:00', 231), (223, 216, 'n5umjep', 0, 1, 1, 1, 0, '2010-04-10 10:50:00', 231), (225, 217, 'detective669', 0, 1, 1, 1, 0, '2010-04-10 10:50:00', 231), (226, 218, '2Old4this', 0, 1, 1, 1, 0, '2010-04-10 10:50:00', 231), (227, 219, '9two0one0', 0, 1, 1, 1, 0, '2010-04-10 10:50:00', 231), (228, 220, 'one9four2eight', 0, 1, 1, 1, 0, '2010-04-10 10:50:00', 231), (229, 221, 'radioman570', 0, 1, 1, 1, 0, '2010-04-10 10:50:00', 231), (230, 222, 'baker1957', 0, 1, 1, 1, 0, '2010-04-10 10:50:00', 231), (231, 223, 'samp1997', 0, 1, 1, 1, 0, '2010-04-10 10:50:00', 231), (232, 224, '10Dev10', 0, 1, 1, 1, 0, '2010-04-10 10:50:00', 231), (233, 225, 'trooper1', 0, 1, 1, 1, 0, '2010-04-10 10:50:00', 231), (235, 226, 'k5bv001', 0, 1, 1, 1, 0, '2010-04-10 10:50:00', 231), (236, 227, 'wllnm1whxbic8yfw', 0, 1, 0, 0, 0, '2010-04-10 10:50:00', 231), (237, 228, 'SLKIRK35', 0, 1, 1, 1, 0, '2010-04-10 10:50:00', 231), (238, 229, 'prissey2', 0, 1, 1, 1, 0, '2010-04-10 10:50:00', 231), (240, 230, 'sha1wna', 0, 1, 1, 1, 0, '2010-04-10 10:50:00', 231), (242, 231, 'kc5rpg', 0, 1, 1, 1, 1, '2010-04-10 10:50:00', 231), (245, 232, 'wc5eoc-11', 0, 1, 1, 0, 0, '2010-05-06 12:43:34', 231), (247, 233, '1Jehovah', 0, 1, 1, 1, 0, '2010-05-11 09:22:17', 231), (249, 234, '3009parkerdr', 0, 1, 1, 1, 0, '2010-05-19 19:44:02', 214), (251, 235, '6d72dogs', 0, 1, 1, 1, 0, '2010-07-05 23:43:48', 178), (253, 237, 'banker72', 0, 1, 1, 0, 0, '2010-07-14 18:19:44', 234), (254, 238, 'Captain178', 0, 1, 1, 1, 0, '2010-07-26 13:26:59', 231), (255, 239, 'f28crvp6', 0, 1, 1, 1, 0, '2010-07-29 10:51:44', 201), (257, 240, '1bexarares4', 0, 1, 1, 1, 0, '2010-07-31 18:45:17', 203), (258, 241, 'bry0604', 0, 1, 1, 1, 0, '2010-08-02 12:32:17', 179), (259, 242, 'promal55', 0, 1, 1, 1, 0, '2010-08-03 15:05:25', 231), (260, 243, 'peanut1', 0, 1, 1, 1, 0, '2010-08-03 15:05:25', 175), (261, 244, 'c3j2pxdk', 1, 1, 1, 0, 0, '2010-08-07 20:24:45', 231), (262, 245, 'm8fptd02', 1, 1, 1, 1, 0, '2010-08-09 16:36:02', 231), (263, 246, 'bo6N4E7l', 0, 1, 1, 1, 0, '2010-08-10 18:11:55', 201), (264, 247, 'Buddy-2010', 0, 1, 0, 0, 0, '2010-08-15 11:28:54', 219), (265, 248, '1gyl5n1gyl5n', 0, 1, 0, 0, 0, '2010-08-16 08:02:03', 233), (266, 249, 'Galaxy75', 0, 1, 0, 0, 0, '2010-08-18 07:02:23', 184), (267, 250, 'ae5jykk5tc', 0, 1, 1, 1, 0, '2010-08-18 15:25:05', 184), (268, 251, 'ham5radio', 0, 1, 0, 0, 0, '2010-08-18 15:25:05', 211), (270, 253, 'ziggy1', 0, 1, 1, 1, 0, '2010-10-02 13:12:22', 201), (271, 254, 'RastaMon37', 0, 1, 0, 0, 0, '2010-10-03 15:23:47', 234), (272, 255, 'david46', 0, 1, 1, 1, 0, '2010-10-04 16:36:23', 200), (273, 256, 'fireline99', 0, 1, 0, 0, 0, '2010-10-07 16:38:21', 229), (274, 257, 'N5umj-10', 0, 1, 1, 1, 0, '2010-10-08 16:37:31', 242), (275, 258, 'Karina#01', 0, 1, 1, 1, 0, '2010-10-17 23:04:57', 242), (276, 259, '6u3ky15u', 0, 1, 0, 0, 0, '2010-11-07 16:55:32', 188), (277, 260, 'Wb5lyjudy$1026', 0, 1, 1, 0, 0, '2010-11-11 20:57:56', 231), (278, 261, 'tvy9mbx75', 1, 1, 0, 0, 0, '2010-11-28 23:29:56', 221), (279, 262, 'SuperWD40', 0, 1, 1, 1, 0, '2010-12-04 12:21:36', 175), (280, 263, 'n5ya11', 0, 1, 1, 1, 0, '2011-01-04 09:03:05', 174), (281, 264, 'shekinah1', 0, 1, 1, 1, 0, '2011-01-14 19:14:36', 178), (283, 266, 'muchu1955', 0, 1, 0, 0, 0, '2011-01-12 21:11:35', 183), (284, 267, 'thf3j0by7', 1, 1, 1, 0, 0, '2011-01-12 21:11:35', 183), (285, 268, '9b29pdj8n', 1, 1, 0, 0, 0, '2011-01-12 21:11:35', 183), (286, 269, 'sj37b476d', 1, 1, 0, 0, 0, '2011-01-12 21:11:35', 183), (287, 270, '7v69fjwgn', 1, 1, 0, 0, 0, '2011-01-12 21:11:35', 183), (288, 271, 'kendmak256', 0, 1, 0, 0, 0, '2011-01-12 21:11:35', 183), (289, 272, '2140rdw', 0, 1, 0, 0, 0, '2011-01-12 21:11:35', 183), (290, 273, 'socks07', 0, 1, 0, 0, 0, '2011-01-12 20:27:35', 262), (291, 274, 'ama4908ama4908', 0, 1, 0, 0, 0, '2011-01-12 21:07:32', 262), (293, 276, '101041s', 0, 1, 0, 0, 0, '2011-01-12 23:10:25', 207), (294, 277, 'd2a0v8i0d', 0, 1, 0, 0, 0, '2011-01-13 09:07:32', 183), (295, 278, 'sf11qghw0', 1, 1, 0, 0, 0, '2011-01-16 19:05:23', 238), (296, 279, 'nikonf4', 0, 1, 0, 0, 0, '2011-01-13 13:57:32', 183), (297, 280, 'gmn0st62v', 1, 1, 0, 0, 0, '2011-01-13 13:57:32', 183), (298, 281, 'augumon890', 0, 1, 0, 0, 0, '2011-01-13 13:57:32', 183), (299, 282, 'k3q50c8m6', 1, 1, 0, 0, 0, '2011-01-13 13:57:32', 183), (300, 283, 'jrod20', 0, 1, 0, 0, 0, '2011-01-13 13:57:32', 183), (301, 284, 'jessed68', 0, 1, 0, 0, 0, '2011-01-13 20:31:45', 183), (302, 285, '8yp2bgk00', 1, 1, 0, 0, 0, '2011-01-16 19:05:23', 238), (303, 286, 'k5bv001', 0, 1, 1, 1, 0, '2011-01-14 20:45:51', 202), (304, 287, 'plover3', 0, 1, 0, 0, 0, '2011-01-15 06:24:47', 250), (305, 288, 'jac071099', 0, 1, 0, 0, 0, '2011-01-15 09:37:35', 243), (306, 289, 'jac071099', 0, 1, 0, 0, 0, '2011-01-15 11:01:48', 262), (307, 290, 'SambowJasper77', 0, 1, 0, 0, 0, '2011-01-15 11:01:48', 262), (308, 291, '25h4c8360', 1, 1, 0, 0, 0, '2011-01-15 11:01:48', 262), (309, 292, 'r526bqkvp', 1, 1, 0, 0, 0, '2011-01-15 11:01:48', 262), (310, 293, 'w5wpw5wp', 0, 1, 0, 0, 0, '2011-01-15 11:01:48', 262), (311, 294, 'fritz99', 0, 1, 0, 0, 0, '2011-01-15 11:39:25', 183), (312, 295, 'B310re22', 0, 1, 0, 0, 0, '2011-01-15 12:15:53', 202), (313, 296, '4795hy6t1', 1, 1, 1, 1, 0, '2011-01-15 13:25:38', 203), (314, 297, 'jcs1367', 0, 1, 1, 1, 0, '2011-01-15 18:57:19', 231), (315, 298, 'mc51w0t6d', 1, 1, 0, 0, 0, '2011-01-19 22:11:29', 240), (316, 299, '0t177jxkz', 1, 1, 0, 0, 0, '2011-01-16 09:42:55', 233), (317, 300, 'x8v7sjf4w', 1, 1, 0, 0, 0, '2011-01-16 11:04:10', 183), (318, 301, '8wn76dxqh', 1, 1, 0, 0, 0, '2011-01-16 20:39:31', 233), (319, 302, 'ncx8qdbvw', 1, 1, 0, 0, 0, '2011-01-16 20:54:53', 233), (320, 303, 'hammin01', 0, 1, 0, 0, 0, '2011-01-17 10:14:50', 208), (321, 304, 'l0ckdave5162', 0, 1, 0, 0, 0, '2011-01-17 08:37:52', 233), (322, 305, 'vbc961p75', 1, 1, 0, 0, 0, '2011-01-17 08:37:52', 233), (323, 306, 'mediaa123mediaa123', 0, 1, 0, 0, 0, '2011-01-17 08:37:52', 233), (324, 307, 'hisdhisd11', 0, 1, 0, 0, 0, '2011-01-17 06:57:45', 231), (325, 308, 's4d21y8v6', 1, 1, 0, 0, 0, '2011-01-17 08:37:52', 211), (326, 309, 'bfsjr5738', 0, 1, 0, 0, 0, '2011-01-17 08:37:52', 233), (327, 310, 'JerryNJan123', 0, 1, 0, 0, 0, '2011-01-17 08:37:52', 255), (328, 311, 'pmx80jy3h', 1, 1, 0, 0, 0, '2011-01-17 08:05:52', 183), (329, 312, '6jb98pd72', 1, 1, 0, 0, 0, '2011-01-17 08:37:52', 255), (330, 313, 'sydney3', 0, 1, 0, 0, 0, '2011-01-17 08:37:52', 233), (331, 314, '1cobra23', 0, 1, 0, 0, 0, '2011-01-17 09:09:32', 262), (332, 315, 'L1ghtning', 0, 1, 0, 0, 0, '2011-01-17 09:09:32', 262), (333, 316, 'vgj0wcyrq', 1, 1, 0, 0, 0, '2011-01-17 08:37:52', 250), (334, 317, 'kj5owham', 0, 1, 0, 0, 0, '2011-01-17 08:37:52', 233), (335, 318, 'B1satdak', 0, 1, 0, 0, 0, '2011-01-17 10:14:50', 181), (336, 319, 'wj47f8rh9', 1, 1, 0, 0, 0, '2011-01-17 10:02:29', 183), (337, 320, '7429TEXAS', 0, 1, 0, 0, 0, '2011-01-17 09:18:11', 250), (338, 321, '7daytexas', 0, 1, 0, 0, 0, '2011-01-17 10:14:50', 181), (339, 322, '7fc21g9pd', 1, 1, 0, 0, 0, '2011-01-17 09:18:11', 250), (340, 323, 'Bouwina66', 0, 1, 0, 0, 0, '2011-01-17 09:18:11', 250), (341, 324, 'crz4ybv6t', 1, 1, 0, 0, 0, '2011-01-17 09:18:11', 250), (342, 325, 'gkc3wyh4t', 1, 1, 0, 0, 0, '2011-01-17 09:18:11', 250), (343, 326, 'huffman1', 0, 1, 0, 0, 0, '2011-01-17 23:40:13', 255), (344, 327, '9062vdqpx', 1, 1, 0, 0, 0, '2011-01-17 10:07:38', 234), (345, 328, 'mwn0h85j4', 1, 1, 0, 0, 0, '2011-01-17 09:52:00', 250), (346, 329, 'yx33kf7gr', 1, 1, 0, 0, 0, '2011-01-17 10:44:56', 250), (347, 330, '1gb1nd24p', 1, 1, 0, 0, 0, '2011-01-17 10:15:20', 250), (348, 331, 'hcco4dre', 0, 1, 0, 0, 0, '2011-01-17 12:07:26', 233), (349, 332, '0p805wyrg', 1, 1, 0, 0, 0, '2011-01-17 10:14:50', 262), (350, 333, 's3d5qhzk5', 1, 1, 0, 0, 0, '2011-01-17 12:07:26', 233), (351, 334, 'h2v69jz3k', 1, 1, 0, 0, 0, '2011-01-17 10:44:56', 250), (352, 335, 'w5wq43w', 0, 1, 0, 0, 0, '2011-01-17 11:51:27', 181), (353, 336, 'kb5ofzisrene', 0, 1, 0, 0, 0, '2011-01-17 21:42:30', 211), (354, 337, '3479will', 0, 1, 0, 0, 0, '2011-01-17 11:44:05', 234), (355, 338, 'dq79hxgb2', 1, 1, 0, 0, 0, '2011-01-17 12:07:26', 233), (356, 339, 'Maxwell1', 0, 1, 0, 0, 0, '2011-01-17 12:07:26', 233), (357, 340, 'ybg21sqc8', 1, 1, 0, 0, 0, '2011-01-17 12:02:53', 250), (358, 341, '27May2001', 0, 1, 0, 0, 0, '2011-01-17 11:51:27', 208), (359, 342, 'svf75x3r9', 1, 1, 0, 0, 0, '2011-01-17 12:16:39', 250), (360, 343, 'wilco1', 0, 1, 0, 0, 0, '2011-01-17 15:19:05', 234), (361, 344, 'k5lrdk5lrd', 0, 1, 0, 0, 0, '2011-01-17 23:40:13', 255), (362, 345, 'gs06zf2d3', 1, 1, 0, 0, 0, '2011-01-17 14:43:39', 250), (363, 346, 'dar5ek', 0, 1, 0, 0, 0, '2011-01-17 23:40:13', 255), (364, 347, 'xts332006', 1, 1, 0, 0, 0, '2011-01-17 21:42:30', 211), (365, 348, 'registration0dud', 1, 0, 0, 0, 0, '2011-01-17 17:11:19', 240), (366, 349, 'thx4zs64g', 1, 1, 0, 0, 0, '2011-01-17 21:42:30', 211), (367, 350, 'jgh8fzwt2', 1, 1, 0, 0, 0, '2011-01-17 21:53:15', 250), (368, 351, 'kny2rwsgh', 1, 1, 0, 0, 0, '2011-01-19 21:19:27', 238), (369, 352, 'pmv1x34j7', 1, 1, 1, 0, 0, '2011-01-17 23:40:13', 231), (371, 354, '48d4q1b0p', 1, 1, 0, 0, 0, '2011-01-18 12:57:28', 188), (372, 355, '6meterdx', 0, 1, 0, 0, 0, '2011-01-17 23:40:13', 255), (373, 356, 'DuckSTX345', 0, 1, 0, 0, 0, '2011-01-18 09:01:43', 181), (374, 357, '1841vnwz7', 1, 1, 0, 0, 0, '2011-01-17 23:40:13', 211), (375, 358, 'n6y0w82sg', 1, 1, 0, 0, 0, '2011-01-17 23:40:13', 233), (376, 359, '505stxares', 0, 1, 0, 0, 0, '2011-01-18 06:34:15', 250), (377, 360, '6gk2drmq5', 1, 1, 0, 0, 0, '2011-01-21 07:45:10', 255), (378, 361, 'Catmandu6348', 0, 1, 0, 0, 0, '2011-01-18 10:15:03', 212), (379, 362, 'kd7hamsam38', 0, 1, 0, 0, 0, '2011-01-18 12:18:57', 220), (380, 363, 'n3z95m1y2', 1, 1, 0, 0, 0, '2011-01-21 07:45:10', 233), (382, 365, 'acems2233', 0, 1, 0, 0, 0, '2011-01-21 07:45:10', 255), (383, 366, '9qm7nh2vr', 1, 1, 0, 0, 0, '2011-01-21 07:45:11', 233), (384, 367, 't6x99hq0y', 1, 1, 0, 0, 0, '2011-01-18 18:45:50', 183), (385, 368, 'sc72alex', 0, 1, 0, 0, 0, '2011-01-18 18:49:19', 183), (386, 369, 'vfr708qxb', 1, 1, 0, 0, 0, '2011-01-19 22:52:41', 207), (387, 370, 'registration0dud', 1, 0, 0, 0, 0, '2011-01-18 20:49:52', 193), (388, 371, '120west', 0, 1, 0, 0, 0, '2011-01-18 23:43:58', 220), (389, 372, 'nbTR18ONO', 0, 1, 0, 0, 0, '2011-01-19 09:26:54', 296), (390, 373, 'kc5abr73', 0, 1, 0, 0, 0, '2011-01-21 07:45:10', 255), (391, 374, 'hxs7g24nz', 1, 1, 0, 0, 0, '2011-01-20 00:42:08', 220), (392, 375, 'spooky01', 0, 1, 1, 0, 0, '2011-01-19 14:25:42', 231), (393, 376, 'House123', 0, 1, 0, 0, 0, '2011-01-19 21:44:28', 250), (394, 377, 'scastle1', 0, 1, 0, 0, 0, '2011-01-19 22:11:29', 297), (395, 378, 'jhc3q439d', 1, 1, 0, 0, 0, '2011-01-21 20:30:46', 188), (396, 379, '5mz8xdqpn', 1, 1, 0, 0, 0, '2011-01-19 22:52:40', 207), (397, 380, 'tejanocowboy418', 0, 1, 0, 0, 0, '2011-01-19 22:11:29', 240), (398, 381, '3q92xkpnb', 1, 1, 0, 0, 0, '2011-01-19 22:11:28', 240), (399, 382, 'austin7252', 0, 1, 0, 0, 0, '2011-01-21 20:30:47', 188), (400, 383, '9jv9y5n03', 1, 1, 0, 0, 0, '2011-01-20 15:56:24', 262), (401, 384, 'd190x002p', 1, 1, 0, 0, 0, '2011-01-20 14:41:13', 183), (402, 385, 'vx993nwks', 1, 1, 0, 0, 0, '2011-01-20 18:07:19', 183), (403, 386, 'bo26bo26', 0, 1, 0, 0, 0, '2011-01-20 18:34:25', 225), (404, 387, 'pjc7q836n', 1, 1, 0, 0, 0, '2011-01-20 19:17:12', 183), (405, 388, 'qg327kh8c', 1, 1, 0, 0, 0, '2011-01-20 19:17:14', 183), (406, 389, 'ssei1234', 0, 1, 0, 0, 0, '2011-01-20 19:17:13', 183), (407, 390, 'vy57sjz3p', 1, 1, 0, 0, 0, '2011-01-20 19:17:14', 231), (408, 391, '2638hvn7t', 1, 1, 0, 0, 0, '2011-01-21 07:45:10', 255), (409, 392, 'yzerman19', 0, 1, 0, 0, 0, '2011-01-21 18:33:01', 207), (410, 393, 'blackjack1935', 0, 1, 0, 0, 0, '2011-01-21 12:00:19', 220), (411, 394, 'p4z0qv5b2', 1, 1, 0, 0, 0, '2011-01-21 15:06:07', 183), (412, 395, 'dqx0gk0ws', 1, 1, 0, 0, 0, '2011-01-21 21:13:35', 183), (413, 396, 'major1296', 0, 1, 0, 0, 0, '2011-01-21 20:30:47', 212), (414, 397, 'fl220111', 0, 1, 0, 0, 0, '2011-01-22 08:43:18', 226), (415, 398, 'armadillo1', 0, 1, 0, 0, 0, '2011-01-22 10:30:00', 250), (416, 399, 'nds0w7c6v', 1, 1, 0, 0, 0, '2011-01-22 23:09:56', 220), (417, 400, 'tb2845jrc', 1, 1, 0, 0, 0, '2011-01-22 23:48:27', 207), (418, 401, 'k409x8tp3', 1, 1, 0, 0, 0, '2011-01-23 08:43:19', 220), (419, 402, 'nkj23q1yt', 1, 1, 0, 0, 0, '2011-01-23 17:17:04', 183), (420, 403, 'xhg8swy8n', 1, 1, 0, 0, 0, '2011-01-24 11:45:56', 220), (421, 404, 'c1e2n3t4', 0, 1, 0, 0, 0, '2011-01-23 23:18:23', 220), (422, 405, 'killerbud1', 0, 1, 0, 0, 0, '2011-01-24 07:05:13', 179), (423, 406, 'registration0dud', 1, 0, 0, 0, 0, '2011-01-23 21:50:48', 181), (424, 407, 'k8j5q056b', 1, 1, 0, 0, 0, '2011-01-24 10:27:04', 220), (425, 408, '1fc58qt7w', 1, 1, 0, 0, 0, '2011-01-24 11:41:41', 217), (426, 409, '7452356a', 0, 1, 0, 0, 0, '2011-01-24 15:46:19', 217), (427, 410, 'registration0dud', 1, 0, 0, 0, 0, '2011-01-24 15:36:22', 220), (428, 411, 'registration0dud', 1, 0, 0, 0, 0, '2011-01-24 16:27:09', 220), (429, 412, 'registration0dud', 1, 0, 0, 0, 0, '2011-01-24 16:32:25', 220), (430, 413, 'kti8751', 0, 1, 0, 0, 0, '2011-01-24 18:09:07', 217); -- -------------------------------------------------------- -- -- Table structure for table `auxcounty` -- CREATE TABLE IF NOT EXISTS `auxcounty` ( `personid` int(11) NOT NULL COMMENT 'ref to person table', `countyid` int(11) NOT NULL COMMENT 'ref to counties table', PRIMARY KEY (`personid`,`countyid`), KEY `fk_person` (`personid`), KEY `fk_county` (`countyid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List additional/multiple counties associated with a person.'; -- -- Dumping data for table `auxcounty` -- INSERT INTO `auxcounty` (`personid`, `countyid`) VALUES (212, 41), (226, 4); -- -------------------------------------------------------- -- -- Table structure for table `capability` -- CREATE TABLE IF NOT EXISTS `capability` ( `capability_id` int(11) NOT NULL auto_increment, `capability` varchar(15) NOT NULL default '', `winlinkitem` tinyint(1) NOT NULL default '0', PRIMARY KEY (`capability_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='list of technical radio capabilities' AUTO_INCREMENT=18 ; -- -- Dumping data for table `capability` -- INSERT INTO `capability` (`capability_id`, `capability`, `winlinkitem`) VALUES (9, 'HF', 0), (10, 'VHF', 0), (11, 'UHF', 0), (12, 'DSTAR', 0), (13, 'Echolink', 0), (14, 'Packet', 1), (15, 'Pactor1', 1), (16, 'Pactor23', 1), (17, 'Winmor', 1); -- -------------------------------------------------------- -- -- Table structure for table `counties` -- CREATE TABLE IF NOT EXISTS `counties` ( `county_id` int(11) NOT NULL auto_increment, `districtid` int(11) NOT NULL, `county` varchar(20) default NULL, `showorder` int(2) NOT NULL default '1' COMMENT 'Display order: [-1=do not show][0=show at top][1=show alpha][2=show at end]', PRIMARY KEY (`county_id`), KEY `idx_districtid` (`districtid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Counties with associated District' AUTO_INCREMENT=105 ; -- -- Dumping data for table `counties` -- INSERT INTO `counties` (`county_id`, `districtid`, `county`, `showorder`) VALUES (1, 16, '!District', -1), (2, 16, '!Section', -1), (3, 2, 'Angelina', 1), (4, 4, 'Aransas', 1), (5, 12, 'Atascosa', 1), (6, 1, 'Austin', 1), (7, 6, 'Bandera', 1), (8, 7, 'Bastrop', 1), (9, 4, 'Bee', 1), (10, 12, 'Bexar', 1), (11, 7, 'Blanco', 1), (12, 1, 'Brazoria', 1), (13, 5, 'Brazos', 1), (14, 3, 'Brooks', 1), (15, 5, 'Burleson', 1), (16, 8, 'Burnet', 1), (17, 7, 'Caldwell', 1), (18, 10, 'Calhoun', 1), (19, 15, 'Cameron', 1), (20, 1, 'Chambers', 1), (21, 10, 'Colorado', 1), (22, 12, 'Comal', 1), (23, 8, 'Concho', 1), (24, 10, 'DeWitt', 1), (25, 13, 'Dimmit', 1), (26, 13, 'Duval', 1), (27, 6, 'Edwards', 1), (28, 7, 'Fayette', 1), (29, 1, 'Fort Bend', 1), (30, 13, 'Frio', 1), (31, 1, 'Galveston', 1), (32, 8, 'Gillespie', 1), (33, 10, 'Goliad', 1), (34, 5, 'Grimes', 1), (35, 12, 'Guadalupe', 1), (36, 9, 'Hardin', 1), (37, 14, 'Harris-NE', 1), (38, 14, 'Harris-NW', 1), (39, 14, 'Harris-SE', 1), (40, 14, 'Harris-SW', 1), (41, 7, 'Hays', 1), (42, 3, 'Hidalgo', 1), (43, 2, 'Houston', 1), (44, 10, 'Jackson', 1), (45, 9, 'Jasper', 1), (46, 9, 'Jefferson', 1), (47, 3, 'Jim Hogg', 1), (48, 4, 'Jim Wells', 1), (49, 10, 'Karnes', 1), (50, 12, 'Kendall', 1), (51, 15, 'Kenedy', 1), (52, 6, 'Kerr', 1), (53, 8, 'Kimble', 1), (54, 6, 'Kinney', 1), (55, 4, 'Kleberg', 1), (56, 13, 'La Salle', 1), (57, 10, 'Lavaca', 1), (58, 7, 'Lee', 1), (59, 5, 'Leon', 1), (60, 1, 'Liberty', 1), (61, 4, 'Live Oak', 1), (62, 8, 'Llano', 1), (63, 5, 'Madison', 1), (64, 8, 'Mason', 1), (65, 10, 'Matagorda', 1), (66, 13, 'Maverick', 1), (67, 8, 'McCulloch', 1), (68, 13, 'McMullen', 1), (69, 6, 'Medina', 1), (70, 8, 'Menard', 1), (71, 5, 'Milam', 1), (72, 1, 'Montgomery', 1), (73, 9, 'Newton', 1), (74, 4, 'Nueces', 1), (75, 9, 'Orange', 1), (76, 2, 'Polk', 1), (77, 6, 'Real', 1), (78, 4, 'Refugio', 1), (79, 5, 'Robertson', 1), (80, 9, 'Sabine', 1), (81, 9, 'San Augustine', 1), (82, 2, 'San Jacinto', 1), (83, 4, 'San Patricio', 1), (84, 8, 'San Saba', 1), (85, 3, 'Starr', 1), (86, 7, 'Travis', 1), (87, 2, 'Trinity', 1), (88, 9, 'Tyler', 1), (89, 6, 'Uvalde', 1), (90, 6, 'Val Verde', 1), (91, 10, 'Victoria', 1), (92, 2, 'Walker', 1), (93, 1, 'Waller', 1), (94, 5, 'Washington', 1), (95, 13, 'Webb', 1), (96, 10, 'Wharton', 1), (97, 15, 'Willacy', 1), (98, 7, 'Williamson', 1), (99, 12, 'Wilson', 1), (100, 3, 'Zapata', 1), (101, 13, 'Zavala', 1), (103, 12, 'Gonzales', 1), (104, 17, 'N/A', 0); -- -------------------------------------------------------- -- -- Table structure for table `courses` -- CREATE TABLE IF NOT EXISTS `courses` ( `course_id` int(11) NOT NULL auto_increment, `coursename` varchar(25) NOT NULL default '', `badge` tinyint(1) NOT NULL default '0' COMMENT 'does this course count for badge merit', PRIMARY KEY (`course_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='list of courses for training' AUTO_INCREMENT=8 ; -- -- Dumping data for table `courses` -- INSERT INTO `courses` (`course_id`, `coursename`, `badge`) VALUES (1, 'ARRL EC-001', 0), (2, 'ICS 100', 1), (3, 'ICS 200', 1), (4, 'ICS 700', 1), (5, 'ICS 800', 1), (6, 'Skywarn', 0), (7, 'ARRL EC-016', 0); -- -------------------------------------------------------- -- -- Table structure for table `districts` -- CREATE TABLE IF NOT EXISTS `districts` ( `district_id` int(11) NOT NULL auto_increment, `district` varchar(12) default NULL COMMENT 'District name, format: District ##', `showorder` int(2) NOT NULL default '1' COMMENT 'Display order: [-1=do not show][0=show at top][1=show alpha][2=show at end]', PRIMARY KEY (`district_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of Districts in the Section.' AUTO_INCREMENT=18 ; -- -- Dumping data for table `districts` -- INSERT INTO `districts` (`district_id`, `district`, `showorder`) VALUES (1, 'District 01', 1), (2, 'District 02', 1), (3, 'District 03', 1), (4, 'District 04', 1), (5, 'District 05', 1), (6, 'District 06', 1), (7, 'District 07', 1), (8, 'District 08', 1), (9, 'District 09', 1), (10, 'District 10', 1), (11, 'District 11', 1), (12, 'District 12', 1), (13, 'District 13', 1), (14, 'District 14', 1), (15, 'District 15', 1), (16, '!Section', -1), (17, 'N/A', 0); -- -------------------------------------------------------- -- -- Table structure for table `documents` -- CREATE TABLE IF NOT EXISTS `documents` ( `doc_id` int(11) NOT NULL auto_increment, `filename` varchar(100) NOT NULL COMMENT 'filename with extension but no path', `title` varchar(100) NOT NULL COMMENT 'title of the document', `description` varchar(255) NOT NULL COMMENT 'Short descripton of the contents.', `public` tinyint(1) NOT NULL default '0' COMMENT 'vs. vault', `date_added` datetime NOT NULL COMMENT 'date added to database', `personid` int(11) NOT NULL, PRIMARY KEY (`doc_id`), KEY `fk_person` (`personid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=65 ; -- -- Dumping data for table `documents` -- INSERT INTO `documents` (`doc_id`, `filename`, `title`, `description`, `public`, `date_added`, `personid`) VALUES (41, 'STX ARES Leaders.pdf', 'STX ARES Leaders Listing', 'Email and phone contact information for STX ARES leaders by district and title.', 0, '2011-01-24 11:19:49', 231), (42, 'EmcommPMBOs.txt', 'Winlink HF EMCOMM Station data', 'EMCOMM RMS PACTOR frequencies', 0, '2010-10-11 08:09:41', 231), (49, 'ARES District 8 Emergency Plan.doc', 'District 8 Emergency Plan', 'Revision 1.0 of the district 8 ARES(r) emergency plan', 1, '2010-07-13 07:46:02', 179), (54, 'STX ARES agency e-mail list.txt', 'STX ARES Agency e-mail list', 'Not all of these will be regularly monitored and addresses are subject to changes in activations.', 0, '2010-08-18 10:31:41', 231), (55, '2009 WILLIAMSON COUNTY ARES Plan June21 2009.pdf', 'Williamson County ARES Plan', 'The current Williamson County ARES Plan. The plan is currently under review and update.', 1, '2010-10-05 21:22:21', 214), (56, 'ARES Dist 4 SET Report 2010-10-02.pdf', 'Simulated Emergency Test (SET) South Texas ARES Di', 'An evaluation of the use of Simplex VHF for communications within STX ARES Dist. 4 when repeaters are inoperative or repeater use is impractical because of heavy traffic volume ', 1, '2010-10-06 11:06:12', 226), (58, 'STX_ARES_Plan 2.9.pdf', 'Emergency Communications Plan', 'Emergency Communications Plan for the STX ARES Area', 1, '2010-11-16 15:07:48', 231), (61, 'ARES Webb County Plan.pdf', 'Webb County ARES Plan', 'This is the current Webb County ARES Plan. This document will be subject to changes and modifications as time goes by not to mention field tests and other on going operations.', 1, '2010-12-29 17:13:55', 242), (64, '2011 Registration Process for South Texas ARES.pdf', 'Registration Process for South Texas ARES', 'This is a tutorial on registering and then using our section Information Vault.', 1, '2011-01-12 16:01:46', 231); -- -------------------------------------------------------- -- -- Table structure for table `eqreports` -- CREATE TABLE IF NOT EXISTS `eqreports` ( `report_id` int(11) NOT NULL auto_increment, `reportname` varchar(40) NOT NULL default '' COMMENT 'String to display to user in pulldowns.', `reportcode` varchar(20) NOT NULL default '' COMMENT 'String to select on in db code.', `displayorder` int(3) NOT NULL default '0' COMMENT 'Order to display to user.', PRIMARY KEY (`report_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of reports to run for equipment data.' AUTO_INCREMENT=11 ; -- -- Dumping data for table `eqreports` -- INSERT INTO `eqreports` (`report_id`, `reportname`, `reportcode`, `displayorder`) VALUES (1, 'List full entries', 'entries', 1), (2, 'List Winlink Server capability', 'winlinkserver', 2), (3, 'List Winlink client emails', 'clientemail', 3), (4, 'List Voice capability', 'voicecapability', 4), (5, 'List HF capability', 'hfcapability', 5), (6, 'List Packet capability', 'packet', 7), (7, 'List Repeaters', 'repeaters', 8), (8, 'Voice stats by District', 'voicestats', 9), (9, 'Facility stats by District', 'facilitystats', 10), (10, 'List RMS capability', 'rmscapability', 6); -- -------------------------------------------------------- -- -- Table structure for table `equipment` -- CREATE TABLE IF NOT EXISTS `equipment` ( `eq_id` int(11) NOT NULL auto_increment, `countyid` int(11) NOT NULL COMMENT 'ref to counties table entry', `locType` varchar(15) default 'Other' COMMENT 'Type of facility', `locName` varchar(75) default NULL COMMENT 'Name of facility', `locAddress` varchar(75) default NULL COMMENT 'Street address', `locPower` tinyint(1) default '0' COMMENT 'Emergency power?', `locComment` varchar(255) default NULL COMMENT 'Comment on location', `voiceRadio` tinyint(1) default '0' COMMENT 'Voice Radio', `vr2m` tinyint(1) default '0' COMMENT '2 Meter', `vr70cm` tinyint(1) default '0' COMMENT '70 cm', `vrhf` tinyint(1) default '0' COMMENT 'HF', `vrdstar` tinyint(1) default '0' COMMENT 'DSTAR', `winlinkServer` tinyint(1) default '0' COMMENT 'Winlink Server', `packet` tinyint(1) default '0' COMMENT 'VHF/HF Packet', `packetCallsign` varchar(50) default NULL COMMENT 'can be series separated by commas', `packetFrequency` varchar(50) default NULL COMMENT 'can be series separated by commas', `rmsRelay` tinyint(1) default '0' COMMENT 'RMS Relay', `rmsActive` tinyint(1) default '0' COMMENT 'RMS Relay is active', `rmsP3Forwarding` tinyint(1) default '0' COMMENT 'HF PACTOR III Forwarding', `winmor` tinyint(1) default '0' COMMENT 'WINMOR', `winmorCallsign` varchar(10) default NULL COMMENT 'WINMOR callsign', `rmsPactor` tinyint(1) default '0' COMMENT 'HF RMS PACTOR', `rmsPactorCallsign` varchar(10) default NULL COMMENT 'HF RMS PACTOR callsign', `winlinkClient` tinyint(1) default '0' COMMENT 'Winlink Client', `clientEmail` varchar(64) default NULL COMMENT 'Winlink Client email', `clientEmail2` varchar(64) default NULL COMMENT 'secondary client email', `clientTelnet` tinyint(1) default '0' COMMENT 'Telnet', `clientPacket` tinyint(1) default '0' COMMENT 'VHF/UHF Packet', `clientHF` tinyint(1) default '0' COMMENT 'HF', `clientHFType` varchar(8) default NULL COMMENT 'PACTOR1, PACTOR2, PACTOR3, WINMOR', `repeater` tinyint(1) default '0' COMMENT 'Repeater', `repeaterFrequency` varchar(7) default NULL COMMENT '###.###', `repeaterTone` varchar(5) default NULL COMMENT '###.#', `repeaterOffset` varchar(7) default NULL COMMENT 'Plus, Minus, Simplex', `comment` varchar(255) default NULL COMMENT 'Capability comment', PRIMARY KEY (`eq_id`), KEY `idx_countyid` (`countyid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Details on Location and Capability for a single facility.' AUTO_INCREMENT=133 ; -- -- Dumping data for table `equipment` -- INSERT INTO `equipment` (`eq_id`, `countyid`, `locType`, `locName`, `locAddress`, `locPower`, `locComment`, `voiceRadio`, `vr2m`, `vr70cm`, `vrhf`, `vrdstar`, `winlinkServer`, `packet`, `packetCallsign`, `packetFrequency`, `rmsRelay`, `rmsActive`, `rmsP3Forwarding`, `winmor`, `winmorCallsign`, `rmsPactor`, `rmsPactorCallsign`, `winlinkClient`, `clientEmail`, `clientEmail2`, `clientTelnet`, `clientPacket`, `clientHF`, `clientHFType`, `repeater`, `repeaterFrequency`, `repeaterTone`, `repeaterOffset`, `comment`) VALUES (2, 12, 'eoc', 'Brazoria County EOC', '', 0, '', 1, 1, 1, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 1, '', NULL, 0, 1, 0, '', 0, '', '', '', 'Shared radio for voice and Winlink? 40/80M HF antenna - radio? Email address needs filled in.'), (3, 12, 'eoc', 'Pearland EOC', '', 0, '', 1, 1, 1, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 1, '', NULL, 0, 1, 0, '', 0, '', '', '', 'HF antenna installed'), (4, 12, 'hospital', 'Sweeny Hospital', '', 0, '', 1, 1, 1, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 1, '', NULL, 0, 1, 0, '', 0, '', '', '', ''), (5, 12, 'jumpkit', 'List location staged', '', 0, '10 Go-kits ready for deployment.', 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', NULL, 0, 0, 0, '', 0, '', '', '', 'Go-Kit capabilities needs to be filled in.'), (6, 29, 'eoc', 'Fort Bend EOC', '', 0, '', 1, 1, 1, 1, 1, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', NULL, 0, 0, 0, '', 0, '', '', '', ''), (7, 29, 'mobile', 'Fort Bend County Regional Communications Trailer', '', 1, '', 1, 1, 1, 1, 1, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 1, '', '', 0, 1, 0, '', 0, '', '', '', '2 ICOM 91 handy talkies with D Star. 1 each Motorola Commercial VHF, UHF and 800MHz Trunking radios.'), (8, 29, 'eoc', 'Sugar Land EOC', '', 0, '', 1, 1, 1, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 1, 'wb5exi@winlink.org', NULL, 0, 1, 0, '', 0, '', '', '', ''), (9, 29, 'eoc', 'Missouri City EOC', '', 0, '', 1, 1, 1, 1, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', NULL, 0, 0, 0, '', 0, '', '', '', ''), (10, 29, 'hospital', 'Sugar Land Memorial Herman Hospital', '', 0, '', 1, 1, 1, 1, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', NULL, 0, 0, 0, '', 0, '', '', '', '2 dual band Kenwood D700 Transceivers.'), (11, 29, 'hospital', 'Sugar Land Methodist Hospital', '', 0, '', 1, 1, 1, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 1, '', NULL, 0, 1, 0, '', 0, '', '', '', ''), (12, 29, 'eoc', 'Richmond EOC', '', 0, '', 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', NULL, 0, 0, 0, '', 0, '', '', '', ''), (13, 29, 'eoc', 'Rosenberg EOC', '', 0, '', 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', NULL, 0, 0, 0, '', 0, '', '', '', ''), (14, 29, 'eoc', 'Stafford EOC', '', 0, '', 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', NULL, 0, 0, 0, '', 0, '', '', '', ''), (15, 29, 'eoc', 'Weston Lakes (Incorporated) EOC', '', 0, '', 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', NULL, 0, 0, 0, '', 0, '', '', '', ''), (16, 29, 'other', 'Richmond State School', '', 0, '', 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', NULL, 0, 0, 0, '', 0, '', '', '', ''), (17, 72, 'other', 'Conroe American Red Cross Office', '', 0, '', 1, 1, 1, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', NULL, 0, 0, 0, '', 0, '', '', '', 'HF antenna installed'), (18, 72, 'hospital', 'St. Luke''s Hospital', '', 0, '', 1, 1, 1, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', NULL, 0, 0, 0, '', 0, '', '', '', ''), (19, 31, 'eoc', 'Galveston County Office of Emergency Management', '1353 FM 646, League City, TX 77573', 1, 'Co-located with NWS Houston/Galveston', 1, 1, 1, 1, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 1, 'wr5gc@winlink.org', '', 0, 1, 0, '', 1, '145.410', '131.8', 'Minus', 'A number of radios, power supplies and related gear are also in storage on the 3rd floor.'), (20, 3, 'eoc', 'Lufkin EOC', '', 1, '', 1, 1, 1, 1, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 1, '', NULL, 0, 1, 0, '', 0, '', '', '', ''), (21, 3, 'jumpkit', 'ARES Portable equipment', '', 1, '', 1, 1, 1, 1, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 1, '', '', 0, 1, 0, '', 1, '444.975', '141.3', 'Plus', '3 HSMM-MESH stations in development -- not yet deployable.'), (22, 3, 'other', 'American Red Cross Service Center - Lufkin', '', 1, '', 1, 1, 1, 1, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 1, '', NULL, 0, 1, 0, '', 0, '', '', '', 'RMS Packet node KE5CKM-10 in development. They have a number of extra 2M radios on site.'), (23, 3, 'other', 'American Red Cross Warehouse - Lufkin', '', 0, '', 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', NULL, 0, 0, 0, '', 0, '', '', '', ''), (24, 3, 'hospital', 'Memorial Medical Center - Lufkin', '', 1, '', 1, 1, 1, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 1, '', NULL, 0, 1, 0, '', 0, '', '', '', ''), (25, 3, 'hospital', 'Woodland Heights Medical Center', '', 1, '', 1, 1, 1, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', NULL, 0, 0, 0, '', 0, '', '', '', ''), (26, 3, 'other', 'County / City Health District - Lufkin', '', 1, '', 1, 1, 1, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 1, '', NULL, 0, 1, 0, '', 0, '', '', '', ''), (27, 3, 'eoc', 'Angelina County EOC - Lufkin', '', 1, '', 1, 1, 1, 0, 0, 1, 1, 'K5KRK-10', '145.070', 0, 0, 0, 0, '', 0, '', 0, '', '', 0, 0, 0, '', 0, '', '', '', ''), (28, 3, 'other', 'State Shelter Hub - Lufkin', '', 0, '', 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', NULL, 0, 0, 0, '', 0, '', '', '', 'VHF/UHF antenna only in place'), (29, 3, 'other', 'Disaster District Committee Sub 2B - DPS Lufkin', '', 0, '', 1, 1, 1, 1, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 1, '', NULL, 0, 1, 0, '', 0, '', '', '', 'HF all band dipole not up.'), (30, 3, 'other', 'Red Cross Affiliated Shelters - 6', '', 0, '', 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', NULL, 0, 0, 0, '', 0, '', '', '', '6 shelters have permanent VHF/UHF antennas installed. 1 shelter also has a permanent HF antenna installed.'), (31, 3, 'other', 'W5IRP 2M Repeater', '', 1, '', 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', NULL, 0, 0, 0, '', 1, '146.940', '141.3', 'Minus', 'remote base is fully frequency agile in VHF/UHF bands for linking outlying repeaters/simplex. Main antenna up 480 feet. Link antennas at 240 feet.'), (32, 3, 'Other', 'W5IRP 70CM Repeater', '', 1, '', 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', NULL, 0, 0, 0, '', 1, '444.975', '107.2', 'Plus', '240 feet'), (33, 3, 'other', 'W5IRP-10 RMS Packet node', '', 1, '', 0, 0, 0, 0, 0, 1, 1, 'W5IRP-10', '145.050', 1, 1, 0, 0, '', 0, '', 0, '', NULL, 0, 0, 0, '', 0, '', '', '', 'W5IRP-7 KA Node'), (34, 3, 'other', 'Saltgrass Repeater', '', 1, '', 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', '', 0, 0, 0, '', 1, '444.425', '203.5', 'Plus', 'Antenna up 240 feet'), (35, 92, 'eoc', 'Walker County EOC', '', 1, '', 1, 1, 1, 1, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 1, 'w5sam@winlink.org', '', 0, 1, 0, '', 0, '', '', '', '80/40M Fan Dipole in storage ready to be erected.'), (36, 92, 'firestation', 'Huntsville Firestation #2', '', 1, '', 1, 1, 1, 1, 0, 1, 1, 'W5SAM-10', '145.050', 0, 0, 0, 0, '', 0, '', 1, '', NULL, 1, 1, 0, '', 1, '146.860', '', 'Minus', 'Equipment stored at station with agreement to operate if EOC disabled or overwhelmed.'), (37, 92, 'other', 'Walker County Repeater - other UHF', '', 0, '', 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', NULL, 0, 0, 0, '', 1, '442.850', '127.3', 'Plus', '8 miles west off US Hwy 30. Antenna at 300 feet.'), (38, 92, 'other', 'Walker County Repeater - other VHF (W5RJV)', '', 0, '', 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', NULL, 0, 0, 0, '', 1, '145.270', '', 'Minus', 'Antenna up 50 feet.'), (39, 76, 'eoc', 'Office of Emergency Management', 'Livingston', 1, 'Generator backup', 1, 1, 1, 1, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 1, '', '', 0, 1, 0, '', 1, '147.040', '131.6', 'Plus', 'Antenna at 50 feet'), (40, 76, 'eoc', 'Onalaska Fire Department/EOC', 'Onalaska, Texas', 1, 'Generator backup', 1, 1, 1, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', '', 0, 0, 0, '', 0, '', '', '', 'Antenna up 40 feet'), (41, 76, 'hospital', 'Livingston Memorial Hospital', 'Livingston', 1, 'Generator Backup', 1, 1, 1, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 1, '', '', 0, 1, 0, '', 0, '', '', '', 'Antenna up 40 feet.'), (42, 76, 'firestation', 'Scenic Loop Fire Department', 'FM 3277, Polk County', 1, 'Generator Backup', 1, 1, 1, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', '', 0, 0, 0, '', 0, '', '', '', 'Antenna up 45 feet.'), (43, 76, 'firestation', 'Corrigan Fire Department', 'Hwy 59, Corrigan, TX.', 1, 'Generator backup.', 1, 1, 1, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', '', 0, 0, 0, '', 0, '', '', '', 'Antenna up 45 feet.'), (44, 76, 'firestation', 'South Polk County Fire Department', 'FM 2610, Ace, TX', 1, 'Generator Backup', 1, 1, 1, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', '', 0, 0, 0, '', 0, '', '', '', 'Antenna up 40 feet.'), (45, 76, 'other', 'VHF Repeater #1', 'Radio Rd. Livingston', 1, 'Generator / Battery', 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', '', 0, 0, 0, '', 1, '147.040', '136.5', 'Plus', 'Antenna up 440 feet.\r\nEcholink enabled.'), (46, 76, 'other', 'VHF Repeater - #2', 'Trinity County', 1, 'Battery', 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', '', 0, 0, 0, '', 1, '145.350', '131.8', 'Minus', 'Antenna up 200 feet.'), (47, 76, 'other', 'Saltgrass UHF', 'Radio Rd. , Livingston,TX.', 1, 'Generator / battery backup.', 1, 0, 1, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', '', 0, 0, 0, '', 1, '443.125', '103.5', 'Plus', 'Saltgrass. Antenna up 440 feet.'), (48, 7, 'eoc', 'Bandera County EOC', '', 1, '', 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', NULL, 0, 0, 0, '', 0, '', '', '', 'Motorola VHF radio with local repeater, talk around and direct channels. HF antenna installation planned by YE 2010'), (49, 7, 'eoc', 'Alternate EOC at County Annex in Lakehills', '', 1, '', 1, 1, 0, 1, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 1, '', NULL, 0, 0, 1, 'Pactor3', 0, '', '', '', 'Motorola VHF Radio with amateur channels'), (50, 7, 'other', 'DEC gear', '', 1, '', 1, 1, 1, 1, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 1, '', NULL, 0, 0, 1, 'Pactor3', 0, '', '', '', 'Has portable VHF/UHF radio that can be taken to either EOC.'), (51, 86, 'other', 'State Operation Center', '', 1, '', 1, 1, 1, 1, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 1, 'aan6etx@winlink.org', NULL, 1, 1, 1, 'Pactor3', 0, '', '', '', 'State RACES and US Army MARS staffing when activated.'), (52, 86, 'eoc', 'The Combined Transportation, Emergency, and Communications Center (CTECC)', '', 1, '', 1, 1, 1, 1, 0, 1, 1, 'W5TQ-10, W5TQ-12', '145.730, 145.07', 1, 1, 0, 0, '', 0, '', 1, 'w5tq-1@winlink.org', NULL, 1, 1, 0, '', 0, '', '', '', ''), (54, 98, 'other', 'N5TW Station', '228 Wind Ridge Cove Georgetown TX 78628', 1, 'Generator/Battery backup', 1, 1, 1, 1, 0, 1, 1, 'N5TW-10, N5TW-12, N5TW-13', '145.610, 145.030, 144.910', 1, 1, 1, 0, '', 0, 'N5TW', 1, 'n5tw-1@winlink.org', '', 1, 1, 1, 'Pactor3', 0, '', '', '', 'N5TW-10/N5TW-13 antenna is a DB-224 up 95 feet. N5TW-12 antenna is a DB-224 up 125 feet.'), (57, 19, 'eoc', 'City of Harlingen Police Department / EOC', '', 1, '', 1, 1, 1, 1, 0, 1, 1, 'AE5R-10', '145.010', 1, 1, 1, 0, '', 0, 'AE5R', 1, 'ae5r-1@winlink.org', NULL, 1, 1, 1, 'Pactor3', 0, '', '', '', 'Duplicate setup in another building.'), (58, 98, 'eoc', 'Cedar Park EOC', '', 1, '', 1, 1, 1, 0, 0, 1, 1, 'W2MN-11', '145.610', 0, 0, 0, 0, '', 0, '', 1, 'w2mn-2@winlink.org', NULL, 1, 1, 0, '', 0, '', '', '', ''), (59, 98, 'firestation', 'Round Rock Firestation #6', '', 1, '', 1, 1, 1, 0, 0, 1, 1, 'KB5TWO-10', '145.610', 0, 0, 0, 0, '', 0, '', 1, 'kb5two-7@winlink.org', NULL, 1, 1, 0, '', 0, '', '', '', ''), (60, 98, 'hospital', 'St. David''s Georgetown Hospital (SDGH)', '', 1, '', 1, 1, 1, 0, 0, 1, 1, 'KD4HNX-10', '145.610', 0, 0, 0, 0, '', 0, '', 1, 'kd4hnx-1@winlink.org', '', 1, 1, 0, '', 0, '', '', '', ''), (61, 98, 'hospital', 'Round Rock Medical Center (RRMC)', '', 1, '', 1, 1, 1, 0, 0, 1, 1, 'KD4HNX-11', '144.910', 0, 0, 0, 0, '', 0, '', 1, 'kd4hnx-4@winlink.org', NULL, 1, 1, 0, '', 0, '', '', '', ''), (62, 98, 'hospital', 'Cedar Park Regional Medical Center (CPRMC)', '', 1, '', 1, 1, 1, 0, 0, 1, 1, 'W2MN-10', '145.610', 0, 0, 0, 0, '', 0, '', 1, 'w2mn-1@winlink.org', NULL, 1, 1, 0, '', 0, '', '', '', ''), (63, 98, 'hospital', 'Scott and White University Medical Center (SWUMC)', '', 1, '', 1, 1, 1, 0, 0, 1, 1, 'NA5BD-11', '145.610', 0, 0, 0, 0, '', 0, '', 1, 'na5bd-2@winlink.org', NULL, 1, 1, 0, '', 0, '', '', '', ''), (64, 98, 'hospital', 'Scott & White Hospital Taylor', '', 1, '', 1, 1, 1, 0, 0, 1, 1, 'N5EXY-10', '144.910', 0, 0, 0, 0, '', 0, '', 1, 'n5exy-2@winlink.org', '', 1, 1, 0, '', 0, '', '', '', ''), (65, 98, 'hospital', 'Seton Medical Center Williamson (SMCW)', '', 1, '', 1, 1, 1, 0, 0, 1, 1, 'NA5BD-10', '144.910', 0, 0, 0, 0, '', 0, '', 1, 'na5bd-3@winlink.org', NULL, 1, 1, 0, '', 0, '', '', '', ''), (66, 98, 'other', 'W9BF-10 RMS Packet Station', '', 0, '', 0, 0, 0, 0, 0, 1, 1, 'W9BF-10', '145.030', 0, 0, 0, 0, '', 0, '', 0, '', NULL, 0, 0, 0, '', 0, '', '', '', ''), (67, 98, 'other', 'KE5RS-10 RMS Packet Station', '', 0, '', 0, 0, 0, 0, 0, 1, 1, 'KE5RS10', '145.730', 0, 0, 0, 0, '', 0, '', 1, 'ke5rs@winlink.org', NULL, 1, 1, 1, 'Pactor1', 0, '', '', '', ''), (68, 86, 'other', 'K5KTF-10 RMS Packet Station', '', 0, '', 0, 0, 0, 0, 0, 1, 1, 'K5KTF-10', '145.610', 0, 0, 0, 0, '', 0, '', 1, 'k5ktf@winlink.org', NULL, 1, 1, 0, '', 0, '', '', '', ''), (69, 16, 'jumpkit', 'HLARC#1 - from W5RME - Marble Falls', '', 1, 'Battery', 1, 1, 1, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 1, '', '', 0, 1, 0, '', 0, '', '', '', ''), (70, 16, 'jumpkit', 'HLARC#2 - from KE5HIR - Burnet', '', 1, 'Battery', 1, 1, 1, 0, 0, 1, 1, '', '', 0, 0, 0, 0, '', 0, '', 1, '', '', 0, 1, 0, '', 0, '', '', '', ''), (71, 16, 'hospital', 'Seton Highland Lakes Hospital - Burnet', '', 1, '', 1, 1, 1, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 1, '', NULL, 0, 1, 0, '', 0, '', '', '', ''), (72, 16, 'hospital', 'Llano Memorial Hospital - Llano', '', 0, '', 1, 1, 1, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 1, '', NULL, 0, 1, 0, '', 0, '', '', '', ''), (73, 16, 'eoc', 'Burnet County Sheriff''s Office', '', 0, '', 1, 1, 1, 0, 0, 1, 1, 'W5RLY-8', '145.030', 0, 0, 0, 0, '', 0, '', 1, 'k5hla-9@winlink.org', NULL, 1, 1, 0, '', 0, '', '', '', ''), (74, 16, 'Other', 'W5RLY-10 RMS Packet station', '', 0, '', 1, 1, 1, 1, 0, 1, 1, 'W5RLY-10', '145.030', 0, 0, 0, 0, '', 0, '', 1, 'w5rly@winlink.org', NULL, 1, 1, 0, '', 0, '', '', '', ''), (75, 19, 'eoc', 'Cameron County EOC', '', 0, '', 1, 1, 1, 1, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', NULL, 0, 0, 0, '', 0, '', '', '', ''), (76, 19, 'eoc', 'City of Brownsville EOC', '', 1, '', 1, 1, 1, 0, 1, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 1, '', NULL, 0, 0, 1, 'Pactor3', 1, '147.040', '', 'Plus', 'Repeater antenna up 450 feet and has battery backup.'), (77, 19, 'other', 'City of Brownsville - repeater 2', '', 1, '', 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', NULL, 0, 0, 0, '', 1, '146.700', '', 'Minus', 'Repeater has 550 ft antenna and diesel generator backup.'), (78, 19, 'other', 'City of Brownsville - digipeater ', '', 1, 'Diesel backup power', 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', NULL, 0, 0, 0, '', 0, '', '', '', 'RGV wide digipeater with antenna up 300 feet.'), (79, 97, 'eoc', 'Willacy County EOC', '', 0, '', 1, 1, 0, 1, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', NULL, 0, 0, 0, '', 0, '', '', '', 'HF and VHF facilities must be brought by volunteering hams.'), (80, 46, 'police', 'Port Arthur Police Department', '', 0, '', 1, 1, 1, 1, 0, 1, 1, 'KC5YSM-10', '145.050', 0, 0, 0, 0, '', 0, '', 0, '', NULL, 0, 0, 0, '', 1, '', '', '', 'Need repeater information. Winlink client status?'), (81, 46, 'other', 'JARC', '', 0, '', 1, 1, 0, 1, 0, 1, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', NULL, 0, 0, 0, '', 1, '', '', '', 'Info on RMS Packet and repeater needed. Winlink client status?'), (82, 45, 'mobile', '"Horse trailer" at Buna sub-courthouse', '', 0, '', 1, 1, 0, 1, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', '', 0, 0, 0, '', 0, '', '', '', 'Has HTs on public service frequencies.'), (83, 73, 'other', 'None', '', 0, 'No amateur equipment in Newton county.', 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', NULL, 0, 0, 0, '', 0, '', '', '', ''), (84, 80, 'other', 'K5QE-10 RMS Packet station', '', 0, '', 0, 0, 0, 0, 0, 1, 1, 'K5QE-10', '145.050', 0, 0, 0, 0, '', 0, '', 0, '', NULL, 0, 0, 0, '', 0, '', '', '', ''), (85, 80, 'other', 'KA5BQM-10 RMS Packet station', '', 0, '', 0, 0, 0, 0, 0, 1, 1, 'KA5BQM-10', '145.010', 0, 0, 0, 0, '', 0, '', 0, '', NULL, 0, 0, 0, '', 0, '', '', '', ''), (86, 75, 'other', 'Orange Chapter of the American Red Cross', '3901 IH-10 East Orange, TX 77630', 1, '', 1, 1, 0, 1, 0, 1, 1, 'N5MTX-11', '145.010', 0, 0, 0, 0, '', 0, '', 1, 'w5nd@winlink.org', '', 1, 0, 0, '', 0, '', '', '', 'Equipment owned by the Orange Amateur Radio Club'), (87, 75, 'hospital', 'Memorial Hermann Baptist Orange Hospital', '608 Strickland Dr. Orange, TX 77630', 1, '', 1, 1, 0, 1, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', '', 0, 0, 0, '', 1, '147.180', '103.5', 'Plus', 'Equipment owned by the Orange Amateur Radio Club. Repeater is backup to regular 147.180 repeater.'), (88, 75, 'other', 'Orange County Road and Bridge', '2600 Lawrence Road Orange, TX 77630', 1, '', 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', '', 0, 0, 0, '', 1, '147.180', '103.5', 'Plus', 'Equipment owned by the Orange Amateur Radio Club. W5ND Repeater has generator backup.'), (89, 75, 'mobile', 'Orange County Emergency Management', '123 South 6th Street Orange, TX 77630', 1, '', 1, 1, 1, 1, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', '', 0, 0, 0, '', 0, '', '', '', 'Antenna / supports portable.'), (90, 75, 'mobile', 'Orange County Emergency Management - Mobile Command Unit', '123 South 6th Street Orange, TX 77630', 1, '', 1, 1, 1, 1, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', '', 0, 0, 0, '', 0, '', '', '', 'HF PACTOR 3 Winlink installation planned for by 2QTR 2011'), (91, 75, 'other', 'Dupont - Sabine River Works', 'FM 1006 - Bldg 3-F Orange Texas 77630', 0, '', 1, 1, 0, 1, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', '', 0, 0, 0, '', 1, '147.060', '103.5', 'Plus', 'Winlink HF (PACTOR 3) and VHF Packet and Telnet waiting to be installed.\r\n2 Meter repeater AA5P.'), (92, 18, 'hospital', 'Port Lavaca Memorial Medical Center', '', 0, '', 1, 1, 1, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 1, '', NULL, 0, 1, 0, '', 0, '', '', '', ''), (93, 24, 'hospital', 'Cuero Hospital', '', 0, '', 1, 1, 1, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 1, '', NULL, 0, 1, 0, '', 0, '', '', '', ''), (94, 44, 'hospital', 'Jackson County Medical Center - Edna', '', 0, '', 1, 1, 1, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 1, '', NULL, 0, 1, 0, '', 0, '', '', '', ''), (95, 57, 'hospital', 'Lavaca County Hospital - Halletsville', '', 0, '', 1, 1, 1, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 1, '', NULL, 0, 1, 0, '', 0, '', '', '', ''), (96, 57, 'hospital', 'Yoakum Medical Center', '', 0, '', 1, 1, 1, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 1, '', NULL, 0, 1, 0, '', 0, '', '', '', ''), (97, 91, 'hospital', 'Citizen''s Medical Center - Victoria', '', 0, '', 1, 1, 1, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 1, '', NULL, 0, 1, 0, '', 0, '', '', '', ''), (98, 91, 'hospital', 'De Tar Hospital North - Victoria', '', 0, '', 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 1, '', NULL, 0, 1, 0, '', 0, '', '', '', ''), (99, 91, 'hospital', 'De Tar Hospital South - Victoria', '', 0, '', 1, 1, 1, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 1, '', NULL, 0, 1, 0, '', 0, '', '', '', ''), (100, 91, 'eoc', 'Victoria City/County EOC', '', 0, '', 1, 1, 1, 0, 0, 1, 1, 'WA5VBP-10', '145.010', 1, 0, 0, 0, '', 0, '', 1, 'wa5vbp@winlink.org', '', 1, 1, 1, 'Pactor3', 0, '', '', '', ''), (101, 18, 'other', 'Dupont? Port Lavaca', '', 0, 'Know there is a significant facility there but do not know name or details...', 1, 1, 1, 1, 0, 1, 1, 'W5KTC-10', '145.010', 0, 0, 0, 0, '', 0, '', 1, '', NULL, 1, 1, 0, '', 0, '', '', '', ''), (102, 57, 'hospital', 'Warm Springs Rehab Center (Near Gonzales)', '', 0, '', 1, 1, 1, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 1, '', NULL, 0, 1, 0, '', 0, '', '', '', ''), (103, 10, 'eoc', 'Bexar County EOC', '', 1, '', 1, 1, 0, 1, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 1, '', NULL, 0, 1, 1, 'Pactor3', 0, '', '', '', ''), (104, 10, 'Other', 'American Red Cross Office - San Antonio', '', 0, '', 1, 1, 1, 0, 0, 1, 1, 'AI5RC-10', '145.090', 0, 0, 0, 0, '', 0, '', 0, '', NULL, 0, 0, 0, '', 0, '', '', '', 'Winlink client too?'), (105, 35, 'eoc', 'Guadalupe County EOC', '', 0, '', 1, 1, 0, 1, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 1, '', NULL, 0, 1, 1, 'Pactor3', 0, '', '', '', ''), (106, 35, 'Other', 'W5SEG Station', '', 0, '', 1, 1, 1, 1, 0, 1, 1, 'W5SEG-10, W5SEG-10', '145.010, 145.090', 1, 1, 1, 0, 'W5SEG', 0, 'W5SEG', 1, 'w5seg@winlink.org', NULL, 1, 1, 1, 'Pactor3', 0, '', '', '', ''), (107, 22, 'eoc', 'Comal County EOC', '', 0, '', 1, 1, 0, 1, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 1, '', NULL, 0, 1, 0, '', 0, '', '', '', ''), (108, 5, 'eoc', 'Atascosa County EOC', '711 Broadway Jourdanton, Texas', 1, 'battery backup and emergency generator', 1, 1, 1, 1, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 1, 'n5tbs@winlink.org', '', 1, 1, 1, 'Pactor3', 1, '145.430', '100.0', 'Minus', 'alternate repeater 145.210 -.600 tone 162.2\r\nwinlink RMS n5tbs-10 145.090'), (109, 31, 'eoc', 'Galveston County OEM Continued', '', 1, '', 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', '', 0, 0, 0, '', 1, '442.225', '131.8', 'Plus', ''), (110, 40, 'hospital', 'Christus St. Catherine Hospital', '', 1, 'Contact: Bruce Smith WA5DVO', 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', NULL, 0, 0, 0, '', 0, '', '', '', '2nd Comet GP6 antenna installed but coax not run yet. Other radio equipment provided by volunteers when called out.'), (111, 39, 'eoc', 'City of La Porte', '', 0, 'WX5LP', 1, 1, 1, 1, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', NULL, 0, 0, 0, '', 0, '', '', '', '3 VHF/UHF radio positions each with dual band / dual receive radios.'), (112, 39, 'eoc', 'City of Pasadena', '', 0, 'W5PAS', 1, 1, 1, 1, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', NULL, 0, 0, 0, '', 0, '', '', '', '4 radio desks: 2 VHF/UHF, 1 VHF and 1 HF (with legal limit amplifier).'), (113, 39, 'mobile', 'Port of Houston Authority', '', 0, 'Tactical call: Port', 1, 1, 1, 1, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', '', 0, 0, 0, '', 0, '', '', '', 'Installed in mobile command Center.'), (114, 31, 'other', 'National Weather Service Houston / Galveston', '1353 FM 646, League City, TX 77573', 1, 'Co-located with Galveston County OEM.', 1, 1, 1, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', '', 0, 0, 0, '', 0, '', '', '', ''), (115, 5, 'hospital', 'South Texas Regional Hospital', '1905 E Highway 97 Jourdanton Texas', 1, 'Not sure radio is connected to power point that is on backup but will check. Radio is TM-V7E. Radio room to be moved near Emergency room area where Satellite phone is located.', 1, 1, 1, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', '', 0, 0, 0, '', 0, '', '', '', 'We currently have a ham to operate this location at times of need from our ARES group in Atascosa County.'), (116, 93, 'other', 'Ken Miller', 'Hockley, Tx', 1, 'EC Waller County ARES', 1, 1, 1, 1, 0, 1, 1, 'W5KAM-10', '145.030', 1, 1, 0, 0, '', 0, '', 1, 'w5kam@aol.com', 'w5kam@winlink.org', 1, 1, 1, 'WINMOR', 1, '146.72', '123.0', 'Minus', 'Waller County ARES back up frequency is 147.38 (tone 123.0)\r\nSimplex Frequency is 146.46'), (117, 93, 'other', 'James Sitton', 'Waller, Tx', 1, 'AEC Waller County ARES', 1, 1, 1, 0, 0, 1, 1, 'KD5JBT-10', '145.030', 0, 0, 0, 0, '', 0, '', 1, 'kd5jbt@haneyfeed.com', 'kd5jbt@winlink.org', 1, 1, 0, '', 0, '', '', '', ''), (118, 93, 'other', 'Christine Smith', 'Waller County', 1, 'DEC Waller County', 1, 1, 1, 1, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 1, 'n5cas @winlink.org', '', 1, 1, 0, '', 0, '', '', '', ''), (119, 82, 'other', 'WB5HZM', '301 Imperial Circle', 1, 'WB5HZM QTH on Lake Livingston. Local weather station at http://www.wunderground.com/swf/Rapid_Fire.swf?units=english&station=KTXCOLDS1', 1, 1, 1, 1, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', '', 0, 0, 0, '', 0, '', '', '', ''), (120, 82, 'Other', 'Sheriff Department', 'Cedar Ave.', 1, 'VHF Radio located in Dispatcher''s office', 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', '', 0, 0, 0, '', 0, '', '', '', '2 Meter antenna located on roof. Can reach 146.940 repeater in Lufkin.'), (121, 67, 'eoc', 'McCulloch County Sheriff''s Department', '300 W. Main St., Brady, TX 76825', 1, 'WA5HOT/EOC', 1, 1, 1, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', '', 0, 0, 0, '', 0, '', '', '', ''), (122, 67, 'hospital', 'Heart of Texas Memorial Hospital', '2008 Old Nine Rd., Brady, TX 76825', 1, 'WA5HOT/ER', 1, 1, 1, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', '', 0, 0, 0, '', 0, '', '', '', ''), (123, 67, 'eoc', 'McCulloch County Sheriff''s Department', '300 W. Main St., Brady, TX 76825', 1, 'WA5HOT/EOC', 1, 1, 1, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', '', 0, 0, 0, '', 0, '', '', '', ''), (124, 16, 'eoc', 'Burnet County EOC', 'County Courthouse basement', 1, 'ARES people should be NIMS compliant to work there (100, 200, 700, 800 prefer also 300, 400)', 1, 1, 1, 1, 0, 1, 1, 'KE5OJA', '145.030', 0, 0, 0, 0, '', 0, '', 0, '', '', 0, 0, 0, '', 0, '', '', '', ''), (125, 98, 'other', 'WCARC Repeater', 'Georgetown, TX', 1, 'Battery backup', 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', '', 0, 0, 0, '', 1, '146.640', '162.2', 'Minus', 'WC-ARES primary Repeater'), (126, 91, 'mobile', 'WA5VBP Communications Trailer', '', 1, '', 1, 1, 1, 1, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 1, '', '', 0, 1, 1, 'Pactor3', 0, '', '', '', 'Property of John Wagner WA5VBP'), (127, 91, 'other', 'W5DSC Repeater Site', 'Bass Lane and Lower Mission Valley Road', 0, '', 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', '', 0, 0, 0, '', 1, '145.190', '103.5', 'Minus', '100W antenna at 450 feet'), (128, 83, 'eoc', 'Aransas Pass City Hall EOC', '600 W. Cleveland Blvd., Aransas Pass, TX 78336-3638', 1, '', 1, 1, 1, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', '', 0, 0, 0, '', 0, '', '', '', 'YAESU FT-8800, YAESU VX-8R, Diamond X-50A (2m/70 cm) at 35 ft., 120 VAC to 12 VDC supply,'), (129, 4, 'eoc', 'Public Safety Center (City of Rockport and Aransas County Joint Center)', '714 E. Concho St., Rockport, TX', 1, 'Contact is Ms Lee Zapata, 714 E. Concho St., Rockport, TX 78382 Tel. (361) 790-1140', 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', '', 0, 0, 0, '', 0, '', '', '', 'ICOM IC 2200H connected to VHF Vertical approx. 20 ft. above ground. Manual in console drawer. Also at position is ICOM Marine Radio'), (130, 76, 'other', 'Repeater #3', 'FM 350 South, Livingston, TX', 0, '', 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', '', 0, 0, 0, '', 1, '147.160', '103.5', 'Plus', 'Antenna 150 ft.'), (131, 76, 'other', 'Repeater #4', 'FM 350 South, Livingston, TX', 0, '', 1, 0, 1, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', '', 0, 0, 0, '', 1, '442.300', '146.2', '', 'Antenna 150 ft.'), (132, 19, 'eoc', 'San Benito Judges Court/EOC', '', 1, 'All equipment is in the hands of the AECs', 1, 1, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, '', 0, '', 0, '', '', 0, 0, 0, '', 0, '', '', '', ''); -- -------------------------------------------------------- -- -- Table structure for table `person` -- CREATE TABLE IF NOT EXISTS `person` ( `person_id` int(11) NOT NULL auto_increment, `firstname` varchar(35) NOT NULL, `middlename` varchar(35) default NULL, `surname` varchar(35) NOT NULL, `address` varchar(100) default NULL, `city` varchar(35) default NULL, `state` varchar(2) default 'TX', `zip` varchar(10) default NULL, `homephone` varchar(35) default NULL, `workphone` varchar(35) default NULL, `cellphone` varchar(35) default NULL, `email` varchar(64) NOT NULL, `callsign` varchar(10) NOT NULL, `licenseclass` varchar(10) default NULL, `districtid` int(11) NOT NULL COMMENT 'ref to district table', `countyid` int(11) NOT NULL COMMENT 'ref to county table', `titleid` int(11) NOT NULL COMMENT 'ref to title table', `updated` datetime NOT NULL COMMENT 'date and time last updated', `emergencypower` tinyint(1) default '0', `comments` varchar(100) default NULL, `multiplecounties` tinyint(1) NOT NULL default '0', PRIMARY KEY (`person_id`), KEY `fk_districtid` (`districtid`), KEY `fk_countyid` (`countyid`), KEY `fk_titleid` (`titleid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='individual person detail profile' AUTO_INCREMENT=414 ; -- -- Dumping data for table `person` -- INSERT INTO `person` (`person_id`, `firstname`, `middlename`, `surname`, `address`, `city`, `state`, `zip`, `homephone`, `workphone`, `cellphone`, `email`, `callsign`, `licenseclass`, `districtid`, `countyid`, `titleid`, `updated`, `emergencypower`, `comments`, `multiplecounties`) VALUES (171, 'Judy', '', 'Whiteside', '228 Wind Ridge Cove', 'Georgetown', 'TX', '78628', '512-863-6865', NULL, NULL, 'jkw@ecpi.com', 'N5TW/XYL', 'Technician', 7, 98, 11, '2011-01-14 14:16:07', 0, 'I create and support the Information Vault web pages.', 0), (172, 'Paul', 'Zane', 'Gilbert', '1209 Doris Ln', 'Cedar Park', 'TX', '78613', '512-260-9365', '512-506-5141', '512-733-3035', 'ke5zw@wt.net', 'KE5ZW', 'Extra', 7, 98, 8, '2011-01-22 19:47:10', 1, 'TxDOT Radio Ops, Public Safety Radio Capability', 0), (173, 'Ben', '', 'Worrell', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'benw@cvctx.com', 'NE5B', NULL, 7, 28, 12, '2010-04-10 10:50:00', 0, NULL, 0), (174, 'Brian', '', 'Cater', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'TxLawMan@aol.com', 'KC5YSM', NULL, 9, 1, 2, '2010-04-10 10:50:00', 0, NULL, 0), (175, 'Christine', '', 'Smith', '26895 Riley Road', 'Waller', 'TX', '77484-6139', '936-931-1539', '832-731-6369', '832-731-6369', 'n5cas@earthlink.net', 'N5CAS', 'General', 1, 93, 2, '2011-01-13 12:07:58', 1, NULL, 0), (176, 'Jennifer', '', 'Wiginton', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'wiginton_j@hotmail.com', 'WW5JLW', NULL, 5, 1, 2, '2010-04-10 10:50:00', 0, NULL, 0), (177, 'Joe', '', 'Fisher', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'jfcc@grandecom.net', 'K5EJL', NULL, 7, 86, 12, '2010-04-10 10:50:00', 0, NULL, 0), (178, 'Michael', '', 'Miles', '904 Sherwood Rd.', 'Lufkin', 'TX', '75904-4567', NULL, NULL, NULL, 'wd5efy@arrl.net', 'WD5EFY', 'General', 2, 3, 2, '2011-01-13 10:48:04', 1, NULL, 0), (179, 'Rik', '', 'Chapman', 'POB 2598', 'Georgetown', 'TX', '78627', NULL, NULL, '512-845-1199', 'drrik@ecpi.com', 'K5RIK', 'Extra', 8, 16, 2, '2011-01-14 16:39:44', 1, NULL, 0), (180, 'Robert', 'Eric "Ric"', 'Wade', '68 Lakewood Dr', 'Laguna Vista', 'TX', '78578', '956-943-4054', '956-364-7499', '956-346-2161', 'k5rew@arrl.net', 'K5REW', 'Advanced', 15, 19, 2, '2011-01-18 19:06:59', 1, 'Dept Homleand Sec. Callsign NCS-036\r\nNavy MARS Callsign NNN0EYT', 0), (181, 'Allan', 'D.', 'Hill', '1907 Mound Lake Dr.', 'Richmond', 'TX', '77406-6981', '281-762-3564', NULL, '713-882-6355', 'nq5b@msn.com', 'NQ5B', 'Extra', 1, 29, 3, '2011-01-16 21:16:49', 1, NULL, 0), (182, 'Alton', '', 'Feeney', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'ajfeeney@2fastmail.com', 'KT4KL', NULL, 6, 7, 3, '2010-04-10 10:50:00', 0, NULL, 0), (183, 'Travis', 'Andy', 'Treat', '209 Winter Haven Lane', 'Brownsville', 'TX', '78526', NULL, NULL, '956 371 3609', 'kf0mp@kf0mp.com', 'KF0MP', 'Extra', 15, 19, 3, '2011-01-12 17:35:37', 1, NULL, 0), (185, 'David', '', 'McGilbery', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'mcgilbdd@sbcglobal.net', 'K5DDM', NULL, 9, 45, 3, '2010-04-10 10:50:00', 0, NULL, 0), (186, 'David', '', 'Warren', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'warrend@cvctx.com', 'KD5GJF', NULL, 7, 28, 12, '2010-04-10 10:50:00', 0, NULL, 0), (187, 'David', '', 'Wisdom', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'w5drw@netzero.net', 'W5DRW', NULL, 6, 90, 3, '2010-04-10 10:50:00', 0, NULL, 0), (188, 'Don', '', 'Dudley', '12002 Black Angus Dr', 'Austin', 'TX', '78727', NULL, '512-936-0766', '512-680-0498', 'ac5yk@arrl.net', 'AC5YK', 'Extra', 7, 86, 2, '2011-01-18 13:01:16', 1, NULL, 0), (189, 'Don', '', 'Kirchner', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'w5dk@w5dk.com', 'W5DK', NULL, 12, 22, 3, '2010-04-10 10:50:00', 0, NULL, 0), (190, 'Franklin', '', 'Stewart', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'fstewart93@yahoo.com', 'KD5WRO', NULL, 5, 71, 3, '2010-04-10 10:50:00', 0, NULL, 0), (191, 'Gil', '', 'Jones', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'CaptainJustice@gmail.com', 'KA5GIL', NULL, 8, 16, 3, '2010-04-10 10:50:00', 0, NULL, 0), (192, 'Greg', '', 'Burkett', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'gburkett@consolidated.net', 'KE5JQV', NULL, 2, 3, 3, '2010-04-10 10:50:00', 0, NULL, 0), (193, 'J.', 'Mark', 'Garton', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'W4ZFH@yahoo.com', 'W4ZFH', NULL, 5, 13, 3, '2010-04-10 10:50:00', 0, NULL, 0), (194, 'James', '', 'Allen', '143 Papawai Rd.', 'Bastrop', 'TX', '78602', NULL, NULL, '512-845-4185', 'jmetcon@hotmail.com', 'KE5AMB', 'Extra', 7, 8, 3, '2011-01-23 18:15:28', 0, 'Com-L ', 0), (195, 'James', '', 'Bomer', '208 FM 3024', 'Mathis', 'TX', '78368', '3614495990', 'same', 'same', 'w5im@arrl.net', 'W5IM', 'Extra', 4, 61, 3, '2011-01-12 18:54:06', 1, NULL, 0), (196, 'Jesse', '', 'Royall', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'w5los@yahoo.com', 'W5LOS', NULL, 4, 9, 3, '2010-04-10 10:50:00', 0, NULL, 0), (197, 'Jim', '', 'Dear', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'jim@w5log.org', 'W5LOG', NULL, 8, 62, 12, '2010-04-10 10:50:00', 0, NULL, 0), (198, 'Jim', '', 'Mastrogiovanni', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'vmastro@gvtc.com', 'KK5RZ', NULL, 12, 50, 3, '2010-04-10 10:50:00', 0, NULL, 0), (199, 'Ernest', '', 'Reich', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'ereich@wireweb.net', 'W5FQA', NULL, 6, 1, 2, '2010-04-10 10:50:00', 0, NULL, 0), (200, 'Jeff', '', 'Walter', '1215 Park Lane', 'Katy', 'TX', '77450', NULL, '713-461-3404', '281-467-8595', 'jawalter6@yahoo.com', 'KE5FGA', 'General', 14, 38, 2, '2011-01-16 09:45:13', 0, NULL, 0), (201, 'John', '', 'Taylor', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'john@taylorent.com', 'KE5HAM', NULL, 10, 1, 2, '2010-04-10 10:50:00', 0, NULL, 0), (202, 'Mark', '', 'Mireles', '4713 Gayle', 'CC', 'TX', '78413', '361 855-9634', '361 961-5982', '361 946-2340', 'AD5CA@Grandecom.net', 'AD5CA', 'Extra', 4, 74, 2, '2011-01-13 05:27:10', 1, NULL, 0), (203, 'Shane', '', 'O''Neal', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'shane@ns5d.com', 'NS5D', NULL, 12, 1, 12, '2010-04-10 10:50:00', 0, NULL, 0), (204, 'Butch', '', 'Johnson', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'mickeym1@peoplepc.com', 'KA5HRF', NULL, 7, 58, 3, '2010-04-10 10:50:00', 0, NULL, 0), (206, 'Charles', '', 'Allison', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'charles@atcweb.com', 'WB5IZD', NULL, 4, 55, 3, '2010-04-10 10:50:00', 0, NULL, 0), (207, 'Clinton', 'D.', 'Wynne', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'n5tbs@peoplepc.com', 'N5TBS', NULL, 12, 5, 3, '2010-04-10 10:50:00', 0, NULL, 0), (208, 'Curtis', '', 'Tallman', '1415 Kinston Drive', 'League City', 'TX', '77573', '281-534-6222', '281-226-6743', '281-433-8561', 'cgtallman@earthlink.net', 'WB5UZZ', 'Extra', 1, 31, 3, '2011-01-17 20:10:02', 1, NULL, 0), (210, 'David', '', 'Sorrel', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'dsorrel@yahoo.com', 'K5MDS', NULL, 10, 96, 3, '2010-04-10 10:50:00', 0, NULL, 0), (211, 'George', '', 'Fletcher', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'gfletcher5@att.net', 'AD5CQ', NULL, 14, 39, 3, '2010-04-10 10:50:00', 0, NULL, 0), (212, 'Jake', '', 'Creamer', '9973 S US Hwy 183', 'Lockhart', 'TX', '78644', NULL, '512-974-0883', '512-644-2195', 'k5gwc@arrl.net', 'K5GWC', 'General', 7, 17, 3, '2011-01-21 20:32:57', 1, NULL, 1), (214, 'Jim', '', 'Russell', '1250 fm 3405', 'Georgetown', 'TX', '78633', NULL, '512-726-0327', '512-563-2564', 'jim@russell-texas.com', 'NQ5L', 'Extra', 7, 98, 9, '2011-01-23 15:34:46', 1, NULL, 0), (215, 'Joe', '', 'Connell', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'jths_68@yahoo.com', 'KB5DTS', NULL, 2, 92, 3, '2010-04-10 10:50:00', 0, NULL, 0), (216, 'John', '', 'Letney', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'ares@laredohams.com', 'KE5CVT', NULL, 13, 95, 3, '2010-04-10 10:50:00', 0, NULL, 0), (217, 'Ken', '', 'Miller', '27285 Hard Road', 'Hockley', 'TX', '77447', '936-931-2724', NULL, '713-826-1049', 'w5kam@aol.com', 'W5KAM', 'General', 1, 93, 3, '2011-01-24 09:02:24', 1, NULL, 0), (218, 'Rick', '', 'Melcer', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'rmelcer@classicnet.net', 'N5KAO', NULL, 8, 67, 3, '2010-04-10 10:50:00', 0, NULL, 0), (219, 'Robbie', '', 'Robertson', '1318 N. Milam Street', 'Seguin', 'TX', '78155', NULL, NULL, NULL, 'w5seg@arrl.net', 'W5SEG', 'Advanced', 12, 35, 12, '2011-01-23 16:32:11', 1, NULL, 0), (220, 'Robert', 'David', 'Herron', '285 White Forest Ln.', 'Livingston', 'TX', '77351', NULL, NULL, '936-327-0838', 'rherron@shawus.com', 'KD5UAD', 'General', 2, 76, 3, '2011-01-17 22:58:36', 1, NULL, 0), (221, 'Rocky', '', 'Wilson', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'rockygwilson@hotmail.com', 'N5MTX', NULL, 9, 75, 3, '2010-04-10 10:50:00', 0, NULL, 0), (222, 'Rodney', '', 'Baker', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'w5dy@arrl.net', 'W5DY', NULL, 10, 33, 3, '2010-04-10 10:50:00', 0, NULL, 0), (223, 'Steven', '', 'Colburn', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'tscolburn@eastex.net', 'WB5HZM', NULL, 2, 82, 3, '2010-04-10 10:50:00', 0, NULL, 0), (224, 'Steven', '', 'Pituch', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'stevenpituch@gmail.com', 'W2MY', NULL, 4, 74, 3, '2010-04-10 10:50:00', 0, NULL, 0), (225, 'Terry', '', 'Bowersmith', '5208 Camden Ln.', 'Pearland', 'TX', '77584', 'n/a', 'n/a', '7134105908', 'sarge43@att.net', 'W5SRG', 'General', 1, 12, 3, '2011-01-17 23:03:49', 1, NULL, 0), (226, 'Tom', '', 'Hargrave', '122 Sea View Drive', 'Aransas Pass', 'TX', '7836-5806', '361-758-6991', 'n/a', '361-332-9231', 'tomh@sprynet.com', 'K5BV', 'Extra', 4, 83, 3, '2011-01-17 16:48:43', 1, 'Home FAX 361-758-0867', 1), (227, 'Tommy', '', 'Hayes', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'n5pjy@hotmail.com', 'N5PJY', NULL, 1, 72, 12, '2010-04-10 10:50:00', 0, NULL, 0), (228, 'Tony', '', 'Kirk', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'tony@centex.net', 'KT5UT', NULL, 8, 84, 3, '2010-04-10 10:50:00', 0, NULL, 0), (229, 'Tootie', '', 'Heintschel', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'kc5hvt@gt.rr.com', 'KC5HVT', NULL, 9, 46, 3, '2010-04-10 10:50:00', 0, NULL, 0), (230, 'Walter', 'B.', 'Hock', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'kk5lo@arrl.net', 'KK5LO', NULL, 6, 69, 3, '2010-04-10 10:50:00', 0, NULL, 0), (231, 'Tom', '', 'Whiteside', '228 Wind Ridge Cove', 'Georgetown', 'TX', '78628', '512-863-6865', NULL, '512-924-1573', 'tomw@ecpi.com', 'N5TW', 'Extra', 7, 98, 1, '2011-01-11 17:24:40', 1, NULL, 0), (232, 'Dallas', '', 'Mellichamp', '2008 Lantana Dr.', 'Round Rock', 'TX', '78664', '512-255-1047', '512-228-5463', '512-560-9074', 'mylastname@yahoo.com', 'KD4HNX', 'Extra', 7, 98, 10, '2011-01-12 18:44:00', 0, 'Pager: 512-307-0911', 0), (233, 'Sidney', 'James', 'Sherwood III', 'P.O. Box 55941 / 9215 Bronco', 'Houston', 'TX', '77255-5941', '713 304-0149', NULL, '713 304-0149', 'n5zkd@sbcglobal.net', 'N5ZKD', 'General', 14, 38, 3, '2011-01-16 21:13:04', 1, NULL, 0), (234, 'Al', '', 'Kirchner', '3009 Parker Dr', 'Georgetown', 'TX', '78628', '(512) 868-6391', NULL, '(512) 630-1756', 'agkirchner@verizon.net', 'KE5OIZ', 'General', 7, 98, 3, '2011-01-17 15:20:54', 1, NULL, 0), (235, 'Van', 'L', 'Sims', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'vanandcindy@excite.com', 'N5RZQ', NULL, 2, 43, 3, '2010-07-05 23:43:48', 0, NULL, 0), (237, 'Andrew', '', 'Littlejohn', '713 W 8th', 'Taylor', 'TX', '76574', '512-352-8212', '512-671-2204', '512-633-7412', 'adlittle@yahoo.com', 'W5ROX', 'Extra', 7, 98, 5, '2011-01-12 16:38:07', 1, NULL, 0), (238, 'Howard', 'B.', 'Watson Jr.', '6501 N. 33rd St', 'McAllen', 'TX', '78504', NULL, NULL, NULL, 'hwatson@rgv.rr.com', 'N3TNQ', 'Extra', 3, 42, 3, '2011-01-20 18:14:57', 0, NULL, 0), (239, 'David', '', 'Dodge', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'nv5c@sbcglobal.net', 'NV5C', NULL, 10, 24, 3, '2010-07-29 10:51:44', 0, NULL, 0), (240, 'Robert', 'A.', 'Rodriguez', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'bobrod@flash.net', 'K5AUW', NULL, 12, 10, 3, '2010-07-31 18:45:17', 0, NULL, 0), (241, 'Bryce', '', 'Weathersby', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'ke5kfd@yahoo.com', 'KE5KFD', NULL, 9, 36, 3, '2010-08-02 12:32:17', 0, NULL, 0), (242, 'Frank', '', 'Aguilar', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'frank@faguilar.com', 'N5SSH', NULL, 13, 1, 2, '2010-08-03 15:05:25', 0, NULL, 0), (243, 'Al', '', 'Andrew', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'baal@sbcglobal.net', 'N5WWS', NULL, 1, 60, 3, '2010-08-03 15:05:25', 0, NULL, 0), (244, 'Richard', 'E.', 'Driscoll Jr.', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'lloscirdjr@sbcglobal.net', 'KD5URB', NULL, 14, 2, 6, '2010-08-07 20:24:45', 0, NULL, 0), (245, 'Toby', '', 'Driscoll', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'n5sim@rgv.rr.com', 'N5SIM', NULL, 3, 1, 2, '2010-08-09 16:36:02', 0, NULL, 0), (246, 'Tommy', '', 'Hargrove', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'ab5as@arrl.net', 'AB5AS', NULL, 10, 18, 3, '2010-08-10 18:11:55', 0, NULL, 0), (247, 'Louis', '', 'Upton', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'k5stx@arrl.net', 'K5STX', NULL, 12, 35, 12, '2010-08-15 11:28:54', 0, NULL, 0), (248, 'Bill', '', 'Rimmer', '10611 Linecamp', 'Houston', 'TX', '77064', NULL, '281-341-4565', '', 'n5lyg@n5lyg.org', 'N5LYG', 'Extra', 14, 38, 13, '2011-01-18 10:30:54', 1, 'text: 2817330705@vtext.com', 0), (249, 'Charlie', '', 'Matthew', '2210 W. Dallas St. #242', 'Houston', 'TX', '77019', '713-498-9802', NULL, '713-498-9802', 'n0xfd@yahoo.com', 'N0XFD', 'General', 14, 40, 12, '2011-01-17 19:36:11', 0, 'Greater Houston Red Cross (GHAC) - DST (Disaster Services Technology) Volunteer Lead', 0), (250, 'Kerry', 'N', 'Mallory', '8215 Leader St.', 'Houston', 'TX', '77036', '281-686-8195', '713-664-5555', '281-686-8195', 'kerry@lse-inc.com', 'AE5JY', 'Extra', 14, 40, 3, '2011-01-12 20:44:02', 1, NULL, 0), (251, 'Michael', 'Alan', 'Urich', '9807 Oakmont', 'La Porte', 'TX', '77571', '832.315.5284', '281.867.9415', '281.415.6609', 'mike@ka5cvh.com', 'KA5CVH', 'General', 14, 39, 12, '2011-01-18 16:19:55', 1, 'ARRL - STX - APIC', 0), (253, 'Skip', '', 'Kwasneski', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'skipkwas@att.net', 'KW5AS', NULL, 10, 91, 3, '2010-10-02 13:12:22', 0, NULL, 0), (254, 'Brad', '', 'Davis', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'braddavis@austin.rr.com', 'NA5BD', NULL, 7, 98, 12, '2010-10-03 15:23:47', 0, NULL, 0), (255, 'David', '', 'Green', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'btbdeg@yahoo.com', 'KE5TZW', NULL, 14, 37, 3, '2010-10-04 16:36:23', 0, NULL, 0), (256, 'Randall', '', 'Leftwich', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'rwleftwich@aol.com', 'KE5YLY', NULL, 9, 46, 12, '2010-10-07 16:38:21', 0, NULL, 0), (257, 'George', '', 'Maldonado', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'N5umj@Hotmail.com', 'N5UMJ', NULL, 13, 66, 3, '2010-10-08 16:37:31', 0, NULL, 0), (258, 'George', '', 'Maldonado', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'N5umjegt@yahoo.com', 'N5UMJ', NULL, 13, 66, 3, '2010-10-17 23:04:57', 0, NULL, 0), (259, 'andrew', '', 'wood', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'kc5djt@yahoo.com', 'KC5DJT', NULL, 7, 86, 12, '2010-11-07 16:55:32', 0, NULL, 0), (260, 'Jay', '', 'Miller', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'jayw5whn@gmail.com', 'W5WHN', NULL, 16, 2, 11, '2010-11-11 20:57:56', 0, NULL, 0), (261, 'michael', 'gene', 'manshack', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'a5og@gt.rr.com', 'AD5OG', NULL, 9, 75, 13, '2010-11-28 23:29:56', 0, NULL, 0), (262, 'Rud', '', 'Merriam', '3 Biscay Ct', 'The Woodlands', 'TX', '77381', NULL, NULL, '832-367-3581', 'k5rud@arrl.net', 'K5RUD', 'Extra', 1, 72, 3, '2011-01-12 17:12:39', 1, NULL, 0), (263, 'Bill', '', 'Simpson', NULL, NULL, 'TX', NULL, NULL, NULL, NULL, 'n5ya@n5ya.com', 'N5YA', NULL, 9, 80, 3, '2011-01-04 09:03:05', 0, NULL, 0), (264, 'Royce', 'Daniel', 'Nickerson', '3366 SH 19 #50', 'Huntsville', 'TX', '77320', '661-720-1023', NULL, '661-229-7148', 'texnlorine@juno.com', 'WR5TX', 'Extra', 2, 87, 3, '2011-01-19 17:25:51', 0, NULL, 0), (266, 'samuel', 'e', 'layne', '16065 orange dr', 'harlingen', 'TX', '78552', '2104014135', '2104014135', '9565363069', 'kg4cnc@yahoo.com', 'KG4CNC', 'General', 15, 19, 12, '2011-01-12 18:42:07', 1, '', 0), (267, 'David', '', 'Woolweaver', '929 S Stuart Place Raod', 'Harlingen', 'TX', '78552', '956-425-3128', '956-425-7744', '', 'k5rav@arrl.org', 'K5RAV', 'General', 15, 19, 11, '2011-01-14 16:28:21', 1, '', 0), (268, 'Ray', '', 'McLaughlin', '214 e 6th street', 'Los Fresnos', 'TX', '78566', '956-233-9306', '956-943-5461', '956-592-1045', 'w5czi@sbcglobal.net', 'W5CZI', 'General', 15, 19, 13, '2011-01-14 17:53:08', 0, '', 0), (269, 'Carlos', 'A', 'Martinez', '1609 Guadalajara Ave', 'Brownsville', 'TX', '78526', '', '', '', 'txfieros@gmail.com', 'KE5YYY', 'General', 15, 19, 12, '2011-01-12 19:19:01', 1, '', 0), (270, 'Michael', 'William', 'Bourne', '16346 FmRd 2629 #4', 'Lyford', 'TX', '78569', '956-622-1102', '1-800-687-4202', '956-622-1102', 'kb0vwg@hotmail.com', 'KB0VWG', 'General', 15, 19, 13, '2011-01-14 17:51:07', 0, '', 0), (271, 'Juan', '', 'Vazquez', '457 Agua Viva Ln', 'Brownsville', 'TX', '78520', '', '', '', 'n5rgv@att.net', 'N5RGV', 'Extra', 15, 19, 12, '2011-01-12 19:58:05', 1, '', 0), (272, 'Ralph', 'C', 'Waddups', '2009 S. Arden', 'Harlingen', 'TX', '78552', '956 536 1244', 'same', 'same', 'rwaddups@rgv.rr.com', 'WA9IES', 'Extra', 15, 19, 13, '2011-01-14 17:53:38', 1, 'VHF NET CONTROL', 0), (273, 'Stephen', '', 'Burns', '10208 S. Summerlin', 'Conroe', 'TX', '77302', '', '', '', 'stephenburns@suddenlink.net', 'N5VTU', 'Extra', 1, 72, 13, '2011-01-20 12:35:23', 1, '', 0), (274, 'Yale', 'Max', 'Taylor', '303 Prince of Wales', 'Conroe', 'TX', '77304', '936 760-2654', '', '', 'maxt3@suddenlink.net', 'W5MAX', 'General', 1, 72, 13, '2011-01-15 11:04:02', 0, '', 0), (276, 'Sandra', 'Ailene', 'Wynne', '717 Pecan Street', 'Jourdanton', 'TX', '78026', '', '', '830-570-1892', 'kb5qqc@peoplepc.com', 'KB5QQC', 'General', 12, 5, 12, '2011-01-12 23:01:43', 1, '', 0), (277, 'David', 'L', 'Jones', 'PO Box 482/501 Ebony', 'Rio Hondo', 'TX', '78583', '9567482070', '9567481005', '9562455259', 'joneser2@hotmail.com', 'N5VCF', 'General', 15, 19, 12, '2011-01-13 08:40:57', 1, '', 0), (278, 'Brandon', '', 'Villarreal', '5129 N. Bryan RD. #2', 'Palmhurst', 'TX', '78573', '', '', '', 'wonderbreadradio@gmail.com', 'N5ICQ', 'General', 3, 42, 12, '2011-01-13 09:27:30', 1, '', 0), (279, 'Joseph', 'Donald', 'Kertesz', '1210 JoAnn Ct.', 'Edinburg', 'TX', '78539', '956-383-0235', '', '956-358-6294', 'kerteszj@rgv.rr.com', 'KC5RFW', 'Technician', 15, 19, 12, '2011-01-13 11:48:07', 1, '', 0), (280, 'Clifford', 'Allen', 'Wareham', '32086 Share 28 Road', 'Los Fresnos', 'TX', '78566', '956-233-4645', '956 233-8924', '956-243-0426', 'cliffordwareham@hotmail.com', 'N5CEY', 'Extra', 15, 19, 12, '2011-01-13 11:48:49', 1, '', 0), (281, 'Christopher', 'Charles', 'Wareham', '32086 Share 28 Road', 'Los Fresnos', 'TX', '78566', '956-233-4645', '', '956-243-0320', 'tacosauce890@gmail.com', 'KF5INZ', 'Technician', 15, 19, 13, '2011-01-20 18:54:07', 1, 'Setup 2 Meter I-Gate under the callsign of KF5INZ at home location', 0), (282, 'Jerome', 'Adelbert', 'Rogers', '4956 Camino Verde Dr.', 'Brownsville', 'TX', '78526', '(956)546-5247', '', '', 'kb5tmc@arrl.net', 'KB5TMC', 'Extra', 15, 19, 13, '2011-01-14 17:54:15', 1, '', 0), (283, 'Jose', 'Luis', 'Rodriguez', '108 canal st.', 'Los Fresnos', 'TX', '78566', '956-233-8155', '', 'N/A', 'kc5san@rgv.rr.com', 'KC5SAN', 'General', 15, 19, 12, '2011-01-13 13:35:50', 0, '', 0), (284, 'Jesus', '', 'Dominguez Jr.', '1744 McKinley St.', 'Brownsville', 'TX', '78521', '', '', '', 'kc5mah@yahoo.com', 'KC5MAH', 'General', 15, 19, 12, '2011-01-13 19:00:10', 0, '', 0), (285, 'Alton', 'O', 'Moore', 'Box 3157', 'Alamo', 'TX', '78516', '956-783-3135', '', '956-358-7522', 'amoore@rgv.rr.com', 'WB5GFU', 'General', 3, 42, 12, '2011-01-13 20:26:40', 1, 'Advanced Class License\r\nNot sure if my application for ARES membership was ever properly processed.', 0), (286, 'Tom', '', 'Hargrave', '122 Sea View Drive', 'Aransas Pass', 'TX', '78336', '361-758-6991', 'na', '361-332-9231', 'k5bv@sprynet.com', 'K5BV', 'Extra', 4, 4, 3, '2011-01-16 12:17:39', 1, '', 0), (287, 'Ed', '', 'Sarlls', '21411 Park Mill Ln', 'Katy', 'TX', '77450', '281-646-8266', '832-640-1177', '832-640-1177', 'esarlls3@yahoo.com', 'KT5YZ', 'Extra', 14, 40, 12, '2011-01-14 22:32:29', 1, '', 0), (288, 'Mark', '', 'Taylor', '6756 FM 1960', 'Dayton', 'TX', '77535', '', '', '832-722-1841', 'mtaylor@lrim.com', 'N5MDT', 'Extra', 1, 60, 12, '2011-01-15 08:13:49', 1, 'Temp QTH. Permanent home in Montgomery County', 0), (289, 'Mark', '', 'Taylor', '100 La Costa Dr', 'Montgomery', 'TX', '77356', '', '', '832-722-1841', 'n5mdt@arrl.net', 'N5MDT', 'Extra', 1, 72, 12, '2011-01-15 08:16:26', 1, '', 0), (290, 'Ryan', 'L', 'Letzerich', '1406 Jander Dr', 'Spring', 'TX', '77386', '281-203-3066', '281-886-2350', '832-585-4174', 'n5rll@sbcglobal.net', 'N5RLL', 'General', 1, 72, 12, '2011-01-15 08:27:05', 1, 'Please list my Cell phone as primary contact. Also affiliated with The Woodlands HRO.', 0), (291, 'Patrick', 'Albert', 'Ramsey', '1902 Mercoal Dr.', 'Spring', 'TX', '77386', '', '', '832-381-0988', 'n5par@sbcglobal.net', 'N5PAR', 'Extra', 1, 72, 12, '2011-01-15 08:38:38', 0, '', 0), (292, 'Larry', '', 'Brown', '2664 S. Woodloch', 'Conroe', 'TX', '77385', '936 273-1150', '', '936 499-3365', 'larrrydbrown@mac.com', 'WB5CXC', 'Advanced', 1, 72, 12, '2011-01-15 09:42:07', 0, '', 0), (293, 'William', 'David', 'Paperman', '19266 Sims', 'Cleveland', 'TX', '77328-6205', '281.592.8636', 'Fax: 281.593.2688', '281.639.5365', 'w5wp@arrl.net', 'W5WP', 'Extra', 1, 72, 12, '2011-01-15 10:45:32', 1, '', 0), (294, 'John', '', 'Teer', '2802 Lazy Lake Drive', 'Harlingen', 'TX', '78550-8636', '', '', '', 'AK5Z@arrl.net', 'AK5Z', 'Extra', 15, 19, 12, '2011-01-15 11:09:22', 1, 'I am also an Assistant Section Manager for STX', 0), (295, 'Ross', '', 'Comstock', '2136 McMullen Ln', 'Aransas Pass', 'TX', '78336', '', '', '361-446-6979', 'kj4ktw@gmail.com', 'KJ4KTW', 'General', 4, 4, 13, '2011-01-17 14:34:55', 0, 'EC-001 completed by self-study\r\nAlso certified ICS 305 and ICS 400', 0), (296, 'Joe', '', 'Bruno', '4433 Stagecaoch Road', 'Seguin', 'TX', '78155', 'None', '', '210-363-9500', 'jlbruno@owfarm.com', 'KE5YWO', 'General', 12, 35, 3, '2011-01-15 13:05:32', 0, 'Working on getting HF, VHF and UHF at home.', 0), (297, 'James', 'C', 'Smith', '8734 Melrose', 'San Antonio', 'TX', '78250', '210 522-6167', '', '210 894-3404', 'n5rxs@satx.rr.com', 'N5RXS', 'General', 12, 10, 2, '2011-01-15 18:19:52', 0, '', 0), (298, 'Schuylar', 'Wayne', 'Crist', '9570 Autumn Shade', 'San Antonio', 'TX', '78254', '210-663-6093', '', '210-663-6093', 'skyskyrider@hotmail.com', 'AE5SC', 'Extra', 12, 10, 12, '2011-01-15 19:04:03', 1, 'I am also an A.R.R.L. Assistant Public Information Coordinator for Districts 10/11/12.', 0), (299, 'Harding', 'R', 'Goodman', '24023 Bridge Way', 'Spring', 'TX', '77389', '281-251-6414', '281-251-6414', '(281) 222-1700', 'hrgoodman@sbcglobal.net', 'KE5KSZ', 'General', 14, 38, 12, '2011-01-16 08:42:03', 1, 'Participate with Montgomery Country even though I live in very north Harris County.', 0), (300, 'Michael', '', 'McPeak', '5129 N. Bryan RD. #2', 'Palmhurst', 'TX', '78573', '', '', '', 'mlmcpeak@gmail.com', 'W5STX', 'Technician', 15, 19, 12, '2011-01-16 11:36:02', 1, 'h county', 0), (301, 'Sharon', 'L', 'Heivilin', '2306 Heathergold Dr', 'Houston', 'TX', '77084', '281-492-7135', '', '832-435-7187', 'kc8eo@arrl.org', 'KC8EO', 'Extra', 14, 38, 13, '2011-01-16 20:18:11', 1, '', 0), (302, 'Andrew', '', 'Bounds', '2738 Wisteria Walk', 'Spring', 'TX', '77388', '', '713-831-3399', '281-536-8493', 'abounds5@gmail.com', 'KD5CQ', 'Extra', 14, 38, 13, '2011-01-16 20:45:53', 1, '', 0), (303, 'john', 'm', 'paterson jr', '1818 oak valley dr', 'kemah', 'TX', '77565', '', '', '281-701-9807', 'kc5laa@arrl.net', 'KC5LAA', 'Extra', 1, 31, 12, '2011-01-17 12:20:13', 1, '', 0), (304, 'David', 'Leland', 'Coles', '14210 Verde Mar Lane', 'Houston', 'TX', '77095', '281-855-9926', '281-221-1357', '281-221-1357', 'David.Coles@KBR.com', 'WD5JIM', 'Extra', 14, 38, 12, '2011-01-16 21:13:51', 0, '', 0), (305, 'Bill', '', 'Pierrard', '8106 Tiger Lane', 'Houston', 'TX', '77040', '713-466-4011', '', '713-614-2267', 'k5jhp@sbcglobal.net', 'K5JHP', 'Extra', 14, 38, 12, '2011-01-16 22:10:35', 0, 'Part of Willowbrook Methodist Hospital group', 0), (306, 'William', 'Matthew', 'Woodruff', '810 Heather Ct', 'Houston', 'TX', '77024', '713-647-8940', '713-435-1497', '713-542-6275', 'matt.woodruff@memorialvillages.net', 'KA5YYD', 'General', 14, 38, 12, '2011-01-16 22:24:34', 1, '', 0), (307, 'Bruce', '', 'Paige', 'PO Box 310', 'Alief', 'TX', '77411', '', '', '832-788-8845', 'kk5do@arrl.net', 'KK5DO', 'Extra', 14, 40, 12, '2011-01-17 08:16:19', 1, 'Net Manager District 14 SW Unit\r\nFirst Responder - Harris County Sheriff''s Office', 0), (308, 'Timothy', 'Charles', 'Groman', '2321 Palm Cir', 'Seabrook', 'TX', '77586', '713-302-1579', '281-291-2583', '832-226-1100', 'kd5ikg@arrl.net', 'KD5IKG', 'General', 14, 39, 12, '2011-01-16 22:51:14', 1, 'Communications Officer for Seabrook VFD', 0), (309, 'Benjamin', 'F', 'Secor Jr', '8002 Rolling Oaks Dr N', 'Spring', 'TX', '77389-3033', '281-772-6087', '', '281-772-6087', 'bsecorjr@aim.com', 'KB5VSY', 'General', 14, 38, 12, '2011-01-16 22:52:57', 1, '', 0), (310, 'Gerald', 'Edward', 'Muller', '12103 Crystalwood Dr', 'Houston', 'TX', '77013', '713-455-8752', 'Retired', '712-305-6922', 'GMuller885@aol.com', 'KF5EYC', 'Technician', 14, 37, 12, '2011-01-17 10:34:45', 0, 'Believe the county is NE. Live nothe of I10 and east of 45/59.', 0), (311, 'David', 'Alfred', 'Bridgwater', 'PO Box 720847', 'McAllen', 'TX', '78504', '512-697-9735', '866-865-6683 ext 5512', '956-330-4890', 'dabridgwater@msn.com', 'WB6TJB', 'Extra', 15, 19, 13, '2011-01-17 08:06:28', 1, '', 0), (312, 'Chris', 'L', 'Engleman', '7211 Foxbrick Ln, Apt 10201', 'Humble', 'TX', '77338', '214-458-9367', '281-446-7127', '214-458-9367', 'chris.engleman@gmail.com', 'KC5COF', 'Technician', 14, 37, 12, '2011-01-17 01:19:37', 1, 'Dispatcher for Humble PD/FD', 0), (313, 'Thomas "Ben"', '', 'Gillis', '2914 Quincannon Ln', 'Houston', 'TX', '77043', '713-690-9612', 'N/A', '713-907-3897', 'bngillis@swbell.net', 'K5TBN', 'General', 14, 38, 12, '2011-01-17 06:38:40', 1, 'PIO Dist. 14', 0), (314, 'Charles', 'R.', 'Steffler', '9018 Willow Springs Lane', 'Conroe', 'TX', '77302', '936-441-7055', '713-989-2637', '813-340-4340', 'CSteffler@aol.com', 'WB5OHT', 'General', 1, 72, 12, '2011-01-17 10:13:38', 1, '', 0), (315, 'David', '', 'Velen', '30434 Glenboro Drive', 'Spring', 'TX', '77386', '281-296-0542', '713-737-9555', '713-485-9648', 'david.velen@yahoo.com', 'KF5CKL', 'General', 1, 72, 12, '2011-01-17 08:10:12', 1, '', 0), (316, 'Delmar', 'Edward ', 'Partridge ', '903 Chisel Point Drive ', 'Houston ', 'TX', '77094', '281 599 0970 ', '281 599 0970', '281 433 3427 ', 'inapeartree.del@gmail.com', 'W5QQ', 'Extra', 14, 40, 13, '2011-01-17 08:22:11', 1, '', 0), (317, 'Philip', '', 'Burrow', '5621 Village Arbour', 'Katy', 'TX', '77493', '281-391-4124', '281-237-4213', '713-859-2229', 'pburrow@consolidated.net', 'KJ5OW', 'Advanced', 14, 38, 12, '2011-01-17 08:31:51', 1, '', 0), (318, 'Paul', '', 'Glosch', '22522 Crownfield Lane', 'Katy', 'TX', '77450', '', '', '', 'pjmfa@consolidated.net', 'KF5ENT', 'Extra', 1, 29, 12, '2011-01-17 08:43:04', 1, '', 0), (319, 'William', 'Ray', 'McLaughlin', '6748 Georgia pine', 'Brownsville', 'TX', '78526', '956-350-5884', '956-943-5461', '956-592-1047', 'rayjr_txpack@sbcglobal.net', 'KD5ZZE', 'General', 15, 19, 12, '2011-01-17 08:47:59', 1, '', 0), (320, 'THOMAS', 'F', 'SHAW III', '10822 LONGSHADOW LANE', 'HUNTERS CREEK VILLAGE', 'TX', '77024-6831', '281-501-1175', '', '713-299-1274', 'SHAW10822@COMCAST.NET', 'K5LOT', 'General', 14, 40, 12, '2011-01-17 09:02:32', 1, 'I''M IN SIDS DISTRICT AREA', 0), (321, 'Michael', '', 'Kahlenberg', '927 Rosa del Villa Court', 'Richmond', 'TX', '77406', '', '', '281-630-4926', 'mhkahl2@aol.com', 'N5MHK', 'Technician', 1, 29, 12, '2011-01-17 09:04:50', 1, '', 0), (322, 'Chris', '', 'Haase', '22403 Stormcroft Lane', 'Katy', 'TX', '77450', '281-395-3460', '281-544-6888', '713-478-0888', 'w5oil@arrl.net', 'W5OIL', 'Extra', 14, 40, 12, '2011-01-17 09:06:22', 1, '', 0), (323, 'Ineke', 'Bouwina', 'Haase', '22403 Stormcroft Lane', 'Katy', 'TX', '77450', '281-395-3460', '281-237-6455', '713-478-0885', 'ineke@ineke.net', 'KT4FUN', 'Technician', 14, 40, 12, '2011-01-17 10:36:46', 1, '', 0), (324, 'Mark', 'Freeman', 'Kirschke', '3302 Chris Drive', 'Houston', 'TX', '77063', '7137879035', '8323933267', '8324099510', 'MarkontheRoad@Hotmail.com', 'KF5FLB', 'Technician', 14, 40, 12, '2011-01-17 09:11:48', 0, '', 0), (325, 'Scott', 'C', 'Reeve', '20714 Chapel Glen Ct', 'Katy', 'TX', '77450-6624', '281-492-1289', '', '281-217-8929', 'screeve@earthlink.net', 'KT5SR', 'Extra', 14, 40, 12, '2011-01-17 09:14:22', 1, '', 0), (326, 'tim', 'donald', 'weiss', 'po box 1209', 'huffman', 'TX', '77336', '2813245165', '', '2816205015', 'timweiss@verizon.net', 'KE5LMA', 'General', 14, 37, 12, '2011-01-17 09:18:02', 1, '', 0), (327, 'Lloyd', 'G', 'Jeffries', '311 Barrington Farm Court', 'Georgetown', 'TX', '78633', '512-240-4243', '', '512-639-7801', 'lgj@arrl.net', 'K1LGJ', 'Extra', 7, 98, 13, '2011-01-17 09:31:35', 0, '', 0), (328, 'Gary', 'Stephen', 'Fortier', '8018 Windswept Ln.', 'Houston', 'TX', '77063', '713-782-3863', '832-230-2190', '832-492-4355', 'rmfortier@gmail.com', 'KE5OCA', 'Technician', 14, 40, 12, '2011-01-17 09:46:46', 1, 'Briarmeadow CERT Coordinator', 0), (329, 'James (Jim)', 'Harold', 'Burrough', '4613 Holt Street', 'Bellaire', 'TX', '77401-5808', '713-661-1692', '713-441-5719', '281-831-1428', 'n5dtt@arrl.net', 'N5DTT', 'Extra', 14, 40, 13, '2011-01-17 10:02:37', 1, 'Hospital Communication Liaison. Current obligation as Emergency Manager at hospital where employed', 0), (330, 'Thomas', '', 'Tankersley', '5025 De Milo Dr.', 'Houston', 'TX', '77092-4211', '(713) 932-9624', '', '(713) 957-1449', 'k5ezt@yahoo.com', 'K5EZT', 'Extra', 14, 40, 13, '2011-01-17 10:05:30', 1, '', 0), (331, 'Robert', 'L.', 'Norris', '15846 Aberdeen trails Dr', 'Houston', 'TX', '77095', '281 345 9131', '', '832 731 7896', 'ke5uip@yahoo.com', 'KE5UIP', 'General', 14, 38, 12, '2011-01-17 10:06:05', 0, '', 0), (332, 'William', 'Allen', 'Jenkins', '11611 Willowrun', 'Montgomery', 'TX', '77356', '7135533394', '9365231141', '7135533394', 'williamjnekins@msn.com', 'K5WAJ', 'General', 1, 72, 12, '2011-01-17 10:07:50', 0, 'Paramedic, Firefighter trained, IC experience, Hazmat Trained, Safety Manager for MCHD EMS', 0), (333, 'Harold (Hal)', 'F', 'Merritt', '2327 Willowby Dr', 'Houston', 'TX', '77008', '713-861-0424', '', '713-817-8572', 'kd5hw@arrl.net', 'KD5HW', 'Extra', 14, 38, 12, '2011-01-17 10:18:08', 1, '', 0), (334, 'Allyson', 'Brown', 'Wells', '10903 Holly Springs Dr', 'Houston', 'TX', '77042', '713-952-4457', '713-718-5653', '281-701-2033', 'ke5jbw@arrl.net', 'KE5JBW', 'General', 14, 40, 13, '2011-01-17 10:38:19', 1, '', 0), (335, 'Richard', '', 'Seegmiller', '2303 Cypress Run Dr', 'Sugar Land', 'TX', '77478', '281-980-8785', '', '281-460-9424', 'rseegmiller@alumni.ucsd.edu', 'KE5KKM', 'Extra', 1, 29, 12, '2011-01-17 10:46:26', 1, '', 0), (336, 'Walter', 'Wayne', 'Wright', '1507 Elton', 'Houston', 'TX', '77034', '713 941 7777', '713 941 7777', '', 'ka5qdg1@juno.com', 'KA5QDG', 'Extra', 14, 39, 12, '2011-01-17 10:57:32', 1, 'Repeater fixer', 0), (337, 'Harvey', 'C.', 'Henning', '107 Oakland Drive', 'Georgetown', 'TX', '78628-7611', '512-819-9934', 'none', '512-818-0359', 'n0ajp@suddenlink.net', 'N0AJP', 'General', 7, 98, 12, '2011-01-17 11:30:22', 0, 'I was the Director of the Waco McLennan Office of Emergency Management. I am retired', 0), (338, 'Matthew', '', 'Kosmoski', '8855 Merlin Court', 'Houston', 'TX', '77055', '', '', '713-314-7882', 'mkosmo@gmail.com', 'KE5HHG', 'General', 14, 38, 12, '2011-01-17 11:32:33', 1, '', 0), (339, 'Gary', 'L.', 'Alose Sr.', '11931 Canyon Rock Ln', 'Tomball', 'TX', '77377', '281-357-0876', '713-230-4344', '843-275-4279', 'gary.alose@comcast.net', 'WS5Y', 'Extra', 14, 38, 12, '2011-01-17 11:34:42', 1, '', 0), (340, 'john', '', 'moore', 'po box 667473', 'houston', 'TX', '77266', '', '', '', 'jwm@hal-pc.org', 'KK5NU', 'Extra', 14, 40, 12, '2011-01-17 11:46:40', 1, '', 0), (341, 'David', 'A', 'Fanelli', '2817 Pine Mills Dr', 'League City', 'TX', '77573-5731', '281-334-9619', '281-483-4833', '281-450-5312', 'kb5pgy@flash.net', 'KB5PGY', 'Extra', 1, 31, 13, '2011-01-17 11:47:37', 1, 'SKYWARN POC For Houston/Galveston NWS', 0), (342, 'Marie', '', 'Schaer', '5210 Chesapeake Way', 'Houston', 'TX', '77056', '', '', '', 'schaer@hal-pc.org', 'KD5UJT', 'Technician', 14, 40, 12, '2011-01-17 12:06:12', 1, '', 0), (343, 'CRAIG', 'EDWARD', 'BOEGLER', '291 RED POPPY TRAIL', 'GEORGETOWN', 'TX', '78633', 'NONE', 'NONE', '512-864-4050', 'W5TSN@SUDDENLINK.NET', 'W5TSN', 'Extra', 7, 98, 13, '2011-01-17 12:44:46', 0, '', 0), (344, 'Louis "Butch"', '', 'Davis', '1834 Whispering Forest Drive', 'Kingwood', 'TX', '77339', '281-359-3359', '713-215-3428', '281-414-9873', 'lou.r.davis@williams.com', 'K5LRD', 'Technician', 14, 37, 12, '2011-01-17 13:50:28', 1, '', 0), (345, 'Johnson', 'Peyton', 'Barnes', '3656 Meadow Lake Lane', 'Houston', 'TX', '77027', '713-622-4220', '713-854-5705', '', 'skaevola@hotmail.com', 'KE5ZDZ', 'Extra', 14, 40, 12, '2011-01-17 14:22:29', 1, '', 0), (346, 'Charles (Chuck)', 'Duane', 'Sprick', '2510 Pebble Stream Court', 'Kingwood', 'TX', '77345', '281-360-8469', 'NA', '281-229-1283', 'ke5rad@arrl.net', 'KE5RAD', 'General', 14, 37, 12, '2011-01-17 15:51:33', 1, '', 0), (347, 'Kyle', '', 'Brewer', '2536 Pelican Dr.', 'Seabrook', 'TX', '77586', '', '281-483-9831', '832-425-8372', 'kyle.a.brewer@gmail.com', 'AE5IJ', 'Extra', 14, 39, 13, '2011-01-17 16:23:34', 1, '', 0), (348, 'Robert', 'H', 'Alexander Jr', '5550 Fredericksburg Rd Apt 822', 'San Antonio', 'TX', '78229', '210-259-8054', '', '', 'ralexander22@satx.rr.com', 'KE5YQE', 'General', 12, 10, 12, '2011-01-17 17:11:19', 0, 'Am planning on adding HF and digital modes soon.', 0), (349, 'Stuart', '', 'Harris', '206 Summer Breeze Drive', 'La Porte', 'TX', '77571', '281 930-9315', '713 731-5420', '713 557-1830', 'stu.houston@yahoo.com', 'KF5ETS', 'General', 14, 39, 12, '2011-01-17 17:16:22', 1, '', 0), (350, 'Billy', 'Glen', 'Ashenhart', '7802 Windswept', 'Houston', 'TX', '77063', '713-781-8910', '713-252-0409', '703-252-0409', 'bill@ashenhart.com', 'KD5RDS', 'Extra', 14, 40, 12, '2011-01-17 17:47:29', 1, '', 0), (351, 'James', 'Vernon', 'Heck', '3013 Goldcrest', 'MCALLEN', 'TX', '78504', '956 682-4429', '', '956-309-1550', 'jamesvheck@gmail.com', 'W5JVH', 'Advanced', 3, 42, 12, '2011-01-17 19:31:59', 1, '', 0), (352, 'Charles', 'L', 'Lancaster', '20011 N. Pecos Valley Trail', 'Katy', 'TX', '77449', '', '', '', 'lancaster67@sbcglobal.net', 'KT5BBQ', 'General', 14, 40, 11, '2011-01-17 19:38:53', 1, '', 0), (354, 'Glen', '', 'Reid', '1305 Carlotta Lane', 'Austin', 'TX', '78733', '512 263 2300', '', '512 263 5700', 'k5fx@arrl.net', 'K5FX', 'Extra', 7, 86, 12, '2011-01-17 19:48:29', 1, '', 0), (355, 'ALAN', '', 'ISAACHSEN', '5438 INKER ST', 'HOUSTON', 'TX', '77007', '', '', '713.213.1170', 'KB2WF@YAHOO.COM', 'KB2WF', 'Advanced', 14, 37, 13, '2011-01-17 19:58:29', 0, '', 0), (356, 'Charles', '', 'Kimtantas', '2831 N. Blue Meadow Circle', 'Sugar Land', 'TX', '77479', '281-980-3513', '713-235-3032', '', 'wb5exi@arrl.net', 'WB5EXI', 'Extra', 1, 29, 12, '2011-01-17 20:06:08', 1, 'Primary FtBendCo OEM\r\nAssigned Sugar Land EOC\r\nTexas RACES 25-157\r\nFBC RACES 4623\r\nICS 300/400', 0), (357, 'Alfred', 'J.', 'Perez', '529B Barringer Lane', 'Webster', 'TX', '77598', '832-380-5867', '', '713-927-7080', 'perez.alfred@gmail.com', ' N5VEV', 'General', 14, 39, 12, '2011-01-17 21:51:23', 1, '', 0), (358, 'Dominic', '', 'Mazoch', '110 West Rocky Creek Road', 'Houston', 'TX', '77076', '713-697-0748', '', '', 'domemt@juno.com', 'N5TCB', 'General', 14, 38, 13, '2011-01-17 22:08:02', 0, '', 0), (359, 'David', 'Wayne', 'Wells', '10903 Holly Springs Drive', 'Houston', 'TX', '77042', '713-417-0648', '713-718-5615', '713-417-0648', 'dwells555@yahoo.com', 'KD5E', 'Extra', 14, 40, 12, '2011-01-18 00:46:46', 1, '', 0), (360, 'Roger', 'W', 'Olsen', '28422 Lauren Cove Lane', 'Spring', 'TX', '77386', '281 907 7293', '713 873 4419', '301 273 5114', 'roger_olsen@hchd.tmc.edu', 'KE5STR', 'General', 14, 37, 12, '2011-01-18 08:27:09', 1, 'I live in Montgomery County but am staff at Ben Taub Gen Hospital during emergencies.', 0), (361, 'Mike', '', 'Wilmore', '235 portulaca court', 'driftwood', 'TX', '78619', '5128479525', '', '6182106058', 'mike704@earthlink.net', 'KF5ACH', 'Technician', 7, 41, 12, '2011-01-19 17:59:49', 0, '', 0), (362, 'James', '( Danny )', 'Thornton', '118 Sycamore', 'Goodrich', 'TX', '77335', '9363654763', '', '9364334909', 'dannythor@eastex.net', 'KD7HAM', 'General', 2, 76, 13, '2011-01-18 15:39:23', 1, '', 0), (363, 'Earl', 'S', 'Pack', '18807 Cypress Mtn. Dr.', 'Spring', 'TX', '77388', '281-288-2029', '281-586-2535', '281-381-2105', 'pack2es@gmail.com', 'AE5PA', 'Extra', 14, 38, 13, '2011-01-18 12:03:11', 1, 'Trainer', 0), (365, 'Aaron', '', 'Siller', '20526 Northoaks Dr', 'Houston', 'TX', '77073', '', '', '8322865469', 'n5ams@yahoo.com', 'N5AMS', 'Technician', 14, 37, 12, '2011-01-18 15:08:34', 0, 'ICS800 in progress', 0), (366, 'Ken', '', 'Mitchell', '6527 Glenhill Drive', 'Spring', 'TX', '77389', '', '', '', 'kd2kw@yahoo.com', 'KD2KW', 'Extra', 14, 38, 12, '2011-01-18 15:52:48', 1, 'How will the required personal information (*) be protected?', 0), (367, 'Dean', '', 'Lonning', '5034 Boca Chica blvd Lot 18', 'Brownsville', 'TX', '78521', '956 544 6999', '956 525 4299', '712 270 2000', 'W5GXL@ARRL.NET', 'W5GXL', 'General', 15, 19, 12, '2011-01-18 18:38:05', 0, '', 0), (368, 'Stephen', '', 'Alexander', '818 East Polk Avenue', 'Harlingen', 'TX', '78550-7230', '956-425-4342', '', '', 'salexander1@rgv.rr.com', 'KB2JQC', 'Advanced', 15, 19, 12, '2011-01-18 18:46:46', 1, '', 0), (369, 'Armando', 'R.', 'Perez', 'p.o. box 455', 'Leming', 'TX', '78050', '830-742-8544', '', '210-393-1715', 'kf5dzi@wildblue.net', 'KF5DZI', 'General', 12, 5, 12, '2011-01-18 20:02:50', 1, '', 0), (370, 'Mike', '', 'Wisby', 'P O Box 1104', 'College Station', 'TX', '77841-1104', '', '979.845.3605', '', 'mwusmm@msn.com', 'KA5HIA', 'Extra', 5, 13, 13, '2011-01-18 20:49:52', 1, 'ICS 300 / ICS 400 / NIMS / FF 2 / HazMat Specialist / Fire Officer 4 / Master Instructor ', 0), (371, 'Robert', '', 'Dibeler', '464 THE OLE DON RD - INDIAN SPRINGS', 'LIVINGSTON', 'TX', '77351-3829', '936-563-3762', '', '936-328-1673', 'wb3gub@yahoo.com', 'WB3GUB', 'General', 2, 76, 12, '2011-01-20 00:44:58', 0, 'I am not sure how high I went in NIMS.', 0), (372, 'Ray', '', 'Mueller', '701 Marilyn Dr', 'Schertz', 'TX', '78154', '210-658-1345', '', '210-845-2288', 'raym701@yahoo.com', 'AE5HN', 'Extra', 12, 35, 12, '2011-01-18 23:53:06', 1, 'Bexar Co. and Guadalupe Co.', 0), (373, 'Bruce', '', 'Bayley', '12439 Adams Ridge Ln', 'Humble', 'TX', '77346', '281 360 8028', '832 865 2104', '832 865 2104', 'kc5abr@earthlink.net', 'KC5ABR', 'Extra', 14, 37, 12, '2011-01-19 11:28:03', 1, '', 0), (374, 'Gregory', 'L', 'Dome', 'PO BOX 2616', 'Onalaska', 'TX', '77360', '936-646-2574', '', '936-828--9471', 'ke5ldo@gmail.com', 'KE5LDO', 'Extra', 2, 76, 12, '2011-01-19 12:26:43', 1, '', 0), (375, 'Lee', 'H', 'Cooper', '2507 Autrey Drive', 'Leander', 'TX', '78641', '', '', '', 'w5lhc@arrl.org', 'W5LHC', 'Extra', 7, 98, 11, '2011-01-19 13:58:00', 0, '', 0), (376, 'Richard', '', 'Remels', '23214 lidstone point', 'Katy', 'TX', '77494', '281 693 5251', '', '713 249 3975', 'rremels@consolidated.net', 'KF5JHX', 'Technician', 14, 40, 12, '2011-01-19 16:09:46', 0, '', 0), (377, 'Steve', '', 'Castle', '504 Jacobs Ln', 'La Vernia', 'TX', '78121', '', '', '910-322-8482', 'n7ful@arrl.net', 'N7FUL', 'Extra', 12, 99, 12, '2011-01-19 18:29:42', 1, 'Referred by Clint Wynne N5TBS. I plan to acquire a generator in the near future.', 0), (378, 'DAVID ', 'JORDAN', 'CHILDRESS', '2379 MISTY LN', 'MAXWELL', 'TX', '78656', '512-754-4941', '', '512-754-4941', 'kd5mml@gmail.com', 'KD5MML', 'General', 7, 17, 13, '2011-01-19 19:56:35', 1, '', 0), (379, 'Nancy', 'S.', 'Perez', 'p.o. box 455', 'Leming', 'TX', '78050', '830-742-8544', '', '210-3931734', 'kf5hgw@wildblue.net', 'KF5HGW', 'Technician', 12, 5, 12, '2011-01-19 20:21:32', 1, '', 0), (380, 'John Jr', 'S', 'GOFF', '1419 BLACK POWDER', 'SAN ANTONIO', 'TX', '78264', '210-626-5788', '210-241-4183', '', 'K5PBR@ARRL.NET', 'K5PBR', 'General', 12, 10, 12, '2011-01-19 20:44:35', 1, '', 0), (381, 'Dorthy', 'M', 'THOMPSON', '1419 BLACK POWDER', 'SAN ANTONIO', 'TX', '78264', '210-626-5788', '', '210-389-8945', 'W7PBR@ARRL.NET', 'W7PBR', 'General', 12, 10, 12, '2011-01-19 20:46:46', 1, '', 0), (382, 'Bob', '', 'Shirey', '650 Dove Hill Dr', 'Kyle', 'TX', '78640', '512-964-9878', '512-419-2177', '512-964-9878', 'rashirey@yahoo.com', 'AK5RS', 'Extra', 7, 17, 12, '2011-01-20 10:05:06', 1, '', 0), (383, 'Greg', '', 'Golian', '229 Club Island way', 'Montgomery', 'TX', '77356', '', '', '281-639-5590', 'ggol@aol.com', 'K5GZG', 'Extra', 1, 72, 12, '2011-01-20 12:46:23', 1, '', 0), (384, 'Frances', 'Avon', 'Treat', '209 Winter Haven Lane', 'Brownsville', 'TX', '78526', '', '', '9563713609', 'n0wnh@kf0mp.com', 'N0WNH', 'Technician', 15, 19, 12, '2011-01-20 14:40:23', 1, '', 0), (385, 'Bobbi', 'Mathis', 'Bourne', '16346 FmRd 2629', 'Lyford', 'TX', '78569', '956-832-2288', '956-364-4775', '956-832-2288', 'kb5vwg@vtxb.com', 'KB5VWG', 'Technician', 15, 19, 12, '2011-01-20 17:41:57', 0, '', 0), (386, 'Robert', 'Allen', 'Giles', '3909 North FM 524 Road', 'Sweeny', 'TX', '77480-8494', '979.647.1111', '', '979.864.0674', 'bogiles@windstream.net', 'KD5DSS', 'Technician', 1, 12, 12, '2011-01-21 16:03:59', 1, 'Texas DPS State Highway Trooper', 0), (387, 'Patricia (Pat)', 'L.', 'Stotler', '1400 Zillock Rd. WF-316', 'San Benito', 'TX', '78586', '956/361-9276', '', '956/244-6442', 'pstotler@aol.com', 'KB0TFK', 'General', 15, 19, 13, '2011-01-20 22:04:14', 1, '', 0), (388, 'Joanne (Jodie)', '', 'Law', '1400 Zillock Rd. WF-316', 'San Benito', 'TX', '78586', '956/361-9276', '', '956/244-2142', 'ab0eg@aol.com', 'AB0EG', 'Extra', 15, 19, 13, '2011-01-20 22:05:53', 1, '', 0), (389, 'Jack', 'L', 'Barnard', '2801 E. Harrison Ave # 25', 'Harlingen', 'TX', '78550', '956-364-3020', '', '308-380-9431', 'jbarnard@kdsi.net', 'WY0F', 'Extra', 15, 19, 12, '2011-01-20 18:44:25', 1, '', 0), (390, 'Enemencio', 'Candido', 'Hernandez', 'PO box 725', 'Rio Hondo', 'TX', '78583', '956-748-4128', '', '', 'e_hrnn@yahoo.com', 'KF5EQO', 'General', 15, 19, 12, '2011-01-20 20:16:35', 1, '', 0), (391, 'Alexander', 'Ian', 'Traxler', '17306 Coronado Park Lane', 'Humble', 'TX', '77346', '', '', '832-350-8729', 'traxla@gmail.com', 'W5AIT', 'General', 14, 37, 13, '2011-01-20 20:03:10', 1, '', 0), (392, 'ROBERT', 'LAWRENCE', 'FORRY', '149 EAST LAKE DRIVE', 'PLEASANTON', 'TX', '78064', '731.225.3059', '210.932.6827', '731.225.3059', 'rforry@yahoo.com', 'W5RLF', 'Technician', 12, 5, 12, '2011-01-21 07:53:06', 1, '', 0), (393, 'Willie', '', 'Nelson', '492 Tallow Street', 'Onalaska', 'TX', '77360', '', '', '', 'wdnelson@suddenlink.net', 'KE5UPP', 'General', 2, 76, 12, '2011-01-21 11:52:42', 1, '', 0), (394, 'Bob', '', 'Austin', '107 West Park Drive', 'Brownsville', 'TX', '78520', '', '', '', 'k5vc@aol.com', 'K5VC', 'Extra', 15, 19, 13, '2011-01-21 15:04:28', 0, '', 0), (395, 'richard', '', 'desrosiers', '17719 graham rd', 'harlingen', 'TX', '78552', '956 564 2375', '', '603 785 7546', 'w1kgz@yahoo.com', 'WB5B', 'Extra', 15, 19, 12, '2011-01-21 19:28:37', 1, '', 0), (396, 'Dana', 'Boyd', 'Norman', '102 Bob White Cove', 'Dripping Springs', 'TX', '78620', '512-845-1997', '', '', 'ke5ylf@yahoo.com', 'KE5YLF', 'Technician', 7, 41, 12, '2011-01-21 19:57:14', 0, '', 0), (397, 'Fredric', '', 'Lozo', '4748 County Road 1075', 'Mathis', 'TX', '78368', '', '', '', 'fredlozo@yahoo.com', 'AK5U', 'Extra', 4, 83, 12, '2011-01-21 22:06:41', 0, 'INACTIVE', 0), (398, 'Jack', '', 'Philley', '23223 Lidstoine Point Ct.', 'Katy', 'TX', '77494', '', '', '', 'jackphilley@consolidated.net', 'WB5KVV', 'Advanced', 14, 40, 12, '2011-01-22 09:42:57', 1, 'call sign is W B 5 K V V, the v v can sometimes be misread as a w ', 0), (399, 'Cecil', 'Clair', 'Watt Jr.', '315 Starr Springs Drive', 'Livingston', 'TX', '77351-8550', '936-563-3479', '', '', 'bayousnsc@netscape.net', 'KE5UPN', 'Technician', 2, 76, 12, '2011-01-22 12:31:52', 1, 'IDPA-SSP', 0), (400, 'Mary', 'A', 'South', '200 Crestfield Dr.', 'Pleasanton', 'TX', '78064-4458', '830-281-2408', 'none', 'same as home', 'hugokk5bz@aol.com', 'KF5DZH', 'Technician', 12, 5, 12, '2011-01-22 20:37:23', 0, '', 0), (401, 'Florence', 'Diane', 'Garneau', '1025 W Church St', 'Livingston', 'TX', '77351', '509 241-0995', '', '936 668-1902', 'wm6v@versalinkus.com', 'WM6V', 'Extra', 2, 76, 12, '2011-01-23 06:38:27', 1, '', 0), (402, 'Linda', '', 'DesRosiers', '17719 Graham Road', 'Harlingen', 'TX', '78552', '', '', '603.785.7546', 'specialforyou@yahoo.com', 'W5TRV', 'Extra', 15, 19, 12, '2011-01-23 11:04:59', 1, '', 0), (403, 'James', 'Richard', 'Oestreich', '2255 FM 3186', 'Onalaska', 'TX', '77360-7557', '(936) 646-4151', '', '(936) 933-0608', 'jimo711@gmail.com', 'K5JRO', 'Extra', 2, 76, 12, '2011-01-24 11:46:17', 1, '', 0), (404, 'Thomas (Tom)', 'Michael', 'Sweany', '475 Indian Shore', 'Livingston', 'TX', '77351', '936 967 3578', '936 967 3578', '713 540 7675', 'w5qvk@eastex.net', 'W5QVK', 'Extra', 2, 76, 12, '2011-01-23 19:26:59', 1, '200 AH battery, gasoline generator,diesel auto able to power or charge 12 v\r\n\r\nfrom 12 v if nwwsws', 0), (405, 'Malcolm', 'Earrell', 'Robertson', 'P.O. Box 8698', 'Horseshoe Bay', 'TX', '78657', '830-693-1359', '', '512-913-0846 preferred-', 'rmalcolm@moment.net', 'W5RME', 'Extra', 8, 16, 13, '2011-01-23 21:07:13', 1, '', 0), (406, 'LeMoyne', '', 'Boyer', '2723 Riverhollow Ln', 'Sugar Land', 'TX', '77479', '281-344-8585', '', '832-226-8940', 'kd5jcy@arrl.net', 'KD5JCY', 'General', 1, 29, 12, '2011-01-23 21:50:48', 1, '', 0), (407, 'Larry', 'Marshall', 'Brooks', 'PO Box 327', 'Ace', 'TX', '77326', '936-685-4842', '', '', 'lmsugar2@yahoo.com', 'KF5DCN', 'Technician', 2, 76, 12, '2011-01-24 10:08:48', 1, '', 0), (408, 'Chris', '', 'Driskill', '408 10TH ST', 'HEMPSTEAD', 'TX', '77445', '979-826-2934', '713-482-5462', '832-330-3857', 'kf5cwp@sbcglobal.net', 'KF5CWP', 'Technician', 1, 93, 12, '2011-01-24 11:07:41', 1, '', 0), (409, 'BOB', '', 'ARNOLD', 'P.O. BOX 2', 'MAGNOLIA', 'TX', '77353', 'NONE COMPUTER LINE ONLY', '', '281-814-9810', 'K5KZS@ATT.NET', 'K5KZS', 'Extra', 1, 93, 12, '2011-01-24 14:46:38', 1, '', 0), (410, 'Billy', '', 'Hill', '286 Bishop', 'Livingston, tx', 'TX', '77351', '', '', '', 'biliou@samlink.net', 'W5IOU', 'General', 2, 76, 12, '2011-01-24 15:36:22', 1, '', 0), (411, 'Elizabeth (Liz)', 'A', 'Ellis', 'P.O. Box 653', 'Ace', 'TX', '77326', '936-685-4727', '', '936-328-0602', 'kuzwhiz@estex.nei', 'KF5DCO', 'Technician', 2, 76, 12, '2011-01-24 16:27:09', 1, '', 0), (412, 'Melvin ( Ralph)', 'R', 'Ellis', 'P.O. Box 653', 'Ace', 'TX', '77326', '936-685-4727', '', '936-328-0409', 'kf5dcp@eastex.net', 'KF5DCP', 'Technician', 2, 76, 12, '2011-01-24 16:32:24', 1, '', 0), (413, 'James', 'D', 'Sitton', 'P.O. Box 258 / 2612 Ashford ST.', 'Waller', 'TX', '77484', '936-372-5169', '936-372-3652', '713-819-1161', 'kd5jbt@haneyfeed.com', 'KD5JBT', 'Technician', 1, 93, 13, '2011-01-24 17:53:40', 1, 'RMS station KD5JBT-10', 0); -- -------------------------------------------------------- -- -- Table structure for table `radiohome` -- CREATE TABLE IF NOT EXISTS `radiohome` ( `personid` int(11) NOT NULL, `capabilityid` int(11) NOT NULL, PRIMARY KEY (`personid`,`capabilityid`), KEY `fk_hperson` (`personid`), KEY `fk_hcap` (`capabilityid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='radio functionality that a user has at home'; -- -- Dumping data for table `radiohome` -- INSERT INTO `radiohome` (`personid`, `capabilityid`) VALUES (172, 9), (172, 10), (172, 11), (172, 12), (172, 16), (175, 9), (175, 10), (175, 11), (175, 13), (178, 9), (178, 10), (178, 11), (178, 14), (179, 9), (179, 10), (179, 11), (179, 14), (180, 9), (180, 10), (180, 13), (180, 14), (180, 15), (181, 9), (181, 10), (181, 11), (181, 14), (183, 9), (183, 10), (183, 13), (183, 14), (183, 15), (188, 9), (188, 10), (188, 11), (188, 12), (194, 9), (194, 10), (194, 11), (194, 13), (194, 14), (194, 15), (195, 9), (195, 10), (195, 14), (195, 15), (200, 10), (200, 11), (200, 14), (202, 9), (202, 10), (202, 11), (202, 14), (202, 15), (208, 9), (208, 10), (208, 11), (208, 14), (212, 9), (212, 10), (212, 11), (214, 9), (214, 10), (214, 11), (214, 12), (214, 13), (214, 14), (214, 15), (214, 16), (214, 17), (217, 9), (217, 10), (217, 11), (217, 13), (217, 14), (217, 17), (219, 9), (219, 10), (219, 11), (219, 14), (219, 16), (219, 17), (220, 9), (220, 10), (220, 11), (220, 13), (225, 9), (225, 10), (225, 11), (226, 9), (226, 10), (226, 11), (226, 13), (226, 14), (231, 9), (231, 10), (231, 11), (231, 13), (231, 14), (231, 15), (231, 16), (231, 17), (232, 10), (232, 11), (232, 14), (233, 9), (233, 10), (233, 11), (233, 13), (233, 17), (234, 9), (234, 10), (234, 11), (234, 13), (234, 14), (234, 17), (237, 9), (237, 10), (237, 11), (237, 13), (237, 14), (237, 17), (248, 9), (248, 10), (248, 11), (250, 9), (250, 10), (250, 11), (250, 13), (250, 14), (251, 9), (251, 10), (251, 11), (262, 9), (262, 10), (262, 11), (262, 13), (262, 14), (264, 9), (264, 10), (264, 11), (264, 13), (264, 14), (266, 9), (266, 10), (266, 11), (267, 9), (267, 10), (267, 11), (267, 13), (267, 14), (267, 15), (269, 9), (269, 10), (269, 13), (270, 9), (270, 10), (270, 11), (270, 13), (270, 14), (271, 9), (271, 10), (271, 11), (271, 13), (271, 14), (271, 17), (272, 9), (272, 10), (272, 11), (273, 9), (273, 10), (273, 11), (273, 13), (273, 14), (274, 9), (274, 10), (274, 11), (274, 14), (276, 9), (276, 10), (276, 11), (276, 13), (276, 14), (276, 15), (277, 9), (277, 10), (278, 9), (278, 10), (278, 11), (279, 10), (279, 11), (280, 9), (280, 10), (280, 13), (281, 10), (281, 13), (282, 9), (282, 10), (282, 11), (282, 14), (283, 9), (283, 10), (283, 11), (283, 13), (284, 9), (284, 10), (284, 11), (284, 13), (285, 9), (285, 10), (285, 11), (285, 14), (286, 9), (286, 10), (286, 11), (286, 13), (286, 14), (287, 10), (287, 11), (288, 9), (288, 10), (288, 11), (288, 13), (288, 14), (288, 15), (288, 16), (288, 17), (289, 9), (289, 10), (289, 11), (289, 13), (289, 14), (289, 15), (289, 16), (289, 17), (290, 10), (290, 11), (290, 13), (291, 9), (291, 10), (291, 11), (291, 13), (292, 9), (292, 10), (292, 13), (292, 14), (293, 9), (293, 10), (293, 11), (293, 13), (293, 14), (293, 15), (294, 9), (294, 10), (294, 11), (295, 9), (295, 10), (295, 11), (295, 13), (295, 14), (295, 17), (297, 9), (297, 10), (297, 11), (297, 14), (298, 9), (298, 10), (298, 11), (299, 9), (299, 10), (299, 11), (300, 10), (301, 9), (301, 10), (301, 11), (302, 9), (302, 10), (302, 11), (303, 10), (303, 11), (303, 14), (303, 15), (303, 16), (305, 9), (305, 10), (305, 14), (306, 9), (306, 10), (306, 11), (306, 14), (307, 9), (307, 10), (307, 11), (307, 13), (307, 14), (308, 9), (308, 10), (308, 11), (308, 13), (309, 9), (309, 10), (309, 11), (310, 10), (310, 11), (310, 12), (310, 13), (311, 9), (311, 10), (311, 14), (311, 16), (312, 10), (312, 11), (312, 13), (313, 10), (313, 11), (314, 10), (314, 11), (315, 9), (315, 10), (315, 11), (316, 9), (316, 10), (316, 11), (316, 12), (317, 9), (317, 10), (317, 11), (317, 14), (318, 9), (318, 13), (319, 9), (319, 10), (319, 11), (319, 17), (320, 9), (320, 10), (320, 11), (322, 9), (322, 10), (322, 11), (322, 13), (322, 14), (323, 10), (323, 11), (325, 10), (325, 11), (325, 14), (326, 9), (326, 10), (326, 11), (327, 10), (327, 11), (327, 12), (327, 13), (327, 14), (328, 10), (328, 11), (329, 9), (329, 10), (329, 11), (330, 10), (330, 11), (330, 13), (331, 9), (331, 10), (331, 11), (331, 13), (332, 9), (332, 10), (332, 11), (332, 14), (333, 9), (333, 10), (333, 11), (333, 14), (333, 15), (334, 9), (334, 10), (334, 11), (335, 9), (335, 10), (336, 9), (336, 10), (336, 11), (336, 12), (336, 13), (336, 14), (337, 9), (337, 10), (337, 14), (339, 9), (339, 10), (339, 11), (339, 14), (340, 9), (340, 10), (340, 11), (340, 14), (341, 10), (341, 11), (341, 14), (342, 10), (343, 10), (343, 11), (343, 12), (344, 10), (344, 11), (345, 9), (345, 10), (345, 11), (346, 9), (346, 10), (346, 11), (346, 13), (346, 14), (346, 17), (347, 10), (347, 11), (347, 14), (348, 10), (348, 11), (348, 12), (348, 13), (349, 9), (349, 10), (349, 11), (350, 9), (350, 10), (351, 9), (351, 10), (351, 11), (352, 9), (352, 10), (352, 11), (354, 9), (354, 10), (354, 11), (354, 13), (355, 10), (355, 11), (355, 14), (356, 9), (356, 10), (356, 11), (356, 12), (356, 13), (356, 14), (356, 15), (356, 17), (357, 9), (357, 10), (357, 11), (358, 9), (358, 10), (358, 11), (359, 9), (359, 10), (359, 11), (360, 10), (360, 11), (361, 10), (361, 11), (362, 9), (362, 10), (362, 11), (362, 13), (363, 10), (363, 11), (365, 10), (365, 13), (366, 9), (366, 10), (366, 11), (366, 13), (366, 14), (366, 15), (366, 17), (367, 9), (367, 10), (367, 13), (368, 9), (368, 10), (368, 11), (368, 13), (369, 9), (369, 10), (369, 11), (369, 13), (370, 9), (370, 10), (370, 11), (371, 10), (372, 9), (372, 10), (372, 11), (372, 13), (372, 14), (372, 15), (372, 17), (373, 9), (373, 10), (373, 11), (373, 12), (374, 9), (374, 10), (374, 11), (375, 9), (375, 10), (375, 11), (375, 12), (375, 13), (375, 14), (376, 10), (376, 13), (377, 9), (377, 10), (377, 11), (378, 9), (378, 10), (378, 11), (379, 10), (379, 11), (379, 13), (380, 9), (380, 10), (380, 11), (380, 13), (380, 14), (381, 9), (381, 10), (381, 11), (381, 13), (381, 14), (382, 9), (382, 10), (382, 11), (383, 9), (383, 10), (383, 14), (384, 10), (385, 10), (385, 11), (385, 13), (388, 9), (388, 10), (388, 11), (388, 13), (389, 9), (389, 10), (389, 11), (389, 14), (390, 9), (390, 10), (390, 11), (390, 13), (391, 10), (391, 11), (392, 10), (392, 11), (393, 9), (393, 10), (393, 11), (393, 13), (394, 9), (394, 10), (394, 11), (394, 14), (395, 9), (395, 10), (395, 11), (395, 13), (396, 10), (396, 11), (396, 13), (398, 9), (398, 10), (398, 11), (399, 11), (399, 13), (401, 9), (401, 10), (401, 11), (401, 13), (401, 14), (402, 9), (402, 10), (402, 11), (402, 13), (403, 9), (403, 10), (403, 11), (404, 9), (404, 10), (404, 11), (405, 9), (405, 10), (405, 11), (405, 13), (406, 9), (406, 10), (406, 11), (407, 10), (408, 10), (409, 9), (409, 10), (409, 11), (409, 13), (410, 9), (410, 10), (410, 11), (411, 10), (411, 11), (411, 13), (412, 10), (412, 11), (412, 13), (413, 10), (413, 14); -- -------------------------------------------------------- -- -- Table structure for table `radiomobile` -- CREATE TABLE IF NOT EXISTS `radiomobile` ( `personid` int(11) NOT NULL, `capabilityid` int(11) NOT NULL, PRIMARY KEY (`personid`,`capabilityid`), KEY `fk_mcap` (`capabilityid`), KEY `fk_mperson` (`personid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='radio functionality that a user has available mobile'; -- -- Dumping data for table `radiomobile` -- INSERT INTO `radiomobile` (`personid`, `capabilityid`) VALUES (172, 9), (179, 9), (183, 9), (195, 9), (202, 9), (214, 9), (217, 9), (219, 9), (225, 9), (233, 9), (248, 9), (264, 9), (270, 9), (271, 9), (287, 9), (293, 9), (297, 9), (299, 9), (303, 9), (305, 9), (306, 9), (308, 9), (309, 9), (316, 9), (319, 9), (320, 9), (322, 9), (325, 9), (326, 9), (333, 9), (336, 9), (339, 9), (341, 9), (343, 9), (345, 9), (351, 9), (352, 9), (354, 9), (358, 9), (359, 9), (366, 9), (367, 9), (373, 9), (375, 9), (377, 9), (378, 9), (380, 9), (381, 9), (388, 9), (389, 9), (405, 9), (409, 9), (172, 10), (175, 10), (178, 10), (179, 10), (180, 10), (181, 10), (183, 10), (188, 10), (194, 10), (195, 10), (202, 10), (208, 10), (212, 10), (214, 10), (217, 10), (219, 10), (220, 10), (225, 10), (226, 10), (231, 10), (232, 10), (233, 10), (234, 10), (237, 10), (248, 10), (249, 10), (250, 10), (251, 10), (262, 10), (264, 10), (267, 10), (269, 10), (270, 10), (271, 10), (272, 10), (273, 10), (274, 10), (276, 10), (277, 10), (279, 10), (280, 10), (281, 10), (282, 10), (283, 10), (284, 10), (286, 10), (287, 10), (288, 10), (289, 10), (290, 10), (291, 10), (292, 10), (293, 10), (294, 10), (295, 10), (296, 10), (297, 10), (298, 10), (299, 10), (302, 10), (303, 10), (304, 10), (305, 10), (306, 10), (307, 10), (308, 10), (309, 10), (310, 10), (311, 10), (312, 10), (313, 10), (314, 10), (315, 10), (316, 10), (317, 10), (319, 10), (320, 10), (322, 10), (325, 10), (326, 10), (327, 10), (328, 10), (329, 10), (330, 10), (331, 10), (332, 10), (333, 10), (334, 10), (335, 10), (336, 10), (338, 10), (339, 10), (340, 10), (341, 10), (342, 10), (343, 10), (345, 10), (346, 10), (347, 10), (349, 10), (350, 10), (351, 10), (352, 10), (354, 10), (355, 10), (357, 10), (358, 10), (359, 10), (360, 10), (361, 10), (363, 10), (365, 10), (366, 10), (367, 10), (369, 10), (370, 10), (372, 10), (373, 10), (374, 10), (375, 10), (376, 10), (377, 10), (378, 10), (379, 10), (380, 10), (381, 10), (382, 10), (383, 10), (384, 10), (385, 10), (388, 10), (389, 10), (391, 10), (395, 10), (396, 10), (398, 10), (401, 10), (402, 10), (404, 10), (405, 10), (406, 10), (408, 10), (409, 10), (410, 10), (411, 10), (412, 10), (413, 10), (172, 11), (175, 11), (178, 11), (179, 11), (181, 11), (188, 11), (194, 11), (202, 11), (208, 11), (214, 11), (217, 11), (219, 11), (220, 11), (225, 11), (226, 11), (231, 11), (232, 11), (233, 11), (234, 11), (237, 11), (248, 11), (249, 11), (250, 11), (251, 11), (262, 11), (264, 11), (267, 11), (269, 11), (270, 11), (273, 11), (274, 11), (277, 11), (279, 11), (283, 11), (284, 11), (286, 11), (287, 11), (288, 11), (289, 11), (290, 11), (291, 11), (292, 11), (293, 11), (294, 11), (295, 11), (296, 11), (297, 11), (298, 11), (299, 11), (302, 11), (303, 11), (304, 11), (305, 11), (306, 11), (307, 11), (308, 11), (309, 11), (310, 11), (311, 11), (312, 11), (313, 11), (314, 11), (316, 11), (319, 11), (320, 11), (322, 11), (325, 11), (326, 11), (327, 11), (328, 11), (329, 11), (330, 11), (331, 11), (332, 11), (333, 11), (334, 11), (336, 11), (338, 11), (339, 11), (341, 11), (343, 11), (345, 11), (346, 11), (347, 11), (349, 11), (351, 11), (352, 11), (354, 11), (355, 11), (357, 11), (358, 11), (359, 11), (360, 11), (361, 11), (362, 11), (363, 11), (365, 11), (366, 11), (367, 11), (369, 11), (370, 11), (372, 11), (373, 11), (374, 11), (375, 11), (377, 11), (378, 11), (379, 11), (380, 11), (381, 11), (382, 11), (385, 11), (388, 11), (389, 11), (391, 11), (396, 11), (398, 11), (399, 11), (405, 11), (406, 11), (409, 11), (410, 11), (413, 11), (172, 12), (188, 12), (232, 12), (293, 12), (310, 12), (316, 12), (327, 12), (343, 12), (355, 12), (373, 12), (175, 13), (178, 13), (180, 13), (183, 13), (194, 13), (220, 13), (225, 13), (233, 13), (249, 13), (250, 13), (270, 13), (286, 13), (288, 13), (289, 13), (331, 13), (344, 13), (346, 13), (367, 13), (376, 13), (381, 13), (388, 13), (405, 13), (178, 14), (180, 14), (183, 14), (202, 14), (214, 14), (219, 14), (226, 14), (232, 14), (249, 14), (250, 14), (286, 14), (293, 14), (308, 14), (322, 14), (333, 14), (339, 14), (341, 14), (346, 14), (366, 14), (372, 14), (380, 14), (381, 14), (389, 14), (413, 14), (202, 15), (214, 15), (333, 15), (341, 15), (366, 15), (172, 16), (214, 16), (214, 17), (219, 17), (233, 17), (333, 17), (366, 17), (372, 17); -- -------------------------------------------------------- -- -- Table structure for table `radioportable` -- CREATE TABLE IF NOT EXISTS `radioportable` ( `personid` int(11) NOT NULL, `capabilityid` int(11) NOT NULL, PRIMARY KEY (`personid`,`capabilityid`), KEY `fk_pperson` (`personid`), KEY `fk_pcap` (`capabilityid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='radio functionality that a user has available portably'; -- -- Dumping data for table `radioportable` -- INSERT INTO `radioportable` (`personid`, `capabilityid`) VALUES (172, 9), (172, 10), (172, 11), (175, 10), (175, 11), (178, 9), (178, 10), (178, 11), (178, 13), (178, 14), (179, 9), (179, 10), (180, 10), (181, 9), (181, 10), (181, 11), (183, 9), (183, 10), (183, 13), (183, 14), (183, 15), (188, 10), (188, 11), (202, 9), (202, 10), (202, 11), (202, 14), (202, 15), (208, 9), (208, 10), (208, 11), (212, 10), (212, 11), (214, 9), (214, 10), (214, 11), (214, 14), (214, 15), (214, 16), (214, 17), (217, 9), (217, 10), (217, 11), (217, 13), (217, 14), (217, 17), (219, 9), (220, 10), (220, 11), (225, 10), (225, 11), (225, 13), (226, 10), (226, 11), (226, 13), (226, 14), (231, 9), (231, 10), (231, 14), (231, 15), (231, 16), (232, 9), (232, 10), (232, 11), (233, 9), (233, 10), (233, 11), (233, 17), (234, 10), (234, 11), (237, 9), (237, 10), (237, 11), (237, 12), (237, 14), (237, 17), (248, 9), (248, 10), (248, 11), (249, 10), (249, 11), (249, 13), (249, 14), (250, 9), (250, 10), (250, 11), (250, 13), (250, 14), (251, 9), (251, 10), (251, 11), (262, 10), (262, 11), (262, 14), (264, 10), (264, 11), (267, 10), (267, 11), (267, 14), (267, 15), (269, 10), (269, 11), (271, 10), (272, 10), (273, 9), (273, 10), (273, 11), (274, 10), (274, 11), (276, 10), (278, 9), (278, 10), (278, 11), (279, 10), (279, 11), (280, 10), (281, 10), (282, 10), (286, 9), (286, 10), (286, 11), (286, 13), (286, 14), (287, 9), (287, 10), (287, 11), (288, 10), (288, 11), (289, 10), (289, 11), (290, 10), (290, 11), (291, 10), (291, 11), (292, 10), (292, 11), (293, 9), (293, 10), (293, 11), (293, 12), (293, 14), (294, 10), (294, 11), (295, 10), (295, 11), (295, 13), (296, 10), (296, 11), (299, 10), (299, 11), (303, 10), (303, 11), (305, 9), (305, 10), (305, 11), (306, 10), (306, 11), (306, 13), (306, 14), (307, 10), (307, 11), (308, 9), (308, 10), (308, 11), (309, 10), (309, 11), (310, 10), (310, 11), (310, 12), (311, 10), (311, 11), (312, 10), (312, 11), (312, 13), (313, 10), (313, 11), (314, 10), (314, 11), (316, 9), (316, 10), (316, 11), (317, 10), (318, 10), (318, 11), (320, 9), (320, 10), (320, 11), (321, 10), (321, 11), (322, 9), (322, 10), (322, 11), (322, 12), (323, 10), (323, 11), (325, 10), (325, 11), (326, 9), (326, 10), (326, 11), (327, 10), (327, 11), (328, 10), (328, 11), (329, 9), (329, 10), (329, 11), (331, 10), (331, 11), (331, 13), (332, 10), (332, 11), (333, 9), (333, 10), (333, 11), (333, 14), (333, 15), (333, 17), (334, 10), (334, 11), (336, 10), (336, 11), (338, 10), (338, 11), (339, 10), (339, 11), (339, 14), (340, 9), (340, 10), (340, 11), (341, 9), (341, 10), (341, 11), (341, 14), (341, 15), (344, 10), (344, 11), (346, 10), (346, 11), (346, 13), (346, 14), (347, 9), (347, 10), (347, 11), (347, 14), (348, 10), (348, 11), (348, 12), (349, 10), (349, 11), (350, 10), (352, 9), (352, 10), (352, 11), (354, 9), (354, 10), (354, 11), (357, 9), (357, 10), (357, 11), (358, 9), (358, 10), (358, 11), (359, 9), (359, 10), (359, 11), (361, 10), (361, 11), (362, 11), (362, 12), (363, 9), (363, 10), (363, 11), (365, 10), (365, 11), (365, 12), (366, 9), (366, 10), (366, 11), (366, 14), (366, 15), (366, 17), (367, 13), (368, 10), (368, 11), (369, 10), (369, 11), (370, 9), (370, 10), (370, 11), (372, 10), (372, 11), (372, 14), (373, 10), (373, 11), (374, 10), (374, 11), (375, 10), (375, 11), (376, 13), (377, 9), (377, 10), (377, 11), (378, 10), (378, 11), (379, 10), (379, 11), (380, 10), (380, 11), (381, 10), (381, 11), (382, 10), (382, 11), (383, 10), (384, 10), (385, 10), (388, 9), (388, 10), (388, 11), (388, 13), (391, 10), (391, 11), (394, 10), (395, 10), (398, 10), (398, 11), (399, 11), (401, 10), (401, 11), (401, 13), (401, 14), (402, 10), (402, 11), (404, 10), (405, 13), (406, 10), (406, 11), (408, 10), (409, 9), (409, 10), (409, 11), (410, 10), (410, 11), (411, 10), (412, 10), (413, 10), (413, 11); -- -------------------------------------------------------- -- -- Table structure for table `rosters` -- CREATE TABLE IF NOT EXISTS `rosters` ( `report_id` int(11) NOT NULL auto_increment, `reportname` varchar(40) NOT NULL default '' COMMENT 'Name of report to display to user.', `reportcode` varchar(20) NOT NULL default '' COMMENT 'String name to use in db code.', `displayorder` int(3) NOT NULL default '0' COMMENT 'Order to display list to user in pulldowns.', `description` varchar(75) NOT NULL default '' COMMENT 'Description to display to user as help text.', PRIMARY KEY (`report_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of rosters reports to run.' AUTO_INCREMENT=9 ; -- -- Dumping data for table `rosters` -- INSERT INTO `rosters` (`report_id`, `reportname`, `reportcode`, `displayorder`, `description`) VALUES (1, 'Roster', 'contact', 1, 'Address, email, phone numbers.'), (2, 'Capability information', 'capability', 4, 'Radio capability for home/mobile/portable use.'), (3, 'Training information', 'training', 5, 'Courses taken.'), (4, 'Emergency power', 'power', 2, 'Emergency power available at home.'), (5, 'Full listing', 'full', -1, 'All contact, capability, training information.'), (6, 'Stats', 'stats', 7, 'Section statistics by District'), (7, 'Comments', 'comments', 3, 'Name, callsign, comments.'), (8, 'Certification', 'certification', 6, 'List persons who are certified.'); -- -------------------------------------------------------- -- -- Table structure for table `states` -- CREATE TABLE IF NOT EXISTS `states` ( `state_id` int(11) NOT NULL auto_increment, `state` varchar(45) default NULL, `abbrev` varchar(2) default NULL, PRIMARY KEY (`state_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='list of states and abbreviations' AUTO_INCREMENT=53 ; -- -- Dumping data for table `states` -- INSERT INTO `states` (`state_id`, `state`, `abbrev`) VALUES (1, 'Alabama', 'AL'), (2, 'Alaska', 'AK'), (3, 'Arizona', 'AZ'), (4, 'Arkansas', 'AR'), (5, 'California', 'CA'), (6, 'Colorado', 'CO'), (7, 'Connecticut', 'CT'), (8, 'Delaware', 'DE'), (9, 'Florida', 'FL'), (10, 'Georgia', 'GA'), (11, 'Hawaii', 'HI'), (12, 'Idaho', 'ID'), (13, 'Illinois', 'IL'), (14, 'Indiana', 'IN'), (15, 'Iowa', 'IA'), (16, 'Kansas', 'KS'), (17, 'Kentucky', 'KY'), (18, 'Louisiana', 'LA'), (19, 'Maine', 'ME'), (20, 'Maryland', 'MD'), (21, 'Massachusetts', 'MA'), (22, 'Michigan', 'MI'), (23, 'Minnesota', 'MN'), (24, 'Mississippi', 'MS'), (25, 'Missouri', 'MO'), (26, 'Montana', 'MT'), (27, 'Nebraska', 'NE'), (28, 'Nevada', 'NV'), (29, 'New Hampshire', 'NH'), (30, 'New Jersey', 'NJ'), (31, 'New Mexico', 'NM'), (32, 'New York', 'NY'), (33, 'North Carolina', 'NC'), (34, 'North Dakota', 'ND'), (35, 'Ohio', 'OH'), (36, 'Oklahoma', 'OK'), (37, 'Oregon', 'OR'), (38, 'Pennsylvania', 'PA'), (39, 'Rhode Island', 'RI'), (40, 'South Carolina', 'SC'), (41, 'South Dakota', 'SD'), (42, 'Tennessee', 'TN'), (43, 'Texas', 'TX'), (44, 'Utah', 'UT'), (45, 'Vermont', 'VT'), (46, 'Virginia', 'VA'), (47, 'Washington', 'WA'), (48, 'West Virginia', 'WV'), (49, 'Wisconsin', 'WI'), (50, 'Wyoming', 'WY'), (51, 'District of Columbia', 'DC'), (52, 'Puerto Rico', 'PR'); -- -------------------------------------------------------- -- -- Table structure for table `titles` -- CREATE TABLE IF NOT EXISTS `titles` ( `title_id` int(11) NOT NULL auto_increment COMMENT 'id/key', `title` varchar(25) NOT NULL default '' COMMENT 'text of title', `ranksort` int(4) NOT NULL COMMENT 'rank sort order', `presentsort` int(4) NOT NULL COMMENT 'presentation sort order', `shortform` varchar(10) NOT NULL default '' COMMENT 'Abbreviation to use in rosters.', PRIMARY KEY (`title_id`), UNIQUE KEY `ranksort` (`ranksort`), UNIQUE KEY `presentsort` (`presentsort`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of Titles used in Section.' AUTO_INCREMENT=14 ; -- -- Dumping data for table `titles` -- INSERT INTO `titles` (`title_id`, `title`, `ranksort`, `presentsort`, `shortform`) VALUES (1, 'SEC', 100, 22, 'SEC'), (2, 'DEC', 200, 23, 'DEC'), (3, 'EC', 300, 24, 'EC'), (4, 'ASEC Operations', 101, 26, 'ASEC Ops'), (5, 'ASEC Arches', 102, 27, 'ASEC Ar'), (6, 'ASEC Digital', 103, 28, 'ASEC Dig'), (7, 'ASEC HF Nets', 104, 29, 'ASEC HF'), (8, 'ASEC Logistics', 105, 30, 'ASEC Log'), (9, 'ASEC Task Force Ops', 106, 31, 'ASEC TFO'), (10, 'ASEC Web', 107, 32, 'ASEC Web'), (11, 'ASEC Other', 108, 33, 'ASEC Oth'), (12, 'ARES Member', 500, 21, 'Member'), (13, 'AEC', 301, 25, 'AEC'); -- -------------------------------------------------------- -- -- Table structure for table `training` -- CREATE TABLE IF NOT EXISTS `training` ( `personid` int(11) NOT NULL, `courseid` int(11) NOT NULL, `certified` tinyint(1) NOT NULL default '0' COMMENT 'completion of this course has been certified with documentation', PRIMARY KEY (`personid`,`courseid`), KEY `fk_pid` (`personid`), KEY `fk_cidx` (`courseid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='intersection table to link persons with courses'; -- -- Dumping data for table `training` -- INSERT INTO `training` (`personid`, `courseid`, `certified`) VALUES (172, 1, 0), (172, 2, 0), (172, 3, 0), (172, 4, 0), (172, 5, 0), (172, 6, 0), (175, 1, 0), (175, 2, 0), (175, 3, 0), (175, 4, 0), (175, 5, 0), (175, 6, 0), (178, 2, 0), (178, 3, 0), (178, 4, 0), (178, 6, 0), (179, 2, 0), (179, 3, 0), (179, 4, 0), (179, 5, 0), (179, 6, 0), (179, 7, 0), (180, 2, 0), (180, 3, 0), (180, 4, 0), (180, 5, 0), (180, 6, 0), (181, 2, 0), (181, 3, 0), (181, 4, 0), (181, 5, 0), (181, 6, 0), (183, 1, 0), (183, 2, 0), (183, 3, 0), (188, 1, 0), (188, 6, 0), (194, 2, 0), (194, 3, 0), (194, 4, 0), (194, 5, 0), (194, 6, 0), (195, 1, 0), (195, 2, 0), (195, 3, 0), (195, 5, 0), (195, 6, 0), (200, 1, 0), (200, 2, 0), (200, 3, 0), (200, 4, 0), (200, 5, 0), (200, 6, 0), (202, 1, 0), (202, 2, 0), (202, 3, 0), (202, 4, 0), (202, 5, 0), (202, 6, 0), (208, 2, 0), (208, 3, 0), (208, 4, 0), (208, 6, 0), (212, 6, 0), (214, 1, 0), (214, 2, 0), (214, 3, 0), (214, 4, 0), (214, 5, 0), (214, 6, 0), (217, 2, 0), (217, 3, 0), (217, 4, 0), (217, 5, 0), (217, 6, 0), (219, 2, 0), (219, 3, 0), (219, 4, 0), (220, 2, 0), (220, 3, 0), (220, 4, 0), (220, 5, 0), (220, 6, 0), (225, 2, 0), (225, 3, 0), (225, 4, 0), (225, 5, 0), (225, 6, 0), (226, 1, 0), (226, 2, 0), (226, 6, 0), (231, 1, 0), (231, 2, 0), (231, 3, 0), (231, 4, 0), (231, 5, 0), (231, 6, 0), (232, 1, 0), (232, 6, 0), (233, 1, 0), (233, 2, 0), (233, 3, 0), (233, 4, 0), (233, 5, 0), (234, 1, 0), (234, 2, 0), (234, 3, 0), (234, 4, 0), (234, 5, 0), (237, 2, 0), (237, 3, 0), (237, 4, 0), (237, 5, 0), (237, 6, 0), (248, 1, 0), (248, 2, 0), (248, 3, 0), (248, 4, 0), (248, 6, 0), (249, 1, 0), (249, 2, 0), (249, 3, 0), (249, 4, 0), (249, 5, 0), (249, 6, 0), (250, 1, 0), (250, 2, 0), (250, 3, 0), (250, 4, 0), (250, 5, 0), (250, 6, 0), (251, 1, 0), (251, 2, 0), (251, 3, 0), (251, 4, 0), (251, 6, 0), (262, 4, 0), (264, 2, 0), (264, 3, 0), (264, 4, 0), (264, 5, 0), (264, 6, 0), (266, 2, 0), (266, 3, 0), (266, 4, 0), (266, 5, 0), (266, 6, 0), (267, 6, 0), (270, 6, 0), (271, 2, 0), (271, 3, 0), (271, 4, 0), (271, 5, 0), (271, 6, 0), (272, 2, 0), (272, 3, 0), (272, 4, 0), (272, 5, 0), (273, 2, 0), (273, 3, 0), (273, 4, 0), (274, 2, 0), (274, 3, 0), (274, 4, 0), (274, 5, 0), (274, 6, 0), (276, 6, 0), (279, 2, 0), (279, 3, 0), (279, 4, 0), (279, 5, 0), (279, 6, 0), (282, 6, 0), (283, 6, 0), (285, 6, 0), (286, 1, 0), (286, 2, 0), (286, 6, 0), (287, 1, 0), (287, 2, 0), (287, 3, 0), (287, 4, 0), (287, 5, 0), (287, 6, 0), (288, 1, 0), (288, 2, 0), (288, 3, 0), (288, 4, 0), (288, 5, 0), (288, 6, 0), (288, 7, 0), (289, 1, 0), (289, 2, 0), (289, 3, 0), (289, 4, 0), (289, 5, 0), (289, 6, 0), (289, 7, 0), (290, 1, 0), (290, 2, 0), (290, 3, 0), (290, 6, 0), (291, 2, 0), (291, 3, 0), (291, 4, 0), (291, 5, 0), (291, 6, 0), (293, 2, 0), (293, 3, 0), (293, 4, 0), (293, 5, 0), (293, 6, 0), (294, 1, 0), (294, 2, 0), (294, 3, 0), (294, 4, 0), (294, 5, 0), (294, 6, 0), (294, 7, 0), (295, 1, 0), (295, 2, 0), (295, 3, 0), (295, 4, 0), (295, 5, 0), (295, 6, 0), (296, 2, 0), (296, 6, 0), (297, 1, 0), (297, 2, 0), (297, 3, 0), (297, 4, 0), (297, 5, 0), (297, 6, 0), (298, 1, 0), (298, 2, 0), (298, 3, 0), (298, 4, 0), (298, 5, 0), (298, 6, 0), (298, 7, 0), (301, 2, 0), (301, 3, 0), (301, 4, 0), (301, 5, 0), (302, 1, 0), (302, 2, 0), (302, 3, 0), (302, 4, 0), (302, 5, 0), (303, 1, 0), (303, 2, 0), (303, 3, 0), (303, 4, 0), (303, 5, 0), (303, 6, 0), (304, 2, 0), (304, 3, 0), (304, 4, 0), (304, 5, 0), (304, 6, 0), (306, 2, 0), (306, 3, 0), (306, 4, 0), (306, 5, 0), (306, 6, 0), (307, 1, 0), (307, 2, 0), (307, 3, 0), (307, 4, 0), (307, 5, 0), (307, 6, 0), (308, 2, 0), (308, 3, 0), (308, 4, 0), (308, 5, 0), (308, 6, 0), (309, 2, 0), (309, 6, 0), (310, 2, 0), (310, 3, 0), (310, 4, 0), (310, 5, 0), (312, 2, 0), (312, 3, 0), (312, 4, 0), (312, 5, 0), (312, 6, 0), (313, 1, 0), (313, 2, 0), (313, 3, 0), (313, 4, 0), (313, 5, 0), (313, 6, 0), (314, 1, 0), (314, 2, 0), (314, 3, 0), (314, 4, 0), (314, 5, 0), (314, 6, 0), (314, 7, 0), (315, 6, 0), (316, 1, 0), (316, 2, 0), (316, 3, 0), (316, 4, 0), (316, 5, 0), (316, 6, 0), (317, 2, 0), (317, 3, 0), (317, 4, 0), (317, 5, 0), (317, 6, 0), (318, 1, 0), (318, 2, 0), (318, 3, 0), (318, 4, 0), (319, 2, 0), (319, 3, 0), (319, 4, 0), (319, 5, 0), (319, 6, 0), (320, 2, 0), (320, 3, 0), (320, 4, 0), (320, 5, 0), (320, 6, 0), (321, 2, 0), (321, 3, 0), (321, 4, 0), (321, 5, 0), (321, 6, 0), (322, 2, 0), (322, 3, 0), (322, 4, 0), (322, 5, 0), (323, 2, 0), (324, 2, 0), (324, 3, 0), (324, 4, 0), (324, 5, 0), (325, 1, 0), (325, 2, 0), (325, 3, 0), (325, 4, 0), (325, 5, 0), (325, 6, 0), (326, 2, 0), (326, 3, 0), (326, 4, 0), (326, 5, 0), (327, 2, 0), (327, 3, 0), (327, 4, 0), (327, 5, 0), (327, 6, 0), (328, 2, 0), (328, 3, 0), (328, 4, 0), (328, 5, 0), (328, 6, 0), (329, 1, 0), (329, 2, 0), (329, 3, 0), (329, 4, 0), (329, 5, 0), (329, 6, 0), (330, 2, 0), (330, 3, 0), (330, 4, 0), (330, 5, 0), (330, 6, 0), (331, 2, 0), (331, 3, 0), (331, 4, 0), (332, 2, 0), (332, 3, 0), (332, 4, 0), (332, 5, 0), (332, 6, 0), (333, 2, 0), (333, 3, 0), (333, 4, 0), (333, 5, 0), (333, 6, 0), (334, 2, 0), (334, 3, 0), (334, 4, 0), (334, 5, 0), (338, 2, 0), (338, 3, 0), (339, 2, 0), (339, 3, 0), (339, 4, 0), (339, 5, 0), (340, 1, 0), (340, 2, 0), (340, 3, 0), (340, 4, 0), (340, 5, 0), (340, 6, 0), (341, 1, 0), (341, 2, 0), (341, 3, 0), (341, 4, 0), (341, 5, 0), (341, 6, 0), (342, 2, 0), (342, 3, 0), (342, 4, 0), (342, 5, 0), (342, 6, 0), (343, 2, 0), (343, 3, 0), (343, 4, 0), (343, 5, 0), (343, 6, 0), (344, 2, 0), (345, 2, 0), (345, 3, 0), (345, 4, 0), (345, 5, 0), (345, 6, 0), (346, 2, 0), (346, 3, 0), (346, 4, 0), (346, 5, 0), (346, 6, 0), (347, 2, 0), (347, 3, 0), (347, 4, 0), (347, 5, 0), (347, 6, 0), (348, 2, 0), (348, 6, 0), (349, 2, 0), (349, 3, 0), (349, 4, 0), (349, 5, 0), (350, 2, 0), (350, 3, 0), (350, 4, 0), (350, 5, 0), (352, 2, 0), (352, 3, 0), (352, 4, 0), (352, 5, 0), (354, 2, 0), (354, 3, 0), (354, 4, 0), (354, 5, 0), (355, 1, 0), (355, 2, 0), (355, 3, 0), (355, 4, 0), (355, 5, 0), (355, 6, 0), (356, 1, 0), (356, 2, 0), (356, 3, 0), (356, 4, 0), (356, 5, 0), (356, 6, 0), (357, 2, 0), (357, 6, 0), (358, 1, 0), (358, 2, 0), (358, 3, 0), (358, 4, 0), (358, 5, 0), (358, 6, 0), (359, 2, 0), (359, 6, 0), (360, 2, 0), (360, 3, 0), (360, 4, 0), (360, 5, 0), (360, 6, 0), (361, 2, 0), (361, 3, 0), (361, 4, 0), (362, 2, 0), (362, 4, 0), (362, 6, 0), (363, 2, 0), (363, 3, 0), (363, 4, 0), (363, 5, 0), (363, 6, 0), (365, 2, 0), (365, 3, 0), (365, 4, 0), (365, 6, 0), (366, 1, 0), (366, 2, 0), (366, 3, 0), (366, 4, 0), (366, 5, 0), (366, 6, 0), (366, 7, 0), (367, 6, 0), (369, 2, 0), (369, 3, 0), (369, 4, 0), (369, 5, 0), (369, 6, 0), (370, 2, 0), (370, 3, 0), (370, 4, 0), (370, 5, 0), (371, 2, 0), (371, 6, 0), (372, 2, 0), (372, 3, 0), (372, 4, 0), (372, 5, 0), (372, 6, 0), (373, 1, 0), (373, 2, 0), (373, 3, 0), (373, 4, 0), (373, 5, 0), (373, 6, 0), (374, 4, 0), (374, 6, 0), (375, 1, 0), (375, 2, 0), (375, 3, 0), (375, 4, 0), (375, 5, 0), (375, 6, 0), (378, 2, 0), (378, 3, 0), (378, 4, 0), (378, 6, 0), (379, 2, 0), (379, 3, 0), (379, 4, 0), (379, 5, 0), (379, 6, 0), (380, 1, 0), (380, 2, 0), (380, 3, 0), (380, 4, 0), (380, 5, 0), (380, 6, 0), (381, 1, 0), (381, 2, 0), (381, 3, 0), (381, 4, 0), (381, 5, 0), (381, 6, 0), (382, 3, 0), (382, 4, 0), (386, 2, 0), (386, 3, 0), (386, 4, 0), (386, 5, 0), (386, 6, 0), (388, 6, 0), (389, 2, 0), (389, 6, 0), (391, 2, 0), (391, 3, 0), (391, 4, 0), (391, 5, 0), (391, 6, 0), (392, 6, 0), (393, 2, 0), (393, 4, 0), (395, 6, 0), (396, 6, 0), (398, 2, 0), (398, 3, 0), (398, 4, 0), (398, 5, 0), (399, 2, 0), (399, 6, 0), (401, 2, 0), (401, 3, 0), (401, 4, 0), (401, 5, 0), (402, 6, 0), (403, 2, 0), (403, 4, 0), (404, 1, 0), (404, 2, 0), (404, 3, 0), (404, 4, 0), (404, 5, 0), (404, 6, 0), (405, 1, 0), (405, 2, 0), (405, 3, 0), (405, 4, 0), (405, 5, 0), (405, 6, 0), (406, 2, 0), (406, 3, 0), (406, 5, 0), (406, 6, 0), (407, 2, 0), (407, 4, 0), (408, 2, 0), (408, 3, 0), (408, 4, 0), (408, 5, 0), (409, 2, 0), (409, 3, 0), (409, 4, 0), (409, 5, 0), (409, 6, 0), (410, 4, 0), (411, 2, 0), (411, 4, 0), (411, 6, 0), (412, 2, 0), (412, 4, 0), (412, 6, 0), (413, 2, 0), (413, 6, 0); -- -- Constraints for dumped tables -- -- -- Constraints for table `authorization` -- ALTER TABLE `authorization` ADD CONSTRAINT `authorization_ibfk_4` FOREIGN KEY (`personid`) REFERENCES `person` (`person_id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `auxcounty` -- ALTER TABLE `auxcounty` ADD CONSTRAINT `fk_county` FOREIGN KEY (`countyid`) REFERENCES `counties` (`county_id`) ON DELETE NO ACTION ON UPDATE CASCADE, ADD CONSTRAINT `fk_person` FOREIGN KEY (`personid`) REFERENCES `person` (`person_id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `counties` -- ALTER TABLE `counties` ADD CONSTRAINT `counties_ibfk_1` FOREIGN KEY (`districtid`) REFERENCES `districts` (`district_id`) ON UPDATE CASCADE; -- -- Constraints for table `documents` -- ALTER TABLE `documents` ADD CONSTRAINT `documents_ibfk_2` FOREIGN KEY (`personid`) REFERENCES `person` (`person_id`) ON DELETE NO ACTION ON UPDATE CASCADE; -- -- Constraints for table `equipment` -- ALTER TABLE `equipment` ADD CONSTRAINT `equipment_ibfk_1` FOREIGN KEY (`countyid`) REFERENCES `counties` (`county_id`) ON UPDATE CASCADE; -- -- Constraints for table `person` -- ALTER TABLE `person` ADD CONSTRAINT `fk_countyid` FOREIGN KEY (`countyid`) REFERENCES `counties` (`county_id`) ON DELETE NO ACTION ON UPDATE CASCADE, ADD CONSTRAINT `fk_districtid` FOREIGN KEY (`districtid`) REFERENCES `districts` (`district_id`) ON DELETE NO ACTION ON UPDATE CASCADE, ADD CONSTRAINT `fk_titleid` FOREIGN KEY (`titleid`) REFERENCES `titles` (`title_id`) ON DELETE NO ACTION ON UPDATE CASCADE; -- -- Constraints for table `radiohome` -- ALTER TABLE `radiohome` ADD CONSTRAINT `fk_hcap` FOREIGN KEY (`capabilityid`) REFERENCES `capability` (`capability_id`) ON DELETE NO ACTION ON UPDATE CASCADE, ADD CONSTRAINT `fk_hperson` FOREIGN KEY (`personid`) REFERENCES `person` (`person_id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `radiomobile` -- ALTER TABLE `radiomobile` ADD CONSTRAINT `fk_mcap` FOREIGN KEY (`capabilityid`) REFERENCES `capability` (`capability_id`) ON DELETE NO ACTION ON UPDATE CASCADE, ADD CONSTRAINT `fk_mperson` FOREIGN KEY (`personid`) REFERENCES `person` (`person_id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `radioportable` -- ALTER TABLE `radioportable` ADD CONSTRAINT `fk_pcap` FOREIGN KEY (`capabilityid`) REFERENCES `capability` (`capability_id`) ON DELETE NO ACTION ON UPDATE CASCADE, ADD CONSTRAINT `fk_pperson` FOREIGN KEY (`personid`) REFERENCES `person` (`person_id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `training` -- ALTER TABLE `training` ADD CONSTRAINT `fk_cidx` FOREIGN KEY (`courseid`) REFERENCES `courses` (`course_id`) ON DELETE NO ACTION ON UPDATE CASCADE, ADD CONSTRAINT `fk_pid` FOREIGN KEY (`personid`) REFERENCES `person` (`person_id`) ON DELETE CASCADE ON UPDATE CASCADE;