DdshW8eE

1-- ----------------------------
2-- Table structure for `Divisions`
3-- ----------------------------
4DROP TABLE IF EXISTS `Divisions`;
5CREATE TABLE `Divisions` (
6  `ID` int(11) NOT NULL AUTO_INCREMENT,
7  `Name` varchar(255) NOT NULL,
8  `ApplicationsOpen` int(11) NOT NULL DEFAULT '0',
9  `PublicApplications` int(11) NOT NULL DEFAULT '0',
10  `Description` text NOT NULL,
11  `Position` int(11) NOT NULL,
12  `HasTeamspeakRank` int(11) NOT NULL,
13  `TeamspeakRank` int(11) NOT NULL,
14  PRIMARY KEY (`ID`)
15) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
16
17-- ----------------------------
18-- Records of Divisions
19-- ----------------------------
20INSERT INTO `Divisions` VALUES ('2', 'Emergency Response Unit', '0', '0', 'This is a default division', '2', '1', '10905');
21INSERT INTO `Divisions` VALUES ('3', 'Taskforce', '0', '0', 'This is a default division', '3', '1', '10906');
22INSERT INTO `Divisions` VALUES ('4', 'Operational Firearms Unit', '0', '0', 'This is a default division', '4', '1', '10907');
23INSERT INTO `Divisions` VALUES ('5', 'Crime and Operations Command', '0', '0', 'This is a default division', '5', '1', '10965');
24INSERT INTO `Divisions` VALUES ('6', 'Roads Policing Unit', '0', '0', 'This is a default division.', '10', '1', '10908');