--
-- Table structure for table `smf_works_categories`
--

CREATE TABLE IF NOT EXISTS `smf_works_categories` (
  `id_cat` tinyint(4) unsigned NOT NULL DEFAULT '0',
  `cat_order` tinyint(4) DEFAULT NULL,
  `cat_name` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `cat_desc` text CHARACTER SET utf8
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `smf_works_categories`
--

INSERT INTO `smf_works_categories` (`id_cat`, `cat_order`, `cat_name`, `cat_desc`) VALUES
(1, 1, 'Creative Writing', 'creative writing desc'),
(2, 2, 'Nonfiction Writing', 'nonfiction writing desc'),
(3, 3, 'Arts (Mental)', 'mental arts desc'),
(4, 4, 'Arts (Physical)', 'physical arts desc');

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

--
-- Table structure for table `smf_works_types`
--

CREATE TABLE IF NOT EXISTS `smf_works_types` (
`id_type` smallint(5) unsigned NOT NULL,
  `id_cat` tinyint(4) unsigned NOT NULL,
  `id_parent` smallint(5) unsigned NOT NULL,
  `child_level` tinyint(4) unsigned NOT NULL,
  `type_order` smallint(5) NOT NULL,
  `type_name` varchar(255) CHARACTER SET utf8 NOT NULL,
  `type_desc` text CHARACTER SET utf8 NOT NULL,
  `num_works` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `num_comments` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `unapproved_comments` smallint(5) unsigned NOT NULL DEFAULT '0'
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `smf_works_types`
--

INSERT INTO `smf_works_types` (`id_type`, `id_cat`, `id_parent`, `child_level`, `type_order`, `type_name`, `type_desc`, `num_works`, `num_comments`, `unapproved_comments`) VALUES
(1, 1, 0, 0, 1, 'Poetry', 'desc', 0, 0, 0),
(2, 1, 0, 0, 2, 'Screenplay', 'desc', 0, 0, 0),
(3, 1, 0, 0, 3, 'FanFiction', 'desc', 0, 0, 0),
(4, 1, 0, 0, 4, 'Stories', 'desc', 0, 0, 0),
(5, 1, 0, 0, 5, 'Lyrics', 'desc', 0, 0, 0),
(6, 1, 0, 0, 6, 'Blogs', 'desc', 0, 0, 0),
(7, 2, 0, 0, 7, 'Journalism', 'desc', 0, 0, 0),
(8, 2, 0, 0, 8, 'Tutorial', 'desc', 0, 0, 0),
(9, 2, 0, 0, 8, 'Guide', 'desc', 0, 0, 0),
(10, 2, 0, 0, 10, 'Essay/Report', 'desc', 0, 0, 0),
(11, 3, 0, 0, 11, 'Music', 'desc', 0, 0, 0),
(12, 3, 0, 0, 12, 'Illustration', 'desc', 0, 0, 0),
(13, 3, 0, 0, 13, 'Comic', 'desc', 0, 0, 0),
(14, 3, 0, 0, 14, 'Website Design', 'desc', 0, 0, 0),
(15, 3, 0, 0, 15, 'Sound Effect', 'desc', 0, 0, 0),
(16, 3, 0, 0, 16, 'Drawing', 'desc', 0, 0, 0),
(17, 3, 0, 0, 17, 'Painting', 'desc', 0, 0, 0),
(18, 4, 0, 0, 18, 'Performance Art', 'desc', 0, 0, 0),
(19, 4, 0, 0, 19, 'Taxidermy', 'desc', 0, 0, 0),
(20, 4, 0, 0, 20, 'Sculpture', 'desc', 0, 0, 0),
(21, 4, 0, 0, 21, 'Crafts', 'desc', 0, 0, 0),
(22, 4, 0, 0, 22, 'Ceramics', 'desc', 0, 0, 0),
(23, 4, 18, 1, 23, 'Presentation', 'desc', 0, 0, 0),
(24, 4, 18, 1, 24, 'Dance', 'desc', 0, 0, 0),
(25, 4, 18, 1, 25, 'Acting', 'desc', 0, 0, 0),
(26, 4, 21, 1, 26, 'Jewelery', 'desc', 0, 0, 0),
(27, 4, 21, 1, 27, 'Knitting', 'desc', 0, 0, 0),
(28, 1, 1, 1, 28, 'Sonnet', 'desc', 0, 0, 0),
(29, 1, 1, 1, 29, 'Ballad', 'desc', 0, 0, 0),
(30, 1, 1, 1, 30, 'Ode', 'desc', 0, 0, 0),
(31, 1, 4, 1, 31, 'Short Story', 'desc', 0, 0, 0),
(32, 1, 4, 1, 32, 'Novel', 'desc', 0, 0, 0);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `smf_works_categories`
--
ALTER TABLE `smf_works_categories`
 ADD PRIMARY KEY (`id_cat`);

--
-- Indexes for table `smf_works_types`
--
ALTER TABLE `smf_works_types`
 ADD PRIMARY KEY (`id_type`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `smf_works_types`
--
ALTER TABLE `smf_works_types`
MODIFY `id_type` smallint(5) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=33;