<commit_before>DROP TABLE if EXISTS maps; /* Reset database on creation */
CREATE TABLE maps (
  id integer PRIMARY KEY AUTOINCREMENT,
  file_reference text NOT NULL /* reference to location in filesystem */
);
DROP TABLE if EXISTS meetings;
CREATE TABLE meetings (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  title TEXT NOT NULL,
  time TEXT NOT NULL, /* YYYY-MM-DD HH:MM:SS.SSS */
  map_id INTEGER,
  FOREIGN KEY(map_id) REFERENCES maps(id)
);
INSERT INTO maps (file_reference) VALUES ('maps/mymap');
INSERT INTO meetings (title, time, map_id) VALUES ('Kodeklubb-møte', '1992-12-18 15:10:20.101', 1);
INSERT INTO meetings (title, time, map_id) VALUES ('Kløfta møte', '2000-12-18 15:10:20.101', 1);<commit_msg>add basic user support to database.<commit_after>DROP TABLE if EXISTS maps; /* Reset database on creation */
CREATE TABLE maps (
  id integer PRIMARY KEY AUTOINCREMENT,
  file_reference text NOT NULL /* reference to location in filesystem */
);
DROP TABLE if EXISTS meetings;
CREATE TABLE meetings (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  title TEXT NOT NULL,
  time TEXT NOT NULL, /* YYYY-MM-DD HH:MM:SS.SSS */
  creator TEXT NOT NULL,
  map_id INTEGER,
  FOREIGN KEY(creator) REFERENCES users(username),
  FOREIGN KEY(map_id) REFERENCES maps(id)
);
DROP TABLE if EXISTS users;
CREATE TABLE users (
  username TEXT PRIMARY KEY,
  password TEXT NOT NULL
);

INSERT INTO maps (file_reference) VALUES ('maps/mymap');
INSERT INTO users (username, password) VALUES ('kari', '<PASSWORD>');
INSERT INTO meetings (title, time, creator, map_id) VALUES ('Kodeklubb-møte', '1992-12-18 15:10:20.101', 'kari', 1);
INSERT INTO meetings (title, time, creator, map_id) VALUES ('Kløfta møte', '2000-12-18 15:10:20.101', 'kari', 1);
{'fraction_non_alphanumeric': 0.11407064273306311, 'fraction_numerical': 0.04169079328314997, 'mean_word_length': 4.7218543046357615, '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': '1315684', 'n_tokens_mistral': 659, 'n_tokens_neox': 570, 'n_words': 208}