با موفقیت اجرا شد!

CREATE DATABASE IF NOT EXISTS yademan1_ErenaDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

×

با موفقیت اجرا شد!

CREATE TABLE IF NOT EXISTS yademan1_ErenaDB.Users ( id INT NOT NULL AUTO_INCREMENT, firstName VARCHAR(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, lastName VARCHAR(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, fatherName VARCHAR(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, baseId INT NOT NULL, phone VARCHAR(14) NOT NULL, password VARCHAR(30) NOT NULL, nationalCode VARCHAR(10), birthDay VARCHAR(15) NOT NULL, image VARCHAR(50), date VARCHAR(30) NOT NULL, status VARCHAR(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (id)) ENGINE = INNODB;

×

با موفقیت اجرا شد!

CREATE TABLE IF NOT EXISTS yademan1_ErenaDB.Notifications ( id INT NOT NULL AUTO_INCREMENT , baseId INT NOT NULL, title VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, description VARCHAR(3000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, maxShowTime VARCHAR(30), date VARCHAR(30) NOT NULL, image VARCHAR(50), status VARCHAR(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (id)) ENGINE = INNODB;

×

با موفقیت اجرا شد!

CREATE TABLE IF NOT EXISTS yademan1_ErenaDB.Bases ( id INT NOT NULL AUTO_INCREMENT, centerId INT NOT NULL, baseName VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, commanderName VARCHAR(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, commanderPhone VARCHAR(14) NOT NULL, address VARCHAR(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, date VARCHAR(30) NOT NULL, status VARCHAR(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (id)) ENGINE = INNODB;

×

با موفقیت اجرا شد!

CREATE TABLE IF NOT EXISTS yademan1_ErenaDB.Submissions ( id INT NOT NULL AUTO_INCREMENT , jobId INT NOT NULL, userId INT NOT NULL, description VARCHAR(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, score Int NOT NULL, date VARCHAR(30) NOT NULL, status VARCHAR (10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (id)) ENGINE = INNODB;

×

با موفقیت اجرا شد!

CREATE TABLE IF NOT EXISTS yademan1_ErenaDB.Files ( id INT NOT NULL AUTO_INCREMENT , submissionId INT, jobId INT, src VARCHAR(50), date VARCHAR(30) NOT NULL, status VARCHAR (10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (id)) ENGINE = INNODB;

×

با موفقیت اجرا شد!

CREATE TABLE IF NOT EXISTS yademan1_ErenaDB.Jobs ( id INT NOT NULL AUTO_INCREMENT , centerId INT NOT NULL, title VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, description VARCHAR(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, maxShowTime VARCHAR(30), date VARCHAR(30) NOT NULL, status VARCHAR (10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (id)) ENGINE = INNODB;

×

با موفقیت اجرا شد!

CREATE TABLE IF NOT EXISTS yademan1_ErenaDB.Roles ( id INT NOT NULL AUTO_INCREMENT , userId INT NOT NULL, addUser VARCHAR (1) NOT NULL, deleteUser VARCHAR (1) NOT NULL, updateUser VARCHAR (1) NOT NULL, updateUsers VARCHAR (1) NOT NULL, getUser VARCHAR (1) NOT NULL, getUsers VARCHAR (1) NOT NULL, getNotifications VARCHAR (1) NOT NULL, addNotification VARCHAR (1) NOT NULL, deleteNotification VARCHAR (1) NOT NULL, updateNotification VARCHAR (1) NOT NULL, addJob VARCHAR (1) NOT NULL, deleteJob VARCHAR (1) NOT NULL, updateJob VARCHAR (1) NOT NULL, getJob VARCHAR (1) NOT NULL, addFile VARCHAR (1) NOT NULL, getFile VARCHAR (1) NOT NULL, deleteFile VARCHAR (1) NOT NULL, addBase VARCHAR (1) NOT NULL, getBases VARCHAR (1) NOT NULL, updateBase VARCHAR (1) NOT NULL, deleteBase VARCHAR (1) NOT NULL, addSubmission VARCHAR (1) NOT NULL, deleteSubmission VARCHAR (1) NOT NULL, updateSubmission VARCHAR (1) NOT NULL, getSubmissions VARCHAR (1) NOT NULL, getBaseInfo VARCHAR (1) NOT NULL, editBaseInfo VARCHAR (1) NOT NULL, PRIMARY KEY (id)) ENGINE = INNODB;

×

با موفقیت اجرا شد!

CREATE TABLE IF NOT EXISTS yademan1_ErenaDB.BaseInfo ( id INT NOT NULL AUTO_INCREMENT , appEnabled VARCHAR(1) NOT NULL, minVersion INT , lastVersion INT , updateTitle VARCHAR(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, updateText VARCHAR(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, updateLink VARCHAR(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, stopTitle VARCHAR(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, stopText VARCHAR(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, messageEnabled VARCHAR(1) NOT NULL , messageTitle VARCHAR(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, messageText VARCHAR(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, uploadUrl VARCHAR(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, isSnow VARCHAR(1) NOT NULL, manager VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, part VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, cneter VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, sendCodeUrl VARCHAR(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, checkCodeUrl VARCHAR(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, status VARCHAR (10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (id)) ENGINE = INNODB;

×

با موفقیت اجرا شد!

CREATE TABLE IF NOT EXISTS yademan1_ErenaDB.Chats ( id INT NOT NULL AUTO_INCREMENT , userId VARCHAR(50) NOT NULL, userName VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, token VARCHAR(100), chanel VARCHAR(30), status VARCHAR (10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (id)) ENGINE = INNODB;

×