Re: xcgal Plugin for PiCal
List posts in the topic
Re: xcgal Plugin for PiCal
msg# 1.1
xcgal_pictures table creation script:
==
CREATE TABLE `xoops_xcgal_pictures` (
`pid` int(11) NOT NULL auto_increment,
`aid` int(11) NOT NULL default '0',
`filepath` varchar(255) NOT NULL default '',
`filename` varchar(255) NOT NULL default '',
`filesize` int(11) NOT NULL default '0',
`total_filesize` int(11) NOT NULL default '0',
`pwidth` smallint(6) NOT NULL default '0',
`pheight` smallint(6) NOT NULL default '0',
`hits` int(10) NOT NULL default '0',
`mtime` int(11) NOT NULL default '0',
`ctime` int(11) NOT NULL default '0',
`owner_id` int(11) NOT NULL default '0',
`owner_name` varchar(40) NOT NULL default '',
`pic_rating` int(11) NOT NULL default '0',
`votes` int(11) NOT NULL default '0',
`title` varchar(255) NOT NULL default '',
`caption` text NOT NULL,
`keywords` varchar(255) NOT NULL default '',
`approved` enum('YES','NO') NOT NULL default 'NO',
`user1` varchar(255) NOT NULL default '',
`user2` varchar(255) NOT NULL default '',
`user3` varchar(255) NOT NULL default '',
`user4` varchar(255) NOT NULL default '',
`url_prefix` tinyint(4) NOT NULL default '0',
`randpos` int(11) NOT NULL default '0',
`ip` varchar(15) NOT NULL default '',
`sent_card` int(10) NOT NULL default '0',
PRIMARY KEY (`pid`),
KEY `pic_hits` (`hits`),
KEY `pic_rate` (`pic_rating`),
KEY `aid_approved` (`aid`,`approved`),
KEY `randpos` (`randpos`),
KEY `pic_aid` (`aid`)
) TYPE=MyISAM AUTO_INCREMENT=19 ;
==
Votes:27
Average:0.37
Posts tree