File: pg-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 (26 lines) | stat: -rw-r--r-- 602 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
25
26
 
create sequence tntdbtest_seq;
create table tntdbtest
(
  id integer not null primary key default nextval('tntdbtest_seq'),
  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 text,
  blobcol bytea,
  datecol date,
  timecol time,
  datetimecol timestamp
);
alter sequence tntdbtest_seq owned by tntdbtest.id;