textbook-management-system/基于PHP的教材管理系统/jc.sql

-- phpMyAdmin SQL Dump
-- version 2.9.2-rc1
-- http://www.phpmyadmin.net
-- 
-- 主机: localhost
-- 生æˆ<C3A6>日期: 2008 å¹´ 04 月 21 æ—¥ 05:49
-- æœ<C3A6>务器版本: 5.0.27
-- PHP 版本: 5.2.1
-- 
-- æ•°æ<C2B0>®åº“: `jc`
-- 

-- --------------------------------------------------------

-- 
-- 表的结构 `admin`
-- 

CREATE TABLE "admin" (
  "name" varchar(20) NOT NULL COMMENT '¹ÜÀíÔ±ÐÕÃû',
  "user_name" varchar(50) NOT NULL COMMENT 'µÇ¼Ãû',
  "password" varchar(20) NOT NULL COMMENT 'ÃÜÂë',
  PRIMARY KEY  ("user_name"),
  FULLTEXT KEY "name" ("name")
);

-- 
-- 导出表中的数æ<C2B0>® `admin`
-- 

INSERT INTO `admin` (`name`, `user_name`, `password`) VALUES 
('¹ÜÀíÔ±', 'admin', 'admin');

-- --------------------------------------------------------

-- 
-- 表的结构 `fafang`
-- 

CREATE TABLE "fafang" (
  "shijian" varchar(50) NOT NULL COMMENT 'ʱ',
  "lsren" varchar(30) NOT NULL COMMENT 'ÁìÊéÈË',
  "ssbanji" varchar(30) NOT NULL COMMENT 'ËùÊô°à¼¶',
  "suliang" float NOT NULL,
  "jcbianhao" varchar(50) NOT NULL,
  PRIMARY KEY  ("jcbianhao")
);

-- 
-- 导出表中的数æ<C2B0>® `fafang`
-- 

INSERT INTO `fafang` (`shijian`, `lsren`, `ssbanji`, `suliang`, `jcbianhao`) VALUES 
('1208755948', '5', '5', 1, '1'),
('1208755969', '41', '2', 1, '999'),
('1208756045', '45', '45', 1, '4236546'),
('1208756056', '455', '4555', 0, '42387777');

-- --------------------------------------------------------

-- 
-- 表的结构 `jiaocai`
-- 

CREATE TABLE "jiaocai" (
  "jcbianhao" varchar(50) NOT NULL,
  "jcming" varchar(50) NOT NULL,
  "zuozhe" varchar(50) NOT NULL,
  "cbshe" varchar(50) NOT NULL,
  "banben" varchar(50) NOT NULL,
  PRIMARY KEY  ("jcbianhao")
);

-- 
-- 导出表中的数æ<C2B0>® `jiaocai`
-- 

INSERT INTO `jiaocai` (`jcbianhao`, `jcming`, `zuozhe`, `cbshe`, `banben`) VALUES 
('0023', 'Êýѧ', 'Ã<EFBFBD>¡Ã÷', 'Ç廪´óѧ', 'µÚÒ»°æ'),
('1124', '4242', '42', '42', '42'),
('423', '24', '242', '424', '42'),
('424', '24', '242', '424', '242'),
('4564', '456', '45', '456', '456456'),
('54645645', '¶á', '45', '456', '456');

-- --------------------------------------------------------

-- 
-- 表的结构 `laoshi`
-- 

CREATE TABLE "laoshi" (
  "jiaoshihao" varchar(20) NOT NULL COMMENT '½ÌʦºÅ',
  "xingming" varchar(20) NOT NULL COMMENT 'ÐÕÃû',
  "xi" varchar(20) NOT NULL COMMENT 'ϵºÅ',
  "user_name" varchar(50) NOT NULL COMMENT 'µÇ¼Ãû',
  "password" varchar(20) NOT NULL COMMENT 'ÃÜÂë',
  PRIMARY KEY  ("jiaoshihao")
);

-- 
-- 导出表中的数æ<C2B0>® `laoshi`
-- 

INSERT INTO `laoshi` (`jiaoshihao`, `xingming`, `xi`, `user_name`, `password`) VALUES 
('001', '½Ìʦ', '¼ÆËã»ú', 'laoshi', 'laoshi');

-- --------------------------------------------------------

-- 
-- 表的结构 `ruku`
-- 

CREATE TABLE "ruku" (
  "jcbianhao" varchar(50) NOT NULL COMMENT '½Ì²Ä±àºÅ',
  "jcming" varchar(50) NOT NULL COMMENT '½Ì²ÄÃû',
  "zuozhe" varchar(30) NOT NULL COMMENT '×÷Õß',
  "cbshe" varchar(50) NOT NULL COMMENT '³ö°æÉç',
  "banben" varchar(20) NOT NULL COMMENT '°æ±¾ºÅ',
  "scjia" float NOT NULL COMMENT 'Êг¡¼Û',
  "sgjia" float NOT NULL COMMENT 'ʵ¹º¼Û',
  "suliang" int(10) NOT NULL COMMENT 'ÊýÁ¿',
  "rukushijian" text NOT NULL,
  PRIMARY KEY  ("jcbianhao")
);

-- 
-- 导出表中的数æ<C2B0>® `ruku`
-- 

INSERT INTO `ruku` (`jcbianhao`, `jcming`, `zuozhe`, `cbshe`, `banben`, `scjia`, `sgjia`, `suliang`, `rukushijian`) VALUES 
('1', '1', '1', '1', '1', 1, 1, 1, '1'),
('999', '9612', '5415', '121', '222', 12, 121, 121, '2'),
('4236546', '24', '242', '424', '42', 455, 54, 585, '1208755827'),
('423', '24', '242', '424', '42', 4, 4, 4, '1208756112');

-- --------------------------------------------------------

-- 
-- 表的结构 `xi`
-- 

CREATE TABLE "xi" (
  "xingming" varchar(20) NOT NULL COMMENT 'ϵ¹ÜÀíÈËÐÕÃû',
  "xi" varchar(20) NOT NULL COMMENT 'ϵºÅ',
  "user_name" varchar(50) NOT NULL COMMENT 'µÇ¼Ãû',
  "password" varchar(20) NOT NULL COMMENT 'ÃÜÂë',
  PRIMARY KEY  ("user_name")
);

-- 
-- 导出表中的数æ<C2B0>® `xi`
-- 

INSERT INTO `xi` (`xingming`, `xi`, `user_name`, `password`) VALUES 
('系级管ç<EFBFBD>†äººå‘˜', '计算机', 'xi', 'xi');

-- --------------------------------------------------------

-- 
-- 表的结构 `xushen`
-- 

CREATE TABLE "xushen" (
  "xuehao" varchar(20) NOT NULL COMMENT 'ѧºÅ',
  "xingming" varchar(20) NOT NULL COMMENT 'ÐÕÃû',
  "banji" varchar(20) NOT NULL COMMENT '°à¼¶',
  "xi" varchar(20) NOT NULL COMMENT 'ϵºÅ',
  "user_name" varchar(50) NOT NULL COMMENT 'µÇ¼Ãû',
  "password" varchar(20) NOT NULL COMMENT 'ÃÜÂë',
  PRIMARY KEY  ("xuehao")
);

-- 
-- 导出表中的数æ<C2B0>® `xushen`
-- 

INSERT INTO `xushen` (`xuehao`, `xingming`, `banji`, `xi`, `user_name`, `password`) VALUES 
('001', 'ѧÉú', '¼ÆËã»úÃ<EFBFBD>øÂç', '¼ÆËã»úÃ<EFBFBD>µ', 'xueshen', 'xueshen');

-- --------------------------------------------------------

-- 
-- 表的结构 `zhengding`
-- 

CREATE TABLE "zhengding" (
  "dingdan" varchar(30) NOT NULL COMMENT '¶©µ¥ºÅ',
  "jcbianhao" varchar(30) NOT NULL COMMENT '½Ì²Ä±àºÅ',
  "jcming" varchar(50) NOT NULL COMMENT '½Ì²ÄÃû',
  "zuozhe" varchar(50) NOT NULL COMMENT '×÷Õß',
  "cbshe" varchar(50) NOT NULL COMMENT '³ö°æÉç',
  "banben" varchar(20) NOT NULL COMMENT '°æ±¾ºÅ',
  "shijian" varchar(50) NOT NULL,
  "zdren" varchar(30) NOT NULL COMMENT 'Õ÷¶©ÈË',
  "szbanji" varchar(30) NOT NULL COMMENT 'Ëù¶©°à¼¶',
  "zdshuliang" int(10) NOT NULL COMMENT 'Õ÷¶©ÊýÁ¿',
  PRIMARY KEY  ("dingdan")
);

-- 
-- 导出表中的数æ<C2B0>® `zhengding`
-- 

INSERT INTO `zhengding` (`dingdan`, `jcbianhao`, `jcming`, `zuozhe`, `cbshe`, `banben`, `shijian`, `zdren`, `szbanji`, `zdshuliang`) VALUES 
('990', '0023', 'Êýѧ', 'Ã<EFBFBD>¡Ã÷', 'Ç廪´óѧ', 'µÚÒ»°æ', '20080420', 'Ã<EFBFBD>¡Ã÷', '¼ÆËã»ú', 10),
('666', '423', '24', '242', '424', '42', '666', '555', '555', 555);