Statistics
| Branch: | Revision:

root / sessionUtils.sql @ 52e54a06

History | View | Annotate | Download (1.9 kB)

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