oa.sql

极限OA开源系统

# MySQL-Front Dump 2.2
#
# Host: oa.xsp.cn   Database: oa
#--------------------------------------------------------
# Server version 4.0.11-gamma-nt


#
# Table structure for table 'oa_addresslist'
#

CREATE TABLE `oa_addresslist` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `username` varchar(15) NOT NULL default '0',
  `sex` char(2) NOT NULL default '',
  `birth` date NOT NULL default '0000-00-00',
  `duty` varchar(20) default NULL,
  `zip` varchar(8) NOT NULL default '',
  `fax` varchar(18) default NULL,
  `tel` varchar(20) NOT NULL default '',
  `mobile` varchar(20) NOT NULL default '',
  `email` varchar(30) NOT NULL default '',
  `work` varchar(30) NOT NULL default '0',
  `address` varchar(50) NOT NULL default '',
  `memo` text,
  `mid` mediumint(8) unsigned NOT NULL default '0',
  `time` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `username` (`sex`),
  FULLTEXT KEY `log` (`memo`,`address`)
) TYPE=MyISAM COMMENT='通讯录表';

#
# Table structure for table 'oa_bulletin'
#

CREATE TABLE `oa_bulletin` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `type` varchar(4) NOT NULL default '公告',
  `title` varchar(30) NOT NULL default '0',
  `content` text NOT NULL,
  `keyword` varchar(30) NOT NULL default '',
  `tdate` date NOT NULL default '0000-00-00',
  `time` int(11) unsigned NOT NULL default '0',
  `daynum` tinyint(2) unsigned NOT NULL default '0',
  `time2` int(11) unsigned NOT NULL default '0',
  `scope` smallint(6) unsigned NOT NULL default '0',
  `mid` mediumint(8) unsigned NOT NULL default '0',
  `admin` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM COMMENT='任务表';

#
# Table structure for table 'oa_cli_note'
#

CREATE TABLE `oa_cli_note` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `cid` int(11) unsigned NOT NULL default '0',
  `type` varchar(15) NOT NULL default '',
  `des` text,
  `time` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`id`),
  KEY `username` (`type`),
  FULLTEXT KEY `log` (`des`)
) TYPE=MyISAM COMMENT='客户拜访记录表';

#
# Table structure for table 'oa_client'
#

CREATE TABLE `oa_client` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `type` tinyint(1) unsigned NOT NULL default '0',
  `contactor` varchar(15) NOT NULL default '',
  `corpname` varchar(60) default NULL,
  `tel` varchar(40) default NULL,
  `fax` varchar(20) default NULL,
  `email` varchar(40) default NULL,
  `province` varchar(20) NOT NULL default '',
  `city` varchar(20) NOT NULL default '',
  `address` varchar(40) NOT NULL default '',
  `url` varchar(50) NOT NULL default '0',
  `des` text NOT NULL,
  `log` text,
  `mid` mediumint(8) unsigned NOT NULL default '0',
  `time` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `username` (`contactor`),
  FULLTEXT KEY `log` (`log`,`des`)
) TYPE=MyISAM COMMENT='客户数据表';

#
# Table structure for table 'oa_department'
#

CREATE TABLE `oa_department` (
  `id` smallint(6) unsigned NOT NULL auto_increment,
  `name` varchar(30) NOT NULL default '0',
  `principal` varchar(15) NOT NULL default '',
  `address` varchar(40) NOT NULL default '',
  `des` varchar(100) NOT NULL default '',
  `fig` tinyint(1) unsigned NOT NULL default '1',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM COMMENT='部门表';



#
# Dumping data for table 'oa_department'
#
INSERT INTO oa_department VALUES("1","市场部","ck","address","","1");
INSERT INTO oa_department VALUES("9","客服部","","","","1");
INSERT INTO oa_department VALUES("6","技术部","ck","address","","1");
INSERT INTO oa_department VALUES("7","财务部","","","","1");
INSERT INTO oa_department VALUES("8","行政部","","","","0");


#
# Table structure for table 'oa_diary'
#

CREATE TABLE `oa_diary` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(60) NOT NULL default '',
  `content` text NOT NULL,
  `mid` mediumint(8) unsigned NOT NULL default '0',
  `date` date NOT NULL default '0000-00-00',
  `time` time NOT NULL default '00:00:00',
  PRIMARY KEY  (`id`),
  FULLTEXT KEY `log` (`content`)
) TYPE=MyISAM COMMENT='客户数据表';

#
# Table structure for table 'oa_dict'
#

CREATE TABLE `oa_dict` (
  `id` smallint(4) unsigned NOT NULL auto_increment,
  `cid` tinyint(2) unsigned NOT NULL default '0',
  `name` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM COMMENT='辞典表';



#
# Dumping data for table 'oa_dict'
#
INSERT INTO oa_dict VALUES("1","1","总经理");
INSERT INTO oa_dict VALUES("2","1","技术部经理");
INSERT INTO oa_dict VALUES("3","1","市场部经理");
INSERT INTO oa_dict VALUES("4","1","客服部经理");
INSERT INTO oa_dict VALUES("5","1","财务部经理");
INSERT INTO oa_dict VALUES("6","1","生产部总监");
INSERT INTO oa_dict VALUES("7","1","工程师");
INSERT INTO oa_dict VALUES("8","1","普通职员");
INSERT INTO oa_dict VALUES("9","1","其 它");
INSERT INTO oa_dict VALUES("10","2","中共党员");
INSERT INTO oa_dict VALUES("11","2","共青团员");
INSERT INTO oa_dict VALUES("12","2","民主人士");
INSERT INTO oa_dict VALUES("13","2","群众");
INSERT INTO oa_dict VALUES("14","3","小学");
INSERT INTO oa_dict VALUES("15","3","初中");
INSERT INTO oa_dict VALUES("16","3","高中");
INSERT INTO oa_dict VALUES("17","3","中专");
INSERT INTO oa_dict VALUES("18","3","技校");
INSERT INTO oa_dict VALUES("19","3","大专");
INSERT INTO oa_dict VALUES("20","3","大本");
INSERT INTO oa_dict VALUES("21","3","硕士");
INSERT INTO oa_dict VALUES("22","3","博士");
INSERT INTO oa_dict VALUES("23","3","博士后");
INSERT INTO oa_dict VALUES("24","3","院士");
INSERT INTO oa_dict VALUES("25","3","其它");
INSERT INTO oa_dict VALUES("26","4","汉族");
INSERT INTO oa_dict VALUES("27","4","回族");
INSERT INTO oa_dict VALUES("28","4","傣族");
INSERT INTO oa_dict VALUES("29","4","苗族");
INSERT INTO oa_dict VALUES("30","4","佤族");
INSERT INTO oa_dict VALUES("31","4","鲜卑族");
INSERT INTO oa_dict VALUES("32","4","朝鲜族");
INSERT INTO oa_dict VALUES("33","4","壮族");
INSERT INTO oa_dict VALUES("34","4","拉祜族");
INSERT INTO oa_dict VALUES("35","4","纳西族");
INSERT INTO oa_dict VALUES("36","4","景颇族");
INSERT INTO oa_dict VALUES("37","4","水族");
INSERT INTO oa_dict VALUES("38","4","怒族");
INSERT INTO oa_dict VALUES("39","4","傈僳族");
INSERT INTO oa_dict VALUES("40","4","独龙族");
INSERT INTO oa_dict VALUES("41","4","布朗族");
INSERT INTO oa_dict VALUES("42","4","基诺族");
INSERT INTO oa_dict VALUES("43","4","羌族");
INSERT INTO oa_dict VALUES("44","4","门巴族");
INSERT INTO oa_dict VALUES("45","4","德昂族");
INSERT INTO oa_dict VALUES("46","4","阿昌族");
INSERT INTO oa_dict VALUES("47","4","普米族");
INSERT INTO oa_dict VALUES("48","4","布依族");
INSERT INTO oa_dict VALUES("49","4","珞巴族");
INSERT INTO oa_dict VALUES("50","4","仡佬族");
INSERT INTO oa_dict VALUES("51","4","白族");
INSERT INTO oa_dict VALUES("52","4","东乡族");
INSERT INTO oa_dict VALUES("53","4","撒拉族");
INSERT INTO oa_dict VALUES("54","4","保安族");
INSERT INTO oa_dict VALUES("55","4","维吾尔族");
INSERT INTO oa_dict VALUES("56","4","土族");
INSERT INTO oa_dict VALUES("57","4","裕固族");
INSERT INTO oa_dict VALUES("58","4","锡伯族");
INSERT INTO oa_dict VALUES("59","4","俄罗斯族");
INSERT INTO oa_dict VALUES("60","4","塔塔尔族");
INSERT INTO oa_dict VALUES("61","4","哈萨克族");
INSERT INTO oa_dict VALUES("62","4","柯尔克孜族");
INSERT INTO oa_dict VALUES("63","4","塔吉克族");
INSERT INTO oa_dict VALUES("64","4","乌孜别克族");
INSERT INTO oa_dict VALUES("65","4","高山族");
INSERT INTO oa_dict VALUES("66","4","畲族");
INSERT INTO oa_dict VALUES("67","4","黎族");
INSERT INTO oa_dict VALUES("68","4","壮族");
INSERT INTO oa_dict VALUES("69","4","瑶族");
INSERT INTO oa_dict VALUES("70","4","京族");
INSERT INTO oa_dict VALUES("71","4","仫佬族");
INSERT INTO oa_dict VALUES("72","4","毛南族");
INSERT INTO oa_dict VALUES("73","4","土家族");
INSERT INTO oa_dict VALUES("74","4","满族");
INSERT INTO oa_dict VALUES("75","4","朝鲜族");
INSERT INTO oa_dict VALUES("76","4","赫哲族");
INSERT INTO oa_dict VALUES("77","4","蒙古族");
INSERT INTO oa_dict VALUES("78","4","达斡尔族");
INSERT INTO oa_dict VALUES("79","4","鄂温克族");
INSERT INTO oa_dict VALUES("80","4","鄂伦春族");
INSERT INTO oa_dict VALUES("81","4","彝族");
INSERT INTO oa_dict VALUES("82","5","正式客户");
INSERT INTO oa_dict VALUES("83","5","预约客户");
INSERT INTO oa_dict VALUES("84","5","潜在客户");
INSERT INTO oa_dict VALUES("85","5","作废客户");
INSERT INTO oa_dict VALUES("86","5","其他客户");
INSERT INTO oa_dict VALUES("87","6","活跃");
INSERT INTO oa_dict VALUES("88","6","停顿");
INSERT INTO oa_dict VALUES("89","6","流失");


#
# Table structure for table 'oa_employees'
#

CREATE TABLE `oa_employees` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `username` varchar(15) NOT NULL default '',
  `sex` char(2) NOT NULL default '',
  `birth` date NOT NULL default '0000-00-00',
  `idcard` varchar(20) NOT NULL default '',
  `native` varchar(20) NOT NULL default '',
  `nation` varchar(15) NOT NULL default '',
  `culture` varchar(10) NOT NULL default '',
  `polity` varchar(16) NOT NULL default '',
  `address` varchar(60) NOT NULL default '',
  `zip` varchar(6) NOT NULL default '',
  `homephone` varchar(20) NOT NULL default '',
  `telphone` varchar(20) NOT NULL default '',
  `mobile` varchar(20) NOT NULL default '',