text: CREATE TABLE IF NOT EXISTS b_socialservices_user
  (
  	ID INT NOT NULL AUTO_INCREMENT,
  	LOGIN VARCHAR(100) NOT NULL,
  	NAME VARCHAR(100) NULL,
  	LAST_NAME VARCHAR(100) NULL,
  	EMAIL VARCHAR(100) NULL,
  	PERSONAL_PHOTO INT NULL,
  	EXTERNAL_AUTH_ID VARCHAR(100) NOT NULL,
  	USER_ID INT NOT NULL,
  	XML_ID VARCHAR(100) NOT NULL,
  	CAN_DELETE CHAR(1) NOT NULL DEFAULT 'Y',
  	PERSONAL_WWW VARCHAR(100) NULL,
  	PERMISSIONS VARCHAR(555) NULL,
  	OATOKEN TEXT NULL,
  	OATOKEN_EXPIRES INT NULL,
  	OASECRET TEXT NULL,
  	REFRESH_TOKEN TEXT NULL,
  	SEND_ACTIVITY CHAR(1) NULL DEFAULT 'Y',
  	SITE_ID VARCHAR(50) NULL,
  	INITIALIZED CHAR(1) NULL DEFAULT 'N',
  	PRIMARY KEY (ID),
  	UNIQUE INDEX IX_B_SOCIALSERVICES_USER (XML_ID, EXTERNAL_AUTH_ID),
  	INDEX IX_B_SOCIALSERVICES_US_3 (LOGIN),
  	INDEX IX_B_SOCIALSERVICES_US_4 (USER_ID, EXTERNAL_AUTH_ID)
  );
  
  CREATE TABLE IF NOT EXISTS  b_socialservices_message
  (
  	ID INT NOT NULL AUTO_INCREMENT,
  	USER_ID INT NOT NULL,
  	SOCSERV_USER_ID INT NOT NULL,
  	PROVIDER VARCHAR(100) NOT NULL,
  	MESSAGE VARCHAR(1000) NULL,
  	INSERT_DATE DATETIME NULL,
  	SUCCES_SENT CHAR(1) NOT NULL DEFAULT 'N',
  	PRIMARY KEY (ID)
  );
  
  CREATE TABLE IF NOT EXISTS b_socialservices_user_link
  (
  	ID INT NOT NULL AUTO_INCREMENT,
  	USER_ID INT NOT NULL,
  	SOCSERV_USER_ID INT NOT NULL,
  	LINK_USER_ID INT NULL,
  	LINK_UID VARCHAR(100) NOT NULL,
  	LINK_NAME VARCHAR(255) NULL,
  	LINK_LAST_NAME VARCHAR(255) NULL,
  	LINK_PICTURE VARCHAR(255) NULL,
  	LINK_EMAIL VARCHAR(255) NULL,
  	TIMESTAMP_X TIMESTAMP NULL,
  	PRIMARY KEY(ID),
  	INDEX ix_b_socialservices_user_link_5 (SOCSERV_USER_ID),
  	INDEX ix_b_socialservices_user_link_6 (LINK_USER_ID, TIMESTAMP_X),
  	INDEX ix_b_socialservices_user_link_7 (LINK_UID)
  );
  
  CREATE TABLE IF NOT EXISTS b_socialservices_contact
  (
  	ID INT NOT NULL AUTO_INCREMENT,
  	TIMESTAMP_X TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
  	USER_ID INT NOT NULL,
  	CONTACT_USER_ID INT NULL,
  	CONTACT_XML_ID INT NULL,
  	CONTACT_NAME VARCHAR(255) NULL,
  	CONTACT_LAST_NAME VARCHAR(255) NULL,
  	CONTACT_PHOTO VARCHAR(255) NULL,
  	LAST_AUTHORIZE datetime,
  	NOTIFY CHAR(1) NULL DEFAULT 'N',
  	PRIMARY KEY (ID),
  	INDEX ix_b_socialservices_contact1(USER_ID),
  	INDEX ix_b_socialservices_contact2(CONTACT_USER_ID),
  	INDEX ix_b_socialservices_contact3(TIMESTAMP_X),
  	INDEX ix_b_socialservices_contact4(LAST_AUTHORIZE)
  );
  
  CREATE TABLE IF NOT EXISTS b_socialservices_contact_connect
  (
  	ID INT NOT NULL AUTO_INCREMENT,
  	TIMESTAMP_X TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
  	CONTACT_ID INT NULL,
  	LINK_ID INT NULL,
  	CONTACT_PROFILE_ID INT NOT NULL,
  	CONTACT_PORTAL VARCHAR(255) NOT NULL,
  	CONNECT_TYPE CHAR(1) NULL DEFAULT 'P',
  	LAST_AUTHORIZE datetime,
  	PRIMARY KEY (ID),
  	INDEX ix_b_socialservices_contact_connect1(CONTACT_ID),
  	INDEX ix_b_socialservices_contact_connect2(LINK_ID),
  	INDEX ix_b_socialservices_contact_connect3(LAST_AUTHORIZE)
  );
  
  CREATE TABLE IF NOT EXISTS b_socialservices_ap
  (
  	ID INT NOT NULL AUTO_INCREMENT,
  	TIMESTAMP_X TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
  	USER_ID INT NOT NULL,
  	DOMAIN VARCHAR(255) NOT NULL,
  	ENDPOINT VARCHAR(255) NULL,
  	LOGIN VARCHAR(50) NULL,
  	PASSWORD VARCHAR(50) NULL,
  	LAST_AUTHORIZE DATETIME NULL,
  	SETTINGS VARCHAR(1000) NULL,
  	PRIMARY KEY (ID),
  	INDEX ix_socialservices_ap1 (USER_ID, DOMAIN)
  );
  
  CREATE TABLE IF NOT EXISTS b_socialservices_zoom_meeting
  (
  	ID int NOT NULL AUTO_INCREMENT,
  	ENTITY_TYPE_ID varchar(10) NOT NULL,
  	ENTITY_ID int NOT NULL,
  	CONFERENCE_URL varchar(255) NOT NULL,
  	CONFERENCE_EXTERNAL_ID bigint unsigned NOT NULL,
  	CONFERENCE_PASSWORD text,
  	JOINED char(1),
  	CONFERENCE_CREATED datetime,
      CONFERENCE_STARTED datetime,
  	CONFERENCE_ENDED datetime,
  	DURATION int,
  	TITLE text,
  	SHORT_LINK varchar(255),
  	HAS_RECORDING char(1),
  	PRIMARY KEY(ID),
  	INDEX IX_B_SOCIALSERVICES_ZOOM_MEETING_1 (CONFERENCE_EXTERNAL_ID),
  	INDEX IX_B_SOCIALSERVICES_ZOOM_MEETING_2 (ENTITY_TYPE_ID, ENTITY_ID)
  );
  
  CREATE TABLE IF NOT EXISTS b_socialservices_zoom_meeting_recording
  (
      ID int NOT NULL AUTO_INCREMENT,
      EXTERNAL_ID varchar(64) not null,
      MEETING_ID int not null,
      START_DATE datetime not null,
      END_DATE datetime not null,
      FILE_TYPE varchar(16) not null,
      FILE_SIZE int not null,
      PLAY_URL varchar(500),
      DOWNLOAD_URL varchar(500),
      RECORDING_TYPE varchar(64) not null,
      DOWNLOAD_TOKEN text,
      `PASSWORD` text,
      FILE_ID int,
      PRIMARY KEY(ID),
      INDEX IX_B_SOCIALSERVICES_ZOOM_MEETING_RECORDING_1 (MEETING_ID)
  );
  