J0jqWSdd

1CREATE TABLE IF NOT EXISTS settings
2(
3    timezone            TEXT   NOT NULL,
4    service_percent     BIGINT NOT NULL,
5    admin_tg_login      BIGINT NOT NULL,
6    track_domain        TEXT   NOT NULL,
7    pay_domain          TEXT   NOT NULL,
8    service_balance     BIGINT NOT NULL,
9    sum_service_balance BIGINT NOT NULL,
10    service_status      BIGINT NOT NULL
11--     created_at   TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP,
12--     updated_at   TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP
13);
14CREATE TABLE IF NOT EXISTS users
15(
16    id              SERIAL PRIMARY KEY,
17    tg_login        BIGINT NOT NULL,
18    service_percent BIGINT NOT NULL,
19    notifications   BIGINT NOT NULL,
20    timezone        TEXT   NOT NULL,
21    track_domain    TEXT   NOT NULL,
22    pay_domain      TEXT   NOT NULL,
23    balance         BIGINT NOT NULL,
24    wallet          BIGINT NOT NULL,
25    status          BIGINT NOT NULL,
26    created_at      TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP,
27    updated_at      TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP
28);
29
30CREATE TABLE IF NOT EXISTS visitors
31(
32    id          SERIAL PRIMARY KEY,
33    user_id     BIGINT NOT NULL REFERENCES users (id),
34    offer_id    BIGINT NOT NULL REFERENCES offers (id),
35    upsell_id  BIGINT NOT NULL DEFAULT 0,
36    sub_id      BIGINT NOT NULL DEFAULT 0,
37    track_count BIGINT NOT NULL,
38    pay_count   BIGINT NOT NULL,
39    "unique"    BIGINT NOT NULL,
40    country     TEXT   NOT NULL,
41    fingerprint TEXT   NOT NULL,
42    created_at  TIMESTAMP WITH TIME ZONE                       DEFAULT CURRENT_TIMESTAMP,
43    updated_at  TIMESTAMP WITH TIME ZONE                       DEFAULT CURRENT_TIMESTAMP
44);
45
46CREATE TABLE IF NOT EXISTS payouts
47(
48    id         SERIAL PRIMARY KEY,
49    user_id    BIGINT NOT NULL REFERENCES users (id),
50    sum_payout BIGINT NOT NULL,
51    status     BIGINT NOT NULL,
52    created_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP,
53    updated_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP
54);
55
56CREATE TABLE IF NOT EXISTS offers
57(
58    id          SERIAL PRIMARY KEY,
59    category    BIGINT NOT NULL,
60    domain      TEXT   NOT NULL,
61    name        TEXT   NOT NULL,
62    price       BIGINT NOT NULL,
63    percent     BIGINT NOT NULL,
64    success_url TEXT   NOT NULL,
65    failed_url  TEXT   NOT NULL
66);
67
68-- добавил пока как тест
69CREATE TABLE IF NOT EXISTS offers_partners
70(
71    id           SERIAL PRIMARY KEY,
72    user_id      BIGINT NOT NULL REFERENCES users (id),
73    offer_id     BIGINT NOT NULL REFERENCES offers (id),
74    upsell_id    BIGINT NOT NULL REFERENCES upsells (id),
75    sub_id       BIGINT NOT NULL DEFAULT 0,
76    partner_link TEXT   NOT NULL
77);
78
79-- добавил пока как тест
80CREATE TABLE IF NOT EXISTS offers_sub_ids
81(
82    id                 SERIAL PRIMARY KEY,
83    user_id            BIGINT NOT NULL REFERENCES users (id),
84    offer_id           BIGINT NOT NULL REFERENCES offers (id),
85    name               TEXT   NOT NULL,
86    subid_partner_link TEXT   NOT NULL
87
88);
89
90CREATE TABLE IF NOT EXISTS upsells
91(
92    id            SERIAL PRIMARY KEY,
93    offer_id      BIGINT NOT NULL REFERENCES offers (id),
94    upsell_number SERIAL,
95    name          TEXT   NOT NULL,
96    price         BIGINT NOT NULL,
97    percent       BIGINT NOT NULL,
98    success_url   TEXT   NOT NULL,
99    failed_url    TEXT   NOT NULL
100);
101
102CREATE TABLE IF NOT EXISTS orders
103(
104    id         BIGSERIAL PRIMARY KEY,
105    user_id    BIGINT NOT NULL REFERENCES users (id),
106    offer_id   BIGINT NOT NULL REFERENCES offers (id),
107    upsell_id  BIGINT NOT NULL REFERENCES upsells (id),
108    visitor_id BIGINT NOT NULL REFERENCES visitors (id),
109    price      BIGINT NOT NULL,
110    status     BIGINT NOT NULL,
111    created_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP,
112    updated_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP
113);