Lines Matching refs:TEXT

5     `user`   TEXT PRIMARY KEY,
7     `domain` TEXT              DEFAULT NULL               -- email domain
12     `user`  TEXT NOT NULL REFERENCES `users` (`user`) ON DELETE CASCADE ON UPDATE CASCADE,
13     `group` TEXT NOT NULL,
21     `session` TEXT PRIMARY KEY,
24     `uid`     TEXT     NOT NULL,
25 …`user`    TEXT              DEFAULT NULL REFERENCES `users` (`user`) ON DELETE SET NULL ON UPDATE …
26     `ua`      TEXT     NOT NULL,
27     `ua_info` TEXT     NOT NULL,
28     `ua_type` TEXT     NOT NULL,
29     `ua_ver`  TEXT     NOT NULL,
30     `os`      TEXT     NOT NULL
41     `url`    TEXT     NOT NULL,
43     `engine` TEXT              DEFAULT NULL -- search engine if it is a search engine referrer
55     `ip`       TEXT     NOT NULL,
56 …`session`  TEXT     NOT NULL REFERENCES `sessions` (`session`) ON DELETE CASCADE ON UPDATE CASCADE,
57     `page`     TEXT     NOT NULL,
69     `ip`      TEXT PRIMARY KEY,
70     `code`    TEXT     NOT NULL,
71     `country` TEXT     NOT NULL,
72     `city`    TEXT     NOT NULL,
73     `host`    TEXT     NOT NULL,
82 … `session` TEXT     NOT NULL REFERENCES `sessions` (`session`) ON DELETE CASCADE ON UPDATE CASCADE,
83     `link`    TEXT     NOT NULL,
84     `page`    TEXT     NOT NULL DEFAULT ''
95     `ip`      TEXT     NOT NULL,
96 … `session` TEXT     NOT NULL REFERENCES `sessions` (`session`) ON DELETE CASCADE ON UPDATE CASCADE,
97     `query`   TEXT     NOT NULL
104     `word` TEXT    NOT NULL,
114     `ip`      TEXT     NOT NULL,
115 … `session` TEXT     NOT NULL REFERENCES `sessions` (`session`) ON DELETE CASCADE ON UPDATE CASCADE,
116     `page`    TEXT     NOT NULL,
117     `type`    TEXT     NOT NULL
127     `ip`   TEXT     NOT NULL,
128 …`user` TEXT     NOT NULL, -- no references to users, as this is for all logins, including failed o…
129     `type` TEXT     NOT NULL
140     `ip`      TEXT,
141 … `session` TEXT     NOT NULL REFERENCES `sessions` (`session`) ON DELETE CASCADE ON UPDATE CASCADE,
142     `media`   TEXT     NOT NULL,
144     `mime1`   TEXT     NOT NULL,
145     `mime2`   TEXT     NOT NULL,
155     `info`  TEXT     NOT NULL,