<commit_before>CREATE TABLE  `zstack`.`KeystoreVO` (
    `uuid` varchar(32) NOT NULL UNIQUE,
    `resourceUuid` varchar(32) NOT NULL,
    `resourceType` varchar(255) NOT NULL,
    `type` varchar(255) NOT NULL,
    `content` varchar(65535) NOT NULL,
    `lastOpDate` timestamp ON UPDATE CURRENT_TIMESTAMP COMMENT 'last operation date',
    `createDate` timestamp,
    PRIMARY KEY  (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE `zstack`.`AccountResourceRefVO` ADD UNIQUE INDEX(resourceUuid,resourceType);

ALTER TABLE `zstack`.`ConsoleProxyAgentVO` modify column description varchar(2048) DEFAULT NULL;
ALTER TABLE `zstack`.`ImageEO` modify column description varchar(2048) DEFAULT NULL COMMENT 'image description';
ALTER TABLE `zstack`.`InstanceOfferingEO` column description varchar(2048) DEFAULT NULL  COMMENT 'instance offering description';
ALTER TABLE `zstack`.`DiskOfferingEO` column description varchar(2048) DEFAULT NULL COMMENT 'disk offering description';
ALTER TABLE `zstack`.`VolumeEO` column description varchar(2048) DEFAULT NULL;
ALTER TABLE `zstack`.`VipVO` column description varchar(2048) DEFAULT NULL;
ALTER TABLE `zstack`.`GlobalConfigVO` column description varchar(2048) DEFAULT NULL;
ALTER TABLE `zstack`.`NetworkServiceProviderVO` column description varchar(2048) DEFAULT NULL;
ALTER TABLE `zstack`.`SecurityGroupVO` column description varchar(2048) DEFAULT NULL;<commit_msg>Data Format Normalization for fields(name,description) of all tables;<commit_after>CREATE TABLE  `zstack`.`KeystoreVO` (
    `uuid` varchar(32) NOT NULL UNIQUE,
    `resourceUuid` varchar(32) NOT NULL,
    `resourceType` varchar(255) NOT NULL,
    `type` varchar(255) NOT NULL,
    `content` varchar(65535) NOT NULL,
    `lastOpDate` timestamp ON UPDATE CURRENT_TIMESTAMP COMMENT 'last operation date',
    `createDate` timestamp,
    PRIMARY KEY  (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE `zstack`.`AccountResourceRefVO` ADD UNIQUE INDEX(resourceUuid,resourceType);

ALTER TABLE `zstack`.`ConsoleProxyAgentVO` modify column description varchar(2048) DEFAULT NULL;
ALTER TABLE `zstack`.`ImageEO` modify column description varchar(2048) DEFAULT NULL COMMENT 'image description';
ALTER TABLE `zstack`.`InstanceOfferingEO` column description varchar(2048) DEFAULT NULL  COMMENT 'instance offering description';
ALTER TABLE `zstack`.`DiskOfferingEO` column description varchar(2048) DEFAULT NULL COMMENT 'disk offering description';
ALTER TABLE `zstack`.`VolumeEO` column description varchar(2048) DEFAULT NULL;
ALTER TABLE `zstack`.`VipVO` column description varchar(2048) DEFAULT NULL;
ALTER TABLE `zstack`.`GlobalConfigVO` column description varchar(2048) DEFAULT NULL;
ALTER TABLE `zstack`.`NetworkServiceProviderVO` column description varchar(2048) DEFAULT NULL;
ALTER TABLE `zstack`.`SecurityGroupVO` column description varchar(2048) DEFAULT NULL;

ALTER TABLE `zstack`.`PolicyVO` column description varchar(2048) DEFAULT NULL;
ALTER TABLE `zstack`.`person` column description varchar(2048) DEFAULT NULL;
ALTER TABLE `zstack`.`UserGroupVO` column description varchar(2048) DEFAULT NULL;

{'fraction_non_alphanumeric': 0.09685695958948044, 'fraction_numerical': 0.03720333547145606, 'mean_word_length': 6.81704260651629, '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': '1534080', 'n_tokens_mistral': 994, 'n_tokens_neox': 892, 'n_words': 294}