| Server IP : 80.87.202.40 / Your IP : 216.73.216.169 Web Server : Apache System : Linux rospirotorg.ru 5.14.0-539.el9.x86_64 #1 SMP PREEMPT_DYNAMIC Thu Dec 5 22:26:13 UTC 2024 x86_64 User : bitrix ( 600) PHP Version : 8.2.27 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /home/bitrix/ext_www/rospirotorg.ru/bitrix/modules/idea/install/db/mysql/ |
Upload File : |
create table if not exists b_idea_email_subscribe ( USER_ID int(18) NOT NULL, SUBSCRIBE_TYPE varchar(32) NOT NULL, --ALL || NEW IDEA ENTITY_TYPE varchar(32) NOT NULL , ENTITY_CODE varchar(255) NOT NULL, PRIMARY KEY(USER_ID, ENTITY_TYPE, ENTITY_CODE), INDEX ix_b_idea_email_subscribe (SUBSCRIBE_TYPE, ENTITY_TYPE, ENTITY_CODE) );