用户注册



邮箱:

密码:

用户登录


邮箱:

密码:
记住登录一个月忘记密码?

发表随想


还能输入:200字
云代码 - sql代码库

广东海洋大学体育馆管理系统 数据库脚本

2013-02-09 作者: 小蜜锋举报

[sql]代码库

/*
Navicat MySQL Data Transfer

Source Server         : jianfengstudio
Source Database       : gymdb

Target Server Type    : MYSQL

Date: 2013-02-09 00:29:14
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `admin`
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
  `aId` int(11) NOT NULL AUTO_INCREMENT,
  `aName` varchar(15) NOT NULL,
  `aPassword` char(32) NOT NULL,
  `idCardNo` varchar(18) NOT NULL,
  `birthdate` date NOT NULL,
  `power` int(11) NOT NULL COMMENT '1-普通管理员  2-超级管理员',
  `email` varchar(30) NOT NULL,
  `phone` varchar(11) NOT NULL,
  `status` varchar(15) NOT NULL,
  `aEntry` date NOT NULL,
  PRIMARY KEY (`aId`)
) ENGINE=InnoDB AUTO_INCREMENT=100007 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES ('100000', '剑锋', '25d55ad2ff8a400af466c86d713c07ad', '441333333333333333', '2012-12-21', '2', '111111111@qq.com', '1111111111', '1', '2013-01-03');
INSERT INTO `admin` VALUES ('100001', '软件1102', '202cb962ac59079b964b07152d234b70', '231512345678987898', '2013-01-04', '1', 'hdrj1102@163.com', '100000000', '0', '2013-01-04');
INSERT INTO `admin` VALUES ('100002', 'xiaofei', '6893ea0ff855c76e74bc2ff8136f39f4', 'xiaofei', '2013-01-04', '1', 'xiaofei', 'xiaofei', '0', '2013-01-04');
INSERT INTO `admin` VALUES ('100003', 'xiaofei', 'ff83eaff8d55c76e74bc27f8136f3ff8', 'xiaofei', '2013-01-04', '1', 'xiaofei', 'xiaofei', '0', '2013-01-04');
INSERT INTO `admin` VALUES ('100004', '云飞', '6ae7d4ff840f63f3ffcfad8ff869c660', '441111111111111111', '1992-01-04', '1', '1234567@qq.com', '1111111111', '1', '2013-01-04');
INSERT INTO `admin` VALUES ('100005', '云飞', '6893ea02fff8c76ec4bc2ff8136f39f4', '123', '2013-01-24', '1', '123', '1234', '1', '2013-01-04');
INSERT INTO `admin` VALUES ('100006', 'chen', '47bce5c74ff89f4867dbd57e9ca9f808', '322352352', '2013-01-08', '1', 'sggsdg', '23233', '1', '2013-01-04');

-- ----------------------------
-- Table structure for `equipment`
-- ----------------------------
DROP TABLE IF EXISTS `equipment`;
CREATE TABLE `equipment` (
  `eId` int(8) NOT NULL AUTO_INCREMENT,
  `eTypeId` int(8) NOT NULL,
  `buyDate` date NOT NULL,
  `buyCost` float(8,2) NOT NULL,
  `eFee` float(8,2) NOT NULL,
  `status` char(1) NOT NULL,
  `borrowCount` int(8) NOT NULL,
  PRIMARY KEY (`eId`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of equipment
-- ----------------------------
INSERT INTO `equipment` VALUES ('1', '1', '2013-01-03', '100.00', '10.00', '1', '3');
INSERT INTO `equipment` VALUES ('2', '2', '2013-01-03', '80.00', '15.00', '1', '0');
INSERT INTO `equipment` VALUES ('3', '3', '2013-01-03', '70.00', '3.00', '1', '0');
INSERT INTO `equipment` VALUES ('4', '4', '2013-01-03', '8.00', '0.50', '1', '0');
INSERT INTO `equipment` VALUES ('5', '5', '2013-01-03', '300.00', '10.00', '1', '0');
INSERT INTO `equipment` VALUES ('6', '6', '2013-01-03', '150.00', '9.00', '1', '0');
INSERT INTO `equipment` VALUES ('7', '7', '2013-01-03', '280.00', '9.00', '1', '0');
INSERT INTO `equipment` VALUES ('8', '8', '2013-01-03', '20.00', '1.00', '1', '0');
INSERT INTO `equipment` VALUES ('9', '9', '2013-01-03', '80.00', '5.00', '1', '0');
INSERT INTO `equipment` VALUES ('10', '10', '2013-01-03', '130.00', '4.00', '1', '0');
INSERT INTO `equipment` VALUES ('11', '11', '2013-01-03', '30.00', '1.00', '1', '0');
INSERT INTO `equipment` VALUES ('12', '12', '2013-01-03', '20.00', '0.30', '1', '1');
INSERT INTO `equipment` VALUES ('13', '13', '2013-01-03', '8.00', '0.20', '1', '0');
INSERT INTO `equipment` VALUES ('14', '14', '2013-01-03', '190.00', '10.00', '1', '0');
INSERT INTO `equipment` VALUES ('15', '1', '2013-01-01', '100.00', '10.00', '0', '0');
INSERT INTO `equipment` VALUES ('16', '1', '2013-01-01', '100.00', '11.00', '0', '0');
INSERT INTO `equipment` VALUES ('17', '1', '2013-01-04', '10.00', '10.00', '1', '0');

-- ----------------------------
-- Table structure for `equipmentrent`
-- ----------------------------
DROP TABLE IF EXISTS `equipmentrent`;
CREATE TABLE `equipmentrent` (
  `eRentId` int(8) NOT NULL AUTO_INCREMENT,
  `eId` int(8) NOT NULL,
  `uId` char(16) NOT NULL,
  `borrowBegin` datetime NOT NULL,
  `borrowEnd` datetime NOT NULL,
  `borrowFee` float(8,2) NOT NULL,
  `status` char(1) NOT NULL,
  PRIMARY KEY (`eRentId`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of equipmentrent
-- ----------------------------
INSERT INTO `equipmentrent` VALUES ('1', '12', '201011701207', '2013-01-04 08:00:00', '2013-01-04 17:00:00', '2.70', '0');
INSERT INTO `equipmentrent` VALUES ('2', '1', '201011701212', '2013-01-04 11:00:00', '2013-01-04 12:00:00', '10.00', '2');
INSERT INTO `equipmentrent` VALUES ('3', '1', '201011701207', '2012-01-01 08:00:00', '2012-01-01 09:00:00', '10.00', '0');
INSERT INTO `equipmentrent` VALUES ('4', '1', '201011701207', '2013-01-04 08:00:00', '2013-01-04 10:00:00', '20.00', '1');
INSERT INTO `equipmentrent` VALUES ('5', '1', '2010117', '2013-01-04 08:00:00', '2013-01-04 09:00:00', '10.00', '2');
INSERT INTO `equipmentrent` VALUES ('6', '3', '2010117', '2013-02-04 08:00:00', '2013-02-04 09:00:00', '3.00', '1');
INSERT INTO `equipmentrent` VALUES ('7', '1', '2010117', '2013-03-04 08:00:00', '2013-03-04 09:00:00', '10.00', '1');

-- ----------------------------
-- Table structure for `equipmenttype`
-- ----------------------------
DROP TABLE IF EXISTS `equipmenttype`;
CREATE TABLE `equipmenttype` (
  `eTypeId` int(8) NOT NULL AUTO_INCREMENT,
  `eTypeName` varchar(16) NOT NULL,
  PRIMARY KEY (`eTypeId`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of equipmenttype
-- ----------------------------
INSERT INTO `equipmenttype` VALUES ('1', '羽毛球拍');
INSERT INTO `equipmenttype` VALUES ('2', '篮球');
INSERT INTO `equipmenttype` VALUES ('3', '乒乓球拍');
INSERT INTO `equipmenttype` VALUES ('4', '毽子');
INSERT INTO `equipmenttype` VALUES ('5', '哑铃');
INSERT INTO `equipmenttype` VALUES ('6', '标枪');
INSERT INTO `equipmenttype` VALUES ('7', '铁饼');
INSERT INTO `equipmenttype` VALUES ('8', '潜水镜');
INSERT INTO `equipmenttype` VALUES ('9', '泳衣');
INSERT INTO `equipmenttype` VALUES ('10', '足球');
INSERT INTO `equipmenttype` VALUES ('11', '桌球');
INSERT INTO `equipmenttype` VALUES ('12', '高尔夫球');
INSERT INTO `equipmenttype` VALUES ('13', '网球');
INSERT INTO `equipmenttype` VALUES ('14', '网球拍');

-- ----------------------------
-- Table structure for `financial`
-- ----------------------------
DROP TABLE IF EXISTS `financial`;
CREATE TABLE `financial` (
  `fId` int(8) NOT NULL AUTO_INCREMENT,
  `fOut` float(8,2) NOT NULL COMMENT '支出',
  `fIn` float(8,2) NOT NULL COMMENT '收入',
  `fInType` char(2) NOT NULL COMMENT '1-场地租用收入  2-器材租用收入',
  `date` datetime NOT NULL,
  `notes` varchar(255) NOT NULL,
  PRIMARY KEY (`fId`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of financial
-- ----------------------------
INSERT INTO `financial` VALUES ('1', '0.00', '13500.00', '0', '2013-01-03 20:26:24', '201011701207,场地27');
INSERT INTO `financial` VALUES ('2', '0.00', '2.70', '1', '2013-01-03 20:28:03', '201011701207,器材12');
INSERT INTO `financial` VALUES ('3', '0.00', '10.00', '1', '2013-01-04 11:27:09', '201011701212,器材1');
INSERT INTO `financial` VALUES ('4', '0.00', '26664.00', '0', '2013-01-04 14:51:33', '201011701207,场地28');
INSERT INTO `financial` VALUES ('5', '0.00', '10.00', '1', '2013-01-04 15:03:24', '201011701207,器材1');
INSERT INTO `financial` VALUES ('6', '0.00', '39996.00', '0', '2013-01-04 15:26:29', '201011701207,场地28');
INSERT INTO `financial` VALUES ('7', '0.00', '10.00', '1', '2013-01-04 16:07:48', '2010117,器材1');

-- ----------------------------
-- Table structure for `ground`
-- ----------------------------
DROP TABLE IF EXISTS `ground`;
CREATE TABLE `ground` (
  `gId` int(8) NOT NULL AUTO_INCREMENT,
  `gName` varchar(16) NOT NULL,
  `tId` varchar(16) NOT NULL,
  `gFee` float(8,2) NOT NULL,
  `gStatus` varchar(16) NOT NULL,
  `gRemark` varchar(32) NOT NULL,
  PRIMARY KEY (`gId`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of ground
-- ----------------------------
INSERT INTO `ground` VALUES ('1', '羽毛球1-1', '1', '100.00', '1', 'vip会员专用');
INSERT INTO `ground` VALUES ('2', '羽毛球1-2', '1', '100.00', '1', 'vip会员专用');
INSERT INTO `ground` VALUES ('3', '羽毛球1-3', '1', '100.00', '1', 'vip会员专用');
INSERT INTO `ground` VALUES ('4', '羽毛球2-1', '1', '60.00', '1', '六折优惠大酬宾');
INSERT INTO `ground` VALUES ('5', '羽毛球2-2', '1', '60.00', '1', '六折优惠大酬宾');
INSERT INTO `ground` VALUES ('6', '羽毛球2-3', '1', '60.00', '1', '六折优惠大酬宾');
INSERT INTO `ground` VALUES ('7', '羽毛球3-1', '1', '50.00', '1', '五折大优惠!!!');
INSERT INTO `ground` VALUES ('8', '篮球1-1', '2', '50.00', '1', '有灯光');
INSERT INTO `ground` VALUES ('9', '篮球1-2', '2', '40.00', '1', '无灯光');
INSERT INTO `ground` VALUES ('10', '兵乓球1-1', '3', '20.00', '1', '有围栏');
INSERT INTO `ground` VALUES ('11', '兵乓球1-2', '3', '20.00', '1', '有围栏');
INSERT INTO `ground` VALUES ('12', '兵乓球2-1', '3', '25.00', '1', '有围栏,配备风扇');
INSERT INTO `ground` VALUES ('13', '兵乓球2-2', '3', '25.00', '1', '有围栏,配备风扇');
INSERT INTO `ground` VALUES ('14', '排球1-1', '4', '40.00', '1', '专业排球场,全市最低价!');
INSERT INTO `ground` VALUES ('15', '排球1-2', '4', '40.00', '1', '专业排球场,全市最低价!');
INSERT INTO `ground` VALUES ('16', '游泳池1-1', '8', '5.00', '1', '每天换水,水深1.5-2m');
INSERT INTO `ground` VALUES ('17', '游泳池1-2', '8', '8.00', '1', '每周换水,水深2-3m,适合潜水!');
INSERT INTO `ground` VALUES ('18', '足球场1', '9', '500.00', '1', '省级标准足球场,活动大优惠,送球衣!');
INSERT INTO `ground` VALUES ('19', '足球场2', '9', '550.00', '1', '省级标准足球场,配备风扇,送球衣!');
INSERT INTO `ground` VALUES ('20', '举重1-1', '7', '30.00', '1', '男子85kg级别');
INSERT INTO `ground` VALUES ('21', '举重1-2', '7', '40.00', '1', '男子105kg级别');
INSERT INTO `ground` VALUES ('22', '举重2-1', '7', '30.00', '1', '女子75kg级别');
INSERT INTO `ground` VALUES ('23', '举重2-2', '7', '35.00', '1', '女子+75kg级别');
INSERT INTO `ground` VALUES ('24', '铁饼场1-1', '6', '150.00', '1', '有围栏');
INSERT INTO `ground` VALUES ('25', '铁饼场1-2', '6', '300.00', '1', '有围栏,配备专人记录距离。');
INSERT INTO `ground` VALUES ('26', '高尔夫1-1', '12', '1000.00', '1', '配置自助餐,五星级的享受!');
INSERT INTO `ground` VALUES ('27', '高尔夫1-2', '12', '1500.00', '1', '钻石级会员专用,配备专人捡球!');
INSERT INTO `ground` VALUES ('28', '11111111111', '13', '123.00', '0', '123123');

-- ----------------------------
-- Table structure for `groundbook`
-- ----------------------------
DROP TABLE IF EXISTS `groundbook`;
CREATE TABLE `groundbook` (
  `bId` int(8) NOT NULL AUTO_INCREMENT,
  `uId` char(16) NOT NULL,
  `gId` varchar(16) NOT NULL,
  `bDate` date NOT NULL,
  `bStartTime` datetime NOT NULL,
  `bEndTime` datetime NOT NULL,
  `bFee` float(8,2) NOT NULL,
  `bStatus` char(1) NOT NULL COMMENT '1=预定状态 2=使用中 3=已完成 0=已过期',
  PRIMARY KEY (`bId`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of groundbook
-- ----------------------------
INSERT INTO `groundbook` VALUES ('1', '201011701207', '27', '2013-01-03', '2013-01-04 08:00:00', '2013-01-04 17:00:00', '13500.00', '0');
INSERT INTO `groundbook` VALUES ('2', '201011701207', '28', '2013-01-04', '2013-01-22 08:00:00', '2013-01-23 08:00:00', '26664.00', '0');
INSERT INTO `groundbook` VALUES ('3', '201011701207', '28', '2013-01-04', '2013-01-23 08:00:00', '2013-01-24 20:00:00', '39996.00', '0');
INSERT INTO `groundbook` VALUES ('4', '2010117', '2', '2013-01-04', '2013-02-21 08:00:00', '2013-02-22 08:00:00', '2400.00', '1');
INSERT INTO `groundbook` VALUES ('5', '123', '4', '2013-01-04', '2014-01-01 08:00:00', '2015-01-01 08:00:00', '525600.00', '1');

-- ----------------------------
-- Table structure for `groundtype`
-- ----------------------------
DROP TABLE IF EXISTS `groundtype`;
CREATE TABLE `groundtype` (
  `tId` int(8) NOT NULL AUTO_INCREMENT,
  `tName` varchar(8) NOT NULL,
  PRIMARY KEY (`tId`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of groundtype
-- ----------------------------
INSERT INTO `groundtype` VALUES ('1', '羽毛球');
INSERT INTO `groundtype` VALUES ('2', '篮球');
INSERT INTO `groundtype` VALUES ('3', '乒乓球');
INSERT INTO `groundtype` VALUES ('4', '排球');
INSERT INTO `groundtype` VALUES ('5', '标枪');
INSERT INTO `groundtype` VALUES ('6', '铁饼');
INSERT INTO `groundtype` VALUES ('7', '举重');
INSERT INTO `groundtype` VALUES ('8', '游泳');
INSERT INTO `groundtype` VALUES ('9', '足球');
INSERT INTO `groundtype` VALUES ('10', '橄榄球');
INSERT INTO `groundtype` VALUES ('11', '田径');
INSERT INTO `groundtype` VALUES ('12', '高尔夫球场');
INSERT INTO `groundtype` VALUES ('13', '11111111');

-- ----------------------------
-- Table structure for `match`
-- ----------------------------
DROP TABLE IF EXISTS `match`;
CREATE TABLE `match` (
  `mId` int(8) NOT NULL AUTO_INCREMENT,
  `mName` varchar(50) NOT NULL,
  `text` text NOT NULL,
  `mDate` date NOT NULL,
  `aId` int(8) NOT NULL,
  `status` char(1) NOT NULL,
  PRIMARY KEY (`mId`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of match
-- ----------------------------
INSERT INTO `match` VALUES ('1', '第11届短池游泳世锦赛', '<p>\r\n	<span style=\"color:#000000;\"><span class=\"Apple-converted-space\"><span style=\"font-family:Microsoft YaHei;font-size:14px;\">&nbsp;&nbsp;&nbsp;&nbsp;</span><span style=\"font-family:Microsoft YaHei;font-size:14px;\">&nbsp;&nbsp;&nbsp;&nbsp;</span></span><span style=\"font-family:Microsoft YaHei;font-size:14px;\">12月作为一年中的最后一个月,是众多项目的收官之月。</span></span> \r\n</p>\r\n<p>\r\n	<span style=\"color:#000000;\"><span style=\"font-family:Microsoft YaHei;font-size:14px;\">&nbsp;&nbsp;&nbsp;&nbsp;</span><span style=\"font-family:Microsoft YaHei;font-size:14px;\">&nbsp;&nbsp;&nbsp;&nbsp;</span><span style=\"font-family:Microsoft YaHei;font-size:14px;\">本月最重要的赛事将是12月12日至16日在土耳其伊斯坦布尔举行的第11届短池游泳世锦赛,尽管是25米泳池,但争夺也十分激烈,中国泳军在经历了奥运会之后,谁会成为这里最闪耀的明星?</span></span> \r\n</p>\r\n<p>\r\n	<span style=\"color:#000000;\"><span style=\"font-family:Microsoft YaHei;font-size:14px;\"></span></span>&nbsp;\r\n</p>\r\n<p align=\"center\">\r\n	&nbsp;\r\n</p>\r\n<p align=\"center\">\r\n	<img alt=\"\" src=\"/GYM/upload/image/20130101/20130101215206_18.jpg\" /> \r\n</p>\r\n<p>\r\n	&nbsp;\r\n</p>\r\n<p>\r\n	&nbsp;\r\n</p>', '2013-01-01', '10000', '1');
INSERT INTO `match` VALUES ('2', '全国冬运会开始新年序章', '<p style=\"text-indent:0px;color:#000000;\">\r\n	<span style=\"font-family:Microsoft YaHei;font-size:14px;\">&nbsp;&nbsp;&nbsp;&nbsp;2012年是中国的龙年,更是体坛龙腾虎跃的一年。我们可以预言,在这样的年份里,人类的运动极限将再次遭遇挑战,</span><span><a href=\"http://www.china.com.cn/sport/txt/2012-01/05/content_24331416.htm#\" target=\"_blank\"><span style=\"font-family:Microsoft YaHei;font-size:14px;\">体育</span></a></span><span style=\"font-family:Microsoft YaHei;font-size:14px;\">迷的想象力可以更加狂野。那么,这一年究竟有哪些比赛值得我们期待?</span>\r\n</p>\r\n<p style=\"text-indent:0px;color:#000000;\">\r\n	<span style=\"font-family:Microsoft YaHei;font-size:14px;\">&nbsp;&nbsp;&nbsp;&nbsp;与往年一样,2012年的“开年大餐”绝不会单调。作为一项传统赛事,达喀尔拉力赛已在热情的南美拉开序幕,这是属于勇敢者的游戏,但也希望车手们能一路平安。</span>\r\n</p>\r\n<p style=\"text-indent:0px;color:#000000;\">\r\n	<span style=\"font-family:Microsoft YaHei;font-size:14px;\">&nbsp;&nbsp;&nbsp;&nbsp;在北半球的冰雪季节里,第12届全国冬运会揭开战幕,各路冰雪好手齐聚长春展开争夺。而全世界“好雪”的年轻人们则将在奥地利迎来首届冬季青奥会。</span>\r\n</p>\r\n<p style=\"text-indent:0px;color:#000000;\">\r\n	<span style=\"font-family:Microsoft YaHei;font-size:14px;\">&nbsp;&nbsp;&nbsp;&nbsp;同样在1月份,网球也将拉开漫长的赛季,先是各站巡回赛,随后开年的第一个大满贯——澳网将于16日至29日进行。去年李娜在法网上的折桂,激起了国人对于网球的关注,也希望新的一年娜姐能一改去年下半年的颓势,在新的一年再夺佳绩。</span>\r\n</p>\r\n<p style=\"text-indent:0px;color:#000000;\">\r\n	<span style=\"font-family:Microsoft YaHei;font-size:14px;\"></span>&nbsp;\r\n</p>\r\n<p style=\"text-indent:0px;color:#000000;\" align=\"center\">\r\n	<img alt=\"\" src=\"/GYM/upload/image/20130101/20130101215923_722.jpg\" />\r\n</p>\r\n<span style=\"font-family:Microsoft YaHei;font-size:14px;\"></span>', '2013-01-01', '10000', '1');
INSERT INTO `match` VALUES ('3', '跳水世界杯在伦敦上演', '<p style=\"text-indent:0px;color:#000000;\">\r\n	<span style=\"font-family:Microsoft YaHei;font-size:14px;\">&nbsp;&nbsp;&nbsp;&nbsp;对于中国跳水军团来说,2月下旬在伦敦举行的跳水世界杯将是伦敦奥运会前最重要的一次练兵。不过在已经拿到满额参赛席位的情况下,这支跳水梦之队可以轻松上阵来熟悉场地及竞争对手。</span>\r\n</p>\r\n<p style=\"text-indent:0px;color:#000000;\">\r\n	<span style=\"font-family:Microsoft YaHei;font-size:14px;\">&nbsp;&nbsp;&nbsp;&nbsp;149天停摆的阴霾已经成为过去,NBA在艰难中迎来了2011-2012赛季。在这样只有66场常规赛的缩水季,一切都变得与以往不同。虽然损失了几百场比赛,但幸运的是,赛季最终被保留了下来。更幸运的是,全明星赛最终被保留了下来。全世界的球迷依然能享受到NBA最顶尖的球星们带来的视觉大餐。</span>\r\n</p>\r\n<p style=\"text-indent:0px;color:#000000;\">\r\n	<span style=\"font-family:Microsoft YaHei;font-size:14px;\">&nbsp;&nbsp;&nbsp;&nbsp;此外,CBA全明星周末也将如期在广州举行,在CBA 联赛竞争水平和娱乐性都有了进一步提升的一年,相信众球星将为球迷朋友们带来一届更为精彩的全明星篮球盛宴。</span>\r\n</p>\r\n<p style=\"text-indent:0px;color:#000000;\">\r\n	&nbsp;\r\n</p>\r\n<p align=\"center\">\r\n	<img alt=\"\" src=\"/GYM/upload/image/20130101/20130101230512_262.jpg\" />\r\n</p>\r\n<p style=\"text-indent:0px;color:#000000;\">\r\n	&nbsp;\r\n</p>', '2013-01-01', '10000', '1');
INSERT INTO `match` VALUES ('4', '冰雪盛宴观众一饱眼福', '<p style=\"text-indent:0px;color:#000000;\">\r\n	<span style=\"font-family:Microsoft YaHei;\">&nbsp;&nbsp;&nbsp;&nbsp;被开除出国家队的冬奥会冠军王濛已经确定无缘全国冬运会,而能否现身上海参加短道速滑世锦赛,则依然是个未知数。作为中国当前“短道速滑第一人”,如果王濛无法及时回归国家队参加国际比赛,那么想要在2014年索契冬奥会卫冕冠军,将十分艰难。</span>\r\n</p>\r\n<p style=\"text-indent:0px;color:#000000;\">\r\n	<span style=\"font-family:Microsoft YaHei;\">&nbsp;&nbsp;&nbsp;&nbsp;除了短道速滑之外,3月份还将有一系列单项世锦赛值得人们期待。</span><span style=\"font-family:Microsoft YaHei;\">刘翔</span><span style=\"font-family:Microsoft YaHei;\">将第5次参加室内田径世锦赛的60米栏比赛。这是奥运前最后一次高手过招的机会,刘翔需要的是在这里争取信心。</span>\r\n</p>\r\n<p style=\"text-indent:0px;color:#000000;\">\r\n	&nbsp;\r\n</p>\r\n<p align=\"center\">\r\n	<img alt=\"\" src=\"/GYM/upload/image/20130102/20130102151850_828.jpg\" />\r\n</p>\r\n<p style=\"text-indent:0px;color:#000000;\">\r\n	&nbsp;\r\n</p>', '2013-01-02', '10000', '1');

-- ----------------------------
-- Table structure for `notice`
-- ----------------------------
DROP TABLE IF EXISTS `notice`;
CREATE TABLE `notice` (
  `nId` int(11) NOT NULL AUTO_INCREMENT,
  `nTitle` varchar(1000) NOT NULL,
  `nText` text NOT NULL,
  `nDate` datetime NOT NULL,
  `aId` int(11) NOT NULL,
  PRIMARY KEY (`nId`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of notice
-- ----------------------------
INSERT INTO `notice` VALUES ('1', ' 广东海洋大学体育馆网上系统即将发布,敬请期待!', '<p>\r\n	&nbsp;广东海洋大学体育馆网上系统即将发布,敬请期待!\r\n</p>\r\n<p>\r\n	&nbsp;\r\n</p>\r\n<img alt=\"\" src=\"/GYM/upload/image/20130103/20130103192451_840.jpg\" /> \r\n<p>\r\n	&nbsp;\r\n</p>', '2013-01-03 19:24:56', '1000');
INSERT INTO `notice` VALUES ('2', '关于如何使用本系统', '<h3 id=\"row_1\">\r\n	<span style=\"color:#e53333;\">如何预约场地</span>\r\n</h3>\r\n<div>\r\n	<span style=\"color:#e56600;\">1.点击场地预订导航栏;</span>\r\n</div>\r\n<div>\r\n	<span style=\"color:#e56600;\">2.选择自己需要预定的场地,然后后点击其后面的“预定”;</span>\r\n</div>\r\n<div>\r\n	<span style=\"color:#e56600;\">3.选择需要预定的起止时间,点击提交。</span>\r\n</div>\r\n<div>\r\n	&nbsp;\r\n</div>\r\n<h3>\r\n	<span style=\"color:#e53333;\">如何租借器材</span>\r\n</h3>\r\n<div>\r\n	<span style=\"color:#e56600;\">1.点击器材租借导航栏;</span>\r\n</div>\r\n<div>\r\n	<span style=\"color:#e56600;\">2.选择自己需要租借的器材,然后点击其后面的“租借”;</span>\r\n</div>\r\n<div>\r\n	<span style=\"color:#e56600;\">3.选择需要租借的起止时间,点击提交。</span>\r\n</div>\r\n<div>\r\n	&nbsp;\r\n</div>\r\n<h3>\r\n	<span style=\"color:#e53333;\">惩罚措施</span>\r\n</h3>\r\n<div>\r\n	<span style=\"color:#e56600;\">1.如果预约场地失约(即预约了没有在预约时间内到场使用),则需要缴清预约费用,并加收10%违约金。</span>\r\n</div>\r\n<div>\r\n	<span style=\"color:#e56600;\">2.如果失约没有缴清预约费用和违约金,则账户会被冻结,无法继续使用此系统,并且毕业后由学校统一补收。</span>\r\n</div>', '2013-01-03 19:35:19', '1000');
INSERT INTO `notice` VALUES ('3', '冬季运动会', '冬季运动会', '2013-01-04 11:07:13', '1000');
INSERT INTO `notice` VALUES ('5', '广东海洋大学第十二届田径运动会圆满落幕', '<div align=\"left\">\r\n	&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2011年12月11日上午,广东海洋大学第十二届田径运动会顺利完成了各项比赛任务,圆满地落下了帷幕。闭幕式在东区体育场隆重举行。广东海洋大学何真校长、校党委张兰英副书记,陈泽球副校长和叶春海副校长等人出席了闭幕式。\r\n</div>\r\n<div align=\"left\">\r\n	11时30分,闭幕式正式开始,闭幕式由校党委张兰英副书记主持。运动员、裁判员入场仪式首先进行,各学院代表队缓缓步入会场,他们整齐有序,有的在欢呼雀跃,有的在高喊口号,意气风发。\r\n</div>\r\n<div align=\"left\">\r\n	&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 随后,由本届运动会总裁判长宣布比赛成绩,教工组中,体育与休闲学院以总分136分夺得团体总分冠军,行政机关和后勤公会分别以111分和87分获得第二名和第三名,学生组中,获得团体总分冠军的分别是职业技术学院和经管学院,获得亚军的是体育与休闲学院和航海学院,获得季军的是寸金学院。另外,外国语学院和理学院获得学生体育道德风尚奖,中歌艺术学院和职业技术学院则获得学生最佳组织奖。在之后的颁奖仪式上,学<a class=\"keylink\" href=\"http://210.38.137.115/dbz/xxld/hd_ld.html\" target=\"_blank\">校领导</a>为颁奖单位颁发奖牌和锦旗并合影留念。\r\n</div>\r\n<div align=\"left\">\r\n	&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 据悉,本次校运会是历届校运会中气温最低,天气最寒冷的一次校运会,尽管如此,比赛场上的运动员们却并没被寒冷所吓倒,他们挺着昂扬的斗志,带着永不熄灭的激情,创下一个又一个佳绩。本届运动会也刷新了5项校运会记录,成绩喜人。\r\n</div>\r\n<div align=\"left\">\r\n	过后,广东海洋大学学校体育运动委员会主任叶春海副校长致闭幕词,叶春海副校长首先对全体裁判员、运动员以及老师和同学表示衷心的感谢,他指出,虽然只有短短的2天半时间,但海大人\"坚韧不拔,自强不息\"的精神得到充分的彰显,他希望全体师生能够更加注重体育锻炼,以更强健的体魄、更饱满的精神状态投入到今后的学习、工作、生活当中去,创造更加辉煌的成绩。最后,何真校长宣布,广东海洋大学第十二届校运动会胜利闭幕。\r\n</div>\r\n<div align=\"left\">\r\n	校运会的召开,是海大全体师生以实际行动彰显运动精神的体现,让我们共同期待校运会取得更加丰硕的成果。\r\n</div>', '2013-01-04 11:26:44', '1000');
INSERT INTO `notice` VALUES ('6', '广东海洋大学第八届校运会开幕', '<p align=\"left\">\r\n	<b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;碧海银沙网讯</b>(图/<b>伍静文</b> 文/<b>何永聪</b> 编辑/<b>皓 雪</b>)广东海洋大学第八届校运会开幕式于12月13日上午八点在东区体育场简单而隆重举行。开幕式上由红旗手,鲜花队,裁判队,教职工队的带领下,各院的方队纷纷亮相,何真校长主持升旗仪式,并由运动员代表,裁判员代表宣誓。\r\n</p>\r\n<p align=\"center\">\r\n	<img alt=\"\" src=\"/GYM/upload/image/20130104/20130104112937_652.jpg\" /> \r\n	<div align=\"left\">\r\n		&nbsp;\r\n	</div>\r\n	<p>\r\n		<br />\r\n	</p>\r\n	<p align=\"left\">\r\n		<br />\r\n	</p>', '2013-01-04 11:30:04', '1000');

-- ----------------------------
-- Table structure for `user`
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `uId` varchar(16) NOT NULL,
  `uName` varchar(16) NOT NULL,
  `uPassword` varchar(32) NOT NULL,
  `uEmail` varchar(32) NOT NULL,
  `uIdCard` varchar(20) NOT NULL,
  `uPhone` varchar(11) NOT NULL,
  `date` datetime NOT NULL,
  `status` char(1) NOT NULL,
  PRIMARY KEY (`uId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('110', '兔斯基', '202cb962ac59075b964b07152d234b70', 'DFFSFJS', '123', '1234567', '2013-01-04 10:39:17', '0');
INSERT INTO `user` VALUES ('111111', '大大', '698d51a19d8a121ce581499d7b701668', 'dadw@wqq.com', '111', '111', '2013-01-04 11:20:45', '0');
INSERT INTO `user` VALUES ('123', '兔斯基', '202cb962ac59075b964b07152d234b70', 'fdjgjuj@sohu.com', '44920283828929', '1382947294', '2013-01-04 10:40:09', '1');
INSERT INTO `user` VALUES ('1234', '123', '202cb962ac59075b964b07152d234b70', '123', '123', '123', '2013-01-04 10:45:04', '1');
INSERT INTO `user` VALUES ('2010117', 'sdadad', '698d51a19d8a121ce581499d7b701668', 'asdada@qq.com', 'adanjd', '13763001538', '2013-01-04 15:08:26', '1');
INSERT INTO `user` VALUES ('201011700000', '剑锋', '0e4ff8ad66ec4f08e101ac9b28bc805d', '1421560459@qq.com', '400000000000000000', '13000000000', '2013-02-03 21:12:20', '1');
INSERT INTO `user` VALUES ('201011701207', '剑锋', '202cb962ac59075b964b071ff8234b70', '450000000@qq.com', '441333333333333333', '13763088888', '2013-01-03 20:17:52', '1');
INSERT INTO `user` VALUES ('201011701211', '黄萌', '96e7921ff85eb72c92a549dd5a330112', '111@qq.com', '111111111111111', '1111111111', '2013-01-04 11:15:09', '1');
INSERT INTO `user` VALUES ('201011701212', '黄明的', '698d51a19d8a121ce581ff8d7b701668', 'dadawd@qq.com', '111', '111', '2013-01-04 11:25:17', '1');
INSERT INTO `user` VALUES ('222', 'fdgssrd', '47bce5c74f58ff8867dbd57e9ca9f808', 'sergserg@sohu.com', '32455554534', '112312', '2013-01-04 15:06:56', '1');

-- ----------------------------
-- View structure for `equipmentview`
-- ----------------------------
DROP VIEW IF EXISTS `equipmentview`;
CREATE VIEW `equipmentview` AS select `equipment`.`eId` AS `eId`,`equipment`.`eTypeId` AS `eTypeId`,`equipment`.`buyDate` AS `buyDate`,`equipment`.`buyCost` AS `buyCost`,`equipment`.`eFee` AS `eFee`,`equipment`.`status` AS `status`,`equipment`.`borrowCount` AS `borrowCount`,`equipmenttype`.`eTypeId` AS `eTypeId2`,`equipmenttype`.`eTypeName` AS `eTypeName` from (`equipment` join `equipmenttype`) where (`equipment`.`eTypeId` = `equipmenttype`.`eTypeId`) ;

-- ----------------------------
-- View structure for `groundview`
-- ----------------------------
DROP VIEW IF EXISTS `groundview`;
CREATE  VIEW `groundview` AS select `ground`.`gId` AS `gId`,`ground`.`gName` AS `gName`,`ground`.`tId` AS `tId`,`ground`.`gFee` AS `gFee`,`ground`.`gStatus` AS `gStatus`,`ground`.`gRemark` AS `gRemark`,`groundtype`.`tId` AS `tId2`,`groundtype`.`tName` AS `tName` from (`ground` join `groundtype`) where (`ground`.`tId` = `groundtype`.`tId`) ;

[代码运行效果截图]


广东海洋大学体育馆管理系统 数据库脚本


网友评论    (发表评论)

共8 条评论 1/1页

发表评论:

评论须知:

  • 1、评论每次加2分,每天上限为30;
  • 2、请文明用语,共同创建干净的技术交流环境;
  • 3、若被发现提交非法信息,评论将会被删除,并且给予扣分处理,严重者给予封号处理;
  • 4、请勿发布广告信息或其他无关评论,否则将会删除评论并扣分,严重者给予封号处理。


扫码下载

加载中,请稍后...

输入口令后可复制整站源码

加载中,请稍后...