<commit_before>drop database brohodb;
create database brohodb;
BEGIN;
  \c brohodb
  CREATE TABLE position(id int primary key,  title text not null, description text, recurring smallint not null);
  CREATE TABLE person(id int primary key, start_class text not null, first_name text not null, last_name text not null, start_semester text not null, end_semester text not null);
  CREATE TABLE floor(id int primary key, name text not null, description text);
  CREATE TABLE room(id int primary key, floor_id int references floor(id), room_num int not null, num_occupants int not null);
  CREATE TABLE picture(id int primary key, type text not null, type_id int not null, title text not null, description text, url text not null);
  CREATE TABLE enduser(id int primary key, first_name text not null, last_name text not null, email text not null, verified_floor_member smallint, role text not null, password text not null);
  CREATE TABLE person_room(id int primary key, person_id int references person(id), room_id int references room(id), start_semester text not null, end_semester text not null);
  CREATE TABLE person_position(id int primary key, person_id int references person(id), position_id int references position(id), description text, start_semester date, end_semester date);
COMMIT;
<commit_msg>added check constraint to picture table<commit_after>drop database brohodb;
create database brohodb;
BEGIN;
  \c brohodb
  CREATE TABLE position(id int primary key,  title text not null, description text, recurring smallint not null);
  CREATE TABLE person(id int primary key, start_class text not null, first_name text not null, last_name text not null
, start_semester text not null, end_semester text not null);
  CREATE TABLE floor(id int primary key, name text not null, description text);
  CREATE TABLE room(id int primary key, floor_id int references floor(id), room_num int not null, num_occupants int no
t null);
  CREATE TABLE picture(id int primary key, table_type text not null, type_id int not null, title text not null, descri
ption text, url text not null, check (table_type = 'user' or table_type = 'person' or table_type = 'room' or table_typ
e = 'floor'));
  CREATE TABLE enduser(id int primary key, first_name text not null, last_name text not null, email text not null, ver
ified_floor_member smallint, role text not null, password text not null);
  CREATE TABLE person_room(id int primary key, person_id int references person(id), room_id int references room(id), s
tart_semester text not null, end_semester text not null);
  CREATE TABLE person_position(id int primary key, person_id int references person(id), position_id int references pos
ition(id), description text, start_semester date, end_semester date);
COMMIT;

{'fraction_non_alphanumeric': 0.060087399854333576, 'fraction_numerical': 0.0, 'mean_word_length': 5.524940617577197, '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': '6732551', 'n_tokens_mistral': 794, 'n_tokens_neox': 739, 'n_words': 375}