Re: Re: Photo Album Schema

From: Date: Thu, 23 Aug 2001 18:48:57 +0000
Subject: Re: Re: Photo Album Schema
References: 1  Groups: php.db 
Request: Send a blank email to php-db+get-11739@lists.php.net to get a copy of this message
The most useful schema would be to have the name of the document be system generated, like i123456789.img and make the database as follows: Image Image_Name varchar(50) primary key Original_Name varchar(50) Description text User User_ID int8 primary key Login char(8) uniques index password varchar(50) encrypted relation User_ID Image_Name Now you have duplicate anems OK, multiple users associated with any picture. You just rename the file as it comes and goes. ______________________________________________________________________________ Your mouse has moved. You must restart Windows for your changes to take effect. #!/usr/bin/perl print $i=pack(c5,(41*2),sqrt(7056),(unpack(c,H)-2),oct(115),10);

« previous php.db (#11739) next »