Lines Matching full:on

12     `user`  TEXT NOT NULL REFERENCES `users` (`user`) ON DELETE CASCADE ON UPDATE CASCADE,
25 …`user`    TEXT              DEFAULT NULL REFERENCES `users` (`user`) ON DELETE SET NULL ON UPDATE …
32 CREATE INDEX `idx_session_dt` ON `sessions` (`dt`);
33 CREATE INDEX `idx_session_uid` ON `sessions` (`uid`);
34 CREATE INDEX `idx_session_ua_type` ON `sessions` (`ua_type`);
45 CREATE UNIQUE INDEX `idx_referers_url` ON `referers` (`url`);
46 CREATE INDEX `idx_referers_dt` ON `referers` (`dt`);
47 CREATE INDEX `idx_referers_engine` ON `referers` (`engine`);
56 …`session`  TEXT     NOT NULL REFERENCES `sessions` (`session`) ON DELETE CASCADE ON UPDATE CASCADE,
58 …`ref_id`   INTEGER           DEFAULT NULL REFERENCES `referers` (`id`) ON DELETE SET NULL ON UPDAT…
64 CREATE INDEX `idx_pageviews_page` ON `pageviews` (`page`);
65 CREATE INDEX `idx_pageviews_dt` ON `pageviews` (`dt`);
76 CREATE INDEX `idx_iplocation_code` ON `iplocation` (`code`);
82 … `session` TEXT     NOT NULL REFERENCES `sessions` (`session`) ON DELETE CASCADE ON UPDATE CASCADE,
86 CREATE INDEX `idx_outlinks_link` ON `outlinks` (`link`);
87 CREATE INDEX `idx_outlinks_dt` ON `outlinks` (`dt`);
96 … `session` TEXT     NOT NULL REFERENCES `sessions` (`session`) ON DELETE CASCADE ON UPDATE CASCADE,
99 CREATE INDEX `idx_search_dt` ON `search` (`dt`);
105     FOREIGN KEY (`sid`) REFERENCES `search` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
115 … `session` TEXT     NOT NULL REFERENCES `sessions` (`session`) ON DELETE CASCADE ON UPDATE CASCADE,
119 CREATE INDEX `idx_edits_dt` ON `edits` (`dt`);
120 CREATE INDEX `idx_edits_type` ON `edits` (`type`);
131 CREATE INDEX `idx_logins_dt` ON `logins` (`dt`);
132 CREATE INDEX `idx_logins_type` ON `logins` (`type`);
141 … `session` TEXT     NOT NULL REFERENCES `sessions` (`session`) ON DELETE CASCADE ON UPDATE CASCADE,
148 CREATE INDEX `idx_media_media` ON `media` (`media`);
149 CREATE INDEX `idx_media_dt` ON `media` (`dt`);
150 CREATE INDEX `idx_media_mime1` ON `media` (`mime1`);