*************

SQL code: Upload dump Copy Format Clear

CREATE TABLE `settings` ( `id` int(11) NOT NULL, `site_logo` text DEFAULT NULL, `site_name` text DEFAULT NULL, `site_title` text NOT NULL, `site_description` text NOT NULL, `site_keywords` text NOT NULL, `site_currency` text NOT NULL, `dolar` text NOT NULL DEFAULT '8,64', `euro` text NOT NULL DEFAULT '10,14', `ruble` text NOT NULL DEFAULT '0.30755', `favicon` text DEFAULT NULL, `site_language` varchar(225) NOT NULL DEFAULT 'tr', `site_theme` text NOT NULL, `site_timezone` int(11) NOT NULL, `max_ticket` int(11) NOT NULL DEFAULT 2, `skype_area` enum('1','2') NOT NULL DEFAULT '1', `name_secret` enum('1','2') NOT NULL DEFAULT '1', `recaptcha` enum('1','2') NOT NULL DEFAULT '1', `recaptcha_key` text DEFAULT NULL, `recaptcha_secret` text DEFAULT NULL, `custom_header` text DEFAULT NULL, `custom_footer` text DEFAULT NULL, `ticket_system` enum('1','2') NOT NULL DEFAULT '2', `register_page` enum('1','2') NOT NULL DEFAULT '2', `terms_checkbox` int(11) NOT NULL DEFAULT 1, `service_speed` enum('1','2') NOT NULL DEFAULT '2', `service_list` enum('1','2') NOT NULL DEFAULT '2', `dolar_charge` double NOT NULL, `euro_charge` double NOT NULL, `ruble_charge` double NOT NULL, `smtp_user` text NOT NULL, `smtp_pass` text NOT NULL, `smtp_server` text NOT NULL, `smtp_port` varchar(225) NOT NULL, `smtp_protocol` enum('0','ssl','tls') NOT NULL, `smtp_type` varchar(11) NOT NULL, `alert_type` enum('1','2','3') NOT NULL, `alert_newmanuelservice` enum('1','2') NOT NULL, `alert_newticket` enum('1','2') NOT NULL, `alert_apibalance` enum('1','2') NOT NULL, `alert_newpayment` enum('1','2') NOT NULL, `alert_newbankpayment` enum('1','2') NOT NULL DEFAULT '1', `alert_serviceapialert` enum('1','2') NOT NULL, `alert_failorder` enum('1','2') NOT NULL, `admin_mail` varchar(225) NOT NULL, `resetpass_page` enum('1','2') NOT NULL, `resetpass_email` enum('1','2') NOT NULL, `site_maintenance` enum('1','2') NOT NULL DEFAULT '2', `site_frozen` int(11) NOT NULL DEFAULT 1, `sms_provider` varchar(225) NOT NULL, `sms_title` varchar(225) NOT NULL, `sms_user` varchar(225) NOT NULL, `sms_pass` varchar(225) NOT NULL, `admin_telephone` varchar(225) NOT NULL, `resetpass_sms` enum('1','2') NOT NULL, `panel_selling` int(11) NOT NULL, `panel_price` int(11) NOT NULL, `free_balance` int(11) NOT NULL, `free_amount` int(11) NOT NULL, `referral` enum('1','2') NOT NULL DEFAULT '1', `ref_bonus` int(11) NOT NULL, `ref_max` int(11) NOT NULL, `ref_type` enum('0','1') NOT NULL DEFAULT '0', `cache` int(11) NOT NULL, `cache_time` int(11) NOT NULL, `guard_system_status` int(11) NOT NULL, `guard_services_status` int(11) NOT NULL, `guard_services_type` int(11) NOT NULL, `guard_notify_status` int(11) NOT NULL, `guard_notify_type` int(11) NOT NULL, `guard_roles_status` int(11) NOT NULL, `guard_roles_type` int(11) NOT NULL, `guard_apikey_type` int(11) NOT NULL, `neworder_terms` int(11) NOT NULL, `guard_cron_system` int(11) NOT NULL DEFAULT 1, `secret_key` varchar(225) NOT NULL, `avarage` int(11) NOT NULL, `sms_verify` int(11) NOT NULL DEFAULT 1, `mail_verify` int(11) NOT NULL DEFAULT 1, `ser_sync` int(11) NOT NULL, `auto_refill` varchar(225) DEFAULT NULL, `notlar` text NOT NULL, `version` text NOT NULL, `google_ads_odeme` text DEFAULT NULL, `google_ads_all` text DEFAULT NULL, `mail_sablon` text DEFAULT NULL, `up_limiti` varchar(11) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Дамп данных таблицы `settings` -- INSERT INTO `settings` (`id`, `site_logo`, `site_name`, `site_title`, `site_description`, `site_keywords`, `site_currency`, `dolar`, `euro`, `ruble`, `favicon`, `site_language`, `site_theme`, `site_timezone`, `max_ticket`, `skype_area`, `name_secret`, `recaptcha`, `recaptcha_key`, `recaptcha_secret`, `custom_header`, `custom_footer`, `ticket_system`, `register_page`, `terms_checkbox`, `service_speed`, `service_list`, `dolar_charge`, `euro_charge`, `ruble_charge`, `smtp_user`, `smtp_pass`, `smtp_server`, `smtp_port`, `smtp_protocol`, `smtp_type`, `alert_type`, `alert_newmanuelservice`, `alert_newticket`, `alert_apibalance`, `alert_newpayment`, `alert_newbankpayment`, `alert_serviceapialert`, `alert_failorder`, `admin_mail`, `resetpass_page`, `resetpass_email`, `site_maintenance`, `site_frozen`, `sms_provider`, `sms_title`, `sms_user`, `sms_pass`, `admin_telephone`, `resetpass_sms`, `panel_selling`, `panel_price`, `free_balance`, `free_amount`, `referral`, `ref_bonus`, `ref_max`, `ref_type`, `cache`, `cache_time`, `guard_system_status`, `guard_services_status`, `guard_services_type`, `guard_notify_status`, `guard_notify_type`, `guard_roles_status`, `guard_roles_type`, `guard_apikey_type`, `neworder_terms`, `guard_cron_system`, `secret_key`, `avarage`, `sms_verify`, `mail_verify`, `ser_sync`, `auto_refill`, `notlar`, `version`, `google_ads_odeme`, `google_ads_all`, `mail_sablon`, `up_limiti`) VALUES (1, '16553582_067dsa1a43121b3ca5f.png', 'domain.ru', 'domain.ru - test', 'tegi', 'RUB', '17.3138', '18.1416', '1655358972_cc304d47dsa2ssa8s21f.png', 'ru', 'bootstrap', 0, 2, '2', '1', '1', '6LckBOcdAdsasdasZJ9', '6LckBOcdAAdsaG--zhSxGwdas84buD_', '', '', '2', '2', 1, '1', '2', 1, 1, 'info@domain.ru', 'Skdsasdf32dasDs', 'domain@mail.ru', '587', 'ssl', 'smtp', '2', '2', '2', '2', '2', '2', '2', '2', 'stdsaws@domain.ru', '2', '2', '1', 1, 'netgsm', '', '', '', '', '1', 2, 999, 1, 0, '2', 10, 50, '1', 2, 1, 1, 1, 1, 1, 2, 1, 1, 2, 1, 1, '', 2, 1, 1, 1, '2', 'Özel Notlar.', '10.2', '', '', '{mail_icerik_cek}  ', '10'); -- --------------------------------------------------------

SQL Server: Preserve result

Stuck with a problem? Got Error? Ask ChatGPT!

SQLize Online / PHPize Online / SQLtest Online