wsCenTgr

1DROP TABLE IF EXISTS `rp_government_roles`;
2CREATE TABLE `rp_government_roles` (
3  `id` int(11) NOT NULL AUTO_INCREMENT,
4  `role_id` int(1) DEFAULT '1',
5  `title` varchar(90) DEFAULT NULL,
6  `department` varchar(90) DEFAULT NULL,
7  `role_type` enum('top_dogs','senior_ministers','junior_ministers') DEFAULT 'senior_ministers',
8  PRIMARY KEY (`id`)
9) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
10
11-- ----------------------------
12-- Records of rp_government_roles
13-- ----------------------------
14INSERT INTO `rp_government_roles` VALUES ('1', '1', 'Minister of State for Research and Skill.', 'Department of Education', 'junior_ministers');
15INSERT INTO `rp_government_roles` VALUES ('2', '2', 'Minister of State for Communities and Urban Development.', 'TBA', 'junior_ministers');
16INSERT INTO `rp_government_roles` VALUES ('3', '3', 'Minister of State for Customs and Economic Development', 'Department of Treasury and Finance ', 'junior_ministers');
17INSERT INTO `rp_government_roles` VALUES ('4', '4', 'Minister of State for Interior and Rural affairs ', 'Department of Energy, Transportation and Infrastructure', 'junior_ministers');
18INSERT INTO `rp_government_roles` VALUES ('5', '5', 'Minister of State for Intelligence and Justice ', 'Department of Security and Intelligence', 'junior_ministers');
19INSERT INTO `rp_government_roles` VALUES ('6', '6', 'Minister of State for Human Services ', 'Department of Health and Social Welfare', 'junior_ministers');
20INSERT INTO `rp_government_roles` VALUES ('7', '7', 'Minister of State for Trade and Industry', 'Department of Business, Labor and Trade', 'junior_ministers');
21INSERT INTO `rp_government_roles` VALUES ('8', '1', 'Secretary of State for Education.', 'Department of Education', 'senior_ministers');
22INSERT INTO `rp_government_roles` VALUES ('9', '2', 'Secretary of State for Treasury and Finance', 'Department of Treasury and Finance ', 'senior_ministers');
23INSERT INTO `rp_government_roles` VALUES ('10', '3', '\r\nSecretary of State for Energy, Transportation and Infrastructure', 'Department of Energy, Transportation and Infrastructure', 'senior_ministers');
24INSERT INTO `rp_government_roles` VALUES ('11', '4', 'Secretary of State for Security and Intelligence', 'Department of Security and Intelligence', 'senior_ministers');
25INSERT INTO `rp_government_roles` VALUES ('12', '5', 'Secretary of State for Health and Social Welfare', 'Department of Health and Social Welfare', 'senior_ministers');
26INSERT INTO `rp_government_roles` VALUES ('13', '6', 'Secretary of State for Business, Labor and Trade', 'Department of Business, Labor and Trade', 'senior_ministers');
27INSERT INTO `rp_government_roles` VALUES ('14', '1', 'Prime Minister', 'His Majesty’s Government', 'top_dogs');
28INSERT INTO `rp_government_roles` VALUES ('15', '2', 'The Crown', 'His Majesty, The King of Hamptonside', 'top_dogs');