This is an automated email from the ASF dual-hosted git repository.
hefengen pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/shenyu.git
The following commit(s) were added to refs/heads/master by this push:
new cb443e0bf6 [type:fix]Fix upgrade sql (#5932)
cb443e0bf6 is described below
commit cb443e0bf62243917f80552d47c2cebd78476fbc
Author: xcsnx <[email protected]>
AuthorDate: Mon Feb 17 09:32:28 2025 +0800
[type:fix]Fix upgrade sql (#5932)
* fix
* fix
---------
Co-authored-by: ‘xcsnx’ <‘[email protected]’>
---
db/upgrade/2.6.1-upgrade-2.7.0-mysql.sql | 97 +++++++++++++++-----------------
1 file changed, 45 insertions(+), 52 deletions(-)
diff --git a/db/upgrade/2.6.1-upgrade-2.7.0-mysql.sql
b/db/upgrade/2.6.1-upgrade-2.7.0-mysql.sql
index 517bba0184..e498be86a7 100755
--- a/db/upgrade/2.6.1-upgrade-2.7.0-mysql.sql
+++ b/db/upgrade/2.6.1-upgrade-2.7.0-mysql.sql
@@ -108,50 +108,6 @@ CREATE TABLE `namespace_plugin_rel` (
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
ROW_FORMAT=DYNAMIC;
-
-INSERT INTO `namespace_plugin_rel` (`id`,`namespace_id`,`plugin_id`, `config`,
`sort`, `enabled`, `date_created`, `date_updated`) VALUES
('1801816010882822145','649330b6-c2d7-4edc-be8e-8a54df9eb385','1', NULL, 20, 0,
'2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO `namespace_plugin_rel` (`id`,`namespace_id`,`plugin_id`, `config`,
`sort`, `enabled`, `date_created`, `date_updated`) VALUES
('1801816010882822146','649330b6-c2d7-4edc-be8e-8a54df9eb385','10', NULL, 140,
0, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO `namespace_plugin_rel` (`id`,`namespace_id`,`plugin_id`, `config`,
`sort`, `enabled`, `date_created`, `date_updated`) VALUES
('1801816010882822147','649330b6-c2d7-4edc-be8e-8a54df9eb385','11',
'{\"protocol\":\"zookeeper\",\"register\":\"127.0.0.1:2181\",\"threadpool\":\"shared\"}',
310, 0, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO `namespace_plugin_rel` (`id`,`namespace_id`,`plugin_id`, `config`,
`sort`, `enabled`, `date_created`, `date_updated`) VALUES
('1801816010882822148','649330b6-c2d7-4edc-be8e-8a54df9eb385','12', NULL, 310,
0, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO `namespace_plugin_rel` (`id`,`namespace_id`,`plugin_id`, `config`,
`sort`, `enabled`, `date_created`, `date_updated`) VALUES
('1801816010882822149','649330b6-c2d7-4edc-be8e-8a54df9eb385','13',
'{\"multiSelectorHandle\":\"1\",\"multiRuleHandle\":\"0\",\"threadpool\":\"shared\"}',
310, 0, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO `namespace_plugin_rel` (`id`,`namespace_id`,`plugin_id`, `config`,
`sort`, `enabled`, `date_created`, `date_updated`) VALUES
('1801816010882822150','649330b6-c2d7-4edc-be8e-8a54df9eb385','14', NULL, 80,
1, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO `namespace_plugin_rel` (`id`,`namespace_id`,`plugin_id`, `config`,
`sort`, `enabled`, `date_created`, `date_updated`) VALUES
('1801816010882822151','649330b6-c2d7-4edc-be8e-8a54df9eb385','15',
'{\"multiSelectorHandle\":\"1\",\"multiRuleHandle\":\"0\",\"threadpool\":\"shared\"}',
310, 0, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO `namespace_plugin_rel` (`id`,`namespace_id`,`plugin_id`, `config`,
`sort`, `enabled`, `date_created`, `date_updated`) VALUES
('1801816010882822152','649330b6-c2d7-4edc-be8e-8a54df9eb385','16', NULL, 110,
0, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO `namespace_plugin_rel` (`id`,`namespace_id`,`plugin_id`, `config`,
`sort`, `enabled`, `date_created`, `date_updated`) VALUES
('1801816010882822153','649330b6-c2d7-4edc-be8e-8a54df9eb385','17',
'{\"registerProtocol\":\"direct\",\"registerAddress\":\"127.0.0.1:2181\",\"corethreads\":0,\"threads\":2147483647,\"queues\":0,\"threadpool\":\"shared\"}',
310, 0, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO `namespace_plugin_rel` (`id`,`namespace_id`,`plugin_id`, `config`,
`sort`, `enabled`, `date_created`, `date_updated`) VALUES
('1801816010882822154','649330b6-c2d7-4edc-be8e-8a54df9eb385','18', NULL, 160,
0, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO `namespace_plugin_rel` (`id`,`namespace_id`,`plugin_id`, `config`,
`sort`, `enabled`, `date_created`, `date_updated`) VALUES
('1801816010882822155','649330b6-c2d7-4edc-be8e-8a54df9eb385','19',
'{\"secretKey\":\"key\"}', 30, 0, '2022-05-25 18:02:53.000', '2022-05-25
18:02:53.000');
-INSERT INTO `namespace_plugin_rel` (`id`,`namespace_id`,`plugin_id`, `config`,
`sort`, `enabled`, `date_created`, `date_updated`) VALUES
('1801816010882822156','649330b6-c2d7-4edc-be8e-8a54df9eb385','2',
'{\"model\":\"black\"}', 50, 0, '2022-05-25 18:02:53.000', '2022-05-25
18:02:53.000');
-INSERT INTO `namespace_plugin_rel` (`id`,`namespace_id`,`plugin_id`, `config`,
`sort`, `enabled`, `date_created`, `date_updated`) VALUES
('1801816010882822157','649330b6-c2d7-4edc-be8e-8a54df9eb385','20', NULL, 120,
0, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO `namespace_plugin_rel` (`id`,`namespace_id`,`plugin_id`, `config`,
`sort`, `enabled`, `date_created`, `date_updated`) VALUES
('1801816010882822158','649330b6-c2d7-4edc-be8e-8a54df9eb385','21', NULL, 40,
0, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO `namespace_plugin_rel` (`id`,`namespace_id`,`plugin_id`, `config`,
`sort`, `enabled`, `date_created`, `date_updated`) VALUES
('1801816010882822159','649330b6-c2d7-4edc-be8e-8a54df9eb385','22', NULL, 70,
0, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO `namespace_plugin_rel` (`id`,`namespace_id`,`plugin_id`, `config`,
`sort`, `enabled`, `date_created`, `date_updated`) VALUES
('1801816010882822160','649330b6-c2d7-4edc-be8e-8a54df9eb385','23', NULL, 220,
0, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO `namespace_plugin_rel` (`id`,`namespace_id`,`plugin_id`, `config`,
`sort`, `enabled`, `date_created`, `date_updated`) VALUES
('1801816010882822161','649330b6-c2d7-4edc-be8e-8a54df9eb385','24', NULL, 100,
1, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO `namespace_plugin_rel` (`id`,`namespace_id`,`plugin_id`, `config`,
`sort`, `enabled`, `date_created`, `date_updated`) VALUES
('1801816010882822162','649330b6-c2d7-4edc-be8e-8a54df9eb385','25', NULL, 410,
1, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO `namespace_plugin_rel` (`id`,`namespace_id`,`plugin_id`, `config`,
`sort`, `enabled`, `date_created`, `date_updated`) VALUES
('1801816010882822163','649330b6-c2d7-4edc-be8e-8a54df9eb385','26',
'{\"multiSelectorHandle\":\"1\"}', 200, 1, '2022-05-25 18:02:53.000',
'2022-05-25 18:02:53.000');
-INSERT INTO `namespace_plugin_rel` (`id`,`namespace_id`,`plugin_id`, `config`,
`sort`, `enabled`, `date_created`, `date_updated`) VALUES
('1801816010882822164','649330b6-c2d7-4edc-be8e-8a54df9eb385','27', NULL, 125,
1, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO `namespace_plugin_rel` (`id`,`namespace_id`,`plugin_id`, `config`,
`sort`, `enabled`, `date_created`, `date_updated`) VALUES
('1801816010882822165','649330b6-c2d7-4edc-be8e-8a54df9eb385','28', '{\"port\":
9500,\"bossGroupThreadCount\": 1,\"maxPayloadSize\":
65536,\"workerGroupThreadCount\": 12,\"userName\": \"shenyu\",\"password\":
\"shenyu\",\"isEncryptPassword\": false,\"encryptMode\":
\"\",\"leakDetectorLevel\": \"DISABLED\"}', 125, 0, '2022-05-25 18:02:53.000',
'2022-05-2 [...]
-INSERT INTO `namespace_plugin_rel` (`id`,`namespace_id`,`plugin_id`, `config`,
`sort`, `enabled`, `date_created`, `date_updated`) VALUES
('1801816010882822166','649330b6-c2d7-4edc-be8e-8a54df9eb385','29',
'{\"topic\":\"shenyu-access-logging\", \"namesrvAddr\":
\"localhost:9876\",\"producerGroup\":\"shenyu-plugin-logging-rocketmq\"}', 170,
0, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO `namespace_plugin_rel` (`id`,`namespace_id`,`plugin_id`, `config`,
`sort`, `enabled`, `date_created`, `date_updated`) VALUES
('1801816010882822167','649330b6-c2d7-4edc-be8e-8a54df9eb385','3', NULL, 90, 0,
'2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO `namespace_plugin_rel` (`id`,`namespace_id`,`plugin_id`, `config`,
`sort`, `enabled`, `date_created`, `date_updated`) VALUES
('1801816010882822168','649330b6-c2d7-4edc-be8e-8a54df9eb385','30',
'{\"cacheType\":\"memory\"}', 10, 0, '2022-05-25 18:02:53.000', '2022-05-25
18:02:53.000');
-INSERT INTO `namespace_plugin_rel` (`id`,`namespace_id`,`plugin_id`, `config`,
`sort`, `enabled`, `date_created`, `date_updated`) VALUES
('1801816010882822169','649330b6-c2d7-4edc-be8e-8a54df9eb385','31', NULL, 1, 0,
'2022-06-16 14:40:35.000', '2022-06-16 14:40:55.000');
-INSERT INTO `namespace_plugin_rel` (`id`,`namespace_id`,`plugin_id`, `config`,
`sort`, `enabled`, `date_created`, `date_updated`) VALUES
('1801816010882822170','649330b6-c2d7-4edc-be8e-8a54df9eb385','32',
'{\"host\":\"localhost\", \"port\": \"9200\"}', 190, 0, '2022-06-19
22:00:00.000', '2022-06-19 22:00:00.000');
-INSERT INTO `namespace_plugin_rel` (`id`,`namespace_id`,`plugin_id`, `config`,
`sort`, `enabled`, `date_created`, `date_updated`) VALUES
('1801816010882822171','649330b6-c2d7-4edc-be8e-8a54df9eb385','33',
'{\"host\":\"localhost\", \"port\": \"9092\"}', 180, 0, '2022-07-04
22:00:00.000', '2022-07-02 22:00:00.000');
-INSERT INTO `namespace_plugin_rel` (`id`,`namespace_id`,`plugin_id`, `config`,
`sort`, `enabled`, `date_created`, `date_updated`) VALUES
('1801816010882822172','649330b6-c2d7-4edc-be8e-8a54df9eb385','34',
'{\"projectName\": \"shenyu\", \"logStoreName\": \"shenyu-logstore\",
\"topic\": \"shenyu-topic\"}', 175, 0, '2022-06-30 21:00:00.000', '2022-06-30
21:00:00.000');
-INSERT INTO `namespace_plugin_rel` (`id`,`namespace_id`,`plugin_id`, `config`,
`sort`, `enabled`, `date_created`, `date_updated`) VALUES
('1801816010882822173','649330b6-c2d7-4edc-be8e-8a54df9eb385','35',
'{\"topic\":\"shenyu-access-logging\", \"serviceUrl\":
\"pulsar://localhost:6650\"}', 185, 0, '2022-06-30 21:00:00.000', '2022-06-30
21:00:00.000');
-INSERT INTO `namespace_plugin_rel` (`id`,`namespace_id`,`plugin_id`, `config`,
`sort`, `enabled`, `date_created`, `date_updated`) VALUES
('1801816010882822174','649330b6-c2d7-4edc-be8e-8a54df9eb385','36',
'{\"endpoint\": \"ap-guangzhou.cls.tencentcs.com\", \"topic\":
\"shenyu-topic\"}', 176, 0, '2022-06-30 21:00:00.000', '2022-06-30
21:00:00.000');
-INSERT INTO `namespace_plugin_rel` (`id`,`namespace_id`,`plugin_id`, `config`,
`sort`, `enabled`, `date_created`, `date_updated`) VALUES
('1801816010882822175','649330b6-c2d7-4edc-be8e-8a54df9eb385','38',
'{\"host\":\"127.0.0.1\",\"port\":\"8123\",\"databse\":\"shenyu-gateway\",\"username\":\"foo\",\"password\":\"bar\"}',
195, 0, '2022-06-30 21:00:00.000', '2022-06-30 21:00:00.000');
-INSERT INTO `namespace_plugin_rel` (`id`,`namespace_id`,`plugin_id`, `config`,
`sort`, `enabled`, `date_created`, `date_updated`) VALUES
('1801816010882822176','649330b6-c2d7-4edc-be8e-8a54df9eb385','39',
'{\"endpoint\":\"http://localhost:8000\"}', 40, 0, '2022-09-11 12:00:00.000',
'2022-09-11 12:00:00.000');
-INSERT INTO `namespace_plugin_rel` (`id`,`namespace_id`,`plugin_id`, `config`,
`sort`, `enabled`, `date_created`, `date_updated`) VALUES
('1801816010882822177','649330b6-c2d7-4edc-be8e-8a54df9eb385','4',
'{\"master\":\"mymaster\",\"mode\":\"standalone\",\"url\":\"192.168.1.1:6379\",\"password\":\"abc\"}',
60, 0, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO `namespace_plugin_rel` (`id`,`namespace_id`,`plugin_id`, `config`,
`sort`, `enabled`, `date_created`, `date_updated`) VALUES
('1801816010882822178','649330b6-c2d7-4edc-be8e-8a54df9eb385','40', NULL, 150,
0, '2022-07-24 19:00:00.000', '2022-07-24 19:00:00.000');
-INSERT INTO `namespace_plugin_rel` (`id`,`namespace_id`,`plugin_id`, `config`,
`sort`, `enabled`, `date_created`, `date_updated`) VALUES
('1801816010882822179','649330b6-c2d7-4edc-be8e-8a54df9eb385','42', NULL, 320,
1, '2023-05-30 18:02:53.000', '2022-05-30 18:02:53.000');
-INSERT INTO `namespace_plugin_rel` (`id`,`namespace_id`,`plugin_id`, `config`,
`sort`, `enabled`, `date_created`, `date_updated`) VALUES
('1801816010882822180','649330b6-c2d7-4edc-be8e-8a54df9eb385','43',
'{\"totalSizeInBytes\":\"104857600\",\"maxBlockMs\":\"0\",\"ioThreadCount\":\"1\",\"batchSizeThresholdInBytes\":\"524288\",\"batchCountThreshold\":\"4096\",\"lingerMs\":\"2000\",\"retries\":\"100\",\"baseRetryBackoffMs\":\"100\",\"maxRetryBackoffMs\":\"100\",\"enableLocalTest\":\"true\"
[...]
-INSERT INTO `namespace_plugin_rel` (`id`,`namespace_id`,`plugin_id`, `config`,
`sort`, `enabled`, `date_created`, `date_updated`) VALUES
('1801816010882822181','649330b6-c2d7-4edc-be8e-8a54df9eb385','44',
'{\"defaultHandleJson\":\"{\\\"authorization\\\":\\\"test:test123\\\"}\"}',
150, 0, '2022-07-24 19:00:00.000', '2022-07-24 19:00:00.000');
-INSERT INTO `namespace_plugin_rel` (`id`,`namespace_id`,`plugin_id`, `config`,
`sort`, `enabled`, `date_created`, `date_updated`) VALUES
('1801816010882822182','649330b6-c2d7-4edc-be8e-8a54df9eb385','45',
'{\"host\":\"127.0.0.1\",\"port\":5672,\"password\":\"admin\",\"username\":\"admin\",\"exchangeName\":\"exchange.logging.plugin\",\"queueName\":\"queue.logging.plugin\",\"routingKey\":\"topic.logging\",\"virtualHost\":\"/\",\"exchangeType\":\"direct\",\"durable\":\"true\",\"exclusive\":
[...]
-INSERT INTO `namespace_plugin_rel` (`id`,`namespace_id`,`plugin_id`, `config`,
`sort`, `enabled`, `date_created`, `date_updated`) VALUES
('1801816010882822183','649330b6-c2d7-4edc-be8e-8a54df9eb385','5',
'{\"multiSelectorHandle\":\"1\",\"multiRuleHandle\":\"0\"}', 200, 1,
'2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO `namespace_plugin_rel` (`id`,`namespace_id`,`plugin_id`, `config`,
`sort`, `enabled`, `date_created`, `date_updated`) VALUES
('1801816010882822184','649330b6-c2d7-4edc-be8e-8a54df9eb385','6',
'{\"register\":\"zookeeper://localhost:2181\",\"multiSelectorHandle\":\"1\",\"threadpool\":\"shared\",\"corethreads\":0,\"threads\":2147483647,\"queues\":0}',
310, 0, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO `namespace_plugin_rel` (`id`,`namespace_id`,`plugin_id`, `config`,
`sort`, `enabled`, `date_created`, `date_updated`) VALUES
('1801816010882822185','649330b6-c2d7-4edc-be8e-8a54df9eb385','8',
'{\"enabled\":false,\"registerType\":\"eureka\",\"serverLists\":\"http://localhost:8761/eureka\",\"props\":
{}}', 200, 0, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-INSERT INTO `namespace_plugin_rel` (`id`,`namespace_id`,`plugin_id`, `config`,
`sort`, `enabled`, `date_created`, `date_updated`) VALUES
('1801816010882822186','649330b6-c2d7-4edc-be8e-8a54df9eb385','9', NULL, 130,
0, '2022-05-25 18:02:53.000', '2022-05-25 18:02:53.000');
-
INSERT INTO `resource` (`id`, `parent_id`, `title`, `name`, `url`,
`component`, `resource_type`, `sort`, `icon`, `is_leaf`, `is_route`, `perms`,
`status`, `date_created`, `date_updated`) VALUES ('1792749362445840479',
'1357956838021890048', 'SHENYU.MENU.SYSTEM.MANAGMENT.NAMESPACEPLUGIN',
'namespacePlugin', '/config/namespacePlugin', 'namespacePlugin', 1, 2, 'build',
0, 0, '', 1, '2024-06-25 18:02:53.000', '2024-06-25 18:02:53.000');
INSERT INTO `resource` (`id`, `parent_id`, `title`, `name`, `url`,
`component`, `resource_type`, `sort`, `icon`, `is_leaf`, `is_route`, `perms`,
`status`, `date_created`, `date_updated`) VALUES ('1792749362445840480',
'1792749362445840479', 'SHENYU.BUTTON.SYSTEM.LIST', '', '', '', 2, 0, '', 1, 0,
'system:namespacePlugin:list', 1, '2024-06-25 18:02:53.000', '2024-06-25
18:02:53.000');
INSERT INTO `resource` (`id`, `parent_id`, `title`, `name`, `url`,
`component`, `resource_type`, `sort`, `icon`, `is_leaf`, `is_route`, `perms`,
`status`, `date_created`, `date_updated`) VALUES ('1792749362445840481',
'1792749362445840479', 'SHENYU.BUTTON.SYSTEM.DELETE', '', '', '', 2, 1, '', 1,
0, 'system:namespacePlugin:delete', 1, '2024-06-25 18:02:53.000', '2024-06-25
18:02:53.000');
@@ -206,35 +162,35 @@ ALTER TABLE `alert_receiver` ADD COLUMN `namespace_id`
varchar(50) NOT NULL COMM
UPDATE selector
SET namespace_id = '649330b6-c2d7-4edc-be8e-8a54df9eb385'
-WHERE namespace_id IS NULL;
+WHERE namespace_id IS NULL OR LENGTH(namespace_id) = 0;
UPDATE rule
SET namespace_id = '649330b6-c2d7-4edc-be8e-8a54df9eb385'
-WHERE namespace_id IS NULL;
+WHERE namespace_id IS NULL OR LENGTH(namespace_id) = 0;
UPDATE meta_data
SET namespace_id = '649330b6-c2d7-4edc-be8e-8a54df9eb385'
-WHERE namespace_id IS NULL;
+WHERE namespace_id IS NULL OR LENGTH(namespace_id) = 0;
UPDATE app_auth
SET namespace_id = '649330b6-c2d7-4edc-be8e-8a54df9eb385'
-WHERE namespace_id IS NULL;
+WHERE namespace_id IS NULL OR LENGTH(namespace_id) = 0;
UPDATE discovery
SET namespace_id = '649330b6-c2d7-4edc-be8e-8a54df9eb385'
-WHERE namespace_id IS NULL;
+WHERE namespace_id IS NULL OR LENGTH(namespace_id) = 0;
UPDATE discovery_upstream
SET namespace_id = '649330b6-c2d7-4edc-be8e-8a54df9eb385'
-WHERE namespace_id IS NULL;
+WHERE namespace_id IS NULL OR LENGTH(namespace_id) = 0;
UPDATE proxy_selector
SET namespace_id = '649330b6-c2d7-4edc-be8e-8a54df9eb385'
-WHERE namespace_id IS NULL;
+WHERE namespace_id IS NULL OR LENGTH(namespace_id) = 0;
UPDATE alert_receiver
SET namespace_id = '649330b6-c2d7-4edc-be8e-8a54df9eb385'
-WHERE namespace_id IS NULL;
+WHERE namespace_id IS NULL OR LENGTH(namespace_id) = 0;
DROP TABLE IF EXISTS `scale_policy`;
CREATE TABLE IF NOT EXISTS `scale_policy`
@@ -291,3 +247,40 @@ CREATE TABLE `namespace_user_rel` (
`date_updated` timestamp NOT NULL
DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'date_updated'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
COMMENT='namespace user relation ';
+
+INSERT INTO `namespace_plugin_rel` (
+ `id`,
+ `namespace_id`,
+ `plugin_id`,
+ `config`,
+ `sort`,
+ `enabled`,
+ `date_created`,
+ `date_updated`
+)
+SELECT
+ CONCAT(FLOOR(UNIX_TIMESTAMP(NOW(3)) * 1000), LPAD(FLOOR(RAND() * 1000000),
6, '0')),
+ '649330b6-c2d7-4edc-be8e-8a54df9eb385',
+ `id`,
+ `config`,
+ `sort`,
+ `enabled`,
+ `date_created`,
+ `date_updated`
+FROM `plugin`;
+
+
+INSERT INTO `namespace_user_rel` (
+ `id`,
+ `namespace_id`,
+ `user_id`,
+ `date_created`,
+ `date_updated`
+)
+SELECT
+ CONCAT(FLOOR(UNIX_TIMESTAMP(NOW(3)) * 1000), LPAD(FLOOR(RAND() * 1000000),
6, '0')),
+ '649330b6-c2d7-4edc-be8e-8a54df9eb385',
+ `id`,
+ `date_created`,
+ `date_updated`
+FROM `dashboard_user`;
\ No newline at end of file
