9b/pastycake — Issue #9: db table design
Author: coh2
Created: 2012-01-23 05:17:01+00:00
State: open
Labels: Ideas

Split up the singular table into multiple ones, namely (at the time):

paste_host which is only an int PK with the domain name,
keyword which is again only an int PK with the kw as text,
matches which is int PK, int FK(paste_host), int FK(keyword), path text

that way, we get some better Normalization and it could also help stuff like new kw search should a neg-match table be needed for that.