<commit_before>-- This file contains the SQL for creating the tables for the models defined in
-- this directory

-- ConfigValue
CREATE TABLE `config_values` (
  `id`             integer      AUTO_INCREMENT PRIMARY KEY,
  `name`           varchar(256) NOT NULL UNIQUE,
  `value`          varchar(256) NULL
);

-- Permission
CREATE TABLE `permissions` (
  `id`             integer      AUTO_INCREMENT PRIMARY KEY,
  `name`           varchar(256) NOT NULL UNIQUE
);

-- Session
CREATE TABLE `session` (
  `id`             integer      AUTO_INCREMENT PRIMARY KEY,
  `sess_key`       varchar(32)  NOT NULL UNIQUE,
  `last_access`    bigint       NOT NULL,
  `users_id`       integer      NULL
);

-- User
CREATE TABLE `users` (
  `id`             integer      AUTO_INCREMENT PRIMARY KEY,
  `username`       varchar(128) NOT NULL UNIQUE,
  `password`       varchar(32)  NOT NULL
);

-- UserPermission
CREATE TABLE `users_permissions_link` (
  `id`             integer      AUTO_INCREMENT PRIMARY KEY,
  `users_id`       integer      NOT NULL,
  `permissions_id` integer      NOT NULL,
  `level`          varchar(8)   NOT NULL
);<commit_msg>Added default admin user to conductor model.sql seed file<commit_after>-- This file contains the SQL for creating the tables for the models defined in
-- this directory

-- ConfigValue
CREATE TABLE `config_values` (
  `id`             integer      AUTO_INCREMENT PRIMARY KEY,
  `name`           varchar(256) NOT NULL UNIQUE,
  `value`          varchar(256) NULL
);

-- Permission
CREATE TABLE `permissions` (
  `id`             integer      AUTO_INCREMENT PRIMARY KEY,
  `name`           varchar(256) NOT NULL UNIQUE
);
INSERT INTO `permissions` (`name`) VALUES ('cdt-admin');

-- Session
CREATE TABLE `session` (
  `id`             integer      AUTO_INCREMENT PRIMARY KEY,
  `sess_key`       varchar(32)  NOT NULL UNIQUE,
  `last_access`    bigint       NOT NULL,
  `users_id`       integer      NULL
);

-- User
CREATE TABLE `users` (
  `id`             integer      AUTO_INCREMENT PRIMARY KEY,
  `username`       varchar(128) NOT NULL UNIQUE,
  `password`       varchar(32)  NOT NULL
);
INSERT INTO `users` (`username`, `password`)
  VALUES ('pgraham', md5('<PASSWORD>'));

-- UserPermission
CREATE TABLE `users_permissions_link` (
  `id`             integer      AUTO_INCREMENT PRIMARY KEY,
  `users_id`       integer      NOT NULL,
  `permissions_id` integer      NOT NULL,
  `level`          varchar(8)   NOT NULL
);
INSERT INTO `users_permissions_link` (`users_id`, `permissions_id`, `level`)
  VALUES (
    (SELECT `id` FROM `users` WHERE `username` = 'pgraham'),
    (SELECT `id` FROM `permissions` WHERE `name` = 'cdt-admin'),
    'write');
{'fraction_non_alphanumeric': 0.10204841713221602, 'fraction_numerical': 0.01303538175046555, 'mean_word_length': 2.456885456885457, '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': '5865707', 'n_tokens_mistral': 881, 'n_tokens_neox': 854, 'n_words': 260}