am.sql

来自「一个很有用的电子刊物发布系统」· SQL 代码 · 共 119 行

# MySQL-Front 3.1  (Build 13.0)


# Database: am
# ------------------------------------------------------
# Server version 3.23.39

CREATE DATABASE `am`;
USE `am`;

#
# Table structure for table articles
#

CREATE TABLE `articles` (
  `ID` bigint(20) NOT NULL auto_increment,
  `title` varchar(200) default NULL,
  `summary` text,
  `fileName` varchar(100) default NULL,
  `author` varchar(100) default NULL,
  `issuer` bigint(20) NOT NULL default '0',
  `workgroup` bigint(20) unsigned default '0',
  `reviewer1` bigint(20) unsigned default '0',
  `reviewer2` bigint(20) unsigned default '0',
  `createDatetime` datetime default '0000-00-00 00:00:00',
  `tag` int(10) default '0',
  `accept` int(10) default '0',
  `allowmodify` int(10) default '0',
  `recommend` int(10) default '0',
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM;

#
# Table structure for table articlesaudit
#

CREATE TABLE `articlesaudit` (
  `ID` bigint(20) NOT NULL auto_increment,
  `articleID` bigint(20) NOT NULL default '0',
  `title` varchar(254) default NULL,
  `reviewer` bigint(20) NOT NULL default '0',
  `comment` text,
  `point` int(10) default NULL,
  `accept` int(10) default '0',
  `commentManager` text,
  `createDatetime` datetime default '0000-00-00 00:00:00',
  `tag` int(10) default '0',
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM;

#
# Table structure for table email
#

CREATE TABLE `email` (
  `ID` bigint(20) NOT NULL auto_increment,
  `subject` varchar(200) default NULL,
  `content` text,
  `sender` varchar(200) NOT NULL default '',
  `receiver` varchar(200) NOT NULL default '',
  `createDatetime` datetime default '0000-00-00 00:00:00',
  `mailType` int(10) default '0',
  `tag` int(10) default '0',
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM;

#
# Table structure for table operatelog
#

CREATE TABLE `operatelog` (
  `ID` bigint(20) NOT NULL auto_increment,
  `operateType` varchar(100) NOT NULL default '',
  `operatorID` bigint(20) NOT NULL default '0',
  `destination` varchar(200) default NULL,
  `operateDatetime` datetime default '0000-00-00 00:00:00',
  `tag` int(10) default '0',
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM;

#
# Table structure for table users
#

CREATE TABLE `users` (
  `ID` bigint(20) NOT NULL auto_increment,
  `userName` varchar(100) NOT NULL default '',
  `userPassword` varchar(100) default NULL,
  `name` varchar(100) default '',
  `company` varchar(100) default NULL,
  `depart` varchar(100) default NULL,
  `email` varchar(100) default NULL,
  `myfields` text,
  `systemRole` varchar(10) default '1',
  `createDatetime` datetime default '0000-00-00 00:00:00',
  `tag` int(10) default '0',
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM;

#
# Dumping data for table users
#

INSERT INTO `users` VALUES (1,'admin','admin','管理员','','','','0,0','0','2006-03-09 13:31:50',0);

#
# Table structure for table workgroup
#

CREATE TABLE `workgroup` (
  `ID` bigint(20) NOT NULL auto_increment,
  `note` varchar(50) default NULL,
  `fieldName` varchar(100) default NULL,
  `tag` int(10) default '0',
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM;