Re: Re: Photo Album Schema
| From: | grant | 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);