Changes between Version 1 and Version 2 of SqlConstantsPlugin

Timestamp:

Jun 11, 2015, 7:31:41 PM (9 years ago)

Author:

figaro

Comment:

Cosmetic changes, tagged with license

SqlConstantsPlugin

@@ -1 @@
-= SQL Constants =
+[[PageOutline(2-5,Contents,pullout)]]
 
-== Description ==
+= Maintain list of static data as key-value pairs in SQL
+
+== Description
 
 This plugin adds a new administration control panel that can be used to manage constants (key/value pairs) stored in the database. These can then be used in report queries.
 
-== Bugs/Feature Requests == 
+== Bugs/Feature Requests
 
 Existing bugs and feature requests for SqlConstantsPlugin are 
@@ -11 +13 @@
 
 If you have any issues, create a 
-[http://trac-hacks.org/newticket?component=SqlConstantsPlugin&owner=optilude new ticket].
+[/newticket?component=SqlConstantsPlugin new ticket].
 
-== Download ==
+[[TicketQuery(component=SqlConstantsPlugin,group=type,format=progress)]]
+
+== Download
 
 Download the zipped source from [download:sqlconstantsplugin here].
 
-== Source ==
+== Source
 
 You can check out SqlConstantsPlugin from [http://trac-hacks.org/svn/sqlconstantsplugin here] using Subversion, or [source:sqlconstantsplugin browse the source] with Trac.
 
-== Example ==
+== Example
 
-Simply install the plugin as normal, and add a table like this to the database:
+Install the plugin as normal, and add a table like this to the database:
 
-{{{
-        CREATE TABLE `constants` (
-          `constant` varchar(255) NOT NULL,
-          `stringval` varchar(255) DEFAULT NULL,
-          `intval` int(11) DEFAULT NULL,
-          `floatval` float DEFAULT NULL,
-          PRIMARY KEY (`constant`)
-        );
+{{{#!sql
+CREATE TABLE `constants` (
+  `constant` VARCHAR(255) NOT NULL,
+  `stringval` VARCHAR(255) DEFAULT NULL,
+  `intval` INT(11) DEFAULT NULL,
+  `floatval` FLOAT DEFAULT NULL,
+  PRIMARY KEY (`constant`)
+);
 }}}
 
-You can then use this in report queries. The stringval column will always be stored. intval and floatval will contain the int/float equivalent if possible (i.e. the input could be cast to an int).
+You can then use this in report queries. The `stringval` column will always be stored. Also, `intval` and `floatval` will contain the int/float equivalent if possible, ie the input could be cast to an INT.
 
 Visit the administration panel to update constants.
 
-== Recent Changes ==
+== Recent Changes
 
 [[ChangeLog(sqlconstantsplugin, 3)]]
 
-== Author/Contributors ==
+== Author/Contributors
 
 '''Author:''' [wiki:optilude] [[BR]]
+'''Maintainer:''' [[Maintainer]] [[BR]]
 '''Contributors:'''