PHP Multi Form Generator (MFG) for use with phpMyEdit, PHP, and MySQL

About MFG - Sample Script - Generate Forms - Help System

Creating "Field Help Pop-ups" For End Users (Add, Change, coPy modes)

phpMyEdit supports the optional display of a 3rd table cell in Add, Change, and coPy modes (to the right of the input boxes). In this "Help" cell you can configure the display of tips or other information for end users.

If you want to carry this a step further, for large projects using these forms, the following database schema can be used to initially populate `mfg_help_data` with user tips that are specific to each column in each table. You will need to edit the `hept_text` entries, but you begin the Help project with `mfg_help_data` populated with the UNIQUE KEY (`tb_name`,`fd_name`). This data will be immediately accessible to form users if the forms are created using the "link to Help popup" option.

NOTE: On some system configurations, there is a PHP bug with the mysql_field_len() function when used with MySQL version 4.1 and UTF8 character sets. An incorrect value for the length of VARCHAR fields may be returned if the character set is UTF8. If you find that the field length set in your forms for VARCHAR columns is incorrect, see the bug note page for a work-around. 
CREATE TABLE `mfg_help_data` (
  `hid` mediumint(9) NOT NULL auto_increment,
  `tb_name` varchar(50) collate utf8_unicode_ci NOT NULL default '',
  `fd_num` smallint(6) NOT NULL default '0',
  `fd_name` varchar(50) collate utf8_unicode_ci NOT NULL default '',
  `fd_name2` varchar(50) collate utf8_unicode_ci NOT NULL default '',
  `help_text` text collate utf8_unicode_ci NOT NULL,
  `example` tinytext collate utf8_unicode_ci NOT NULL,
  `language` varchar(50) collate utf8_unicode_ci NOT NULL default 'English',
  `lang_code` varchar(5) collate utf8_unicode_ci NOT NULL default 'en-US',
  `char_set` varchar(15) collate utf8_unicode_ci NOT NULL default 'UTF-8',
  `dir` enum('ltr','rtl') collate utf8_unicode_ci default 'ltr',
  `deleted` tinyint(4) NOT NULL default '0',
  `updated` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`hid`),
  UNIQUE KEY `no_duplicates` (`tb_name`,`fd_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
# mfg_change_log SQL follows...

INSERT INTO `mfg_help_data` (`hid`, `tb_name`, `fd_num`, `fd_name`, `fd_name2`, `help_text`, `example`, `language`, `lang_code`, `char_set`, `dir`, `deleted`, `updated`) VALUES
("", "mfg_change_log", "0", "id", "Id", "This entry is the record number assigned by the database (max. 8 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_change_log", "1", "updated", "Updated", "Timestamp fields are updated automatically when records are changed (max. 19 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_change_log", "2", "user", "User", "User is an alphanumeric field (max. 150 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_change_log", "3", "host", "Host", "Host is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_change_log", "4", "operation", "Operation", "Operation is an alphanumeric field (max. 150 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_change_log", "5", "tab", "Tab", "Tab is an alphanumeric field (max. 150 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_change_log", "6", "rowkey", "Rowkey", "Rowkey is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_change_log", "7", "col", "Col", "Col is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_change_log", "8", "oldval", "Oldval", "Oldval is an alphanumeric field (max. 196605 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_change_log", "9", "newval", "Newval", "Newval is an alphanumeric field (max. 196605 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW());
# mfg_colors SQL follows...

INSERT INTO `mfg_help_data` (`hid`, `tb_name`, `fd_num`, `fd_name`, `fd_name2`, `help_text`, `example`, `language`, `lang_code`, `char_set`, `dir`, `deleted`, `updated`) VALUES
("", "mfg_colors", "0", "id", "Id", "This entry is the record number assigned by the database (max. 5 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_colors", "1", "name", "Name", "Name is an alphanumeric field (max. 60 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_colors", "2", "hex", "Hex", "Hex is an alphanumeric field (max. 21 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW());
# mfg_content SQL follows...

INSERT INTO `mfg_help_data` (`hid`, `tb_name`, `fd_num`, `fd_name`, `fd_name2`, `help_text`, `example`, `language`, `lang_code`, `char_set`, `dir`, `deleted`, `updated`) VALUES
("", "mfg_content", "0", "id", "Id", "This entry is the record number assigned by the database (max. 6 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_content", "1", "snum", "Snum", "Snum is a numeric field in the mfg_content table (max. 5 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_content", "2", "pnum", "Pnum", "Pnum is a numeric field in the mfg_content table (max. 5 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_content", "3", "link", "Link", "Link is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_content", "4", "heading", "Heading", "Heading is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_content", "5", "meta_title", "Meta Title", "Meta Title is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_content", "6", "meta_desc", "Meta Desc", "Meta Desc is an alphanumeric field (max. 196605 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_content", "7", "meta_key", "Meta Key", "Meta Key is an alphanumeric field (max. 196605 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_content", "8", "html_1", "Html 1", "Html 1 is an alphanumeric field (max. 196605 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_content", "9", "html_2", "Html 2", "Html 2 is an alphanumeric field (max. 196605 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_content", "10", "php_script", "Php Script", "Php Script is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_content", "11", "content", "Content", "Content is an alphanumeric field (max. 196605 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_content", "12", "td_left", "Td Left", "Td Left is an alphanumeric field (max. 3 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_content", "13", "eval_content", "Eval Content", "Eval Content is an alphanumeric field (max. 3 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_content", "14", "mli", "Mli", "Mli is an alphanumeric field (max. 3 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_content", "15", "ul", "Ul", "Ul is an alphanumeric field (max. 3 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_content", "16", "https", "Https", "Https is an alphanumeric field (max. 3 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_content", "17", "nav", "Nav", "Nav is an alphanumeric field (max. 3 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_content", "18", "hidden", "Hidden", "Hidden is an alphanumeric field (max. 3 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_content", "19", "deleted", "Deleted", "Deleted is an alphanumeric field (max. 3 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_content", "20", "spider", "Spider", "Spider is an alphanumeric field (max. 3 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_content", "21", "priority", "Priority", "Priority is an alphanumeric field (max. 9 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_content", "22", "changefreq", "Changefreq", "Changefreq is an alphanumeric field (max. 21 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_content", "23", "posted", "Posted", "Syntax for the Posted field is YYYY-MM-DD HH:II:SS, e.g. 2006-12-31 08:00:00 (max. 19 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_content", "24", "updated", "Updated", "Timestamp fields are updated automatically when records are changed (max. 19 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW());
# mfg_customers SQL follows...

INSERT INTO `mfg_help_data` (`hid`, `tb_name`, `fd_num`, `fd_name`, `fd_name2`, `help_text`, `example`, `language`, `lang_code`, `char_set`, `dir`, `deleted`, `updated`) VALUES
("", "mfg_customers", "0", "RecordID", "Recordid", "This entry is the record number assigned by the database (max. 9 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_customers", "1", "CustomerID", "Customerid", "Customerid is an alphanumeric field (max. 15 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_customers", "2", "CompanyName", "Companyname", "Companyname is an alphanumeric field (max. 120 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_customers", "3", "ContactName", "Contactname", "Contactname is an alphanumeric field (max. 90 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_customers", "4", "ContactTitle", "Contacttitle", "Contacttitle is an alphanumeric field (max. 90 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_customers", "5", "Address", "Address", "Address is an alphanumeric field (max. 180 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_customers", "6", "City", "City", "City is an alphanumeric field (max. 45 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_customers", "7", "Region", "Region", "Region is an alphanumeric field (max. 45 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_customers", "8", "PostalCode", "Postalcode", "Postalcode is an alphanumeric field (max. 30 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_customers", "9", "Country", "Country", "Country is an alphanumeric field (max. 45 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_customers", "10", "Phone", "Phone", "Phone is an alphanumeric field (max. 72 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_customers", "11", "Fax", "Fax", "Fax is an alphanumeric field (max. 72 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW());
# mfg_employees SQL follows...

INSERT INTO `mfg_help_data` (`hid`, `tb_name`, `fd_num`, `fd_name`, `fd_name2`, `help_text`, `example`, `language`, `lang_code`, `char_set`, `dir`, `deleted`, `updated`) VALUES
("", "mfg_employees", "0", "EmployeeID", "Employeeid", "This entry is the record number assigned by the database (max. 11 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_employees", "1", "LastName", "Lastname", "Lastname is an alphanumeric field (max. 60 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_employees", "2", "FirstName", "Firstname", "Firstname is an alphanumeric field (max. 30 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_employees", "3", "Title", "Title", "Title is an alphanumeric field (max. 90 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_employees", "4", "TitleOfCourtesy", "Titleofcourtesy", "Titleofcourtesy is an alphanumeric field (max. 75 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_employees", "5", "BirthDate", "Birthdate", "Syntax for the Birthdate field is YYYY-MM-DD , e.g. 2006-12-31 (max. 10 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_employees", "6", "HireDate", "Hiredate", "Syntax for the Hiredate field is YYYY-MM-DD , e.g. 2006-12-31 (max. 10 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_employees", "7", "Address", "Address", "Address is an alphanumeric field (max. 180 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_employees", "8", "City", "City", "City is an alphanumeric field (max. 45 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_employees", "9", "Region", "Region", "Region is an alphanumeric field (max. 45 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_employees", "10", "PostalCode", "Postalcode", "Postalcode is an alphanumeric field (max. 30 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_employees", "11", "Country", "Country", "Country is an alphanumeric field (max. 45 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_employees", "12", "HomePhone", "Homephone", "Homephone is an alphanumeric field (max. 72 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_employees", "13", "Extension", "Extension", "Extension is an alphanumeric field (max. 12 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_employees", "14", "Notes", "Notes", "Notes is an alphanumeric field (max. -3 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_employees", "15", "ReportsTo", "Reportsto", "Reportsto is a numeric field in the mfg_employees table (max. 11 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW());
# mfg_help_data SQL follows...

INSERT INTO `mfg_help_data` (`hid`, `tb_name`, `fd_num`, `fd_name`, `fd_name2`, `help_text`, `example`, `language`, `lang_code`, `char_set`, `dir`, `deleted`, `updated`) VALUES
("", "mfg_help_data", "0", "hid", "Hid", "This entry is the record number assigned by the database (max. 9 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_help_data", "1", "tb_name", "Tb Name", "Tb Name is an alphanumeric field (max. 150 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_help_data", "2", "fd_num", "Fd Num", "Fd Num is a numeric field in the mfg_help_data table (max. 6 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_help_data", "3", "fd_name", "Fd Name", "Fd Name is an alphanumeric field (max. 150 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_help_data", "4", "fd_name2", "Fd Name2", "Fd Name2 is an alphanumeric field (max. 150 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_help_data", "5", "help_text", "Help Text", "Help Text is an alphanumeric field (max. 196605 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_help_data", "6", "example", "Example", "Example is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_help_data", "7", "language", "Language", "Language is an alphanumeric field (max. 150 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_help_data", "8", "lang_code", "Lang Code", "Lang Code is an alphanumeric field (max. 15 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_help_data", "9", "char_set", "Char Set", "Char Set is an alphanumeric field (max. 45 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_help_data", "10", "dir", "Dir", "Dir is an alphanumeric field (max. 9 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_help_data", "11", "deleted", "Deleted", "Deleted is a numeric field in the mfg_help_data table (max. 4 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_help_data", "12", "updated", "Updated", "Timestamp fields are updated automatically when records are changed (max. 19 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW());
# mfg_order_details SQL follows...

INSERT INTO `mfg_help_data` (`hid`, `tb_name`, `fd_num`, `fd_name`, `fd_name2`, `help_text`, `example`, `language`, `lang_code`, `char_set`, `dir`, `deleted`, `updated`) VALUES
("", "mfg_order_details", "0", "OrderID", "Orderid", "Orderid is a numeric field in the mfg_order_details table (max. 11 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_order_details", "1", "ProductID", "Productid", "Productid is a numeric field in the mfg_order_details table (max. 11 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_order_details", "2", "UnitPrice", "Unitprice", "Unitprice is a numeric field in the mfg_order_details table (max. 9 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_order_details", "3", "Quantity", "Quantity", "Quantity is a numeric field in the mfg_order_details table (max. 6 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_order_details", "4", "Discount", "Discount", "Discount is a numeric field in the mfg_order_details table (max. 13 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW());
# mfg_orders SQL follows...

INSERT INTO `mfg_help_data` (`hid`, `tb_name`, `fd_num`, `fd_name`, `fd_name2`, `help_text`, `example`, `language`, `lang_code`, `char_set`, `dir`, `deleted`, `updated`) VALUES
("", "mfg_orders", "0", "OrderID", "Orderid", "This entry is the record number assigned by the database (max. 11 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_orders", "1", "CustomerID", "Customerid", "Customerid is an alphanumeric field (max. 15 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_orders", "2", "EmployeeID", "Employeeid", "Employeeid is a numeric field in the mfg_orders table (max. 11 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_orders", "3", "OrderDate", "Orderdate", "Syntax for the Orderdate field is YYYY-MM-DD , e.g. 2006-12-31 (max. 10 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_orders", "4", "RequiredDate", "Requireddate", "Syntax for the Requireddate field is YYYY-MM-DD , e.g. 2006-12-31 (max. 10 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_orders", "5", "ShippedDate", "Shippeddate", "Syntax for the Shippeddate field is YYYY-MM-DD , e.g. 2006-12-31 (max. 10 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_orders", "6", "ShipVia", "Shipvia", "Shipvia is a numeric field in the mfg_orders table (max. 11 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_orders", "7", "Freight", "Freight", "Freight is a numeric field in the mfg_orders table (max. 9 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_orders", "8", "ShipName", "Shipname", "Shipname is an alphanumeric field (max. 120 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_orders", "9", "ShipAddress", "Shipaddress", "Shipaddress is an alphanumeric field (max. 180 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_orders", "10", "ShipCity", "Shipcity", "Shipcity is an alphanumeric field (max. 45 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_orders", "11", "ShipRegion", "Shipregion", "Shipregion is an alphanumeric field (max. 45 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_orders", "12", "ShipPostalCode", "Shippostalcode", "Shippostalcode is an alphanumeric field (max. 30 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_orders", "13", "ShipCountry", "Shipcountry", "Shipcountry is an alphanumeric field (max. 45 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW());
# mfg_outlook SQL follows...

INSERT INTO `mfg_help_data` (`hid`, `tb_name`, `fd_num`, `fd_name`, `fd_name2`, `help_text`, `example`, `language`, `lang_code`, `char_set`, `dir`, `deleted`, `updated`) VALUES
("", "mfg_outlook", "0", "ID", "Id", "This entry is the record number assigned by the database (max. 9 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "1", "Title", "Title", "Title is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "2", "FirstName", "Firstname", "Firstname is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "3", "MiddleName", "Middlename", "Middlename is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "4", "LastName", "Lastname", "Lastname is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "5", "Suffix", "Suffix", "Suffix is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "6", "Company", "Company", "Company is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "7", "Department", "Department", "Department is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "8", "JobTitle", "Jobtitle", "Jobtitle is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "9", "BusinessStreet", "Businessstreet", "Businessstreet is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "10", "BusinessStreet2", "Businessstreet2", "Businessstreet2 is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "11", "BusinessStreet3", "Businessstreet3", "Businessstreet3 is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "12", "BusinessCity", "Businesscity", "Businesscity is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "13", "BusinessState", "Businessstate", "Businessstate is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "14", "BusinessPostalCode", "Businesspostalcode", "Businesspostalcode is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "15", "BusinessCountry", "Businesscountry", "Businesscountry is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "16", "HomeStreet", "Homestreet", "Homestreet is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "17", "HomeStreet2", "Homestreet2", "Homestreet2 is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "18", "HomeStreet3", "Homestreet3", "Homestreet3 is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "19", "HomeCity", "Homecity", "Homecity is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "20", "HomeState", "Homestate", "Homestate is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "21", "HomePostalCode", "Homepostalcode", "Homepostalcode is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "22", "HomeCountry", "Homecountry", "Homecountry is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "23", "OtherStreet", "Otherstreet", "Otherstreet is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "24", "OtherStreet2", "Otherstreet2", "Otherstreet2 is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "25", "OtherStreet3", "Otherstreet3", "Otherstreet3 is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "26", "OtherCity", "Othercity", "Othercity is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "27", "OtherState", "Otherstate", "Otherstate is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "28", "OtherPostalCode", "Otherpostalcode", "Otherpostalcode is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "29", "OtherCountry", "Othercountry", "Othercountry is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "30", "AssistantsPhone", "Assistantsphone", "Assistantsphone is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "31", "BusinessFax", "Businessfax", "Businessfax is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "32", "BusinessPhone", "Businessphone", "Businessphone is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "33", "BusinessPhone2", "Businessphone2", "Businessphone2 is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "34", "Callback", "Callback", "Callback is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "35", "CarPhone", "Carphone", "Carphone is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "36", "CompanyMainPhone", "Companymainphone", "Companymainphone is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "37", "HomeFax", "Homefax", "Homefax is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "38", "HomePhone", "Homephone", "Homephone is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "39", "HomePhone2", "Homephone2", "Homephone2 is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "40", "ISDN", "Isdn", "Isdn is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "41", "MobilePhone", "Mobilephone", "Mobilephone is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "42", "OtherFax", "Otherfax", "Otherfax is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "43", "OtherPhone", "Otherphone", "Otherphone is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "44", "Pager", "Pager", "Pager is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "45", "PrimaryPhone", "Primaryphone", "Primaryphone is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "46", "RadioPhone", "Radiophone", "Radiophone is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "47", "TTYTDDPhone", "Ttytddphone", "Ttytddphone is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "48", "Telex", "Telex", "Telex is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "49", "Account", "Account", "Account is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "50", "Anniversary", "Anniversary", "Anniversary is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "51", "AssistantsName", "Assistantsname", "Assistantsname is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "52", "BillingInformation", "Billinginformation", "Billinginformation is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "53", "Birthday", "Birthday", "Birthday is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "54", "Categories", "Categories", "Categories is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "55", "Children", "Children", "Children is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "56", "DirectoryServer", "Directoryserver", "Directoryserver is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "57", "EmailAddress", "Emailaddress", "Emailaddress is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "58", "EmailDisplayName", "Emaildisplayname", "Emaildisplayname is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "59", "Email2Address", "Email2address", "Email2address is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "60", "Email2DisplayName", "Email2displayname", "Email2displayname is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "61", "Email3Address", "Email3address", "Email3address is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "62", "Email3DisplayName", "Email3displayname", "Email3displayname is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "63", "Gender", "Gender", "Gender is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "64", "GovernmentIDNumber", "Governmentidnumber", "Governmentidnumber is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "65", "Hobby", "Hobby", "Hobby is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "66", "Initials", "Initials", "Initials is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "67", "InternetFreeBusy", "Internetfreebusy", "Internetfreebusy is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "68", "Keywords", "Keywords", "Keywords is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "69", "Language1", "Language1", "Language1 is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "70", "Location", "Location", "Location is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "71", "ManagersName", "Managersname", "Managersname is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "72", "Mileage", "Mileage", "Mileage is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "73", "Notes", "Notes", "Notes is an alphanumeric field (max. -3 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "74", "OfficeLocation", "Officelocation", "Officelocation is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "75", "OrganizationalIDNumber", "Organizationalidnumber", "Organizationalidnumber is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "76", "POBox", "Pobox", "Pobox is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "77", "Priority", "Priority", "Priority is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "78", "Private", "Private", "Private is a numeric field in the mfg_outlook table (max. 3 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "79", "Profession", "Profession", "Profession is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "80", "ReferredBy", "Referredby", "Referredby is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "81", "Sensitivity", "Sensitivity", "Sensitivity is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "82", "Spouse", "Spouse", "Spouse is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "83", "User1", "User1", "User1 is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "84", "User2", "User2", "User2 is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "85", "User3", "User3", "User3 is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "86", "User4", "User4", "User4 is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_outlook", "87", "WebPage", "Webpage", "Webpage is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW());
# mfg_products SQL follows...

INSERT INTO `mfg_help_data` (`hid`, `tb_name`, `fd_num`, `fd_name`, `fd_name2`, `help_text`, `example`, `language`, `lang_code`, `char_set`, `dir`, `deleted`, `updated`) VALUES
("", "mfg_products", "0", "ProductID", "Productid", "This entry is the record number assigned by the database (max. 11 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_products", "1", "ProductName", "Productname", "Productname is an alphanumeric field (max. 120 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_products", "2", "SupplierID", "Supplierid", "Supplierid is a numeric field in the mfg_products table (max. 11 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_products", "3", "CategoryID", "Categoryid", "Categoryid is a numeric field in the mfg_products table (max. 11 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_products", "4", "QuantityPerUnit", "Quantityperunit", "Quantityperunit is an alphanumeric field (max. 60 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_products", "5", "UnitPrice", "Unitprice", "Unitprice is a numeric field in the mfg_products table (max. 9 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_products", "6", "UnitsInStock", "Unitsinstock", "Unitsinstock is a numeric field in the mfg_products table (max. 6 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_products", "7", "UnitsOnOrder", "Unitsonorder", "Unitsonorder is a numeric field in the mfg_products table (max. 6 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_products", "8", "ReorderLevel", "Reorderlevel", "Reorderlevel is a numeric field in the mfg_products table (max. 6 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_products", "9", "Discontinued", "Discontinued", "Discontinued is a numeric field in the mfg_products table (max. 4 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW());
# mfg_sql_col_types SQL follows...

INSERT INTO `mfg_help_data` (`hid`, `tb_name`, `fd_num`, `fd_name`, `fd_name2`, `help_text`, `example`, `language`, `lang_code`, `char_set`, `dir`, `deleted`, `updated`) VALUES
("", "mfg_sql_col_types", "0", "unit_id", "Unit Id", "This entry is the record number assigned by the database (max. 11 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_sql_col_types", "1", "time_col", "Time Col", "Syntax for the Time Col field is HH:MM:SS, e.g. 08:00:00 (max. 8 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_sql_col_types", "2", "int_date", "Int Date", "Int Date is a numeric field in the mfg_sql_col_types table (max. 11 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_sql_col_types", "3", "email", "Email", "Email is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_sql_col_types", "4", "date_null", "Date Null", "Syntax for the Date Null field is YYYY-MM-DD , e.g. 2006-12-31 (max. 10 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_sql_col_types", "5", "date_not_null", "Date Not Null", "Syntax for the Date Not Null field is YYYY-MM-DD , e.g. 2006-12-31 (max. 10 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_sql_col_types", "6", "time_null", "Time Null", "Syntax for the Time Null field is HH:MM:SS, e.g. 08:00:00 (max. 8 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_sql_col_types", "7", "time_not_null", "Time Not Null", "Syntax for the Time Not Null field is HH:MM:SS, e.g. 08:00:00 (max. 8 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_sql_col_types", "8", "datetime_null", "Datetime Null", "Syntax for the Datetime Null field is YYYY-MM-DD HH:II:SS, e.g. 2006-12-31 08:00:00 (max. 19 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_sql_col_types", "9", "datetime_not_null", "Datetime Not Null", "Syntax for the Datetime Not Null field is YYYY-MM-DD HH:II:SS, e.g. 2006-12-31 08:00:00 (max. 19 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_sql_col_types", "10", "year_null", "Year Null", "Syntax for the Year Null field is YYYY, e.g. 2006 (max. 4 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_sql_col_types", "11", "year_not_null", "Year Not Null", "Syntax for the Year Not Null field is YY, e.g. 06 (max. 2 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_sql_col_types", "12", "timestamp_14", "Timestamp 14", "Timestamp fields are updated automatically when records are changed (max. 19 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_sql_col_types", "13", "smallint_null", "Smallint Null", "Smallint Null is a numeric field in the mfg_sql_col_types table (max. 6 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_sql_col_types", "14", "smallint_not_null", "Smallint Not Null", "Smallint Not Null is a numeric field in the mfg_sql_col_types table (max. 6 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_sql_col_types", "15", "mediumint_null", "Mediumint Null", "Mediumint Null is a numeric field in the mfg_sql_col_types table (max. 9 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_sql_col_types", "16", "mediumint_not_null", "Mediumint Not Null", "Mediumint Not Null is a numeric field in the mfg_sql_col_types table (max. 9 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_sql_col_types", "17", "decimal_null", "Decimal Null", "Decimal Null is a numeric field in the mfg_sql_col_types table (max. 13 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_sql_col_types", "18", "decimal_not_null", "Decimal Not Null", "Decimal Not Null is a numeric field in the mfg_sql_col_types table (max. 10 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_sql_col_types", "19", "double_null", "Double Null", "Double Null is a numeric field in the mfg_sql_col_types table (max. 10 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_sql_col_types", "20", "double_not_null", "Double Not Null", "Double Not Null is a numeric field in the mfg_sql_col_types table (max. 10 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_sql_col_types", "21", "float_null", "Float Null", "Float Null is a numeric field in the mfg_sql_col_types table (max. 10 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_sql_col_types", "22", "float_not_null", "Float Not Null", "Float Not Null is a numeric field in the mfg_sql_col_types table (max. 10 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_sql_col_types", "23", "char_null", "Char Null", "Char Null is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_sql_col_types", "24", "char_not_null", "Char Not Null", "Char Not Null is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_sql_col_types", "25", "tinytext_null", "Tinytext Null", "Tinytext Null is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_sql_col_types", "26", "tinytext_not_null", "Tinytext Not Null", "Tinytext Not Null is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_sql_col_types", "27", "text_null", "Text Null", "Text Null is an alphanumeric field (max. 196605 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_sql_col_types", "28", "mediumtext_null", "Mediumtext Null", "Mediumtext Null is an alphanumeric field (max. 50331645 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_sql_col_types", "29", "set_null", "Set Null", "Set Null is an alphanumeric field (max. 45 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_sql_col_types", "30", "set_not_null", "Set Not Null", "Set Not Null is an alphanumeric field (max. 66 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_sql_col_types", "31", "enum_not_null", "Enum Not Null", "Enum Not Null is an alphanumeric field (max. 3 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW());
# mfg_streets SQL follows...

INSERT INTO `mfg_help_data` (`hid`, `tb_name`, `fd_num`, `fd_name`, `fd_name2`, `help_text`, `example`, `language`, `lang_code`, `char_set`, `dir`, `deleted`, `updated`) VALUES
("", "mfg_streets", "0", "id", "Id", "This entry is the record number assigned by the database (max. 10 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_streets", "1", "st", "St", "St is an alphanumeric field (max. 90 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_streets", "2", "dir", "Dir", "Dir is an alphanumeric field (max. 15 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_streets", "3", "blk", "Blk", "Blk is a numeric field in the mfg_streets table (max. 9 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_streets", "4", "rot", "Rot", "Rot is an alphanumeric field (max. 90 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW());
# mfg_suppliers SQL follows...

INSERT INTO `mfg_help_data` (`hid`, `tb_name`, `fd_num`, `fd_name`, `fd_name2`, `help_text`, `example`, `language`, `lang_code`, `char_set`, `dir`, `deleted`, `updated`) VALUES
("", "mfg_suppliers", "0", "SupplierID", "Supplierid", "This entry is the record number assigned by the database (max. 11 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_suppliers", "1", "CompanyName", "Companyname", "Companyname is an alphanumeric field (max. 120 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_suppliers", "2", "ContactName", "Contactname", "Contactname is an alphanumeric field (max. 90 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_suppliers", "3", "ContactTitle", "Contacttitle", "Contacttitle is an alphanumeric field (max. 90 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_suppliers", "4", "Address", "Address", "Address is an alphanumeric field (max. 180 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_suppliers", "5", "City", "City", "City is an alphanumeric field (max. 45 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_suppliers", "6", "Region", "Region", "Region is an alphanumeric field (max. 45 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_suppliers", "7", "PostalCode", "Postalcode", "Postalcode is an alphanumeric field (max. 30 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_suppliers", "8", "Country", "Country", "Country is an alphanumeric field (max. 45 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_suppliers", "9", "Phone", "Phone", "Phone is an alphanumeric field (max. 72 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_suppliers", "10", "Fax", "Fax", "Fax is an alphanumeric field (max. 72 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_suppliers", "11", "HomePage", "Homepage", "Homepage is an alphanumeric field (max. -3 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW());
# mfg_to_do SQL follows...

INSERT INTO `mfg_help_data` (`hid`, `tb_name`, `fd_num`, `fd_name`, `fd_name2`, `help_text`, `example`, `language`, `lang_code`, `char_set`, `dir`, `deleted`, `updated`) VALUES
("", "mfg_to_do", "0", "ID", "Id", "This entry is the record number assigned by the database (max. 5 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_to_do", "1", "Subject", "Subject", "Subject is an alphanumeric field (max. 90 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_to_do", "2", "CompanyID", "Companyid", "Companyid is a numeric field in the mfg_to_do table (max. 8 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_to_do", "3", "LastNameID", "Lastnameid", "Lastnameid is a numeric field in the mfg_to_do table (max. 8 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_to_do", "4", "Comments", "Comments", "Comments is an alphanumeric field (max. 196605 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_to_do", "5", "Status", "Status", "Status is an alphanumeric field (max. 18 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_to_do", "6", "ROID", "Roid", "Roid is a numeric field in the mfg_to_do table (max. 8 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_to_do", "7", "LastUpdatedByID", "Lastupdatedbyid", "Lastupdatedbyid is a numeric field in the mfg_to_do table (max. 8 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_to_do", "8", "DateCreated", "Datecreated", "Syntax for the Datecreated field is YYYY-MM-DD , e.g. 2006-12-31 (max. 10 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_to_do", "9", "PublicRecord", "Publicrecord", "Publicrecord is a numeric field in the mfg_to_do table (max. 3 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_to_do", "10", "DateModified", "Datemodified", "Timestamp fields are updated automatically when records are changed (max. 19 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW());
# mfg_user_log SQL follows...

INSERT INTO `mfg_help_data` (`hid`, `tb_name`, `fd_num`, `fd_name`, `fd_name2`, `help_text`, `example`, `language`, `lang_code`, `char_set`, `dir`, `deleted`, `updated`) VALUES
("", "mfg_user_log", "0", "id", "Id", "This entry is the record number assigned by the database (max. 6 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_user_log", "1", "submit_token", "Submit Token", "Submit Token is an alphanumeric field (max. 96 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_user_log", "2", "ip", "Ip", "Ip is an alphanumeric field (max. 60 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_user_log", "3", "host", "Host", "Host is an alphanumeric field (max. 225 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_user_log", "4", "user", "User", "User is an alphanumeric field (max. 90 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_user_log", "5", "agent", "Agent", "Agent is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_user_log", "6", "referer", "Referer", "Referer is an alphanumeric field (max. 765 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_user_log", "7", "method", "Method", "Method is an alphanumeric field (max. 30 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_user_log", "8", "request", "Request", "Request is an alphanumeric field (max. 300 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_user_log", "9", "data", "Data", "Data is an alphanumeric field (max. 196605 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW()),
("", "mfg_user_log", "10", "updated", "Updated", "Timestamp fields are updated automatically when records are changed (max. 19 characters)", "", "English", "en-US", "UTF-8", "ltr", "0", NOW());

Buy from REGNOW.ORG 7-day money back guarantee.
Within 7 days of the date of purchase, refunds may be granted to any MFG buyer who is dissatisfied with MFG and who communicates valid reasons for requesting a refund. Allow 2-3 days for refund processing, typically via swreg.org, PayPal, or alternative payment method.
Tip: remove the Extended Download Service from the cart at swreg.org
Paypal

Allow 24 hours for delivery via email when selecting Google Checkout.

Payment via SWREG.ORG or PayPal should result in a
download link being emailed as soon as the sale is confirmed.

web hosting
Multi Form Generator by Doug Hockinson - doug@hockinson.com
Denver, Colorado USA - VoiceMail / FaxMail (720) 208-0661
php-form-generator.com - hockinson.com - phpvs.com - theirdreams.com