daily pastebin goal
29%
SHARE
TWEET

Untitled

a guest Feb 23rd, 2019 50 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. -- we don't know how to generate root <with-no-name> (class Root) :(
  2. create table PIT_COMMENT
  3. (
  4.     ID BIGINT default (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_F08A3C00_FD23_4A69_B5EC_A65E71BDAA06) auto_increment
  5.         primary key,
  6.     COMMENT VARCHAR(2000) not null,
  7.     TEAM_NUMBER INTEGER not null,
  8.     TIMESTAMP TIMESTAMP(26,6) not null
  9. );
  10.  
  11. create table PIT_PICTURE
  12. (
  13.     ID BIGINT default (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_B1A1A664_1B88_4915_B704_B17861D23518) auto_increment
  14.         primary key,
  15.     PICTURE VARCHAR(2000) not null,
  16.     TEAM_NUMBER INTEGER not null,
  17.     TIMESTAMP TIMESTAMP(26,6) not null
  18. );
  19.  
  20. create table SCOUTING_FORM
  21. (
  22.     ID BIGINT default (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_A90377FB_2364_49D3_ABF9_367643638CAB) auto_increment
  23.         primary key,
  24.     CROSS_HABITAT_LINE BOOLEAN not null,
  25.     MATCH_NUMBER INTEGER not null,
  26.     SANDSTORM_CARGO_BALL_COUNT INTEGER not null,
  27.     SANDSTORM_CARGO_HATCH_PANEL_COUNT INTEGER not null,
  28.     SANDSTORM_ROCKET_BALL_COUNT INTEGER not null,
  29.     SANDSTORM_ROCKET_HATCH_PANEL_COUNT INTEGER not null,
  30.     TEAM_NUMBER INTEGER not null
  31. );
  32.  
  33. create table TEAM
  34. (
  35.     TEAM_NUMBER INTEGER not null
  36.         primary key,
  37.     TEAM_NAME VARCHAR(255) not null
  38. );
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top