-- 表创建
CREATE TABLE title (
    id INT AUTO_INCREMENT PRIMARY KEY,
    INFOCODE VARCHAR(255) NOT NULL,
    title TEXT,
    is_deleted TINYINT(1) DEFAULT 0,
    INDEX idx_id_is_deleted (id, is_deleted),
    INDEX idx_info_code (INFOCODE)
);

CREATE TABLE new (
    id INT AUTO_INCREMENT PRIMARY KEY,
    INFOCODE VARCHAR(255) NOT NULL,
    new LONGTEXT,
    INDEX idx_info_code (INFOCODE)
);

-- 插入 title 表数据
INSERT INTO title (INFOCODE, title, is_deleted) VALUES
('CODE001', 'Title 1', 0),
('CODE002', 'Title 2', 0),
('CODE003', 'Title 3', 0),
('CODE004', 'Title 4', 0),
('CODE005', 'Title 5', 0),
('CODE006', 'Title 6', 0),
('CODE007', 'Title 7', 0),
('CODE008', 'Title 8', 0),
('CODE009', 'Title 9', 0),
('CODE010', 'Title 10', 0),
('CODE011', 'Title 11', 0),
('CODE012', 'Title 12', 0),
('CODE013', 'Title 13', 0),
('CODE014', 'Title 14', 0),
('CODE015', 'Title 15', 0),
('CODE016', 'Title 16', 0),
('CODE017', 'Title 17', 0),
('CODE018', 'Title 18', 0),
('CODE019', 'Title 19', 0),
('CODE020', 'Title 20', 0),
('CODE021', 'Title 21', 0),
('CODE022', 'Title 22', 0),
('CODE023', 'Title 23', 0),
('CODE024', 'Title 24', 0),
('CODE025', 'Title 25', 0),
('CODE026', 'Title 26', 0),
('CODE027', 'Title 27', 0),
('CODE028', 'Title 28', 0),
('CODE029', 'Title 29', 0),
('CODE030', 'Title 30', 0),
('CODE031', 'Title 31', 0),
('CODE032', 'Title 32', 0),
('CODE033', 'Title 33', 0),
('CODE034', 'Title 34', 0),
('CODE035', 'Title 35', 0),
('CODE036', 'Title 36', 0),
('CODE037', 'Title 37', 0),
('CODE038', 'Title 38', 0),
('CODE039', 'Title 39', 0),
('CODE040', 'Title 40', 0),
('CODE041', 'Title 41', 0),
('CODE042', 'Title 42', 0),
('CODE043', 'Title 43', 0),
('CODE044', 'Title 44', 0),
('CODE045', 'Title 45', 0),
('CODE046', 'Title 46', 0),
('CODE047', 'Title 47', 0),
('CODE048', 'Title 48', 0),
('CODE049', 'Title 49', 0),
('CODE050', 'Title 50', 0);

-- 插入 new 表数据
INSERT INTO new (INFOCODE, new) VALUES
('CODE001', 'New content 1'),
('CODE002', 'New content 2'),
('CODE003', 'New content 3'),
('CODE004', 'New content 4'),
('CODE005', 'New content 5'),
('CODE006', 'New content 6'),
('CODE007', 'New content 7'),
('CODE008', 'New content 8'),
('CODE009', 'New content 9'),
('CODE010', 'New content 10'),
('CODE011', 'New content 11'),
('CODE012', 'New content 12'),
('CODE013', 'New content 13'),
('CODE014', 'New content 14'),
('CODE015', 'New content 15'),
('CODE016', 'New content 16'),
('CODE017', 'New content 17'),
('CODE018', 'New content 18'),
('CODE019', 'New content 19'),
('CODE020', 'New content 20'),
('CODE021', 'New content 21'),
('CODE022', 'New content 22'),
('CODE023', 'New content 23'),
('CODE024', 'New content 24'),
('CODE025', 'New content 25'),
('CODE026', 'New content 26'),
('CODE027', 'New content 27'),
('CODE028', 'New content 28'),
('CODE029', 'New content 29'),
('CODE030', 'New content 30'),
('CODE031', 'New content 31'),
('CODE032', 'New content 32'),
('CODE033', 'New content 33'),
('CODE034', 'New content 34'),
('CODE035', 'New content 35'),
('CODE036', 'New content 36'),
('CODE037', 'New content 37'),
('CODE038', 'New content 38'),
('CODE039', 'New content 39'),
('CODE040', 'New content 40'),
('CODE041', 'New content 41'),
('CODE042', 'New content 42'),
('CODE043', 'New content 43'),
('CODE044', 'New content 44'),
('CODE045', 'New content 45'),
('CODE046', 'New content 46'),
('CODE047', 'New content 47'),
('CODE048', 'New content 48'),
('CODE049', 'New content 49'),
('CODE050', 'New content 50');