Changeset 20202 for extensions/Piwecard/install/functions.inc.php

Timestamp:

Jan 17, 2013, 12:06:49 AM (11 years ago)

Author:

julien1311

Message:

[piwecard] several changes (almost 2.4.a.b4)

File:

• extensions/Piwecard/install/functions.inc.php (modified) (5 diffs)

extensions/Piwecard/install/functions.inc.php

@@ -2 +2 @@
 function piwecard_db_create($table) {
         $query = 'CREATE TABLE ' . $table . ' (
-                                                id CHAR(64) NOT NULL,
+                                                unique_id INT NOT NULL AUTO_INCREMENT,
+                                                ecard_id CHAR(64) NOT NULL,
                                                 sender_name CHAR(100) NOT NULL,
                                                 sender_email CHAR(100) NOT NULL,
@@ -12 +13 @@
                                                 date_creation DATETIME NOT NULL,
                                                 date_validity DATETIME DEFAULT NULL,
-                                                PRIMARY KEY (id)
+                                                PRIMARY KEY (unique_id)
                                         ) DEFAULT CHARSET=utf8;';
         pwg_query($query);
@@ -22 +23 @@
 }
 
-function piwecard_db_populate($old_table, $new_table) {
+function piwecard_db_update_from_2_3($old_table, $new_table) {
         $query = 'SELECT * FROM '.$old_table.';';
         $result = pwg_query($query);
@@ -28 +29 @@
         while($data = pwg_db_fetch_assoc($result)) {
                 $insert = array(
-                                        'id' => $data['numero'],
+                                        'ecard_id' => $data['numero'],
                                         'sender_name' => $data['nomexp'],
                                         'sender_email' => $data['adrexp'],
@@ -48 +49 @@
 }
 
+function piwecard_db_update_from_2_4a_b3($table) {
+        $query = 'ALTER TABLE '.$table.' DROP PRIMARY KEY;';
+        $result = pwg_query($query);
+        $query = 'ALTER TABLE '.$table.' ADD unique_id INT NOT NULL AUTO_INCREMENT FIRST, ADD PRIMARY KEY (unique_id);';
+        $result = pwg_query($query);
+        $query = 'ALTER TABLE '.$table.' CHANGE id ecard_id CHAR(64) NOT NULL;';
+        $result = pwg_query($query);
+}
+
 function piwecard_conf_create($name) {
         $query = 'INSERT INTO '.CONFIG_TABLE.' (param,value,comment) VALUES ("'.$name.'","","'.ucfirst($name).' configuration");';