Mysql 之 ALTER TABLE
来源:互联网 发布:java全局变量怎么定义 编辑:程序博客网 时间:2024/05/16 17:18
-- MySQL dump 10.13 Distrib 5.5.20, for Win64 (x86)
--
-- Host: localhost Database: gdtswebdb
-- ------------------------------------------------------
-- Server version 5.5.20-log
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `gdts_role`
--
ALTER TABLE gdts_solution ADD ManagerID varchar(6) DEFAULT NULL;
ALTER TABLE gdts_module ADD CreateUserID varchar(6) DEFAULT NULL;
LOCK TABLES `gdts_role` WRITE;
/*!40000 ALTER TABLE `gdts_role` DISABLE KEYS */;
INSERT INTO `gdts_role` VALUES (998,'子管理员',NULL,NULL,CURRENT_TIMESTAMP);
/*!40000 ALTER TABLE `gdts_role` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2013-05-31 9:26:06
--
-- Host: localhost Database: gdtswebdb
-- ------------------------------------------------------
-- Server version 5.5.20-log
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `gdts_role`
--
ALTER TABLE gdts_solution ADD ManagerID varchar(6) DEFAULT NULL;
ALTER TABLE gdts_module ADD CreateUserID varchar(6) DEFAULT NULL;
LOCK TABLES `gdts_role` WRITE;
/*!40000 ALTER TABLE `gdts_role` DISABLE KEYS */;
INSERT INTO `gdts_role` VALUES (998,'子管理员',NULL,NULL,CURRENT_TIMESTAMP);
/*!40000 ALTER TABLE `gdts_role` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2013-05-31 9:26:06
- Mysql 之 ALTER TABLE
- ALTER TABLE语法--mysql
- MySQL - ALTER TABLE语法
- mysql ALTER TABLE
- mysql alter table
- mysql alter table总结
- MySQL的alter table
- MySQL的alter table
- mysql alter table 操作
- mysql alter table
- MySQL简单操作之alter table改变表的结构
- MySQL简单操作之alter table改变表的结构
- mysql alter table的过程
- (读书笔记)Mysql alter table
- mysql的alter table 命令
- mysql之alter
- MySQL之alter语句
- MySQL ALTER TABLE: ALTER vs CHANGE vs MODIFY COLUMN
- 几种简单排序算法
- 图片转换二进制流-二进制流转换图片保存(winform、Wince程序通用)
- VB 循环播放视频文件
- ohmygod
- 三层架构之初识庐山真面目
- Mysql 之 ALTER TABLE
- 获取class文件的编译级别
- iOS:UIViewController周期、属性和相关方法
- crond 笔记
- 解决Jar mismatch! Fix your dependencies
- Android编译和运行原理
- HDU1239:Calling Extraterrestrial Intelligence Again
- C#入门经典第五版 示例 3
- JSON格式的数据