h2 database

 ALTER TABLE test ALTER COLUMN col1 RENAME TO colnew
drop table cells;
create table sheets( SORDER DOUBLE unique, phenotype VARCHAR unique);
create table "1.0000001cells"( RORDER DOUBLE unique, CORDER DOUBLE unique, VALUE varchar, FORMULA varchar, BORDER TINYINT, BGRDCOLOR TINYINT, FONTNAME VARCHAR, FONTSIZE TINYINT, FONTSTYLE TINYINT, HLINK VARCHAR, RSPAN SMALLINT, CSPAN SMALLINT) ;
create table "1.0000001rows"( phenotype VARCHAR_IGNORECASE unique, RORDER double unique, height REAL);
create table "1.0000001columns"( phenotype INT unique, RORDER double unique, width REAL);
create table celldependencies( ORSORDER DOUBLE, ORRORDER DOUBLE unique, ORCORDER DOUBLE, DSTSORDER DOUBLE, DSTRORDER DOUBLE unique, DSTCORDER DOUBLE);
create table charts( CHORDER DOUBLE unique, phenotype VARCHAR unique, SORDER DOUBLE, POSX DOUBLE, POSY DOUBLE, HEIGHT REAL, WIDTH REAL, SNAPTLTORORDER DOUBLE, SNAPTLTOCORDER DOUBLE, SNAPBRTORORDER DOUBLE, SNAPBRTOCORDER DOUBLE, TITLE VARCHAR, AXISSTART float);
create table chartdependencies( ORSORDER DOUBLE, ORRORDER DOUBLE unique, ORCORDER DOUBLE, DSTCHORDER DOUBLE);
create table images( IMGORDER DOUBLE unique, phenotype VARCHAR unique, SORDER DOUBLE, POSX DOUBLE, POSY DOUBLE, HEIGHT REAL, WIDTH REAL, SNAPTLTORORDER DOUBLE, SNAPTLTOCORDER DOUBLE, SNAPBRTORORDER DOUBLE, SNAPBRTOCORDER DOUBLE, DATA BLOB);
create table imagedependencies( ORSORDER DOUBLE, ORRORDER DOUBLE unique, ORCORDER DOUBLE, DSTIMGORDER DOUBLE);
    last modified: 06 July 2013 [ View wiki source Close ]
     
SEARCH DIFFERENCE ATTACHMENT RECENT POST