SQL

CREATE TABLE `jale_billings` (
	`id` LONGTEXT NOT NULL COLLATE 'utf8mb3_general_ci',
	`identifier` LONGTEXT NOT NULL COLLATE 'utf8mb3_general_ci',
	`sender` LONGTEXT NOT NULL COLLATE 'utf8mb3_general_ci',
	`recipient` LONGTEXT NOT NULL COLLATE 'utf8mb3_general_ci',
	`reason` LONGTEXT NOT NULL COLLATE 'utf8mb3_general_ci',
	`price` BIGINT(20) NOT NULL DEFAULT '0',
	`status` INT(11) NOT NULL DEFAULT '0',
	`job` LONGTEXT NOT NULL COLLATE 'utf8mb3_general_ci',
	`received_date` TIMESTAMP NOT NULL DEFAULT current_timestamp(),
	`expire_date` TIMESTAMP NOT NULL DEFAULT current_timestamp()
)
COLLATE='utf8mb3_general_ci'
ENGINE=InnoDB
;

Last updated