Statistics
| Branch: | Revision:

root / sessionUtils.sql @ 8c368a17

History | View | Annotate | Download (1.9 kB)

1
/* for saved session */
2
drop table if exists session;
3
create table session (
4
  session char(20) not null collate utf8_bin, -- 0
5
  statusId int not null, -- 1
6
  statusNote varchar(255) null, -- 2
7
  clientCtrl text null, -- 3
8
  customTrackAttr text null, -- 4
9
  juxType int not null, -- 5
10
  juxWhat text null, -- 6
11
  juxNote varchar(255) null,  -- 7
12
  dspStat varchar(255) null, -- 8
13
  corrStat varchar(255) null, -- 9
14
  itemlist MEDIUMTEXT null, -- 10 the geneset that's been used for gsv
15
  custmd text null, -- 11
16
  mdconshow text null, -- 12
17
  dataset varchar(255) null, -- 13
18
  pairwisecomp text null, -- 14
19
  bed_n text null, -- 15
20
  bed_c text null, -- 16
21
  bedgraph_n text null, -- 17
22
  bedgraph_c text null, -- 18
23
  sam_n text null, -- 19 sam/tabix not in use
24
  sam_c text null, -- 20
25
  qdecor_n text null, -- 21
26
  lr_n text null, -- 22
27
  lr_c text null, -- 23
28
  cat_n text null, -- 24
29
  cat_c text null, -- 25
30
  bigwighmtk_n text null, -- 26
31
  bigwighmtk_c text null, -- 27
32
  decorRenderingParams text null, -- 28 for all non-numerical tracks
33
  qtc text not null, -- 29
34
  geneset MEDIUMTEXT null, -- 30
35
  stickynote text null, -- 31
36
  scaffoldCount smallint null, -- 32
37
  scaffoldNames text null, -- 33
38
  bam_n text null, -- 34
39
  bam_c text null, -- 35
40
  reserved_3 text null, -- 36
41
  reserved_4 text null,
42
  reserved_5 text null,
43
  reserved_6 text null,
44
  reserved_7 text null,
45
  reserved_8 text null,
46
  reserved_9 text null,
47
  reserved_10 text null
48
);
49
/* for run-time use of gene set view */
50
drop table if exists genesetRuntime;
51
create table genesetRuntime (
52
  session char(20) not null collate utf8_bin,
53
  statusId int not null,
54
  itemlist MEDIUMTEXT not null
55
);
56
/* scaffold, for run-time */
57
drop table if exists scaffoldRuntime;
58
create table scaffoldRuntime (
59
  session char(20) not null collate utf8_bin,
60
  statusId int not null,
61
  count smallint unsigned not null,
62
  names longtext not null /* name1,len1,name2,len2,... */
63
);