mysql.txt

jsp全部邮件系统 jsp全部邮件系统

CREATE DATABASE fastmail;
use fastmail;

CREATE TABLE alias (
  userid varchar(20) DEFAULT '' NOT NULL,
  alias varchar(100) DEFAULT '' NOT NULL,
  alias_userid varchar(20) DEFAULT '' NOT NULL,
  alias_host varchar(100) DEFAULT '' NOT NULL,
  KEY userid (userid),
  KEY alias (alias),
  UNIQUE user_alias (userid,alias,alias_userid,alias_host)
);

INSERT INTO alias VALUES( 'alias', 'root', 'admin', '');
INSERT INTO alias VALUES( 'alias', 'postmaster', '.', '/Maildir/');
INSERT INTO alias VALUES( 'alias', 'mailer-daemon', '/', ' home/mail/mdaemon');

CREATE TABLE mailbox (
  userid varchar(20) DEFAULT '' NOT NULL,
  uid mediumint(9) DEFAULT '333' NOT NULL,
  gid mediumint(9) DEFAULT '333' NOT NULL,
  home varchar(100) DEFAULT '' NOT NULL,
  password varchar(16) DEFAULT '' NOT NULL,
  quota int(10) DEFAULT '5000' NOT NULL,
  PRIMARY KEY (userid),
  UNIQUE home (home),
  KEY password (password)
);

INSERT INTO mailbox VALUES( 'admin', '333', '333', '/home/mail/', '43e9a4ab75570f5b', '5000');

CREATE TABLE rcpthosts (
  host varchar(100) DEFAULT '' NOT NULL,
  PRIMARY KEY (host)
);

CREATE TABLE virtual (
  userid varchar(20) DEFAULT '' NOT NULL,
  ext varchar(100) DEFAULT '' NOT NULL,
  virtual_userid varchar(20) DEFAULT '' NOT NULL,
  virtual_host varchar(100) DEFAULT '' NOT NULL,
  PRIMARY KEY (virtual_userid,virtual_host),
  KEY (virtual_userid),
  KEY (virtual_host),
  UNIQUE virtual (userid,ext,virtual_userid,virtual_host)
);

CREATE TABLE folderlist (
  userid varchar(20) DEFAULT '' NOT NULL,
  folderindex int DEFAULT 0 NOT NULL,
  folderid varchar(100) DEFAULT '' NOT NULL,
  foldername varchar(20) DEFAULT '' NOT NULL,
  type tinyint	DEFAULT 0 NOT NULL
);
INSERT INTO folderlist VALUES( 'admin', '30000', 'src', '草稿箱', '0');
INSERT INTO folderlist VALUES( 'admin', '20000', 'snt', '发件箱', '0');
INSERT INTO folderlist VALUES( 'admin', '40000', 'dsb', '垃圾箱', '0');
INSERT INTO folderlist VALUES( 'admin', '10000', 'rev', '收件箱', '0');

CREATE TABLE address (
   id int(11) NOT NULL auto_increment,
   regdate datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
   userid varchar(20) NOT NULL,
   username varchar(50) NOT NULL,
   gender char(2),
   location varchar(100),
   zipcode varchar(50),
   phone varchar(50),
   bpcode varchar(50),
   handset varchar(50),
   email varchar(50),
   homepage varchar(50),
   birthday date,
   PRIMARY KEY (id),
   UNIQUE id (id)
);
CREATE TABLE admin (
   userid varchar(20) NOT NULL,
   password varchar(20) NOT NULL,
   username varchar(20) NOT NULL,
   PRIMARY KEY (userid),
   UNIQUE userid (userid)
);
INSERT INTO admin VALUES( 'admin', '43e9a4ab75570f5b', 'Fastmail默认管理者');
CREATE TABLE profile (
   userid varchar(20) NOT NULL,
   username varchar(50) NOT NULL,
   gender tinyint(4) NOT NULL,
   location varchar(100),
   zipcode varchar(50),
   signature varchar(250),
   regdate datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
   certificateType tinyint(4),
   cardNumber varchar(20),
   birthday date DEFAULT '0000-00-00',
   province tinyint(4),
   education tinyint(4),
   occupation tinyint(4),
   phone varchar(50),
   signup char(1) DEFAULT 'Y',
   PRIMARY KEY (userid),
   UNIQUE userid (userid)
);
INSERT INTO profile VALUES( 'admin', 'Fastmail默认管理者', '0', '', '610054', '', NOW(), '1', '888888888888888888', '2000-05-08', '21', '4', '8', 'Y','');