|
Table: lorzutcs_lorzutc
|
Create Table: CREATE TABLE `lorzutc` (
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
`kind` varchar(1) NOT NULL,
|
`title` varchar(120) NOT NULL,
|
`descr` longtext NOT NULL,
|
`picture` varchar(100) NOT NULL,
|
`price` int(10) unsigned DEFAULT NULL,
|
`priority` int(10) unsigned NOT NULL,
|
`date_added` datetime NOT NULL,
|
`is_published` tinyint(1) NOT NULL,
|
`reds_total` int(10) unsigned NOT NULL,
|
`reds_reserved` int(10) unsigned NOT NULL,
|
`fork_id` int(11) DEFAULT NULL,
|
`reds_engaged` int(10) unsigned NOT NULL,
|
`color` smallint(5) unsigned NOT NULL,
|
`is_rare` tinyint(1) NOT NULL,
|
`subtitle` varchar(120) NOT NULL,
|
`drop` varchar(1) NOT NULL,
|
`dust_ended` tinyint(1) NOT NULL,
|
`ext_id` varchar(255) DEFAULT NULL,
|
`platform_type` varchar(32) NOT NULL,
|
`cnt_sold` int(10) unsigned NOT NULL,
|
`cnt_to_sell` int(10) unsigned NOT NULL,
|
`robot_needed` int(11) DEFAULT NULL,
|
`share_picture` varchar(100) DEFAULT NULL,
|
`robot_quest_id` int(11) DEFAULT NULL,
|
`currency` varchar(1) NOT NULL,
|
`call_drop_amount` int(10) unsigned DEFAULT NULL,
|
`call_drop_lorzutc_id` int(11) DEFAULT NULL,
|
`call_hint_text` longtext NOT NULL,
|
`no_quantity_discount` tinyint(1) NOT NULL,
|
`morning_amount` int(10) unsigned NOT NULL,
|
`morning_type_id` int(11) DEFAULT NULL,
|
`limit_daily` int(10) unsigned NOT NULL,
|
`limit_error_daily` longtext NOT NULL,
|
`limit_error_total` longtext NOT NULL,
|
`limit_total` int(10) unsigned NOT NULL,
|
`limit_warning_daily` longtext NOT NULL,
|
`limit_warning_total` longtext NOT NULL,
|
`date_finish` datetime DEFAULT NULL,
|
`only_corp` tinyint(1) NOT NULL,
|
`robot_coins_amount` int(10) unsigned NOT NULL,
|
`first_tag` varchar(90) DEFAULT NULL,
|
`second_tag` varchar(90) DEFAULT NULL,
|
`is_free` tinyint(1) NOT NULL DEFAULT 0,
|
`instruction_for_red_activation_url` varchar(200) DEFAULT NULL,
|
`use_instruction_for_red_activation` tinyint(1) NOT NULL,
|
`descr_de` longtext DEFAULT NULL,
|
`descr_en` longtext DEFAULT NULL,
|
`descr_fr` longtext DEFAULT NULL,
|
`descr_pl` longtext DEFAULT NULL,
|
`descr_ru` longtext DEFAULT NULL,
|
`call_hint_text_de` longtext DEFAULT NULL,
|
`call_hint_text_en` longtext DEFAULT NULL,
|
`call_hint_text_fr` longtext DEFAULT NULL,
|
`call_hint_text_pl` longtext DEFAULT NULL,
|
`call_hint_text_ru` longtext DEFAULT NULL,
|
`subtitle_de` varchar(120) DEFAULT NULL,
|
`subtitle_en` varchar(120) DEFAULT NULL,
|
`subtitle_fr` varchar(120) DEFAULT NULL,
|
`subtitle_pl` varchar(120) DEFAULT NULL,
|
`subtitle_ru` varchar(120) DEFAULT NULL,
|
`title_de` varchar(120) DEFAULT NULL,
|
`title_en` varchar(120) DEFAULT NULL,
|
`title_fr` varchar(120) DEFAULT NULL,
|
`title_pl` varchar(120) DEFAULT NULL,
|
`title_ru` varchar(120) DEFAULT NULL,
|
`limit_error_daily_de` longtext DEFAULT NULL,
|
`limit_error_daily_en` longtext DEFAULT NULL,
|
`limit_error_daily_fr` longtext DEFAULT NULL,
|
`limit_error_daily_pl` longtext DEFAULT NULL,
|
`limit_error_daily_ru` longtext DEFAULT NULL,
|
`limit_error_total_de` longtext DEFAULT NULL,
|
`limit_error_total_en` longtext DEFAULT NULL,
|
`limit_error_total_fr` longtext DEFAULT NULL,
|
`limit_error_total_pl` longtext DEFAULT NULL,
|
`limit_error_total_ru` longtext DEFAULT NULL,
|
`limit_warning_daily_de` longtext DEFAULT NULL,
|
`limit_warning_daily_en` longtext DEFAULT NULL,
|
`limit_warning_daily_fr` longtext DEFAULT NULL,
|
`limit_warning_daily_pl` longtext DEFAULT NULL,
|
`limit_warning_daily_ru` longtext DEFAULT NULL,
|
`limit_warning_total_de` longtext DEFAULT NULL,
|
`limit_warning_total_en` longtext DEFAULT NULL,
|
`limit_warning_total_fr` longtext DEFAULT NULL,
|
`limit_warning_total_pl` longtext DEFAULT NULL,
|
`limit_warning_total_ru` longtext DEFAULT NULL,
|
`packed_coins_amount` int(10) unsigned NOT NULL,
|
`date_start` datetime(6) DEFAULT NULL,
|
`for_axcfgrtys` tinyint(1),
|
`axcfgrty_form_label` varchar(256) DEFAULT NULL,
|
`service_transfer_enabled` tinyint(1) NOT NULL,
|
`for_direct_link_only` tinyint(1) NOT NULL,
|
`multi_axcfgrty_form` longtext DEFAULT NULL,
|
`multi_axcfgrty_form_de` longtext DEFAULT NULL,
|
`multi_axcfgrty_form_en` longtext DEFAULT NULL,
|
`multi_axcfgrty_form_fr` longtext DEFAULT NULL,
|
`multi_axcfgrty_form_pl` longtext DEFAULT NULL,
|
`multi_axcfgrty_form_ru` longtext DEFAULT NULL,
|
PRIMARY KEY (`id`),
|
UNIQUE KEY `lorzutcs_lorzutc_fork_id_3d78875a493a690e_uniq` (`fork_id`,`ext_id`),
|
KEY `lorzutcs_lorzutc_7ffe293f` (`call_drop_lorzutc_id`),
|
KEY `lorzutcs_lorzutc_6ae2cc48` (`morning_type_id`),
|
KEY `lorzutcs_lorzutc_fork_id_kind_idx` (`fork_id`,`kind`),
|
CONSTRAINT `D677e29f346e2cb9534923ae7a1cef3c` FOREIGN KEY (`morning_type_id`) REFERENCES `lorzutcs_lorzutcstacktype` (`id`),
|
CONSTRAINT `pr_call_drop_lorzutc_id_4585ada564c7ff7b_fk_lorzutcs_lorzutc_id` FOREIGN KEY (`call_drop_lorzutc_id`) REFERENCES `lorzutcs_lorzutc` (`id`),
|
CONSTRAINT `lorzutcs_lorzutc_fork_id_24d38688d2cddd78_fk_lorzutcs_fork_id` FOREIGN KEY (`fork_id`) REFERENCES `lorzutcs_fork` (`id`)
|
) ENGINE=InnoDB AUTO_INCREMENT=2008 DEFAULT CHARSET=utf8
|
|
|
|
SHOW CREATE TABLE axcfgrtys_axcfgrtyprlorzutcasde\G
|
*************************** 1. row ***************************
|
Table: axcfgrtys_axcfgrtyprlorzutcasde
|
Create Table: CREATE TABLE `axcfgrtys_axcfgrtyprlorzutcasde` (
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
`date_start` datetime(6) NOT NULL,
|
`date_last_activity` datetime(6) NOT NULL,
|
`state` varchar(1) NOT NULL,
|
`desc` longtext NOT NULL,
|
`error` longtext NOT NULL,
|
`tries_count` int(11) NOT NULL,
|
`space_id` int(11) DEFAULT NULL,
|
`space_status` int(11) DEFAULT NULL,
|
`space_error` longtext DEFAULT NULL,
|
`lorzutc_id` int(11) NOT NULL,
|
PRIMARY KEY (`id`),
|
KEY `axcfgrtys_axcfgrtypr_lorzutc_id_fk_lorzutcs_` (`lorzutc_id`),
|
CONSTRAINT `axcfgrtys_axcfgrtypr_lorzutc_id_fk_lorzutcs_` FOREIGN KEY (`lorzutc_id`) REFERENCES `lorzutcs_lorzutc` (`id`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8
|