TGCSpareList
TGC Database
Place
Information of the database
- The database, "tgc_sparemodule_db", is on dbod-atlastgc.cern.ch
- The database contains 6 tables, "ps_board", "HPT_board", "SSW", "cable", "fan", and "other_module".
Description of table, "ps_board", "HPT_board", "SSW", and "cable".
| Field |
Type |
Null |
Key |
Default |
Extra |
| id |
int(11) |
YES |
MUL |
NULL |
|
| name |
varchar(20) |
YES |
|
NULL |
|
| model_number |
varchar(200) |
YES |
|
NULL |
|
| serial_number |
varchar(200) |
YES |
|
NULL |
|
| barcode_number |
varchar(200) |
YES |
|
NULL |
|
| place |
enum('locker_1','locker_2','locker_3','locker_4','locker_5','locker_6','locker_7','locker_8','locker_9','locker_10') |
YES |
|
NULL |
|
| memo |
varchar(2000) |
YES |
|
NULL |
|
| confirmation_date |
date |
YES |
|
NULL |
|
Description of table, "fan".
| Field |
Type |
Null |
Key |
Default |
Extra |
| id |
int(11) |
YES |
MUL |
NULL |
|
| name |
varchar(20) |
YES |
|
NULL |
|
| model_number |
varchar(200) |
YES |
|
NULL |
|
| serial_number |
varchar(200) |
YES |
|
NULL |
|
| memo |
varchar(200) |
YES |
|
NULL |
|
| confirmation_date |
date |
YES |
|
NULL |
|
Description of table, "other_module".
| Field |
Type |
Null |
Key |
Default |
Extra |
| id |
int(11) |
YES |
MUL |
NULL |
|
| name |
varchar(20) |
YES |
|
NULL |
|
| model_number |
varchar(200) |
YES |
|
NULL |
|
| serial_number |
varchar(200) |
YES |
|
NULL |
|
| barcode_number |
varchar(200) |
YES |
|
NULL |
|
| place |
varchar(200) |
YES |
|
NULL |
|
| memo |
varchar(2000) |
YES |
|
NULL |
|
| confirmation_date |
date |
YES |
|
NULL |
|
How to access the database
- login to lxplus
- $
mysql -h dbod-atlastgc.cern.ch -P 5515 -u sparemod_user -p (password: sparemodule_user)
- mysql>
SHOW DATABASES;
- Please check whether database "tgc_sparemod_db" exists.
- mysql>
USE tgc_sparemod_db
- mysql>
SHOW TABLES;
- mysql>
SELECT * FROM ps_board; (to see contents of ps_board)
How to edit the database
- login to lxplus
- $
mysql -h dbod-atlastgc.cern.ch -P 5515 -u sparemod_admin -p (password: sparemodule)
- mysql>
SHOW DATABASES;
- Please check whether database "tgc_sparemod_db" exists.
- mysql>
USE tgc_sparemod_db
- mysql>
SHOW TABLES;
- For example,
UPDATE SSW SET memo = "/N" WHERE id = 31;
spare list (spreadsheets)
Spare list
CERN Technical Database
CERN Database
--
ShogoKido - 2017-06-09
Home 
Plugins
Sandbox for tests
Support
Alice
Atlas
CMS
LHCb
Public Webs
Sandbox Web 
Create New Topic
Index
Search
Changes
Notifications
RSS Feed
Statistics
Account 
Copyright &© 2008-2023 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.