Opened 2 months ago
Last modified 3 weeks ago
#1348 assigned дефект
Для работы сканера необходимо сделать следующее: — at Version 1
Reported by: | Denis_N | Owned by: | san |
---|---|---|---|
Priority: | major | Component: | БД изделий АДС |
Keywords: | Cc: |
Description (last modified by )
- Добавить столбец
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)
- Изменить местоположение у всех изделий, которые имеют местоположение склад, на nowhere, чтобы точно знать какие изделия у нас хранятся на складе
- Добавить столбец
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 | | +--------------+-----------------------------------------------------------------------------------+------+-----+---------+----------------+
Note:
See TracTickets
for help on using tickets.