· 8 years ago · May 14, 2018, 08:24 PM
1CREATE TABLE IF NOT EXISTS `pages` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `parent` int(11) NOT NULL,
4 `author` varchar(64) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL,
5 PRIMARY KEY (`id`)
6) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
7
8--
9-- Dumping data for table `pages`
10--
11
12INSERT INTO `pages` (`id`, `parent`, `author`) VALUES
13(1, 0, 'admin@jirimedved.cz'),
14(2, 1, 'admin@jirimedved.cz'),
15(3, 1, 'admin@jirimedved.cz'),
16(4, 0, 'admin@jirimedved.cz'),
17(5, 4, 'admin@jirimedved.cz'),
18(6, 5, 'admin@jirimedved.cz');