mysql_scheme.sql

来自「一个用Java开发的Web邮局」· SQL 代码 · 共 105 行

# WebMail CVS ID: $Id: mysql_scheme.sql,v 1.1.1.1 2000/02/01 12:01:29 wastl Exp $

# MySQL dump 6.6
#
# Host: localhost    Database: webmail
#--------------------------------------------------------
# Server version	3.22.29-log

CREATE DATABASE webmail;
USE webmail;

#
# Table structure for table 'mailhosts'
#
CREATE TABLE mailhosts (
  id int(11) DEFAULT '0' NOT NULL auto_increment,
  host char(80) DEFAULT '' NOT NULL,
  login char(10) DEFAULT '' NOT NULL,
  password char(10) DEFAULT '' NOT NULL,
  name char(60) DEFAULT '' NOT NULL,
  PRIMARY KEY (id)
);

#
# Table structure for table 'sysconf'
#
CREATE TABLE sysconf (
  id int(11) DEFAULT '0' NOT NULL auto_increment,
  param varchar(20) DEFAULT '' NOT NULL,
  value text,
  PRIMARY KEY (id)
);

#
# Table structure for table 'userdata'
#
CREATE TABLE userdata (
  id int(11) DEFAULT '0' NOT NULL auto_increment,
  full_name varchar(60),
  email varchar(80) DEFAULT '' NOT NULL,
  signature text,
  first_login datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
  last_login datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
  count_login int(11),
  sent_folder varchar(80),
  locale varchar(10),
  msg_per_page int(11),
  flag_savesent enum('Y','N'),
  flag_setflags enum('Y','N'),
  flag_showfancy enum('Y','N'),
  flag_showimages enum('Y','N'),
  PRIMARY KEY (id)
);

#
# Table structure for table 'users'
#
CREATE TABLE users (
  id int(11) DEFAULT '0' NOT NULL auto_increment,
  login char(10) DEFAULT '' NOT NULL,
  password char(14) DEFAULT '' NOT NULL,
  domain int(11),
  PRIMARY KEY (id),
  KEY idx_user (login)
);

#
# Table structure for table 'users2mailhosts'
#
CREATE TABLE users2mailhosts (
  id int(11) DEFAULT '0' NOT NULL auto_increment,
  r_user int(11) DEFAULT '0' NOT NULL,
  r_host int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (id),
  KEY idx_user (r_user),
  KEY idx_host (r_host)
);

#
# Table structure for table 'users2userdata'
#
CREATE TABLE users2userdata (
  id int(11) DEFAULT '0' NOT NULL auto_increment,
  r_user int(11) DEFAULT '0' NOT NULL,
  r_data int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (id),
  KEY idx_user (r_user),
  KEY idx_data (r_data)
);


#
# Table structure for table 'virtual_domains'
#
CREATE TABLE virtual_domains (
  id int(11) DEFAULT '0' NOT NULL auto_increment,
  domain varchar(80) DEFAULT '' NOT NULL,
  default_server varchar(80) DEFAULT '' NOT NULL,
  auth_server varchar(80),
  host_restriction enum('Y','N') DEFAULT 'Y' NOT NULL,
  allowed_hosts text,
  PRIMARY KEY (id),
  KEY vdom_domain (domain)
);