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
);
|