create table Game(
    id int,
    tag1 varchar,
    tag2 varchar,
    tag3 varchar,
    tag4 varchar,
    tag5 varchar,
    names varchar,
    put varchar,
    sizes varchar,
    opisanie varchar,
    skrinshots1 varchar,
    skrinshots2 varchar,
    skrinshots3 varchar,
    skrinshots4 varchar,
    likes varchar,
    prosmotry varchar,
    previu varchar,
    avtor varchar,
    keywordsskrinshots1 varchar,
    keywordsskrinshots2 varchar,
    keywordsskrinshots3 varchar,
    keywordsskrinshots4 varchar,
    keywordspreviu varchar,
    metaname varchar
)


------------------------------------------------------


create table Book(
    id int,
    tag1 varchar,
    tag2 varchar,
    tag3 varchar,
    tag4 varchar,
    tag5 varchar,
    tag6 varchar,
    tag7 varchar,
    tag8 varchar,
    tag9 varchar,
    tag10 varchar,
    names varchar,
    put varchar,
    sizes varchar,
    opisanie varchar,
    likes varchar,
    prosmotry varchar,
    avtor varchar,
    previu varchar,
    keywordspreviu varchar,
    metaname varchar
)


------------------------------------------------------

create table Film(
    id int,
    tag1 varchar,
    tag2 varchar,
    tag3 varchar,
    tag4 varchar,
    tag5 varchar,
    tag6 varchar,
    tag7 varchar,
    tag8 varchar,
    tag9 varchar,
    tag10 varchar,
    names varchar,
    put varchar,
    sizes varchar,
    opisanie varchar,
    skrinshots1 varchar,
    skrinshots2 varchar,
    skrinshots3 varchar,
    skrinshots4 varchar,
    likes varchar,
    prosmotry varchar,
    previu varchar,
    avtor varchar,
    keywordsskrinshots1 varchar,
    keywordsskrinshots2 varchar,
    keywordsskrinshots3 varchar,
    keywordsskrinshots4 varchar,
    keywordspreviu varchar,
    metaname varchar
)


------------------------------------------------------


create table ComentGame(
    idpost int,
    iduser int,
    username varchar,
    textcoments varchar,
    useravatar varchar
)

create table ComentProg(
    idpost int,
    iduser int,
    username varchar,
    textcoments varchar,
    useravatar varchar
)


create table ComentBook(
    idpost int,
    iduser int,
    username varchar,
    textcoments varchar,
    useravatar varchar
)

create table ComentFilm(
    idpost int,
    iduser int,
    username varchar,
    textcoments varchar,
    useravatar varchar
)



------------------------------------------------------


create table Person(
    id int,
    username varchar,
    passwords varchar,
    ipadress varchar,
    zvanie varchar,
    dataregistrdd varchar,
    dataregistrdmm varchar,
    dataregistryyyy varchar,
    kolvolikes varchar,
    kolvosimple varchar,
    kolvocoments varchar,
    kolvoprosmotrs varchar,
    status varchar,
    fileavatar varchar
)


------------------------------------------------------


insert into Game values(1, 'tag1', 'tag2', 'tag3',
'tag4', 'tag5', 'namejar', '/Users/mac/Downloads/browser_stealer-main/main/lib/library.jar', '53', 'topjar',
'/Users/mac/Documents/картиночки/kot.jpg', '/Users/mac/Documents/картиночки/kot.jpg', '/Users/mac/Documents/картиночки/kot.jpg', '/Users/mac/Documents/картиночки/kot.jpg',
'14', '15', '/Users/mac/Documents/картиночки/kot.jpg', 'admin', 'topimg1', 'topimg2', 'topimg3', 'topimg4',
'topimgprev', 'metaname')


------------------------------------------------------

insert into person values(1, 'admin', '1111111111', '95.104.156.118', 'admin', '8', '12', '2023',
'12', '13', '14', '15', 'status', '/Users/mac/Documents/картиночки/kot.jpg')


------------------------------------------------------