/*
Navicat MySQL Data Transfer

Source Server         : localhost,9307
Source Server Version : 60005
Source Host           : localhost:9283
Source Database       : mydata

Target Server Type    : MYSQL
Target Server Version : 60005
File Encoding         : 65001

Date: 2009-10-29 13:41:24
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `cfilters`
-- ----------------------------
DROP TABLE IF EXISTS `cfilters`;
CREATE TABLE `cfilters` (
  `FNAME` varchar(100) NOT NULL,
  `FDATA` text,
  `FTIMES` int(11) DEFAULT '0',
  PRIMARY KEY (`FNAME`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

-- ----------------------------
-- Records of cfilters
-- ----------------------------
INSERT INTO `cfilters` VALUES ('电信手机用户', '/v///wEEAAAAAAYCAAAAMCUCAAAAHgAAAGN4R3JpZEN1c3RvbWVyREJUYWJsZVZpZXdQSE9ORQYCMCUABgQAAAAxMzMlAgAAAB4AAABjeEdyaWRDdXN0b21lckRCVGFibGVWaWV3UEhPTkUGBDEzMyUABgQAAAAxNTMlAgAAAB4AAABjeEdyaWRDdXN0b21lckRCVGFibGVWaWV3UEhPTkUGBDE1MyUABgQAAAAxODklAgAAAB4AAABjeEdyaWRDdXN0b21lckRCVGFibGVWaWV3UEhPTkUGBDE4OSU=', '0');
INSERT INTO `cfilters` VALUES ('移动手机用户', '/v///wENAAAAAAYEAAAAMTM0JQIAAAAeAAAAY3hHcmlkQ3VzdG9tZXJEQlRhYmxlVmlld1BIT05FBgQxMzQlAAYEAAAAMTM1JQIAAAAeAAAAY3hHcmlkQ3VzdG9tZXJEQlRhYmxlVmlld1BIT05FBgQxMzUlAAYEAAAAMTM2JQIAAAAeAAAAY3hHcmlkQ3VzdG9tZXJEQlRhYmxlVmlld1BIT05FBgQxMzYlAAYEAAAAMTM3JQIAAAAeAAAAY3hHcmlkQ3VzdG9tZXJEQlRhYmxlVmlld1BIT05FBgQxMzclAAYEAAAAMTM4JQIAAAAeAAAAY3hHcmlkQ3VzdG9tZXJEQlRhYmxlVmlld1BIT05FBgQxMzglAAYEAAAAMTM5JQIAAAAeAAAAY3hHcmlkQ3VzdG9tZXJEQlRhYmxlVmlld1BIT05FBgQxMzklAAYEAAAAMTUwJQIAAAAeAAAAY3hHcmlkQ3VzdG9tZXJEQlRhYmxlVmlld1BIT05FBgQxNTAlAAYEAAAAMTUxJQIAAAAeAAAAY3hHcmlkQ3VzdG9tZXJEQlRhYmxlVmlld1BIT05FBgQxNTElAAYEAAAAMTUyJQIAAAAeAAAAY3hHcmlkQ3VzdG9tZXJEQlRhYmxlVmlld1BIT05FBgQxNTIlAAYEAAAAMTU4JQIAAAAeAAAAY3hHcmlkQ3VzdG9tZXJEQlRhYmxlVmlld1BIT05FBgQxNTglAAYEAAAAMTU5JQIAAAAeAAAAY3hHcmlkQ3VzdG9tZXJEQlRhYmxlVmlld1BIT05FBgQxNTklAAYEAAAAMTg4JQIAAAAeAAAAY3hHcmlkQ3VzdG9tZXJEQlRhYmxlVmlld1BIT05FBgQxODglAAYEAAAAMTU3JQIAAAAeAAAAY3hHcmlkQ3VzdG9tZXJEQlRhYmxlVmlld1BIT05FBgQxNTcl', '0');
INSERT INTO `cfilters` VALUES ('12月17日过生日', '/v///wEBAAAAAAYJAAAAJTEy1MIxN8jVFAAAABwAAABjeEdyaWRDdXN0b21lckRCVGFibGVWaWV3VDEwBgklMTLUwjE3yNU=', '0');
INSERT INTO `cfilters` VALUES ('联通手机用户', '/v///wEHAAAAAAYEAAAAMTMwJQIAAAAeAAAAY3hHcmlkQ3VzdG9tZXJEQlRhYmxlVmlld1BIT05FBgQxMzAlAAYEAAAAMTMxJQIAAAAeAAAAY3hHcmlkQ3VzdG9tZXJEQlRhYmxlVmlld1BIT05FBgQxMzElAAYEAAAAMTMyJQIAAAAeAAAAY3hHcmlkQ3VzdG9tZXJEQlRhYmxlVmlld1BIT05FBgQxMzIlAAYEAAAAMTU1JQIAAAAeAAAAY3hHcmlkQ3VzdG9tZXJEQlRhYmxlVmlld1BIT05FBgQxNTUlAAYEAAAAMTU2JQIAAAAeAAAAY3hHcmlkQ3VzdG9tZXJEQlRhYmxlVmlld1BIT05FBgQxNTYlAAYEAAAAMTg1JQIAAAAeAAAAY3hHcmlkQ3VzdG9tZXJEQlRhYmxlVmlld1BIT05FBgQxODUlAAYEAAAAMTg2JQIAAAAeAAAAY3hHcmlkQ3VzdG9tZXJEQlRhYmxlVmlld1BIT05FBgQxODYl', '0');
INSERT INTO `cfilters` VALUES ('(累计积分 > 500)', '/v///wABAAAAAAQDAAAANTAwHAAAABwAAABjeEdyaWRDdXN0b21lckRCVGFibGVWaWV3TjAzBQAAAAAAAAD6B0A=', '0');

-- ----------------------------
-- Table structure for `crecord`
-- ----------------------------
DROP TABLE IF EXISTS `crecord`;
CREATE TABLE `crecord` (
  `ID` varchar(100) NOT NULL,
  `CID` varchar(100) NOT NULL,
  `OWNER` int(11) NOT NULL,
  `UPDATETIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `BDATE` timestamp NULL DEFAULT NULL,
  `PRODUCT` varchar(500) DEFAULT NULL,
  `BMONEY` decimal(15,2) DEFAULT NULL,
  `BSCORE` int(11) DEFAULT NULL,
  `NOTE` varchar(2000) DEFAULT NULL,
  `CREATETIME` timestamp NULL DEFAULT NULL,
  `DATALOG` text,
  `C01` varchar(500) DEFAULT NULL,
  `C02` varchar(500) DEFAULT NULL,
  `C03` varchar(500) DEFAULT NULL,
  `C04` varchar(500) DEFAULT NULL,
  `C05` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

-- ----------------------------
-- Records of crecord
-- ----------------------------
INSERT INTO `crecord` VALUES ('ffbe38f81f8bfcafacb25f9dc362b0a9', 'fbbac3a4590c890b22b9b899b34c1951', '2094', '2009-08-11 01:55:37', '2009-08-11 00:00:00', '手机', '2000.00', '4000', 'test', '2009-08-11 01:54:54', null, null, null, null, null, null);

-- ----------------------------
-- Table structure for `customer`
-- ----------------------------
DROP TABLE IF EXISTS `customer`;
CREATE TABLE `customer` (
  `ID` varchar(100) NOT NULL,
  `NAME` varchar(100) NOT NULL,
  `PHONE` varchar(100) NOT NULL,
  `PTYPE` int(11) DEFAULT '0',
  `DIR` int(11) DEFAULT NULL,
  `PATH` varchar(200) DEFAULT NULL,
  `OWNER` int(11) NOT NULL,
  `TAG` varchar(500) DEFAULT NULL,
  `TAG2` varchar(500) DEFAULT NULL,
  `UPDATETIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `CREATETIME` timestamp NULL DEFAULT NULL,
  `T01` varchar(200) DEFAULT NULL,
  `T02` varchar(200) DEFAULT NULL,
  `T03` varchar(200) DEFAULT NULL,
  `T04` varchar(200) DEFAULT NULL,
  `T05` varchar(200) DEFAULT NULL,
  `T06` varchar(200) DEFAULT NULL,
  `T07` varchar(200) DEFAULT NULL,
  `T08` varchar(200) DEFAULT NULL,
  `T09` varchar(200) DEFAULT NULL,
  `T10` varchar(200) DEFAULT NULL,
  `T11` varchar(200) DEFAULT NULL,
  `T12` varchar(200) DEFAULT NULL,
  `T13` varchar(200) DEFAULT NULL,
  `T14` varchar(200) DEFAULT NULL,
  `T15` varchar(200) DEFAULT NULL,
  `N01` double DEFAULT NULL,
  `N02` double DEFAULT NULL,
  `N03` double DEFAULT NULL,
  `N04` double DEFAULT NULL,
  `N05` double DEFAULT NULL,
  `D01` timestamp NULL DEFAULT NULL,
  `D02` timestamp NULL DEFAULT NULL,
  `D03` timestamp NULL DEFAULT NULL,
  `D04` timestamp NULL DEFAULT NULL,
  `D05` timestamp NULL DEFAULT NULL,
  `M01` text,
  `CT1` varchar(100) DEFAULT NULL,
  `CT2` varchar(100) DEFAULT NULL,
  `CT3` varchar(100) DEFAULT NULL,
  `CT4` varchar(100) DEFAULT NULL,
  `CN1` double DEFAULT NULL,
  `CN2` double DEFAULT NULL,
  `CN3` double DEFAULT NULL,
  `CD1` timestamp NULL DEFAULT NULL,
  `CD2` timestamp NULL DEFAULT NULL,
  `CM1` text,
  PRIMARY KEY (`ID`),
  KEY `CUSTOMER_Index01` (`NAME`,`DIR`,`OWNER`,`PHONE`,`UPDATETIME`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

-- ----------------------------
-- Records of customer
-- ----------------------------
INSERT INTO `customer` VALUES ('fbbac3a4590c890b22b9b899b34c1951', '朱家田', '18925024504', null, '3', '/根目录/供应商', '2094', null, null, '2009-10-09 10:56:43', '2009-03-02 00:00:00', null, '男', null, null, null, null, null, null, null, '12月17日', null, null, null, null, null, '1', '2000', '4000', null, null, '2009-08-11 00:00:00', '2009-08-11 00:00:00', '2009-08-11 00:00:00', '2009-08-11 00:00:00', '2009-08-11 00:00:00', null, null, null, null, null, null, null, null, '2009-08-11 00:00:00', '2009-08-11 00:00:00', null);
INSERT INTO `customer` VALUES ('94c7c08f30cafa6b692f1c6ac17c007a', '曹霞', '13710105172', null, '2', '/根目录/客户', '2094', null, null, '2009-09-24 10:25:49', '2009-08-25 22:33:27', '', '女', null, null, null, null, null, null, null, '07月23日', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);

-- ----------------------------
-- Table structure for `customerdir`
-- ----------------------------
DROP TABLE IF EXISTS `customerdir`;
CREATE TABLE `customerdir` (
  `DIR` int(11) NOT NULL AUTO_INCREMENT,
  `PATH` varchar(1000) DEFAULT NULL,
  `PARENT` int(11) DEFAULT NULL,
  `IMAGE` int(11) DEFAULT NULL,
  `DTYPE` varchar(100) DEFAULT NULL,
  `NAME` varchar(100) DEFAULT NULL,
  `NOTE` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`DIR`),
  UNIQUE KEY `CUSTOMERDIR_PARENT_NAME` (`PARENT`,`NAME`)
) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=gbk;

-- ----------------------------
-- Records of customerdir
-- ----------------------------
INSERT INTO `customerdir` VALUES ('1', '/根目录', '0', '0', '', '根目录', '--');
INSERT INTO `customerdir` VALUES ('2', '/根目录/客户', '1', '1', null, '客户', null);
INSERT INTO `customerdir` VALUES ('3', '/根目录/供应商', '1', '1', null, '供应商', null);

-- ----------------------------
-- Table structure for `cviews`
-- ----------------------------
DROP TABLE IF EXISTS `cviews`;
CREATE TABLE `cviews` (
  `CNAME` varchar(100) NOT NULL,
  `CDATA` text,
  `CTIMES` int(11) DEFAULT '0',
  PRIMARY KEY (`CNAME`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

-- ----------------------------
-- Records of cviews
-- ----------------------------
INSERT INTO `cviews` VALUES ('自定义', '[FormCustomerList.cxGridCustomerDBTableView: TcxGridDBTableView]\r\n=\r\nFooter=\"False\"\r\nGroupByBox=\"False\"\r\nGroupFooters=0\r\nNewItemRow=\"False\"\r\nVersion=1\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewID: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=24\r\nAlignmentHorz=0\r\nIndex=0\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewNAME: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=60\r\nAlignmentHorz=0\r\nIndex=1\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewPHONE: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=96\r\nAlignmentHorz=0\r\nIndex=2\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewPTYPE: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=74\r\nAlignmentHorz=1\r\nIndex=3\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewDIR: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=74\r\nAlignmentHorz=0\r\nIndex=4\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT02: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=50\r\nAlignmentHorz=0\r\nIndex=5\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT10: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=80\r\nAlignmentHorz=0\r\nIndex=6\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT01: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=100\r\nAlignmentHorz=0\r\nIndex=7\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewD02: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=55\r\nAlignmentHorz=0\r\nIndex=8\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT09: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=200\r\nAlignmentHorz=0\r\nIndex=9\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT05: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=120\r\nAlignmentHorz=0\r\nIndex=10\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT06: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=120\r\nAlignmentHorz=0\r\nIndex=11\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT03: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=45\r\nAlignmentHorz=0\r\nIndex=12\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewN05: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=75\r\nAlignmentHorz=1\r\nIndex=13\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewN04: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=75\r\nAlignmentHorz=1\r\nIndex=14\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewN02: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=55\r\nAlignmentHorz=1\r\nIndex=15\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewN03: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=55\r\nAlignmentHorz=1\r\nIndex=16\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewN01: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=55\r\nAlignmentHorz=1\r\nIndex=17\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT07: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=100\r\nAlignmentHorz=0\r\nIndex=18\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT08: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=100\r\nAlignmentHorz=0\r\nIndex=19\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCT1: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=82\r\nAlignmentHorz=0\r\nIndex=20\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCT2: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=80\r\nAlignmentHorz=0\r\nIndex=21\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCN1: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=74\r\nAlignmentHorz=1\r\nIndex=22\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewM01: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=446\r\nAlignmentHorz=0\r\nIndex=23\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewPATH: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=105\r\nAlignmentHorz=0\r\nIndex=24\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewOWNER: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=74\r\nAlignmentHorz=1\r\nIndex=25\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewTAG: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=3504\r\nAlignmentHorz=0\r\nIndex=26\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewTAG2: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=3504\r\nAlignmentHorz=0\r\nIndex=27\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCREATETIME: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=130\r\nAlignmentHorz=0\r\nIndex=28\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewUPDATETIME: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=130\r\nAlignmentHorz=0\r\nIndex=29\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT04: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=1404\r\nAlignmentHorz=0\r\nIndex=30\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT11: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=1404\r\nAlignmentHorz=0\r\nIndex=31\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT12: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=1404\r\nAlignmentHorz=0\r\nIndex=32\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT13: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=1404\r\nAlignmentHorz=0\r\nIndex=33\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT14: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=1404\r\nAlignmentHorz=0\r\nIndex=34\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT15: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=1404\r\nAlignmentHorz=0\r\nIndex=35\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewD01: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=130\r\nAlignmentHorz=0\r\nIndex=36\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewD03: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=130\r\nAlignmentHorz=0\r\nIndex=37\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewD04: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=130\r\nAlignmentHorz=0\r\nIndex=38\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewD05: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=130\r\nAlignmentHorz=0\r\nIndex=39\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCT3: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=704\r\nAlignmentHorz=0\r\nIndex=40\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCT4: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=704\r\nAlignmentHorz=0\r\nIndex=41\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCN2: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=74\r\nAlignmentHorz=1\r\nIndex=42\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCN3: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=74\r\nAlignmentHorz=1\r\nIndex=43\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCD1: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=130\r\nAlignmentHorz=0\r\nIndex=44\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCD2: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=130\r\nAlignmentHorz=0\r\nIndex=45\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCM1: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=74\r\nAlignmentHorz=0\r\nIndex=46\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n', '3');
INSERT INTO `cviews` VALUES ('生日', '[FormCustomerList.cxGridCustomerDBTableView: TcxGridDBTableView]\r\n=\r\nFooter=\"False\"\r\nGroupByBox=\"False\"\r\nGroupFooters=0\r\nNewItemRow=\"False\"\r\nVersion=1\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewID: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=24\r\nAlignmentHorz=0\r\nIndex=0\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewNAME: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=60\r\nAlignmentHorz=0\r\nIndex=1\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewPHONE: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=96\r\nAlignmentHorz=0\r\nIndex=2\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewPTYPE: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=74\r\nAlignmentHorz=1\r\nIndex=3\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewDIR: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=128\r\nAlignmentHorz=0\r\nIndex=4\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT02: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=50\r\nAlignmentHorz=0\r\nIndex=5\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT10: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=80\r\nAlignmentHorz=0\r\nIndex=6\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT01: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=100\r\nAlignmentHorz=0\r\nIndex=7\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewD02: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=77\r\nAlignmentHorz=0\r\nIndex=8\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT09: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=200\r\nAlignmentHorz=0\r\nIndex=9\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT05: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=120\r\nAlignmentHorz=0\r\nIndex=10\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT06: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=120\r\nAlignmentHorz=0\r\nIndex=11\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT03: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=45\r\nAlignmentHorz=0\r\nIndex=12\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewN05: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=75\r\nAlignmentHorz=1\r\nIndex=13\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewN04: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=75\r\nAlignmentHorz=1\r\nIndex=14\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewN02: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=55\r\nAlignmentHorz=1\r\nIndex=15\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewN03: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=55\r\nAlignmentHorz=1\r\nIndex=16\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewN01: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=55\r\nAlignmentHorz=1\r\nIndex=17\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT07: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=100\r\nAlignmentHorz=0\r\nIndex=18\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT08: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=100\r\nAlignmentHorz=0\r\nIndex=19\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCT1: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=82\r\nAlignmentHorz=0\r\nIndex=20\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCT2: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=80\r\nAlignmentHorz=0\r\nIndex=21\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCN1: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=74\r\nAlignmentHorz=1\r\nIndex=22\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewM01: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=446\r\nAlignmentHorz=0\r\nIndex=23\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewPATH: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=105\r\nAlignmentHorz=0\r\nIndex=24\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewOWNER: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=74\r\nAlignmentHorz=1\r\nIndex=25\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewTAG: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=3504\r\nAlignmentHorz=0\r\nIndex=26\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewTAG2: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=3504\r\nAlignmentHorz=0\r\nIndex=27\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCREATETIME: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=130\r\nAlignmentHorz=0\r\nIndex=28\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewUPDATETIME: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=130\r\nAlignmentHorz=0\r\nIndex=29\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT04: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=1404\r\nAlignmentHorz=0\r\nIndex=30\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT11: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=1404\r\nAlignmentHorz=0\r\nIndex=31\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT12: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=1404\r\nAlignmentHorz=0\r\nIndex=32\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT13: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=1404\r\nAlignmentHorz=0\r\nIndex=33\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT14: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=1404\r\nAlignmentHorz=0\r\nIndex=34\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT15: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=1404\r\nAlignmentHorz=0\r\nIndex=35\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewD01: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=130\r\nAlignmentHorz=0\r\nIndex=36\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewD03: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=130\r\nAlignmentHorz=0\r\nIndex=37\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewD04: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=130\r\nAlignmentHorz=0\r\nIndex=38\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewD05: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=130\r\nAlignmentHorz=0\r\nIndex=39\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCT3: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=704\r\nAlignmentHorz=0\r\nIndex=40\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCT4: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=704\r\nAlignmentHorz=0\r\nIndex=41\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCN2: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=74\r\nAlignmentHorz=1\r\nIndex=42\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCN3: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=74\r\nAlignmentHorz=1\r\nIndex=43\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCD1: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=130\r\nAlignmentHorz=0\r\nIndex=44\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCD2: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=130\r\nAlignmentHorz=0\r\nIndex=45\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCM1: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=74\r\nAlignmentHorz=0\r\nIndex=46\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n', '5');
INSERT INTO `cviews` VALUES ('联系', '[FormCustomerList.cxGridCustomerDBTableView: TcxGridDBTableView]\r\n=\r\nFooter=\"False\"\r\nGroupByBox=\"False\"\r\nGroupFooters=0\r\nNewItemRow=\"False\"\r\nVersion=1\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewID: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=24\r\nAlignmentHorz=0\r\nIndex=0\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewNAME: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=60\r\nAlignmentHorz=0\r\nIndex=1\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewPHONE: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=96\r\nAlignmentHorz=0\r\nIndex=2\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewPTYPE: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=74\r\nAlignmentHorz=1\r\nIndex=3\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewDIR: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=128\r\nAlignmentHorz=0\r\nIndex=4\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT02: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=50\r\nAlignmentHorz=0\r\nIndex=5\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT10: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=80\r\nAlignmentHorz=0\r\nIndex=6\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT01: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=100\r\nAlignmentHorz=0\r\nIndex=7\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewD02: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=77\r\nAlignmentHorz=0\r\nIndex=8\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT05: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=120\r\nAlignmentHorz=0\r\nIndex=9\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT06: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=102\r\nAlignmentHorz=0\r\nIndex=10\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT03: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=79\r\nAlignmentHorz=0\r\nIndex=11\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT09: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=200\r\nAlignmentHorz=0\r\nIndex=12\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewN05: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=75\r\nAlignmentHorz=1\r\nIndex=13\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewN04: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=75\r\nAlignmentHorz=1\r\nIndex=14\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewN02: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=55\r\nAlignmentHorz=1\r\nIndex=15\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewN03: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=55\r\nAlignmentHorz=1\r\nIndex=16\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewN01: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=55\r\nAlignmentHorz=1\r\nIndex=17\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT07: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=100\r\nAlignmentHorz=0\r\nIndex=18\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT08: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=100\r\nAlignmentHorz=0\r\nIndex=19\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCT1: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=82\r\nAlignmentHorz=0\r\nIndex=20\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCT2: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=80\r\nAlignmentHorz=0\r\nIndex=21\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCN1: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=74\r\nAlignmentHorz=1\r\nIndex=22\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewM01: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=446\r\nAlignmentHorz=0\r\nIndex=23\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewPATH: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=105\r\nAlignmentHorz=0\r\nIndex=24\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewOWNER: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=74\r\nAlignmentHorz=1\r\nIndex=25\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewTAG: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=3504\r\nAlignmentHorz=0\r\nIndex=26\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewTAG2: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=3504\r\nAlignmentHorz=0\r\nIndex=27\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCREATETIME: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=130\r\nAlignmentHorz=0\r\nIndex=28\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewUPDATETIME: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=130\r\nAlignmentHorz=0\r\nIndex=29\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT04: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=1404\r\nAlignmentHorz=0\r\nIndex=30\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT11: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=1404\r\nAlignmentHorz=0\r\nIndex=31\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT12: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=1404\r\nAlignmentHorz=0\r\nIndex=32\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT13: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=1404\r\nAlignmentHorz=0\r\nIndex=33\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT14: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=1404\r\nAlignmentHorz=0\r\nIndex=34\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT15: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=1404\r\nAlignmentHorz=0\r\nIndex=35\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewD01: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=130\r\nAlignmentHorz=0\r\nIndex=36\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewD03: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=130\r\nAlignmentHorz=0\r\nIndex=37\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewD04: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=130\r\nAlignmentHorz=0\r\nIndex=38\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewD05: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=130\r\nAlignmentHorz=0\r\nIndex=39\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCT3: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=704\r\nAlignmentHorz=0\r\nIndex=40\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCT4: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=704\r\nAlignmentHorz=0\r\nIndex=41\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCN2: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=74\r\nAlignmentHorz=1\r\nIndex=42\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCN3: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=74\r\nAlignmentHorz=1\r\nIndex=43\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCD1: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=130\r\nAlignmentHorz=0\r\nIndex=44\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCD2: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=130\r\nAlignmentHorz=0\r\nIndex=45\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCM1: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=74\r\nAlignmentHorz=0\r\nIndex=46\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n', '3');
INSERT INTO `cviews` VALUES ('消费', '[FormCustomerList.cxGridCustomerDBTableView: TcxGridDBTableView]\r\n=\r\nFooter=\"False\"\r\nGroupByBox=\"False\"\r\nGroupFooters=0\r\nNewItemRow=\"False\"\r\nVersion=1\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewID: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=24\r\nAlignmentHorz=0\r\nIndex=0\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewNAME: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=60\r\nAlignmentHorz=0\r\nIndex=1\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewPHONE: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=96\r\nAlignmentHorz=0\r\nIndex=2\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewPTYPE: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=74\r\nAlignmentHorz=1\r\nIndex=3\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewDIR: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=126\r\nAlignmentHorz=0\r\nIndex=4\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT02: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=50\r\nAlignmentHorz=0\r\nIndex=5\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT10: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=80\r\nAlignmentHorz=0\r\nIndex=6\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT01: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=100\r\nAlignmentHorz=0\r\nIndex=7\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewD02: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=77\r\nAlignmentHorz=0\r\nIndex=8\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT05: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=120\r\nAlignmentHorz=0\r\nIndex=9\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT06: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=102\r\nAlignmentHorz=0\r\nIndex=10\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT03: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=79\r\nAlignmentHorz=0\r\nIndex=11\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT09: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=200\r\nAlignmentHorz=0\r\nIndex=12\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewN05: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=93\r\nAlignmentHorz=1\r\nIndex=13\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewN04: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=103\r\nAlignmentHorz=1\r\nIndex=14\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewN02: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=83\r\nAlignmentHorz=1\r\nIndex=15\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewN03: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=73\r\nAlignmentHorz=1\r\nIndex=16\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewN01: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=65\r\nAlignmentHorz=1\r\nIndex=17\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT07: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=100\r\nAlignmentHorz=0\r\nIndex=18\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT08: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=100\r\nAlignmentHorz=0\r\nIndex=19\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCT1: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=82\r\nAlignmentHorz=0\r\nIndex=20\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCT2: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=80\r\nAlignmentHorz=0\r\nIndex=21\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCN1: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=74\r\nAlignmentHorz=1\r\nIndex=22\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewM01: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=446\r\nAlignmentHorz=0\r\nIndex=23\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewPATH: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=105\r\nAlignmentHorz=0\r\nIndex=24\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewOWNER: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=74\r\nAlignmentHorz=1\r\nIndex=25\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewTAG: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=3504\r\nAlignmentHorz=0\r\nIndex=26\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewTAG2: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=3504\r\nAlignmentHorz=0\r\nIndex=27\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCREATETIME: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=130\r\nAlignmentHorz=0\r\nIndex=28\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewUPDATETIME: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=130\r\nAlignmentHorz=0\r\nIndex=29\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT04: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=1404\r\nAlignmentHorz=0\r\nIndex=30\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT11: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=1404\r\nAlignmentHorz=0\r\nIndex=31\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT12: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=1404\r\nAlignmentHorz=0\r\nIndex=32\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT13: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=1404\r\nAlignmentHorz=0\r\nIndex=33\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT14: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=1404\r\nAlignmentHorz=0\r\nIndex=34\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT15: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=1404\r\nAlignmentHorz=0\r\nIndex=35\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewD01: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=130\r\nAlignmentHorz=0\r\nIndex=36\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewD03: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=130\r\nAlignmentHorz=0\r\nIndex=37\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewD04: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=130\r\nAlignmentHorz=0\r\nIndex=38\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewD05: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=130\r\nAlignmentHorz=0\r\nIndex=39\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCT3: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=704\r\nAlignmentHorz=0\r\nIndex=40\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCT4: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=704\r\nAlignmentHorz=0\r\nIndex=41\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCN2: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=74\r\nAlignmentHorz=1\r\nIndex=42\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCN3: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=74\r\nAlignmentHorz=1\r\nIndex=43\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCD1: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=130\r\nAlignmentHorz=0\r\nIndex=44\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCD2: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=130\r\nAlignmentHorz=0\r\nIndex=45\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCM1: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=74\r\nAlignmentHorz=0\r\nIndex=46\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n', '3');
INSERT INTO `cviews` VALUES ('简单', '[FormCustomerList.cxGridCustomerDBTableView: TcxGridDBTableView]\r\n=\r\nFooter=\"False\"\r\nGroupByBox=\"False\"\r\nGroupFooters=0\r\nNewItemRow=\"False\"\r\nVersion=1\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewID: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=24\r\nAlignmentHorz=0\r\nIndex=0\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewDIR: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=124\r\nAlignmentHorz=0\r\nIndex=1\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewNAME: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=60\r\nAlignmentHorz=0\r\nIndex=2\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewPHONE: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=96\r\nAlignmentHorz=0\r\nIndex=3\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewPTYPE: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=74\r\nAlignmentHorz=1\r\nIndex=4\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT02: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=50\r\nAlignmentHorz=0\r\nIndex=5\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT10: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=80\r\nAlignmentHorz=0\r\nIndex=6\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT01: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=100\r\nAlignmentHorz=0\r\nIndex=7\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewD02: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=55\r\nAlignmentHorz=0\r\nIndex=8\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT09: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=200\r\nAlignmentHorz=0\r\nIndex=9\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT05: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=120\r\nAlignmentHorz=0\r\nIndex=10\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT06: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=120\r\nAlignmentHorz=0\r\nIndex=11\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT03: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=45\r\nAlignmentHorz=0\r\nIndex=12\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewN05: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=75\r\nAlignmentHorz=1\r\nIndex=13\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewN04: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=75\r\nAlignmentHorz=1\r\nIndex=14\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewN02: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=55\r\nAlignmentHorz=1\r\nIndex=15\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewN03: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=55\r\nAlignmentHorz=1\r\nIndex=16\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewN01: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=55\r\nAlignmentHorz=1\r\nIndex=17\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT07: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=100\r\nAlignmentHorz=0\r\nIndex=18\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT08: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=100\r\nAlignmentHorz=0\r\nIndex=19\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCT1: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=82\r\nAlignmentHorz=0\r\nIndex=20\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCT2: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=80\r\nAlignmentHorz=0\r\nIndex=21\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCN1: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=74\r\nAlignmentHorz=1\r\nIndex=22\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewM01: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=446\r\nAlignmentHorz=0\r\nIndex=23\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewPATH: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=105\r\nAlignmentHorz=0\r\nIndex=24\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewOWNER: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=74\r\nAlignmentHorz=1\r\nIndex=25\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewTAG: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=3504\r\nAlignmentHorz=0\r\nIndex=26\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewTAG2: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=3504\r\nAlignmentHorz=0\r\nIndex=27\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCREATETIME: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=130\r\nAlignmentHorz=0\r\nIndex=28\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewUPDATETIME: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=130\r\nAlignmentHorz=0\r\nIndex=29\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT04: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=1404\r\nAlignmentHorz=0\r\nIndex=30\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT11: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=1404\r\nAlignmentHorz=0\r\nIndex=31\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT12: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=1404\r\nAlignmentHorz=0\r\nIndex=32\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT13: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=1404\r\nAlignmentHorz=0\r\nIndex=33\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT14: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=1404\r\nAlignmentHorz=0\r\nIndex=34\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT15: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=1404\r\nAlignmentHorz=0\r\nIndex=35\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewD01: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=130\r\nAlignmentHorz=0\r\nIndex=36\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewD03: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=130\r\nAlignmentHorz=0\r\nIndex=37\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewD04: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=130\r\nAlignmentHorz=0\r\nIndex=38\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewD05: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=130\r\nAlignmentHorz=0\r\nIndex=39\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCT3: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=704\r\nAlignmentHorz=0\r\nIndex=40\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCT4: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=704\r\nAlignmentHorz=0\r\nIndex=41\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCN2: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=74\r\nAlignmentHorz=1\r\nIndex=42\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCN3: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=74\r\nAlignmentHorz=1\r\nIndex=43\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCD1: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=130\r\nAlignmentHorz=0\r\nIndex=44\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCD2: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=130\r\nAlignmentHorz=0\r\nIndex=45\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCM1: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=74\r\nAlignmentHorz=0\r\nIndex=46\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n', '4');
INSERT INTO `cviews` VALUES ('全部', '[FormCustomerList.cxGridCustomerDBTableView: TcxGridDBTableView]\r\n=\r\nFooter=\"False\"\r\nGroupByBox=\"False\"\r\nGroupFooters=0\r\nNewItemRow=\"False\"\r\nVersion=1\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewID: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=24\r\nAlignmentHorz=0\r\nIndex=0\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewDIR: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=106\r\nAlignmentHorz=0\r\nIndex=1\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewNAME: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=60\r\nAlignmentHorz=0\r\nIndex=2\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewPHONE: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=96\r\nAlignmentHorz=0\r\nIndex=3\r\nVisible=\"True\"\r\nSortOrder=\"soDescending\"\r\nSortIndex=0\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewPTYPE: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=74\r\nAlignmentHorz=1\r\nIndex=4\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT02: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=50\r\nAlignmentHorz=0\r\nIndex=5\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT10: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=80\r\nAlignmentHorz=0\r\nIndex=6\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT01: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=100\r\nAlignmentHorz=0\r\nIndex=7\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewD02: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=79\r\nAlignmentHorz=0\r\nIndex=8\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT09: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=200\r\nAlignmentHorz=0\r\nIndex=9\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT05: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=120\r\nAlignmentHorz=0\r\nIndex=10\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT06: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=120\r\nAlignmentHorz=0\r\nIndex=11\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT03: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=93\r\nAlignmentHorz=0\r\nIndex=12\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewN05: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=78\r\nAlignmentHorz=1\r\nIndex=13\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewN04: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=78\r\nAlignmentHorz=1\r\nIndex=14\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewN02: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=62\r\nAlignmentHorz=1\r\nIndex=15\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewN03: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=72\r\nAlignmentHorz=1\r\nIndex=16\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewN01: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=54\r\nAlignmentHorz=1\r\nIndex=17\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT07: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=100\r\nAlignmentHorz=0\r\nIndex=18\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT08: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=100\r\nAlignmentHorz=0\r\nIndex=19\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCT1: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=82\r\nAlignmentHorz=0\r\nIndex=20\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCT2: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=80\r\nAlignmentHorz=0\r\nIndex=21\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCN1: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=74\r\nAlignmentHorz=1\r\nIndex=22\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewM01: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=446\r\nAlignmentHorz=0\r\nIndex=23\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewPATH: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=105\r\nAlignmentHorz=0\r\nIndex=24\r\nVisible=\"True\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewOWNER: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=74\r\nAlignmentHorz=1\r\nIndex=25\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewTAG: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=3504\r\nAlignmentHorz=0\r\nIndex=26\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewTAG2: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=3504\r\nAlignmentHorz=0\r\nIndex=27\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCREATETIME: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=130\r\nAlignmentHorz=0\r\nIndex=28\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewUPDATETIME: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=130\r\nAlignmentHorz=0\r\nIndex=29\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT04: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=1404\r\nAlignmentHorz=0\r\nIndex=30\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT11: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=1404\r\nAlignmentHorz=0\r\nIndex=31\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT12: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=1404\r\nAlignmentHorz=0\r\nIndex=32\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT13: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=1404\r\nAlignmentHorz=0\r\nIndex=33\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT14: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=1404\r\nAlignmentHorz=0\r\nIndex=34\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewT15: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=1404\r\nAlignmentHorz=0\r\nIndex=35\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewD01: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=130\r\nAlignmentHorz=0\r\nIndex=36\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewD03: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=130\r\nAlignmentHorz=0\r\nIndex=37\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewD04: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=130\r\nAlignmentHorz=0\r\nIndex=38\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewD05: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=130\r\nAlignmentHorz=0\r\nIndex=39\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCT3: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=704\r\nAlignmentHorz=0\r\nIndex=40\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCT4: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=704\r\nAlignmentHorz=0\r\nIndex=41\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCN2: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=74\r\nAlignmentHorz=1\r\nIndex=42\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCN3: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=74\r\nAlignmentHorz=1\r\nIndex=43\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCD1: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=130\r\nAlignmentHorz=0\r\nIndex=44\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCD2: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=130\r\nAlignmentHorz=0\r\nIndex=45\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n[FormCustomerList.cxGridCustomerDBTableView/cxGridCustomerDBTableViewCM1: TcxGridDBColumn]\r\n=\r\nGroupIndex=-1\r\nWidth=74\r\nAlignmentHorz=0\r\nIndex=46\r\nVisible=\"False\"\r\nSortOrder=\"soNone\"\r\nSortIndex=-1\r\nWasVisibleBeforeGrouping=\"False\"\r\n\r\n', '2');

-- ----------------------------
-- Table structure for `smsreceive`
-- ----------------------------
DROP TABLE IF EXISTS `smsreceive`;
CREATE TABLE `smsreceive` (
  `ID` varchar(100) NOT NULL,
  `SENDER` varchar(100) DEFAULT NULL,
  `TARGET` varchar(100) DEFAULT NULL,
  `CONTENT` varchar(200) DEFAULT NULL,
  `SENDTIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

-- ----------------------------
-- Records of smsreceive
-- ----------------------------

-- ----------------------------
-- Table structure for `smsrecord`
-- ----------------------------
DROP TABLE IF EXISTS `smsrecord`;
CREATE TABLE `smsrecord` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `SENDER` varchar(100) DEFAULT NULL,
  `STYPE` varchar(100) DEFAULT NULL,
  `NUMS` varchar(5000) DEFAULT NULL,
  `NCOUNT` int(11) DEFAULT '0',
  `MSG` varchar(500) DEFAULT NULL,
  `MCOUNT` int(11) DEFAULT '0',
  `SENDTIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `TRYTIMES` int(11) DEFAULT '0',
  `STATUS` varchar(100) DEFAULT NULL,
  `INFO` varchar(200) DEFAULT NULL,
  `TASKTARGET` varchar(100) DEFAULT NULL,
  `TASKID` varchar(100) DEFAULT NULL,
  `TASKTIME` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=gbk;

-- ----------------------------
-- Records of smsrecord
-- ----------------------------

-- ----------------------------
-- Table structure for `smstasks`
-- ----------------------------
DROP TABLE IF EXISTS `smstasks`;
CREATE TABLE `smstasks` (
  `ID` varchar(100) NOT NULL,
  `NAME` varchar(100) NOT NULL,
  `DTYPE` varchar(100) NOT NULL,
  `DMASK` varchar(100) DEFAULT NULL,
  `SENDTIME` varchar(100) NOT NULL,
  `MSG` varchar(500) NOT NULL,
  `TTYPE` varchar(100) NOT NULL,
  `TARGET` text,
  `FILTER` text,
  `NOTE` varchar(500) DEFAULT NULL,
  `STOP` int(11) DEFAULT '0',
  `DEF` int(11) DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

-- ----------------------------
-- Records of smstasks
-- ----------------------------
INSERT INTO `smstasks` VALUES ('A001', '生日祝福', '当天生日', null, '10:00:00', '亲爱的{姓名}，今天是您的生日，愿所有的快乐、所有的幸福、所有的温馨、所有的好运围绕在您身边。生日快乐！', '指定条件', '(累计积分 > 500)', null, null, '1', '0');
INSERT INTO `smstasks` VALUES ('A002', '元旦祝福', '每年(公历)', '01月01日', '10:00:00', '元旦来到，祝你在新年里：事业如日中天，心情阳光灿烂，工资地覆天翻，未来风光无限，爱情浪漫依然，快乐游戏人间。', '指定条件', null, null, null, '1', '0');

-- ----------------------------
-- Table structure for `users`
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `USERID` int(11) NOT NULL,
  `UNAME` varchar(100) DEFAULT NULL,
  `UTYPE` int(11) DEFAULT NULL,
  `PWD` varchar(200) DEFAULT NULL,
  `UPDATETIME` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `CORDER` varchar(100) DEFAULT NULL,
  `T01` varchar(200) DEFAULT NULL,
  `T02` varchar(200) DEFAULT NULL,
  `T03` varchar(200) DEFAULT NULL,
  `T04` varchar(200) DEFAULT NULL,
  `T05` varchar(200) DEFAULT NULL,
  `T06` varchar(200) DEFAULT NULL,
  `T07` varchar(200) DEFAULT NULL,
  `T08` varchar(200) DEFAULT NULL,
  `T09` varchar(200) DEFAULT NULL,
  `T10` varchar(200) DEFAULT NULL,
  `T11` varchar(200) DEFAULT NULL,
  `T12` varchar(200) DEFAULT NULL,
  `T13` varchar(200) DEFAULT NULL,
  `T14` varchar(200) DEFAULT NULL,
  `T15` varchar(200) DEFAULT NULL,
  `N01` double DEFAULT NULL,
  `N02` double DEFAULT NULL,
  `N03` double DEFAULT NULL,
  `N04` double DEFAULT NULL,
  `N05` double DEFAULT NULL,
  `D01` timestamp NULL DEFAULT NULL,
  `D02` timestamp NULL DEFAULT NULL,
  `D03` timestamp NULL DEFAULT NULL,
  `D04` timestamp NULL DEFAULT NULL,
  `D05` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`USERID`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES ('2094', '接口试用账号', '3', '76072ddfbf14ab5e8709c0c0e16d6412', '2009-10-09 11:00:36', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);

-- ----------------------------
-- Table structure for `zdts_data`
-- ----------------------------
DROP TABLE IF EXISTS `zdts_data`;
CREATE TABLE `zdts_data` (
  `RCID` varchar(100) NOT NULL,
  `RID` varchar(100) NOT NULL,
  `CTIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `CORDER` int(11) NOT NULL AUTO_INCREMENT,
  `CTYPE` int(11) NOT NULL,
  `SRC` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`CORDER`),
  UNIQUE KEY `ZDTS_DATA_PINDEX` (`RCID`,`RID`)
) ENGINE=MyISAM AUTO_INCREMENT=101 DEFAULT CHARSET=gbk;

-- ----------------------------
-- Records of zdts_data
-- ----------------------------

-- ----------------------------
-- Table structure for `zdts_variant`
-- ----------------------------
DROP TABLE IF EXISTS `zdts_variant`;
CREATE TABLE `zdts_variant` (
  `KEYNAME` varchar(40) NOT NULL,
  `KEYVALUE` varchar(100) NOT NULL,
  PRIMARY KEY (`KEYNAME`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

-- ----------------------------
-- Records of zdts_variant
-- ----------------------------

-- ----------------------------
-- View structure for `customer_path`
-- ----------------------------
DROP VIEW IF EXISTS `customer_path`;
CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `customer_path` AS select `a`.`DIR` AS `DIR`,concat('/',`a`.`NAME`) AS `Path` from `customerdir` `a` where (`a`.`DIR` = 1) union select `a`.`DIR` AS `DIR`,concat(concat('/',`b`.`NAME`),'/',`a`.`NAME`) AS `Path` from (`customerdir` `a` left join `customerdir` `b` on((`a`.`PARENT` = `b`.`DIR`))) where (`b`.`DIR` = 1) union select `a`.`DIR` AS `DIR`,concat(concat(concat('/',`c`.`NAME`),'/',`b`.`NAME`),'/',`a`.`NAME`) AS `Path` from ((`customerdir` `a` left join `customerdir` `b` on((`a`.`PARENT` = `b`.`DIR`))) left join `customerdir` `c` on((`b`.`PARENT` = `c`.`DIR`))) where (`c`.`DIR` = 1) union select `a`.`DIR` AS `DIR`,concat(concat(concat(concat('/',`d`.`NAME`),'/',`c`.`NAME`),'/',`b`.`NAME`),'/',`a`.`NAME`) AS `Path` from (((`customerdir` `a` left join `customerdir` `b` on((`a`.`PARENT` = `b`.`DIR`))) left join `customerdir` `c` on((`b`.`PARENT` = `c`.`DIR`))) left join `customerdir` `d` on((`c`.`PARENT` = `d`.`DIR`))) where (`d`.`DIR` = 1) union select `a`.`DIR` AS `DIR`,concat(concat(concat(concat(concat('/',`e`.`NAME`),'/',`d`.`NAME`),'/',`c`.`NAME`),'/',`b`.`NAME`),'/',`a`.`NAME`) AS `Path` from ((((`customerdir` `a` left join `customerdir` `b` on((`a`.`PARENT` = `b`.`DIR`))) left join `customerdir` `c` on((`b`.`PARENT` = `c`.`DIR`))) left join `customerdir` `d` on((`c`.`PARENT` = `d`.`DIR`))) left join `customerdir` `e` on((`d`.`PARENT` = `e`.`DIR`))) where (`e`.`DIR` = 1);

-- ----------------------------
-- Procedure structure for `ZPROC_RECORD`
-- ----------------------------
DROP PROCEDURE IF EXISTS `ZPROC_RECORD`;

CREATE PROCEDURE `ZPROC_RECORD`(
    in_rcid varchar(100),
    in_dataid varchar(100),
    in_type integer,
    in_time timestamp,    in_src varchar(100))
BEGIN
 delete from zdts_data where rid = in_dataid and rcid = in_rcid;
 insert into zdts_data(rcid,rid,ctime,ctype,src)
      values(in_rcid,in_dataid,in_time,in_type,in_src);
END;


CREATE TRIGGER `after_crecord_insert` AFTER INSERT ON `crecord` FOR EACH ROW begin
declare locktag integer default 0;

   select count(*)  into locktag from zdts_variant
       where keyname = 'locked.customer'  and keyvalue = 'yes';

   if (locktag = 0) then
      CALL  zproc_record('customer',cast(new.cid as char(100)),0,current_timestamp,cast(new.owner as char(100)));
   end if;

end;


CREATE TRIGGER `after_crecord_update` AFTER UPDATE ON `crecord` FOR EACH ROW begin
declare locktag integer default 0;

   select count(*)  into locktag from zdts_variant
       where keyname = 'locked.customer'  and keyvalue = 'yes';

   if (locktag = 0) then
      CALL  zproc_record('customer',cast(old.cid as char(100)),0,current_timestamp,cast(old.owner as char(100)));
   end if;

end;


CREATE TRIGGER `after_crecord_delete` AFTER DELETE ON `crecord` FOR EACH ROW begin
declare locktag integer default 0;

   select count(*)  into locktag from zdts_variant
       where keyname = 'locked.customer'  and keyvalue = 'yes';

   if (locktag = 0) then
      CALL  zproc_record('customer',cast(old.cid as char(100)),0,current_timestamp,cast(old.owner as char(100)));
   end if;

end;


CREATE TRIGGER `Before_customer_insert` BEFORE INSERT ON `customer` FOR EACH ROW begin
 set NEW.PATH = (Select PATH from customer_path where dir = NEW.dir);
end;


CREATE TRIGGER `after_customer_insert` AFTER INSERT ON `customer` FOR EACH ROW begin
declare locktag integer default 0;

   select count(*)  into locktag from zdts_variant
       where keyname = 'locked.customer'  and keyvalue = 'yes';

   if (locktag = 0) then
      CALL  zproc_record('customer',cast(new.id as char(100)),1,current_timestamp,cast(new.owner as char(100)));
   end if;

end;


CREATE TRIGGER `Before_customer_update` BEFORE UPDATE ON `customer` FOR EACH ROW begin
 set NEW.PATH = (Select PATH from customer_path where dir = NEW.dir);
end;


CREATE TRIGGER `after_customer_update` AFTER UPDATE ON `customer` FOR EACH ROW begin
declare locktag integer default 0;

   select count(*)  into locktag from zdts_variant
       where keyname = 'locked.customer'  and keyvalue = 'yes';

   if (locktag = 0) then
      CALL  zproc_record('customer',cast(old.id as char(100)),0,current_timestamp,cast(old.owner as char(100)));
   end if;

end;


CREATE TRIGGER `after_customer_delete` AFTER DELETE ON `customer` FOR EACH ROW begin
declare locktag integer default 0;

   select count(*)  into locktag from zdts_variant
       where keyname = 'locked.customer'  and keyvalue = 'yes';

   if (locktag = 0) then
      CALL  zproc_record('customer',cast(old.id as char(100)),-1,current_timestamp,cast(old.owner as char(100)));
   end if;

end;


CREATE TRIGGER `Before_dir_insert` BEFORE INSERT ON `customerdir` FOR EACH ROW begin
    set NEW.PATH =  concat(  (Select PATH from customer_path where dir = NEW.PARENT limit 1)  , '/' , NEW.name );
end;


CREATE TRIGGER `Before_dir_update` BEFORE UPDATE ON `customerdir` FOR EACH ROW begin
    set NEW.PATH =  concat(  (Select PATH from customer_path where dir = NEW.PARENT limit 1)  , '/' , NEW.name );
end;


CREATE TRIGGER `After_dir_update` AFTER UPDATE ON `customerdir` FOR EACH ROW begin
  update customer set dir = dir where dir = NEW.dir 
  or dir in (select a.dir from customerdir a where a.parent = NEW.dir
                or a.dir in (select b.dir from customerdir b where b.parent = NEW.dir
                               or b.dir in (select d.dir from customerdir d where d.parent = NEW.dir
                                     or d.dir in (select e.dir from customerdir e where e.parent = NEW.dir)
                                            )
                                ) 
                 );
  
end;


CREATE TRIGGER `After_dir_delete` AFTER DELETE ON `customerdir` FOR EACH ROW begin
  delete from customer  where dir = OLD.dir ;end;

