-- http://www.phpmyadmin.net
--




--
-- Database: `tmiva_2baccessible`
--

-- --------------------------------------------------------

--
-- Table structure for table `contacts`
--

CREATE TABLE IF NOT EXISTS `contacts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `first_name` varchar(50) NOT NULL DEFAULT '',
  `last_name` varchar(50) NOT NULL DEFAULT '',
  `address_1` varchar(70) NOT NULL DEFAULT '',
  `address_2` varchar(70) NOT NULL DEFAULT '',
  `city` varchar(70) NOT NULL DEFAULT '',
  `state` char(2) NOT NULL DEFAULT '',
  `zip` smallint(5) unsigned NOT NULL DEFAULT '0',
  `timezone` enum('Eastern Standard Time','Central Standard Time (-1 Hour)','Mountain Standard Time (-2 Hour)','Pacific Standard Time (-3 Hour)','Alaskan Time (-4 Hours)','Hawaii-Aleutian (-5 Hours)') NOT NULL DEFAULT 'Eastern Standard Time',
  `phone_1` bigint(10) unsigned NOT NULL DEFAULT '0',
  `phone_2` bigint(10) unsigned NOT NULL DEFAULT '0',
  `email` varchar(70) NOT NULL DEFAULT '',
  `website` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

--
-- Dumping data for table `contacts`
--

INSERT INTO `contacts` (`id`, `first_name`, `last_name`, `address_1`, `address_2`, `city`, `state`, `zip`, `timezone`, `phone_1`, `phone_2`, `email`, `website`) VALUES
(3, 'Josh', 'West', 'asdf', 'asdf', 'asdf', 'Al', 0, 'Eastern Standard Time', 5402465674, 0, 'josh3dmaker@yahoo.com', ''),
(4, 'Bob', 'Fest', 'asdf', 'asdf', 'asdf', 'Al', 0, 'Eastern Standard Time', 2147483647, 0, 'asdfasdfa@yahoo.com', 'http://www.tmiva.com/'),
(5, 'Wil', 'Schmitts', '567 Somewhere Lane', 'Apt 1441', 'Arlington', 'VA', 22202, 'Eastern Standard Time', 7035054555, 7035555555, 'wil@here.com', 'www.somewebsite.net'),
(6, 'Marc', 'Wehbi', '', '', '', 'Al', 0, 'Eastern Standard Time', 2147483647, 0, 'marc@tmiva.com', 'http://'),
(7, 'Marc', 'Wehbi', '', '', '', 'Al', 0, 'Eastern Standard Time', 2147483647, 0, 'testingemail@gmail.com', 'http://'),
(8, 'Joshua', 'West', '1600 S. Joyce St.', 'Apt. 1411', 'Arlington', 'Vi', 22202, 'Eastern Standard Time', 2147483647, 2147483647, 'joshmaker@gmail.com', 'www.tmiva.com'),
(9, 'Glenn', 'Smith', '', '', '', 'Al', 0, 'Eastern Standard Time', 2147483647, 0, 'Glenn@vssi.biz', 'http://'),
(10, 'Josh', 'West', 'address_1', 'address_2', 'city', 'Al', 0, 'Eastern Standard Time', 1, 2, 'example@example.com', 'http://');

-- --------------------------------------------------------

--
-- Table structure for table `courses`
--

CREATE TABLE IF NOT EXISTS `courses` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '',
  `number` int(11) NOT NULL DEFAULT '0',
  `description` text NOT NULL,
  `date` int(11) NOT NULL DEFAULT '0',
  `length` int(11) NOT NULL DEFAULT '0',
  `teacher` varchar(255) NOT NULL DEFAULT '0',
  `cost` int(11) NOT NULL DEFAULT '0',
  `enrolled_students` smallint(5) unsigned NOT NULL DEFAULT '0',
  `max_students` smallint(5) unsigned NOT NULL DEFAULT '0',
  `prerequesites` text NOT NULL,
  `type` enum('browsing','developing') NOT NULL DEFAULT 'browsing',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;

--
-- Dumping data for table `courses`
--

INSERT INTO `courses` (`id`, `title`, `number`, `description`, `date`, `length`, `teacher`, `cost`, `enrolled_students`, `max_students`, `prerequesites`, `type`) VALUES
(4, 'Its the final countdown', 111, 'tudududuuuuuuutuuuuuuuuuuu', 1217304001, 4, 'Glenn Smith', 500, 0, 50, '', 'browsing'),
(3, 'Solving the Mystery of Web Access', 101, 'A course that will make assistive technology Web users of the very basics to look for when learning about the Web', 1208145601, 60, 'Glenn Smith', 5, 3, 10, '', 'browsing'),
(6, 'JAWS for Windows Basics', 201, 'learn the basics of JAWS. How to set speech rate, volumne, set your verbosity, your graphics settings, and the html settings for the Internet.', 1208664001, 0, 'Glenn Smith', 0, 0, 5, '', 'browsing'),
(14, 'Glenn''s Wisdom', 301, 'A brief course on how to use the Internet', 1208750401, 1, 'Glenn', 25, 0, 1, '', 'browsing'),
(15, 'How to Play the Guitar', 101, 'Learn to play the guitar', 1230699601, 0, 'Jimmy Hendrix', 1000, 10, 10, '', 'developing'),
(16, 'PHP Is Fun', 201, 'This is a great class.', 1211256001, 0, 'Glenn Smith', 100, 0, 0, '', 'developing');

-- --------------------------------------------------------

--
-- Table structure for table `users_courses`
--

CREATE TABLE IF NOT EXISTS `users_courses` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT '0',
  `course_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `users_type`
--

CREATE TABLE IF NOT EXISTS `users_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `users_type`
--

INSERT INTO `users_type` (`id`, `name`) VALUES
(1, 'Disabled User'),
(2, 'Developer'),
(3, 'Teacher'),
(4, 'Administrator');

-- --------------------------------------------------------

--
-- Table structure for table `websites`
--

CREATE TABLE IF NOT EXISTS `websites` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(65) NOT NULL DEFAULT '',
  `url` varchar(65) NOT NULL DEFAULT '',
  `score` smallint(5) unsigned NOT NULL DEFAULT '0',
  `profile` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `websites`
--

INSERT INTO `websites` (`id`, `name`, `url`, `score`, `profile`) VALUES
(1, 'Highsoftware Inc.', 'www.hisoftware.com', 85, 'Founded in 1998, HiSoftware is a leading provider of software, services, and On-Demand solutions that test, repair, monitor and enforce audited Web content, quality, and regulatory compliance. The company’s solutions empower content developers, Web site architects, and executives to work collaboratively to create and manage corporate Web standards for accessibility, financial banking compliance, privacy, operational security, search engine optimization (SEO), site quality and performance, and application transaction testing.'),
(2, 'Humanware Inc.', 'www.humanware.com', 86, 'Focused on enhancing the lives of people with visual and learning disabilities, HumanWare provides intuitive, intelligent solutions that enable their customers to participate effectively in today''s information intensive and highly mobile society.\r\n\r\nWith its integrated marketing, production and R&D operations in Canada and established sales offices in the United States, the United Kingdom, Europe and Australia, and strong distribution networks throughout North America, Asia and the Middle East, Europe and Australasia, HumanWare is truly a global company.'),
(6, 'Freedom Scientific', 'www.freedomscientific.com', 59, 'Freedom Scientific is the world&rsquo;s leader in technology-based solutions for people with visual impairments. Our low vision products are designed to improve the lives of those whose eyesight is diminished to any degree and for any reason, including: diabetes, macular degeneration, glaucoma, cataracts, and retinitis pigmentosa. Freedom Scientific has also developed leading-edge products that enable the blind to have complete access to information and computing. In addition, Freedom Scientific is a leading developer of products specifically designed to assist persons with reading-related learning challenges. Freedom Scientific&rsquo;s products help people stay active, remain independent, and live better.\r\n\r\nFreedom Scientific is a privately-held company. It has offices in Florida, California, and Switzerland and distributors in 56 countries. Approximately one in four of Freedom Scientific&rsquo;s employees has a visual impairment. These employees work in virtually every facet of the Company’s operations — technical support, product testing, development, sales (both inside and outside), customer service, quality assurance, and product management.'),
(4, 'Ai Squared', 'www.aisquared.com', 40, 'Ai Squared has been a leader in the assistive technology field for 18 years. The company''s flagship product, ZoomText, is the world''s best magnification and reading software for the vision impaired. Ai Squared prides itself on delivering the highest quality software products and superior technical support.\r\n\r\nLocated in the heart of Vermont''s green mountains, in the picturesque village of Manchester Center, Ai Squared has grown from a one-man operation into a team dedicated to providing accessibility solutions for all low-vision computer users.');

