text: CREATE DATABASE /*!32312 IF NOT EXISTS*/`musicstore` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci */;
  
  USE `musicstore`;
  
  DROP TABLE IF EXISTS `ums_admin`;
  
  CREATE TABLE `ums_admin` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `username` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
    `password` varchar(300) COLLATE utf8_unicode_ci NOT NULL,
    `email` varchar(300) COLLATE utf8_unicode_ci NOT NULL,
    `nick_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
    `note` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
    `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `login_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `status` int(11) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;