Someone

create database elibrary DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_unicode_ci;
use elibrary;
SET NAMES utf8;

CREATE TABLE image(  imgid int(3) unsigned not null auto_increment,
                     imgtype varchar(16) not null default '',
                     imgdata mediumblob,
                     primary key(imgid)
) TYPE = InnoDB;


CREATE TABLE category(  category_id int unsigned not null auto_increment,
			category_nm varchar(50) not null,
                        sup_category_id int unsigned,
                        category_type tinyint(1) not null DEFAULT 0,
                        primary key(category_id),
                        foreign key(sup_category_id) references CATEGORY(category_id) ON DELETE CASCADE ON UPDATE CASCADE
) TYPE = InnoDB;


CREATE table book(  title varchar(100) not null,
                    author varchar(50) not null,
                    publisher varchar(50) not null,
                    isbn char(13) not null unique,
                    year_p year not null,
                    category_id int unsigned not null,
                    copies int not null,
                    summary varchar(500),
                    image_id int(3) unsigned unique,
                    primary key(isbn),
                    foreign key(category_id) references CATEGORY(category_id) ON DELETE CASCADE ON UPDATE CASCADE,
                    foreign key(image_id) references IMAGE(imgid) ON DELETE SET NULL ON UPDATE CASCADE
) TYPE = InnoDB;


CREATE table magazine(  title varchar(100) not null,
                        publisher varchar(50) not null,
                        issn char(13) not null unique,
                        month_p int(2) not null,
                        year_p year not null,
                        category_id int unsigned not null,
                        copies int not null,
                        image_id int(3) unsigned unique,
                        primary key(issn),
                        foreign key(category_id) references CATEGORY(category_id) ON DELETE CASCADE ON UPDATE CASCADE,
                        foreign key(image_id) references IMAGE(imgid) ON DELETE SET NULL ON UPDATE CASCADE
) TYPE = InnoDB;


CREATE table users(  login varchar(20) not null unique,
                     password char(40) not null,
                     name varchar(20) not null,
                     surname varchar(20) not null,
                     address varchar(50) not null,
                     adt char(7) not null unique,
                     email varchar(80) not null unique,
                     utype tinyint(1) not null DEFAULT 0,
                     primary key(adt)
) TYPE = InnoDB;


CREATE table lending(  lending_id int unsigned not null auto_increment,
                       users_login varchar(20) not null,
                       isbn char(13),
                       issn char(13),
                       date_time datetime not null,
                       date_time_ret datetime not null, 
                       primary key(lending_id),
                       foreign key(users_login) references USERS(login) ON DELETE CASCADE ON UPDATE CASCADE,
                       foreign key(isbn) references BOOK(isbn) ON DELETE CASCADE ON UPDATE CASCADE,
                       foreign key(issn) references MAGAZINE(issn) ON DELETE CASCADE ON UPDATE CASCADE
) TYPE = InnoDB;


CREATE table booking(  booking_id int unsigned not null auto_increment,
                       users_login varchar(20) not null,
                       isbn char(13) not null,
                       issn char(13) not null,
                       date_time datetime not null,
                       date_time_exp datetime not null, 
                       primary key(booking_id),
                       foreign key(users_login) references USERS(login) ON DELETE CASCADE ON UPDATE CASCADE,
                       foreign key(isbn) references BOOK(isbn) ON DELETE CASCADE ON UPDATE CASCADE,
                       foreign key(issn) references MAGAZINE(issn) ON DELETE CASCADE ON UPDATE CASCADE
) TYPE = InnoDB;


CREATE table comments(  comment_id int unsigned not null auto_increment,
                        users_login varchar(20) not null,
                        isbn char(13) not null,
                        issn char(13) not null,
                        date_time datetime not null,
                        sxolia varchar(400),
                        rating int(1),
                        primary key(comment_id),
                        foreign key(users_login) references USERS(login) ON DELETE CASCADE ON UPDATE CASCADE,
                        foreign key(isbn) references BOOK(isbn) ON DELETE CASCADE ON UPDATE CASCADE,
                        foreign key(issn) references MAGAZINE(issn) ON DELETE CASCADE ON UPDATE CASCADE
) TYPE = InnoDB;

INSERT INTO USERS values ('admin1' ,sha1('lks@@007') ,'Loukas' , 'Antiohos' ,'Korinthou 185-187' ,'T311037' ,'loukas07@hotmail.com' ,1 );
INSERT INTO USERS values ('admin2' ,sha1('so345air') ,'Panagiwths' , 'Aggelopoulos' ,'Mpoukaourh 104' ,'S611476' ,'aggelopp@hotmail.com' ,1 );
INSERT INTO USERS values ('admin3' ,sha1('popopopo') ,'Antwnhs' , 'Garnelhs' ,'Satwbriandou 66' ,'T458746' ,'garnelis@hotmail.com' ,1 );