File: create_gabysql.sql

package info (click to toggle)
gaby 2.0.2-3
  • links: PTS
  • area: main
  • in suites: woody
  • size: 6,148 kB
  • ctags: 3,101
  • sloc: ansic: 48,660; sh: 8,710; python: 1,161; makefile: 951; perl: 265; sed: 93; xml: 89; sql: 25
file content (28 lines) | stat: -rw-r--r-- 526 bytes parent folder | download | duplicates (4) 
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
27
28
 

create table AddressBook (
	id		integer		primary key,
	firstname	varchar(50),
	lastname	varchar(50),
	more		varchar(50),
	street		varchar(100),
	zip		varchar(8),
	city		varchar(60),
	state		varchar(30),
	country		varchar(30),
	birthday	varchar(20),
	privatephone	varchar(20),
	workphone	varchar(20),
	cellphone	varchar(20),
	fax		varchar(20),
	email		varchar(50),
	website		varchar(50),
	category	varchar(30),
	remarks		varchar(250)
);

create table Zip (
	id		integer		primary key,
	zip		varchar(10),
	city		varchar(50)
);