`

create database hibnie

阅读更多

/*
Navicat MySQL Data Transfer

Source Server         : connection
Source Server Version : 60011
Source Host           : localhost:3306
Source Database       : hibnie

Target Server Type    : MYSQL
Target Server Version : 60011
File Encoding         : 65001

Date: 2011-04-15 17:18:02
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `hibernatedialect`
-- ----------------------------
DROP TABLE IF EXISTS `hibernatedialect`;
CREATE TABLE `hibernatedialect` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `RDBMS` varchar(30) NOT NULL DEFAULT '',
  `Dialect` varchar(200) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of hibernatedialect
-- ----------------------------
INSERT INTO hibernatedialect VALUES ('1', 'DB2', 'org.hibernate.dialect.DB2Dialect');
INSERT INTO hibernatedialect VALUES ('2', 'DB2 AS/400', 'org.hibernate.dialect.DB2400Dialect');
INSERT INTO hibernatedialect VALUES ('3', 'DB2 OS390', 'org.hibernate.dialect.DB2390Dialect');
INSERT INTO hibernatedialect VALUES ('5', 'PostgreSQL', 'org.hibernate.dialect.PostgreSQLDialect');
INSERT INTO hibernatedialect VALUES ('6', 'MySQL', 'org.hibernate.dialect.MySQLDialevct');
INSERT INTO hibernatedialect VALUES ('7', 'MySQL with InnoDB', 'org.hibernate.dialect.MySQLInnoDBDialect');
INSERT INTO hibernatedialect VALUES ('8', 'MySQL with MyISAM', 'org.hibernate.dialect.MySQLMyISAMDialect');
INSERT INTO hibernatedialect VALUES ('9', 'Oracle(any version)', 'org.hibernate.dialect.OracleDialect');
INSERT INTO hibernatedialect VALUES ('10', 'Oracle 9i', 'org.hibernate.dialect.Oracle9iDialect');
INSERT INTO hibernatedialect VALUES ('11', 'Oracle 10g', 'org.hibernate.dialect.Oracle10gDialect');
INSERT INTO hibernatedialect VALUES ('12', 'Sybase', 'org.hibernate.dialect.SybaseDialect');
INSERT INTO hibernatedialect VALUES ('13', 'Sybase Anywhere', 'org.hibernate.dialect.SybaseAnywhereDialect');
INSERT INTO hibernatedialect VALUES ('14', 'Microsoft SQL Server', 'org.hibernate.dialect.SQLServerDialect');
INSERT INTO hibernatedialect VALUES ('15', 'SAP DB', 'org.hibernate.dialect.SAPDBDialect');
INSERT INTO hibernatedialect VALUES ('16', 'Informix', 'org.hibernate.dialect.InformixDialect');
INSERT INTO hibernatedialect VALUES ('17', 'HypersonicSQL', 'org.hibernate.dialect.HSQLDialect');
INSERT INTO hibernatedialect VALUES ('18', 'Ingres', 'org.hibernate.dialect.IngresDialect');
INSERT INTO hibernatedialect VALUES ('19', 'Progress', 'org.hibernate.dialect.ProgressDialect');
INSERT INTO hibernatedialect VALUES ('20', 'Mckoi SQL', 'org.hibernate.dialect.MckoiDialect');
INSERT INTO hibernatedialect VALUES ('21', 'Interbase', 'org.hibernate.dialect.InterbaseDialect');
INSERT INTO hibernatedialect VALUES ('22', 'Pointbase', 'org.hibernate.dialect.PointbaseDialect');
INSERT INTO hibernatedialect VALUES ('23', 'FrontBase', 'org.hibernate.dialect.FrontbaseDialect');
INSERT INTO hibernatedialect VALUES ('24', 'Firebird', '');

-- ----------------------------
-- Table structure for `tuser`
-- ----------------------------
DROP TABLE IF EXISTS `tuser`;
CREATE TABLE `tuser` (
  `uid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(20) NOT NULL DEFAULT '',
  `password` varchar(20) NOT NULL DEFAULT '',
  `age` int(3) NOT NULL DEFAULT '18',
  `birth` date DEFAULT NULL,
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tuser
-- ----------------------------
INSERT INTO tuser VALUES ('1', 'a', 'a', '25', '1985-05-20');

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics