useful-qry/table-controls/테이블필드확인.sql

SELECT * FROM `dbr_company` WHERE email = 'opticlibre@naver.com';
SELECT * FROM `pro_member` WHERE email = 'opticlibre@naver.com';
SELECT * FROM `pro_member_ext` WHERE id = 168;

delete FROM `pro_member` WHERE email = 'dev1.dabory@gmail.com';
delete FROM `pro_member` WHERE email = 'dev1.dabory@gmail.com';
delete FROM `pro_member_ext` WHERE id = 149;

SELECT * FROM `dbr_company` WHERE email = 'dev1.dabory@gmail.com';
SELECT * FROM `pro_member` WHERE email = 'dev1.dabory@gmail.com';
SELECT * FROM `pro_member_ext` WHERE id = 149;

ALTER TABLE `dbr_user_menu` ADD `guest_app_id` INT(11) NOT NULL DEFAULT '0' AFTER `is_skipped`;

ALTER TABLE `bcs_circulatiing`
  CHANGE `circulatiing_supply` `circulating_supply` DECIMAL (34, 0) DEFAULT 0 NOT NULL;

RENAME TABLE `bcs_circulatiing` TO `bcs_circulating`;


ALTER TABLE `dbr_porder_bd` 
  ADD `memo` TEXT NULL DEFAULT NULL AFTER `confirm_date`,
  ADD `column2` varchar(69) DEFAULT NULL AFTER `confirm_date`,
  ADD `column1` varchar(69) DEFAULT NULL AFTER `confirm_date`;



delete FROM `dbr_setup` WHERE setup_code = 'office-info';
INSERT INTO dbr_setup (branch_id, setup_code, brand_code, setup_name, component, parameter, is_on_use, is_brand_select, setup_json )
VALUES (0, 'office-info', '', '사무실정보', 'popup-setup.form-a.office-info-form', '/popup-setup/form-a/office-info', '1', '0', '{\"OfcCode\":\"baeksan-optical\",\"OfcPlace\":\"2\",\"OfcName\":\"3\",\"OfcTaxNo\":\"4\",\"OfcEmail\":\"5\",\"OfcTelNo\":\"6\",\"OfcFaxNo\":\"7\",\"OfcMobile\":\"8\",\"OfcZipCode\":\"9\",\"OfcPresident\":\"10\",\"OfcAddress\":\"11\",\"OfcBizType\":\"12\",\"OfcDealItem\":\"13\"}');

update dbr_setup set component = 'popup-setup.form-a.media-library-form' where setup_code='media-body'


drop table if exists dbt_list_type1;
CREATE TABLE `dbt_list_type1` (
 `t_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 `id` int(10) unsigned DEFAULT NULL,
 `created_on` int(11) NOT NULL DEFAULT unix_timestamp(),
 `list_token` varchar(21) NOT NULL,
 `order_by` varchar(32) DEFAULT NULL,
 `c1` varchar(64) DEFAULT NULL,
 `c2` varchar(64) DEFAULT NULL,
 `c3` varchar(64) DEFAULT NULL,
 `c4` varchar(64) DEFAULT NULL,
 `c5` varchar(64) DEFAULT NULL,
 `c6` varchar(64) DEFAULT NULL,
 `c7` varchar(64) DEFAULT NULL,
 `c8` varchar(64) DEFAULT NULL,
 `c9` varchar(64) DEFAULT NULL,
 `c10` varchar(64) DEFAULT NULL,
 `c11` varchar(64) DEFAULT NULL,
 `c12` varchar(64) DEFAULT NULL,
 `c13` varchar(64) DEFAULT NULL,
 `c14` varchar(64) DEFAULT NULL,
 `c15` varchar(64) DEFAULT NULL,
 `c16` varchar(64) DEFAULT NULL,
 `c17` varchar(64) DEFAULT NULL,
 `c18` varchar(64) DEFAULT NULL,
 `c19` varchar(64) DEFAULT NULL,
 `c20` varchar(64) DEFAULT NULL,
 `d1` decimal(20,4) DEFAULT '0.0000',
 `d2` decimal(20,4) DEFAULT '0.0000',
 `d3` decimal(20,4) DEFAULT '0.0000',
 `d4` decimal(20,4) DEFAULT '0.0000',
 `d5` decimal(20,4) DEFAULT '0.0000',
 `d6` decimal(20,4) DEFAULT '0.0000',
 `d7` decimal(20,4) DEFAULT '0.0000',
 `d8` decimal(20,4) DEFAULT '0.0000',
 `d9` decimal(20,4) DEFAULT '0.0000',
 `d10` decimal(20,4) DEFAULT '0.0000',
 `is_sum` char(1) NOT NULL DEFAULT '0',
 `t1` mediumtext DEFAULT NULL,
 `t2` mediumtext DEFAULT NULL,
 UNIQUE KEY `tid` (`t_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2273 DEFAULT CHARSET=utf8mb4

drop table if exists cry_list1;
drop table if exists cry_list1_federated;

drop table if exists fed_crystal_host;
CREATE TABLE `fed_crystal_host` (
 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 `created_on` int(11) NOT NULL DEFAULT unix_timestamp(),
 `list_token` varchar(21) NOT NULL,
 `position` varchar(10) NOT NULL,
 `order_by` varchar(32) DEFAULT NULL,
 `c1` varchar(64) DEFAULT NULL,
 `c2` varchar(64) DEFAULT NULL,
 `c3` varchar(64) DEFAULT NULL,
 `c4` varchar(64) DEFAULT NULL,
 `c5` varchar(64) DEFAULT NULL,
 `c6` varchar(64) DEFAULT NULL,
 `c7` varchar(64) DEFAULT NULL,
 `c8` varchar(64) DEFAULT NULL,
 `c9` varchar(64) DEFAULT NULL,
 `c10` varchar(64) DEFAULT NULL,
 `c11` varchar(64) DEFAULT NULL,
 `c12` varchar(64) DEFAULT NULL,
 `c13` varchar(64) DEFAULT NULL,
 `c14` varchar(64) DEFAULT NULL,
 `c15` varchar(64) DEFAULT NULL,
 `c16` varchar(64) DEFAULT NULL,
 `c17` varchar(64) DEFAULT NULL,
 `c18` varchar(64) DEFAULT NULL,
 `c19` varchar(64) DEFAULT NULL,
 `c20` varchar(64) DEFAULT NULL,
 `d1` decimal(20,4) DEFAULT '0.0000',
 `d2` decimal(20,4) DEFAULT '0.0000',
 `d3` decimal(20,4) DEFAULT '0.0000',
 `d4` decimal(20,4) DEFAULT '0.0000',
 `d5` decimal(20,4) DEFAULT '0.0000',
 `d6` decimal(20,4) DEFAULT '0.0000',
 `d7` decimal(20,4) DEFAULT '0.0000',
 `d8` decimal(20,4) DEFAULT '0.0000',
 `d9` decimal(20,4) DEFAULT '0.0000',
 `d10` decimal(20,4) DEFAULT '0.0000',
 `is_sum` char(1) NOT NULL DEFAULT '0',
 `t1` mediumtext DEFAULT NULL,
 `t2` mediumtext DEFAULT NULL,
 UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

drop table if exists fed_office_host;
CREATE TABLE `fed_office_host` (
 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 `created_on` int(11) NOT NULL DEFAULT 123,
 `updated_on` int(11) NOT NULL DEFAULT 123,
 `ofc_code` varchar(21) NOT NULL,
 `ofc_place` varchar(128) DEFAULT NULL,
 `ofc_name` varchar(128) DEFAULT NULL,
 `fed_office_host` varchar(128) DEFAULT NULL,
 `ofc_tax_no` varchar(32) DEFAULT NULL,
 `ofc_email` varchar(128) DEFAULT NULL,
 `ofc_tel_no` varchar(16) DEFAULT NULL,
 `ofc_fax_no` varchar(16) DEFAULT NULL,
 `ofc_mobile` varchar(16) DEFAULT NULL,
 `ofc_zip_code` varchar(16) DEFAULT NULL,
 `ofc_president` varchar(64) DEFAULT NULL,
 `ofc_address` varchar(256) DEFAULT NULL,
 `ofc_biz_type` varchar(64) DEFAULT NULL,
 `ofc_deal_type` varchar(64) DEFAULT NULL,
 `sales_qty_point` tinyint(4) unsigned NOT NULL DEFAULT 0,
 `sales_prc_point` tinyint(4) unsigned NOT NULL DEFAULT 0,
 `sales_amt_point` tinyint(4) unsigned NOT NULL DEFAULT 0,
 `purch_qty_point` tinyint(4) unsigned NOT NULL DEFAULT 0,
 `purch_prc_point` tinyint(4) unsigned NOT NULL DEFAULT 0,
 `purch_amt_point` tinyint(4) unsigned NOT NULL DEFAULT 0,
 `stock_qty_point` tinyint(4) unsigned NOT NULL DEFAULT 0,
 `stock_prc_point` tinyint(4) unsigned NOT NULL DEFAULT 0,
 `stock_amt_point` tinyint(4) unsigned NOT NULL DEFAULT 0,
 `acc_amt_point` tinyint(4) unsigned NOT NULL DEFAULT 0,
 UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

drop table if exists fed_office_guest;
CREATE TABLE `fed_office_guest` (
 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 `created_on` int(11) NOT NULL DEFAULT 123,
 `updated_on` int(11) NOT NULL DEFAULT 123,
 `ofc_code` varchar(21) NOT NULL,
 `ofc_place` varchar(128) DEFAULT NULL,
 `ofc_name` varchar(128) DEFAULT NULL,
 `fed_office_host` varchar(128) DEFAULT NULL,
 `ofc_tax_no` varchar(32) DEFAULT NULL,
 `ofc_email` varchar(128) DEFAULT NULL,
 `ofc_tel_no` varchar(16) DEFAULT NULL,
 `ofc_fax_no` varchar(16) DEFAULT NULL,
 `ofc_mobile` varchar(16) DEFAULT NULL,
 `ofc_zip_code` varchar(16) DEFAULT NULL,
 `ofc_president` varchar(64) DEFAULT NULL,
 `ofc_address` varchar(256) DEFAULT NULL,
 `ofc_biz_type` varchar(64) DEFAULT NULL,
 `ofc_deal_type` varchar(64) DEFAULT NULL,
 `sales_qty_point` tinyint(4) unsigned NOT NULL DEFAULT 0,
 `sales_prc_point` tinyint(4) unsigned NOT NULL DEFAULT 0,
 `sales_amt_point` tinyint(4) unsigned NOT NULL DEFAULT 0,
 `purch_qty_point` tinyint(4) unsigned NOT NULL DEFAULT 0,
 `purch_prc_point` tinyint(4) unsigned NOT NULL DEFAULT 0,
 `purch_amt_point` tinyint(4) unsigned NOT NULL DEFAULT 0,
 `stock_qty_point` tinyint(4) unsigned NOT NULL DEFAULT 0,
 `stock_prc_point` tinyint(4) unsigned NOT NULL DEFAULT 0,
 `stock_amt_point` tinyint(4) unsigned NOT NULL DEFAULT 0,
 `acc_amt_point` tinyint(4) unsigned NOT NULL DEFAULT 0,
 UNIQUE KEY `id` (`id`)
) ENGINE = FEDERATED CONNECTION='mysql://symerp_db:8xFrHRymYxU@175.126.146.153:3306/crystalfed_db/fed_office_host';

) ENGINE = FEDERATED CONNECTION='mysql://weberp_db:nb7X94raSds@175.126.146.153:3306/crystalfed_db/fed_office_host';


drop table if exists fed_crystal_guest;
drop table if exists fed_office_guest;


drop table if exists zdb_optpos_contact_lens;


ALTER TABLE `dbr_sorder` ADD INDEX `sorder_date` (`sorder_date`);

ALTER TABLE `dbr_sgroup` ADD `Sort` CHAR(1) NOT NULL DEFAULT '0' AFTER `agroup_id`;
ALTER TABLE `dbr_sgroup` ADD `branch_id` INT(11) NOT NULL DEFAULT '0' AFTER `agroup_id`;


show create table bcs_circulating

ALTER TABLE 
	CHANGE `` * COMMENT '',
	CHANGE `` * COMMENT '';

drop table if exists dbr_acc_title;
CREATE TABLE `dbr_acc_title` (
 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 `created_on` bigint(20) DEFAULT 0,
 `updated_on` bigint(20) DEFAULT 0,
 `title_code` varchar(6) NOT NULL DEFAULT '' COMMENT '계정과목코드',
 `acc_dr_cr` tinyint(4) NOT NULL DEFAULT 3 COMMENT '차대변',
 `title_name` varchar(64) NOT NULL DEFAULT '' COMMENT '계정과목명',
 `atgroup_code` varchar(16) NOT NULL DEFAULT '' COMMENT '집합계정코드',
 `plus_minus` char(1) NOT NULL DEFAULT '0' COMMENT '증가차감',
 `is_chung` char(1) NOT NULL DEFAULT '0' COMMENT '충당금계정',
 `is_total` char(1) NOT NULL DEFAULT '0' COMMENT '합계계정',
 `is_import_cost` char(1) NOT NULL DEFAULT '0' COMMENT '수입비용계정',
 `level3_atgroup_code` varchar(16) NOT NULL DEFAULT '' COMMENT '3단계집합코드',
 `rep_title_code` varchar(16) NOT NULL DEFAULT '' COMMENT '대표계정코드',
 `is_acc_company` char(1) NOT NULL DEFAULT '0' COMMENT '회계업체존재',
 `is_skipped` char(1) NOT NULL DEFAULT '0' COMMENT '사용않음',
 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=306 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;




update users set created_on = 0, updated_on = 0 ;


drop table if exists dbr_sorder;
CREATE TABLE `dbr_sorder` (
 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 `created_on` bigint(20) DEFAULT 0,
 `updated_on` bigint(20) DEFAULT 0,
 `sorder_date` char(8) NOT NULL DEFAULT '',
 `sorder_no` varchar(21) DEFAULT NULL COMMENT '수주번호:자동채번',
 `squote_id` int(10) unsigned DEFAULT NULL,
 `deal_type_id` int(10) unsigned DEFAULT NULL COMMENT '거래구분:매출(00)-Default',
 `user_id` int(10) unsigned NOT NULL COMMENT '사용자 id:(5)Default',
 `sgroup_id` int(10) unsigned DEFAULT NULL COMMENT '영업구분:안경사',
 `sgroup2_id` int(10) unsigned DEFAULT NULL COMMENT '영업구분:판매사',
 `branch_id` int(10) unsigned DEFAULT NULL COMMENT '지점:본사(1)Default',
 `storage_id` int(10) unsigned DEFAULT NULL COMMENT '창고:본사(1)Default',
 `buyer_id` int(10) unsigned DEFAULT NULL COMMENT '고객id',
 `vat_rate_id` int(10) unsigned DEFAULT NULL COMMENT '부가세율:포함(1)Default,별도(0)',
 `project_id` int(10) NOT NULL DEFAULT 0,
 `buyer_contact` varchar(49) DEFAULT NULL COMMENT '고객담당자',
 `pay_terms` varchar(69) DEFAULT NULL COMMENT '지불조건',
 `pay_period` varchar(69) DEFAULT NULL COMMENT '지불기간',
 `destination` varchar(69) DEFAULT NULL COMMENT '도착지역',
 `delivery` varchar(69) DEFAULT NULL COMMENT '납기',
 `status` char(1) DEFAULT NULL COMMENT '상황:완료(3)',
 `situation` char(2) DEFAULT NULL COMMENT '안좋은 상황코드(claim등)',
 `is_closed` char(1) NOT NULL COMMENT '종결처리',
 `is_first_order` char(1) NOT NULL DEFAULT '0' COMMENT '고객의 첫번째 주문여부',
 `column1` varchar(69) DEFAULT NULL,
 `column2` varchar(69) DEFAULT NULL,
 `remarks` text DEFAULT NULL,
 `json1` text DEFAULT NULL COMMENT '검안내용',
 `json2` text DEFAULT NULL COMMENT '현재 사용하지 않음',
 `is_pro` char(1) NOT NULL DEFAULT '0' COMMENT '0:ERP주문, 1:온라인주문',
 `discount_amt` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT '할인금액',
 `ccard_amt` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT '신용카드결제액',
 `cash_amt` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT '현금결제액',
 `coupon_amt` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT '쿠폰결제액',
 `reward_amt` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT '적립금사용액',
 `credit_use_amt` decimal(20,4) NOT NULL DEFAULT 0.0000 COMMENT '충전금사용액',
 `is_locked` char(1) NOT NULL DEFAULT '0' COMMENT '정산완료(1)-수정불가',
 `ship_contact` varchar(64) DEFAULT NULL COMMENT '연락처명',
 `ship_mobile` varchar(21) DEFAULT NULL COMMENT '배송연락처번호',
 `ship_method` varchar(32) DEFAULT NULL COMMENT '배송방식',
 `ship_fee` decimal(20,4) DEFAULT 0.0000 COMMENT '배송비',
 `ship_zip_code` varchar(21) DEFAULT NULL COMMENT '우편번호',
 `ship_addr1` varchar(64) DEFAULT NULL COMMENT '주소1',
 `ship_addr2` varchar(64) DEFAULT NULL COMMENT '주소2',
 `ship_notes` varchar(64) DEFAULT NULL COMMENT '배송메모',
 `paymethod` char(2) NOT NULL DEFAULT '0' COMMENT '결재방식',
 `remit_account` varchar(64) DEFAULT NULL COMMENT '송금받는계좌',
 `remit_name` varchar(32) DEFAULT NULL COMMENT '무통장입금자명',
 `ip` varchar(20) DEFAULT NULL,
 PRIMARY KEY (`id`),
 UNIQUE KEY `sorder_no` (`sorder_no`),
 KEY `sorder_date` (`sorder_date`),
 KEY `squote_id` (`squote_id`),
 KEY `deal_type_id` (`deal_type_id`),
 KEY `user_id` (`user_id`),
 KEY `sgroup_id` (`sgroup_id`),
 KEY `sgroup2_id` (`sgroup2_id`),
 KEY `branch_id` (`branch_id`),
 KEY `storage_id` (`storage_id`),
 KEY `buyer_id` (`buyer_id`),
 KEY `vat_rate_id` (`vat_rate_id`),
 KEY `project_id` (`project_id`),
 KEY `mdx_buyer_date` (`buyer_id`,`sorder_date`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=100012 DEFAULT CHARSET=utf8mb4;

REPLACE INTO dbr_media
    (id, media_no, media_date, user_id, branch_id, media_brand, media_name)
VALUES
    (1, '200101-0000', '20000101', 5, 1, 'image', 'blank_image');

REPLACE INTO dbr_media_bd (id,  media_id, seq_no, image_type) VALUES (1, 1, 1, 'big');
REPLACE INTO dbr_media_bd (id,  media_id, seq_no, image_type) VALUES (2, 1, 2, 'middle');
REPLACE INTO dbr_media_bd (id,  media_id, seq_no, image_type) VALUES (3, 1, 3, 'thumb');

REPLACE INTO users
    (id, email, password, activate_code, reset_code, nick_name, first_name, sur_name)
VALUES
    (1, MD5(RAND()), 'unlinked', 'unlinked', 'unlinked', 'unlinked', 'unlinked', 'unlinked');

REPLACE INTO dbr_user_ext
    (id, mobile_no, phone_no, user_perm_id, menu_lang_sw,
    sgroup_id, branch_id, storage_id, agroup_id, country_code, is_expired)
VALUES
    (1, 'unlinked', 'unlinked', 7, 0, 
    1, 1, 1, 1, 'ko_KR', '0');

REPLACE INTO pro_member
    (id, email, password, activate_code, reset_code, nick_name, first_name, sur_name)
VALUES
    (1, MD5(RAND()), 'unlinked', 'unlinked', 'unlinked', 'unlinked', 'unlinked', 'unlinked');

    ALTER TABLE `pro_member_ext` CHANGE `created_on` `created_on` BIGINT(11) NOT NULL DEFAULT '0';
    ALTER TABLE `pro_member_ext` CHANGE `updated_on` `updated_on` BIGINT(11) NOT NULL DEFAULT '0';

REPLACE INTO pro_member_ext
    (id, mobile_no, phone_no, member_perm_id, menu_lang_sw,
    sgroup_id, branch_id, storage_id, agroup_id, country_code, is_expired)
VALUES
    (1, 'unlinked', 'unlinked', 7, 0, 
    1, 1, 1, 1, 'ko_KR', '0');

REPLACE INTO pro_seo_meta (id,  join_duid) VALUES (1, '1')


drop table if exists dbt_list_sum;
CREATE TABLE `dbt_list_sum` (
 `t_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 `h_id` int(11) NOT NULL DEFAULT 0 COMMENT '전표 Header id',
 `id` int(10) unsigned DEFAULT NULL,
 `created_on` bigint(20) DEFAULT 0,
 `list_token` varchar(21) NOT NULL,
 `order_by` varchar(64) DEFAULT NULL,
 `c1` varchar(64) DEFAULT NULL,
 `c2` varchar(64) DEFAULT NULL,
 `c3` varchar(64) DEFAULT NULL,
 `c4` varchar(64) DEFAULT NULL,
 `c5` varchar(64) DEFAULT NULL,
 `c6` varchar(64) DEFAULT NULL,
 `c7` varchar(64) DEFAULT NULL,
 `c8` varchar(64) DEFAULT NULL,
 `c9` varchar(64) DEFAULT NULL,
 `c10` varchar(64) DEFAULT NULL,
 `c11` varchar(64) DEFAULT NULL,
 `c12` varchar(64) DEFAULT NULL,
 `c13` varchar(64) DEFAULT NULL,
 `c14` varchar(64) DEFAULT NULL,
 `c15` varchar(64) DEFAULT NULL,
 `c16` varchar(64) DEFAULT NULL,
 `c17` varchar(64) DEFAULT NULL,
 `c18` varchar(64) DEFAULT NULL,
 `c19` varchar(64) DEFAULT NULL,
 `c20` varchar(64) DEFAULT NULL,
 `d1` decimal(20,4) DEFAULT 0.0000,
 `d2` decimal(20,4) DEFAULT 0.0000,
 `d3` decimal(20,4) DEFAULT 0.0000,
 `d4` decimal(20,4) DEFAULT 0.0000,
 `d5` decimal(20,4) DEFAULT 0.0000,
 `d6` decimal(20,4) DEFAULT 0.0000,
 `d7` decimal(20,4) DEFAULT 0.0000,
 `d8` decimal(20,4) DEFAULT 0.0000,
 `d9` decimal(20,4) DEFAULT 0.0000,
 `d10` decimal(20,4) DEFAULT 0.0000,
 `is_sum` char(1) NOT NULL DEFAULT '0',
 `t1` mediumtext DEFAULT NULL,
 `t2` mediumtext DEFAULT NULL,
 UNIQUE KEY `tid` (`t_id`)
) ENGINE=MyISAM AUTO_INCREMENT=360 DEFAULT CHARSET=utf8mb4


[ssohost pre-process]
drop table if exists crm_account;
CREATE TABLE `crm_account` (
 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 `created_on` bigint(11) NOT NULL,
 `updated_on` bigint(11) NOT NULL,
 `buyer_id` int(10) unsigned NOT NULL,
 `account_name` varchar(64) NOT NULL,
 `str0` varchar(64) DEFAULT NULL,
 `str1` varchar(64) DEFAULT NULL,
 `str2` varchar(64) DEFAULT NULL,
 `str3` varchar(64) DEFAULT NULL,
 `str4` varchar(64) DEFAULT NULL,
 `str5` varchar(64) DEFAULT NULL,
 `str6` varchar(64) DEFAULT NULL,
 `str7` varchar(64) DEFAULT NULL,
 `str8` varchar(64) DEFAULT NULL,
 `str9` varchar(64) DEFAULT NULL,
 `rng0` varchar(64) DEFAULT NULL,
 `rng1` varchar(64) DEFAULT NULL,
 `rng2` varchar(64) DEFAULT NULL,
 `rng3` varchar(64) DEFAULT NULL,
 `rng4` varchar(64) DEFAULT NULL,
 `rng5` varchar(64) DEFAULT NULL,
 `rng6` varchar(64) DEFAULT NULL,
 `rng7` varchar(64) DEFAULT NULL,
 `rng8` varchar(64) DEFAULT NULL,
 `rng9` varchar(64) DEFAULT NULL,
 `dec0` decimal(20,4) DEFAULT 0.0000,
 `dec1` decimal(20,4) DEFAULT 0.0000,
 `dec2` decimal(20,4) DEFAULT 0.0000,
 `dec3` decimal(20,4) DEFAULT 0.0000,
 `dec4` decimal(20,4) DEFAULT 0.0000,
 `dec5` decimal(20,4) DEFAULT 0.0000,
 `dec6` decimal(20,4) DEFAULT 0.0000,
 `dec7` decimal(20,4) DEFAULT 0.0000,
 `dec8` decimal(20,4) DEFAULT 0.0000,
 `dec9` decimal(20,4) DEFAULT 0.0000,
 `chk0_opt0` char(1) DEFAULT '0',
 `chk0_opt1` char(1) DEFAULT '0',
 `chk0_opt2` char(1) DEFAULT '0',
 `chk0_opt3` char(1) DEFAULT '0',
 `chk0_opt4` char(1) DEFAULT '0',
 `chk1_opt0` char(1) DEFAULT '0',
 `chk1_opt1` char(1) DEFAULT '0',
 `chk1_opt2` char(1) DEFAULT '0',
 `chk1_opt3` char(1) DEFAULT '0',
 `chk1_opt4` char(1) DEFAULT '0',
 `chk2_opt0` char(1) DEFAULT '0',
 `chk2_opt1` char(1) DEFAULT '0',
 `chk2_opt2` char(1) DEFAULT '0',
 `chk2_opt3` char(1) DEFAULT '0',
 `chk2_opt4` char(1) DEFAULT '0',
 `chk3_opt0` char(1) DEFAULT '0',
 `chk3_opt1` char(1) DEFAULT '0',
 `chk3_opt2` char(1) DEFAULT '0',
 `chk3_opt3` char(1) DEFAULT '0',
 `chk3_opt4` char(1) DEFAULT '0',
 `chk4_opt0` char(1) DEFAULT '0',
 `chk4_opt1` char(1) DEFAULT '0',
 `chk4_opt2` char(1) DEFAULT '0',
 `chk4_opt3` char(1) DEFAULT '0',
 `chk4_opt4` char(1) DEFAULT '0',
 `chk5_opt0` char(1) DEFAULT '0',
 `chk5_opt1` char(1) DEFAULT '0',
 `chk5_opt2` char(1) DEFAULT '0',
 `chk5_opt3` char(1) DEFAULT '0',
 `chk5_opt4` char(1) DEFAULT '0',
 `chk6_opt0` char(1) DEFAULT '0',
 `chk6_opt1` char(1) DEFAULT '0',
 `chk6_opt2` char(1) DEFAULT '0',
 `chk6_opt3` char(1) DEFAULT '0',
 `chk6_opt4` char(1) DEFAULT '0',
 `chk7_opt0` char(1) DEFAULT '0',
 `chk7_opt1` char(1) DEFAULT '0',
 `chk7_opt2` char(1) DEFAULT '0',
 `chk7_opt3` char(1) DEFAULT '0',
 `chk7_opt4` char(1) DEFAULT '0',
 `chk8_opt0` char(1) DEFAULT '0',
 `chk8_opt1` char(1) DEFAULT '0',
 `chk8_opt2` char(1) DEFAULT '0',
 `chk8_opt3` char(1) DEFAULT '0',
 `chk8_opt4` char(1) DEFAULT '0',
 `chk9_opt0` char(1) DEFAULT '0',
 `chk9_opt1` char(1) DEFAULT '0',
 `chk9_opt2` char(1) DEFAULT '0',
 `chk9_opt3` char(1) DEFAULT '0',
 `chk9_opt4` char(1) DEFAULT '0',
 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=104 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

drop table if exists crm_account_item;
CREATE TABLE `crm_account_item` (
 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 `created_on` bigint(11) NOT NULL,
 `updated_on` bigint(11) NOT NULL,
 `account_id` int(10) unsigned NOT NULL,
 `item_name` varchar(64) DEFAULT NULL,
 `str0` varchar(64) DEFAULT NULL,
 `str1` varchar(64) DEFAULT NULL,
 `str2` varchar(64) DEFAULT NULL,
 `str3` varchar(64) DEFAULT NULL,
 `str4` varchar(64) DEFAULT NULL,
 `str5` varchar(64) DEFAULT NULL,
 `str6` varchar(64) DEFAULT NULL,
 `str7` varchar(64) DEFAULT NULL,
 `str8` varchar(64) DEFAULT NULL,
 `str9` varchar(64) DEFAULT NULL,
 `rng0` varchar(64) DEFAULT NULL,
 `rng1` varchar(64) DEFAULT NULL,
 `rng2` varchar(64) DEFAULT NULL,
 `rng3` varchar(64) DEFAULT NULL,
 `rng4` varchar(64) DEFAULT NULL,
 `rng5` varchar(64) DEFAULT NULL,
 `rng6` varchar(64) DEFAULT NULL,
 `rng7` varchar(64) DEFAULT NULL,
 `rng8` varchar(64) DEFAULT NULL,
 `rng9` varchar(64) DEFAULT NULL,
 `dec0` decimal(20,4) DEFAULT 0.0000,
 `dec1` decimal(20,4) DEFAULT 0.0000,
 `dec2` decimal(20,4) DEFAULT 0.0000,
 `dec3` decimal(20,4) DEFAULT 0.0000,
 `dec4` decimal(20,4) DEFAULT 0.0000,
 `dec5` decimal(20,4) DEFAULT 0.0000,
 `dec6` decimal(20,4) DEFAULT 0.0000,
 `dec7` decimal(20,4) DEFAULT 0.0000,
 `dec8` decimal(20,4) DEFAULT 0.0000,
 `dec9` decimal(20,4) DEFAULT 0.0000,
 `chk0_opt0` char(1) DEFAULT '0',
 `chk0_opt1` char(1) DEFAULT '0',
 `chk0_opt2` char(1) DEFAULT '0',
 `chk0_opt3` char(1) DEFAULT '0',
 `chk0_opt4` char(1) DEFAULT '0',
 `chk1_opt0` char(1) DEFAULT '0',
 `chk1_opt1` char(1) DEFAULT '0',
 `chk1_opt2` char(1) DEFAULT '0',
 `chk1_opt3` char(1) DEFAULT '0',
 `chk1_opt4` char(1) DEFAULT '0',
 `chk2_opt0` char(1) DEFAULT '0',
 `chk2_opt1` char(1) DEFAULT '0',
 `chk2_opt2` char(1) DEFAULT '0',
 `chk2_opt3` char(1) DEFAULT '0',
 `chk2_opt4` char(1) DEFAULT '0',
 `chk3_opt0` char(1) DEFAULT '0',
 `chk3_opt1` char(1) DEFAULT '0',
 `chk3_opt2` char(1) DEFAULT '0',
 `chk3_opt3` char(1) DEFAULT '0',
 `chk3_opt4` char(1) DEFAULT '0',
 `chk4_opt0` char(1) DEFAULT '0',
 `chk4_opt1` char(1) DEFAULT '0',
 `chk4_opt2` char(1) DEFAULT '0',
 `chk4_opt3` char(1) DEFAULT '0',
 `chk4_opt4` char(1) DEFAULT '0',
 `chk5_opt0` char(1) DEFAULT '0',
 `chk5_opt1` char(1) DEFAULT '0',
 `chk5_opt2` char(1) DEFAULT '0',
 `chk5_opt3` char(1) DEFAULT '0',
 `chk5_opt4` char(1) DEFAULT '0',
 `chk6_opt0` char(1) DEFAULT '0',
 `chk6_opt1` char(1) DEFAULT '0',
 `chk6_opt2` char(1) DEFAULT '0',
 `chk6_opt3` char(1) DEFAULT '0',
 `chk6_opt4` char(1) DEFAULT '0',
 `chk7_opt0` char(1) DEFAULT '0',
 `chk7_opt1` char(1) DEFAULT '0',
 `chk7_opt2` char(1) DEFAULT '0',
 `chk7_opt3` char(1) DEFAULT '0',
 `chk7_opt4` char(1) DEFAULT '0',
 `chk8_opt0` char(1) DEFAULT '0',
 `chk8_opt1` char(1) DEFAULT '0',
 `chk8_opt2` char(1) DEFAULT '0',
 `chk8_opt3` char(1) DEFAULT '0',
 `chk8_opt4` char(1) DEFAULT '0',
 `chk9_opt0` char(1) DEFAULT '0',
 `chk9_opt1` char(1) DEFAULT '0',
 `chk9_opt2` char(1) DEFAULT '0',
 `chk9_opt3` char(1) DEFAULT '0',
 `chk9_opt4` char(1) DEFAULT '0',
 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO pro_item_revsum ( id, created_on, updated_on)
SELECT id, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()
FROM dbr_item
where 1;