<commit_before>CREATE DATABASE MSEF;
USE MSEF;


CREATE TABLE forms ( 
  Id INT NOT NULL AUTO_INCREMENT, 
  Name VARCHAR(250) NOT NULL, 
  FormPath VARCHAR(1000) NOT NULL, 
  PRIMARY KEY(Id)
);

CREATE TABLE statuses ( 
  Id INT NOT NULL AUTO_INCREMENT, 
  Name VARCHAR(100) NOT NULL, 
  Description VARCHAR(250), 
  PRIMARY KEY(Id)
);

CREATE TABLE projects (
  Id INT NOT NULL AUTO_INCREMENT, 
  status_id INT NOT NULL, 
  Name VARCHAR(250) NOT NULL, 
  Electrical BOOL NOT NULL DEFAULT FALSE,
  Description VARCHAR(1000) NOT NULL, 
  Abstract VARCHAR(1000) NOT NULL, 
  PRIMARY KEY(Id), 
  FOREIGN KEY (status_id) REFERENCES statuses(Id)
);

CREATE TABLE categories (
  Id INT NOT NULL AUTO_INCREMENT, 
  Name VARCHAR(250) NOT NULL, 
  Description VARCHAR(250) NOT NULL, 
  MaxCapacity INT NULL, 
  PRIMARY KEY (Id)
);


CREATE TABLE projectCatagories (
   project_id INT NOT NULL,
   category_id INT NOT NULL,
   FOREIGN KEY (project_id) REFERENCES projects(Id),
   FOREIGN KEY (project_id) REFERENCES categories(Id)
);

CREATE TABLE awards (
  Id INT NOT NULL AUTO_INCREMENT, 
  Name VARCHAR(250) NOT NULL, 
  Description VARCHAR(1000) NOT NULL, 
  Reward VARCHAR(1000) NULL, 
  PRIMARY KEY(Id)<commit_msg>Added full text index to projects table.<commit_after>CREATE DATABASE MSEF;
USE MSEF;


CREATE TABLE forms ( 
  Id INT NOT NULL AUTO_INCREMENT, 
  Name VARCHAR(250) NOT NULL, 
  FormPath VARCHAR(1000) NOT NULL, 
  PRIMARY KEY(Id)
);

CREATE TABLE statuses ( 
  Id INT NOT NULL AUTO_INCREMENT, 
  Name VARCHAR(100) NOT NULL, 
  Description VARCHAR(250), 
  PRIMARY KEY(Id)
);

CREATE TABLE projects (
  Id INT NOT NULL AUTO_INCREMENT, 
  status_id INT NOT NULL, 
  Name VARCHAR(250) NOT NULL, 
  Electrical BOOL NOT NULL DEFAULT FALSE,
  Description VARCHAR(1000) NOT NULL, 
  Abstract VARCHAR(1000) NOT NULL, 
  PRIMARY KEY(Id), 
  FOREIGN KEY (status_id) REFERENCES statuses(Id),
  FULLTEXT INDEX (Name, Description, Abstract)
) ENGINE=MyISAM;

CREATE TABLE categories (
  Id INT NOT NULL AUTO_INCREMENT, 
  Name VARCHAR(250) NOT NULL, 
  Description VARCHAR(250) NOT NULL, 
  MaxCapacity INT NULL, 
  PRIMARY KEY (Id)
);


CREATE TABLE projectCatagories (
   project_id INT NOT NULL,
   category_id INT NOT NULL,
   FOREIGN KEY (project_id) REFERENCES projects(Id),
   FOREIGN KEY (project_id) REFERENCES categories(Id)
);

CREATE TABLE awards (
  Id INT NOT NULL AUTO_INCREMENT, 
  Name VARCHAR(250) NOT NULL, 
  Description VARCHAR(1000) NOT NULL, 
  Reward VARCHAR(1000) NULL, 
  PRIMARY KEY(Id)
{'fraction_non_alphanumeric': 0.07526881720430108, 'fraction_numerical': 0.0326563122262047, 'mean_word_length': 3.984126984126984, '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': '1331972', 'n_tokens_mistral': 967, 'n_tokens_neox': 813, 'n_words': 291}