Zipfs-Law-Language-Detector/data/words/schema.sql

7 lines
158 B
SQL

create table Words(
Language text,
Word text,
Occurrences integer
);
CREATE INDEX idx_language_occurrences ON Words(language, occurrences DESC);