Database schema for Categories

[eluser]InsiteFX[/eluser]
2 would be alright in your case.

Code:

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

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

CREATE TABLE `categories` (
  `id`              int(11)      unsigned NOT NULL  AUTO_INCREMENT,
  `cat_name`       varchar(255)          NOT NULL  DEFAULT '',
  `cat_short_desc` varchar(255)          NOT NULL  DEFAULT '',
  `cat_long_desc`  text,
  `cat_sort_order` int(3)                NOT NULL  DEFAULT '0',
  `cat_parent_id`  int(11)      unsigned NOT NULL  DEFAULT '0',
  `cat_status`     enum('active','inactive') NOT NULL DEFAULT 'active',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `categories` VALUES (1, 'Products', '', '', 0, 0, 'active');
INSERT INTO `categories` VALUES (2, 'Car', '', '', 0, 1, 'active');
INSERT INTO `categories` VALUES (3, 'Game', '', '', 0, 1, 'active');