<commit_before>
-- -----------------------------------------------------
-- Table `AD_DEVICE`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `AD_DEVICE` (
  `ANDROID_DEVICE_ID` VARCHAR(45) NOT NULL ,
  `GCM_TOKEN` VARCHAR(45) NULL DEFAULT NULL ,
  `DEVICE_INFO` VARCHAR(500) NULL DEFAULT NULL ,
  `IMEI` VARCHAR(45) NULL DEFAULT NULL ,
  `IMSI` VARCHAR(45) NULL DEFAULT NULL ,
  `OS_VERSION` VARCHAR(45) NULL DEFAULT NULL ,
  `DEVICE_MODEL` VARCHAR(45) NULL DEFAULT NULL ,
  `VENDOR` VARCHAR(45) NULL DEFAULT NULL ,
  `LATITUDE` VARCHAR(45) NULL DEFAULT NULL,
  `LONGITUDE` VARCHAR(45) NULL DEFAULT NULL,
  `SERIAL` VARCHAR(45) NULL DEFAULT NULL,
  `MAC_ADDRESS` VARCHAR(45) NULL DEFAULT NULL,
  `DEVICE_NAME` VARCHAR(100) NULL DEFAULT NULL,
  PRIMARY KEY (`ANDROID_DEVICE_ID`) );

-- -----------------------------------------------------
-- Table `AD_FEATURE`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `AD_FEATURE` (
  `ID` INT NOT NULL AUTO_INCREMENT ,
  `CODE` VARCHAR(45) NOT NULL,
  `NAME` VARCHAR(100) NULL ,
  `DESCRIPTION` VARCHAR(200) NULL ,
  PRIMARY KEY (`ID`) );


-- -----------------------------------------------------
-- TODO remove this later
-- -----------------------------------------------------

INSERT INTO AD_FEATURE (CODE, NAME, DESCRIPTION)
VALUES
('DEVICE_LOCK', 'DEVICE_LOCK', 'Lock the device'),
('DEVICE_LOCATION', 'DEVICE_LOCATION', 'Request coordinates of device location'),
('WIFI', 'WIFI', 'Setting up wifi configuration'),
('CAMERA', 'CAMERA', 'Enable or disable camera'),
('EMAIL', 'EMAIL', 'Configure email settings'),
('DEVICE_MUTE', 'DEVICE_MUTE', 'Enable mute in the device'),
('PASSWORD_POLICY', 'PASSWORD_POLICY', 'Set up password policy'),
('DEVICE_INFO', 'DEVICE_INFO', 'Request device information'),
('ENTERPRISE_WIPE', 'ENTERPRISE_WIPE', 'Remove enterprise applications'),
('CLEAR_PASSWORD', 'CLEAR_PASSWORD', 'Clear current password'),
('WIPE_DATA', 'WIPE_DATA', 'Factory reset the device'),
('APPLICATION_LIST', 'APPLICATION_LIST', 'Request list of current installed applications'),
('CHANGE_LOCK_CODE', 'CHANGE_LOCK_CODE', 'Change current lock code'),
('INSTALL_APPLICATION', 'INSTALL_APPLICATION', 'Install Enterprise or Market application'),
('UNINSTALL_APPLICATION', 'UNINSTALL_APPLICATION', 'Uninstall application'),
('BLACKLIST_APPLICATIONS', 'BLACKLIST_APPLICATIONS', 'Blacklist applications'),
('ENCRYPT_STORAGE', 'ENCRYPT_STORAGE', 'Encrypt storage'),
('DEVICE_RING', 'DEVICE_RING', 'Ring the device'),
('PASSCODE_POLICY', 'PASSCODE_POLICY', 'Set passcode policy'),
('NOTIFICATION', 'NOTIFICATION', 'Send notification');<commit_msg>* Changed the name of features<commit_after>
-- -----------------------------------------------------
-- Table `AD_DEVICE`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `AD_DEVICE` (
  `ANDROID_DEVICE_ID` VARCHAR(45) NOT NULL ,
  `GCM_TOKEN` VARCHAR(45) NULL DEFAULT NULL ,
  `DEVICE_INFO` VARCHAR(500) NULL DEFAULT NULL ,
  `IMEI` VARCHAR(45) NULL DEFAULT NULL ,
  `IMSI` VARCHAR(45) NULL DEFAULT NULL ,
  `OS_VERSION` VARCHAR(45) NULL DEFAULT NULL ,
  `DEVICE_MODEL` VARCHAR(45) NULL DEFAULT NULL ,
  `VENDOR` VARCHAR(45) NULL DEFAULT NULL ,
  `LATITUDE` VARCHAR(45) NULL DEFAULT NULL,
  `LONGITUDE` VARCHAR(45) NULL DEFAULT NULL,
  `SERIAL` VARCHAR(45) NULL DEFAULT NULL,
  `MAC_ADDRESS` VARCHAR(45) NULL DEFAULT NULL,
  `DEVICE_NAME` VARCHAR(100) NULL DEFAULT NULL,
  PRIMARY KEY (`ANDROID_DEVICE_ID`) );

-- -----------------------------------------------------
-- Table `AD_FEATURE`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `AD_FEATURE` (
  `ID` INT NOT NULL AUTO_INCREMENT ,
  `CODE` VARCHAR(45) NOT NULL,
  `NAME` VARCHAR(100) NULL ,
  `DESCRIPTION` VARCHAR(200) NULL ,
  PRIMARY KEY (`ID`) );


-- -----------------------------------------------------
-- TODO remove this later
-- -----------------------------------------------------

INSERT INTO AD_FEATURE (CODE, NAME, DESCRIPTION)
VALUES
('DEVICE_LOCK', 'Device Lock', 'Lock the device'),
('DEVICE_LOCATION', 'Location', 'Request coordinates of device location'),
('WIFI', 'Wifi', 'Setting up wifi configuration'),
('CAMERA', 'Camera', 'Enable or disable camera'),
('EMAIL', 'Email', 'Configure email settings'),
('DEVICE_MUTE', 'Mute', 'Enable mute in the device'),
('DEVICE_INFO', 'Device Info', 'Request device information'),
('ENTERPRISE_WIPE', 'Enterprise Wipe', 'Remove enterprise applications'),
('CLEAR_PASSWORD', 'Clear Password', 'Clear current password'),
('WIPE_DATA', 'Wipe Data', 'Factory reset the device'),
('APPLICATION_LIST', 'Application List', 'Request list of current installed applications'),
('CHANGE_LOCK_CODE', 'Change Lock-code', 'Change current lock code'),
('INSTALL_APPLICATION', 'Install App', 'Install Enterprise or Market application'),
('UNINSTALL_APPLICATION', 'Uninstall App', 'Uninstall application'),
('BLACKLIST_APPLICATIONS', 'Blacklist app', 'Blacklist applications'),
('ENCRYPT_STORAGE', 'Encrypt storage', 'Encrypt storage'),
('DEVICE_RING', 'Ring', 'Ring the device'),
('PASSCODE_POLICY', 'Password Policy', 'Set passcode policy'),
('NOTIFICATION', 'Message', 'Send message');
{'fraction_non_alphanumeric': 0.25358303076629085, 'fraction_numerical': 0.01375883814255685, 'mean_word_length': 3.105098039215686, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '5569193', 'n_tokens_mistral': 1579, 'n_tokens_neox': 1479, 'n_words': 456}