10.5.2.sql

来自「Hibernate开发及整合应用大全 蔡雪焘编著 本书用典型的示例剖析Hiber」· SQL 代码 · 共 55 行

drop database if exists schoolproject;
create database schoolproject;
use schoolproject;

--
-- Table structure for table `student`
--

DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
  `team_id` varchar(100) default '',
  `id` varchar(100) NOT NULL default '',
  `name` varchar(20) default '',
  `cardId` varchar(20) NOT NULL default '',
  `age` int(11) default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `student`
--


/*!40000 ALTER TABLE `student` DISABLE KEYS */;
LOCK TABLES `student` WRITE;
INSERT INTO `student` VALUES ('ff80808105416d3b0105416d3eca0002','5c23417401f153ee0101f153f2a10001','spark','aa',0);
INSERT INTO `student` VALUES('ff80808105416d3b0105416d3eca0002','5c23417401f166090101f1660cdf0001','jerry','aa',0);
INSERT INTO `student` VALUES('ff80808105416d3b0105416d3eca0002','ff80808105416d3b0105416d3eca0001','tomclus','ba',33);
INSERT INTO `student` VALUES('ff80808105416d3b0105416d3eca0002','ff808081054175b501054175b9190001','tom','bb',33);
UNLOCK TABLES;
/*!40000 ALTER TABLE `student` ENABLE KEYS */;

--
-- Table structure for table `team`
--

DROP TABLE IF EXISTS `team`;
CREATE TABLE `team` (
  `id` varchar(100) NOT NULL default '',
  `teamName` varchar(100) default '',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `team`
--


/*!40000 ALTER TABLE `team` DISABLE KEYS */;
LOCK TABLES `team` WRITE;
INSERT INTO `team` VALUES ('ff80808105416d3b0105416d3eca0002','team1');
UNLOCK TABLES;