CREATE TABLE `tx_news_domain_model_news`  (
  `uid` int(11) NOT NULL,
  `deleted`  smallint(6) DEFAULT 0,
  `pid`  smallint(6) NOT NULL,
  `sys_language_uid` smallint(6) DEFAULT 0,
  `t3ver_state` smallint(6) DEFAULT 0,
  `t3ver_wsid` smallint(6) DEFAULT 0,
  `t3ver_oid` smallint(6) DEFAULT 0,
  `hidden` smallint(6) DEFAULT 0,
  `starttime` int DEFAULT NULL,
  `endtime` int DEFAULT NULL,
  `fe_group`  varchar(30) DEFAULT NULL,
  `datetime` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE `sys_category_record_mm`  (
  `uid_foreign` int(11) NOT NULL,
  `uid_local` int(11) NOT NULL,
  `fieldname` varchar(30) NOT NULL,
  `tablenames` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

insert into `tx_news_domain_model_news`(
  `uid`,
  `deleted`,
  `pid`,
  `sys_language_uid`,
  `t3ver_state`,
  `t3ver_wsid`,
  `t3ver_oid`,
  `hidden`,
  `starttime`,
  `endtime`,
  `fe_group`,
  `datetime`
) select
  seq,
  0,
  7, 
  0, 
  0,
  0,
  0,
  0,
  1600000000,
  0, #endtime
  NULL,
  UNIX_TIMESTAMP(CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 100 * 24 * 60 *60) SECOND)
from  seq_1_to_1000000;

insert into `sys_category_record_mm`(
  `uid_foreign`,
  `uid_local`,
  `fieldname`,
  `tablenames`
) select
    FLOOR(1 + (RAND() * 1000000)),
    FLOOR(1 + (RAND() * 300)),
    'categories',
    'tx_news_domain_model_news'
from  seq_1_to_100000;