/
PUPBCLMS.sql
12 lines (12 loc) · 1.84 KB
/
PUPBCLMS.sql
1
2
3
4
5
6
7
8
9
10
11
12
CREATE DATABASE PUPBCLMS;
USE PUPBCLMS;
CREATE TABLE Students(ID INT UNSIGNED NOT NULL AUTO_INCREMENT KEY, Name VARCHAR(128), Course VARCHAR(8), Year VARCHAR(8), Section VARCHAR(16), Student_Number VARCHAR(16), Barcode BINARY(255));
CREATE TABLE Admin(ID INT UNSIGNED NOT NULL AUTO_INCREMENT KEY, Name VARCHAR(128), Password VARCHAR(128));
CREATE TABLE Authors(ID INT UNSIGNED NOT NULL AUTO_INCREMENT KEY, Name VARCHAR(128));
CREATE TABLE PUBLISHER(ID INT UNSIGNED NOT NULL AUTO_INCREMENT KEY, Name VARCHAR(128));
CREATE TABLE Library_Stat(ID INT UNSIGNED NOT NULL AUTO_INCREMENT KEY, Name VARCHAR(128), Section VARCHAR(16));
CREATE TABLE Books(ID INT UNSIGNED NOT NULL AUTO_INCREMENT KEY, Author VARCHAR(128), Title VARCHAR(128), Publisher VARCHAR(128),Year CHAR(4), Genre VARCHAR(32));
CREATE TABLE Borrowed_Books(ID INT UNSIGNED NOT NULL AUTO_INCREMENT KEY, Author VARCHAR(128), Title VARCHAR(128), Name VARCHAR(128), Course VARCHAR(8), Year VARCHAR(8), Date_Borrowed DATETIME(6));
CREATE TABLE Search_Books(ID INT UNSIGNED NOT NULL AUTO_INCREMENT KEY, Author VARCHAR(128), Title VARCHAR(128), Publisher VARCHAR(128), Year CHAR(4), Quantity CHAR(4));
CREATE TABLE `tutorial`.`students` ( `id` INT(11) NOT NULL AUTO_INCREMENT , `Last_Name` VARCHAR(128) NOT NULL , `First_Name` VARCHAR(128) NOT NULL , `Course` VARCHAR(8) NOT NULL , `Year` VARCHAR(8) NOT NULL , `Student_Number` VARCHAR(16) NOT NULL , `Contact_Number` INT(11) NOT NULL , `Barcode` INT(11) NOT NULL , `Addr` INT(128) NOT NULL , PRIMARY KEY (`id`), FULLTEXT `Name` (`Last_Name`, `Course`)) ENGINE = InnoDB;
CREATE TABLE `tutorial`.`book` ( `id` INT(11) NOT NULL AUTO_INCREMENT , `Last_Name` VARCHAR(128) NOT NULL , `Name` VARCHAR(32) NOT NULL , `Title` VARCHAR(128) NOT NULL , `Publisher` VARCHAR(128) NOT NULL , `Year` INT(4) NOT NULL , `Genre` VARCHAR(32) NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB;