File: sqlite-test.sql

package info (click to toggle)
tntdb 1.3-2
  • links: PTS
  • area: main
  • in suites: jessie, jessie-kfreebsd
  • size: 3,044 kB
  • ctags: 2,387
  • sloc: cpp: 14,250; sh: 11,084; makefile: 252; ansic: 144; sql: 106
file content (24 lines) | stat: -rw-r--r-- 482 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 autoincrement,
  boolcol boolean,
  shortcol integer,
  intcol integer,
  longcol integer,
  unsignedshortcol integer,
  unsignedcol integer,
  unsignedlongcol integer,
  int32col integer,
  uint32col integer,
  int64col integer,
  uint64col integer,
  decimalcol decimal(10, 4),
  floatcol real,
  doublecol real,
  charcol char,
  stringcol text,
  blobcol blob,
  datecol date,
  timecol time,
  datetimecol datetime
);