Changes between Version 90 and Version 91 of PS1_IPP_Czarlog_20121126

Timestamp:

Nov 29, 2012, 3:42:35 PM (14 years ago)

Author:

watersc1

Comment:

--

PS1_IPP_Czarlog_20121126

@@ -116 +116 @@
 Rows matched: 1  Changed: 1  Warnings: 0
 }}}
+ * 15:38 CZW: isp database changes finished:
+{{{
+mysql> select * from dbversion;
++----------------+---------------------+
+| schema_version | updated             |
++----------------+---------------------+
+| 1.1.71         | 2012-01-31 15:42:51 | 
++----------------+---------------------+
+1 row in set (0.02 sec)
+
+mysql> ALTER TABLE warpSkyfile add column background_model SMALLINT after maskfrac_advisory;
+Query OK, 159282 rows affected (5.34 sec)
+Records: 159282  Duplicates: 0  Warnings: 0
+
+mysql> ALTER TABLE stackSumSkyfile add column background_model SMALLINT after software_ver;
+Query OK, 80 rows affected (1.05 sec)
+Records: 80  Duplicates: 0  Warnings: 0
+
+mysql> ALTER TABLE skycalResult ADD column n_detections INT after n_astrom;
+ERROR 1146 (42S02): Table 'isp.skycalResult' doesn't exist
+mysql> UPDATE dbversion set schema_version = '1.1.72', updated= CURRENT_TIMESTAMP();
+Query OK, 1 row affected (0.00 sec)
+Rows matched: 1  Changed: 1  Warnings: 0
+}}}
+ * 15:39 CZW: ssp database changes finished:
+{{{
+
+select * from dbversion
+    -> ;
++--------------------+---------------------+
+| schema_version     | updated             |
++--------------------+---------------------+
+| 1.1.71717171717171 | 2012-01-31 19:52:32 | 
++--------------------+---------------------+
+1 row in set (0.05 sec)
+
+mysql> ALTER TABLE warpSkyfile add column background_model SMALLINT after maskfrac_advisory;
+Query OK, 0 rows affected (1.10 sec)
+Records: 0  Duplicates: 0  Warnings: 0
+
+mysql> ALTER TABLE stackSumSkyfile add column background_model SMALLINT after software_ver;
+Query OK, 0 rows affected (1.00 sec)
+Records: 0  Duplicates: 0  Warnings: 0
+
+mysql> ALTER TABLE skycalResult ADD column n_detections INT after n_astrom;
+Query OK, 0 rows affected (0.81 sec)
+Records: 0  Duplicates: 0  Warnings: 0
+
+mysql> ALTER TABLE skycalResult ADD column n_extended INT after n_detections;
+Query OK, 0 rows affected (0.63 sec)
+Records: 0  Duplicates: 0  Warnings: 0
+
+mysql> UPDATE dbversion set schema_version = '1.1.72', updated= CURRENT_TIMESTAMP();
+Query OK, 1 row affected (0.00 sec)
+Rows matched: 1  Changed: 1  Warnings: 0
+}}}
+ * 15:40 CZW: No changes made to megacam database:
+{{{
+mysql> select * from dbversion;
++----------------+---------------------+
+| schema_version | updated             |
++----------------+---------------------+
+| 1.1.69         | 2012-03-22 11:30:59 | 
++----------------+---------------------+
+1 row in set (0.08 sec)
+}}}
+ * 15:42 CZW: uip database changes finished:
+{{{
+
+mysql> select * from dbversion;
++--------------------+---------------------+
+| schema_version     | updated             |
++--------------------+---------------------+
+| 1.1.71717171717171 | 2012-02-29 12:02:53 | 
++--------------------+---------------------+
+1 row in set (0.08 sec)
+
+mysql> ALTER TABLE warpSkyfile add column background_model SMALLINT after maskfrac_advisory;
+Query OK, 0 rows affected (1.04 sec)
+Records: 0  Duplicates: 0  Warnings: 0
+
+mysql> ALTER TABLE stackSumSkyfile add column background_model SMALLINT after software_ver;
+Query OK, 0 rows affected (1.00 sec)
+Records: 0  Duplicates: 0  Warnings: 0
+
+mysql> ALTER TABLE skycalResult ADD column n_detections INT after n_astrom;
+Query OK, 0 rows affected (0.84 sec)
+Records: 0  Duplicates: 0  Warnings: 0
+
+mysql> ALTER TABLE skycalResult ADD column n_extended INT after n_detections;
+Query OK, 0 rows affected (0.65 sec)
+Records: 0  Duplicates: 0  Warnings: 0
+
+mysql> UPDATE dbversion set schema_version = '1.1.72', updated= CURRENT_TIMESTAMP();
+Query OK, 1 row affected (0.00 sec)
+Rows matched: 1  Changed: 1  Warnings: 0
+}}}
 === Friday : 2012.11.29 ===