 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `jobs` (
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
-  `privilege` tinyint(3) unsigned DEFAULT '0',
   `title` varchar(50) NOT NULL,
   `company` varchar(50) NOT NULL COMMENT 'todo: use company_id FK instead',
-  `base_at` varchar(50) NOT NULL,
+  `location` varchar(50) NOT NULL,
   `content` text NOT NULL,
+  `rank` tinyint(3) unsigned DEFAULT '0',
   `hits` smallint(5) unsigned DEFAULT '0',
   `expired_at` datetime DEFAULT NULL,
   `created_at` datetime DEFAULT NULL,

  `user_id` int(10) unsigned NOT NULL,
  `question_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;


  `target_id` int(10) unsigned NOT NULL,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
