openaccess/tests/work/source/tbldef/TableTestBaseFields.sql

CREATE TABLE [TableTestBaseFields] (
  [auto_number] AUTOINCREMENT CONSTRAINT [PrimaryKey] PRIMARY KEY  UNIQUE  NOT NULL ,
  [string] VARCHAR (255),
  [long_string] LONGTEXT ,
  [integer] SHORT ,
  [long_int] LONG ,
  [real] SINGLE ,
  [real_one_decimal] SINGLE ,
  [real_double] DOUBLE ,
  [decimal] DECIMAL (18, 0),
  [datetime] DATETIME ,
  [boolean] BIT ,
  [string_with_default] VARCHAR (255),
  [numeric_with_condition] LONG ,
  [nonnull_date] VARCHAR (255),
  [indexed_integer_no_decimal] SHORT 
)