-
Notifications
You must be signed in to change notification settings - Fork 0
/
books.sql
18 lines (14 loc) · 865 Bytes
/
books.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
CREATE DATABASE IF NOT EXISTS `books`;
USE `books`;
DROP TABLE IF EXISTS `books`;
CREATE TABLE `books` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
`content` longtext COLLATE utf8_unicode_ci NOT NULL,
`author_name` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
`created_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
LOCK TABLES `books` WRITE;
INSERT INTO `books` VALUES (10,'Physics','<p>Theory and Practicals</p>','Sultan Ahmed','2022-06-20 13:50:19'),(20,'Maths','<p>Past Papers Only</p>','Ali Khan','2022-06-20 13:55:47'),(30,'Biology','<p>Past Papers with Practicals</p>','Taimoor Khan','2022-06-20 14:05:03'),(40,'Chemistry','<p>Model Papers with Theory</p>','Uzair Ahmed K.','2022-06-20 14:15:29');
UNLOCK TABLES;