<commit_before>DROP TABLE IF EXISTS stops;
DROP TABLE IF EXISTS stop_times;
DROP TABLE IF EXISTS trips;
DROP TABLE IF EXISTS routes;
DROP TABLE IF EXISTS services;
DROP TABLE IF EXISTS service_exceptions;
DROP TABLE IF EXISTS favorites;

CREATE TABLE stops (
	id NVARCHAR(32) NOT NULL,
	name NVARCHAR(32) NOT NULL,
	lat DECIMAL(10,8) NOT NULL,
	lng DECIMAL(11,8) NOT NULL,
	region NVARCHAR(32) NOT NULL,
	type NVARCHAR(32),
	PRIMARY KEY (id),
	UNIQUE (id)
);

CREATE TABLE stop_times (
	stop_id INT(16) NOT NULL,
	trip_id INT(16) NOT NULL,
	arrival TIME NOT NULL,
	departure TIME NOT NULL
);

CREATE TABLE trips (
	id INT(16) NOT NULL,
	route_id CHAR(32) NOT NULL,
	service_id INT(16) NOT NULL,
	wheelchair TEXT NOT NULL,
	PRIMARY KEY (id),
	UNIQUE (id)
);

CREATE TABLE routes (
	id CHAR(32) NOT NULL,
	type NVARCHAR(16) NOT NULL,
	region NVARCHAR(32) NOT NULL,
	PRIMARY KEY (id),
	UNIQUE (id)
);

CREATE TABLE services (
	id INT(16) NOT NULL,
	days VARCHAR(45) NOT NULL,
	start DATE NOT NULL,
	end DATE NOT NULL,
	PRIMARY KEY (id),
	UNIQUE (id)
);

CREATE TABLE service_exceptions (
	service_id INT(16) NOT NULL,<commit_msg>Fix error 1406 on trips import (api)<commit_after>DROP TABLE IF EXISTS stops;
DROP TABLE IF EXISTS stop_times;
DROP TABLE IF EXISTS trips;
DROP TABLE IF EXISTS routes;
DROP TABLE IF EXISTS services;
DROP TABLE IF EXISTS service_exceptions;
DROP TABLE IF EXISTS favorites;

CREATE TABLE stops (
	id NVARCHAR(32) NOT NULL,
	name NVARCHAR(32) NOT NULL,
	lat DECIMAL(10,8) NOT NULL,
	lng DECIMAL(11,8) NOT NULL,
	region NVARCHAR(32) NOT NULL,
	type NVARCHAR(32),
	PRIMARY KEY (id),
	UNIQUE (id)
);

CREATE TABLE stop_times (
	stop_id INT(16) NOT NULL,
	trip_id INT(16) NOT NULL,
	arrival TIME NOT NULL,
	departure TIME NOT NULL
);

CREATE TABLE trips (
	id INT(16) NOT NULL,
	route_id CHAR(32) NOT NULL,
	service_id INT(16) NOT NULL,
	wheelchair BOOL,
	PRIMARY KEY (id),
	UNIQUE (id)
);

CREATE TABLE routes (
	id CHAR(32) NOT NULL,
	type NVARCHAR(16) NOT NULL,
	region NVARCHAR(32) NOT NULL,
	PRIMARY KEY (id),
	UNIQUE (id)
);

CREATE TABLE services (
	id INT(16) NOT NULL,
	days VARCHAR(45) NOT NULL,
	start DATE NOT NULL,
	end DATE NOT NULL,
	PRIMARY KEY (id),
	UNIQUE (id)
);

CREATE TABLE service_exceptions (
	service_id INT(16) NOT NULL,
{'fraction_non_alphanumeric': 0.09179170344218888, 'fraction_numerical': 0.03353927625772286, 'mean_word_length': 4.462650602409639, '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': '2438998', 'n_tokens_mistral': 938, 'n_tokens_neox': 858, 'n_words': 321}