/Am1.0/script/gene/load.sql - Annotate - Browser Metadata - WashUGb Issue Tracking System

Daofeng Li

drop table if exists orfstruct;

2

8c368a17

Daofeng Li

create table orfstruct (

3

8c368a17

Daofeng Li

id int unsigned not null primary key,

4

8c368a17

Daofeng Li

chrom varchar(255) not null,

5

8c368a17

Daofeng Li

strand char(1) not null,

6

8c368a17

Daofeng Li

txStart int unsigned not null,

7

8c368a17

Daofeng Li

txEnd int unsigned not null,

8

8c368a17

Daofeng Li

cdsStart int unsigned not null,

9

8c368a17

Daofeng Li

cdsEnd int unsigned not null,

10

8c368a17

Daofeng Li

exonCount int unsigned not null,

11

8c368a17

Daofeng Li

exonStarts text not null,

12

8c368a17

Daofeng Li

exonEnds text not null,

13

8c368a17

Daofeng Li

name varchar(255) not null

14

8c368a17

Daofeng Li

);

15

8c368a17

Daofeng Li

load data local infile 'orf.struct' into table orfstruct;

16

8c368a17

Daofeng Li

17

8c368a17

Daofeng Li

18

8c368a17

Daofeng Li

drop table if exists orfsymbol;

19

8c368a17

Daofeng Li

create table orfsymbol (

20

8c368a17

Daofeng Li

name varchar(255) not null,

21

8c368a17

Daofeng Li

symbol varchar(255) null,

22

8c368a17

Daofeng Li

description text null,

23

8c368a17

Daofeng Li

id int unsigned not null primary key,

24

8c368a17

Daofeng Li

index(name)

25

8c368a17

Daofeng Li

);

26

8c368a17

Daofeng Li

27

8c368a17

Daofeng Li

28

8c368a17

Daofeng Li

drop table if exists Gleanstruct;

29

8c368a17

Daofeng Li

create table Gleanstruct (

30

8c368a17

Daofeng Li

id int unsigned not null primary key,

31

8c368a17

Daofeng Li

chrom varchar(255) not null,

32

8c368a17

Daofeng Li

strand char(1) not null,

33

8c368a17

Daofeng Li

txStart int unsigned not null,

34

8c368a17

Daofeng Li

txEnd int unsigned not null,

35

8c368a17

Daofeng Li

cdsStart int unsigned not null,

36

8c368a17

Daofeng Li

cdsEnd int unsigned not null,

37

8c368a17

Daofeng Li

exonCount int unsigned not null,

38

8c368a17

Daofeng Li

exonStarts text not null,

39

8c368a17

Daofeng Li

exonEnds text not null,

40

8c368a17

Daofeng Li

name varchar(255) not null

41

8c368a17

Daofeng Li

);

42

8c368a17

Daofeng Li

load data local infile 'Glean.struct' into table Gleanstruct;

43

8c368a17

Daofeng Li

44

8c368a17

Daofeng Li

drop table if exists Gleansymbol;

45

8c368a17

Daofeng Li

create table Gleansymbol (

46

8c368a17

Daofeng Li

name varchar(255) not null,

47

8c368a17

Daofeng Li

symbol varchar(255) null,

48

8c368a17

Daofeng Li

description text null,

49

8c368a17

Daofeng Li

id int unsigned not null primary key,

50

8c368a17

Daofeng Li

index(name)

51

8c368a17

Daofeng Li

);

WashU Epigenome Browser » Browser Metadata

root / Am1.0 / script / gene / load.sql @ 8c368a17

1	8c368a17	Daofeng Li	drop table if exists orfstruct;
2	8c368a17	Daofeng Li	create table orfstruct (
3	8c368a17	Daofeng Li	id int unsigned not null primary key,
4	8c368a17	Daofeng Li	chrom varchar(255) not null,
5	8c368a17	Daofeng Li	strand char(1) not null,
6	8c368a17	Daofeng Li	txStart int unsigned not null,
7	8c368a17	Daofeng Li	txEnd int unsigned not null,
8	8c368a17	Daofeng Li	cdsStart int unsigned not null,
9	8c368a17	Daofeng Li	cdsEnd int unsigned not null,
10	8c368a17	Daofeng Li	exonCount int unsigned not null,
11	8c368a17	Daofeng Li	exonStarts text not null,
12	8c368a17	Daofeng Li	exonEnds text not null,
13	8c368a17	Daofeng Li	name varchar(255) not null
14	8c368a17	Daofeng Li	);
15	8c368a17	Daofeng Li	load data local infile 'orf.struct' into table orfstruct;
16	8c368a17	Daofeng Li
17	8c368a17	Daofeng Li
18	8c368a17	Daofeng Li	drop table if exists orfsymbol;
19	8c368a17	Daofeng Li	create table orfsymbol (
20	8c368a17	Daofeng Li	name varchar(255) not null,
21	8c368a17	Daofeng Li	symbol varchar(255) null,
22	8c368a17	Daofeng Li	description text null,
23	8c368a17	Daofeng Li	id int unsigned not null primary key,
24	8c368a17	Daofeng Li	index(name)
25	8c368a17	Daofeng Li	);
26	8c368a17	Daofeng Li
27	8c368a17	Daofeng Li
28	8c368a17	Daofeng Li	drop table if exists Gleanstruct;
29	8c368a17	Daofeng Li	create table Gleanstruct (
30	8c368a17	Daofeng Li	id int unsigned not null primary key,
31	8c368a17	Daofeng Li	chrom varchar(255) not null,
32	8c368a17	Daofeng Li	strand char(1) not null,
33	8c368a17	Daofeng Li	txStart int unsigned not null,
34	8c368a17	Daofeng Li	txEnd int unsigned not null,
35	8c368a17	Daofeng Li	cdsStart int unsigned not null,
36	8c368a17	Daofeng Li	cdsEnd int unsigned not null,
37	8c368a17	Daofeng Li	exonCount int unsigned not null,
38	8c368a17	Daofeng Li	exonStarts text not null,
39	8c368a17	Daofeng Li	exonEnds text not null,
40	8c368a17	Daofeng Li	name varchar(255) not null
41	8c368a17	Daofeng Li	);
42	8c368a17	Daofeng Li	load data local infile 'Glean.struct' into table Gleanstruct;
43	8c368a17	Daofeng Li
44	8c368a17	Daofeng Li	drop table if exists Gleansymbol;
45	8c368a17	Daofeng Li	create table Gleansymbol (
46	8c368a17	Daofeng Li	name varchar(255) not null,
47	8c368a17	Daofeng Li	symbol varchar(255) null,
48	8c368a17	Daofeng Li	description text null,
49	8c368a17	Daofeng Li	id int unsigned not null primary key,
50	8c368a17	Daofeng Li	index(name)
51	8c368a17	Daofeng Li	);