Generated from ./tables.sql with ROBODoc v4.0.18 on Mon Aug 18 22:39:20 2008

schtonk/tables.tcl

NAME

    tables.sql - schtonk database table definitions

DESCRIPTION

    this file is used for creating db tables used by schtonk

schtonk/pages

NAME

    pages - schtonk database table for pages

DESCRIPTION

    this db table holds the pages. 

SOURCE

    create table pages (
            ID INTEGER not null,          # pageid integer, referred as backend.tcl/pageid
            POST_DATE INTEGER NOT NULL,   # page date, as normal 1970-epoch
            VICTIM VARCHAR(30) NOT NULL,  # httpd username of page modifier
            REL_NUMBER INTEGER NOT NULL,  # page version
            IS_LATEST INTEGER,            # when 1 this the latest rel
            PAGE_CONTENT BLOB             # actual page content
    ) ; 

schtonk/attachments

NAME

    attachments         - schtonk database table for attachments

DESCRIPTION

    this db table holds the attachments of tables.sql/pages

SOURCE

    create table attachments (
            ID INTEGER not null,             # page where this attachment belongs to
            ATTACHMENT_ID INTEGER not null,  # unique id for attachment,referred with pageid parameter when backend.tcl/server_of_the_client is called with b argument
            POST_DATE INTEGER NOT NULL,      # date of attachment, epoch=1970-01-01
            VICTIM VARCHAR(30) NOT NULL,     # httpd user of attacher
            EXPLANATION VARCHAR(100),        # string telling what this is
            MIMETYPE VARCHAR(100) NOT NULL,  # attachment filetype
            FILENAME VARCHAR(256) NOT NULL,  # attachmetn filename
            ATTACHMENT_CONTENT MEDIUMBLOB    # content of the attachment, max 16777216 bytes
    ) ; 

schtonk/string_translations

NAME

    string_translations - localizable strings for schtonk

DESCRIPTION

    this db table holds string translations

SOURCE

    drop table string_translations ;
    create table string_translations (
            str_name varchar(50),       # id of  string
            translation BLOB,           # actual translated text
            lang varchar(2) ) ;         # lang, preferably in ISO 639