23 lines
1016 B
MySQL
23 lines
1016 B
MySQL
|
CREATE TABLE IF NOT EXISTS `vn`.`itemStateTag` (
|
||
|
|
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
|
|
`name` varchar(50) DEFAULT NULL,
|
||
|
|
PRIMARY KEY (`id`),
|
||
|
|
UNIQUE KEY `name_UNIQUE` (`name`)
|
||
|
|
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT
|
||
|
|
CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
||
|
|
|
||
|
|
INSERT IGNORE INTO `vn`.`itemStateTag` (`name`) VALUES ('Artificial');
|
||
|
|
INSERT IGNORE INTO `vn`.`itemStateTag` (`name`) VALUES ('Inactivo');
|
||
|
|
INSERT IGNORE INTO `vn`.`itemStateTag` (`name`) VALUES ('Preservado');
|
||
|
|
INSERT IGNORE INTO `vn`.`itemStateTag` (`name`) VALUES ('Seco');
|
||
|
|
INSERT IGNORE INTO `vn`.`itemStateTag` (`name`) VALUES ('Seco y preservado');
|
||
|
|
INSERT IGNORE INTO `vn`.`itemStateTag` (`name`) VALUES ('Estabilizada');
|
||
|
|
INSERT IGNORE INTO `vn`.`itemStateTag` (`name`) VALUES ('Natural y seco');
|
||
|
|
INSERT IGNORE INTO `vn`.`itemStateTag` (`name`) VALUES ('Preservado y artificial');
|
||
|
|
INSERT IGNORE INTO `vn`.`itemStateTag` (`name`) VALUES ('Usado');
|
||
|
|
|
||
|
|
UPDATE vn.tag
|
||
|
|
SET isFree=0,
|
||
|
|
sourceTable='itemStateTag'
|
||
|
|
WHERE name= 'Estado';
|