From 9c7b5fab0cdef4124037953bb4a8e8e0db89736f Mon Sep 17 00:00:00 2001
From: Jan Schneider <jan@horde.org>
Date: Fri, 28 Jan 2011 18:24:11 +0100
Subject: [PATCH] Convert Horde_Core_Auth_Signup to migrations.

---
 .../Horde/Core/1_horde_core_base_tables.php          | 20 ++++++++++++++++++++
 horde/scripts/sql/horde_signups.mysql.sql            |  7 -------
 horde/scripts/sql/horde_signups.sql                  |  7 -------
 .../upgrades/2009-09-10_horde_signup_drop_email.sql  |  1 -
 4 files changed, 20 insertions(+), 15 deletions(-)
 create mode 100644 framework/Core/migration/Horde/Core/1_horde_core_base_tables.php
 delete mode 100644 horde/scripts/sql/horde_signups.mysql.sql
 delete mode 100644 horde/scripts/sql/horde_signups.sql
 delete mode 100644 horde/scripts/upgrades/2009-09-10_horde_signup_drop_email.sql

diff --git a/framework/Core/migration/Horde/Core/1_horde_core_base_tables.php b/framework/Core/migration/Horde/Core/1_horde_core_base_tables.php
new file mode 100644
index 000000000..8c10c6271
--- /dev/null
+++ b/framework/Core/migration/Horde/Core/1_horde_core_base_tables.php
@@ -0,0 +1,20 @@
+<?php
+class HordeCoreBaseTables extends Horde_Db_Migration_Base
+{
+    public function up()
+    {
+        if (!in_array('horde_signups', $this->tables())) {
+            $t = $this->createTable('horde_signups', array('primaryKey' => array('user_name')));
+            $t->column('user_name', 'string', array('limit' => 255, 'null' => false));
+            $t->column('signup_date', 'integer', array('null' => false));
+            $t->column('signup_host', 'string', array('limit' => 255, 'null' => false));
+            $t->column('signup_data', 'text', array('null' => false));
+            $t->end();
+        }
+    }
+
+    public function down()
+    {
+        $this->dropTable('horde_signups');
+    }
+}
diff --git a/horde/scripts/sql/horde_signups.mysql.sql b/horde/scripts/sql/horde_signups.mysql.sql
deleted file mode 100644
index 37233672e..000000000
--- a/horde/scripts/sql/horde_signups.mysql.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-CREATE TABLE horde_signups (
-    user_name VARCHAR(255) NOT NULL,
-    signup_date VARCHAR(255) NOT NULL,
-    signup_host VARCHAR(255) NOT NULL,
-    signup_data TEXT NOT NULL,
-    PRIMARY KEY user_name (user_name)
-);
diff --git a/horde/scripts/sql/horde_signups.sql b/horde/scripts/sql/horde_signups.sql
deleted file mode 100644
index 1fbb4293b..000000000
--- a/horde/scripts/sql/horde_signups.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-CREATE TABLE horde_signups (
-    user_name VARCHAR(255) NOT NULL,
-    signup_date INTEGER NOT NULL,
-    signup_host VARCHAR(255) NOT NULL,
-    signup_data TEXT NOT NULL,
-    PRIMARY KEY (user_name)
-);
diff --git a/horde/scripts/upgrades/2009-09-10_horde_signup_drop_email.sql b/horde/scripts/upgrades/2009-09-10_horde_signup_drop_email.sql
deleted file mode 100644
index decd11c07..000000000
--- a/horde/scripts/upgrades/2009-09-10_horde_signup_drop_email.sql
+++ /dev/null
@@ -1 +0,0 @@
-ALTER TABLE horde_signups DROP COLUMN signup_email;
-- 
2.11.0