Difference between revisions of "Mysql database"
| Line 1: | Line 1: | ||
| + | Tables and structure for run management | ||
| − | + | mysql> describe runtable; | |
| + | +---------------+---------------+------+-----+---------+-------+ | ||
| + | | Field | Type | Null | Key | Default | Extra | | ||
| + | +---------------+---------------+------+-----+---------+-------+ | ||
| + | | run | int(11) | YES | | NULL | | | ||
| + | | runtype | varchar(50) | YES | | NULL | | | ||
| + | | side | varchar(5) | YES | | NULL | | | ||
| + | | target | varchar(30) | YES | | NULL | | | ||
| + | | epicstarget | varchar(30) | YES | | NULL | | | ||
| + | | targetencoder | int(11) | YES | | NULL | | | ||
| + | | raster | char(3) | YES | | NULL | | | ||
| + | | mom | float | YES | | NULL | | | ||
| + | | momepics | float | YES | | NULL | | | ||
| + | | angle | float | YES | | NULL | | | ||
| + | | angleepics | float | YES | | NULL | | | ||
| + | | dipcur | float | YES | | NULL | | | ||
| + | | anastart | int(11) | YES | | NULL | | | ||
| + | | anadone | int(11) | YES | | NULL | | | ||
| + | | comment | varchar(100) | YES | | NULL | | | ||
| + | | time | timestamp(14) | YES | | NULL | | | ||
| + | +---------------+---------------+------+-----+---------+-------+ | ||
| + | |||
| + | Scripts located | ||
| + | a-onl account scripts/mysql | ||
Revision as of 04:31, 16 February 2007
Tables and structure for run management
mysql> describe runtable; +---------------+---------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+---------------+------+-----+---------+-------+ | run | int(11) | YES | | NULL | | | runtype | varchar(50) | YES | | NULL | | | side | varchar(5) | YES | | NULL | | | target | varchar(30) | YES | | NULL | | | epicstarget | varchar(30) | YES | | NULL | | | targetencoder | int(11) | YES | | NULL | | | raster | char(3) | YES | | NULL | | | mom | float | YES | | NULL | | | momepics | float | YES | | NULL | | | angle | float | YES | | NULL | | | angleepics | float | YES | | NULL | | | dipcur | float | YES | | NULL | | | anastart | int(11) | YES | | NULL | | | anadone | int(11) | YES | | NULL | | | comment | varchar(100) | YES | | NULL | | | time | timestamp(14) | YES | | NULL | | +---------------+---------------+------+-----+---------+-------+
Scripts located a-onl account scripts/mysql
