crm.sql

来自「CRM 不仅仅是一个管理名词和管理概念」· SQL 代码 · 共 577 行 · 第 1/2 页

# phpMyAdmin MySQL-Dump
# version 2.2.4
# http://phpwizard.net/phpMyAdmin/
# http://phpmyadmin.sourceforge.net/ (download page)
#
# 主机: localhost
# Generation Time: Sep 18, 2003 at 05:05 PM
# Server version: 3.23.52
# PHP Version: 4.3.0
# 数据库 : `crm`
# --------------------------------------------------------

#
# 数据表的结构 `crm_account`
#

CREATE TABLE crm_account (
  AccountID int(10) NOT NULL auto_increment,
  AccountOwnerID varchar(40) NOT NULL default '',
  AccountName varchar(100) NOT NULL default '',
  AccountType varchar(40) NOT NULL default '',
  AccountSN varchar(20) NOT NULL default '',
  AccountIndustry varchar(40) NOT NULL default '',
  AccountSource varchar(40) NOT NULL default '',
  Area varchar(20) NOT NULL default '',
  YearRevenue varchar(40) NOT NULL default '',
  Tel varchar(60) NOT NULL default '',
  HumanScale varchar(40) NOT NULL default '',
  Fax varchar(60) NOT NULL default '',
  Relationship varchar(40) NOT NULL default '',
  WebSite varchar(60) NOT NULL default '',
  MainContact varchar(40) NOT NULL default '',
  Credit varchar(40) NOT NULL default '',
  TaxSN varchar(40) NOT NULL default '',
  FixedAssets varchar(40) NOT NULL default '',
  Sale varchar(40) NOT NULL default '',
  SaleManNumber varchar(40) NOT NULL default '',
  ComputerNumber varchar(40) NOT NULL default '',
  CorpProperty varchar(40) NOT NULL default '',
  FoundTime varchar(40) NOT NULL default '',
  Shared tinyint(1) NOT NULL default '0',
  Country varchar(100) NOT NULL default '',
  Province varchar(100) NOT NULL default '',
  City varchar(100) NOT NULL default '',
  Address varchar(200) NOT NULL default '',
  Zip varchar(20) NOT NULL default '',
  Memo varchar(250) NOT NULL default '',
  CreateID varchar(40) NOT NULL default '',
  CreateTime datetime default NULL,
  ModifyID varchar(40) NOT NULL default '',
  ModifyTime datetime default NULL,
  ifshow tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (AccountID),
  KEY AccountOwnerID (AccountOwnerID),
  KEY Shared (Shared)
) TYPE=MyISAM COMMENT='客户信息表';

#
# 数据表的结构 `crm_account_human_scale`
#

CREATE TABLE crm_account_human_scale (
  ScaleID int(10) NOT NULL auto_increment,
  ScaleName varchar(40) NOT NULL default '',
  PRIMARY KEY  (ScaleID)
) TYPE=MyISAM COMMENT='人员规模表';

#
# 导出下面的数据库内容 `crm_account_human_scale`
#

INSERT INTO crm_account_human_scale VALUES (1, '小型');
INSERT INTO crm_account_human_scale VALUES (2, '中小型');
INSERT INTO crm_account_human_scale VALUES (3, '中型');
INSERT INTO crm_account_human_scale VALUES (4, '大中型');
INSERT INTO crm_account_human_scale VALUES (5, '大型');
INSERT INTO crm_account_human_scale VALUES (6, '超大型');
# --------------------------------------------------------

#
# 数据表的结构 `crm_account_industry`
#

CREATE TABLE crm_account_industry (
  IndustryID int(10) NOT NULL auto_increment,
  IndustryName varchar(40) NOT NULL default '',
  PRIMARY KEY  (IndustryID)
) TYPE=MyISAM COMMENT='客户行业表';

#
# 导出下面的数据库内容 `crm_account_industry`
#

INSERT INTO crm_account_industry VALUES (1, '动力能源');
INSERT INTO crm_account_industry VALUES (2, '办公文教');
INSERT INTO crm_account_industry VALUES (3, '食品饮料');
INSERT INTO crm_account_industry VALUES (4, '服饰皮革');
INSERT INTO crm_account_industry VALUES (5, '交通运输');
INSERT INTO crm_account_industry VALUES (6, '商业服务');
INSERT INTO crm_account_industry VALUES (7, '纤维纺织');
INSERT INTO crm_account_industry VALUES (8, '房产建筑');
INSERT INTO crm_account_industry VALUES (9, '工业用品');
INSERT INTO crm_account_industry VALUES (10, '科研文化');
INSERT INTO crm_account_industry VALUES (11, '家用电器');
INSERT INTO crm_account_industry VALUES (12, '家居用品');
INSERT INTO crm_account_industry VALUES (13, '机械机电');
INSERT INTO crm_account_industry VALUES (14, '电脑软件');
INSERT INTO crm_account_industry VALUES (15, '医药保健');
INSERT INTO crm_account_industry VALUES (16, '金融贸易');
INSERT INTO crm_account_industry VALUES (17, '化学化工');
INSERT INTO crm_account_industry VALUES (18, '玩具行业');
INSERT INTO crm_account_industry VALUES (19, '冶金矿产');
INSERT INTO crm_account_industry VALUES (20, '运动休闲');
INSERT INTO crm_account_industry VALUES (21, '通讯邮电');
INSERT INTO crm_account_industry VALUES (22, '旅游餐饮');
INSERT INTO crm_account_industry VALUES (23, '信息媒体');
INSERT INTO crm_account_industry VALUES (24, '其他行业');
# --------------------------------------------------------

#
# 数据表的结构 `crm_account_relationship`
#

CREATE TABLE crm_account_relationship (
  RelationshipID int(10) NOT NULL auto_increment,
  RelationshipName varchar(40) NOT NULL default '',
  PRIMARY KEY  (RelationshipID)
) TYPE=MyISAM COMMENT='客户关系等级表';

#
# 导出下面的数据库内容 `crm_account_relationship`
#

INSERT INTO crm_account_relationship VALUES (1, '密切');
INSERT INTO crm_account_relationship VALUES (2, '良好');
INSERT INTO crm_account_relationship VALUES (3, '普通');
INSERT INTO crm_account_relationship VALUES (4, '紧张');
INSERT INTO crm_account_relationship VALUES (5, '其他');
# --------------------------------------------------------

#
# 数据表的结构 `crm_account_type`
#

CREATE TABLE crm_account_type (
  TypeID int(10) NOT NULL auto_increment,
  TypeName varchar(40) NOT NULL default '',
  PRIMARY KEY  (TypeID)
) TYPE=MyISAM COMMENT='帐户类别表';

#
# 导出下面的数据库内容 `crm_account_type`
#

INSERT INTO crm_account_type VALUES (1, '企业大客户');
INSERT INTO crm_account_type VALUES (2, '家庭用户');
INSERT INTO crm_account_type VALUES (3, '政府用户');
INSERT INTO crm_account_type VALUES (4, '个人用户');
INSERT INTO crm_account_type VALUES (5, '中小企业');
INSERT INTO crm_account_type VALUES (6, '批发商');
# --------------------------------------------------------

#
# 数据表的结构 `crm_account_year_revenue`
#

CREATE TABLE crm_account_year_revenue (
  RevenueID int(10) NOT NULL auto_increment,
  RevenueName varchar(40) NOT NULL default '',
  PRIMARY KEY  (RevenueID)
) TYPE=MyISAM COMMENT='年收入表';

#
# 导出下面的数据库内容 `crm_account_year_revenue`
#

INSERT INTO crm_account_year_revenue VALUES (1, '0-10万元');
INSERT INTO crm_account_year_revenue VALUES (2, '10-50万元');
INSERT INTO crm_account_year_revenue VALUES (3, '50-100万元');
INSERT INTO crm_account_year_revenue VALUES (4, '100-500万元');
INSERT INTO crm_account_year_revenue VALUES (5, '500-1000万元');
INSERT INTO crm_account_year_revenue VALUES (6, '1000-5000万元');
INSERT INTO crm_account_year_revenue VALUES (7, '5000万元-1亿元');
INSERT INTO crm_account_year_revenue VALUES (8, '一亿元以上');
# --------------------------------------------------------

#
# 数据表的结构 `crm_activity`
#

CREATE TABLE crm_activity (
  ActivityID int(10) NOT NULL auto_increment,
  AccountID int(10) NOT NULL default '0',
  ContactID int(10) NOT NULL default '0',
  ProjectID int(10) NOT NULL default '0',
  ActivityName varchar(100) NOT NULL default '',
  ActivityLocation varchar(60) NOT NULL default '',
  ActivityMode varchar(40) NOT NULL default '',
  ActivityExecuteID int(10) NOT NULL default '0',
  BeginTime date NOT NULL default '0000-00-00',
  EndTime date NOT NULL default '0000-00-00',
  YuJianSale decimal(10,2) NOT NULL default '0.00',
  PeiTongRen varchar(100) NOT NULL default '',
  Result varchar(250) NOT NULL default '',
  Memo varchar(250) NOT NULL default '',
  PRIMARY KEY  (ActivityID),
  KEY AccountID (AccountID),
  KEY ActivityExecuteID (ActivityExecuteID),
  KEY ProjectID (ProjectID),
  KEY ContactID (ContactID)
) TYPE=MyISAM COMMENT='行动表';

# --------------------------------------------------------

#
# 数据表的结构 `crm_area`
#

CREATE TABLE crm_area (
  AreaID int(8) NOT NULL auto_increment,
  AreaName varchar(50) NOT NULL default '',
  PRIMARY KEY  (AreaID)
) TYPE=MyISAM COMMENT='客户地区表';

#
# 导出下面的数据库内容 `crm_area`
#

INSERT INTO crm_area VALUES (1, '华东地区');
INSERT INTO crm_area VALUES (2, '华南地区');
INSERT INTO crm_area VALUES (3, '华中地区');
INSERT INTO crm_area VALUES (4, '华北地区');
INSERT INTO crm_area VALUES (5, '西北地区');
INSERT INTO crm_area VALUES (6, '西南地区');
INSERT INTO crm_area VALUES (7, '其他地区');
# --------------------------------------------------------

#
# 数据表的结构 `crm_attach`
#

CREATE TABLE crm_attach (
  AttachID int(10) NOT NULL auto_increment,
  AttachColumn varchar(60) NOT NULL default '',
  AttachColumnID int(10) NOT NULL default '0',
  FileName varchar(200) NOT NULL default '',
  AttachName varchar(100) NOT NULL default '',
  FileSize varchar(100) NOT NULL default '',
  UploaderID int(10) NOT NULL default '0',
  UploadTime date NOT NULL default '0000-00-00',
  PRIMARY KEY  (AttachID),
  KEY AttachColumnID (AttachColumnID)
) TYPE=MyISAM COMMENT='web上传附件表';

# --------------------------------------------------------

#
# 数据表的结构 `crm_contact`
#

CREATE TABLE crm_contact (
  ContactID int(10) NOT NULL auto_increment,
  AccountID int(10) NOT NULL default '0',
  ContactName varchar(40) NOT NULL default '',
  ChenWei varchar(40) NOT NULL default '',
  ZhiWu varchar(40) NOT NULL default '',
  Dept varchar(40) NOT NULL default '',
  Birthday date NOT NULL default '0000-00-00',
  Email varchar(40) NOT NULL default '',
  OfficeTel varchar(40) NOT NULL default '',
  OfficeFax varchar(40) NOT NULL default '',
  Mobile varchar(40) NOT NULL default '',
  HomeTel varchar(40) NOT NULL default '',
  HomeAddr varchar(60) NOT NULL default '',
  Hobby varchar(100) NOT NULL default '',
  Source varchar(40) NOT NULL default '',
  Relation varchar(40) NOT NULL default '',
  AddID int(10) NOT NULL default '0',
  CreateTime date NOT NULL default '0000-00-00',
  PRIMARY KEY  (ContactID),
  KEY AccountID (AccountID),
  KEY AddID (AddID)
) TYPE=MyISAM COMMENT='联系人信息表';

# --------------------------------------------------------

#
# 数据表的结构 `crm_contact_folk`
#