database.sql

jwp是 JSP WebProject的简写。它是一个基于Web的应用程序。它编写的方式是JSP/Java+Mysql.主要的功能是管理项目、任务、命令、用户、报告、文档。这个程序对学生管理自己的程序

# MySQL-Front Dump 2.5
#
# Host: localhost   Database: seminar
# --------------------------------------------------------
# Server version 4.0.12-max-debug


#
# Table structure for table 'demands'
#

DROP TABLE IF EXISTS demands;
CREATE TABLE demands (
  LfdNr int(11) unsigned NOT NULL auto_increment,
  Project int(11) unsigned NOT NULL default '0',
  Description varchar(255) NOT NULL default '',
  Comment longtext,
  PRIMARY KEY  (LfdNr),
  UNIQUE KEY LfdNr (LfdNr),
  KEY LfdNr_2 (LfdNr)
) TYPE=MyISAM;


#
# Table structure for table 'documents'
#

DROP TABLE IF EXISTS documents;
CREATE TABLE documents (
  LfdNr int(11) unsigned NOT NULL auto_increment,
  Project int(11) unsigned NOT NULL default '0',
  Filename varchar(255) default NULL,
  Date date default '0000-00-00',
  Description varchar(255) default NULL,
  Comment longtext,
  Mime varchar(255) NOT NULL default '',
  Document blob,
  PRIMARY KEY  (LfdNr),
  UNIQUE KEY LfdNr (LfdNr),
  KEY LfdNr_2 (LfdNr)
) TYPE=MyISAM;

#
# Table structure for table 'members'
#

DROP TABLE IF EXISTS members;
CREATE TABLE members (
  LfdNr int(11) unsigned NOT NULL auto_increment,
  Project int(11) unsigned NOT NULL default '0',
  Member int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (LfdNr),
  UNIQUE KEY LfdNr (LfdNr),
  KEY LfdNr_2 (LfdNr)
) TYPE=MyISAM;


#
# Table structure for table 'milestones'
#

DROP TABLE IF EXISTS milestones;
CREATE TABLE milestones (
  LfdNr int(11) unsigned NOT NULL auto_increment,
  Project int(11) unsigned NOT NULL default '0',
  Date date default NULL,
  Description varchar(255) NOT NULL default '',
  Comment longtext,
  PRIMARY KEY  (LfdNr),
  UNIQUE KEY LfdNr (LfdNr),
  KEY LfdNr_2 (LfdNr)
) TYPE=MyISAM;


#
# Table structure for table 'project'
#

DROP TABLE IF EXISTS project;
CREATE TABLE project (
  LfdNr int(11) unsigned NOT NULL auto_increment,
  Name varchar(255) NOT NULL default '0',
  Organisation varchar(255) default '0',
  Description longtext,
  Manager int(11) unsigned NOT NULL default '0',
  CurrentSituation longtext,
  Target longtext,
  PRIMARY KEY  (LfdNr),
  UNIQUE KEY LfdNr (LfdNr),
  KEY LfdNr_2 (LfdNr)
) TYPE=MyISAM;


#
# Table structure for table 'reports'
#

DROP TABLE IF EXISTS reports;
CREATE TABLE reports (
  LfdNr int(11) unsigned NOT NULL auto_increment,
  Project int(11) unsigned NOT NULL default '0',
  Startdate date default '0000-00-00',
  Enddate date default '0000-00-00',
  Status varchar(255) default '0',
  Step tinyint(3) unsigned default '0',
  Phase varchar(255) default '0',
  Degree tinyint(3) unsigned default '0',
  Events longtext,
  PlannedEvents longtext,
  Risks longtext,
  Decision longtext,
  User int(11) unsigned NOT NULL default '0',
  Date date NOT NULL default '0000-00-00',
  PRIMARY KEY  (LfdNr),
  UNIQUE KEY LfdNr (LfdNr),
  KEY LfdNr_2 (LfdNr)
) TYPE=MyISAM;


#
# Table structure for table 'task'
#

DROP TABLE IF EXISTS task;
CREATE TABLE task (
  LfdNr int(11) unsigned NOT NULL auto_increment,
  Description varchar(255) NOT NULL default '0',
  Comment longtext,
  Duration tinyint(3) unsigned default '0',
  Status tinyint(3) unsigned default '0',
  Prio varchar(255) default '0',
  Start date default NULL,
  End date default NULL,
  Creator tinyint(3) unsigned NOT NULL default '0',
  Responsible tinyint(3) unsigned NOT NULL default '0',
  Project int(11) unsigned NOT NULL default '0',
  Parent int(11) unsigned default '0',
  PRIMARY KEY  (LfdNr),
  UNIQUE KEY LfdNr (LfdNr),
  KEY LfdNr_2 (LfdNr)
) TYPE=MyISAM;


#
# Table structure for table 'user'
#

DROP TABLE IF EXISTS user;
CREATE TABLE user (
  LfdNr int(11) unsigned NOT NULL auto_increment,
  First varchar(255) NOT NULL default '0',
  Last varchar(255) NOT NULL default '0',
  Username varchar(255) NOT NULL default '0',
  Password varchar(255) NOT NULL default '0',
  Category varchar(255) default NULL,
  Phone varchar(255) default '0',
  eMail varchar(255) default '0',
  Fax varchar(255) default '0',
  PRIMARY KEY  (LfdNr),
  UNIQUE KEY LfdNr (LfdNr),
  KEY LfdNr_2 (LfdNr)
) TYPE=MyISAM;



#
# Dumping data for table 'user'
#

INSERT INTO user VALUES("1", "Admin", "Istrator", "admin", "admin", "Administrator", "0", "root@localhost", "0");