calendar-zhaiqing.sql

来自「一个带数据库的日历记事本,可以实现查询、保存和修改功能」· SQL 代码 · 共 35 行

/*
SQLyog Community Edition- MySQL GUI v6.05
Host - 5.0.15-nt : Database - calender
*********************************************************************
Server version : 5.0.15-nt
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

create database if not exists `calender`;

USE `calender`;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*Table structure for table `calendar` */

DROP TABLE IF EXISTS `calendar`;

CREATE TABLE `calendar` (
  `date` date NOT NULL,
  `event` varchar(100) default NULL,
  PRIMARY KEY  (`date`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `calendar` */

insert  into `calendar`(`date`,`event`) values ('2009-01-01','Happy new year'),('2009-02-13','I finish my calendar this night.\nThank everybady\'s help.'),('2009-02-14','valentine\'s day\nPart time job from 18:00 to 2:00'),('2009-02-17','The exams'),('2009-02-18','The exam of network at 14:00'),('2009-02-19','It is time to finish the calendar.'),('2009-02-20','Part time job from 18:00 to 2:00'),('2009-02-21','Part time job from 18:00 to 2:00'),('2009-03-18','End of the java lessons'),('2009-03-27','2,20'),('2009-03-28','Happy my brithday!'),('2009-04-01','April Fools\' Day');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;