1 2 3 4 5 6 7
CREATE TABLE links ( long TEXT NOT NULL, short TEXT NOT NULL PRIMARY KEY, disabled BOOLEAN NOT NULL DEFAULT FALSE, ip TEXT NOT NULL, uses INTEGER NOT NULL DEFAULT 0 )