-
Notifications
You must be signed in to change notification settings - Fork 0
/
library.sql
107 lines (87 loc) · 3.21 KB
/
library.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
-- phpMyAdmin SQL Dump
-- version 4.5.2
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Feb 09, 2017 at 10:53 AM
-- Server version: 5.7.9
-- PHP Version: 5.6.16
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `library`
--
-- --------------------------------------------------------
--
-- Table structure for table `books`
--
DROP TABLE IF EXISTS `books`;
CREATE TABLE IF NOT EXISTS `books` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`author` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`publisher` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`quantity` int(11) NOT NULL,
`categoryId` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `books`
--
INSERT INTO `books` (`id`, `title`, `author`, `publisher`, `quantity`, `categoryId`) VALUES
(27, 'King of war', 'kua of gink', 'sdfsd', 3, 3),
(3, 'Thien Long Bat Bo', 'Kim Dung', 'Van hoc', 104, 1),
(4, 'co gai van chuong', 'Mizuki', 'Thai Ha', 3, 1),
(5, 'Kimi no nawa', 'Matoko Shinkai', 'IPM', 4, 4),
(14, 'Sherlock Holmes', 'Conan Doyle', 'Van Hoc', 4, 2),
(19, 'rừng na uy', 'sdfsd', 'sdfs', 23, 4),
(13, 'Konichiwa', 'Kim Dung', 'Kim Dong', 20, 2),
(15, 'Anh hung xa dieu', 'Kim dung', 'VH', 4, 1),
(16, 'Clean Code', 'Uncle Bob', 'vh cntt', 4, 5),
(17, 'Clean Coder', 'Uncle Bob', 'vh cntt', 5, 5),
(18, 'Khu vuong ngon tinh', 'Makoto Shinkai', 'IPM', 2, 4),
(21, 'đắc nhân tâm', '12', '213', 2, 5),
(26, 'ahihi', 'hihia', 'hiahi', 23, 5),
(24, 'ronaldo', 'ronaldo', 'ronaldo', 3, 1);
-- --------------------------------------------------------
--
-- Table structure for table `categories`
--
DROP TABLE IF EXISTS `categories`;
CREATE TABLE IF NOT EXISTS `categories` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `categories`
--
INSERT INTO `categories` (`id`, `name`) VALUES
(1, 'Kiem hiep'),
(2, 'Trinh tham'),
(3, 'Ngon tinh'),
(4, 'Tieu thuyet'),
(5, 'CNTT');
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
CREATE TABLE IF NOT EXISTS `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`password` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`id`, `username`, `password`) VALUES
(1, 'admin', '21232f297a57a5a743894a0e4a801fc3');
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;