user.sql

CREATE SCHEMA IF NOT EXISTS comics;
-- drop schema comics;
use comics;
CREATE TABLE users (
    username varchar(255) NOT NULL,
    password varchar (255),
    avatar text,
    gmail varchar(255),
    role varchar (255),
    age int, 
    favorite varchar(255),
    comics_followed text,
    PRIMARY KEY (username)
);
select * from users;
insert into users(username, password, avatar, gmail, role, age, favorite, comics_followed) 
values ('g12', '123', 'https://i.imgur.com/HZ86ajE.png', 'g12@usth', 'Admin', '20','','');
-- drop table users;

CREATE TABLE comics (
    title varchar(255) NOT NULL,
    author varchar(255),
    artist varchar(255),
    publisher varchar(255),
    public_date date,
    genre varchar(255),
    volume int,
    series varchar(255),
    cover_image text,
    language varchar(255), 
    synopsis text,
    PRIMARY KEY (title)
);

select * from comics;
-- drop table comics;

CREATE TABLE followed_comics (
	numlist int AUTO_INCREMENT,
    title varchar(255),
    username varchar(255),
    PRIMARY KEY (numlist)
);
select * from followed_comics;
drop table followed_comics;

CREATE TABLE sort (
	order_by varchar(255),
    PRIMARY KEY (
        order_by
    )
);
select * from sort;
-- delete from sort;
-- drop table sort;