Location: PHPKode > projects > Content*Builder > contentbuilder/system/setup/updates/update_053_060.php
<?php

// start 0.5.3 - 0.6 Updates
	$tmpQuery = mysql_query("CREATE TABLE ".TABLE."_comment (
		commentID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, 
		type VARCHAR(20) NOT NULL, 
		entryID VARCHAR(20) NOT NULL, 
		author VARCHAR(50) NOT NULL, 
		title VARCHAR(255) NOT NULL, 
		text TEXT NOT NULL, 
		datetime DATETIME NOT NULL,
		homepage VARCHAR(255) NOT NULL, 
		email VARCHAR(100) NOT NULL
	);");  
	$tmpQuery = mysql_query("ALTER TABLE ".TABLE."_comment COMMENT = 'v0.1'");
	// add art templates for articleML
	$tmpQuery = mysql_query("ALTER TABLE ".TABLE."_art_general ADD template VARCHAR( 255 ) DEFAULT 'default' NOT NULL");
	$tmpQuery = mysql_query("ALTER TABLE ".TABLE."_art_general COMMENT = 'v.01'");
	// Update column table
	$tmpQuery = mysql_query("ALTER TABLE ".TABLE."_columns CHANGE groupsAllowed groupsAllowed VARCHAR( 255 ) NULL");
	$tmpQuery = mysql_query("ALTER TABLE ".TABLE."_columns COMMENT = 'v.03'");
	// Update File Table
	$tmpQuery = mysql_query("ALTER TABLE ".TABLE."_mm_files ADD thumbnailID VARCHAR(100) NOT NULL");
	$tmpQuery = mysql_query("ALTER TABLE ".TABLE."_mm_files CHANGE online options BIGINT(32) UNSIGNED NOT NULL");
	$tmpQuery = mysql_query("ALTER TABLE ".TABLE."_mm_files COMMENT = 'v0.1'");
	// Update poll table ... Add IP Lock table
	$tmpQuery = mysql_query("CREATE TABLE ".TABLE."_ip_table (
		insertID INT(8) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, 
		ip VARCHAR(15) NOT NULL, 
		time VARCHAR(10) DEFAULT NULL, 
		module CHAR(20) NOT NULL,
		entryID VARCHAR(20) NOT NULL);");
	$tmpQuery = mysql_query("ALTER TABLE ".TABLE."_ip_table COMMENT = 'v0.1'");
	// Update User Tables
	$tmpQuery = mysql_query("CREATE TABLE ".TABLE."_user_group_relation (
		userID VARCHAR(32) NOT NULL, 
		groupID INT(6) NOT NULL);");
	$tmpQuery = mysql_query("ALTER TABLE ".TABLE."_user_group_relation ADD UNIQUE (userID,groupID)");
	$tmpQuery = mysql_query("ALTER TABLE ".TABLE."_user_group_relation COMMENT = 'v.01'");
	$tmpQuery = mysql_query("ALTER TABLE ".TABLE."_usergroups ADD groupType int(10) unsigned NOT NULL default '0'");
	$tmpQuery = mysql_query("ALTER TABLE ".TABLE."_usergroups COMMENT = 'v0.2'");
// end 0.5.3 - 0.6 Updates

?>
Return current item: Content*Builder