ALTER TABLE  `file` ADD  `type` VARCHAR( 2 ) NOT NULL AFTER  `status` ;

--
-- Table structure for table `file_list`
--

CREATE TABLE IF NOT EXISTS `file_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `condo_id` int(11) NOT NULL,
  `file_id` int(11) NOT NULL,
  `filetitle` varchar(100) NOT NULL,
  `description` varchar(300) DEFAULT NULL,
  `filename` varchar(100) NOT NULL,
  `status` varchar(1) NOT NULL DEFAULT 'A',
  `type` varchar(1) NOT NULL,
  `created_datetime` datetime NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

ALTER TABLE  `file_list` ADD  `folder_name` VARCHAR( 100 ) NOT NULL AFTER  `description` ;
ALTER TABLE  `file_list` ADD  `realname` VARCHAR( 100 ) NOT NULL AFTER  `filename` ;