CREATE TABLE `budgetapprovalsetuptbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cnamefk` int(11) DEFAULT NULL,
  `empfk` int(11) DEFAULT NULL,
  `rolefk` int(11) DEFAULT NULL,
  `status` varchar(45) DEFAULT 'Active',
  `order` int(11) DEFAULT NULL,
  `createdby` int(11) DEFAULT NULL,
  `datecreated` varchar(45) DEFAULT NULL,
  `timecreated` varchar(45) DEFAULT NULL,
  `actiontaken` varchar(45) DEFAULT NULL,
  `takenby` varchar(45) DEFAULT NULL,
  `dateofactiontaken` varchar(45) DEFAULT NULL,
  `timeofactiontaken` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `budgetcurrencysetuptbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cnamefk` int(11) DEFAULT NULL,
  `budgetfk` int(11) DEFAULT NULL,
  `currencyfk` int(11) DEFAULT NULL,
  `conversion_amount` decimal(18,2) DEFAULT '0.00',
  `status` varchar(45) DEFAULT 'Active',
  `createdby` varchar(45) DEFAULT NULL,
  `datecreated` varchar(45) DEFAULT NULL,
  `timecreated` varchar(45) DEFAULT NULL,
  `actiontaken` varchar(45) DEFAULT NULL,
  `takenby` varchar(45) DEFAULT NULL,
  `dateofactiontaken` varchar(45) DEFAULT NULL,
  `timeofactiontaken` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `budgetdeptitemsetuptbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `deptfk` int(11) DEFAULT NULL,
  `budgetitem` text,
  `createdby` varchar(45) DEFAULT NULL,
  `datecreated` varchar(45) DEFAULT NULL,
  `timecreated` varchar(45) DEFAULT NULL,
  `actiontaken` varchar(45) DEFAULT NULL,
  `takenby` int(11) DEFAULT NULL,
  `timeofactiontaken` varchar(45) DEFAULT NULL,
  `dateofactiontaken` varchar(45) DEFAULT NULL,
  `status` varchar(45) DEFAULT 'Active',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
CREATE TABLE `budgetperiodtbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cnamefk` int(11) DEFAULT NULL,
  `year` varchar(45) DEFAULT NULL,
  `status` varchar(45) DEFAULT 'Active',
  `createdby` varchar(45) DEFAULT NULL,
  `datecreated` varchar(45) DEFAULT NULL,
  `timecreated` varchar(45) DEFAULT NULL,
  `actiontaken` varchar(45) DEFAULT NULL,
  `takenby` int(11) DEFAULT NULL,
  `dateofactiontaken` varchar(45) DEFAULT NULL,
  `timeofactiontaken` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

CREATE TABLE `budgetdeptuserrtbl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `deptfk` varchar(45) DEFAULT NULL,
  `empfk` varchar(45) DEFAULT NULL,
  `status` varchar(45) DEFAULT 'Active',
  `createdby` int(11) DEFAULT NULL,
  `datecreated` varchar(45) DEFAULT NULL,
  `timecreated` varchar(45) DEFAULT NULL,
  `actiontaken` varchar(45) DEFAULT NULL,
  `takenby` int(11) DEFAULT NULL,
  `timeofactiontaken` varchar(45) DEFAULT NULL,
  `dateofactiontaken` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;