CREATE TABLE IF NOT EXISTS TS_NUVOTON_SELECTION_GUIDE_FIELDS (TABLE_NAME TEXT NOT NULL,TABLE_COLUMN TEXT NOT NULL,SHOW_COLUMN TEXT NOT NULL);DELETE FROM TS_NUVOTON_SELECTION_GUIDE_FIELDS;INSERT INTO TS_NUVOTON_SELECTION_GUIDE_FIELDS (TABLE_NAME,TABLE_COLUMN,SHOW_COLUMN) VALUES ('TS_NUVOTON_SELECTION_GUIDE_S15','ADC','ADC');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_FIELDS (TABLE_NAME,TABLE_COLUMN,SHOW_COLUMN) VALUES ('TS_NUVOTON_SELECTION_GUIDE_S15','DataFlash','Data
 Flash');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_FIELDS (TABLE_NAME,TABLE_COLUMN,SHOW_COLUMN) VALUES ('TS_NUVOTON_SELECTION_GUIDE_S15','Flash','Flash');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_FIELDS (TABLE_NAME,TABLE_COLUMN,SHOW_COLUMN) VALUES ('TS_NUVOTON_SELECTION_GUIDE_S15','I2C','I2C');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_FIELDS (TABLE_NAME,TABLE_COLUMN,SHOW_COLUMN) VALUES ('TS_NUVOTON_SELECTION_GUIDE_S15','IO','I/O');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_FIELDS (TABLE_NAME,TABLE_COLUMN,SHOW_COLUMN) VALUES ('TS_NUVOTON_SELECTION_GUIDE_S15','ISPICPIAP','ISP
/ICP
/IAP');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_FIELDS (TABLE_NAME,TABLE_COLUMN,SHOW_COLUMN) VALUES ('TS_NUVOTON_SELECTION_GUIDE_S15','Package','Package');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_FIELDS (TABLE_NAME,TABLE_COLUMN,SHOW_COLUMN) VALUES ('TS_NUVOTON_SELECTION_GUIDE_S15','PWM','PWM');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_FIELDS (TABLE_NAME,TABLE_COLUMN,SHOW_COLUMN) VALUES ('TS_NUVOTON_SELECTION_GUIDE_S15','SPI','SPI');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_FIELDS (TABLE_NAME,TABLE_COLUMN,SHOW_COLUMN) VALUES ('TS_NUVOTON_SELECTION_GUIDE_S15','SRAM','SRAM');CREATE TABLE IF NOT EXISTS TS_NUVOTON_SELECTION_GUIDE_MAIN (TABLE_NAME TEXT NOT NULL,FAMILY TEXT NOT NULL);DELETE FROM TS_NUVOTON_SELECTION_GUIDE_MAIN;INSERT INTO TS_NUVOTON_SELECTION_GUIDE_MAIN (TABLE_NAME,FAMILY) VALUES ('TS_NUVOTON_SELECTION_GUIDE_S15','8bit 8051 MCUs');CREATE TABLE IF NOT EXISTS TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO TEXT NOT NULL,ADC TEXT,DataFlash TEXT,Flash TEXT,I2C TEXT,IO TEXT,ISPICPIAP TEXT,Package TEXT,PWM TEXT,SPI TEXT,SRAM TEXT);DELETE FROM TS_NUVOTON_SELECTION_GUIDE_S15;INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('ML51BB9AE','2','Configurable','16K','2','7','ISP,ICP,IAP','MSOP10','6*16-bit','1','1K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('ML51DB9AE','3','Configurable','16K','2','11','ISP,ICP,IAP','TSSOP14','6*16-bit','1','1K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('ML51EB9AE','8','Configurable','16K','2','24','ISP,ICP,IAP','TSSOP28','6*16-bit','1','1K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('ML51EC0AE','8','Configurable','32K','2','24','ISP,ICP,IAP','TSSOP28','6*16-bit','2','2K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('ML51FB9AE','6','Configurable','16K','2','16','ISP,ICP,IAP','TSSOP20','6*16-bit','1','1K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('ML51LD1AE','10','Configurable','64K','2','43','ISP,ICP,IAP','LQFP48','12*16-bit','2','4K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('ML51OB9AE','6','Configurable','16K','2','16','ISP,ICP,IAP','SOP20','6*16-bit','1','1K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('ML51PB9AE','8','Configurable','16K','2','24','ISP,ICP,IAP','LQFP32','6*16-bit','2','1K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('ML51PC0AE','8','Configurable','32K','2','28','ISP,ICP,IAP','LQFP32','6*16-bit','2','2K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('ML51SD1AE','14','Configurable','64K','2','56','ISP,ICP,IAP','LQFP64','12*16-bit','2','4K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('ML51TB9AE','8','Configurable','16K','2','28','ISP,ICP,IAP','QFN33','6*16-bit','2','1K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('ML51TC0AE','8','Configurable','32K','2','28','ISP,ICP,IAP','QFN33','6*16-bit','2','2K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('ML51TD1AE','9','Configurable','64K','2','28','ISP,ICP,IAP','QFN33','12*16-bit','2','4K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('ML51UB9AE','8','Configurable','16K','2','24','ISP,ICP,IAP','SOP28','6*16-bit','1','1K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('ML51UC0AE','8','Configurable','32K','2','24','ISP,ICP,IAP','SOP28','6*16-bit','2','2K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('ML51XB9AE','6','Configurable','16K','2','17','ISP,ICP,IAP','QFN20','6*16-bit','1','1K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('ML54LD1AE','10','Configurable','64K','2','42','ISP,ICP,IAP','LQFP48','12*16-bit','2','4K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('ML54MD1AE','10','Configurable','64K','2','38','ISP,ICP,IAP','LQFP44','12*16-bit','2','4K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('ML54SD1AE','14','Configurable','64K','2','55','ISP,ICP,IAP','LQFP64','12*16-bit','2','4K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('ML56LD1AE','10','Configurable','64K','2','42','ISP,ICP,IAP','LQFP48','12*16-bit','2','4K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('ML56MD1AE','10','Configurable','64K','2','38','ISP,ICP,IAP','LQFP44','12*16-bit','2','4K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('ML56SD1AE','14','Configurable','64K','2','55','ISP,ICP,IAP','LQFP64','12*16-bit','2','4K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('MS51BA9AE','4','Configurable','8K','1','8','ISP,ICP,IAP','MSOP10','6*16-bit','0','1K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('MS51DA9AE','5','Configurable','8K','1','12','ISP,ICP,IAP','TSSOP14','6*16-bit','1','1K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('MS51EC0AE','15','Configurable','32K','1','26','ISP,ICP,IAP','TSSOP28','12*16-bit','1','2K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('MS51FB9AE','8','Configurable','16K','1','18','ISP,ICP,IAP','TSSOP20','6*16-bit','1','1K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('MS51FC0AE','10','Configurable','32K','1','18','ISP,ICP,IAP','TSSOP20','10*16-bit','1','2K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('MS51PC0AE','15','Configurable','32K','1','30','ISP,ICP,IAP','LQFP32','12*16-bit','1','2K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('MS51TC0AE','15','Configurable','32K','1','30','ISP,ICP,IAP','QFN33','12*16-bit','1','2K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('MS51XB9AE','8','Configurable','16K','1','18','ISP,ICP,IAP','QFN20','6*16-bit','1','1K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('MS51XC0BE','10','Configurable','32K','1','18','ISP,ICP,IAP','QFN20','10*16-bit','1','2K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('MUG51TB9AE','-','Configurable','16K','2','24','ISP,ICP,IAP','QFN33','6*16-bit','1','1K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('N76E003','8*12-bit','Configurable','18K','1','18','ISP,ICP,IAP','TSSOP20/QFN20','6*16-bit','1','1K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('N76E616','10*10-bit','Configurable','18K','1','26','ISP, ICP, IAP','LQFP 44/LQFP 48/PQFP 44','8*12-bit','1','512');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('N76E885','10*10-bit','Configurable','18K','1','26','ISP, ICP, IAP','TSSOP28/TSSOP20','8*12-bit','1','512');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('N78E055A','-','4K','16K','-','40','ISP','PDIP40/PLCC44/PQFP44/LQFP48','5*8-bit','1','256+1K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('N78E059A','-','4K','32K','-','40','ISP','PDIP40/PLCC44/PQFP44/LQFP48','5*8-bit','1','256+1K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('N78E366A','-','-','64K','-','40','ISP','PDIP40/PLCC44/PQFP44/LQFP48','5*8-bit','1','256+1K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('N78E517A','-','Configurable','64K','-','40','ISP','PDIP40/PLCC44/PQFP44/LQFP48
/TQFP44','5*8-bit','1','256+1K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('N79E352R','-','128','8K','1','38','ICP','PDIP40/LQFP48','2*8-bit','-','256');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('N79E715','8*10-bit','Configurable','16K','1','25','ISP, ICP','SOP28/TSSOP28/SOP20/TSSOP20/SOP16','4*10-bit','1','512');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('N79E822','4*10-bit','256','2K','1','18','ICP','SOP20/PDIP20','4*10-bit','-','256');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('N79E823','4*10-bit','256','4K','1','18','ICP','SOP20/PDIP20','4*10-bit','-','256');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('N79E824','4*10-bit','256','8K','1','18','ICP','SOP20/PDIP20','4*10-bit','-','256');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('N79E825','4*10-bit','256','16K','1','18','ICP','SOP20/PDIP20','4*10-bit','-','256');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('N79E8432','4*10-bit','4K','4K','1','13','ISP, ICP','SOP16','4*10-bit','-','512');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('N79E844','7*10-bit','4K','8K','1','17','ISP, ICP','TSSOP20','4*10-bit','1','512');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('N79E845','7*10-bit','Configurable','16K','1','17','ISP, ICP','TSSOP20','4*10-bit','1','512');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('N79E854','8*10-bit','4K','8K','1','25','ISP, ICP','TSSOP28','4*10-bit','2','512');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('N79E855','8*10-bit','Configurable','16K','1','25','ISP, ICP','TSSOP28','4*10-bit','2','512');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('N79E875','8*10-bit','128','16K','1','36','ICP','LQFP48','8*12-bit','1','512');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('W77C032A','-','-','-','-','36','-','PDIP40/PLCC44/PQFP44','-','-','256+1K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('W77E058A','-','-','32K','-','36','-','PDIP40/PLCC44/PQFP44','-','-','256+1K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('W77E516A','-','-','64K','-','36','ISP','PDIP40/PLCC44/PQFP44','-','-','256+1K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('W77E532A','-','-','128K','-','36','ISP','PDIP40/PLCC44/PQFP44','-','-','256+1K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('W77L032A','-','-','-','-','36','-','PDIP40/PLCC44/PQFP44','-','-','256+1K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('W77L058A','-','-','32K','-','36','-','PDIP40/PLCC44/PQFP44','-','-','256+1K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('W77L516A','-','','64K','-','36','ISP','PDIP40/PLCC44/PQFP44','-','-','256+1K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('W77L532A','-','-','128K','-','36','ISP','PDIP40/PLCC44/PQFP44','-','-','256+1K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('W78C032','-','-','-','-','32','-','PDIP40/PLCC44/PQFP44','-','-','256');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('W78C438','-','-','-','-','40','-','PQFP100','-','-','256');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('W78E052D','-','-','8K','-','36','ISP','PDIP40/PLCC44/PQFP44/LQFP48/TQFP44','-','-','256');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('W78E054D','-','-','16K','-','36','ISP','PDIP40/PLCC44/PQFP44/LQFP48/TQFP44','-','-','256');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('W78E058D','-','-','32K','-','36','ISP','PDIP40/PLCC44/PQFP44/LQFP48','-','-','512');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('W78E516D','-','-','64K','-','36','ISP','PDIP40/PLCC44/PQFP44/LQFP48','-','-','512');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('W78E858A','-','-','32K','-','36','ISP','PDIP40/PLCC44/PQFP44','4*8-bit','-','768');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('W78ERD2A','-','-','64K','-','36','ISP','PDIP40/PLCC44/PQFP44','5*8-bit','-','256+1K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('W78IRD2A','-','-','64K','-','36','ISP','PDIP40/PLCC44','5*8-bit','-','256+1K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('W79E2051','-','128','2K','-','17','ICP','SOP20/PDIP20','1*10-bit','-','256');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('W79E4051','-','128','4K','-','17','ICP','SOP20/PDIP20','1*10-bit','-','256');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('W79E632A','-','-','128K','-','36','ISP','PLCC44/PQFP44','6*8-bit','-','256+1K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('W79E633A','4*10-bit','-','128K','2','36','ISP','PLCC44/PQFP44','6*8-bit','-','256+1K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('W79E658A','8*10-bit','-','128K','2','60','ISP','PQFP100','6*8-bit','-','256+1K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('W79E659A','8*10-bit','-','32K','2','60','ISP','PQFP100','6*8-bit','-','256+1K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('W79E8213','8*10-bit','128','4K','-','18','ICP','SOP20/PDIP20','4*10-bit','-','128');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('W79L632A','-','-','128K','-','36','ISP','PLCC44/PQFP44','6*8-bit','-','256+1K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('W79L633A','4*10-bit','-','128K','2','36','ISP','PLCC44/PQFP44','6*8-bit','-','256+1K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('W79L658A','8*10-bit','-','128K','2','60','ISP','PQFP100','6*8-bit','-','256+1K');INSERT INTO TS_NUVOTON_SELECTION_GUIDE_S15 (PARTNO,ADC,DataFlash,Flash,I2C,IO,ISPICPIAP,Package,PWM,SPI,SRAM) VALUES ('W79L659A','8*10-bit','-','32K','2','60','ISP','PQFP100','6*8-bit','-','256+1K');CREATE TABLE IF NOT EXISTS TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID INTEGER NOT NULL,PACKAGE TEXT NOT NULL);
DELETE FROM TS_NUVOTON_SELECTION_GUIDE_PACKAGE;
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (1,'48QFN');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (2,'40QFN');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (3,'32QFN');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (4,'9 bump WCSP');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (5,'8-Pin SOP 8-Pin PDIP');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (6,'8-Pin SOP (Thermal ex-pad)');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (7,'DIE');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (8,'DIP 28, SOIC 28, TSOP 28, DIE');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (9,'LQFP216');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (10,'LQFP176');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (11,'LQFP144');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (12,'LQFP128');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (13,'LQFP128 TFBGA128 TFBGA144');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (14,'LQFP128 TFBGA128');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (15,'LQFP-128(MCP)');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (16,'LQFP-128 (MCP)');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (17,'LQFP100');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (18,'LQFP64');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (19,'LQFP64 VFBGA64');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (20,'LQFP-64 (MCP)');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (21,'LQFP64(7x7mm)');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (22,'LQFP48');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (23,'MSOP10');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (24,'MSOP 8-pin');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (25,'MSOP8');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (26,'PBGA324');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (27,'PDIP40');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (28,'PDIP20');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (29,'PLCC44');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (30,'PQFP100');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (31,'PQFP44');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (32,'QFN48');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (33,'QFN33');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (34,'QFN33(4x4mm)');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (35,'QFN32');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (36,'QFN32, SOP16');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (37,'QFN-32 (5x5)');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (38,'QFN-32 (5x5) SSOP-28');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (39,'QFN-24 (4x4)');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (40,'QFN20');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (41,'QFN-20 (4x4)');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (42,'QFN16');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (43,'SOIC 28');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (44,'SOIC 28, DIE');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (45,'SOIC 28, TSOP 28, DIE');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (46,'SOIC 16, DIE');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (47,'SOP24, SSOP24');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (48,'SOP24, SSOP20');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (49,'SOT23-5');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (50,'SOT23-5 SOT23-6');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (51,'SOP20');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (52,'SOP20,SSOP20, TSSOP20');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (53,'SOP20, SSOP20, TSSOP20');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (54,'SOP20, SSOP20, TSSOP20, QFN32');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (55,'SOP16');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (56,'SOP-16, PDIP-16');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (57,'SOP14');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (58,'SOP-14 TSSOP-14');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (59,'SOP8');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (60,'SOP8 with Exposed Pad');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (61,'SSOP20');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (62,'TQFP-64 (MCP)');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (63,'TQFP44');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (64,'TSSOP28');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (65,'TSSOP28 QFN32');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (66,'TSSOP20');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (67,'TSSOP16');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (68,'TSSOP-16');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (69,'TSSOP14');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (70,'LQFP-216 (MCP)');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (71,'WLCSP49');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (72,'LQFP64, QFN32');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (73,'SOP14');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (74,'SOP8');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (75,'QFN20');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (76,'QFN48');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (77,'SOP16');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (78,'QFN32');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (79,'SOP28');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (80,'QFN-20 (4x4)');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (81,'QFN-32 (5x5)');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (82,'QFN-48 (6x6)');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (83,'QFN-32 (5x5)');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (84,'QFN-28 (4x4)');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (85,'QFN-32 (5x5)');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (86,'LQFP64');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (87,'QFN40');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (88,'TQFP048-P-0707');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (89,'TQFP064-P-1010');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (90,'TQFP080-P-1212');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (91,'HQFN032-A2-0404');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (92,'TQFP056-P-1010');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (93,'HQFP064-P-1010DZ');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (94,'MSOP008-P-0150XZL');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (95,'MSOP014-P-0225XZL');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (96,'HQFN020-A-0303XZL');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (97,'HQFN024-A-0404AZ');
INSERT INTO TS_NUVOTON_SELECTION_GUIDE_PACKAGE (ID,PACKAGE) VALUES (98,'LQFP080-P-1414FZ')