触发器生成id mysql_mysql添加id-uuid 触发器

最新推荐文章于 2023-10-26 11:39:22 发布

燕枝

最新推荐文章于 2023-10-26 11:39:22 发布

阅读量468

点赞数

文章标签：触发器生成id mysql

本文链接：https://blog.csdn.net/weixin_31900373/article/details/113169493

版权

/*Navicat MySQL Data Transfer

Source Server : 爬虫

Source Server Version : 50173

Source Host : 101.201.78.86:3306

Source Database : tw_census

Target Server Type : MYSQL

Target Server Version : 50173

File Encoding : 65001

Date: 2017-12-22 15:58:57*/SET FOREIGN_KEY_CHECKS=0;-- ----------------------------

-- Table structure forapp_channel-- ----------------------------DROP TABLE IF EXISTS `app_channel`;

CREATE TABLE `app_channel` (

`id` varchar(32) NOT NULL DEFAULT '1',

`app_id` varchar(32) NOT NULL,

`channel_id` varchar(32) NOT NULL,

`create_time` datetime NOT NULL,

`create_user` varchar(32) DEFAULT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ----------------------------

-- Table structure forapp_info-- ----------------------------DROP TABLE IF EXISTS `app_info`;

CREATE TABLE `app_info` (

`id` varchar(32) NOT NULL DEFAULT '1',

`app_name` varchar(32) NOT NULL,

`create_time` datetime NOT NULL,

`create_user` varchar(32) NOT NULL,

`app_code` varchar(32) NOT NULL,

`app_del`int(6) NOT NULL,

PRIMARY KEY (`id`),

KEY `id` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ----------------------------

-- Table structure forapp_pay-- ----------------------------DROP TABLE IF EXISTS `app_pay`;

CREATE TABLE `app_pay` (

`id` varchar(32) NOT NULL DEFAULT '1',

`user_id` varchar(32) NOT NULL,

`app_id` varchar(32) NOT NULL,

`channel_id` varchar(32) NOT NULL,

`server_id` varchar(32) NOT NULL,

`commodit` text,

`price`int(11) NOT NULL,

`pay_type`int(11) NOT NULL,

`pay_cp_id` varchar(64) NOT NULL,

`order_status`int(11) DEFAULT NULL COMMENT '支付状态 0：未付款，1：已付款未领取 2：已付款已领取道具',

`pay_time` datetime NOT NULL,

`user_k`int(32) NOT NULL,

`aorl`int(11) NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ----------------------------

-- Table structure forapp_server-- ----------------------------DROP TABLE IF EXISTS `app_server`;

CREATE TABLE `app_server` (

`id` varchar(32) NOT NULL DEFAULT '1',

`app_id` varchar(32) NOT NULL,

`server_id` varchar(32) NOT NULL,

`create_time` datetime NOT NULL,

`create_user` varchar(32) DEFAULT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ----------------------------

-- Table structure forapp_user-- ----------------------------DROP TABLE IF EXISTS `app_user`;

CREATE TABLE `app_user` (

`id` varchar(32) NOT NULL DEFAULT '1',

`u_name` varchar(32) NOT NULL,

`cp_id` varchar(32) NOT NULL,

`server_id` varchar(32) NOT NULL,

`channel_id` varchar(32) DEFAULT NULL,

`app_id` varchar(32) DEFAULT NULL,

`level`int(11) DEFAULT NULL,

`game_coin`int(32) DEFAULT NULL,

`diamond_coin`int(32) DEFAULT NULL,

`create_ip` varchar(32) DEFAULT NULL,

`create_time` datetime NOT NULL,

`user_k`int(11) NOT NULL,

`aorl`int(11) DEFAULT NULL,

PRIMARY KEY (`id`),

KEY `id` (`id`),

KEY `Channel_id` (`channel_id`),

KEY `Appid` (`app_id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ----------------------------

-- Table structure forchannel_info-- ----------------------------DROP TABLE IF EXISTS `channel_info`;

CREATE TABLE `channel_info` (

`id` varchar(32) NOT NULL DEFAULT '1',

`channel_name` varchar(32) NOT NULL,

`channel_code` varchar(32) NOT NULL,

`create_time` datetime NOT NULL,

`create_user` varchar(32) DEFAULT NULL,

`partner` varchar(32) DEFAULT NULL,

`aorl`int(6) NOT NULL,

`channel_del`int(6) NOT NULL,

PRIMARY KEY (`id`),

KEY `id` (`id`) USING BTREE

) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ----------------------------

-- Table structure forchannel_server-- ----------------------------DROP TABLE IF EXISTS `channel_server`;

CREATE TABLE `channel_server` (

`id` varchar(32) NOT NULL DEFAULT '1',

`channel_id` varchar(32) NOT NULL,

`server_id` varchar(32) NOT NULL,

`create_time` datetime NOT NULL,

`create_user` varchar(32) DEFAULT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ----------------------------

-- Table structure forlogin_90_only_history-- ----------------------------DROP TABLE IF EXISTS `login_90_only_history`;

CREATE TABLE `login_90_only_history` (

`id` varchar(32) NOT NULL DEFAULT '1',

`use_id` varchar(32) NOT NULL,

`app_id` varchar(32) NOT NULL,

`channel_id` varchar(32) NOT NULL,

`Server_id` varchar(32) NOT NULL,

`login_time` datetime NOT NULL,

`user_k`int(32) DEFAULT NULL,

`aorl`int(11) NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ----------------------------

-- Table structure forlogin_history-- ----------------------------DROP TABLE IF EXISTS `login_history`;

CREATE TABLE `login_history` (

`id` varchar(32) NOT NULL DEFAULT '1',

`use_id` varchar(32) NOT NULL,

`login_time` datetime NOT NULL,

`app_id` varchar(32) NOT NULL,

`channel_id` varchar(32) NOT NULL,

`server_id` varchar(32) NOT NULL,

`user_k`int(32) DEFAULT NULL,

`aorl`int(11) NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ----------------------------

-- Table structure forserver_info-- ----------------------------DROP TABLE IF EXISTS `server_info`;

CREATE TABLE `server_info` (

`id` varchar(32) NOT NULL DEFAULT '1',

`server_name` varchar(32) NOT NULL,

`create_time` datetime NOT NULL,

`create_user` varchar(32) DEFAULT NULL,

`aorl`int(6) NOT NULL,

`partner` varchar(32) DEFAULT NULL,

`server_del`int(6) NOT NULL,

PRIMARY KEY (`id`),

KEY `id` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ----------------------------

-- Table structure forsys_account-- ----------------------------DROP TABLE IF EXISTS `sys_account`;

CREATE TABLE `sys_account` (

`id` varchar(32) NOT NULL DEFAULT '1',

`sys_admin` varchar(32) DEFAULT NULL,

`ps` varchar(32) DEFAULT NULL,

`key_sen` varchar(32) DEFAULT NULL,

`lev`int(32) DEFAULT NULL,

`type`int(32) DEFAULT NULL,

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;-- ----------------------------

-- Table structure fortest-- ----------------------------DROP TABLE IF EXISTS `test`;

CREATE TABLE `test` (

`id`int(11) DEFAULT NULL,

`name` varchar(32) DEFAULT NULL

) ENGINE=MyISAM DEFAULT CHARSET=utf8;-- ----------------------------

-- Table structure fortest11-- ----------------------------DROP TABLE IF EXISTS `test11`;

CREATE TABLE `test11` (

`Id`int(11) NOT NULL AUTO_INCREMENT,

`zd1` varchar(255) DEFAULT NULL,

`zd` varchar(255) DEFAULT NULL,

PRIMARY KEY (`Id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TRIGGER IF EXISTS `tri_auto_uuid_app_channel`;

DELIMITER ;;

CREATE TRIGGER `tri_auto_uuid_app_channel` BEFORE INSERT ON `app_channel` FOR EACH ROW BEGINif new.id = '1' THEN set new.id = (select REPLACE(uuid(), '-', ''));

endif;

END

;;

DELIMITER ;

DROP TRIGGER IF EXISTS `tri_auto_uuid_app_info`;

DELIMITER ;;

CREATE TRIGGER `tri_auto_uuid_app_info` BEFORE INSERT ON `app_info` FOR EACH ROW BEGINif new.id = '1' THEN set new.id = (select REPLACE(uuid(), '-', ''));

endif;

END

;;

DELIMITER ;

DROP TRIGGER IF EXISTS `tri_auto_uuid_app_pay`;

DELIMITER ;;

CREATE TRIGGER `tri_auto_uuid_app_pay` BEFORE INSERT ON `app_pay` FOR EACH ROW BEGINif new.id = '1' THEN set new.id = (select REPLACE(uuid(), '-', ''));

endif;

END

;;

DELIMITER ;

DROP TRIGGER IF EXISTS `tri_auto_uuid_app_server`;

DELIMITER ;;

CREATE TRIGGER `tri_auto_uuid_app_server` BEFORE INSERT ON `app_server` FOR EACH ROW BEGINif new.id = '1' THEN set new.id = (select REPLACE(uuid(), '-', ''));

endif;

END

;;

DELIMITER ;

DROP TRIGGER IF EXISTS `tri_auto_uuid_app_user`;

DELIMITER ;;

CREATE TRIGGER `tri_auto_uuid_app_user` BEFORE INSERT ON `app_user` FOR EACH ROW BEGINif new.id = '1' THEN set new.id = (select REPLACE(uuid(), '-', ''));

endif;

END

;;

DELIMITER ;

DROP TRIGGER IF EXISTS `tri_auto_uuid_channel_info`;

DELIMITER ;;

CREATE TRIGGER `tri_auto_uuid_channel_info` BEFORE INSERT ON `channel_info` FOR EACH ROW BEGINif new.id = '1' THEN set new.id = (select REPLACE(uuid(), '-', ''));

endif;

END

;;

DELIMITER ;

DROP TRIGGER IF EXISTS `tri_auto_uuid_channel_server`;

DELIMITER ;;

CREATE TRIGGER `tri_auto_uuid_channel_server` BEFORE INSERT ON `channel_server` FOR EACH ROW BEGINif new.id = '1' THEN set new.id = (select REPLACE(uuid(), '-', ''));

endif;

END

;;

DELIMITER ;

DROP TRIGGER IF EXISTS `tri_auto_uuid_login_90_only_history`;

DELIMITER ;;

CREATE TRIGGER `tri_auto_uuid_login_90_only_history` BEFORE INSERT ON `login_90_only_history` FOR EACH ROW BEGINif new.id = '1' THEN set new.id = (select REPLACE(uuid(), '-', ''));

endif;

END

;;

DELIMITER ;

DROP TRIGGER IF EXISTS `tri_auto_uuid_login_history`;

DELIMITER ;;

CREATE TRIGGER `tri_auto_uuid_login_history` BEFORE INSERT ON `login_history` FOR EACH ROW BEGINif new.id = '1' THEN set new.id = (select REPLACE(uuid(), '-', ''));

endif;

END

;;

DELIMITER ;

DROP TRIGGER IF EXISTS `tri_auto_uuid_server_info`;

DELIMITER ;;

CREATE TRIGGER `tri_auto_uuid_server_info` BEFORE INSERT ON `server_info` FOR EACH ROW BEGINif new.id = '1' THEN set new.id = (select REPLACE(uuid(), '-', ''));

endif;

END

;;

DELIMITER ;

DROP TRIGGER IF EXISTS `tri_auto_uuid_sys_account`;

DELIMITER ;;

CREATE TRIGGER `tri_auto_uuid_sys_account` BEFORE INSERT ON `sys_account` FOR EACH ROW BEGINif new.id = '1' THEN set new.id = (select REPLACE(uuid(), '-', ''));

endif;

END

;;

DELIMITER ;

燕枝

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
触发器生成id mysql_mysql添加id-uuid 触发器

/*Navicat MySQL Data TransferSource Server : 爬虫Source Server Version : 50173Source Host : 101.201.78.86:3306Source Database : tw_censusTarget Server Type : MYSQLTarget Serve...
复制链接

扫一扫