-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `damoeba_profiles`
--
CREATE DATABASE IF NOT EXISTS `damoeba_profiles` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `damoeba_profiles`;

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

--
-- Table structure for table `resumes`
--

CREATE TABLE IF NOT EXISTS `resumes` (
  `id` int(10) UNSIGNED DEFAULT NULL,
  `profile_id` int(10) UNSIGNED NOT NULL,
  `total_exp` tinyint(2) UNSIGNED DEFAULT NULL,
  `profile_title` varchar(128) DEFAULT NULL,
  `filename` varchar(255) NOT NULL,
  `resume` mediumtext NOT NULL,
  `location` varchar(128) DEFAULT NULL,
  `primary_skills` varchar(255) DEFAULT NULL,
  `state_id` smallint(5) UNSIGNED DEFAULT NULL,
  `emp_type_id` int(10) DEFAULT NULL,
  `visa_type_id` int(10) DEFAULT NULL,
  `in_place` tinyint(1) NOT NULL DEFAULT '0',
  `in_block_list` tinyint(1) DEFAULT NULL,
  `in_hotlist` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`profile_id`),
  KEY `total_exp` (`total_exp`),
  KEY `emp_type_id` (`emp_type_id`),
  KEY `visa_type_id` (`visa_type_id`),
  KEY `created_at` (`created_at`),
  KEY `in_place` (`in_place`),
  KEY `in_block_list` (`in_block_list`),
  KEY `in_hotlist` (`in_hotlist`),
  KEY `profile_title` (`profile_title`),
  KEY `primary_skills` (`primary_skills`),
  KEY `state_id` (`state_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



--
-- Indexes for dumped tables
--

--
-- Indexes for table `resumes`
--
ALTER TABLE `resumes` ADD FULLTEXT KEY `resume` (`resume`);
COMMIT;

