با موفقیت اجرا شد!CREATE DATABASE IF NOT EXISTS yademan1_FamilyBankDB
CHARACTER SET utf8mb4
COLLATE utf8mb4_unicode_ci
با موفقیت اجرا شد!CREATE TABLE IF NOT EXISTS yademan1_FamilyBankDB.BaseInfos (
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,
messageVersion INT ,
contactUsEnabled VARCHAR(1) NOT NULL ,
supportEnabled VARCHAR(1) NOT NULL ,
uploadUrl VARCHAR(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
isSnow VARCHAR(1) NOT NULL,
usageVideo VARCHAR(500) NOT NULL,
developerPhone VARCHAR(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
supportPhone VARCHAR(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
eitaa VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
eitaaUrl VARCHAR(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
telegram VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
telegramUrl VARCHAR(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
instagram VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
instagramUrl VARCHAR(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
skype VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
skypeUrl VARCHAR(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
email VARCHAR(80) 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_FamilyBankDB.Users (
id INT NOT NULL AUTO_INCREMENT ,
roleId INT NOT NULL,
firstName VARCHAR(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
lastName VARCHAR(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
phone VARCHAR(13) NOT NULL,
email VARCHAR(50),
imageUrl VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
credit Int NOT NULL,
userIdentificationCode INT,
otherIdentificationCode INT,
token VARCHAR(50) 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_FamilyBankDB.InvestmentFunds (
id INT NOT NULL AUTO_INCREMENT,
fundName VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
fundDescription VARCHAR(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
imageUrl 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_FamilyBankDB.LotteryFunds (
id INT NOT NULL AUTO_INCREMENT ,
fundNumber VARCHAR(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
fundName VARCHAR(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
valuePerShare INT NOT NULL,
lotteryTime VARCHAR(30),
lotteryCount INT NOT NULL,
managerShare FLOAT NOT NULL,
useManagerCredit VARCHAR(1) NOT NULL,
conversationId INT NOT NULL,
creditId INT,
balance INT NOT NULL,
showPhoneToMembers VARCHAR(1) 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_FamilyBankDB.Transactions (
id INT NOT NULL AUTO_INCREMENT ,
parentId INT NOT NULL,
transactionNubmer VARCHAR(10) NOT NULL,
transactionPrice INT NOT NULL,
destinationOfMoney INT NOT NULL,
originOfMoney INT NOT NULL,
userId INT NOT NULL,
lotteryId 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_FamilyBankDB.Conversations (
id INT NOT NULL AUTO_INCREMENT ,
destinationLottery INT,
destinationUser INT,
originUser 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_FamilyBankDB.Messages (
id INT NOT NULL AUTO_INCREMENT ,
title VARCHAR(72) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
description VARCHAR(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
parentId INT,
conversationId 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_FamilyBankDB.BankAccounts (
id INT NOT NULL AUTO_INCREMENT ,
creditNumber VARCHAR(16),
shabaNubmer VARCHAR(26),
idPay VARCHAR(50),
userId INT NOT NULL,
lotteryId 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_FamilyBankDB.Tickets (
id INT NOT NULL AUTO_INCREMENT ,
title VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
description VARCHAR(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
categoryId VARCHAR(2),
urgencyPerTen VARCHAR(1),
userId 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_FamilyBankDB.MembershipRequests (
id INT NOT NULL AUTO_INCREMENT ,
userId INT NOT NULL,
investmentId INT NOT NULL,
lotteryId 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_FamilyBankDB.Files (
id INT NOT NULL AUTO_INCREMENT ,
userId INT NOT NULL,
messageId INT,
ticketId INT,
src VARCHAR(50) 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_FamilyBankDB.IdentificationCodes (
id INT NOT NULL AUTO_INCREMENT ,
userId INT NOT NULL,
identificationCode INT 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_FamilyBankDB.Roles (
id INT NOT NULL AUTO_INCREMENT ,
updateBaseInfo VARCHAR (1) NOT NULL,
getBaseInfo VARCHAR (1) NOT NULL,
addUser VARCHAR (1) NOT NULL,
updateUser VARCHAR (1) NOT NULL,
deleteUser VARCHAR (1) NOT NULL,
getUser VARCHAR (1) NOT NULL,
addInvestment VARCHAR (1) NOT NULL,
updateInvestment VARCHAR (1) NOT NULL,
deleteInvestment VARCHAR (1) NOT NULL,
getInvestment VARCHAR (1) NOT NULL,
getAllInvestments VARCHAR (1) NOT NULL,
addLottery VARCHAR (1) NOT NULL,
updateLottery VARCHAR (1) NOT NULL,
deleteLottery VARCHAR (1) NOT NULL,
getLottery VARCHAR (1) NOT NULL,
addTransaction VARCHAR (1) NOT NULL,
updateTransaction VARCHAR (1) NOT NULL,
deleteTransaction VARCHAR (1) NOT NULL,
getTransaction VARCHAR (1) NOT NULL,
getAllTransactions VARCHAR (1) NOT NULL,
addMessage VARCHAR (1) NOT NULL,
updateMessage VARCHAR (1) NOT NULL,
deleteMessage VARCHAR (1) NOT NULL,
getMessage VARCHAR (1) NOT NULL,
addBankAccount VARCHAR (1) NOT NULL,
updateBankAccount VARCHAR (1) NOT NULL,
deleteBankAccount VARCHAR (1) NOT NULL,
getBankAccount VARCHAR (1) NOT NULL,
getAllBankAccounts VARCHAR (1) NOT NULL,
addTicket VARCHAR (1) NOT NULL,
updateTicket VARCHAR (1) NOT NULL,
deleteTicket VARCHAR (1) NOT NULL,
getTicket VARCHAR (1) NOT NULL,
getAllTickets VARCHAR (1) NOT NULL,
addMemberShit VARCHAR (1) NOT NULL,
updateMemberShit VARCHAR (1) NOT NULL,
deleteMemberShit VARCHAR (1) NOT NULL,
getMemberShit VARCHAR (1) NOT NULL,
getAllMemberShits VARCHAR (1) NOT NULL,
addFile VARCHAR (1) NOT NULL,
deleteFile VARCHAR (1) NOT NULL,
addIdentificationCode VARCHAR (1) NOT NULL,
updateIdentificationCode VARCHAR (1) NOT NULL,
deleteIdentificationCode VARCHAR (1) NOT NULL,
getIdentificationCode VARCHAR (1) NOT NULL,
getAllIdentificationCodes VARCHAR (1) NOT NULL,
addRole VARCHAR (1) NOT NULL,
updateRole VARCHAR (1) NOT NULL,
deleteRole VARCHAR (1) NOT NULL,
getRole VARCHAR (1) NOT NULL,
addLotteryFundMember VARCHAR (1) NOT NULL,
updateLotteryFundMember VARCHAR (1) NOT NULL,
deleteLotteryFundMember VARCHAR (1) NOT NULL,
getLotteryFundMember VARCHAR (1) NOT NULL,
getAllLotteryFundMembers VARCHAR (1) 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_FamilyBankDB.LotteryFundMembers (
id INT NOT NULL AUTO_INCREMENT ,
userId VARCHAR(50) NOT NULL,
lotteryId VARCHAR(50) NOT NULL,
roleInLottery VARCHAR(20) NOT NULL,
investmentId 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_FamilyBankDB.HomeSliders (
id INT NOT NULL AUTO_INCREMENT ,
nameFa VARCHAR(20) NOT NULL,
nameEn VARCHAR(20) NOT NULL,
isActive VARCHAR(1) NOT NULL,
showDescription VARCHAR(1) NOT NULL,
date VARCHAR(30) NOT NULL,
status VARCHAR(10) NOT NULL,
PRIMARY KEY (id)) ENGINE = INNODB;
با موفقیت اجرا شد!CREATE TABLE IF NOT EXISTS yademan1_FamilyBankDB.HomeSlid (
id INT NOT NULL AUTO_INCREMENT ,
parentId INT NOT NULL ,
source Varchar(1000) NOT NULL,
type Varchar(20),
action VARCHAR(50),
nameFa VARCHAR(20) NOT NULL,
nameEn VARCHAR(20) NOT NULL,
descriptionFa VARCHAR(100) NOT NULL,
descriptionEn VARCHAR(100) NOT NULL,
imageUrl VARCHAR(500) NOT NULL,
isActive VARCHAR(1) NOT NULL,
date VARCHAR(30) NOT NULL,
status VARCHAR(10) NOT NULL,
PRIMARY KEY (id)) ENGINE = INNODB;
با موفقیت اجرا شد!CREATE TABLE IF NOT EXISTS yademan1_FamilyBankDB.LoanCategory (
id INT NOT NULL AUTO_INCREMENT ,
parentId Int,
type Int NOT NULL,
nameFa VARCHAR(30) NOT NULL,
nameEn VARCHAR(30) NOT NULL,
imageUrl VARCHAR(500),
showOnMainScreen VARCHAR(1) NOT NULL,
date VARCHAR(30) NOT NULL,
status VARCHAR(10) NOT NULL,
PRIMARY KEY (id)) ENGINE = INNODB;
با موفقیت اجرا شد!CREATE TABLE IF NOT EXISTS yademan1_FamilyBankDB.Accessories (
id INT NOT NULL AUTO_INCREMENT ,
parentId Int,
name VARCHAR(30) NOT NULL,
imageUrl VARCHAR(500),
showOnMainScreen VARCHAR(1) NOT NULL,
date VARCHAR(30) NOT NULL,
status VARCHAR(10) NOT NULL,
PRIMARY KEY (id)) ENGINE = INNODB;
با موفقیت اجرا شد!CREATE TABLE IF NOT EXISTS yademan1_FamilyBankDB.Content (
id INT NOT NULL AUTO_INCREMENT ,
providerId INT,
usageId INT,
accessoryId INT,
titleFa VARCHAR(30) NOT NULL,
titleEn VARCHAR(30) NOT NULL,
descriptionFa VARCHAR(8000) NOT NULL,
descriptionEn VARCHAR(8000) NOT NULL,
freemium VARCHAR(1),
limited VARCHAR(1),
label_fa VARCHAR(40),
label_en VARCHAR(40),
date VARCHAR(30) NOT NULL,
status VARCHAR(10) NOT NULL,
PRIMARY KEY (id)) ENGINE = INNODB;
با موفقیت اجرا شد!CREATE TABLE IF NOT EXISTS yademan1_FamilyBankDB.Scrollable (
id INT NOT NULL AUTO_INCREMENT ,
categoryId Int,
filter VARCHAR(50),
titleFa VARCHAR(80) NOT NULL,
titleEn VARCHAR(80) NOT NULL,
date VARCHAR(30) NOT NULL,
status VARCHAR(10) NOT NULL,
PRIMARY KEY (id)) ENGINE = INNODB;