<commit_before>CREATE TABLE `rooms` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `room_number` varchar(20) NOT NULL,
  `room_status` int(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf-8;<commit_msg>add user and companies to database<commit_after>CREATE DATABASE IF NOT EXISTS `officeiot` DEFAULT CHARACTER SET utf8;
USE `officeiot`;


CREATE TABLE rooms (
        id              int NOT NULL AUTO_INCREMENT,
        name            char(100),
        company_name    char(100),
        status          int(1),
        primary key (id),
        foreign key (company_name) references companies
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE users (
        email           char(100) not null,
        password        <PASSWORD>),
        company_name    char(100),
        primary key (email)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE companies (
        id              int NOT NULL AUTO_INCREMENT,
        company_name    char(100) not null,
        primary key (id),
        foreign key (comapny_name) references rooms,
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

{'fraction_non_alphanumeric': 0.08258527827648116, 'fraction_numerical': 0.026032315978456014, 'mean_word_length': 2.6201298701298703, 'pattern_counts': {'":': 0, '<': 4, '<?xml version=': 0, '>': 4, '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': '6358436', 'n_tokens_mistral': 369, 'n_tokens_neox': 336, 'n_words': 104}