/**
* 数据库修改日志
**/
#新建文档分类表
CREATE TABLE `documents_sort` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `sort_name` varchar(255) NOT NULL DEFAULT '' COMMENT '分类名称',
  `sort_note` text COMMENT '分类说明',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='文档分类';

#新建文档表
CREATE TABLE `documents` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `sort_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '分类 0内容公告',
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT '标题',
  `info` text COMMENT '内容',
  `user_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '发布人',
  `post_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '发布时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `sort_id` (`sort_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='文档';

#2013-07-27
ALTER TABLE ssf add ssf_order int(10) unsigned default 0;
ALTER TABLE customer_ssf_snap add ssf_order int(10) unsigned default 0;
ALTER TABLE jqcalendar add UserId int(10) not null default 0;
#2013-07-28
ALTER TABLE customer ADD service_charge decimal(8,2) DEFAULT 0 COMMENT '服务费';
ALTER TABLE customer ADD sc_type enum('month', 'semester', 'year') DEFAULT 'month' COMMENT '缴费方式';
#2.13-08-02
alter table business add fax varchar(50) COMMENT '传真';
alter table business add mobile varchar(50) COMMENT '手机';
alter table business add email varchar(50) COMMENT '邮箱';
alter table business add express varchar(50) COMMENT '快递';
alter table business add bill varchar(50) COMMENT '发票/台账';
alter table business add change_personnel_day char(2) COMMENT '增减员申报时间';
alter table business add pay_day char(2) COMMENT '付款时间';
alter table business add pay_type varchar(50) COMMENT '付款时间';
alter table business add service_info varchar(255) COMMENT '服务项目';
alter table business add contract_no char(30) COMMENT '合同编号';