<?php
--
-- Table structure for table `category`
--

CREATE TABLE `category` (
  `category_id` int(10) unsigned NOT NULL auto_increment,
  `category_parent_id` int(10) unsigned default '0',
  `name` varchar(50) NOT NULL default '',
  `calc_name` varchar(100) NOT NULL default '',
  `active` tinyint(1) unsigned NOT NULL default '1',
  `hidden` tinyint(1) unsigned NOT NULL default '1',
  `standard_case_weight` int(10) unsigned default NULL,
  PRIMARY KEY  (`category_id`),
  KEY `IDX_category_name` (`name`),
  KEY `IDX_category_category_parent_id` (`category_parent_id`),
  KEY `IDX_category_active` (`active`),
  KEY `IDX_category_hidden` (`hidden`),
  KEY `IDX_category_active_hidden` (`active`,`hidden`),
  KEY `IDX_standard_case_weight` (`standard_case_weight`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
?>

‹ Account Balance Stored ProcedureupCategory Update Calculated Name Stored Procedure ›