CREATE TABLE `clipbucket_svn`.`cb_collection_cateogries` ( `category_id` INT( 255 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , `category_name` VARCHAR( 30 ) NOT NULL , `category_order` INT( 5 ) NOT NULL , `category_desc` TEXT NOT NULL , `date_added` MEDIUMTEXT NOT NULL , `category_thumb` MEDIUMINT NOT NULL , `isdefault` ENUM( 'yes', 'no' ) NOT NULL ) ENGINE = InnoDB ; CREATE TABLE IF NOT EXISTS `cb_collections` ( `collection_id` bigint(25) NOT NULL AUTO_INCREMENT, `collection_name` varchar(225) NOT NULL, `collection_description` text NOT NULL, `collection_tags` text NOT NULL, `category` varchar(20) NOT NULL, `userid` int(10) NOT NULL, `views` bigint(20) NOT NULL, `date_added` datetime NOT NULL, `featured` varchar(4) NOT NULL, `broadcast` varchar(10) NOT NULL, `allow_comments` varchar(4) NOT NULL, `total_comments` bigint(20) NOT NULL, `total_objects` bigint(20) NOT NULL, `active` varchar(4) NOT NULL, `public_upload` varchar(4) NOT NULL, `type` varchar(10) NOT NULL, PRIMARY KEY (`collection_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; ALTER TABLE `cb_collections` CHANGE `broadcast` `broadcast` VARCHAR( 10 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'public', CHANGE `allow_comments` `allow_comments` VARCHAR( 4 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'yes', CHANGE `active` `active` VARCHAR( 4 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'yes', CHANGE `public_upload` `public_upload` VARCHAR( 4 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'yes' CREATE TABLE IF NOT EXISTS `cb_collection_items` ( `ci_id` bigint(20) NOT NULL AUTO_INCREMENT, `collection_id` bigint(20) NOT NULL, `object_id` bigint(20) NOT NULL, `userid` bigint(20) NOT NULL, `type` varchar(10) NOT NULL, `date_added` datetime NOT NULL, PRIMARY KEY (`ci_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; INSERT INTO `cb_email_templates` (`email_template_id`, `email_template_name`, `email_template_code`, `email_template_subject`, `email_template`, `email_template_allowed_tags`) VALUES (NULL, 'Collection Share Template', 'collection_share_template', '{username} wants to share collection with you', '

{website_title}

{username} wants to share this collection with you.

Collection Description
{description}

Personal Message
{user_message}

Thanks,
{website_title}

copyrights {date_year} {website_title}

', '');