CREATE TABLE pp99data_th (
    id INT(11) AUTO_INCREMENT PRIMARY KEY,
    phone_number VARCHAR(255) NOT NULL,
    created_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE gtm_deposit_indo (
    id INT(11) AUTO_INCREMENT PRIMARY KEY,
    phone_number VARCHAR(255) NOT NULL,
    url VARCHAR(255) NOT NULL,
    created_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE pp99data_register_th (
    id INT(11) AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(255) NOT NULL,
    phone_number VARCHAR(255) NOT NULL,
    password VARCHAR(255) NOT NULL, 
    created_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);


CREATE TABLE gtm_depo_indo (
    id INT(11) AUTO_INCREMENT PRIMARY KEY,
    phone_number VARCHAR(255) NOT NULL,
    created_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);


CREATE TABLE gtm_register_indo (
    id INT(11) AUTO_INCREMENT PRIMARY KEY,
    phone_number VARCHAR(255) NOT NULL,
    bank VARCHAR(255) NOT NULL,
    bank_no VARCHAR(255) NOT NULL, 
    bank_name VARCHAR(255) NOT NULL,
    created_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE gtm_register_indo_2 (
    id INT(11) AUTO_INCREMENT PRIMARY KEY,
    phone_number VARCHAR(255) NOT NULL,
    bank VARCHAR(255) NOT NULL,
    bank_no VARCHAR(255) NOT NULL, 
    bank_name VARCHAR(255) NOT NULL,
    created_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE gtm_register_indo_3 (
    id INT(11) AUTO_INCREMENT PRIMARY KEY,
    phone_number VARCHAR(255) NOT NULL,
    bank VARCHAR(255) NOT NULL,
    bank_no VARCHAR(255) NOT NULL, 
    bank_name VARCHAR(255) NOT NULL,
    created_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE gtm_register_indo_4 (
    id INT(11) AUTO_INCREMENT PRIMARY KEY,
    phone_number VARCHAR(255) NOT NULL,
    bank VARCHAR(255) NOT NULL,
    bank_no VARCHAR(255) NOT NULL, 
    bank_name VARCHAR(255) NOT NULL,
    created_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE gtm_register_aud (
    id INT(11) AUTO_INCREMENT PRIMARY KEY,
    phone_number VARCHAR(255) NOT NULL,
    created_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE gtm_register_my (
    id INT(11) AUTO_INCREMENT PRIMARY KEY,
    phone_number VARCHAR(255) NOT NULL,
    created_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE gtm_register_bdt (
    id INT(11) AUTO_INCREMENT PRIMARY KEY,
    phone_number VARCHAR(255) NOT NULL,
    url VARCHAR(255) NOT NULL,
    created_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

ALTER TABLE gtm_register_indo_3
ADD COLUMN url VARCHAR(255);

ALTER TABLE gtm_register_indo_2
ADD COLUMN url VARCHAR(255);

ALTER TABLE gtm_register_my
ADD COLUMN url VARCHAR(255);

ALTER TABLE gtm_register_indo_3
MODIFY bank_no VARCHAR(15);  -- Adjust the length as needed

ALTER TABLE gtm_register_indo_2
MODIFY bank_no VARCHAR(255);  -- Adjust the length as needed