Lines Matching full:not

6     `dt`     DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, -- last seen
12     `user`  TEXT NOT NULL REFERENCES `users` (`user`) ON DELETE CASCADE ON UPDATE CASCADE,
13     `group` TEXT NOT NULL,
22     `dt`      DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
23     `end`     DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
24     `uid`     TEXT     NOT NULL,
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,
42     `dt`     DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
54     `dt`       DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
55     `ip`       TEXT     NOT NULL,
56 …`session`  TEXT     NOT NULL REFERENCES `sessions` (`session`) ON DELETE CASCADE ON UPDATE CASCADE,
57     `page`     TEXT     NOT NULL,
59     `screen_x` INTEGER  NOT NULL,
60     `screen_y` INTEGER  NOT NULL,
61     `view_x`   INTEGER  NOT NULL,
62     `view_y`   INTEGER  NOT NULL
70     `code`    TEXT     NOT NULL,
71     `country` TEXT     NOT NULL,
72     `city`    TEXT     NOT NULL,
73     `host`    TEXT     NOT NULL,
74     `lastupd` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
81     `dt`      DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
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 ''
94     `dt`      DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
95     `ip`      TEXT     NOT NULL,
96 … `session` TEXT     NOT NULL REFERENCES `sessions` (`session`) ON DELETE CASCADE ON UPDATE CASCADE,
97     `query`   TEXT     NOT NULL
103     `sid`  INTEGER NOT NULL,
104     `word` TEXT    NOT NULL,
113     `dt`      DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
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
126     `dt`   DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
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
139     `dt`      DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
141 … `session` TEXT     NOT NULL REFERENCES `sessions` (`session`) ON DELETE CASCADE ON UPDATE CASCADE,
142     `media`   TEXT     NOT NULL,
143     `size`    INTEGER  NOT NULL,
144     `mime1`   TEXT     NOT NULL,
145     `mime2`   TEXT     NOT NULL,
146     `inline`  INTEGER  NOT NULL
155     `info`  TEXT     NOT NULL,
156     `dt`    DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
157     `value` INTEGER  NOT NULL,