Skip to content

Instantly share code, notes, and snippets.

@jwlyn
Last active August 29, 2015 14:01
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jwlyn/ea55dc3f16248fa88657 to your computer and use it in GitHub Desktop.
Save jwlyn/ea55dc3f16248fa88657 to your computer and use it in GitHub Desktop.
淘宝diamond的sql脚本
create database if not exists `diamond`;
grant all on diamond.* to zh@'%' identified by 'abc';
use `diamond`;
create table config_info (
`id` bigint(64) unsigned NOT NULL auto_increment,
`data_id` varchar(255) NOT NULL DEFAULT '',
`group_id` varchar(128) NOT NULL DEFAULT '',
`content` longtext NOT NULL,
`md5` varchar(32) NOT NULL DEFAULT '',
`gmt_create` datetime NOT NULL DEFAULT '2010-05-05 00:00:00',
`gmt_modified` datetime NOT NULL DEFAULT '2010-05-05 00:00:00',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_config_datagroup` (`data_id`,`group_id`)
)ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment