From: Jason Woofenden <jason@jasonwoof.com>
Date: Fri, 29 Jun 2012 17:45:18 +0000 (-0400)
Subject: metaform: make generated databases case sensitive
X-Git-Url: https://jasonwoof.com/gitweb/?p=wfpl.git;a=commitdiff_plain;h=3e70448969d205f3387edc245c6b52d01ae9ab75

metaform: make generated databases case sensitive
---

diff --git a/metaform.php b/metaform.php
index 1cd27f5..b4ec6e0 100644
--- a/metaform.php
+++ b/metaform.php
@@ -26,33 +26,33 @@ require_once('code/wfpl/format.php');
 # see code/wfpl/metaform/template.html for the html templates for these elements
 $GLOBALS['types'] = array(
 #    type                  input          format        sql     
-	'varname' =>    array('textbox',     'varname',    'varchar(50)'),
-	'name' =>       array('textbox',     'oneline',    'varchar(200)'),
-	'textbox' =>    array('textbox',     'oneline',    'varchar(200)'),
+	'varname' =>    array('textbox',     'varname',    'varchar(50) binary'),
+	'name' =>       array('textbox',     'oneline',    'varchar(200) binary'),
+	'textbox' =>    array('textbox',     'oneline',    'varchar(200) binary'),
 	'int' =>        array('textbox',     'int',        'int'),
 	'decimal' =>    array('textbox',     'decimal',    'decimal(12,12)'),
-	'bigint' =>     array('textbox',     'int',        'varchar(100)'), # up to 100 digits, stored as a string
-	'zip' =>        array('textbox',     'zip',        'varchar(20)'),
-	'email' =>      array('email',       'email',      'varchar(100)'),
-	'search' =>     array('search',      'oneline',    'varchar(200)'),
-	'phone' =>      array('textbox',     'phone',      'varchar(32)'),
-	'state' =>      array('states',      'oneline',    'varchar(2)'),
-	'money' =>      array('textbox',     'money',      'varchar(32)'),
-	'date' =>       array('date',        'mdy_to_ymd', 'char(10)'),
-	'dollars' =>    array('textbox',     'dollars',    'varchar(32)'),
-	'url' =>        array('textbox',     'url',        'varchar(200)'),
-	'hidden' =>     array('hidden',      'unix',       'varchar(200)'),
-	'password' =>   array('password',    'oneline',    'varchar(200)'),
-	'textarea' =>   array('textarea',    'unix',       'text'),
-	'html' =>       array('html',        'unix',       'text'),
-	'pulldown' =>   array('pulldown',    'options',    'varchar(100)'),
-	'radio' =>      array('radio',       'options',    'varchar(100)'),
+	'bigint' =>     array('textbox',     'int',        'varchar(100) binary'), # up to 100 digits, stored as a string
+	'zip' =>        array('textbox',     'zip',        'varchar(20) binary'),
+	'email' =>      array('email',       'email',      'varchar(100) binary'),
+	'search' =>     array('search',      'oneline',    'varchar(200) binary'),
+	'phone' =>      array('textbox',     'phone',      'varchar(32) binary'),
+	'state' =>      array('states',      'oneline',    'varchar(2) binary'),
+	'money' =>      array('textbox',     'money',      'varchar(32) binary'),
+	'date' =>       array('date',        'mdy_to_ymd', 'char(10) binary'),
+	'dollars' =>    array('textbox',     'dollars',    'varchar(32) binary'),
+	'url' =>        array('textbox',     'url',        'varchar(200) binary'),
+	'hidden' =>     array('hidden',      'unix',       'varchar(200) binary'),
+	'password' =>   array('password',    'oneline',    'varchar(200) binary'),
+	'textarea' =>   array('textarea',    'unix',       'text binary'),
+	'html' =>       array('html',        'unix',       'mediumtext binary'),
+	'pulldown' =>   array('pulldown',    'options',    'varchar(100) binary'),
+	'radio' =>      array('radio',       'options',    'varchar(100) binary'),
 	'checkbox' =>   array('checkbox',    'bool',       'int(1)'),
-	'yesno' =>      array('checkbox',    'yesno',      'varchar(3)'),
+	'yesno' =>      array('checkbox',    'yesno',      'varchar(3) binary'),
 	'delete' =>     array('checkbox',    'yesno',      'n/a'),
-	'image' =>      array('image',       'oneline',    'varchar(120)'),
-	'thumb' =>      array('image',       'oneline',    'varchar(240)'),
-	'file' =>       array('file',        'oneline',    'varchar(100)'),
+	'image' =>      array('image',       'oneline',    'varchar(120) binary'),
+	'thumb' =>      array('image',       'oneline',    'varchar(240) binary'),
+	'file' =>       array('file',        'oneline',    'varchar(100) binary'),
 	'submit' =>     array('submit',      'n/a',        'n/a'),
 	'{' =>          array('fieldset',    'n/a',        'n/a'),
 	'}' =>          array('end_fieldset','n/a',        'n/a')