Welcome to Geeklog, Anonymous Thursday, March 28 2024 @ 09:11 pm EDT

Geeklog Forums

gl_gallery planning


Status: offline

mthomas

Forum User
Full Member
Registered: 04/18/04
Posts: 148
DB Map- Please take a look and see if there is a area needing a change.

CREATE TABLE `gl_gallery_company_profiles` (
`cid` mediumint(8) NOT NULL auto_increment,
`lid` mediumint(8) default NULL,
`cname` varchar(50) default NULL,
`liname` mediumint(8) default NULL,
`caddr_1` varchar(50) default NULL,
`caddr_2` varchar(50) default NULL,
`caddr_3` varchar(50) default NULL,
`caddr_4` varchar(50) default NULL,
`caddr_5` varchar(50) default NULL,
`caddr_6` varchar(50) default NULL,
`url_1` varchar(50) default NULL,
`url_2` varchar(50) default NULL,
`email_1` varchar(50) default NULL,
`email_2` varchar(50) default NULL,
`phone_1` varchar(25) default NULL,
`phone_2` varchar(25) default NULL,
`fax_1` varchar(50) default NULL,
`fax_2` varchar(50) default NULL,
`logo1` varchar(128) default NULL,
`logo2` varchar(128) default NULL,
`image_1` varchar(128) default NULL,
`image_2` varchar(128) default NULL,
`image_3` varchar(128) default NULL,
PRIMARY KEY (`cid`)
) TYPE=MyISAM;

CREATE TABLE `gl_gallery_product_profiles` (
`cid` mediumint(8) NOT NULL auto_increment,
`pid` mediumint(8) default NULL,
`lid` mediumint(8) default NULL,
`pname` varchar(50) default NULL,
`purl_1` varchar(50) default NULL,
`purl_2` varchar(50) default NULL,
`pdescription1` varchar(128) default NULL,
`pdescription2` varchar(128) default NULL,
`pdescription3` varchar(128) default NULL,
`pdescription4` varchar(128) default NULL,
`pdescription5` varchar(128) default NULL,
`pdescription6` varchar(128) default NULL,
`pdescription7` varchar(128) default NULL,
`plogo` varchar(128) default NULL,
`pimage_1` varchar(128) default NULL,
`pimage_2` varchar(128) default NULL,
`pimage_3` varchar(128) default NULL,
PRIMARY KEY (`cid`)
) TYPE=MyISAM;

CREATE TABLE `gl_gallery_security` (
`cid` mediumint(8) NOT NULL auto_increment,
`uid` varchar(50) NOT NULL default '',
PRIMARY KEY (`cid`, `uid`),
) TYPE=MyISAM;
 Quote

Status: offline

samstone

Forum User
Full Member
Registered: 09/29/02
Posts: 820
What's this?
 Quote

Status: offline

mthomas

Forum User
Full Member
Registered: 04/18/04
Posts: 148
Inital Topic Thread

I move to a new thread as its time to start actually development (or at least the ground work for it)
 Quote

Status: offline

Euan

Forum User
Full Member
Registered: 04/22/02
Posts: 292
Might I suggest that you don't call this "gallery"? It could get confusing...

Cheers

Euan.
-- Heather Engineering
-- No job too small
 Quote

Status: offline

mthomas

Forum User
Full Member
Registered: 04/18/04
Posts: 148
suggestions for name?
 Quote

Status: offline

beewee

Forum User
Full Member
Registered: 08/05/03
Posts: 969
Location:The Netherlands, where else?
GL_Profile
GL_Showroom
GL_Base
GL_Data

It's your plug-in....you choose!
Dutch Geeklog sites about camping/hiking:
www.kampeerzaken.nl | www.campersite.nl | www.caravans.nl | www.caravans.net
 Quote

Status: offline

mthomas

Forum User
Full Member
Registered: 04/18/04
Posts: 148
lol know that hehe
I ask since it was suggested to use something other than gallery (I was not aware there was any other plugin called gallery)

I'll go with showroom lest I hear another outcry
 Quote

Status: offline

samstone

Forum User
Full Member
Registered: 09/29/02
Posts: 820
That's why I was confused at the beginning.

I think "Showroom" sound neat!

Sam
 Quote

All times are EDT. The time is now 09:11 pm.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content