26 lines
534 B
MySQL
26 lines
534 B
MySQL
|
-- MariaDB script
|
||
|
|
|
||
|
|
-- Create the database
|
||
|
|
CREATE DATABASE librarian;
|
||
|
|
|
||
|
|
-- Use the database
|
||
|
|
USE librarian;
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS bookData;
|
||
|
|
|
||
|
|
-- Table 'BookData'
|
||
|
|
CREATE TABLE bookData (
|
||
|
|
id INT NOT NULL auto_increment PRIMARY KEY,
|
||
|
|
published INT NOT NULL,
|
||
|
|
uuid MEDIUMTEXT NOT NULL,
|
||
|
|
isbn MEDIUMTEXT NOT NULL,
|
||
|
|
title MEDIUMTEXT NOT NULL,
|
||
|
|
lastCheckoutDate INT8,
|
||
|
|
shelf MEDIUMTEXT NOT NULL,
|
||
|
|
checkoutBy MEDIUMTEXT,
|
||
|
|
contact MEDIUMTEXT
|
||
|
|
);
|
||
|
|
|
||
|
|
GRANT ALL PRIVILEGES ON librarian.bookData TO 'admin';
|
||
|
|
FLUSH PRIVILEGES;
|