[phpBddb-dev1] Fwd: Re: information

[Brian <br...@br...>]

>Date: Fri, 12 Jul 2002 10:12:42 +0200
>To: "David C. Haley" <dh...@ho...>
>From: Brian <br...@br...>
>Subject: Re: information
>Bcc: die...@gu...
>
>Right, there is only one database, with
>one table housing "master collection" [we may split this one if it is=20
>getting to large]
>one table housing additional user specific collection data [for all users,=
=20
>we may split this too]
>
>Have a look at sql/bddb.sql
>
>TABLE bddb_bd   --> this is where beer mat data is stored (master=
 collection)
>TABLE bddb_serien       --> this is where beer mat sets are stored (master=
=20
>collection)
>TABLE bddb_brau --> this is where Brewery data is stored (master=
 collection)
>TABLE bddb_userbd       --> in here is user specific collection data=20
>stored (user collection)
>TABLE bddb_trust        --> had the idea that users should be able to=20
>trust other users
>                         --> so that more than one user can maintain a=20
> users collection
>TABLE bddb_rights       --> user/ group rights are set here
>TABLE bddb_user --> personalities, login data
>
>This is what i have done so far, just testing my ideas. First we should=20
>discuss needed/ unneeded tables and their structure.
>
>
># http://www.phpmyadmin.net/ (download page)
>#
># Host: localhost
># Erstellungszeit: 12. Juli 2002 um 09:40
># Server Version: 3.23.39
># PHP-Version: 4.0.4pl1
># Datenbank : `db36460009`
># --------------------------------------------------------
>
>#
># Tabellenstruktur f=B3r Tabelle `bddb_bd`
>#
>
>CREATE TABLE bddb_bd (
>   ID bigint(6) unsigned zerofill NOT NULL default '000000',
>   link_brau int(11) NOT NULL default '0',
>   link_serie int(11) default NULL,
>   bier tinytext NOT NULL,
>   ausdatum year(4) default NULL,
>   form tinytext NOT NULL,
>   druck tinytext NOT NULL,
>   kommentar longtext,
>   bild mediumtext,
>   bild2 mediumtext,
>   owner tinytext NOT NULL,
>   PRIMARY KEY  (ID),
>   UNIQUE KEY ID (ID)
>) TYPE=3DMyISAM COMMENT=3D'Bierdeckel Details';
># --------------------------------------------------------
>
>#
># Tabellenstruktur f=B3r Tabelle `bddb_brau`
>#
>
>CREATE TABLE bddb_brau (
>   ID smallint(5) unsigned zerofill NOT NULL auto_increment,
>   brauerei tinytext NOT NULL,
>   ort tinytext,
>   anmerk longtext,
>   ad_brau tinytext,
>   ad_strasse tinytext,
>   ad_ plz int(11) default NULL,
>   ad_ort tinytext,
>   logo mediumtext,
>   ad_hp mediumtext,
>   PRIMARY KEY  (ID),
>   UNIQUE KEY ID (ID)
>) TYPE=3DMyISAM COMMENT=3D'Brauerei-Index';
># --------------------------------------------------------
>
>#
># Tabellenstruktur f=B3r Tabelle `bddb_rights`
>#
>
>CREATE TABLE bddb_rights (
>   type char(10) NOT NULL default '',
>   sbyid set('true','false') NOT NULL default 'false',
>   login set('true','false') NOT NULL default 'false',
>   vbrau set('true','false') NOT NULL default 'false',
>   nbrau set('true','false') NOT NULL default 'false',
>   nseri set('true','false') NOT NULL default '',
>   nebdl set('true','false') NOT NULL default '',
>   nuser set('true','false') NOT NULL default 'false',
>   bbyid set('true','false') NOT NULL default 'false',
>   PRIMARY KEY  (type),
>   UNIQUE KEY type (type)
>) TYPE=3DMyISAM COMMENT=3D'User-Rechtemanagment';
># --------------------------------------------------------
>
>#
># Tabellenstruktur f=B3r Tabelle `bddb_serien`
>#
>
>CREATE TABLE bddb_serien (
>   ID mediumint(7) unsigned zerofill NOT NULL auto_increment,
>   name tinytext NOT NULL,
>   link_brau int(11) NOT NULL default '0',
>   bild mediumtext NOT NULL,
>   beschr longtext,
>   PRIMARY KEY  (ID),
>   UNIQUE KEY ID (ID)
>) TYPE=3DMyISAM COMMENT=3D'Serien Index';
># --------------------------------------------------------
>
>#
># Tabellenstruktur f=B3r Tabelle `bddb_trust`
>#
>
>CREATE TABLE bddb_trust (
>   ID bigint(20) NOT NULL default '0',
>   wer tinytext NOT NULL,
>   wem tinytext NOT NULL,
>   PRIMARY KEY  (ID)
>) TYPE=3DMyISAM;
># --------------------------------------------------------
>
>#
># Tabellenstruktur f=B3r Tabelle `bddb_user`
>#
>
>CREATE TABLE bddb_user (
>   ID bigint(20) NOT NULL auto_increment,
>   type set('admin','ops-bd','ops-us','owner','user-t','user') NOT NULL=20
> default 'user',
>   name tinytext NOT NULL,
>   vorname tinytext NOT NULL,
>   email tinytext NOT NULL,
>   strasse tinytext,
>   plz varchar(5) default NULL,
>   ort tinytext,
>   tel tinytext,
>   seit timestamp(14) NOT NULL,
>   nick varchar(10) NOT NULL default '',
>   pass tinytext NOT NULL,
>   PRIMARY KEY  (ID),
>   UNIQUE KEY ID (ID),
>   UNIQUE KEY nick (nick)
>) TYPE=3DMyISAM COMMENT=3D'User-Tabelle mit Trustrelationship';
># --------------------------------------------------------
>
>#
># Tabellenstruktur f=B3r Tabelle `bddb_userbd`
>#
>
>CREATE TABLE bddb_userbd (
>   ID bigint(6) unsigned zerofill NOT NULL default '000000',
>   link_brau int(11) NOT NULL default '0',
>   link_serie int(11) default NULL,
>   link_bd int(11) NOT NULL default '0',
>   kommentar longtext,
>   anzahl mediumint(8) unsigned NOT NULL default '0',
>   preis decimal(10,0) unsigned default '0',
>   sort mediumblob,
>   owner tinytext NOT NULL,
>   PRIMARY KEY  (ID),
>   UNIQUE KEY ID (ID)
>) TYPE=3DMyISAM COMMENT=3D'Useroptionen je BD';
>
>
>Brian
>
>
>
>At 20:54 11.07.2002 -0500, you wrote:
>>I'm at -0600 GMT. camping out in Texas at the moment. :)
>>feel free to look me up on ICQ @ 21106127
>>
>>I looked at the diagram that you sent. from teh look of it you seem to
>>have a large dbase that I assume houses a 'master' collection of
>>information. with the clients having smaller more personal databases. is
>>that right...
>>
>>David
>>
>>On Thu, 2002-07-11 at 17:14, Brian wrote:
>> > Because of the time difference, i think it is a better idea to have
>> > discussions through email/ forum.
>> > On the other hand this is no solution for quick discussions.
>> >
>> > I am available through ICQ at UIN # 66986349 (Bru). So if we could=20
>> arrange
>> > this, i want to have the possibility to discuss the further roadmap.
>> > What is your time compared to GMT ?
>> >
>> > Brian
>> >
>> >
>> > At 13:34 11.07.2002 -0500, you wrote:
>> >
>> > >how do you plan on getting together to discuss plans and ideas for the
>> > >project (email, chat program like AIM, forums)?
>> >