   `contactId` bigint(20) unsigned NOT NULL,
   `categoryId` int(10) unsigned NOT NULL,
   `formId` bigint(20) unsigned NOT NULL,
-  `statusId` tinyint(2) unsigned NOT NULL,
+  `status` enum('new','inprogress','closed') DEFAULT NULL,
   `rating` tinyint(1) unsigned NOT NULL,
-  `text` text NOT NULL,
+  `text` varchar(1500) DEFAULT NULL,
   `dtAdded` datetime NOT NULL,
   `isFeatured` tinyint(1) NOT NULL,
   `priority` tinyint(2) unsigned NOT NULL DEFAULT '99',
   `license` tinyint(1) unsigned NOT NULL DEFAULT '1',
+  `textLength` smallint(4) unsigned NOT NULL DEFAULT '0',
+  `isFlagged` tinyint(1) DEFAULT '0',
+  `isPublished` tinyint(1) DEFAULT '0',
+  `isArchived` tinyint(1) DEFAULT '0',
+  `isSticked` tinyint(1) DEFAULT '0',
   PRIMARY KEY (`feedbackId`),
-  KEY `fk_Feedback_Status1` (`statusId`),
-  KEY `fk_Feedback_Contact1` (`contactId`),
-  KEY `fk_Feedback_Form1` (`formId`),
-  KEY `fk_Feedback_Category1` (`categoryId`),
-  KEY `fk_Feedback_Site1` (`siteId`)
-) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
+  KEY `Feedback_Contact_contactId` (`contactId`),
+  KEY `Feedback_Form_formId` (`formId`),
+  KEY `Feedback_Category_categoryId` (`categoryId`),
+  KEY `Feedback_Site_siteId` (`siteId`),
+  KEY `text` (`text`(255))
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=65 ;
 
 --
 -- Dumping data for table `Feedback`
 --
 
-INSERT INTO `Feedback` (`feedbackId`, `siteId`, `contactId`, `categoryId`, `formId`, `statusId`, `rating`, `text`, `dtAdded`, `isFeatured`, `priority`, `license`) VALUES
-(1, 1, 1, 1, 1, 1, 5, 'It''s comfortable, the audio quality is great, the mic. folds out of the way nicely, It has a mic. mute button and volume control with a clip so I can clip it to my shirt and i can always find it. And best of all the lights!', '2011-02-07 12:35:02', 1, 50, 1),
-(2, 1, 2, 1, 1, 1, 5, 'I like the non-slip ruber texture on the keys and the backlight, I also like that all the keys are programable', '2011-01-15 13:02:48', 0, 30, 1),
-(3, 1, 3, 2, 1, 1, 4, 'I like the Backlight and the profile management. The "keys" are soft and I like its revestiment', '2011-01-31 18:12:27', 1, 20, 2);
+INSERT INTO `Feedback` (`feedbackId`, `siteId`, `contactId`, `categoryId`, `formId`, `status`, `rating`, `text`, `dtAdded`, `isFeatured`, `priority`, `license`, `textLength`, `isFlagged`, `isPublished`, `isArchived`, `isSticked`) VALUES
+(1, 1, 1, 1, 1, 'inprogress', 5, 'sodkoskgos odkgo skdogk skdogksod giw egureo gjerip gpejrgj ipergp kerogk[ kw[ekgo kweiogkj iwekgi jigji sdgok sodkgo skdogks odkgosdk gosjdigjiwje wepkg dijg weirgj ergoijerg erpiojg eprjg oerog rgjr ijieji eij gjdgj djgdklj dgsd ;gs;dg sdijgspdgjspdgjsdipgjspdgjisodpfjivjsdv ckdsmcosdk', '2011-02-07 12:35:02', 1, 20, 2, 253, 0, 0, 0, 0),
+(3, 1, 3, 2, 1, 'new', 4, 'I like the Backlight and the profile management. The "keys" are soft and I like its revestiment', '2011-01-31 18:12:27', 1, 20, 2, 95, 0, 0, 0, 0),
+(4, 1, 4, 1, 1, 'new', 5, 'The keyboard is cool for hacking terminators :)', '2011-02-15 18:12:27', 1, 60, 3, 47, 0, 0, 0, 0),
+(5, 1, 21, 1, 1, 'new', 5, 'qwrerewrwe', '2011-04-22 19:22:48', 1, 0, 2, 10, 0, 0, 0, 0),
+(6, 1, 23, 1, 1, 'new', 5, 'fggdfgdfg', '2011-04-22 20:20:49', 0, 0, 1, 9, 0, 0, 0, 0),
+(9, 1, 27, 1, 1, 'new', 4, 'review', '2011-04-25 15:26:14', 1, 0, 3, 6, 0, 0, 0, 0),
+(10, 1, 28, 1, 1, 'new', 4, 'another review', '2011-04-25 15:29:01', 1, 0, 2, 14, 0, 0, 0, 0),
+(11, 1, 34, 1, 1, 'new', 5, 'werwerwe re wer werewrwer', '2011-04-27 12:14:26', 0, 0, 1, 25, 0, 0, 0, 0),
+(12, 1, 35, 1, 1, 'new', 5, 'werwerwe re wer werewrwer', '2011-04-27 12:18:45', 0, 0, 1, 25, 0, 0, 0, 0),
+(13, 1, 36, 1, 1, 'new', 5, 'gfdgdfgfd', '2011-04-27 12:30:57', 0, 0, 1, 9, 0, 0, 0, 0),
+(14, 1, 37, 1, 1, 'new', 5, 'qwerty', '2011-04-27 12:32:11', 0, 0, 1, 6, 0, 0, 0, 0),
+(15, 1, 38, 1, 1, 'new', 5, 'qwe', '2011-04-27 13:46:55', 1, 0, 2, 3, 0, 0, 0, 0),
+(16, 1, 43, 1, 1, 'new', 5, 'dfvdsfdsfdsvsdf', '2011-04-27 16:58:12', 0, 0, 3, 15, 0, 0, 0, 0),
+(17, 1, 44, 1, 1, 'new', 5, 'dfvdsfdsfdsvsdf\r\n\r\nfdsfsdfsdf', '2011-04-27 16:58:40', 1, 0, 3, 29, 0, 0, 0, 0),
+(18, 1, 52, 1, 1, 'new', 5, 'fdgdfgdfg', '2011-04-27 18:44:32', 1, 0, 1, 9, 0, 0, 0, 0),
+(19, 1, 53, 1, 1, 'new', 5, 'mega new', '2011-04-27 18:59:35', 1, 0, 3, 8, 0, 0, 0, 0),
+(20, 1, 54, 1, 1, 'new', 5, 'qwewqeqw\r\newq\r\neq\r\ne\r\nwqeqwewqeqwe', '2011-04-28 17:18:26', 1, 20, 2, 34, 0, 0, 0, 0),
+(21, 1, 55, 1, 1, 'new', 5, 'qwe', '2011-04-28 23:19:38', 0, 0, 2, 3, 0, 0, 0, 0),
+(22, 1, 56, 1, 1, 'new', 5, 'qwe', '2011-04-28 23:21:32', 0, 0, 2, 3, 0, 0, 0, 0),
+(23, 1, 57, 1, 1, 'new', 5, 'fdsfdsfdsfsdfs', '2011-04-28 23:25:38', 0, 0, 3, 14, 0, 0, 0, 0),
+(24, 1, 58, 1, 1, 'new', 5, 'fdsfdsfdsfsdfs', '2011-04-28 23:26:31', 0, 0, 3, 14, 0, 0, 0, 0),
+(25, 1, 59, 1, 1, 'new', 5, 'fdgfgfdgdfg\r\ngdfgdfgfd', '2011-04-28 23:27:15', 0, 0, 1, 22, 0, 0, 0, 0),
+(26, 1, 60, 1, 1, 'new', 5, 'fdgfgfdgdfg\r\ngdfgdfgfd', '2011-04-28 23:27:23', 0, 0, 1, 22, 0, 0, 0, 0),
+(27, 1, 61, 1, 1, 'new', 5, 'wqewqeq', '2011-04-28 23:29:08', 0, 0, 1, 7, 0, 0, 0, 0),
+(28, 1, 62, 1, 1, 'new', 5, 'wqewqeq', '2011-04-28 23:30:39', 0, 0, 1, 7, 0, 0, 0, 0),
+(29, 1, 76, 1, 1, 'new', 5, NULL, '2011-04-29 18:24:57', 0, 0, 1, 37, 0, 0, 0, 0),
+(30, 1, 77, 1, 1, 'new', 5, NULL, '2011-04-29 18:29:16', 0, 0, 1, 37, 0, 0, 0, 0),
+(31, 1, 82, 1, 1, 'new', 5, '', '2011-04-29 18:41:30', 0, 0, 1, 0, 0, 0, 0, 0),
+(32, 1, 83, 1, 1, 'new', 5, '', '2011-04-29 19:25:41', 0, 0, 1, 0, 0, 0, 0, 0),
+(33, 1, 84, 1, 1, 'new', 5, 'sfdfsdfdfsdfdsfdsfsdfsd\nfsdfsdfsddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd', '2011-04-29 19:31:01', 0, 0, 1, 193, 0, 0, 0, 0),
+(34, 1, 85, 1, 1, 'new', 5, 'qwerty', '2011-04-29 19:31:37', 0, 0, 1, 6, 0, 0, 0, 0),
+(35, 1, 86, 1, 1, 'new', 5, 'qwerty', '2011-04-29 19:31:39', 0, 0, 1, 6, 0, 0, 0, 0),
+(36, 1, 87, 1, 1, 'new', 5, 'qwerty', '2011-04-29 19:31:41', 0, 0, 1, 6, 0, 0, 0, 0),
+(37, 1, 88, 1, 1, 'new', 5, 'qwerty', '2011-04-29 19:31:42', 0, 0, 1, 6, 0, 0, 0, 0),
+(38, 1, 89, 1, 1, 'new', 5, 'qwerty', '2011-04-29 19:31:43', 0, 0, 1, 6, 0, 0, 0, 0),
+(39, 1, 90, 1, 1, 'new', 5, 'qwerty', '2011-04-29 19:31:44', 0, 0, 1, 6, 0, 0, 0, 0),
+(40, 1, 91, 1, 1, 'new', 5, 'gdfgdfg', '2011-04-29 19:38:06', 0, 0, 1, 7, 0, 0, 0, 0),
+(41, 1, 92, 1, 1, 'new', 5, 'qwerer\nrwe\nrw\nerwerwerwer', '2011-04-29 19:52:17', 0, 0, 1, 25, 0, 0, 0, 0),
+(42, 1, 92, 1, 1, 'new', 5, 'qwerer\nrwe\nrw\nerwerwerwer', '2011-04-29 19:52:28', 0, 0, 1, 25, 0, 0, 0, 0),
+(43, 1, 93, 1, 1, 'new', 3, 'gfgdgdfg\ndfgdfgdfgfd', '2011-04-29 19:56:21', 0, 0, 3, 20, 0, 0, 0, 0),
+(44, 1, 93, 1, 1, 'new', 3, 'gfgdgdfg\ndfgdfgdfgfd', '2011-04-29 20:13:23', 0, 0, 3, 20, 0, 0, 0, 0),
+(45, 1, 93, 1, 1, 'new', 3, 'gfgdgdfg\ndfgdfgdfgfd', '2011-04-29 20:13:40', 0, 0, 3, 20, 0, 0, 0, 0),
+(46, 1, 93, 1, 1, 'new', 3, 'gfgdgdfg\ndfgdfgdfgfd', '2011-04-29 20:13:42', 0, 0, 3, 20, 0, 0, 0, 0),
+(47, 1, 93, 1, 1, 'new', 3, 'gfgdgdfg\ndfgdfgdfgfd', '2011-04-29 20:13:43', 0, 0, 3, 20, 0, 0, 0, 0),
+(48, 1, 93, 1, 1, 'new', 3, 'gfgdgdfg\ndfgdfgdfgfd', '2011-04-29 20:13:43', 0, 0, 3, 20, 0, 0, 0, 0),
+(49, 1, 93, 1, 1, 'new', 3, 'gfgdgdfg\ndfgdfgdfgfd', '2011-04-29 20:13:44', 0, 0, 3, 20, 0, 0, 0, 0),
+(50, 1, 93, 1, 1, 'new', 3, 'gfgdgdfg\ndfgdfgdfgfd', '2011-04-29 20:13:44', 0, 0, 3, 20, 0, 0, 0, 0),
+(51, 1, 93, 1, 1, 'new', 3, 'gfgdgdfg\ndfgdfgdfgfd', '2011-04-29 20:13:45', 0, 0, 3, 20, 0, 0, 0, 0),
+(52, 1, 93, 1, 1, 'new', 3, 'gfgdgdfg\ndfgdfgdfgfd', '2011-04-29 20:13:45', 0, 0, 3, 20, 0, 0, 0, 0),
+(53, 1, 93, 1, 1, 'new', 3, 'gfgdgdfg\ndfgdfgdfgfd', '2011-04-29 20:13:45', 0, 0, 3, 20, 0, 0, 0, 0),
+(54, 1, 93, 1, 1, 'new', 3, 'gfgdgdfg\ndfgdfgdfgfd', '2011-04-29 20:13:45', 0, 0, 3, 20, 0, 0, 0, 0),
+(55, 1, 93, 1, 1, 'new', 3, 'gfgdgdfg\ndfgdfgdfgfd', '2011-04-29 20:13:46', 0, 0, 3, 20, 0, 0, 0, 0),
+(56, 1, 93, 1, 1, 'new', 3, 'gfgdgdfg\ndfgdfgdfgfd', '2011-04-29 20:13:46', 0, 0, 3, 20, 0, 0, 0, 0),
+(57, 1, 93, 1, 1, 'new', 3, 'gfgdgdfg\ndfgdfgdfgfd', '2011-04-29 20:13:46', 0, 0, 3, 20, 0, 0, 0, 0),
+(58, 1, 93, 1, 1, 'new', 3, 'gfgdgdfg\ndfgdfgdfgfd', '2011-04-29 20:14:08', 0, 0, 3, 20, 0, 0, 0, 0),
+(59, 1, 93, 1, 1, 'new', 3, 'gfgdgdfg\ndfgdfgdfgfd', '2011-04-29 20:16:16', 0, 0, 3, 20, 0, 0, 0, 0),
+(60, 1, 93, 1, 1, 'new', 3, 'gfgdgdfg\ndfgdfgdfgfd', '2011-04-29 20:17:07', 0, 0, 3, 20, 0, 0, 0, 0),
+(61, 1, 93, 1, 1, 'new', 3, 'gfgdgdfg\ndfgdfgdfgfd', '2011-04-29 20:17:43', 0, 0, 3, 20, 0, 0, 0, 0),
+(62, 1, 94, 1, 1, 'new', 5, 'qwerty', '2011-06-07 15:35:40', 0, 0, 1, 6, 0, 0, 0, 0),
+(63, 1, 95, 1, 1, 'new', 4, 'gh', '2011-06-15 19:28:16', 0, 0, 1, 2, 0, 0, 0, 0),
+(64, 1, 1, 1, 1, 'new', 1, 'BAD!!!!!!', '2011-06-17 15:04:31', 0, 99, 1, 9, 0, 0, 0, 0);
 
 -- --------------------------------------------------------
 

  `help` text NOT NULL,
  `scaleId` smallint(5) unsigned NOT NULL,
  `displayData` text NOT NULL,
  PRIMARY KEY (`formId`),
  KEY `fk_Form_Theme1` (`themeId`),
  KEY `fk_Form_Scale1` (`scaleId`),
  KEY `fk_Form_Site1` (`siteId`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `Form`
--

INSERT INTO `Form` (`formId`, `siteId`, `themeId`, `title`, `help`, `scaleId`, `displayData`) VALUES
(1, 1, 3, 'Leave your feedback for Razer LLC', 'Don''t know what to write?', 2, '{"firstName": "true","lastName": "true","position": "false","location": "true","company": "false","date": "true","picture": "true"}');

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


--

INSERT INTO `sessions` (`id`, `last_activity`, `data`) VALUES
('vqnew89v3Tu6HLgiWOs5sMLlx6vxhvkM8s0v1l3d', 1310577597, 'a:3:{s:10:"csrf_token";s:16:"88tU4JWtrnqEx5Jl";s:11:"s36_user_id";s:1:"1";s:22:":old:laravel_old_input";a:0:{}}'),
('QXb9e5cKsoGbZxbYvkfPfMU1pk380RVsdmZJ5qVF', 1310623383, 'a:3:{s:10:"csrf_token";s:16:"BqUjMRinlweR8oOI";s:11:"s36_user_id";s:1:"1";s:22:":old:laravel_old_input";a:0:{}}'),
('puSQkDuUu8rzZexyV7JJwpg2SxHK8Tr23mI0EHP0', 1310573510, 'a:3:{s:10:"csrf_token";s:16:"8GlqX5LUI1XZvT9d";s:11:"s36_user_id";s:1:"1";s:22:":old:laravel_old_input";a:0:{}}');

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

