
create users Table Query

CREATE TABLE usersdemo (
    id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
    first_name VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    user_id VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    last_name VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    picture VARCHAR(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    street_1 VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    street_2 VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    country VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    state VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    city VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    zip_code INT(10) NOT NULL,
    email VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    mobile BIGINT(20) NOT NULL,
    sex VARCHAR(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    user_role VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    status VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    created_by VARCHAR(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    created_date DATETIME NOT NULL,
    updated_by VARCHAR(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    updated_date DATETIME NOT NULL,
    is_deleted INT(1) NOT NULL DEFAULT 0
);


Create activity_log Table

CREATE TABLE activity_log (
    id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
    activity_description VARCHAR(200) COLLATE utf8mb4_general_ci NOT NULL,
    module_name VARCHAR(100) COLLATE utf8mb4_general_ci NOT NULL,
    record_id INT(11) NOT NULL,
    action VARCHAR(100) COLLATE utf8mb4_general_ci NOT NULL,
    created_by VARCHAR(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    created_date DATETIME NOT NULL
);


Create apps Table

CREATE TABLE IF NOT EXISTS apps (
    id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
    app_id VARCHAR(10) COLLATE utf8mb4_general_ci NOT NULL,
    picture VARCHAR(200) COLLATE utf8mb4_general_ci NOT NULL,
    name VARCHAR(100) COLLATE utf8mb4_general_ci NOT NULL,
    app_url VARCHAR(100) COLLATE utf8mb4_general_ci NOT NULL,
    user_role VARCHAR(20) COLLATE utf8mb4_general_ci NOT NULL,
    status INT(1) NOT NULL DEFAULT 0,
    created_by VARCHAR(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    created_date DATETIME NOT NULL,
    updated_by VARCHAR(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    updated_date DATETIME NOT NULL,
    is_deleted INT(1) NOT NULL DEFAULT 0
);
