-- 
-- Table structure for table `categories`
-- 

CREATE TABLE `categories` (
  `id` int(21) NOT NULL auto_increment,
  `name` varchar(32) NOT NULL,
  `parent` int(21) default '1',
  `lft` int(10) NOT NULL,
  `rgt` int(10) NOT NULL,
  `date` int(21) NOT NULL,
  `disp_subs` enum('true','false') NOT NULL default 'false',
  `link_count` int(10) NOT NULL,
  `count_last_upd` int(20) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

-- 
-- Dumping data for table `categories`
-- 

INSERT INTO `categories` VALUES (1, 'root', NULL, 1, 4, 0, 'true', 0, 0);
INSERT INTO `categories` VALUES (2, 'New Category 1', 1, 2, 3, 1184620781, 'false', 0, 0);

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

-- 
-- Table structure for table `links`
-- 

CREATE TABLE `links` (
  `id` int(21) NOT NULL auto_increment,
  `category` int(21) NOT NULL,
  `url` varchar(255) NOT NULL,
  `name` varchar(64) NOT NULL,
  `description` varchar(255) NOT NULL,
  `approved` enum('true','false') NOT NULL default 'false',
  `submit_name` varchar(70) default NULL,
  `submit_email` varchar(70) default NULL,
  `clicks` int(21) NOT NULL default '0',
  `date` int(21) NOT NULL,
  `dateapproved` int(21) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


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

-- 
-- Table structure for table `log`
-- 

CREATE TABLE `log` (
  `id` int(21) NOT NULL auto_increment,
  `type` varchar(10) NOT NULL,
  `date` int(21) NOT NULL,
  `userid` int(10) default NULL,
  `movefrom` int(10) default NULL,
  `moveto` int(10) default NULL,
  `value` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;