id	summary	reporter	owner	description	type	status	priority	component	resolution	keywords	cc
1348	Создать столбцы для работы Сканера(вообще) и Приемки(от ревизии 378)	Denis_N	san	"Для работы Сканера:

1. Добавить столбец `shelfdrawer` в таблицу products.
Терминальная команда: alter table products add column shelfdrawer varchar(12) default null;

{{{
+-------------+--------------------------------------------------------------------------+------+-----+---------+----------------+
| 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)

}}}

2. Изменить местоположение у всех изделий, которые имеют местоположение склад, на nowhere, чтобы точно знать какие изделия у нас хранятся на складе
3. Добавить столбец `shelfdrawer` в таблицу history.
Терминальная команда: alter table history add column shelfdrawer varchar(12) default null;


{{{
+--------------+-----------------------------------------------------------------------------------+------+-----+---------+----------------+
| Field        | Type                                                                              | Null | Key | Default | Extra          |
+--------------+-----------------------------------------------------------------------------------+------+-----+---------+----------------+
| UID          | int                                                                               | YES  |     | NULL    |                |
| worker       | varchar(100)                                                                      | YES  |     | NULL    |                |
| date         | datetime                                                                          | YES  |     | NULL    |                |
| type_write   | set('record','otk','mismatch','testing','shipping','transform','change_location') | YES  |     | NULL    |                |
| order_from   | varchar(100)                                                                      | YES  |     | NULL    |                |
| whom_order   | varchar(100)                                                                      | YES  |     | NULL    |                |
| location     | enum('stock','shipped','develop','isolator','nelikvid','repair','work')           | YES  |     | NULL    |                |
| number_order | int                                                                               | YES  |     | NULL    |                |
| status       | enum('ok','fail')                                                                 | YES  |     | NULL    |                |
| comment      | longtext                                                                          | YES  |     | NULL    |                |
| N            | int                                                                               | NO   | PRI | NULL    | auto_increment |
| bond         | int                                                                               | YES  | MUL | NULL    |                |
| shelfdrawer  | varchar(12)                                                                       | YES  |     | NULL    |                |
+--------------+-----------------------------------------------------------------------------------+------+-----+---------+----------------+
}}}


Для работы Первичного приема:

Нужно добавить столбец `version`(версия изделия) в таблицу products.
Терминальная команда: alter table products add column `version` int default null;


{{{
+-------------+--------------------------------------------------------------------------+------+-----+---------+----------------+
| 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    |                |
| version     | int                                                                      | YES  |     | NULL    |                |
+-------------+--------------------------------------------------------------------------+------+-----+---------+----------------+
}}}


"	дефект	assigned	major	БД изделий АДС