4.4.2.sql

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

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

drop table if exists certificate;

CREATE TABLE certificate (
  id varchar(100) NOT NULL default '',
  `describe` varchar(100) default '',
  PRIMARY KEY  (id)
) ENGINE = InnoDB
CHARACTER SET utf8 COLLATE utf8_general_ci;


--
-- Dumping data for table 'certificate'
--

INSERT INTO certificate VALUES ('ff80808105416d3b0105416d3eca0001','222');
INSERT INTO certificate VALUES ('ff808081054175b501054175b9190001','222');

--
-- 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
CHARACTER SET utf8 COLLATE utf8_general_ci;

--
-- Dumping data for table 'student'
--

INSERT INTO student VALUES ('ff80808105416d3b0105416d3eca0002','ff80808105416d3b0105416d3eca0001','tomclus','200512345',33);
INSERT INTO student VALUES ('ff80808105416d3b0105416d3eca0002','ff808081054175b501054175b9190001','tom','11111111',33);

--
-- 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
CHARACTER SET utf8 COLLATE utf8_general_ci;

--
-- Dumping data for table 'team'
--

INSERT INTO team VALUES ('ff80808105416d3b0105416d3eca0002','team1');