Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --
- -- Database: `notebooks`
- --
- -- --------------------------------------------------------
- --
- -- Table structure for table `notebooks`
- --
- CREATE TABLE IF NOT EXISTS `notebooks` (
- `id` int(11) NOT NULL,
- `name` varchar(255) DEFAULT NULL,
- `parent` int(4) NOT NULL DEFAULT '0',
- `active` int(1) NOT NULL DEFAULT '1'
- ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `notebooks`
- --
- INSERT INTO `notebooks` (`id`, `name`, `parent`, `active`) VALUES
- (1, 'Parent Notebook 1', 0, 1),
- (2, 'Parent Notebook 2', 0, 1),
- (3, 'Parent Notebook 3', 0, 1),
- (4, 'Child Notebook 1', 1, 1),
- (5, 'Child Notebook 2', 1, 1),
- (6, 'Parent Notebook 4', 0, 1),
- (7, 'Child Notebook 3', 3, 1),
- (8, 'Child Notebook 4', 3, 1),
- (9, 'Child Notebook 5', 3, 1),
- (10, 'Child Notebook 6', 1, 1);
- -- --------------------------------------------------------
- --
- -- Table structure for table `notes`
- --
- CREATE TABLE IF NOT EXISTS `notes` (
- `id` int(11) NOT NULL,
- `name` varchar(255) DEFAULT NULL,
- `parent` int(11) NOT NULL DEFAULT '0',
- `active` int(11) NOT NULL DEFAULT '1'
- ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `notes`
- --
- INSERT INTO `notes` (`id`, `name`, `parent`, `active`) VALUES
- (1, 'Note 1', 0, 1),
- (2, 'Note 2', 1, 1),
- (3, 'Note 3', 1, 1),
- (4, 'Note 4', 1, 1),
- (5, 'Note 5', 1, 1),
- (6, 'Note 6', 2, 1),
- (7, 'Note 7', 3, 1),
- (8, 'Note 8', 3, 1),
- (9, 'Note 9', 3, 1),
- (10, 'Note 10', 1, 1);
- --
- -- Indexes for dumped tables
- --
- --
- -- Indexes for table `notebooks`
- --
- ALTER TABLE `notebooks`
- ADD PRIMARY KEY (`id`);
- --
- -- Indexes for table `notes`
- --
- ALTER TABLE `notes`
- ADD PRIMARY KEY (`id`);
- --
- -- AUTO_INCREMENT for dumped tables
- --
- --
- -- AUTO_INCREMENT for table `notebooks`
- --
- ALTER TABLE `notebooks`
- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=11;
- --
- -- AUTO_INCREMENT for table `notes`
- --
- ALTER TABLE `notes`
- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=11;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement