← Back to main page
blog-acoustic-fingerprinting
ARCHIVED - acoustic fingerprinting television shows with python
git clone https://git.vogt.world/blog-acoustic-fingerprinting.git
alt url: https://github.com/vogtb/blog-acoustic-fingerprinting
Log | Files | README.md
← All files
name: src/sql/schema.sql
-rw-r--r--
212
 
1CREATE DATABASE fingerprints;
2USE fingerprints;
3CREATE TABLE Fingerprints (
4  hash BIGINT NOT NULL,
5  episode VARCHAR(20) NOT NULL,
6  playhead BIGINT NOT NULL,
7  INDEX(hash),
8  UNIQUE(hash, playhead, episode)
9);