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

/*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
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值