jDMpAmCU

1CREATE TABLE IF NOT EXISTS doa_core_setting (
2    id bigint(20) not null auto_increment,
3    
4    user_id bigint(20) not null,
5    subscription_level varchar(50) default 'free',
6    language_code varchar(200) default 'en',
7    currency_code varchar(10) default 'IDR',
8    hide_profile bool not null default false,
9    
10    created_at datetime(6) null,
11    updated_at datetime(6) null,
12    deleted_at datetime(6) null,
13    primary key(id)
14);
15
16CREATE TABLE IF NOT EXISTS doa_subscription_subscriptionpayment (
17    id bigint(20) not null auto_increment,
18    user_id bigint(20) not null,
19    code varchar(255) not null,
20    period varchar(50) not null default 'semiannually',
21    amount double not null default 0.0,
22    currency_code varchar(10) not null default 'IDR',
23    start_date datetime(6) not null,
24    end_date datetime(6) not null,
25    created_at datetime(6) null,
26    updated_at datetime(6) null,
27    deleted_at datetime(6) null,
28    primary key(id)
29);
30
31
32CREATE TABLE IF NOT EXISTS doa_account_userconnection (
33    id bigint(20) not null auto_increment,
34    sender_id bigint(20) not null,
35    receiver_id bigint(20) not null,
36    status varchar(20) not null default 'requested',
37    created_at datetime(6) null,
38    updated_at datetime(6) null,
39    deleted_at datetime(6) null,
40    primary key(id)
41);
42
43
44CREATE TABLE IF NOT EXISTS doa_plan_plan_partners(
45  id int(11) not null auto_increment,
46  plan_id bigint(20) not null,
47  user_id bigint(20) not null
48  primary key(id)
49);
50
51
52CREATE TABLE IF NOT EXISTS doa_plan_pinnedplan (
53    id bigint(20) not null auto_increment,
54    plan_id bigint(20) not null,
55    user_id bigint(20) not null,
56    created_at datetime(6) null,
57    updated_at datetime(6) null,
58    deleted_at datetime(6) null,
59    primary key(id)
60);