Opened 2 weeks ago

#1348 assigned дефект

Для работы сканера необходимо сделать следующее:

Reported by: Denis_N Owned by: san
Priority: major Component: БД изделий АДС
Keywords: Cc:

Description

  1. Добавить столбец 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)
    
    
  1. Изменить местоположение у всех изделий, которые имеют местоположение склад, на nowhere

Change History (0)

Note: See TracTickets for help on using tickets.