diff options
Diffstat (limited to 'examples/README')
-rw-r--r-- | examples/README | 32 |
1 files changed, 32 insertions, 0 deletions
diff --git a/examples/README b/examples/README new file mode 100644 index 0000000..a56a725 --- /dev/null +++ b/examples/README @@ -0,0 +1,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 +); |