tables.sql

来自「The goal of this library is to make ODBC」· SQL 代码 · 共 21 行

CREATE TABLE DB_EXAMPLE ( 
  INT_VALUE     INTEGER NOT NULL, 
  STRING_VALUE  VARCHAR(50), 
  DOUBLE_VALUE  FLOAT, 
  EXAMPLE_LONG  INTEGER, 
  EXAMPLE_DATE  DATE ) ; 

CREATE TABLE DB_EXAMPLE_BACKUP ( 
  INT_VALUE     INTEGER NOT NULL, 
  STRING_VALUE  VARCHAR(50), 
  DOUBLE_VALUE  FLOAT, 
  EXAMPLE_LONG  INTEGER, 
  EXAMPLE_DATE  DATE ) ; 

CREATE TABLE DB_SAMPLE ( 
  SAMPLE_LONG  INTEGER, 
  SAMPLE_INT   INTEGER, 
  SAMPLE_STR   VARCHAR(50), 
  EXTRA_FLOAT  FLOAT ) ;