--
-- Create schema test
--

CREATE DATABASE IF NOT EXISTS test;
USE test;

--
-- Definition of table `test_table`
--

DROP TABLE IF EXISTS `test_table`;
CREATE TABLE `test_table` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `menuindex` int(10) unsigned NOT NULL,
  `title` varchar(45) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `test_table`
--

INSERT INTO `test_table` (`id`,`menuindex`,`title`) VALUES 
 (1,10,'Item 1'),
 (2,9,'Item 2'),
 (3,8,'Item 3'),
 (4,7,'Item 4'),
 (5,6,'Item 5'),
 (6,5,'Item 6'),
 (7,4,'Item 7'),
 (8,3,'Item 8'),
 (9,2,'Item 9'),
 (10,1,'Item 10');