[转]Request Control Introduce

本文转自: NeuglsWorkStudio http://www.neugls.info/?p=130

Request control use sqlite3 as its database, connected by sqlitewrap. If you want to know more about sqlitewrap, please visit this website: http://www.ararat.cz/doku.php/en:sqlitewrap for more information.

Develop Environment

Request Control was writen and compiled under Delphi XE. If you want to compile it youself, you may need to install Delphi on your computer.

Structure

DataBase Structure

-- Table: software
CREATE TABLE software ( 
    ID           INTEGER          PRIMARY KEY AUTOINCREMENT,
    SoftwareName VARCHAR( 2048 ),
    CreatedTime  REAL,
    Status       INTEGER          DEFAULT ( 0 ),
    Notes        VARCHAR( 3072 ) 
);


-- Table: versions
CREATE TABLE versions ( 
    ID            INTEGER          PRIMARY KEY AUTOINCREMENT,
    SoftwareID    INTEGER,
    VersionNumber INTEGER,
    VersionString VARCHAR( 512 ),
    VersionName   VARCHAR( 2048 ),
    Status        INTEGER          DEFAULT ( 0 ),
    StartTime     REAL,
    EndTime       REAL 
);


-- Table: Items
CREATE TABLE Items ( 
    ID              INTEGER           PRIMARY KEY AUTOINCREMENT,
    SoftwareID      INTEGER,
    VersionID       INTEGER,
    SortDescription VARCHAR( 4096 ),
    Notes           VARCHAR( 10240 ),
    ItemType        INTEGER           DEFAULT ( 0 ),
    Status          INTEGER           DEFAULT ( 0 ),
    CreatedTime     REAL 
);