-- Generation Time: Jan 03, 2008 at 12:41 PM
-- Server version: 5.0.24
-- PHP Version: 4.4.7

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `imd`
--

-- --------------------------------------------------------

--
-- Table structure for table `files`
--

CREATE TABLE IF NOT EXISTS `files` (
  `id` int(11) NOT NULL auto_increment,
  `code` varchar(5) NOT NULL,
  `owner` mediumint(5) NOT NULL,
  `private` tinyint(1) NOT NULL default '0',
  `filename` tinytext NOT NULL,
  `ratio` float NOT NULL,
  `path` varchar(255) NOT NULL default '',
  `mime` varchar(255) NOT NULL default '',
  `date` int(11) NOT NULL default '0',
  `views` int(4) NOT NULL default '0',
  `who` varchar(20) NOT NULL default '',
  `ip` varchar(15) NOT NULL default '',
  `flagged` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `lusers`
--

CREATE TABLE IF NOT EXISTS `lusers` (
  `uid` mediumint(5) NOT NULL auto_increment,
  `userlevel` tinyint(1) NOT NULL default '0',
  `username` varchar(255) NOT NULL,
  `passwd` varchar(40) NOT NULL,
  `email` varchar(255) NOT NULL,
  `date` int(10) NOT NULL,
  `active` varchar(25) NOT NULL,
  UNIQUE KEY `uid` (`uid`),
  UNIQUE KEY `username` (`username`),
  UNIQUE KEY `email` (`email`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;