Opened 2 weeks ago
#1348 assigned дефект
Для работы сканера необходимо сделать следующее:
Reported by: | Denis_N | Owned by: | san |
---|---|---|---|
Priority: | major | Component: | БД изделий АДС |
Keywords: | Cc: |
Description
- Добавить столбец
shelfdrawer
в таблицу products.+-------------+--------------------------------------------------------------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+--------------------------------------------------------------------------+------+-----+---------+----------------+ | UID | int | NO | PRI | NULL | auto_increment | | type | varchar(100) | YES | | Плата | | | name | varchar(100) | YES | | NULL | | | serial | varchar(100) | NO | UNI | NULL | | | date | date | YES | | NULL | | | owner | varchar(100) | YES | | NULL | | | location | enum('stock','shipped','develop','isolator','nelikvid','work','nowhere') | NO | | NULL | | | testing | enum('ok','fail','notest') | YES | | notest | | | otk | enum('ok','fail','nocheck') | YES | | nocheck | | | comment | longtext | YES | | NULL | | | shelfdrawer | varchar(12) | YES | | NULL | | +-------------+--------------------------------------------------------------------------+------+-----+---------+----------------+ 11 rows in set (0.01 sec)
- Изменить местоположение у всех изделий, которые имеют местоположение склад, на nowhere
Note:
See TracTickets
for help on using tickets.