CREATE TABLE pqr_qrcodes (
qrc_id int(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
qrc_name varchar(250) NOT NULL,
qrc_codes varchar(250) NOT NULL,
qrc_longcodes text NULL,
qrc_desc text NULL,
qrc_redirect varchar(250) NOT NULL,
qrc_nbscan float NOT NULL,
qrc_datemodif datetime NOT NULL,
qrc_datecreate datetime NOT NULL,
qrc_actif int(4) NOT NULL
) CHARACTER SET=utf8mb4 ;
CREATE TABLE pqr_stats_scan (
sta_id int(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
sta_code_id varchar(250) NOT NULL,
sta_locgeo varchar(50) NOT NULL,
sta_locip varchar(50) NOT NULL,
sta_locville varchar(50) NOT NULL,
sta_locpays varchar(50) NOT NULL,
sta_datecreate datetime NOT NULL
) CHARACTER SET=utf8mb4 ;
CREATE TABLE pqr_administra (
adm_id int(4) NOT NULL AUTO_INCREMENT PRIMARY KEY,
adm_login varchar(150) NULL,
adm_password varchar(150) NULL,
adm_identification varchar(150),
adm_email varchar(150) NULL,
adm_tel varchar(20) NULL,
adm_niv int(4) NULL,
adm_visite int(4) NULL,
adm_dateconnect datetime NOT NULL,
adm_datemodif datetime NOT NULL,
adm_datecreate datetime NOT NULL,
adm_actif int(4) NOT NULL
) CHARACTER SET=utf8mb4 ;
