cvs: pearweb /sql Makefile aliases.sql authors.sql data.sql design.txt domains.sql packages.sql versions.sql

ssb Sun Jul 16 01:01:44 2000 EDT Modified files: /pearweb/sql Makefile aliases.sql authors.sql data.sql design.txt domains.sql packages.sql versions.sql Log: * renamed some fields, "make create" and "make destroy" work now Index: pearweb/sql/Makefile diff -u pearweb/sql/Makefile:1.3 pearweb/sql/Makefile:1.4 --- pearweb/sql/Makefile:1.3 Tue Feb 29 05:30:01 2000 +++ pearweb/sql/Makefile Sun Jul 16 01:01:44 2000 @@ -17,13 +17,18 @@ # +----------------------------------------------------------------------+ # -TABLE_FILES=authors.sql packages.sql aliases.sql +TABLE_FILES=\ + aliases.sql \ + authors.sql \ + domains.sql \ + packages.sql \ + versions.sql SQL_TYPE=mysql SQL_USER=pear SQL_PASSWORD=pear SQL_SERVER=pear -SQL_COMMAND=mysql -u '$(SQL_USER)' -p'$(SQL_PASSWORD)' '$(SQL_SERVER)' < $< > $@ 2>&1 -SQL_PIPE_COMMAND=mysql -u '$(SQL_USER)' -p'$(SQL_PASSWORD)' '$(SQL_SERVER)' +SQL_COMMAND=mysql -u '$(SQL_USER)' '$(SQL_SERVER)' < $< > $@ 2>&1 +SQL_PIPE_COMMAND=mysql -u '$(SQL_USER)' '$(SQL_SERVER)' SQL_GRANT_FILE= ECHO = echo @@ -77,9 +82,12 @@ @$(SQL_COMMAND) @echo -# Specify dependencies between tables (though use of foreign keys) -# as dependencies between their respective .res files here. For example, +# Specify dependencies between tables (by use of foreign keys) as +# dependencies between their respective .res files here. For example, # if the table "foo" has foreign keys to the table "bar", add # "foo.res: bar.res". aliases.res: packages.res +domains.res: authors.res +packages.res: authors.res +versions.res: packages.res Index: pearweb/sql/aliases.sql diff -u pearweb/sql/aliases.sql:1.1 pearweb/sql/aliases.sql:1.2 --- pearweb/sql/aliases.sql:1.1 Sun Feb 27 20:15:09 2000 +++ pearweb/sql/aliases.sql Sun Jul 16 01:01:44 2000 @@ -1,5 +1,5 @@ CREATE TABLE aliases ( package VARCHAR(80) NOT NULL REFERENCES packages(name), alias VARCHAR(80) NOT NULL, - UNIQUE INDEX(package,alias) + PRIMARY KEY(package,alias) ); Index: pearweb/sql/authors.sql diff -u pearweb/sql/authors.sql:1.1 pearweb/sql/authors.sql:1.2 --- pearweb/sql/authors.sql:1.1 Sun Dec 12 04:44:32 1999 +++ pearweb/sql/authors.sql Sun Jul 16 01:01:44 2000 @@ -1,5 +1,5 @@ CREATE TABLE authors ( - handle VARCHAR(20), + handle VARCHAR(20) NOT NULL, password VARCHAR(64), name VARCHAR(100), email VARCHAR(100), @@ -9,6 +9,8 @@ createdby VARCHAR(20), showemail BOOL, registered BOOL, - credentials INTEGER, - authorinfo TEXT + admin BOOL, + authorinfo TEXT, + + PRIMARY KEY(handle) ); Index: pearweb/sql/data.sql diff -u pearweb/sql/data.sql:1.2 pearweb/sql/data.sql:1.3 --- pearweb/sql/data.sql:1.2 Sun Feb 27 20:15:11 2000 +++ pearweb/sql/data.sql Sun Jul 16 01:01:44 2000 @@ -1 +1,3 @@ -INSERT INTO authors VALUES('SSB','azCfFoKW7AwzQ','Stig Bakken','stig@php.net','http://www.pvv.org/~ssb/',944079834,944079834,'SSB',1,1,3,NULL); +INSERT INTO authors VALUES('SSB','8c38dfa80e2bf8b2076a30848f111300','Stig Bakken','stig@php.net','http://www.pvv.org/~ssb/',944079834,944079834,'SSB',1,1,1,NULL); +INSERT INTO domains VALUES('', 'SSB'); +INSERT INTO domains VALUES('DB', 'SSB'); Index: pearweb/sql/design.txt diff -u pearweb/sql/design.txt:1.1 pearweb/sql/design.txt:1.2 --- pearweb/sql/design.txt:1.1 Fri Jul 14 07:06:13 2000 +++ pearweb/sql/design.txt Sun Jul 16 01:01:44 2000 @@ -1,5 +1,5 @@ PEAR BACKEND DATABASE DESIGN - $Id: design.txt,v 1.1 2000/07/14 14:06:13 ssb Exp $ + $Id: design.txt,v 1.2 2000/07/16 08:01:44 ssb Exp $ TERMINOLOGY @@ -98,8 +98,7 @@ in a (binary) distribution file called "DB_foosql-1.1b2.tar.gz": <?xml version="1.0" ?> -<Package xmlns="http://xmlns.php.net/pear/packagedesc" - Type="Binary"> +<Package xmlns="http://xmlns.php.net/pear/packagedesc" Type="Binary"> <Name>DB/foosql</Name> <Summary> DB/foosql is the DB backend for FooSQL. Index: pearweb/sql/domains.sql diff -u pearweb/sql/domains.sql:1.1 pearweb/sql/domains.sql:1.2 --- pearweb/sql/domains.sql:1.1 Sun Feb 27 20:15:11 2000 +++ pearweb/sql/domains.sql Sun Jul 16 01:01:44 2000 @@ -4,6 +4,3 @@ PRIMARY KEY(domain) ); - -INSERT INTO domains VALUES('', 'SSB'); -INSERT INTO domains VALUES('DB', 'SSB'); Index: pearweb/sql/packages.sql diff -u pearweb/sql/packages.sql:1.2 pearweb/sql/packages.sql:1.3 --- pearweb/sql/packages.sql:1.2 Sun Feb 27 20:15:11 2000 +++ pearweb/sql/packages.sql Sun Jul 16 01:01:44 2000 @@ -1,11 +1,12 @@ CREATE TABLE packages ( name VARCHAR(80) NOT NULL, + domain VARCHAR(80) NOT NULL, originator VARCHAR(20) NOT NULL REFERENCES authors(handle), maintainer VARCHAR(20) NOT NULL REFERENCES authors(handle), currentstable VARCHAR(20), currentdevel VARCHAR(20), copyright VARCHAR(20) NOT NULL, - summary VARCHAR(100), + summary TEXT, description TEXT, PRIMARY KEY(name) Index: pearweb/sql/versions.sql diff -u pearweb/sql/versions.sql:1.1 pearweb/sql/versions.sql:1.2 --- pearweb/sql/versions.sql:1.1 Sun Feb 27 20:15:11 2000 +++ pearweb/sql/versions.sql Sun Jul 16 01:01:44 2000 @@ -1,8 +1,10 @@ CREATE TABLE versions ( + id INTEGER NOT NULL AUTO_INCREMENT, package VARCHAR(80) NOT NULL REFERENCES packages(name), version VARCHAR(20) NOT NULL, releasedate DATETIME, releasenotes TEXT, - UNIQUE INDEX(package,version) + PRIMARY KEY(id), + UNIQUE(package,version) );