employees.sql

来自「用JSF1.2和EJB3.0实现的一个项目实例」· SQL 代码 · 共 43 行

/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='SYSTEM' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */;
/*!40101 SET SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */;
/*!40103 SET SQL_NOTES='ON' */;


# Host: localhost    Database: jsfejb3_demo
# ------------------------------------------------------
# Server version 5.0.41-community-nt

DROP DATABASE IF EXISTS `jsfejb3_demo`;
CREATE DATABASE `jsfejb3_demo` /*!40100 DEFAULT CHARACTER SET 

utf8 */;
USE `jsfejb3_demo`;

#
# Table structure for table employees
#

CREATE TABLE `employees` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(56) NOT NULL default '',
  `age` int(11) default NULL,
  `address` varchar(128) default NULL,
  `registerTime` timestamp NULL default CURRENT_TIMESTAMP on 

update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Dumping data for table employees
#

INSERT INTO `employees` VALUES (1,'++YONG',26,'福建','2008-02-20 18:11:15');

/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;