Draft: initial user flow for creating a wallet

db/mysql.sql

+create table app_state
+(
+    id            int auto_increment,
+    message       varchar(200) null,
+    menu          varchar(200) null,
+    variable_name varchar(100) not null,
+    constraint app_state_pk
+        primary key (id)
+);
+
+create unique index app_state_id_uindex
+    on app_state (id);
+
+
+
+create table app_user
+(
+    id          int auto_increment,
+    telegram_id int           not null,
+    state_id    int default 0 not null,
+    nickname    varchar(100)  null,
+    variables   varchar(200)  null,
+    constraint app_user_pk
+        primary key (id)
+    constraint app_state_app_wallet_id_fk
+        foreign key (state_id) references app_state (id)
+);
+
+create unique index app_user_id_uindex
+    on app_user (id);
+
+create table app_wallet
+(
+    id             int auto_increment,
+    max_co_signers int          not null,
+    min_co_signers int          null,
+    name           varchar(100) null,
+    initiator_id   int          not null,
+    constraint app_wallet_pk
+        primary key (id),
+    constraint app_wallet_app_user_id_fk
+        foreign key (initiator_id) references app_user (id)
+);
+
+create unique index app_wallet_id_uindex
+    on app_wallet (id);