update DRG Grouper 6.2.1 สิทธิ OFC , LGO ,SSS date_start '2018-01-01'

---

/* update DRG Grouper 6.2.1 สิทธิ OFC , LGO ,SSS date_start '2018-01-01' */
DROP TABLE IF EXISTS pttype_grouper;
CREATE TABLE `pttype_grouper` (
`pttype_grouper_id` int(11) NOT NULL DEFAULT 0 ,
`pttype` char(2) CHARACTER SET tis620 COLLATE tis620_thai_ci NULL DEFAULT NULL ,
`begin_date` date NULL DEFAULT NULL ,
`end_date` date NULL DEFAULT NULL ,
`grouper_major_version` int(11) NULL DEFAULT NULL ,
`grouper_minor_version` int(11) NULL DEFAULT NULL ,
PRIMARY KEY (`pttype_grouper_id`),
INDEX `ix_pttype` (`pttype`) USING BTREE
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=tis620 COLLATE=tis620_thai_ci
CHECKSUM=0
ROW_FORMAT=FIXED
DELAY_KEY_WRITE=0
;

REPLACE INTO pttype_grouper
SELECT @row:=@row+1 AS pttype_grouper_id,
pttype,
'2018-01-01' AS begin_date,
'2028-01-01' AS end_date,
'6205' AS grouper_major_version,
NULL AS grouper_minor_version
FROM pttype ,(SELECT @row:=0) AS r
WHERE pttype_spp_id IN(1,2);

---