Attachment #3319 for bug #6097

View | Details | Raw Unified | Return to bug 6097
Collapse All | Expand All

(-)a/dbscripts/xml/upgrade.xml (+5 lines)

Lines 231-236	Link Here

231

		<note file="docs/release-notes/README-2.3.4" />

231

		<note file="docs/release-notes/README-2.3.4" />

232

	</upgrade>

232

	</upgrade>

233

234

    <upgrade minversion="2.2.3.0" maxversion="2.3.2.0">

235

        <!-- COUNTER - counter_monthly_log update.-->

236

        <data file="plugins/generic/counter/counter_monthly_log_1_1.xml" />

237

    </upgrade>

238

234

	<!-- update plugin configuration - should be done as the final upgrade task -->

239

	<!-- update plugin configuration - should be done as the final upgrade task -->

235

	<code function="addPluginVersions" />

240

	<code function="addPluginVersions" />

236

</install>

241

</install>

(-)a/plugins/generic/counter/counter_monthly_log_1_1.xml (-4 / +20 lines)

Lines 2-8	Link Here

<!DOCTYPE data SYSTEM "../../../lib/pkp/dtd/xmlData.dtd">

<!DOCTYPE data SYSTEM "../../../lib/pkp/dtd/xmlData.dtd">

<!--

<!--

  * counter_monthly_log_1_7.xml

  * counter_monthly_log_1_1.xml

  * Copyright (c) 2003-2010 John Willinsky

  * Copyright (c) 2003-2010 John Willinsky

  * Distributed under the GNU GPL v2. For full terms see the file docs/COPYING.

  * Distributed under the GNU GPL v2. For full terms see the file docs/COPYING.

Lines 15-48	Link Here

  <!-- rename current table to _old -->

  <!-- rename current table to _old -->

  <sql>

  <sql>

    <query driver="mysql">

    <query>

      ALTER TABLE counter_monthly_log RENAME TO counter_monthly_log_old

      ALTER TABLE counter_monthly_log RENAME TO counter_monthly_log_old

    </query>

    </query>

  </sql>

  </sql>

  <!-- create new counter_monthly_log with a new schema -->

  <!-- create new counter_monthly_log with a new schema -->

  <sql>

  <sql>

    <query driver="mysql">

    <query driver="mysql">

      CREATE TABLE counter_monthly_log ( year int(11) NOT NULL, month int(11) NOT NULL, journal_id int(11) NOT NULL, count_html int(20) NOT NULL DEFAULT 0, count_pdf int(20) NOT NULL DEFAULT 0, count_other int(20) NOT NULL DEFAULT 0, UNIQUE KEY counter_monthly_log_ukey (year,month,journal_id) )

      CREATE TABLE counter_monthly_log ( year int(11) NOT NULL, month int(11) NOT NULL, journal_id int(11) NOT NULL, count_html int(20) NOT NULL DEFAULT 0, count_pdf int(20) NOT NULL DEFAULT 0, count_other int(20) NOT NULL DEFAULT 0, UNIQUE KEY counter_monthly_log_ukey (year,month,journal_id) )

    </query>

    </query>

    <!-- Same thing for postgres, probably only works on PG 8.x -->

    <query driver="postgres7">

      CREATE TABLE counter_monthly_log ( year INT8 NOT NULL, journal_id INT8 NOT NULL, month INT8 NOT NULL, count_html INT8 DEFAULT 0 NOT NULL, count_pdf INT8 DEFAULT 0 NOT NULL, count_other INT8 DEFAULT 0 NOT NULL)

    </query>

    <query driver="postgres7">

      CREATE UNIQUE INDEX counter_monthly_log_key ON counter_monthly_log (year, month, journal_id)

    </query>

  </sql>

  </sql>

  <!-- pull data out of _old table and insert into new table, assume 0 for count_html, count_other -->

  <!-- pull data out of _old table and insert into new table, assume 0 for count_html, count_other -->

  <sql>

  <sql>

    <query driver="mysql">

    <query>

      INSERT INTO counter_monthly_log (year,month,journal_id,count_html,count_pdf,count_other) SELECT year, 1 as month, journal_id, 0, count_jan as count, 0 FROM counter_monthly_log_old UNION SELECT year, 2 as month, journal_id, 0, count_feb as count, 0 FROM counter_monthly_log_old UNION SELECT year, 3 as month, journal_id, 0, count_mar as count, 0 FROM counter_monthly_log_old UNION SELECT year, 4 as month, journal_id, 0, count_apr as count, 0 FROM counter_monthly_log_old UNION SELECT year, 5 as month, journal_id, 0, count_may as count, 0 FROM counter_monthly_log_old UNION SELECT year, 6 as month, journal_id, 0, count_jun as count, 0 FROM counter_monthly_log_old UNION SELECT year, 7 as month, journal_id, 0, count_jul as count, 0 FROM counter_monthly_log_old UNION SELECT year, 8 as month, journal_id, 0, count_aug as count, 0 FROM counter_monthly_log_old UNION SELECT year, 9 as month, journal_id, 0, count_sep as count, 0 FROM counter_monthly_log_old UNION SELECT year, 10 as month, journal_id, 0, count_oct as count, 0 FROM counter_monthly_log_old UNION SELECT year, 11 as month, journal_id, 0, count_nov as count, 0 FROM counter_monthly_log_old UNION SELECT year, 12 as month, journal_id, 0, count_dec as count, 0 FROM counter_monthly_log_old ORDER BY journal_id, year, month

      INSERT INTO counter_monthly_log (year,month,journal_id,count_html,count_pdf,count_other) SELECT year, 1 as month, journal_id, 0, count_jan as count, 0 FROM counter_monthly_log_old UNION SELECT year, 2 as month, journal_id, 0, count_feb as count, 0 FROM counter_monthly_log_old UNION SELECT year, 3 as month, journal_id, 0, count_mar as count, 0 FROM counter_monthly_log_old UNION SELECT year, 4 as month, journal_id, 0, count_apr as count, 0 FROM counter_monthly_log_old UNION SELECT year, 5 as month, journal_id, 0, count_may as count, 0 FROM counter_monthly_log_old UNION SELECT year, 6 as month, journal_id, 0, count_jun as count, 0 FROM counter_monthly_log_old UNION SELECT year, 7 as month, journal_id, 0, count_jul as count, 0 FROM counter_monthly_log_old UNION SELECT year, 8 as month, journal_id, 0, count_aug as count, 0 FROM counter_monthly_log_old UNION SELECT year, 9 as month, journal_id, 0, count_sep as count, 0 FROM counter_monthly_log_old UNION SELECT year, 10 as month, journal_id, 0, count_oct as count, 0 FROM counter_monthly_log_old UNION SELECT year, 11 as month, journal_id, 0, count_nov as count, 0 FROM counter_monthly_log_old UNION SELECT year, 12 as month, journal_id, 0, count_dec as count, 0 FROM counter_monthly_log_old ORDER BY journal_id, year, month

    </query>

    </query>

  </sql>

  </sql>

  <!-- remove the _old table -->

  <!-- remove the _old table -->

  <sql>

  <sql>

    <query driver="mysql">

    <query driver="mysql">

      DROP TABLE IF EXISTS counter_monthly_log_old

      DROP TABLE IF EXISTS counter_monthly_log_old

    </query>

    </query>

    <query driver="postgres7">

      DROP TABLE counter_monthly_log_old CASCADE

    </query>

  </sql>

  </sql>

  <!-- create indexes or primary key -->

</data>

</data>

Return to bug 6097