1 files changed, 49 insertions, 0 deletions
diff --git a/plugins/picasa-albums/1.0.5/scb/Table.php b/plugins/picasa-albums/1.0.5/scb/Table.php
new file mode 100644
index 00000000..b4529b88
--- /dev/null
+++ b/plugins/picasa-albums/1.0.5/scb/Table.php
@@ -0,0 +1,49 @@
+<?php
+
+// Takes care of creating, updating and deleting database tables
+class scbTable {
+	protected $name;
+	protected $columns;
+	protected $upgrade_method;
+
+	function __construct( $name, $file, $columns, $upgrade_method = 'dbDelta' ) {
+		global $wpdb;
+
+		$this->name = $wpdb->$name = $wpdb->prefix . $name;
+		$this->columns = $columns;
+		$this->upgrade_method = $upgrade_method;
+
+		scbUtil::add_activation_hook( $file, array( $this, 'install' ) );
+		scbUtil::add_uninstall_hook( $file, array( $this, 'uninstall' ) );
+	}
+
+	function install() {
+		global $wpdb;
+
+		$charset_collate = '';
+		if ( $wpdb->has_cap( 'collation' ) ) {
+			if ( ! empty( $wpdb->charset ) )
+				$charset_collate = "DEFAULT CHARACTER SET $wpdb->charset";
+			if ( ! empty( $wpdb->collate ) )
+				$charset_collate .= " COLLATE $wpdb->collate";
+		}
+
+		if ( 'dbDelta' == $this->upgrade_method ) {
+			require_once ABSPATH . 'wp-admin/includes/upgrade.php';
+			dbDelta( "CREATE TABLE $this->name ( $this->columns ) $charset_collate" );		
+			return;
+		}
+
+		if ( 'delete_first' == $this->upgrade_method )
+			$wpdb->query( "DROP TABLE IF EXISTS $this->name;" );
+
+		$wpdb->query( "CREATE TABLE IF NOT EXISTS $this->name ( $this->columns ) $charset_collate;" );
+	}
+
+	function uninstall() {
+		global $wpdb;
+
+		$wpdb->query( "DROP TABLE IF EXISTS $this->name" );
+	}
+}
+