zsjz-ai/sql/testSql/testdb.sql

INSERT INTO govern_tree (id, tableNameEn, tableNameCn, pid, type, dataCount)
SELECT 1, 'call_record', '通话记录', 0, 'table', count(*) as dataCount
FROM call_record;
INSERT INTO govern_tree (id, tableNameEn, tableNameCn, pid, type, dataCount)
SELECT 2, 'trans_record', '银行交易流水', 0, 'table', count(*) as dataCount
FROM trans_record;
INSERT INTO govern_tree (id, tableNameEn, tableNameCn, pid, type, dataCount)
SELECT 3, 'call_opening_info', '通话开户信息', 0, 'table', count(*) as dataCount
FROM call_opening_info;
INSERT INTO govern_tree (id, tableNameEn, tableNameCn, pid, type, dataCount)
SELECT 4, 'account_opening_info', '账户开户信息', 0, 'table', count(*) as dataCount
FROM account_opening_info;
INSERT INTO govern_tree (id, tableNameEn, tableNameCn, pid, type, dataCount)
SELECT 12, 'resident_population_info', '户籍信息', 0, 'table', count(*) as dataCount
FROM resident_population_info;
INSERT INTO govern_tree (id, tableNameEn, tableNameCn, pid, type, dataCount)
SELECT 13, 'express_info', '快递收件信息', 0, 'table', count(*) as dataCount
FROM express_info;
INSERT INTO govern_tree (id, tableNameEn, tableNameCn, pid, type, dataCount)
SELECT 14, 'hotel_stay_info', '旅馆住宿信息查询', 0, 'table', count(*) as dataCount
FROM hotel_stay_info;
INSERT INTO govern_tree (id, tableNameEn, tableNameCn, pid, type, dataCount)
SELECT 15, 'flight_ticket_info', '民航订票信息查询', 0, 'table', count(*) as dataCount
FROM flight_ticket_info;
INSERT INTO govern_tree (id, tableNameEn, tableNameCn, pid, type, dataCount)
SELECT 16, 'flight_departure_info', '民航离港信息查询', 0, 'table', count(*) as dataCount
FROM flight_departure_info;
INSERT INTO govern_tree (id, tableNameEn, tableNameCn, pid, type, dataCount)
SELECT 17, 'together_flight_info', '同航班服务', 0, 'table', count(*) as dataCount
FROM together_flight_info;
INSERT INTO govern_tree (id, tableNameEn, tableNameCn, pid, type, dataCount)
SELECT 18, 'together_train_info', '同火车服务', 0, 'table', count(*) as dataCount
FROM together_train_info;
INSERT INTO govern_tree (id, tableNameEn, tableNameCn, pid, type, dataCount)
SELECT 19, 'train_ticket_info', '铁路订票信息查询', 0, 'table', count(*) as dataCount
FROM train_ticket_info;
INSERT INTO govern_tree (id, tableNameEn, tableNameCn, pid, type, dataCount)
SELECT 20, 'together_live_info', '同住服务', 0, 'table', count(*) as dataCount
FROM together_live_info