[Logicampus-svn] SF.net SVN: logicampus:[1299] logicampus/trunk/src/public_html
Brought to you by:
trilexcom
Menu
▾
▴
[Logicampus-svn] SF.net SVN: logicampus:[1299] logicampus/trunk/src/public_html
|
From: <fah...@us...> - 2009-02-27 12:20:32
|
Revision: 1299
http://logicampus.svn.sourceforge.net/logicampus/?rev=1299&view=rev
Author: faheemkhan
Date: 2009-02-27 12:20:25 +0000 (Fri, 27 Feb 2009)
Log Message:
-----------
Updated Schema files
Added Paths:
-----------
logicampus/trunk/src/public_html/install/
logicampus/trunk/src/public_html/install/data_01.php
logicampus/trunk/src/public_html/install/data_02.php
logicampus/trunk/src/public_html/install/data_03.php
logicampus/trunk/src/public_html/install/data_04.php
logicampus/trunk/src/public_html/install/data_05.php
logicampus/trunk/src/public_html/install/data_06.php
logicampus/trunk/src/public_html/install/data_07.php
logicampus/trunk/src/public_html/install/data_08.php
logicampus/trunk/src/public_html/install/data_09.php
logicampus/trunk/src/public_html/install/data_10.php
logicampus/trunk/src/public_html/install/data_11.php
logicampus/trunk/src/public_html/install/data_12.php
logicampus/trunk/src/public_html/install/data_13.php
logicampus/trunk/src/public_html/install/data_14.php
logicampus/trunk/src/public_html/install/data_15.php
logicampus/trunk/src/public_html/install/db.php
logicampus/trunk/src/public_html/install/index.php
logicampus/trunk/src/public_html/install/install_done.php
logicampus/trunk/src/public_html/install/install_proc.php
logicampus/trunk/src/public_html/install/schema_01.php
logicampus/trunk/src/public_html/install/schema_02.php
logicampus/trunk/src/public_html/install/schema_03.php
logicampus/trunk/src/public_html/install/schema_04.php
logicampus/trunk/src/public_html/install/schema_05.php
logicampus/trunk/src/public_html/install/schema_06.php
logicampus/trunk/src/public_html/install/schema_07.php
logicampus/trunk/src/public_html/install/schema_08.php
logicampus/trunk/src/public_html/install/schema_09.php
logicampus/trunk/src/public_html/install/schema_10.php
logicampus/trunk/src/public_html/install/schema_11.php
logicampus/trunk/src/public_html/install/schema_12.php
logicampus/trunk/src/public_html/install/schema_13.php
logicampus/trunk/src/public_html/install/schema_14.php
logicampus/trunk/src/public_html/install/schema_15.php
logicampus/trunk/src/public_html/install/schema_16.php
logicampus/trunk/src/public_html/install/schema_17.php
logicampus/trunk/src/public_html/install/schema_18.php
logicampus/trunk/src/public_html/install/schema_19.php
logicampus/trunk/src/public_html/install/schema_20.php
logicampus/trunk/src/public_html/install/schema_21.php
logicampus/trunk/src/public_html/install/schema_22.php
logicampus/trunk/src/public_html/install/schema_23.php
logicampus/trunk/src/public_html/install/schema_24.php
logicampus/trunk/src/public_html/install/schema_25.php
logicampus/trunk/src/public_html/install/schema_26.php
logicampus/trunk/src/public_html/install/schema_27.php
logicampus/trunk/src/public_html/install/schema_28.php
logicampus/trunk/src/public_html/install/schema_29.php
logicampus/trunk/src/public_html/install/schema_30.php
logicampus/trunk/src/public_html/install/schema_31.php
logicampus/trunk/src/public_html/install/schema_32.php
logicampus/trunk/src/public_html/install/schema_33.php
logicampus/trunk/src/public_html/install/schema_34.php
Added: logicampus/trunk/src/public_html/install/data_01.php
===================================================================
--- logicampus/trunk/src/public_html/install/data_01.php (rev 0)
+++ logicampus/trunk/src/public_html/install/data_01.php 2009-02-27 12:20:25 UTC (rev 1299)
@@ -0,0 +1,264 @@
+<?
+$installTableSchemas = array();
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (1, 1, 'text', 'name', 'Enter your name', '', '', 'default', '', 'Y', '', 3, 15, 'Y', 1, 15, 25, '', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (2, 1, 'textarea', 'body', 'Enter your\nmessage', '', '', 'default', '', 'Y', '<h3>', 1, 65535, 'Y', 2, 0, 25, '', '', '', '', 25, 15, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', 'N')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (3, 1, 'text', 'email', 'Enter your\nemail\naddress', '', '', 'email', '(email must be a valid email\naddress)', 'Y', '', 5, 100, 'Y', 3, 15, 100, '', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (4, 1, 'hidden', 'formId', '', '1', '', '', '', '', '', 0, 0, 'N', 4, 0, 0, '', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (7, 1, 'row', '', '', 'Enter your message\nbelow.\nSomeone will contact you shortly.', '', '', '', '', '', 0, 0, '', 5, 0, 0, '', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (6, 1, 'text', 'subject', 'Enter your Subject', '', '', 'default', '', 'Y', '', 3, 25, 'Y', 6, 15, 25, '', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (8, 2, 'text', 'name', 'Enter a name for\nyour\nform', '', '', 'default', '(Example: "User\nProfile")', 'Y', '', 5, 75, 'Y', 2, 25, 75, '', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (9, 2, 'textarea', 'description', 'Enter\na\ndescription', '', '', 'default', '', 'Y', '', 1, 65535, 'Y', 3, 0, 0, '', '', '', '', 25, 10, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', 'N')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (10, 2, 'text', 'action', 'What is\nthe\n"action" of your form?', '', '', 'default', 'Example:\nhttp://www.site.com/form.php', 'Y', '', 3, 100, 'N', 16, 25, 100, '', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (149, 2, 'select', 'method', 'Enter the\nform\nmethod', 'POST', '', 'select', 'There are two types of\nmethods, GET\nand POST. Select one.', 'N', '', 1, 1, 'Y', 5, 1, 0, 'POST=POST,GET=GET', '', 'N', 'N', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (12, 2, 'text', 'target', 'Enter the target\nof\nyour form', '', '', 'default', '(normally used with frames)', 'Y', '', 3, 25, 'N', 15, 25, 25, '', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (13, 2, 'select', 'enctype', 'Form encoding\ntype', 'application/x-www-form-urlencoded', '', 'default', '(select\nmultipart/form-data if you are building a form to handle file\nuploads)', 'N', '', 1, 25, 'N', 17, 1, 2, 'application/x-www-form-urlencoded=application/x-www-form-urlencoded,multipart/form-data=multipart/form-data\n', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (14, 2, 'select', 'border', 'Table border\nwidth', '0', '', 'default', '', 'N', '', 1, 2, 'Y', 11, 1, 2, '0=None,1=1,2=2,3=3,4=4,5=5', '', 'N', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (15, 2, 'select', 'cellpadding', 'Table\ncellpadding', '0', '', 'default', '', 'Y', '', 1, 2, 'Y', 13, 1, 2, '0=None,1=1,2=2,3=3,4=4,5=5', '', 'N', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (16, 2, 'select', 'cellspacing', 'Table\ncellspacing', '0', '', 'default', '', 'Y', '', 1, 2, 'Y', 12, 1, 2, '0=None,1=1,2=2,3=3,4=4,5=5', '', 'N', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (17, 2, 'text', 'width', 'Table width', '75%', '', 'default', '', 'Y', '', 1, 4, 'Y', 10, 2, 4, '', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (18, 2, 'hidden', 'event', '', 'addModifyFormPost', '', 'default', '', '', '', 0, 0, '', 18, 0, 0, '', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (19, 2, 'submit', 'submit', '', 'Enter', '', 'default', '', '', '', 0, 0, '', 20, 0, 0, '', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (20, 2, 'row', '', '', 'Step 1 - Required\nFields', '', 'default', '', '', '', 0, 0, '', 1, 0, 0, '', '', '', '', 0, 0, '', 0, 'formHeading', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (21, 2, 'hidden', 'formId', '', '2', '', '', '', '', '', 0, 0, 'N', 19, 0, 0, '', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (163, 2, 'text', 'type', 'Form Type', 'site', '', 'default', 'The type of form should be left to \'site\' unless you are developing new types of form elements.', 'Y', '', 1, 25, 'Y', 7, 25, 25, '', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (23, 3, 'text', 'fieldName', 'Enter the\nfield\nname', '', '', 'default', '', 'Y', '', 1, 100, 'Y', 2, 15, 100, '', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (24, 3, 'text', 'displayName', 'Display Name', '', '', 'default', '(this is what people will read to know what to\nfill\nin, example: Phone Number)', 'N', '<b></b><i></i><a></a>', 1, 255, 'Y', 3, 15, 255, '', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (25, 3, 'textarea', 'defaultValue', 'Enter\nthe\ndefault value for this form field', '', '', 'default', '', 'Y', '', 1, 65535, 'N', 9, 0, 0, '', '', '', '', 25, 10, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', 'N')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (26, 3, 'textarea', 'exp', 'Regular\nExpression', '', '', 'default', '(enter a regular expression for\nthis data)', 'Y', '', 1, 65535, 'N', 10, 0, 0, '', '', '', '', 25, 10, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', 'N')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (27, 3, 'select', 'validationType', 'Chooseformvalidation type', 'default', '', 'select', '(default checks\r\nagainst\r\nany regular expressions enter as well as min/max\r\nlengths)', 'N', '', 1, 1, 'N', 11, 0, 0, 'default=Default,email=Email Address,select=Select Drop Down,alphaChars=Only allow Alpha Characters,numericChars=Only allow Numbers,alphaNumeric=Alpha and Numeric', '', 'N', 'N', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (28, 3, 'textarea', 'message', 'Instructions\nor\nhelp', '', '', 'default', '(messages are displayed where this\ntext is,\nunderneath the form as help)', 'N', '', 1, 65535, 'N', 12, 0, 0, '', '', '', '', 25, 10, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', 'N')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (29, 3, 'select', 'stripTags', 'Strip HTML\nTags?', 'N', '', 'default', '', 'N', '', 1, 1, 'N', 13, 1, 0, 'N=No, Y=Yes', '', 'N', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (30, 3, 'text', 'allowedTags', 'Allowed\nHTML\nTags', '', '', 'default', '(Optional if you say yes above.\nEnter HTML\ntags you will allow, example: &lt;b&gt;', 'N', '', 1, 255, 'N', 14, 15, 255, '', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (31, 3, 'row', '', '', 'Step 3 - Form\nValidation', '', '', '', '', '', 0, 0, '', 15, 0, 0, '', '', '', '', 0, 0, '', 0, 'formHeading', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (32, 3, 'text', 'min', 'Minimum Input Length', '1', '', 'default', '(numbers only)', 'Y', '', 1, 7, 'N', 16, 4, 7, '', '', '', '', 0, 10, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (33, 3, 'text', 'max', 'Maximum Length\nAllowed', '1', '', 'default', '(numbers only)', 'Y', '', 1, 7, 'N', 17, 4, 7, '', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (34, 3, 'select', 'req', 'Is this a required field?', '', '', 'select', '', 'N', '', 1, 1, 'Y', 4, 1, 0, 'N=No,Y=Yes', '', 'N', 'N', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (35, 3, 'text', 'size', 'Field Size', '15', '', 'default', '(numbers only)', 'Y', '', 1, 5, 'Y', 5, 5, 5, '', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (36, 3, 'text', 'maxlength', 'Maximum\nField\nLength', '25', '', 'default', '(numbers only)', 'Y', '', 1, 5, 'Y', 6, 5, 5, '', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (37, 3, 'hidden', 'event', '', 'addModifyFormFieldPost', '', '', '', '', '', 0, 0, '', 18, 0, 0, '', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (39, 3, 'hidden', 'type', '', 'text', '', '', '', '', '', 0, 0, '', 19, 0, 0, '', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (46, 4, 'text', 'fieldName', 'Enter the\r\nfield\r\nname', '', '', 'default', '', 'Y', '', 1, 100, 'Y', 2, 50, 100, '', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (47, 4, 'text', 'displayName', 'Display Name', '', '', 'default', '(this is what people will read to know what to\nfill\nin, example: Phone Number)', 'N', '<b></b><i></i><a></a>', 1, 255, 'Y', 3, 15, 255, '', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (48, 4, 'textarea', 'defaultValue', 'Enter\nthe\ndefault value for this form field', '', '', 'default', '', 'Y', '', 1, 65535, 'N', 9, 0, 0, '', '', '', '', 25, 10, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', 'N')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (49, 4, 'textarea', 'message', 'Instructions\nor\nhelp', '', '', 'default', '(messages are displayed where this\ntext is,\nunderneath the form as help)', 'N', '', 1, 65535, 'N', 10, 0, 0, '', '', '', '', 25, 10, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', 'N')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (60, 4, 'select', 'multiple', 'Is this a\nmutiple\nselect form?', 'N', '', 'default', '', 'N', '', 1, 1, 'Y', 5, 1, 0, 'N=No,Y=Yes', '', 'N', 'N', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (51, 4, 'hidden', 'min', '', '1', '', 'default', '', 'Y', '', 1, 7, 'N', 14, 4, 7, '', '', '', '', 0, 10, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (52, 4, 'hidden', 'max', '', '1', '', 'default', '', 'Y', '', 1, 7, 'N', 15, 4, 7, '', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (53, 4, 'select', 'req', 'Is this arequiredfield?', '', '', 'select', '', 'N', '', 1, 1, 'N', 4, 1, 0, 'N=No,Y=Yes', '', 'N', 'N', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (54, 4, 'text', 'size', 'Field Size', '1', '', 'default', 'If you are creating a mutiple select form, set the\nsize\nlarger to see more values.', 'Y', '', 1, 5, 'Y', 6, 5, 5, '', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (55, 4, 'hidden', 'event', '', 'addModifyFormFieldPost', '', '', '', '', '', 0, 0, '', 16, 0, 0, '', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (56, 4, 'hidden', 'type', '', 'select', '', '', '', '', '', 0, 0, '', 17, 0, 0, '', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (57, 4, 'hidden', 'stripTags', '', 'N', '', 'default', '', 'N', '', 1, 1, 'N', 18, 1, 0, '', '', 'N', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (58, 4, 'hidden', 'validationType', '', 'select', '', '', '', 'N', '', 1, 1, '', 19, 0, 0, '', '', 'N', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (59, 4, 'textarea', 'selectOptions', 'Enter\nyour\ndrop down options', '', '', 'default', 'Note: enter drop\ndown options\nas follows with NO spaces between them. Example:\n1=Name,2=Phone', 'Y', '', 1, 65535, 'N', 13, 0, 0, '', '', '', '', 25, 10, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', 'N')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (61, 4, 'select', 'useValue', 'Use value\ninstead\nof key (advanced option)?', 'N', '', 'default', '', 'N', '', 1, 1, 'N', 11, 1, 0, 'N=No,Y=Yes', '', 'N', 'N', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (62, 5, 'text', 'fieldName', 'Enter the\nfield\nname', '', '', 'default', '', 'Y', '', 1, 100, 'Y', 2, 15, 100, '', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (63, 5, 'text', 'displayName', 'Display Name', '', '', 'default', '(this is what people will read to know what to\nfill\nin, example: Phone Number)', 'N', '<b></b><i></i><a></a>', 1, 255, 'Y', 3, 15, 255, '', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (64, 5, 'textarea', 'defaultValue', 'Enter\nthe\ndefault value for this form field', '', '', 'default', '', 'Y', '', 1, 65535, 'N', 10, 0, 0, '', '', '', '', 25, 10, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', 'N')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (65, 5, 'textarea', 'message', 'Instructions\nor\nhelp', '', '', 'default', '(messages are displayed where this\ntext is,\nunderneath the form as help)', 'N', '', 1, 65535, 'N', 11, 0, 0, '', '', '', '', 25, 10, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', 'N')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (66, 5, 'hidden', 'min', '', '1', '', 'default', '', 'Y', '', 1, 7, 'N', 15, 4, 7, '', '', '', '', 0, 10, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (67, 5, 'hidden', 'max', '', '65535', '', 'default', '', 'Y', '', 1, 7, 'N', 16, 4, 7, '', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (68, 5, 'select', 'req', 'Is this a required field?', '', '', 'select', '', 'N', '', 1, 1, 'N', 4, 1, 0, 'N=No,Y=Yes', '', 'N', 'N', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (69, 5, 'hidden', 'size', '', '0', '', 'default', '', 'Y', '', 1, 5, 'Y', 20, 5, 5, '', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (70, 5, 'hidden', 'event', '', 'addModifyFormFieldPost', '', '', '', '', '', 0, 0, '', 18, 0, 0, '', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (71, 5, 'hidden', 'type', '', 'textarea', '', '', '', '', '', 0, 0, '', 19, 0, 0, '', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (72, 5, 'hidden', 'validationType', '', 'default', '', '', '', 'N', '', 1, 1, '', 17, 0, 0, '', '', 'N', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (73, 5, 'textarea', 'exp', 'Regular\nExpression(s)', '', '', 'default', '(enter regular\nexpressions to\nmatch against data)', 'N', '', 1, 65535, 'N', 12, 0, 0, '', '', '', '', 25, 10, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', 'N')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (118, 5, 'select', 'stripTags', 'Strip\nHTML\nTags?', 'N', '', '', '', '', '', 0, 0, 'N', 13, 1, 0, 'N=No,Y=Yes', '', 'N', 'N', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+
+?>
\ No newline at end of file
Added: logicampus/trunk/src/public_html/install/data_02.php
===================================================================
--- logicampus/trunk/src/public_html/install/data_02.php (rev 0)
+++ logicampus/trunk/src/public_html/install/data_02.php 2009-02-27 12:20:25 UTC (rev 1299)
@@ -0,0 +1,276 @@
+<?
+$installTableSchemas = array();
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (74, 5, 'text', 'cols', 'Enter number of\r\ncolumns', '25', '', 'default', '', 'N', '', 1, 3, 'Y', 5, 15, 25, '', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (75, 5, 'text', 'rows', 'Enter number of rows', '10', '', 'default', '', 'N', '', 1, 2, 'Y', 6, 15, 25, '', '', '', '', 25, 10, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (76, 6, 'text', 'fieldName', 'Enter the name', '', '', 'default', '', 'N', '', 1, 25, 'Y', 2, 15, 25, '', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (77, 6, 'text', 'defaultValue', 'Enter the\nvalue\nfor the hidden field', '', '', 'default', '', 'N', '', 1, 25, 'Y', 3, 15, 25, '', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (78, 6, 'hidden', 'event', '', 'addModifyFormFieldPost', '', '', '', '', '', 0, 0, '', 5, 0, 0, '', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (79, 6, 'hidden', 'type', '', 'hidden', '', '', '', '', '', 0, 0, '', 6, 0, 0, '', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (83, 7, 'text', 'fieldName', 'Enter the name', 'submit', '', 'default', '', 'N', '', 1, 25, 'Y', 2, 15, 25, '', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (84, 7, 'text', 'defaultValue', 'Enter the name\nof\nyour button', 'Enter', '', 'default', '', 'N', '', 1, 25, 'Y', 3, 15, 25, '', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (85, 7, 'hidden', 'event', '', 'addModifyFormFieldPost', '', '', '', '', '', 0, 0, '', 5, 0, 0, '', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (86, 7, 'hidden', 'type', '', 'submit', '', '', '', '', '', 0, 0, '', 6, 0, 0, '', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (89, 8, 'textarea', 'defaultValue', 'Enter\nTitle', '', '', 'default', '(if nothing is filled in you will just\nhave a\nblank row)', 'N', '', 1, 65535, 'N', 2, 0, 0, '', '', '', '', 25, 10, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', 'N')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (90, 8, 'hidden', 'type', '', 'row', '', '', '', '', '', 0, 0, '', 5, 0, 0, '', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (91, 8, 'hidden', 'event', '', 'addModifyFormFieldPost', '', '', '', '', '', 0, 0, '', 6, 0, 0, '', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (2147483799, 2147483663, 'radio', 'showonlineinfo', 'Show online information?', 'N', '', 'radio', '', '', '', 0, 0, 'Y', 49, 0, 0, 'N=No,Y=Yes', 'Y', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 1, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (2147483798, 2147483663, 'text', 'msn', 'MSN Handle', '', '', 'default', '', 'Y', '', 0, 0, 'N', 48, 20, 50, '', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 2, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (2147483794, 2147483663, 'text', 'url', 'Personal Home Page', 'http://', '', 'default', 'ex: http://www.google.com/', 'Y', '', 0, 0, 'N', 44, 25, 100, '', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 3, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (2147483793, 2147483663, 'row', '', '', 'Online Information', '', '', '', '', '', 0, 0, '', 43, 0, 0, '', '', '', '', 0, 0, '', 0, 'tabletitle', 'a:1:{i:0;s:3:"reg";}', '', 4, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (2147483789, 2147483663, 'customField', 'pagerPhone', 'Pager', '', '', 'phoneNumber', '', '', '', 1, 1, 'N', 15, 1, 0, '', '', 'N', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 5, '', '', '', 'phoneNumber')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (2147483786, 2147483663, 'customField', 'workPhone', 'Work Phone', '', '', 'phoneNumber', '', '', '', 1, 1, 'N', 11, 1, 0, '', '', 'Y', '', 0, 0, '', 0, '', 'a:1:{i:0;s:7:"student";}', '', 6, '', '', '', 'phoneNumber')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (2147483785, 2147483663, 'customField', 'homePhone', 'Home Phone', '', '', 'phoneNumber', '', '', '', 1, 1, 'Y', 10, 1, 0, '', '', 'Y', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 7, '', '', '', 'phoneNumber')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (2147483782, 2147483663, 'text', 'city', 'City', '', '', 'default', '', 'Y', '', 1, 50, 'Y', 6, 25, 50, '', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 8, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (119, 8, 'text', 'rowStyle', 'Style Sheet', '', '', 'default', 'Choose a style sheet for your row. Example:\nformHeading', 'Y', '', 1, 35, 'N', 3, 15, 35, '', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (124, 9, 'text', 'fieldName', 'Enter name\nof\npassword field', 'password', '', 'default', '', 'Y', '', 1, 50, 'Y', 2, 15, 50, '', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (125, 9, 'text', 'displayName', 'Enter\ndisplay\ntext', 'Enter your password', '', 'default', '', 'Y', '', 0, 255, 'Y', 3, 25, 255, '', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (126, 9, 'hidden', 'event', '', 'addModifyFormFieldPost', '', '', '', '', '', 0, 0, '', 9, 0, 0, '', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multiple, useValue, cols, rows, image, parentPkey, rowStyle, groups, notgroups, row, startYear, endYear, dateTimeBit, extra) VALUES (127, 9, 'hidden', 'type', '', 'password', '', '', '', '', '', 0, 0, '', 8, 0, 0, '', '', '', '', 0, 0, '', 0, '', 'a:1:{i:0;s:3:"reg";}', '', 0, '', '', '', '')
+campusdelimeter;
+$installTableSchemas[] = $table;
+$table = <<<campusdelimeter
+INSERT INTO lcForms (pkey, formId, type, fieldName, displayName, defaultValue, exp, validationType, message, stripTags, allowedTags, min, max, req, sort, size, maxlength, selectOptions, checked, multip...
[truncated message content] |
