JUniAAKP

1
2--
3-- Table structure for table `config_groups`
4--
5
6CREATE TABLE IF NOT EXISTS `config_groups` (
7  `id` int(11) NOT NULL AUTO_INCREMENT,
8  `client_id` int(11) NOT NULL,
9  `name` varchar(100) NOT NULL,
10  `parent` int(11) NOT NULL,
11  `pos` int(11) NOT NULL,
12  PRIMARY KEY (`id`)
13) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
14
15--
16-- Dumping data for table `config_groups`
17--
18
19INSERT INTO `config_groups` (`id`, `client_id`, `name`, `parent`, `pos`) VALUES
20(1, 1, 'test', 0, 0),
21(2, 1, 'Test Group 2', 0, 0),
22(3, 3, 'test', 0, 0),
23(4, 3, 'test', 0, 0);
24
25-- --------------------------------------------------------
26
27--
28-- Table structure for table `config_items`
29--
30
31CREATE TABLE IF NOT EXISTS `config_items` (
32  `id` int(11) NOT NULL AUTO_INCREMENT,
33  `client_id` int(11) NOT NULL,
34  `group_id` int(11) NOT NULL,
35  `name` varchar(100) NOT NULL,
36  `item` text NOT NULL,
37  `pos` int(11) NOT NULL,
38  PRIMARY KEY (`id`)
39) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
40
41--
42-- Dumping data for table `config_items`
43--
44
45INSERT INTO `config_items` (`id`, `client_id`, `group_id`, `name`, `item`, `pos`) VALUES
46(1, 1, 1, 'Test Config Item 1', 'Sample Item text or something like that', 0),
47(2, 1, 1, 'Test Config Item 2', 'Another Sample Item text. ', 0);
48
49-- --------------------------------------------------------