cvs: docweb / rfc.sql /scripts setup_rfc_database.php /sql rfc.sql
| From: | Sean Coates | Date: | Sun, 12 Sep 2004 15:42:32 +0000 |
| Subject: | cvs: docweb / rfc.sql /scripts setup_rfc_database.php /sql rfc.sql | ||
| Groups: | php.doc.web | ||
| Request: | Send a blank email to doc-web+get-289@lists.php.net to get a copy of this message | ||
sean Sun Sep 12 11:42:32 2004 EDT
Added files:
/docweb/sql rfc.sql
Removed files:
/docweb rfc.sql
Modified files:
/docweb/scripts setup_rfc_database.php
Log:
moved .sql out of root
http://cvs.php.net/diff.php/docweb/scripts/setup_rfc_database.php?r1=1.1&r2=1.2&ty=u
Index: docweb/scripts/setup_rfc_database.php
diff -u docweb/scripts/setup_rfc_database.php:1.1 docweb/scripts/setup_rfc_database.php:1.2
--- docweb/scripts/setup_rfc_database.php:1.1 Sat Sep 11 08:38:28 2004
+++ docweb/scripts/setup_rfc_database.php Sun Sep 12 11:42:32 2004
@@ -17,14 +17,14 @@
* | Authors: Jacques Marneweck <jacques@php.net> |
* +----------------------------------------------------------------------+
*
- * $Id: setup_rfc_database.php,v 1.1 2004/09/11 12:38:28 jacques Exp $
+ * $Id: setup_rfc_database.php,v 1.2 2004/09/12 15:42:32 sean Exp $
*/
$idx = sqlite_open("../sqlite/rfc.sqlite", 0666);
if (!$idx) {
die("could not open $tmp_name");
}
-sqlite_query($idx, file_get_contents("../rfc.sql"));
+sqlite_query($idx, file_get_contents("../sql/rfc.sql"));
sqlite_close($idx);
/* vim: set noet ts=4 sw=4 ft=php: : */
http://cvs.php.net/co.php/docweb/sql/rfc.sql?r=1.1&p=1
Index: docweb/sql/rfc.sql
+++ docweb/sql/rfc.sql
/*
* Tables for the RFC system
* Original PEPr sql can be found at pearweb/sql/pepr.sql
*
* This is for a SQLite database, only edit if you
* know what SQLite doesn't support
*/
CREATE TABLE package_proposal_changelog (
pkg_prop_id int(11) NOT NULL default '0',
timestamp int(14) NOT NULL default '0',
user_handle varchar(20) NOT NULL default '',
comment text,
PRIMARY KEY (pkg_prop_id,timestamp,user_handle)
);
CREATE TABLE package_proposal_comments (
user_handle varchar(20) NOT NULL default '',
pkg_prop_id int(11) NOT NULL default '0',
timestamp int(14) NOT NULL default '0',
comment text NOT NULL,
PRIMARY KEY (user_handle,pkg_prop_id,timestamp)
);
CREATE TABLE package_proposal_links (
pkg_prop_id int(11) NOT NULL default '0',
type varchar(225) NOT NULL default 'pkg_file',
url varchar(255) NOT NULL default ''
);
CREATE TABLE package_proposal_votes (
pkg_prop_id int(11) NOT NULL default '0',
user_handle varchar(255) NOT NULL default '',
value tinyint(1) NOT NULL default '1',
reviews text NOT NULL,
is_conditional tinyint(1) NOT NULL default '0',
comment text NOT NULL,
timestamp timestamp(14) NOT NULL,
PRIMARY KEY (pkg_prop_id,user_handle)
);
CREATE TABLE package_proposals (
id INTEGER PRIMARY KEY,
pkg_category varchar(80) NOT NULL default '',
pkg_name varchar(80) NOT NULL default '' UNIQUE,
pkg_describtion text NOT NULL,
pkg_filehash text NOT NULL default '0',
draft_date timestamp(14) NOT NULL default '0',
proposal_date timestamp(14) NOT NULL default '0',
vote_date timestamp(14) NOT NULL default '0',
longened_date timestamp(14) NOT NULL default '0',
status varchar(200) NOT NULL default 'draft',
user_handle varchar(255) NOT NULL default '',
markup varchar(20) NOT NULL default 'bbcode'
);