Просмотр архива скрипт ФриЛенсера ДЕМО Дерьмо (Рукожопная Версия)

DROP TABLE IF EXISTS `admin_perms`;
CREATE TABLE `admin_perms` (
  `id` int
NOT NULL AUTO_INCREMENT,
  `name_perm` varchar(255) NOT NULL,
 
`design_prefix` mediumtext NOT NULL,
  `manage_deal` int NOT NULL,
 
`edit_users` int NOT NULL,
  `edit_works` int NOT NULL,
  `edit_categories`
int NOT NULL,
  `edit_sections` int NOT NULL,
  `edit_subcategories` int
NOT NULL,
  `edit_site_info` int NOT NULL,
  `edit_group` int NOT NULL,
 
`edit_modules` int NOT NULL,
  `edit_solutions` int NOT NULL,
 
`edit_templates` int NOT NULL,
  `edit_operator_details` int NOT NULL,
 
`confirm_transfers` int NOT NULL,
  `manage_payment` int NOT NULL,
 
`del_feedback` int NOT NULL,
  `view_del_comments` int NOT NULL,
 
`us_support` int NOT NULL,
  `manage_nodes` int NOT NULL,
 
`view_dashboard` int NOT NULL,
  `manage_update` int NOT NULL,
  PRIMARY
KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_0900_ai_ci;

DROP TABLE IF EXISTS `cart`;
CREATE TABLE
`cart` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `us` int unsigned
NOT NULL,
  `k_work` int unsigned NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

DROP
TABLE IF EXISTS `category`;
CREATE TABLE `category` (
  `id` int NOT NULL
AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` text NOT
NULL,
  `k_image` varchar(255) CHARACTER SET utf8mb4 COLLATE
utf8mb4_0900_ai_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT
CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

DROP TABLE IF EXISTS
`disputes`;
CREATE TABLE `disputes` (
  `id` int unsigned NOT NULL
AUTO_INCREMENT,
  `status_disp` int NOT NULL,
  `us_open_disp` int unsigned
NOT NULL,
  `deal_disp` int unsigned NOT NULL,
  `info_disp` mediumtext NOT
NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_0900_ai_ci;

DROP TABLE IF EXISTS
`general_parameters`;
CREATE TABLE `general_parameters` (
  `id` int NOT
NULL,
  `delay_time_funds` varchar(255) NOT NULL,
  `deal_commission`
tinyint unsigned NOT NULL,
  `conclusion_commission` tinyint unsigned NOT
NULL,
  `email_support` varchar(255) NOT NULL,
  `theme` varchar(255)
CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `up_interval`
int NOT NULL DEFAULT '14400',
  `site_landing` int NOT NULL
) ENGINE=InnoDB
DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

DROP TABLE IF EXISTS
`messages`;
CREATE TABLE `messages` (
  `id` int unsigned NOT NULL
AUTO_INCREMENT,
  `sender_id` int unsigned NOT NULL,
  `receiver_id` int
unsigned NOT NULL,
  `readed` int NOT NULL,
  `k_text` text CHARACTER SET
utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `attachment` varchar(255)
DEFAULT NULL,
  `created_at` varchar(255) DEFAULT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_0900_ai_ci;

DROP TABLE IF EXISTS
`operator_details`;
CREATE TABLE `operator_details` (
  `id` int NOT NULL
AUTO_INCREMENT,
  `operator_type` int NOT NULL,
  `operator_email`
varchar(255) NOT NULL,
  `operator_address` varchar(255) NOT NULL,
 
`ip_fullname` varchar(255) NOT NULL,
  `ip_inn` varchar(255) NOT NULL,
 
`ip_ogrnip` varchar(255) NOT NULL,
  `ooo_name` varchar(255) NOT NULL,
 
`ooo_inn` varchar(255) NOT NULL,
  `ooo_ogrn` varchar(255) NOT NULL,
 
PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_0900_ai_ci;

DROP TABLE IF EXISTS `payout`;
CREATE TABLE
`payout` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `us` int unsigned
NOT NULL,
  `requisites` varchar(255) NOT NULL,
  `k_order` varchar(255)
CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `summ`
decimal(10,2) NOT NULL,
  `stade` int NOT NULL,
  `k_time` varchar(255)
CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `answer` text
CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `commiss`
tinyint unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT
CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

DROP TABLE IF EXISTS
`plugin_settings`;
CREATE TABLE `plugin_settings` (
  `plugin` varchar(64)
NOT NULL,
  `setting_key` varchar(255) NOT NULL,
  `setting_value` text NOT
NULL,
  UNIQUE KEY `unique_plugin_setting` (`plugin`,`setting_key`)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

DROP
TABLE IF EXISTS `plugins`;
CREATE TABLE `plugins` (
  `id` varchar(64) NOT
NULL,
  `type` varchar(32) DEFAULT NULL,
  `name` varchar(128) DEFAULT
NULL,
  `status` tinyint(1) DEFAULT '1',
  `missing` tinyint(1) DEFAULT
NULL,
  `version` varchar(128) DEFAULT NULL,
  `settings` text,
  PRIMARY
KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_0900_ai_ci;

DROP TABLE IF EXISTS `project_profit`;
CREATE
TABLE `project_profit` (
  `id` int NOT NULL AUTO_INCREMENT,
  `fullprofit`
decimal(10,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

DROP TABLE IF EXISTS
`rating`;
CREATE TABLE `rating` (
  `id` int unsigned NOT NULL
AUTO_INCREMENT,
  `worker` int unsigned NOT NULL,
  `us` int unsigned NOT
NULL,
  `rating` int NOT NULL,
  `k_work` int unsigned NOT NULL,
 
`k_comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT
NULL,
  `deal` int unsigned NOT NULL,
  `del` varchar(255) NOT NULL,
 
`salt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT
NULL,
  PRIMARY KEY (`id`),
  KEY `k_work` (`k_work`)
) ENGINE=InnoDB 
DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

DROP TABLE IF EXISTS
`rating_comments`;
CREATE TABLE `rating_comments` (
  `id` int unsigned NOT
NULL AUTO_INCREMENT,
  `rating_id` int unsigned NOT NULL,
  `us` int
unsigned NOT NULL,
  `message` text NOT NULL,
  `created_at` varchar(255)
NOT NULL,
  `changed_at` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

DROP
TABLE IF EXISTS `rating_comments_history`;
CREATE TABLE
`rating_comments_history` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
 
`comment_id` int unsigned NOT NULL,
  `old_message` text NOT NULL,
 
`new_message` text NOT NULL,
  `changed_by` int unsigned NOT NULL,
 
`changed_at` varchar(255) NOT NULL,
  `created_at` varchar(255) NOT NULL,
 
`deleted_at` varchar(255) NOT NULL,
  `deal` int unsigned NOT NULL,
 
`rating_id` int unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB 
DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

DROP TABLE IF EXISTS
`rating_history`;
CREATE TABLE `rating_history` (
  `id` int unsigned NOT
NULL AUTO_INCREMENT,
  `rating_id` int unsigned NOT NULL,
  `deal` int
unsigned NOT NULL,
  `us` int unsigned NOT NULL,
  `worker` int unsigned
NOT NULL,
  `rating` int NOT NULL,
  `k_work` int unsigned NOT NULL,
 
`k_comment` text NOT NULL,
  `created_at` int unsigned NOT NULL,
 
`deleted_at` int unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

DROP
TABLE IF EXISTS `recover_user`;
CREATE TABLE `recover_user` (
  `email`
varchar(255) NOT NULL,
  `code` char(6) NOT NULL,
  PRIMARY KEY (`email`)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

DROP
TABLE IF EXISTS `section`;
CREATE TABLE `section` (
  `id` int NOT NULL
AUTO_INCREMENT,
  `category` int NOT NULL,
  `name` varchar(255) NOT NULL,

 `k_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci
NOT NULL,
  `subcategory` int NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

DROP
TABLE IF EXISTS `select_works`;
CREATE TABLE `select_works` (
  `id` int
unsigned NOT NULL AUTO_INCREMENT,
  `work_id` int unsigned NOT NULL,
 
`k_user_id` int unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

DROP TABLE IF EXISTS
`site_info`;
CREATE TABLE `site_info` (
  `id` int NOT NULL,
  `name`
varchar(255) NOT NULL,
  `description` text NOT NULL,
  `min_desc` text
CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL
) ENGINE=InnoDB
DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

DROP TABLE IF EXISTS
`solutions_category`;
CREATE TABLE `solutions_category` (
  `id` int NOT
NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

DROP
TABLE IF EXISTS `solutions_question`;
CREATE TABLE `solutions_question` (
 
`id` int NOT NULL AUTO_INCREMENT,
  `question` varchar(255) NOT NULL,
 
`solution` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,

 `section` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT
CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

DROP TABLE IF EXISTS
`solutions_section`;
CREATE TABLE `solutions_section` (
  `id` int NOT NULL
AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `category` int NOT NULL,

 PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_0900_ai_ci;

DROP TABLE IF EXISTS `subcategory`;
CREATE
TABLE `subcategory` (
  `id` int NOT NULL AUTO_INCREMENT,
  `category` int
NOT NULL,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

DROP
TABLE IF EXISTS `themes`;
CREATE TABLE `themes` (
  `id` varchar(128) NOT
NULL,
  `name` varchar(255) NOT NULL,
  `description` text NOT NULL,
 
`is_active` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_0900_ai_ci;

DROP TABLE IF EXISTS `tickets`;
CREATE TABLE
`tickets` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `deal` int
unsigned NOT NULL,
  `us` int unsigned NOT NULL,
  `stade` int NOT NULL,
 
`time_ticket` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci
NOT NULL,
  `time_close_deal` varchar(255) CHARACTER SET utf8mb4 COLLATE
utf8mb4_0900_ai_ci NOT NULL,
  `info_ticket` mediumtext CHARACTER SET
utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `support_response`
mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
 
PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_0900_ai_ci;

DROP TABLE IF EXISTS `transactions`;
CREATE
TABLE `transactions` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
 
`k_type` int NOT NULL,
  `us` int unsigned NOT NULL,
  `summ` decimal(10,2)
NOT NULL,
  `k_time` varchar(255) CHARACTER SET utf8mb4 COLLATE
utf8mb4_0900_ai_ci NOT NULL,
  `k_order` varchar(255) CHARACTER SET utf8mb4
COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `k_ord` int NOT NULL,
  `status` int
NOT NULL,
  `trx_id` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

DROP
TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int unsigned NOT
NULL AUTO_INCREMENT,
  `login` varchar(255) NOT NULL,
  `email`
varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
 
`description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT
NULL,
  `pass` varchar(255) CHARACTER SET utf8mb4 COLLATE
utf8mb4_0900_ai_ci NOT NULL,
  `viz` varchar(255) NOT NULL,
  `gde`
varchar(255) NOT NULL,
  `ip` varchar(255) NOT NULL,
  `k_online`
varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
 
`avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT
NULL,
  `background` varchar(255) CHARACTER SET utf8mb4 COLLATE
utf8mb4_0900_ai_ci NOT NULL,
  `header` varchar(255) CHARACTER SET utf8mb4
COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `level_us` int NOT NULL,
  `prev`
int NOT NULL,
  `max_us` varchar(255) NOT NULL,
  `datareg` varchar(255)
CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `online_us`
varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
 
`card` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT
NULL,
  `k_money` decimal(10,2) NOT NULL,
  `salt` varchar(255) NOT NULL,
 
`oauth` int NOT NULL,
  `oauth_sub` varchar(255) NOT NULL,
 
`oauth_provider` varchar(255) CHARACTER SET utf8mb4 COLLATE
utf8mb4_0900_ai_ci NOT NULL,
  `fingerprint` varchar(255) CHARACTER SET
utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `last_up_all` int NOT NULL
DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_0900_ai_ci;

DROP TABLE IF EXISTS `users_banned`;
CREATE
TABLE `users_banned` (
  `id` int NOT NULL AUTO_INCREMENT,
  `us` int
unsigned NOT NULL,
  `reas` text NOT NULL,
  `hours` mediumint NOT NULL,
 
`fp` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT
NULL,
  `time_ban` varchar(255) CHARACTER SET utf8mb4 COLLATE
utf8mb4_0900_ai_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT
CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

DROP TABLE IF EXISTS
`work_processed`;
CREATE TABLE `work_processed` (
  `id` int unsigned NOT
NULL AUTO_INCREMENT,
  `k_work` int unsigned NOT NULL,
  `worker` int
unsigned NOT NULL,
  `creator` int unsigned NOT NULL,
  `stade` int NOT
NULL,
  `k_money` decimal(10,2) NOT NULL,
  `time_work` varchar(255)
CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
 
`time_close_work` varchar(255) CHARACTER SET utf8mb4 COLLATE
utf8mb4_0900_ai_ci NOT NULL,
  `k_order` varchar(255) CHARACTER SET utf8mb4
COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `wts` varchar(255) CHARACTER SET
utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `deal_commiss` tinyint
unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT
CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

DROP TABLE IF EXISTS
`works`;
CREATE TABLE `works` (
  `id` int unsigned NOT NULL
AUTO_INCREMENT,
  `name_work` varchar(255) NOT NULL,
  `desc_work` text NOT
NULL,
  `cena_work` varchar(255) NOT NULL,
  `user_work` int unsigned NOT
NULL,
  `person_work` int NOT NULL,
  `image_work` varchar(255) NOT NULL,
 
`category` int unsigned NOT NULL,
  `section` int NOT NULL,
  `subcategory`
int NOT NULL,
  `time_work` varchar(255) CHARACTER SET utf8mb4 COLLATE
utf8mb4_0900_ai_ci NOT NULL,
  `del` varchar(255) NOT NULL,
  `k_off`
varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
 
`salt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT
NULL,
  `up_time` varchar(255) CHARACTER SET utf8mb4 COLLATE
utf8mb4_0900_ai_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT
CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

DROP TABLE IF EXISTS
`works_images`;
CREATE TABLE `works_images` (
  `id` int NOT NULL
AUTO_INCREMENT,
  `k_work` int NOT NULL,
  `k_image` varchar(255) NOT
NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_0900_ai_ci;

DROP TABLE IF EXISTS
`works_transact_orders`;
CREATE TABLE `works_transact_orders` (
  `id` int
NOT NULL AUTO_INCREMENT,
  `key_work` varchar(255) CHARACTER SET utf8mb4
COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `worker` int unsigned NOT NULL,
 
`us` int unsigned NOT NULL,
  `k_work` int unsigned NOT NULL,
 
`deal_order` varchar(255) NOT NULL,
  `salt` varchar(255) NOT NULL,
 
PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_0900_ai_ci;