-- Create a new keyspace called 'library'
CREATE KEYSPACE library WITH REPLICATION = { 'class' : 'SimpleStrategy', 'replication_factor' : 1 };
USE library;
 
-- Create a table for authors
CREATE TABLE authors (
    author_id uuid PRIMARY KEY,
    firstname varchar,
    lastname varchar,
    email varchar
);
 
-- Insert an author
INSERT INTO authors (author_id, firstname, lastname, email) VALUES (uuid(), 'Jane', 'Austen', 'janeausten@gmail.com');
 
-- Drop the email column
ALTER TABLE authors DROP email;
 
-- Add a new column 'age'
ALTER TABLE authors ADD age int;
 
-- Insert another author with the new age column
INSERT INTO authors (author_id, firstname, lastname, age) VALUES (uuid(), 'Mark', 'Twain', 45);
 
-- Create a table for books
CREATE TABLE books (
    book_id uuid PRIMARY KEY,
    title varchar,
    author_id uuid,
    publication_date date
);
 
-- Insert a book
INSERT INTO books (book_id, title, author_id, publication_date) VALUES (uuid(), 'Pride and Prejudice', (SELECT author_id FROM authors WHERE firstname='Jane' AND lastname='Austen'), '1813-01-28');
 
-- Querying all authors
SELECT * FROM authors;
 
-- Querying all books
SELECT * FROM books;
 

LS0gQ3JlYXRlIGEgbmV3IGtleXNwYWNlIGNhbGxlZCAnbGlicmFyeScKQ1JFQVRFIEtFWVNQQUNFIGxpYnJhcnkgV0lUSCBSRVBMSUNBVElPTiA9IHsgJ2NsYXNzJyA6ICdTaW1wbGVTdHJhdGVneScsICdyZXBsaWNhdGlvbl9mYWN0b3InIDogMSB9OwpVU0UgbGlicmFyeTsKCi0tIENyZWF0ZSBhIHRhYmxlIGZvciBhdXRob3JzCkNSRUFURSBUQUJMRSBhdXRob3JzICgKICAgIGF1dGhvcl9pZCB1dWlkIFBSSU1BUlkgS0VZLAogICAgZmlyc3RuYW1lIHZhcmNoYXIsCiAgICBsYXN0bmFtZSB2YXJjaGFyLAogICAgZW1haWwgdmFyY2hhcgopOwoKLS0gSW5zZXJ0IGFuIGF1dGhvcgpJTlNFUlQgSU5UTyBhdXRob3JzIChhdXRob3JfaWQsIGZpcnN0bmFtZSwgbGFzdG5hbWUsIGVtYWlsKSBWQUxVRVMgKHV1aWQoKSwgJ0phbmUnLCAnQXVzdGVuJywgJ2phbmVhdXN0ZW5AZ21haWwuY29tJyk7CgotLSBEcm9wIHRoZSBlbWFpbCBjb2x1bW4KQUxURVIgVEFCTEUgYXV0aG9ycyBEUk9QIGVtYWlsOwoKLS0gQWRkIGEgbmV3IGNvbHVtbiAnYWdlJwpBTFRFUiBUQUJMRSBhdXRob3JzIEFERCBhZ2UgaW50OwoKLS0gSW5zZXJ0IGFub3RoZXIgYXV0aG9yIHdpdGggdGhlIG5ldyBhZ2UgY29sdW1uCklOU0VSVCBJTlRPIGF1dGhvcnMgKGF1dGhvcl9pZCwgZmlyc3RuYW1lLCBsYXN0bmFtZSwgYWdlKSBWQUxVRVMgKHV1aWQoKSwgJ01hcmsnLCAnVHdhaW4nLCA0NSk7CgotLSBDcmVhdGUgYSB0YWJsZSBmb3IgYm9va3MKQ1JFQVRFIFRBQkxFIGJvb2tzICgKICAgIGJvb2tfaWQgdXVpZCBQUklNQVJZIEtFWSwKICAgIHRpdGxlIHZhcmNoYXIsCiAgICBhdXRob3JfaWQgdXVpZCwKICAgIHB1YmxpY2F0aW9uX2RhdGUgZGF0ZQopOwoKLS0gSW5zZXJ0IGEgYm9vawpJTlNFUlQgSU5UTyBib29rcyAoYm9va19pZCwgdGl0bGUsIGF1dGhvcl9pZCwgcHVibGljYXRpb25fZGF0ZSkgVkFMVUVTICh1dWlkKCksICdQcmlkZSBhbmQgUHJlanVkaWNlJywgKFNFTEVDVCBhdXRob3JfaWQgRlJPTSBhdXRob3JzIFdIRVJFIGZpcnN0bmFtZT0nSmFuZScgQU5EIGxhc3RuYW1lPSdBdXN0ZW4nKSwgJzE4MTMtMDEtMjgnKTsKCi0tIFF1ZXJ5aW5nIGFsbCBhdXRob3JzClNFTEVDVCAqIEZST00gYXV0aG9yczsKCi0tIFF1ZXJ5aW5nIGFsbCBib29rcwpTRUxFQ1QgKiBGUk9NIGJvb2tzOwo=