<commit_before>create table MST_ITEM (
item_id int primary key auto_increment,
item_name varchar(100) not null,
vendor varchar(100));

create table MST_PROJECT(
project_id int primary key auto_increment,
project_name varchar(100) not null,
descrip varchar(100)
);

create table MST_USERGROUP(
usergroup_id int primary key auto_increment,
usergroup_name varchar(50) not null
);

create table MST_USER(
user_id varchar(30) primary key,
usergroup_id int not null,
password varchar(100) not null,
salt varchar(33) not null,
foreign key (usergroup_id) references MST_USERGROUP(usergroup_id) on delete cascade
);

create table MST_MENU(
menu_id int primary key auto_increment,
menu_name varchar(100)
);

create table MST_ACTION(
action_id int primary key auto_increment,
menu_id int not null,
menu_url varchar(200) not null,
foreign key (menu_id) references MST_MENU(menu_id) on delete cascade
);

create table MST_USERGROUPAC(
usergroupac_id int primary key auto_increment,
usergroup_id int not null,
action_id int not null,
foreign key (usergroup_id) references MST_USERGROUP(usergroup_id) on delete cascade,
foreign key (action_id) references MST_ACTION(action_id) on delete cascade
);

create table MST_PROJECTUSER(
project_id int not null,
user_id varchar(30) not null,
foreign key (project_id) references MST_PROJECT(project_id) on delete cascade,
foreign key (user_id) references MST_USER(user_id) on delete cascade
);
<commit_msg>GRAB db<commit_after>create table MST_ITEM (
item_id int primary key auto_increment,
item_name varchar(100) not null,
vendor varchar(100));

create table MST_PROJECT(
project_id int primary key auto_increment,
project_name varchar(100) not null,
descrip varchar(100)
);

create table MST_USERGROUP(
usergroup_id int primary key auto_increment,
usergroup_name varchar(50) not null
);

create table MST_USER(
user_id varchar(30) primary key,
usergroup_id int not null,
password varchar(100) not null,
salt varchar(33) not null,
foreign key (usergroup_id) references MST_USERGROUP(usergroup_id) on delete cascade
);

create table MST_MENU(
menu_id int primary key auto_increment,
menu_name varchar(100)
);

create table MST_ACTION(
action_id int primary key auto_increment,
menu_id int not null,
menu_url varchar(200) not null,
descrip varchar(100),
foreign key (menu_id) references MST_MENU(menu_id) on delete cascade
);

create table MST_USERGROUPAC(
usergroupac_id int primary key auto_increment,
usergroup_id int not null,
action_id int not null,
foreign key (usergroup_id) references MST_USERGROUP(usergroup_id) on delete cascade,
foreign key (action_id) references MST_ACTION(action_id) on delete cascade
);

create table MST_PROJECTUSER(
project_id int not null,
user_id varchar(30) not null,
foreign key (project_id) references MST_PROJECT(project_id) on delete cascade,
foreign key (user_id) references MST_USER(user_id) on delete cascade
);

{'fraction_non_alphanumeric': 0.065625, 'fraction_numerical': 0.021180555555555557, 'mean_word_length': 7.138418079096045, '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': '76025', 'n_tokens_mistral': 1032, 'n_tokens_neox': 925, 'n_words': 323}