CREATE TABLE IF NOT EXISTS `#__budget_statements` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,

`date` DATE NOT NULL ,
`date_effective` DATE NOT NULL ,
`description` VARCHAR(255)  NOT NULL ,
`amount` VARCHAR(255)  NOT NULL ,
`balance` VARCHAR(255)  NOT NULL ,
`vendor_id` VARCHAR(255)  NOT NULL ,
`account_id` VARCHAR(255)  NOT NULL ,
`ordering` INT(11)  NOT NULL ,
`state` TINYINT(1)  NOT NULL ,
`checked_out` INT(11)  NOT NULL ,
`checked_out_time` DATETIME NOT NULL ,
`created_by` INT(11)  NOT NULL ,
`modified_by` INT(11)  NOT NULL ,
PRIMARY KEY (`id`)
) DEFAULT COLLATE=utf8mb4_unicode_ci;

