Performing Database Updates

CREATE TABLE `cpg15x_cms` ( `ID` int(11) NOT NULL auto_increment, `catid` int(11) NOT NULL default '0', `title` varchar(255) NOT NULL default '', `content` text NOT NULL default '', PRIMARY KEY (`ID`, `catid`), FULLTEXT KEY `title` (`title`,`content`) ) AUTO_INCREMENT=1 Already Done
: MySQL Said
CREATE TABLE cpg15x_cms_config ( name varchar(40) NOT NULL default '', value varchar(255) NOT NULL default '', PRIMARY KEY (name) )Already Done
: MySQL Said
ALTER TABLE `cpg15x_cms` ADD `pos` int(11) NOT NULL default '0'Already Done
: MySQL Said
ALTER TABLE `cpg15x_cms` ADD `type` int(11) NOT NULL default '0'Already Done
: MySQL Said
ALTER TABLE `cpg15x_cms` CHANGE `catid` `conid` int(11) NOT NULL default '0'Already Done
: MySQL Said
ALTER TABLE `cpg15x_cms` CHANGE `pos` `cpos` int(11) NOT NULL default '0'Already Done
: MySQL Said
ALTER TABLE `cpg15x_cms` ADD `modified` TIMESTAMP NOT NULLAlready Done
: MySQL Said
ALTER TABLE `cpg15x_cms` ADD `start` DATETIMEAlready Done
: MySQL Said
ALTER TABLE `cpg15x_cms` ADD `end` DATETIMEAlready Done
: MySQL Said
INSERT INTO `cpg15x_cms` (conid,title,content,type) VALUES ('0','Welcome to Coppermine', 'Simple test of CPG MiniCMS','0')Already Done
: MySQL Said
INSERT INTO `cpg15x_cms_config` VALUES ('dbver', '0.0')Already Done
: MySQL Said
INSERT INTO `cpg15x_cms_config` VALUES ('redirect_index_php', '')Already Done
: MySQL Said
INSERT INTO `cpg15x_cms_config` VALUES ('related_size', 'thumb')Already Done
: MySQL Said
INSERT INTO `cpg15x_cms_config` VALUES ('editor', 'fckeditor')Already Done
: MySQL Said
INSERT INTO `cpg15x_cms_config` VALUES ('rss_enabled', '0')Already Done
: MySQL Said
INSERT INTO `cpg15x_cms_config` VALUES ('rss_description_length', '50')Already Done
: MySQL Said
INSERT INTO `cpg15x_cms_config` VALUES ('rss_include_image', '0')Already Done
: MySQL Said
INSERT INTO `cpg15x_cms_config` VALUES ('rss_image_size', 'thumb')Already Done
: MySQL Said
UPDATE `cpg15x_cms` SET `modified`=NOW() WHERE `modified`='0000-00-00 00:00:00'Already Done
: MySQL Said
ALTER TABLE `cpg15x_cms` DROP `pos`Already Done
: MySQL Said
UPDATE cpg15x_cms_config SET value='1.5.20' WHERE name='dbver'Already Done
: MySQL Said
UPDATE cpg15x_config SET value = 'minicms/breadcrumb/catlist/alblist' WHERE name = 'main_page_layout'Already Done
: MySQL Said
Home - My old 1.15.46 test gallery upgraded to 1.16.04

My old 1.15.46 test gallery upgraded to 1.16.04

For me, it's great on PC and tablet, but can't get right for mobile

Category Albums Files
User galleriesThis category contains my test albums and maybe some from friends who wish to give Coppermine a try.
3 21
Linked files, locos by class
3 0
Linked files, diesel units by class
3 0
Test CategoryI used this when testing 8 years ago!!!
3 29
56 files in 16 albums and 4 categories with 1 comments viewed 20,175 times

Class 60s on 6E41


CFN38547MID18734.jpg

3 files, last one added on Jan 08, 2013
Album viewed 185 times

Another test


CFN52968.JPG

3 files, last one added on Jan 03, 2013
Album viewed 164 times

test3 linked photos


CFN32140ZMID18355.jpg

0 files, 2 linked files, 2 files total
Album viewed 194 times

3 albums on 1 page(s)