![[MC-04 logo]](/mc-04/chrome/site/logo.png){kind=logo}
Opened 3 years ago
Last modified 3 years ago
#997 assigned задача
Формат таблиц в БД — at Version 6
| Reported by: | san | Owned by: | san |
|---|---|---|---|
| Priority: | blocker | Component: | БД изделий АДС |
| Keywords: | Cc: |
Description (last modified by )
Здесь описан формат таблиц в БД, при необходимости изменить формат - пишем в этот тикет.
MariaDB [adcproducts]> SHOW columns from products;
+------------+-------------------------------------------------------------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+-------------------------------------------------------------------------+------+-----+---------+----------------+
| UID | int(32) | NO | PRI | NULL | auto_increment |
| type | varchar(100) | YES | | NULL | |
| name | varchar(100) | YES | | NULL | |
| perfomance | 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','repair','work') | YES | | NULL | |
| testing | enum('ok','fail','notest') | YES | | notest | |
| otk | enum('ok','fail','nocheck') | YES | | NULL | |
| mismatch | enum('yes','no') | YES | | no | |
| repair | varchar(100) | YES | | NULL | |
| comment | text | YES | | NULL | |
+------------+-------------------------------------------------------------------------+------+-----+---------+----------------+
13 rows in set (0.002 sec)
MariaDB [adcproducts]> SHOW columns from history;
+--------------+---------------------------------------------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+---------------------------------------------------------------+------+-----+---------+-------+
| UID | int(32) | YES | | NULL | |
| worker | varchar(100) | YES | | NULL | |
| date | datetime | YES | | NULL | |
| type_write | enum('record','otk','mismatch','testing','repair','shipping','transform') | 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 | varchar(100) | YES | | NULL | |
| status | enum('ok','fail') | YES | | NULL | |
| comment | text | YES | | NULL | |
| protocol | varchar(100) | YES | | NULL | |
+--------------+---------------------------------------------------------------+------+-----+---------+-------+
10 rows in set (0.002 sec)
MariaDB [adcproducts]> SHOW columns from users;
+----------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+--------------+------+-----+---------+-------+
| user | varchar(100) | YES | UNI | NULL | |
| worker | varchar(100) | YES | | NULL | |
| password | varchar(100) | YES | | NULL | |
| root | varchar(100) | YES | | NULL | |
+----------+--------------+------+-----+---------+-------+
4 rows in set (0.001 sec)
MariaDB [adcproducts]> SHOW columns from list_of_products;
+-------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+-------+
| name | varchar(100) | YES | | NULL | |
| type | varchar(100) | YES | | NULL | |
+-------+--------------+------+-----+---------+-------+
2 rows in set (0.004 sec)
MariaDB [adcproducts]> SHOW columns from orders;
+-------------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+------------------+------+-----+---------+-------+
| UID | int(32) | YES | UNI | NULL | |
| composition | text | YES | | NULL | |
| recipient | varchar(100) | YES | | NULL | |
| shipped | enum('yes','no') | YES | | NULL | |
| comment | text | YES | | NULL | |
+-------------+------------------+------+-----+---------+-------+
5 rows in set (0.003 sec)
Права: accept,mismatch,otk,refand,repair,shipment,testing,transform
Change History (6)
comment:1 by , 3 years ago
| Description: | modified (diff) |
|---|
follow-up: 5 comment:2 by , 3 years ago
comment:3 by , 3 years ago
| Owner: | changed from to |
|---|---|
| Status: | new → assigned |
comment:4 by , 3 years ago
| Owner: | changed from to |
|---|
comment:5 by , 3 years ago
Replying to san:
Денис: Нужно добавить новый тип записи transform
alter table history modify column type_write enum ('record','otk','mismatch','testing','repair','shipping','transform');
p.s. Наверное и право transform тоже нужно добавить в список
Добавил
comment:6 by , 3 years ago
| Description: | modified (diff) |
|---|
Note:
See TracTickets
for help on using tickets.
Денис: Нужно добавить новый тип записи transform
alter table history modify column type_write enum ('record','otk','mismatch','testing','repair','shipping','transform');p.s. Наверное и право transform тоже нужно добавить в список