 -- --------------------------------------------------------
 
 --
+-- Table structure for table `AuthAssignment`
+--
+
+CREATE TABLE IF NOT EXISTS `AuthAssignment` (
+  `itemname` varchar(64) NOT NULL,
+  `userid` varchar(64) NOT NULL,
+  `bizrule` text,
+  `data` text,
+  PRIMARY KEY (`itemname`,`userid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
+-- Dumping data for table `AuthAssignment`
+--
+
+INSERT INTO `AuthAssignment` (`itemname`, `userid`, `bizrule`, `data`) VALUES
+('categoryManager', '1', NULL, NULL),
+('feedbackManager', '1', NULL, NULL);
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `AuthItem`
+--
+
+CREATE TABLE IF NOT EXISTS `AuthItem` (
+  `name` varchar(64) NOT NULL,
+  `type` int(11) NOT NULL,
+  `description` text,
+  `bizrule` text,
+  `data` text,
+  PRIMARY KEY (`name`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
+-- Dumping data for table `AuthItem`
+--
+
+INSERT INTO `AuthItem` (`name`, `type`, `description`, `bizrule`, `data`) VALUES
+('addAdmin', 0, 'viewAdmin', NULL, 'N;'),
+('addCategory', 0, 'addCategory', NULL, 'N;'),
+('adminManager', 2, '', NULL, 'N;'),
+('archiveFeedback', 0, 'archiveFeedback', NULL, 'N;'),
+('baseEditAdmin', 0, 'viewAdmin', NULL, 'N;'),
+('baseEditCategory', 0, 'baseEditCategory', NULL, 'N;'),
+('baseEditFeedback', 0, 'baseEditFeedback', NULL, 'N;'),
+('categoryManager', 2, '', NULL, 'N;'),
+('changePriorityFeedback', 0, 'changePriorityFeedback', NULL, 'N;'),
+('changeStatusFeedback', 0, 'changeStatusFeedback', NULL, 'N;'),
+('deleteAdmin', 0, 'viewAdmin', NULL, 'N;'),
+('deleteCategory', 0, 'deleteCategory', NULL, 'N;'),
+('deleteFeedback', 0, 'deleteFeedback', NULL, 'N;'),
+('editAdmin', 1, 'editAdmin', NULL, 'N;'),
+('editCategory', 1, 'editCategory', NULL, 'N;'),
+('editFeedback', 1, 'editFeedback', NULL, 'N;'),
+('feedbackManager', 2, '', NULL, 'N;'),
+('formManager', 2, '', NULL, 'N;'),
+('moveFeedback', 0, 'moveFeedback', NULL, 'N;'),
+('publishFeedback', 0, 'publishFeedback', NULL, 'N;'),
+('setFlaggedFeedback', 0, 'setFlaggedFeedback', NULL, 'N;'),
+('setStickyFeedback', 0, 'setStickyFeedback', NULL, 'N;'),
+('siteManager', 2, '', NULL, 'N;'),
+('viewAdmin', 0, 'viewAdmin', NULL, 'N;'),
+('viewCategory', 0, 'viewCategory', NULL, 'N;'),
+('viewFeedback', 0, 'viewFeedback', NULL, 'N;'),
+('viewForm', 0, 'viewForm', NULL, 'N;'),
+('viewSite', 0, 'viewSite', NULL, 'N;');
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `AuthItemChild`
+--
+
+CREATE TABLE IF NOT EXISTS `AuthItemChild` (
+  `parent` varchar(64) NOT NULL,
+  `child` varchar(64) NOT NULL,
+  PRIMARY KEY (`parent`,`child`),
+  KEY `child` (`child`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
+-- Dumping data for table `AuthItemChild`
+--
+
+INSERT INTO `AuthItemChild` (`parent`, `child`) VALUES
+('editAdmin', 'addAdmin'),
+('editCategory', 'addCategory'),
+('editFeedback', 'archiveFeedback'),
+('editAdmin', 'baseEditAdmin'),
+('editCategory', 'baseEditCategory'),
+('editFeedback', 'baseEditFeedback'),
+('editFeedback', 'changePriorityFeedback'),
+('editFeedback', 'changeStatusFeedback'),
+('editAdmin', 'deleteAdmin'),
+('editCategory', 'deleteCategory'),
+('editFeedback', 'deleteFeedback'),
+('adminManager', 'editAdmin'),
+('categoryManager', 'editCategory'),
+('feedbackManager', 'editFeedback'),
+('editFeedback', 'moveFeedback'),
+('editFeedback', 'publishFeedback'),
+('editFeedback', 'setFlaggedFeedback'),
+('editFeedback', 'setStickyFeedback'),
+('adminManager', 'viewAdmin'),
+('categoryManager', 'viewCategory'),
+('feedbackManager', 'viewFeedback'),
+('formManager', 'viewForm'),
+('siteManager', 'viewSite');
+
+-- --------------------------------------------------------
+
+--
 -- Table structure for table `Category`
 --
 
 CREATE TABLE IF NOT EXISTS `Category` (
   `categoryId` int(10) unsigned NOT NULL AUTO_INCREMENT,
-  `companyId` int(10) unsigned NOT NULL,
+  `siteId` int(10) unsigned NOT NULL,
   `intName` varchar(45) NOT NULL,
   `name` varchar(45) NOT NULL,
   `changeable` tinyint(1) NOT NULL DEFAULT '1',
   PRIMARY KEY (`categoryId`),
-  KEY `fk_Category_Company1` (`companyId`)
+  KEY `Category_Site_siteId` (`siteId`)
 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
 
 --
 -- Dumping data for table `Category`
 --
 
-INSERT INTO `Category` (`categoryId`, `companyId`, `intName`, `name`, `changeable`) VALUES
+INSERT INTO `Category` (`categoryId`, `siteId`, `intName`, `name`, `changeable`) VALUES
 (1, 1, 'default', 'General', 0),
 (2, 1, 'suggestions', 'Suggestions', 1),
 (3, 1, 'bugs', 'Problems/Bugs', 1),

--

INSERT INTO `Scale` (`scaleId`, `name`, `intName`) VALUES
(1, 'Gradient', 'gradient'),
(2, 'Buttons', 'buttons');

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


-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 14, 2011 at 02:09 PM
-- Server version: 5.1.54
-- PHP Version: 5.3.5-1ubuntu7.2

