Not logged in.  Login/Logout/Register | List snippets | | Create snippet | Upload image | Upload data

14
LINES

< > BotCompany Repo | #1011902 // H2 Tables

Document

1  
drop table symbol;

2  
create table symbol (

3  
  id int auto_increment primary key,

4  
  name text not null

5  
);

6  


7  
create index on symbol (name); // doesn't work



8  


9  
create table triple (



10  
  globalID varchar(16) primary key,



11  
  a int,



12  
  b int,



13  
  c int



14  
);



      
download  show line numbers   
Travelled to 12 computer(s): aoiabmzegqzx, bhatertpkbcr, cbybwowwnfue, gwrvuhgaqvyk, ishqpsrjomds, lpdgvwnxivlt, mqqgnosmbjvj, pyentgdyhuwx, pzhvpgtvlbxg, tslmcundralx, tvejysmllsmz, vouqrxazstgt


No comments. add comment
      
      
  

  

    Snippet ID:
    #1011902
  

  

    Snippet name:
    H2 Tables
  

    

    Eternal ID of this version:
    #1011902/3
  

  

    Text MD5:
    a6386c163e98a923a7f444c4c0c94b22
  

    

    Author:
    stefan
  

  

    Category:
    javax / a.i.
  

  

    Type:
    Document
  

        

    Public (visible to everyone):
    Yes
  

  

    Archived (hidden from active list):
    No
  

  

    Created/modified:
      2017-11-09 10:52:31
  

  

    Source code size:
    250 bytes / 14 lines
  

  

    Pitched / IR pitched:
    No / No
  

    

    Views / Downloads:
    386 / 109
  

      

    Version history:
    2 change(s)
  

    

    Referenced in:
[show references]