| Index: trunk/extensions/ContributionTracking/ContributionTracking.pg.sql |
| — | — | @@ -0,0 +1,25 @@ |
| | 2 | + |
| | 3 | +-- Schema for the ContributionTracking extension |
| | 4 | +-- Postgres version |
| | 5 | + |
| | 6 | +BEGIN; |
| | 7 | + |
| | 8 | +CREATE TABLE contribution_tracking ( |
| | 9 | + id SERIAL PRIMARY KEY, |
| | 10 | + contribution_id INTEGER, |
| | 11 | + note TEXT, |
| | 12 | + referrer TEXT, |
| | 13 | + anonymous SMALLINT, |
| | 14 | + utm_source TEXT, |
| | 15 | + utm_medium TEXT, |
| | 16 | + utm_campaign TEXT, |
| | 17 | + optout SMALLINT, |
| | 18 | + language TEXT, |
| | 19 | + ts TIMESTAMPTZ |
| | 20 | +); |
| | 21 | + |
| | 22 | +CREATE UNIQUE INDEX contribution_tracking_index1 ON contribution_tracking(contribution_id); |
| | 23 | +CREATE UNIQUE INDEX contribution_tracking_index2 ON contribution_tracking(ts); |
| | 24 | + |
| | 25 | +COMMIT; |
| | 26 | + |