use [% cpm %];
#
# MySQLDiff 1.5.0
#
# http://www.mysqldiff.org
# (c) 2001-2004, Lippe-Net Online-Service
#
# Create time: 15.01.2008 14:29
#
# --------------------------------------------------------
# Source info
# Host: localhost
# Database: dedipco_cpm1
# --------------------------------------------------------
# Target info
# Host: localhost
# Database: dedipco_cmafter
# --------------------------------------------------------
#

SET FOREIGN_KEY_CHECKS = 0;
INSERT INTO [% table_prefix %]_config VALUES ('admin_activation', '0');

#
# DDL START
#
ALTER TABLE [% table_prefix %]_albums
    COMMENT='Used to store albums';


ALTER TABLE [% table_prefix %]_banned
    COMMENT='Data about banned users';


ALTER TABLE [% table_prefix %]_bridge
    COMMENT='Stores the bridging data, not used when unbridged';


ALTER TABLE [% table_prefix %]_categories
    COMMENT='Used to store categories';


ALTER TABLE [% table_prefix %]_comments
    COMMENT='Used to store comments made on pics';


ALTER TABLE [% table_prefix %]_config
    COMMENT='Used to store the configuration options';


ALTER TABLE [% table_prefix %]_exif
    COMMENT='Stores EXIF data from individual pics';


ALTER TABLE [% table_prefix %]_hit_stats
    COMMENT='Detailed stats about hits, only used when enabled';


ALTER TABLE [% table_prefix %]_pictures
    COMMENT='Used to store data about individual pics';


ALTER TABLE [% table_prefix %]_usergroups
    COMMENT='Used to store user groups';


ALTER TABLE [% table_prefix %]_users
    COMMENT='Used to store users, not used when bridged';


ALTER TABLE [% table_prefix %]_vote_stats
    COMMENT='Detailed stats about votes, only used when enabled';


ALTER TABLE [% table_prefix %]_votes
    COMMENT='Stores votes for individual pics';


#
# DDL END
#

SET FOREIGN_KEY_CHECKS = 1;
