Geeklog Forums

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;

What's this?

Inital Topic Thread

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

Might I suggest that you don't call this "gallery"? It could get confusing...

Cheers

Euan.

---

-- Heather Engineering
-- No job too small

suggestions for name?

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

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

That's why I was confused at the beginning.

I think "Showroom" sound neat!

Sam