aboutsummaryrefslogtreecommitdiff
path: root/examples/README
blob: a56a72516b27052416d88e620dc1e55824afdb7d (plain)
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
29
30
31
32
This directory contains examples of guile-sql usage.

whoisd -- a simple whois daemon.

Here is the database structure for use with this daemon:

CREATE DATABASE whois
CREATE TABLE admin_c (
	domain	varchar(255) default '' not null,
	contact char(24) default '' not null
);
CREATE TABLE tech_c (
	domain	varchar(255) default '' not null,
	contact char(24) default '' not null
);
CREATE TABLE zone_c (
	domain	varchar(255) default '' not null,
	contact char(24) default '' not null
);
CREATE TABLE nserver (
	domain	varchar(255) default '' not null,
	nserver varchar(255) default '' not null
);
CREATE TABLE domain (
	domain	varchar(255) default '' not null,
	created	date,
	changed	date,
	changed_by char(128),
	descr	text,
	remark	text,
	source  char(24) default 'UNKNOWN' not null
);

Return to:

Send suggestions and report system problems to the System administrator.