library.sql

来自「一个用java开发的具有搜索功能的图书管理系统」· SQL 代码 · 共 129 行 · 第 1/5 页

CREATE TABLE `administrator` (
  `administratorName` varchar(50) NOT NULL,
  `password` varchar(50) default NULL,
  `loginDate` datetime default NULL,
  `lastestDate` datetime default NULL,
  PRIMARY KEY  (`administratorName`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

#
# Dumping data for table administrator
#

INSERT INTO `administrator` VALUES ('123456','123456','2007-06-21 00:00:00',NULL);
INSERT INTO `administrator` VALUES ('3104006491','3104006491','2007-06-21 00:00:00',NULL);
INSERT INTO `administrator` VALUES ('admin','admin','2007-06-19 09:17:14','2007-06-19 09:17:14');
INSERT INTO `administrator` VALUES ('bcvnbcv','nb','2007-06-21 00:00:00',NULL);
INSERT INTO `administrator` VALUES ('bcxvbvcx','10','2007-06-21 00:00:00',NULL);
INSERT INTO `administrator` VALUES ('bmbnmvbty','78','2007-06-21 00:00:00',NULL);
INSERT INTO `administrator` VALUES ('ewqggnbvc','36','2007-06-21 00:00:00',NULL);
INSERT INTO `administrator` VALUES ('fdsavcxz','1234','2007-06-21 00:00:00',NULL);
INSERT INTO `administrator` VALUES ('gfdfdsaf','123','2007-06-21 00:00:00',NULL);
INSERT INTO `administrator` VALUES ('hgnbvcn','123','2007-06-21 00:00:00',NULL);
INSERT INTO `administrator` VALUES ('ioueyt','ab','2007-06-21 00:00:00',NULL);
INSERT INTO `administrator` VALUES ('jghjhgfj','321','2007-06-21 00:00:00',NULL);
INSERT INTO `administrator` VALUES ('jhjhjhg','47','2007-06-21 00:00:00',NULL);