File: CreateTBLTestTables.script

package info (click to toggle)
ctn 3.2.0~dfsg-8
  • links: PTS, VCS
  • area: main
  • in suites: sid, trixie
  • size: 16,924 kB
  • sloc: ansic: 179,652; makefile: 7,006; java: 1,863; csh: 1,067; yacc: 523; sh: 424; cpp: 394; sql: 389; lex: 170
file content (21 lines) | stat: -rw-r--r-- 468 bytes parent folder | download | duplicates (32) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
 
CREATE TABLE TBL_Persons
	(
	FNAME		char(50)	not null,
	LNAME		char(50)	not null,
	AGE		int		not null,
	ZIP		int		not null,
	WEIGHT		real		not null
	)
\g
CREATE TABLE UniqueNumbers
	(
	NumberName	char(50)	not null,
	UniqueNumber	int		not null
	)
\g
INSERT INTO UniqueNumbers (NumberName, UniqueNumber) VALUES ('UN1',0)
\g
INSERT INTO UniqueNumbers (NumberName, UniqueNumber) VALUES ('UN2',0)
\g
INSERT INTO UniqueNumbers (NumberName, UniqueNumber) VALUES ('UN3',0)
\g