xref: /plugin/statistics/db/update0003.sql (revision 9aec20ef18cca1f21a6264e3242a9d6305a77ea1)
1CREATE TABLE `campaigns`
2(
3    `session`  TEXT PRIMARY KEY REFERENCES `sessions` (`session`) ON DELETE CASCADE ON UPDATE CASCADE,
4    `campaign` TEXT NOT NULL,
5    `source`   TEXT NULL,
6    `medium`   TEXT NULL
7);
8