--
-- Table structure for table `document_file`
--

DROP TABLE IF EXISTS `document_file`;
CREATE TABLE `document_file` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `fk_folder_id` int(10) unsigned NOT NULL default '0',
  `name` varchar(255) NOT NULL,
  `ext` varchar(5) NOT NULL default 'nkw',
  `size` bigint(20) NOT NULL default '0',
  `mime` varchar(50) NOT NULL default 'unknow',
  `last_modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `visibility` enum('private','public') default 'private',
  `information` text,
  `public_id` varchar(255) default NULL,
  `deleted` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `deleted` (`deleted`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;