Developers of Sympa

[IKEDA Soji <address@concealed>]

Hi,

[-dev] Restoring previous key for stat_counter_table. The composed primary key proposed breaks upgrade for previous install, which don't necessary match the constraints defined by this key.

I suppose it won't work anyway, because this column won't allow Null.

How about making it auto-increment?

Regards,

--- Soji

2015/03/04 18:33、address@concealed のメッセージ:

sympa[12015] branches/sympa-6.2-branch/src/lib/Sympa/DatabaseDescription.pm: [-dev] Restoring previous key for stat_counter_table.

Revision

12015

Author

david.verdin

Date

2015-03-04 10:33:56 +0100 (mer. 04 mars 2015)

Log Message

[-dev] Restoring previous key for stat_counter_table. The composed primary key proposed breaks upgrade for previous install, which don't necessary match the constraints defined by this key.

Modified Paths

• branches/sympa-6.2-branch/src/lib/Sympa/DatabaseDescription.pm

Diff

Modified: branches/sympa-6.2-branch/src/lib/Sympa/DatabaseDescription.pm (12014 => 12015)

--- branches/sympa-6.2-branch/src/lib/Sympa/DatabaseDescription.pm	2015-03-04 08:33:06 UTC (rev 12014)
+++ branches/sympa-6.2-branch/src/lib/Sympa/DatabaseDescription.pm	2015-03-04 09:33:56 UTC (rev 12015)
@@ -734,18 +734,17 @@
     },
     'stat_counter_table' => {
         'fields' => {
-            #'id_counter' => {
-            #    'struct'   => 'bigint(20)',
-            #    'doc'      => '',
-            #    'order'    => 1,
-            #    'primary'  => 1,
-            #    'not_null' => 1,
-            #},
+            'id_counter' => {
+                'struct'   => 'bigint(20)',
+                'doc'      => '',
+                'order'    => 1,
+                'primary'  => 1,
+                'not_null' => 1,
+            },
             'beginning_date_counter' => {
                 'struct'   => 'int(11)',
                 'doc'      => '',
                 'order'    => 2,
-                'primary'  => 1,
                 'not_null' => 1,
             },
             'end_date_counter' => {
@@ -756,21 +755,18 @@
             'data_counter' => {
                 'struct'   => 'varchar(50)',
                 'doc'      => '',
-                'primary'  => 1,
                 'not_null' => 1,
                 'order'    => 3,
             },
             'robot_counter' => {
                 'struct'   => $robot_struct,
                 'doc'      => '',
-                'primary'  => 1,
                 'not_null' => 1,
                 'order'    => 4,
             },
             'list_counter' => {
                 'struct'  => $list_struct,
                 'doc'     => '',
-                'primary' => 1,
                 'order'   => 5,
             },
             #'variation_counter' => {