oira666_tg
v1.0.24
Published
tg framework for oira666
Downloads
6
Readme
requires the following mysql db sctructure:
CREATE TABLE `user_chats` (
`user_id` BIGINT(20) NOT NULL DEFAULT '0',
`chat_id` BIGINT(20) NOT NULL DEFAULT '0',
`dt_create` DATETIME NOT NULL,
PRIMARY KEY (`user_id`, `chat_id`) USING BTREE
)
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB
;
CREATE TABLE `user` (
`user_id` BIGINT(20) NOT NULL,
`is_bot` TINYINT(1) NOT NULL,
`language_code` VARCHAR(10) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
`username` VARCHAR(100) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
`first_name` VARCHAR(100) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
`last_name` VARCHAR(100) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
`role` ENUM('user','admin','developer') NOT NULL DEFAULT 'user' COLLATE 'utf8mb4_general_ci',
`dt_create` DATETIME NOT NULL,
`dt_update` DATETIME NULL DEFAULT NULL,
`dt_unsubscribe` DATETIME NULL DEFAULT NULL,
`unsubscribed` TINYINT(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`user_id`) USING BTREE
)
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB
;
CREATE TABLE `session` (
`session_key` VARCHAR(250) NOT NULL COLLATE 'utf8mb4_general_ci',
`user_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
`language_code` VARCHAR(10) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
`data` MEDIUMTEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
`handler_history` MEDIUMTEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
`keyboard` MEDIUMTEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
`expected_input` MEDIUMTEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
`dt_access` DATETIME NOT NULL,
PRIMARY KEY (`session_key`) USING BTREE,
INDEX `user` (`user_id`) USING BTREE
)
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB
;
CREATE TABLE `message_info` (
`message_id` BIGINT(20) NOT NULL,
`user_id` BIGINT(20) NULL DEFAULT NULL,
`chat_id` BIGINT(20) NOT NULL,
`data` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
`dt_create` DATETIME NULL DEFAULT NULL,
PRIMARY KEY (`message_id`, `chat_id`) USING BTREE,
INDEX `user_id` (`user_id`) USING BTREE
)
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB
;
