Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Database fields...

Quote Reply
Database fields...
This is a little weird. I've just installed a copy of Links SQL on a clients server, and its showing me the following for the 'Properties' of links;
1 ID INT Yes ID TEXT ^\d+$
2 Title VARCHAR(100) Yes Title TEXT 3
3 URL VARCHAR(255) Yes http:// URL TEXT ^\w+: 1
4 LinkOwner VARCHAR(50) Yes admin LinkOwner TEXT
5 Add_Date DATE Yes 0000-00-00 Add Date DATE
6 Mod_Date DATE Yes 0000-00-00 Mod Date DATE
7 Description TEXT No Description TEXTAREA 1
8 Contact_Name VARCHAR(255) No Contact Name TEXT
9 Contact_Email VARCHAR(255) No Contact Email TEXT
10 Hits INT Yes Hits TEXT ^\d+$
11 isNew ENUM(No, Yes) Yes No isNew SELECT
12 isChanged ENUM(No, Yes) Yes No isChanged SELECT
13 isPopular ENUM(No, Yes) Yes No isPopular SELECT
14 isValidated ENUM(No, Yes) Yes Yes isValidated SELECT
15 Rating FLOAT Yes 0.00 Rating TEXT ^\d+\.?\d*$
16 Votes SMALLINT Yes Votes TEXT ^\d+$
17 Status SMALLINT Yes Status TEXT ^\-?\d+$
18 Date_Checked DATETIME No 0000-00-00 00:00:00 Date Checked DATE
19 Timestmp TIMESTAMP No Timestamp DATE


and the following when try to add/modify/delete etc a link;

Title
URL
LinkOwner
Add Date
Mod Date
Description
Contact Name
Contact Email
Hits
isValidated ---NoYes
Rating
Votes


It appears I am missing quite a few fields, including isPopular (which is spewing up an error when try to add/modify etc). Very odd.

Any ideas? Unsure

BTW: I've done a database re-sync too, but that doesn't seem to make a difference.

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Subject Author Views Date
Thread Database fields... Andy 1418 Nov 6, 2002, 4:01 AM
Post Re: [Andy] Database fields...
Andy 1340 Nov 7, 2002, 1:39 AM