File: mysql-test.sql

package info (click to toggle)
tntdb 1.4-2
  • links: PTS
  • area: main
  • in suites: forky, sid
  • size: 1,632 kB
  • sloc: cpp: 15,806; makefile: 261; ansic: 260; sql: 158; sh: 11
file content (24 lines) | stat: -rw-r--r-- 518 bytes parent folder | download | duplicates (5) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
 
create table tntdbtest
(
  id integer not null primary key auto_increment,
  boolcol boolean,
  shortcol integer,
  intcol integer,
  longcol bigint,
  unsignedshortcol integer,
  unsignedcol bigint,
  unsignedlongcol decimal(24),
  int32col integer,
  uint32col bigint,
  int64col bigint,
  uint64col decimal(24),
  decimalcol decimal(16, 4),
  floatcol real,
  doublecol double precision,
  charcol char,
  stringcol varchar(255),
  blobcol blob,
  datecol date null,
  timecol time,
  datetimecol timestamp null
);