Still looks good for a Wednesday beta release. I'm trying to shoehorn it into an Install module, and then have to make sure it works from a plug-in install.
If you have purchased this mod, or the image gallery mod, and want to beta this, email me. This is a real beta. It won't destroy your system, but it's almost guaranteed not to work on first install :) So I don't want to encourage anyone to install it who doesn't _ask_ first :)
Here is the Attach_Links table, and what it will look like. I tried to cover all the important attributes an attachment could have, as well as a few that add some extra features if you use them right.
====
LinkID => { pos => 2, type => 'INT', not_null => 1, unsigned => 1, regex => '^\d+$' },
Username => { pos => 3, type => 'CHAR', not_null => 1, size => 50},
Date => { pos => 4, type => 'DATE' },
Slot => { pos => 5, type => 'SMALLINT', not_null => 0, unsigned => 1, default => 0, regex => '^\d+$' },
File_Name => { pos => 6, type => 'CHAR', not_null => 1, size => 50, weight => 1 },
Storage_Path => { pos => 7, type => 'CHAR', not_null => 1, size => 255},
Download_Name => { pos => 8, type => 'CHAR', not_null => 1, size => 50},
File_MimeType => { pos => 9, type => 'CHAR', not_null => 1, default => 'text/html', size => 80},
Type => { pos => 10, type => 'CHAR', not_null => 0, size => 5, weight => 1 },
Size => { pos => 11, type => 'SMALLINT', not_null => 0, unsigned => 1, regex => '^\d+$' },
Height => { pos => 12, type => 'SMALLINT', not_null => 0, unsigned => 1, regex => '^\d+$' },
Width => { pos => 13, type => 'SMALLINT', not_null => 0, unsigned => 1, regex => '^\d+$' },
Pages => { pos => 14, type => 'SMALLINT', not_null => 0, unsigned => 1, regex => '^\d+$' },
Resolution => { pos => 15, type => 'SMALLINT', not_null => 0, unsigned => 1, regex => '^\d+$' },
Title => { pos => 16, type => 'CHAR', not_null => 1, size => 255},
Description => { pos => 17, type => 'TEXT' },
Keywords => { pos => 18, type => 'CHAR', not_null => 0, size => 255},
Topics => { pos => 19, type => 'CHAR', not_null => 0, size => 255},
Content_Type => { pos => 20, type => 'CHAR', not_null => 0, size => 255},
Copyright_Info => { pos => 21, type => 'CHAR', not_null => 0, size => 255},
Downloads => { pos => 22, type => 'SMALLINT', not_null => 1, unsigned => 1, default => 0, regex => '^\d+$' },
isNew => { pos => 23, type => 'ENUM', values => ['Yes', 'No'], not_null => 1, default => 'No' },
isGraphic => { pos => 24, type => 'ENUM', values => ['Yes', 'No'], not_null => 1, default => 'No' },
isValidated => { pos => 25, type => 'ENUM', values => ['Yes', 'No'], not_null => 1, default => 'No' },Slot: will allow minor page-formatting.
File_Name: the disk-storage name
Download_Name: The download name (not yet implemented)
File_MimeType: To allow browsers/servers to deal with it
Type: Human/searchable type -- GIF, PDF, SHTML, etc
Height/Width: only if "isGraphic"
Pages: used for non-graphics, ie: PDF, Text
Resolution: Can be used to set the resolution - 72, 150, 300, etc
Topics: An admin field, for categorizing/searching behind the scenes
Content_Type: an admin field, or enum field, for "Story, Photo, Review", etc. Customizable.
If you can think of any other attributes that apply to a wide range of attachments, I can work them in, but they need to be really general. You can customize this any way you want, just like the Links record, but I'm trying to make a pretty complete default install.
Technically, LinkID, Username, could be pulled out, with ID, into a Cat_Links type table, but performance would unnecessarily suffer. For a very, very small byte penalty this creates an easy linking to Username and Link. NOTE: This is something that _is_ done in the Image Gallery mod, since the basic unit of the Image Gallery is an "Element" (or attachment) and not a "Link". An attachment/Element can be a member of several groups, "links" or series.
PUGDOGŪ Enterprises, Inc.
FAQ:http://LinkSQL.com/FAQ
Forum:http://LinkSQL.com/forum
If you have purchased this mod, or the image gallery mod, and want to beta this, email me. This is a real beta. It won't destroy your system, but it's almost guaranteed not to work on first install :) So I don't want to encourage anyone to install it who doesn't _ask_ first :)
Here is the Attach_Links table, and what it will look like. I tried to cover all the important attributes an attachment could have, as well as a few that add some extra features if you use them right.
====
Code:
ID => { pos => 1, type => 'INT', not_null => 1, unsigned => 1, regex => '^\d+$' }, LinkID => { pos => 2, type => 'INT', not_null => 1, unsigned => 1, regex => '^\d+$' },
Username => { pos => 3, type => 'CHAR', not_null => 1, size => 50},
Date => { pos => 4, type => 'DATE' },
Slot => { pos => 5, type => 'SMALLINT', not_null => 0, unsigned => 1, default => 0, regex => '^\d+$' },
File_Name => { pos => 6, type => 'CHAR', not_null => 1, size => 50, weight => 1 },
Storage_Path => { pos => 7, type => 'CHAR', not_null => 1, size => 255},
Download_Name => { pos => 8, type => 'CHAR', not_null => 1, size => 50},
File_MimeType => { pos => 9, type => 'CHAR', not_null => 1, default => 'text/html', size => 80},
Type => { pos => 10, type => 'CHAR', not_null => 0, size => 5, weight => 1 },
Size => { pos => 11, type => 'SMALLINT', not_null => 0, unsigned => 1, regex => '^\d+$' },
Height => { pos => 12, type => 'SMALLINT', not_null => 0, unsigned => 1, regex => '^\d+$' },
Width => { pos => 13, type => 'SMALLINT', not_null => 0, unsigned => 1, regex => '^\d+$' },
Pages => { pos => 14, type => 'SMALLINT', not_null => 0, unsigned => 1, regex => '^\d+$' },
Resolution => { pos => 15, type => 'SMALLINT', not_null => 0, unsigned => 1, regex => '^\d+$' },
Title => { pos => 16, type => 'CHAR', not_null => 1, size => 255},
Description => { pos => 17, type => 'TEXT' },
Keywords => { pos => 18, type => 'CHAR', not_null => 0, size => 255},
Topics => { pos => 19, type => 'CHAR', not_null => 0, size => 255},
Content_Type => { pos => 20, type => 'CHAR', not_null => 0, size => 255},
Copyright_Info => { pos => 21, type => 'CHAR', not_null => 0, size => 255},
Downloads => { pos => 22, type => 'SMALLINT', not_null => 1, unsigned => 1, default => 0, regex => '^\d+$' },
isNew => { pos => 23, type => 'ENUM', values => ['Yes', 'No'], not_null => 1, default => 'No' },
isGraphic => { pos => 24, type => 'ENUM', values => ['Yes', 'No'], not_null => 1, default => 'No' },
isValidated => { pos => 25, type => 'ENUM', values => ['Yes', 'No'], not_null => 1, default => 'No' },
File_Name: the disk-storage name
Download_Name: The download name (not yet implemented)
File_MimeType: To allow browsers/servers to deal with it
Type: Human/searchable type -- GIF, PDF, SHTML, etc
Height/Width: only if "isGraphic"
Pages: used for non-graphics, ie: PDF, Text
Resolution: Can be used to set the resolution - 72, 150, 300, etc
Topics: An admin field, for categorizing/searching behind the scenes
Content_Type: an admin field, or enum field, for "Story, Photo, Review", etc. Customizable.
If you can think of any other attributes that apply to a wide range of attachments, I can work them in, but they need to be really general. You can customize this any way you want, just like the Links record, but I'm trying to make a pretty complete default install.
Technically, LinkID, Username, could be pulled out, with ID, into a Cat_Links type table, but performance would unnecessarily suffer. For a very, very small byte penalty this creates an easy linking to Username and Link. NOTE: This is something that _is_ done in the Image Gallery mod, since the basic unit of the Image Gallery is an "Element" (or attachment) and not a "Link". An attachment/Element can be a member of several groups, "links" or series.
PUGDOGŪ Enterprises, Inc.
FAQ:http://LinkSQL.com/FAQ
Forum:http://LinkSQL.com/forum