File: schema.sql

package info (click to toggle)
libgnatcoll-db 25.0.0-2
  • links: PTS, VCS
  • area: main
  • in suites: sid, trixie
  • size: 11,592 kB
  • sloc: ansic: 128,019; ada: 28,171; sql: 15,778; python: 2,266; makefile: 621; sh: 45
file content (11 lines) | stat: -rw-r--r-- 299 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
7
8
9
10
11
 

CREATE TABLE emp
 (name   CHARACTER VARYING NOT NULL UNIQUE,
  salary INTEGER);

INSERT INTO emp VALUES ('Bill',  900);
INSERT INTO emp VALUES ('Bob',    90);
INSERT INTO emp VALUES ('Sam',     9);
INSERT INTO emp VALUES ('Null', null);

CREATE TYPE apgxs_composite_type AS (x integer, y integer);