CVS: phpwiki/schemas sqlite.sql,NONE,1.1

Update of /cvsroot/phpwiki/phpwiki/schemas
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv22101

Added Files:
        sqlite.sql 
Log Message:
forgot the schema file


--- NEW FILE: sqlite.sql ---
-- http://www.hezmatt.org/~mpalmer/sqlite-phpwiki/sqlite.sql

-- $Id: sqlite.sql,v 1.1 2004/03/24 01:02:11 rurban Exp $

CREATE TABLE page (
        id              INT NOT NULL,
        pagename        VARCHAR(100) NOT NULL,
        hits            INT NOT NULL DEFAULT 0,
        pagedata        MEDIUMTEXT NOT NULL DEFAULT '',
        PRIMARY KEY (id)
);

CREATE UNIQUE INDEX page_index ON page (pagename);

CREATE TABLE version (
        id              INT NOT NULL,
        version         INT NOT NULL,
        mtime           INT NOT NULL,
        minor_edit      TINYINT DEFAULT 0,
        content         MEDIUMTEXT NOT NULL DEFAULT '',
        versiondata     MEDIUMTEXT NOT NULL DEFAULT '',
        PRIMARY KEY (id,version)
);

CREATE INDEX version_index ON version (mtime);

CREATE TABLE recent (
        id              INT NOT NULL,
        latestversion   INT,
        latestmajor     INT,
        latestminor     INT,
        PRIMARY KEY (id)
);

CREATE TABLE nonempty (
        id              INT NOT NULL,
        PRIMARY KEY (id)
);

CREATE TABLE link (
        linkfrom        INT NOT NULL,
        linkto          INT NOT NULL
);

CREATE INDEX linkfrom_index ON link (linkfrom);
CREATE INDEX linkto_index ON link (linkto);

CREATE TABLE session (
        sess_id varchar(32) not null default '',
        sess_data blob not null,
        sess_date INT UNSIGNED NOT NULL,
        PRIMARY KEY (sess_id)
);



-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click