From 50a1f053200176cb2c900bcfc3a44c9de09f4435 Mon Sep 17 00:00:00 2001 From: rurban Date: Thu, 25 Mar 2004 19:51:12 +0000 Subject: [PATCH] remove wrong filename git-svn-id: svn://svn.code.sf.net/p/phpwiki/code/trunk@3211 96ab9672-09ca-45d6-a79d-3d69d39ca109 --- schemas/sqlite,sql | 53 ---------------------------------------------- 1 file changed, 53 deletions(-) delete mode 100644 schemas/sqlite,sql diff --git a/schemas/sqlite,sql b/schemas/sqlite,sql deleted file mode 100644 index eb7f42f65..000000000 --- a/schemas/sqlite,sql +++ /dev/null @@ -1,53 +0,0 @@ --- http://www.hezmatt.org/~mpalmer/sqlite-phpwiki/sqlite.sql - --- $Id: sqlite,sql,v 1.1 2004-03-17 14:41:33 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) -); -- 2.45.0