Home›Help›Trac

Changeset 15888 for trunk


Ignore:
Timestamp:
01/17/12 03:43:28 (4 months ago)
Author:
Anton Lesnikov
Message:

Studio -> Form Builder -> Predefined Lists/Values?

Location:
trunk
Files:
13 added
6 edited

Legend:

Unmodified
Added
Removed

  • trunk/install/sql/v70.sql

    r15878 r15888  
    16781678-- -------------------------------------------------------- 
    16791679 
    1680 -- 
    1681 -- Table structure for table `sys_pre_values` 
    1682 -- 
    1683  
    1684 CREATE TABLE `sys_pre_values` ( 
    1685   `Key` varchar(255) NOT NULL default '' COMMENT 'Key which defines link to values list', 
    1686   `Value` varchar(255) NOT NULL default '' COMMENT 'Simple value stored in the database', 
    1687   `Order` int(10) unsigned NOT NULL default '0', 
    1688   `LKey` varchar(255) NOT NULL default '' COMMENT 'Primary language key used for displaying this value', 
    1689   `LKey2` varchar(255) NOT NULL default '' COMMENT 'Additional key used in some other places', 
    1690   `LKey3` varchar(255) NOT NULL default '', 
    1691   `Extra` varchar(255) NOT NULL default '' COMMENT 'Some extra values. For example image link for sex', 
    1692   `Extra2` varchar(255) NOT NULL default '', 
    1693   `Extra3` varchar(255) NOT NULL default '' 
    1694 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    1695  
    1696 -- 
    1697 -- Dumping data for table `sys_pre_values` 
    1698 -- 
    1699 INSERT INTO `sys_pre_values` VALUES  
    1700 ('Country', 'AF', 1, '__Afghanistan', '', '', '', '', ''), 
    1701 ('Country', 'AX', 2, '__Aland_Islands', '', '', '', '', ''), 
    1702 ('Country', 'AL', 3, '__Albania', '', '', '', '', ''), 
    1703 ('Country', 'DZ', 4, '__Algeria', '', '', '', '', ''), 
    1704 ('Country', 'AS', 5, '__American Samoa', '', '', '', '', ''), 
    1705 ('Country', 'AD', 6, '__Andorra', '', '', '', '', ''), 
    1706 ('Country', 'AO', 7, '__Angola', '', '', '', '', ''), 
    1707 ('Country', 'AI', 8, '__Anguilla', '', '', '', '', ''), 
    1708 ('Country', 'AQ', 9, '__Antarctica', '', '', '', '', ''), 
    1709 ('Country', 'AG', 10, '__Antigua and Barbuda', '', '', '', '', ''), 
    1710 ('Country', 'AR', 11, '__Argentina', '', '', '', '', ''), 
    1711 ('Country', 'AM', 12, '__Armenia', '', '', '', '', ''), 
    1712 ('Country', 'AW', 13, '__Aruba', '', '', '', '', ''), 
    1713 ('Country', 'AU', 14, '__Australia', '', '', '', '', ''), 
    1714 ('Country', 'AT', 15, '__Austria', '', '', '', '', ''), 
    1715 ('Country', 'AZ', 16, '__Azerbaijan', '', '', '', '', ''), 
    1716 ('Country', 'BH', 17, '__Bahrain', '', '', '', '', ''), 
    1717 ('Country', 'BD', 18, '__Bangladesh', '', '', '', '', ''), 
    1718 ('Country', 'BB', 19, '__Barbados', '', '', '', '', ''), 
    1719 ('Country', 'BY', 20, '__Belarus', '', '', '', '', ''), 
    1720 ('Country', 'BE', 21, '__Belgium', '', '', '', '', ''), 
    1721 ('Country', 'BZ', 22, '__Belize', '', '', '', '', ''), 
    1722 ('Country', 'BJ', 23, '__Benin', '', '', '', '', ''), 
    1723 ('Country', 'BM', 24, '__Bermuda', '', '', '', '', ''), 
    1724 ('Country', 'BT', 25, '__Bhutan', '', '', '', '', ''), 
    1725 ('Country', 'BO', 26, '__Bolivia', '', '', '', '', ''), 
    1726 ('Country', 'BA', 27, '__Bosnia and Herzegovina', '', '', '', '', ''), 
    1727 ('Country', 'BW', 28, '__Botswana', '', '', '', '', ''), 
    1728 ('Country', 'BV', 29, '__Bouvet Island', '', '', '', '', ''), 
    1729 ('Country', 'BR', 30, '__Brazil', '', '', '', '', ''), 
    1730 ('Country', 'IO', 31, '__British Indian Ocean Territory', '', '', '', '', ''), 
    1731 ('Country', 'VG', 32, '__British Virgin Islands', '', '', '', '', ''), 
    1732 ('Country', 'BN', 33, '__Brunei Darussalam', '', '', '', '', ''), 
    1733 ('Country', 'BG', 34, '__Bulgaria', '', '', '', '', ''), 
    1734 ('Country', 'BF', 35, '__Burkina Faso', '', '', '', '', ''), 
    1735 ('Country', 'MM', 36, '__Burma', '', '', '', '', ''), 
    1736 ('Country', 'BI', 37, '__Burundi', '', '', '', '', ''), 
    1737 ('Country', 'KH', 38, '__Cambodia', '', '', '', '', ''), 
    1738 ('Country', 'CM', 39, '__Cameroon', '', '', '', '', ''), 
    1739 ('Country', 'CA', 40, '__Canada', '', '', '', '', ''), 
    1740 ('Country', 'CV', 41, '__Cape Verde', '', '', '', '', ''), 
    1741 ('Country', 'KY', 42, '__Cayman Islands', '', '', '', '', ''), 
    1742 ('Country', 'CF', 43, '__Central African Republic', '', '', '', '', ''), 
    1743 ('Country', 'TD', 44, '__Chad', '', '', '', '', ''), 
    1744 ('Country', 'CL', 45, '__Chile', '', '', '', '', ''), 
    1745 ('Country', 'CN', 46, '__China', '', '', '', '', ''), 
    1746 ('Country', 'CX', 47, '__Christmas Island', '', '', '', '', ''), 
    1747 ('Country', 'CC', 48, '__Cocos (Keeling) Islands', '', '', '', '', ''), 
    1748 ('Country', 'CO', 49, '__Colombia', '', '', '', '', ''), 
    1749 ('Country', 'KM', 50, '__Comoros', '', '', '', '', ''), 
    1750 ('Country', 'CD', 51, '__Congo, Democratic Republic of the', '', '', '', '', ''), 
    1751 ('Country', 'CG', 52, '__Congo, Republic of the', '', '', '', '', ''), 
    1752 ('Country', 'CK', 53, '__Cook Islands', '', '', '', '', ''), 
    1753 ('Country', 'CR', 54, '__Costa Rica', '', '', '', '', ''), 
    1754 ('Country', 'CI', 55, '__Cote d''Ivoire', '', '', '', '', ''), 
    1755 ('Country', 'HR', 56, '__Croatia', '', '', '', '', ''), 
    1756 ('Country', 'CU', 57, '__Cuba', '', '', '', '', ''), 
    1757 ('Country', 'CY', 58, '__Cyprus', '', '', '', '', ''), 
    1758 ('Country', 'CZ', 59, '__Czech Republic', '', '', '', '', ''), 
    1759 ('Country', 'DK', 60, '__Denmark', '', '', '', '', ''), 
    1760 ('Country', 'DJ', 61, '__Djibouti', '', '', '', '', ''), 
    1761 ('Country', 'DM', 62, '__Dominica', '', '', '', '', ''), 
    1762 ('Country', 'DO', 63, '__Dominican Republic', '', '', '', '', ''), 
    1763 ('Country', 'TL', 64, '__East Timor', '', '', '', '', ''), 
    1764 ('Country', 'EC', 65, '__Ecuador', '', '', '', '', ''), 
    1765 ('Country', 'EG', 66, '__Egypt', '', '', '', '', ''), 
    1766 ('Country', 'SV', 67, '__El Salvador', '', '', '', '', ''), 
    1767 ('Country', 'GQ', 68, '__Equatorial Guinea', '', '', '', '', ''), 
    1768 ('Country', 'ER', 69, '__Eritrea', '', '', '', '', ''), 
    1769 ('Country', 'EE', 70, '__Estonia', '', '', '', '', ''), 
    1770 ('Country', 'ET', 71, '__Ethiopia', '', '', '', '', ''), 
    1771 ('Country', 'FK', 72, '__Falkland Islands (Islas Malvinas)', '', '', '', '', ''), 
    1772 ('Country', 'FO', 73, '__Faroe Islands', '', '', '', '', ''), 
    1773 ('Country', 'FJ', 74, '__Fiji', '', '', '', '', ''), 
    1774 ('Country', 'FI', 75, '__Finland', '', '', '', '', ''), 
    1775 ('Country', 'FR', 76, '__France', '', '', '', '', ''), 
    1776 ('Country', 'GF', 77, '__French Guiana', '', '', '', '', ''), 
    1777 ('Country', 'PF', 78, '__French Polynesia', '', '', '', '', ''), 
    1778 ('Country', 'TF', 79, '__French Southern and Antarctic Lands', '', '', '', '', ''), 
    1779 ('Country', 'GA', 80, '__Gabon', '', '', '', '', ''), 
    1780 ('Country', 'GE', 81, '__Georgia', '', '', '', '', ''), 
    1781 ('Country', 'DE', 82, '__Germany', '', '', '', '', ''), 
    1782 ('Country', 'GH', 83, '__Ghana', '', '', '', '', ''), 
    1783 ('Country', 'GI', 84, '__Gibraltar', '', '', '', '', ''), 
    1784 ('Country', 'GR', 85, '__Greece', '', '', '', '', ''), 
    1785 ('Country', 'GL', 86, '__Greenland', '', '', '', '', ''), 
    1786 ('Country', 'GD', 87, '__Grenada', '', '', '', '', ''), 
    1787 ('Country', 'GP', 88, '__Guadeloupe', '', '', '', '', ''), 
    1788 ('Country', 'GU', 89, '__Guam', '', '', '', '', ''), 
    1789 ('Country', 'GT', 90, '__Guatemala', '', '', '', '', ''), 
    1790 ('Country', 'GG', 91, '__Guernsey', '', '', '', '', ''), 
    1791 ('Country', 'GN', 92, '__Guinea', '', '', '', '', ''), 
    1792 ('Country', 'GW', 93, '__Guinea-Bissau', '', '', '', '', ''), 
    1793 ('Country', 'GY', 94, '__Guyana', '', '', '', '', ''), 
    1794 ('Country', 'HT', 95, '__Haiti', '', '', '', '', ''), 
    1795 ('Country', 'HM', 96, '__Heard Island and McDonald Islands', '', '', '', '', ''), 
    1796 ('Country', 'VA', 97, '__Holy See (Vatican City)', '', '', '', '', ''), 
    1797 ('Country', 'HN', 98, '__Honduras', '', '', '', '', ''), 
    1798 ('Country', 'HK', 99, '__Hong Kong (SAR)', '', '', '', '', ''), 
    1799 ('Country', 'HU', 100, '__Hungary', '', '', '', '', ''), 
    1800 ('Country', 'IS', 101, '__Iceland', '', '', '', '', ''), 
    1801 ('Country', 'IN', 102, '__India', '', '', '', '', ''), 
    1802 ('Country', 'ID', 103, '__Indonesia', '', '', '', '', ''), 
    1803 ('Country', 'IR', 104, '__Iran', '', '', '', '', ''), 
    1804 ('Country', 'IQ', 105, '__Iraq', '', '', '', '', ''), 
    1805 ('Country', 'IE', 106, '__Ireland', '', '', '', '', ''), 
    1806 ('Country', 'IM', 107, '__Isle_of_Man', '', '', '', '', ''), 
    1807 ('Country', 'IL', 108, '__Israel', '', '', '', '', ''), 
    1808 ('Country', 'IT', 109, '__Italy', '', '', '', '', ''), 
    1809 ('Country', 'JM', 110, '__Jamaica', '', '', '', '', ''), 
    1810 ('Country', 'JP', 111, '__Japan', '', '', '', '', ''), 
    1811 ('Country', 'JE', 112, '__Jersey', '', '', '', '', ''), 
    1812 ('Country', 'JO', 113, '__Jordan', '', '', '', '', ''), 
    1813 ('Country', 'KZ', 114, '__Kazakhstan', '', '', '', '', ''), 
    1814 ('Country', 'KE', 115, '__Kenya', '', '', '', '', ''), 
    1815 ('Country', 'KI', 116, '__Kiribati', '', '', '', '', ''), 
    1816 ('Country', 'KP', 117, '__Korea, North', '', '', '', '', ''), 
    1817 ('Country', 'KR', 118, '__Korea, South', '', '', '', '', ''), 
    1818 ('Country', 'KW', 119, '__Kuwait', '', '', '', '', ''), 
    1819 ('Country', 'KG', 120, '__Kyrgyzstan', '', '', '', '', ''), 
    1820 ('Country', 'LA', 121, '__Laos', '', '', '', '', ''), 
    1821 ('Country', 'LV', 122, '__Latvia', '', '', '', '', ''), 
    1822 ('Country', 'LB', 123, '__Lebanon', '', '', '', '', ''), 
    1823 ('Country', 'LS', 124, '__Lesotho', '', '', '', '', ''), 
    1824 ('Country', 'LR', 125, '__Liberia', '', '', '', '', ''), 
    1825 ('Country', 'LY', 126, '__Libya', '', '', '', '', ''), 
    1826 ('Country', 'LI', 127, '__Liechtenstein', '', '', '', '', ''), 
    1827 ('Country', 'LT', 128, '__Lithuania', '', '', '', '', ''), 
    1828 ('Country', 'LU', 129, '__Luxembourg', '', '', '', '', ''), 
    1829 ('Country', 'MO', 130, '__Macao', '', '', '', '', ''), 
    1830 ('Country', 'MK', 131, '__Macedonia, The Former Yugoslav Republic of', '', '', '', '', ''), 
    1831 ('Country', 'MG', 132, '__Madagascar', '', '', '', '', ''), 
    1832 ('Country', 'MW', 133, '__Malawi', '', '', '', '', ''), 
    1833 ('Country', 'MY', 134, '__Malaysia', '', '', '', '', ''), 
    1834 ('Country', 'MV', 135, '__Maldives', '', '', '', '', ''), 
    1835 ('Country', 'ML', 136, '__Mali', '', '', '', '', ''), 
    1836 ('Country', 'MT', 137, '__Malta', '', '', '', '', ''), 
    1837 ('Country', 'MH', 138, '__Marshall Islands', '', '', '', '', ''), 
    1838 ('Country', 'MQ', 139, '__Martinique', '', '', '', '', ''), 
    1839 ('Country', 'MR', 140, '__Mauritania', '', '', '', '', ''), 
    1840 ('Country', 'MU', 141, '__Mauritius', '', '', '', '', ''), 
    1841 ('Country', 'YT', 142, '__Mayotte', '', '', '', '', ''), 
    1842 ('Country', 'MX', 143, '__Mexico', '', '', '', '', ''), 
    1843 ('Country', 'FM', 144, '__Micronesia, Federated States of', '', '', '', '', ''), 
    1844 ('Country', 'MD', 145, '__Moldova', '', '', '', '', ''), 
    1845 ('Country', 'MC', 146, '__Monaco', '', '', '', '', ''), 
    1846 ('Country', 'MN', 147, '__Mongolia', '', '', '', '', ''), 
    1847 ('Country', 'ME', 148, '__Montenegro', '', '', '', '', ''), 
    1848 ('Country', 'MS', 149, '__Montserrat', '', '', '', '', ''), 
    1849 ('Country', 'MA', 150, '__Morocco', '', '', '', '', ''), 
    1850 ('Country', 'MZ', 151, '__Mozambique', '', '', '', '', ''), 
    1851 ('Country', 'NA', 152, '__Namibia', '', '', '', '', ''), 
    1852 ('Country', 'NR', 153, '__Nauru', '', '', '', '', ''), 
    1853 ('Country', 'NP', 154, '__Nepal', '', '', '', '', ''), 
    1854 ('Country', 'NL', 155, '__Netherlands', '', '', '', '', ''), 
    1855 ('Country', 'AN', 156, '__Netherlands Antilles', '', '', '', '', ''), 
    1856 ('Country', 'NC', 157, '__New Caledonia', '', '', '', '', ''), 
    1857 ('Country', 'NZ', 158, '__New Zealand', '', '', '', '', ''), 
    1858 ('Country', 'NI', 159, '__Nicaragua', '', '', '', '', ''), 
    1859 ('Country', 'NE', 160, '__Niger', '', '', '', '', ''), 
    1860 ('Country', 'NG', 161, '__Nigeria', '', '', '', '', ''), 
    1861 ('Country', 'NU', 162, '__Niue', '', '', '', '', ''), 
    1862 ('Country', 'NF', 163, '__Norfolk Island', '', '', '', '', ''), 
    1863 ('Country', 'MP', 164, '__Northern Mariana Islands', '', '', '', '', ''), 
    1864 ('Country', 'NO', 165, '__Norway', '', '', '', '', ''), 
    1865 ('Country', 'OM', 166, '__Oman', '', '', '', '', ''), 
    1866 ('Country', 'PK', 167, '__Pakistan', '', '', '', '', ''), 
    1867 ('Country', 'PW', 168, '__Palau', '', '', '', '', ''), 
    1868 ('Country', 'PS', 169, '__Palestinian Territory, Occupied', '', '', '', '', ''), 
    1869 ('Country', 'PA', 170, '__Panama', '', '', '', '', ''), 
    1870 ('Country', 'PG', 171, '__Papua New Guinea', '', '', '', '', ''), 
    1871 ('Country', 'PY', 172, '__Paraguay', '', '', '', '', ''), 
    1872 ('Country', 'PE', 173, '__Peru', '', '', '', '', ''), 
    1873 ('Country', 'PH', 174, '__Philippines', '', '', '', '', ''), 
    1874 ('Country', 'PN', 175, '__Pitcairn Islands', '', '', '', '', ''), 
    1875 ('Country', 'PL', 176, '__Poland', '', '', '', '', ''), 
    1876 ('Country', 'PT', 177, '__Portugal', '', '', '', '', ''), 
    1877 ('Country', 'PR', 178, '__Puerto Rico', '', '', '', '', ''), 
    1878 ('Country', 'QA', 179, '__Qatar', '', '', '', '', ''), 
    1879 ('Country', 'RE', 180, '__Reunion', '', '', '', '', ''), 
    1880 ('Country', 'RO', 181, '__Romania', '', '', '', '', ''), 
    1881 ('Country', 'RU', 182, '__Russia', '', '', '', '', ''), 
    1882 ('Country', 'RW', 183, '__Rwanda', '', '', '', '', ''), 
    1883 ('Country', 'SH', 184, '__Saint Helena', '', '', '', '', ''), 
    1884 ('Country', 'KN', 185, '__Saint Kitts and Nevis', '', '', '', '', ''), 
    1885 ('Country', 'LC', 186, '__Saint Lucia', '', '', '', '', ''), 
    1886 ('Country', 'PM', 187, '__Saint Pierre and Miquelon', '', '', '', '', ''), 
    1887 ('Country', 'VC', 188, '__Saint Vincent and the Grenadines', '', '', '', '', ''), 
    1888 ('Country', 'BL', 189, '__Saint_Barthelemy', '', '', '', '', ''), 
    1889 ('Country', 'MF', 190, '__Saint_Martin_French_part', '', '', '', '', ''), 
    1890 ('Country', 'WS', 191, '__Samoa', '', '', '', '', ''), 
    1891 ('Country', 'SM', 192, '__San Marino', '', '', '', '', ''), 
    1892 ('Country', 'ST', 193, '__Sao Tome and Principe', '', '', '', '', ''), 
    1893 ('Country', 'SA', 194, '__Saudi Arabia', '', '', '', '', ''), 
    1894 ('Country', 'SN', 195, '__Senegal', '', '', '', '', ''), 
    1895 ('Country', 'RS', 196, '__Serbia', '', '', '', '', ''), 
    1896 ('Country', 'SC', 197, '__Seychelles', '', '', '', '', ''), 
    1897 ('Country', 'SL', 198, '__Sierra Leone', '', '', '', '', ''), 
    1898 ('Country', 'SG', 199, '__Singapore', '', '', '', '', ''), 
    1899 ('Country', 'SK', 200, '__Slovakia', '', '', '', '', ''), 
    1900 ('Country', 'SI', 201, '__Slovenia', '', '', '', '', ''), 
    1901 ('Country', 'SB', 202, '__Solomon Islands', '', '', '', '', ''), 
    1902 ('Country', 'SO', 203, '__Somalia', '', '', '', '', ''), 
    1903 ('Country', 'ZA', 204, '__South Africa', '', '', '', '', ''), 
    1904 ('Country', 'GS', 205, '__South Georgia and the South Sandwich Islands', '', '', '', '', ''), 
    1905 ('Country', 'ES', 206, '__Spain', '', '', '', '', ''), 
    1906 ('Country', 'LK', 207, '__Sri Lanka', '', '', '', '', ''), 
    1907 ('Country', 'SD', 208, '__Sudan', '', '', '', '', ''), 
    1908 ('Country', 'SR', 209, '__Suriname', '', '', '', '', ''), 
    1909 ('Country', 'SJ', 210, '__Svalbard', '', '', '', '', ''), 
    1910 ('Country', 'SZ', 211, '__Swaziland', '', '', '', '', ''), 
    1911 ('Country', 'SE', 212, '__Sweden', '', '', '', '', ''), 
    1912 ('Country', 'CH', 213, '__Switzerland', '', '', '', '', ''), 
    1913 ('Country', 'SY', 214, '__Syria', '', '', '', '', ''), 
    1914 ('Country', 'TW', 215, '__Taiwan', '', '', '', '', ''), 
    1915 ('Country', 'TJ', 216, '__Tajikistan', '', '', '', '', ''), 
    1916 ('Country', 'TZ', 217, '__Tanzania', '', '', '', '', ''), 
    1917 ('Country', 'TH', 218, '__Thailand', '', '', '', '', ''), 
    1918 ('Country', 'BS', 219, '__The Bahamas', '', '', '', '', ''), 
    1919 ('Country', 'GM', 220, '__The Gambia', '', '', '', '', ''), 
    1920 ('Country', 'TG', 221, '__Togo', '', '', '', '', ''), 
    1921 ('Country', 'TK', 222, '__Tokelau', '', '', '', '', ''), 
    1922 ('Country', 'TO', 223, '__Tonga', '', '', '', '', ''), 
    1923 ('Country', 'TT', 224, '__Trinidad and Tobago', '', '', '', '', ''), 
    1924 ('Country', 'TN', 225, '__Tunisia', '', '', '', '', ''), 
    1925 ('Country', 'TR', 226, '__Turkey', '', '', '', '', ''), 
    1926 ('Country', 'TM', 227, '__Turkmenistan', '', '', '', '', ''), 
    1927 ('Country', 'TC', 228, '__Turks and Caicos Islands', '', '', '', '', ''), 
    1928 ('Country', 'TV', 229, '__Tuvalu', '', '', '', '', ''), 
    1929 ('Country', 'UG', 230, '__Uganda', '', '', '', '', ''), 
    1930 ('Country', 'UA', 231, '__Ukraine', '', '', '', '', ''), 
    1931 ('Country', 'AE', 232, '__United Arab Emirates', '', '', '', '', ''), 
    1932 ('Country', 'GB', 233, '__United Kingdom', '', '', '', '', ''), 
    1933 ('Country', 'US', 234, '__United States', '', '', '', '', ''), 
    1934 ('Country', 'UM', 235, '__United States Minor Outlying Islands', '', '', '', '', ''), 
    1935 ('Country', 'UY', 236, '__Uruguay', '', '', '', '', ''), 
    1936 ('Country', 'UZ', 237, '__Uzbekistan', '', '', '', '', ''), 
    1937 ('Country', 'VU', 238, '__Vanuatu', '', '', '', '', ''), 
    1938 ('Country', 'VE', 239, '__Venezuela', '', '', '', '', ''), 
    1939 ('Country', 'VN', 240, '__Vietnam', '', '', '', '', ''), 
    1940 ('Country', 'VI', 241, '__Virgin Islands', '', '', '', '', ''), 
    1941 ('Country', 'WF', 242, '__Wallis and Futuna', '', '', '', '', ''), 
    1942 ('Country', 'EH', 243, '__Western Sahara', '', '', '', '', ''), 
    1943 ('Country', 'YE', 244, '__Yemen', '', '', '', '', ''), 
    1944 ('Country', 'ZM', 245, '__Zambia', '', '', '', '', ''), 
    1945 ('Country', 'ZW', 246, '__Zimbabwe', '', '', '', '', ''); 
    1946  
    1947 INSERT INTO `sys_pre_values` VALUES('Sex', 'female', 1, '_Female', '_LookinFemale', '', '', '', ''); 
    1948 INSERT INTO `sys_pre_values` VALUES('Sex', 'male', 0, '_Male', '_LookinMale', '', '', '', ''); 
    1949 INSERT INTO `sys_pre_values` VALUES('Height', '1', 1, '__4''7" (140cm) or below', '', '', '', '', ''); 
    1950 INSERT INTO `sys_pre_values` VALUES('Height', '2', 2, '__4''8" - 4''11" (141-150cm)', '', '', '', '', ''); 
    1951 INSERT INTO `sys_pre_values` VALUES('Height', '3', 3, '__5''0" - 5''3" (151-160cm)', '', '', '', '', ''); 
    1952 INSERT INTO `sys_pre_values` VALUES('Height', '4', 4, '__5''4" - 5''7" (161-170cm)', '', '', '', '', ''); 
    1953 INSERT INTO `sys_pre_values` VALUES('Height', '5', 5, '__5''8" - 5''11" (171-180cm)', '', '', '', '', ''); 
    1954 INSERT INTO `sys_pre_values` VALUES('Height', '6', 6, '__6''0" - 6''3" (181-190cm)', '', '', '', '', ''); 
    1955 INSERT INTO `sys_pre_values` VALUES('Height', '7', 7, '__6''4" (191cm) or above', '', '', '', '', ''); 
    1956 INSERT INTO `sys_pre_values` VALUES('BodyType', '1', 1, '__Average', '', '', '', '', ''); 
    1957 INSERT INTO `sys_pre_values` VALUES('BodyType', '2', 2, '__Ample', '', '', '', '', ''); 
    1958 INSERT INTO `sys_pre_values` VALUES('BodyType', '3', 3, '__Athletic', '', '', '', '', ''); 
    1959 INSERT INTO `sys_pre_values` VALUES('BodyType', '4', 4, '__Cuddly', '', '', '', '', ''); 
    1960 INSERT INTO `sys_pre_values` VALUES('BodyType', '5', 5, '__Slim', '', '', '', '', ''); 
    1961 INSERT INTO `sys_pre_values` VALUES('BodyType', '6', 6, '__Very Cuddly', '', '', '', '', ''); 
    1962 INSERT INTO `sys_pre_values` VALUES('Religion', '1', 1, '__Adventist', '', '', '', '', ''); 
    1963 INSERT INTO `sys_pre_values` VALUES('Religion', '2', 2, '__Agnostic', '', '', '', '', ''); 
    1964 INSERT INTO `sys_pre_values` VALUES('Religion', '3', 3, '__Atheist', '', '', '', '', ''); 
    1965 INSERT INTO `sys_pre_values` VALUES('Religion', '4', 4, '__Baptist', '', '', '', '', ''); 
    1966 INSERT INTO `sys_pre_values` VALUES('Religion', '5', 5, '__Buddhist', '', '', '', '', ''); 
    1967 INSERT INTO `sys_pre_values` VALUES('Religion', '6', 6, '__Caodaism', '', '', '', '', ''); 
    1968 INSERT INTO `sys_pre_values` VALUES('Religion', '7', 7, '__Catholic', '', '', '', '', ''); 
    1969 INSERT INTO `sys_pre_values` VALUES('Religion', '8', 8, '__Christian', '', '', '', '', ''); 
    1970 INSERT INTO `sys_pre_values` VALUES('Religion', '9', 9, '__Hindu', '', '', '', '', ''); 
    1971 INSERT INTO `sys_pre_values` VALUES('Religion', '10', 10, '__Iskcon', '', '', '', '', ''); 
    1972 INSERT INTO `sys_pre_values` VALUES('Religion', '11', 11, '__Jainism', '', '', '', '', ''); 
    1973 INSERT INTO `sys_pre_values` VALUES('Religion', '12', 12, '__Jewish', '', '', '', '', ''); 
    1974 INSERT INTO `sys_pre_values` VALUES('Religion', '13', 13, '__Methodist', '', '', '', '', ''); 
    1975 INSERT INTO `sys_pre_values` VALUES('Religion', '14', 14, '__Mormon', '', '', '', '', ''); 
    1976 INSERT INTO `sys_pre_values` VALUES('Religion', '15', 15, '__Moslem', '', '', '', '', ''); 
    1977 INSERT INTO `sys_pre_values` VALUES('Religion', '16', 16, '__Orthodox', '', '', '', '', ''); 
    1978 INSERT INTO `sys_pre_values` VALUES('Religion', '17', 17, '__Pentecostal', '', '', '', '', ''); 
    1979 INSERT INTO `sys_pre_values` VALUES('Religion', '18', 18, '__Protestant', '', '', '', '', ''); 
    1980 INSERT INTO `sys_pre_values` VALUES('Religion', '19', 19, '__Quaker', '', '', '', '', ''); 
    1981 INSERT INTO `sys_pre_values` VALUES('Religion', '20', 20, '__Scientology', '', '', '', '', ''); 
    1982 INSERT INTO `sys_pre_values` VALUES('Religion', '21', 21, '__Shinto', '', '', '', '', ''); 
    1983 INSERT INTO `sys_pre_values` VALUES('Religion', '22', 22, '__Sikhism', '', '', '', '', ''); 
    1984 INSERT INTO `sys_pre_values` VALUES('Religion', '23', 23, '__Spiritual', '', '', '', '', ''); 
    1985 INSERT INTO `sys_pre_values` VALUES('Religion', '24', 24, '__Taoism', '', '', '', '', ''); 
    1986 INSERT INTO `sys_pre_values` VALUES('Religion', '25', 25, '__Wiccan', '', '', '', '', ''); 
    1987 INSERT INTO `sys_pre_values` VALUES('Religion', '26', 26, '__Other', '', '', '', '', ''); 
    1988 INSERT INTO `sys_pre_values` VALUES('Ethnicity', '1', 1, '__African', '', '', '', '', ''); 
    1989 INSERT INTO `sys_pre_values` VALUES('Ethnicity', '2', 2, '__African American', '', '', '', '', ''); 
    1990 INSERT INTO `sys_pre_values` VALUES('Ethnicity', '3', 3, '__Asian', '', '', '', '', ''); 
    1991 INSERT INTO `sys_pre_values` VALUES('Ethnicity', '4', 4, '__Caucasian', '', '', '', '', ''); 
    1992 INSERT INTO `sys_pre_values` VALUES('Ethnicity', '5', 5, '__East Indian', '', '', '', '', ''); 
    1993 INSERT INTO `sys_pre_values` VALUES('Ethnicity', '6', 6, '__Hispanic', '', '', '', '', ''); 
    1994 INSERT INTO `sys_pre_values` VALUES('Ethnicity', '7', 7, '__Indian', '', '', '', '', ''); 
    1995 INSERT INTO `sys_pre_values` VALUES('Ethnicity', '8', 8, '__Latino', '', '', '', '', ''); 
    1996 INSERT INTO `sys_pre_values` VALUES('Ethnicity', '9', 9, '__Mediterranean', '', '', '', '', ''); 
    1997 INSERT INTO `sys_pre_values` VALUES('Ethnicity', '10', 10, '__Middle Eastern', '', '', '', '', ''); 
    1998 INSERT INTO `sys_pre_values` VALUES('Ethnicity', '11', 11, '__Mixed', '', '', '', '', ''); 
    1999 INSERT INTO `sys_pre_values` VALUES('MaritalStatus', '1', 1, '__Single', '', '', '', '', ''); 
    2000 INSERT INTO `sys_pre_values` VALUES('MaritalStatus', '2', 2, '__Attached', '', '', '', '', ''); 
    2001 INSERT INTO `sys_pre_values` VALUES('MaritalStatus', '3', 3, '__Divorced', '', '', '', '', ''); 
    2002 INSERT INTO `sys_pre_values` VALUES('MaritalStatus', '4', 4, '__Married', '', '', '', '', ''); 
    2003 INSERT INTO `sys_pre_values` VALUES('MaritalStatus', '5', 5, '__Separated', '', '', '', '', ''); 
    2004 INSERT INTO `sys_pre_values` VALUES('MaritalStatus', '6', 6, '__Widow', '', '', '', '', ''); 
    2005 INSERT INTO `sys_pre_values` VALUES('Language', '0', 0, '__English', '', '', '', '', ''); 
    2006 INSERT INTO `sys_pre_values` VALUES('Language', '1', 1, '__Afrikaans', '', '', '', '', ''); 
    2007 INSERT INTO `sys_pre_values` VALUES('Language', '2', 2, '__Arabic', '', '', '', '', ''); 
    2008 INSERT INTO `sys_pre_values` VALUES('Language', '3', 3, '__Bulgarian', '', '', '', '', ''); 
    2009 INSERT INTO `sys_pre_values` VALUES('Language', '4', 4, '__Burmese', '', '', '', '', ''); 
    2010 INSERT INTO `sys_pre_values` VALUES('Language', '5', 5, '__Cantonese', '', '', '', '', ''); 
    2011 INSERT INTO `sys_pre_values` VALUES('Language', '6', 6, '__Croatian', '', '', '', '', ''); 
    2012 INSERT INTO `sys_pre_values` VALUES('Language', '7', 7, '__Danish', '', '', '', '', ''); 
    2013 INSERT INTO `sys_pre_values` VALUES('Language', '8', 8, '__Dutch', '', '', '', '', ''); 
    2014 INSERT INTO `sys_pre_values` VALUES('Language', '9', 9, '__Esperanto', '', '', '', '', ''); 
    2015 INSERT INTO `sys_pre_values` VALUES('Language', '10', 10, '__Estonian', '', '', '', '', ''); 
    2016 INSERT INTO `sys_pre_values` VALUES('Language', '11', 11, '__Finnish', '', '', '', '', ''); 
    2017 INSERT INTO `sys_pre_values` VALUES('Language', '12', 12, '__French', '', '', '', '', ''); 
    2018 INSERT INTO `sys_pre_values` VALUES('Language', '13', 13, '__German', '', '', '', '', ''); 
    2019 INSERT INTO `sys_pre_values` VALUES('Language', '14', 14, '__Greek', '', '', '', '', ''); 
    2020 INSERT INTO `sys_pre_values` VALUES('Language', '15', 15, '__Gujrati', '', '', '', '', ''); 
    2021 INSERT INTO `sys_pre_values` VALUES('Language', '16', 16, '__Hebrew', '', '', '', '', ''); 
    2022 INSERT INTO `sys_pre_values` VALUES('Language', '17', 17, '__Hindi', '', '', '', '', ''); 
    2023 INSERT INTO `sys_pre_values` VALUES('Language', '18', 18, '__Hungarian', '', '', '', '', ''); 
    2024 INSERT INTO `sys_pre_values` VALUES('Language', '19', 19, '__Icelandic', '', '', '', '', ''); 
    2025 INSERT INTO `sys_pre_values` VALUES('Language', '20', 20, '__Indian', '', '', '', '', ''); 
    2026 INSERT INTO `sys_pre_values` VALUES('Language', '21', 21, '__Indonesian', '', '', '', '', ''); 
    2027 INSERT INTO `sys_pre_values` VALUES('Language', '22', 22, '__Italian', '', '', '', '', ''); 
    2028 INSERT INTO `sys_pre_values` VALUES('Language', '23', 23, '__Japanese', '', '', '', '', ''); 
    2029 INSERT INTO `sys_pre_values` VALUES('Language', '24', 24, '__Korean', '', '', '', '', ''); 
    2030 INSERT INTO `sys_pre_values` VALUES('Language', '25', 25, '__Latvian', '', '', '', '', ''); 
    2031 INSERT INTO `sys_pre_values` VALUES('Language', '26', 26, '__Lithuanian', '', '', '', '', ''); 
    2032 INSERT INTO `sys_pre_values` VALUES('Language', '27', 27, '__Malay', '', '', '', '', ''); 
    2033 INSERT INTO `sys_pre_values` VALUES('Language', '28', 28, '__Mandarin', '', '', '', '', ''); 
    2034 INSERT INTO `sys_pre_values` VALUES('Language', '29', 29, '__Marathi', '', '', '', '', ''); 
    2035 INSERT INTO `sys_pre_values` VALUES('Language', '30', 30, '__Moldovian', '', '', '', '', ''); 
    2036 INSERT INTO `sys_pre_values` VALUES('Language', '31', 31, '__Nepalese', '', '', '', '', ''); 
    2037 INSERT INTO `sys_pre_values` VALUES('Language', '32', 32, '__Norwegian', '', '', '', '', ''); 
    2038 INSERT INTO `sys_pre_values` VALUES('Language', '33', 33, '__Persian', '', '', '', '', ''); 
    2039 INSERT INTO `sys_pre_values` VALUES('Language', '34', 34, '__Polish', '', '', '', '', ''); 
    2040 INSERT INTO `sys_pre_values` VALUES('Language', '35', 35, '__Portuguese', '', '', '', '', ''); 
    2041 INSERT INTO `sys_pre_values` VALUES('Language', '36', 36, '__Punjabi', '', '', '', '', ''); 
    2042 INSERT INTO `sys_pre_values` VALUES('Language', '37', 37, '__Romanian', '', '', '', '', ''); 
    2043 INSERT INTO `sys_pre_values` VALUES('Language', '38', 38, '__Russian', '', '', '', '', ''); 
    2044 INSERT INTO `sys_pre_values` VALUES('Language', '39', 39, '__Serbian', '', '', '', '', ''); 
    2045 INSERT INTO `sys_pre_values` VALUES('Language', '40', 40, '__Spanish', '', '', '', '', ''); 
    2046 INSERT INTO `sys_pre_values` VALUES('Language', '41', 41, '__Swedish', '', '', '', '', ''); 
    2047 INSERT INTO `sys_pre_values` VALUES('Language', '42', 42, '__Tagalog', '', '', '', '', ''); 
    2048 INSERT INTO `sys_pre_values` VALUES('Language', '43', 43, '__Taiwanese', '', '', '', '', ''); 
    2049 INSERT INTO `sys_pre_values` VALUES('Language', '44', 44, '__Tamil', '', '', '', '', ''); 
    2050 INSERT INTO `sys_pre_values` VALUES('Language', '45', 45, '__Telugu', '', '', '', '', ''); 
    2051 INSERT INTO `sys_pre_values` VALUES('Language', '46', 46, '__Thai', '', '', '', '', ''); 
    2052 INSERT INTO `sys_pre_values` VALUES('Language', '47', 47, '__Tongan', '', '', '', '', ''); 
    2053 INSERT INTO `sys_pre_values` VALUES('Language', '48', 48, '__Turkish', '', '', '', '', ''); 
    2054 INSERT INTO `sys_pre_values` VALUES('Language', '49', 49, '__Ukrainian', '', '', '', '', ''); 
    2055 INSERT INTO `sys_pre_values` VALUES('Language', '50', 50, '__Urdu', '', '', '', '', ''); 
    2056 INSERT INTO `sys_pre_values` VALUES('Language', '51', 51, '__Vietnamese', '', '', '', '', ''); 
    2057 INSERT INTO `sys_pre_values` VALUES('Language', '52', 52, '__Visayan', '', '', '', '', ''); 
    2058 INSERT INTO `sys_pre_values` VALUES('Education', '1', 1, '__High School graduate', '', '', '', '', ''); 
    2059 INSERT INTO `sys_pre_values` VALUES('Education', '2', 2, '__Some college', '', '', '', '', ''); 
    2060 INSERT INTO `sys_pre_values` VALUES('Education', '3', 3, '__College student', '', '', '', '', ''); 
    2061 INSERT INTO `sys_pre_values` VALUES('Education', '4', 4, '__AA (2 years college)', '', '', '', '', ''); 
    2062 INSERT INTO `sys_pre_values` VALUES('Education', '5', 5, '__BA/BS (4 years college)', '', '', '', '', ''); 
    2063 INSERT INTO `sys_pre_values` VALUES('Education', '6', 6, '__Some grad school', '', '', '', '', ''); 
    2064 INSERT INTO `sys_pre_values` VALUES('Education', '7', 7, '__Grad school student', '', '', '', '', ''); 
    2065 INSERT INTO `sys_pre_values` VALUES('Education', '8', 8, '__MA/MS/MBA', '', '', '', '', ''); 
    2066 INSERT INTO `sys_pre_values` VALUES('Education', '9', 9, '__PhD/Post doctorate', '', '', '', '', ''); 
    2067 INSERT INTO `sys_pre_values` VALUES('Education', '10', 10, '__JD', '', '', '', '', ''); 
    2068 INSERT INTO `sys_pre_values` VALUES('Income', '1', 1, '__$10,000/year and less', '', '', '', '', ''); 
    2069 INSERT INTO `sys_pre_values` VALUES('Income', '2', 2, '__$10,000-$30,000/year', '', '', '', '', ''); 
    2070 INSERT INTO `sys_pre_values` VALUES('Income', '3', 3, '__$30,000-$50,000/year', '', '', '', '', ''); 
    2071 INSERT INTO `sys_pre_values` VALUES('Income', '4', 4, '__$50,000-$70,000/year', '', '', '', '', ''); 
    2072 INSERT INTO `sys_pre_values` VALUES('Income', '5', 5, '__$70,000/year and more', '', '', '', '', ''); 
    2073 INSERT INTO `sys_pre_values` VALUES('Smoker', '1', 1, '__No', '', '', '', '', ''); 
    2074 INSERT INTO `sys_pre_values` VALUES('Smoker', '2', 2, '__Rarely', '', '', '', '', ''); 
    2075 INSERT INTO `sys_pre_values` VALUES('Smoker', '3', 3, '__Often', '', '', '', '', ''); 
    2076 INSERT INTO `sys_pre_values` VALUES('Smoker', '4', 4, '__Very often', '', '', '', '', ''); 
    2077 INSERT INTO `sys_pre_values` VALUES('Drinker', '1', 1, '__No', '', '', '', '', ''); 
    2078 INSERT INTO `sys_pre_values` VALUES('Drinker', '2', 2, '__Rarely', '', '', '', '', ''); 
    2079 INSERT INTO `sys_pre_values` VALUES('Drinker', '3', 3, '__Often', '', '', '', '', ''); 
    2080 INSERT INTO `sys_pre_values` VALUES('Drinker', '4', 4, '__Very often', '', '', '', '', ''); 
    2081 -- -------------------------------------------------------- 
     1680 
    20821681 
    20831682-- 
    … …  
    44534052 
    44544053 
    4455 -- -------------------------------------------------------- 
    4456  
     4054-- 
     4055-- Table structure for table `sys_form_pre_lists` 
     4056-- 
     4057CREATE TABLE `sys_form_pre_lists` ( 
     4058  `id` int(11) NOT NULL AUTO_INCREMENT, 
     4059  `module` varchar(32) NOT NULL default '', 
     4060  `key` varchar(255) NOT NULL default '', 
     4061  `title` varchar(255) NOT NULL default '', 
     4062  `use_for_sets` tinyint(4) unsigned NOT NULL default '0', 
     4063  PRIMARY KEY (`id`), 
     4064  UNIQUE KEY `key` (`key`) 
     4065) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
     4066 
     4067-- 
     4068-- Dumping data for table `sys_form_pre_lists` 
     4069-- 
     4070INSERT INTO `sys_form_pre_lists`(`key`, `title`, `module`, `use_for_sets`) VALUES 
     4071('Country', '_adm_form_txt_pre_lists_country', 'system', '0'), 
     4072('Sex', '_adm_form_txt_pre_lists_sex', 'system', '1'), 
     4073('Height', '_adm_form_txt_pre_lists_height', 'system', '0'), 
     4074('BodyType', '_adm_form_txt_pre_lists_body_type', 'system', '0'), 
     4075('Religion', '_adm_form_txt_pre_lists_religion', 'system', '0'), 
     4076('Ethnicity', '_adm_form_txt_pre_lists_ethnicity', 'system', '0'), 
     4077('MaritalStatus', '_adm_form_txt_pre_lists_marital_status', 'system', '0'), 
     4078('Language', '_adm_form_txt_pre_lists_language', 'system', '0'), 
     4079('Education', '_adm_form_txt_pre_lists_education', 'system', '0'), 
     4080('Income', '_adm_form_txt_pre_lists_income', 'system', '0'), 
     4081('Smoker', '_adm_form_txt_pre_lists_smoker', 'system', '0'), 
     4082('Drinker', '_adm_form_txt_pre_lists_drinker', 'system', '0'); 
     4083 
     4084-- 
     4085-- Table structure for table `sys_form_pre_values` 
     4086-- 
     4087CREATE TABLE `sys_form_pre_values` ( 
     4088  `id` int(11) NOT NULL AUTO_INCREMENT, 
     4089  `Key` varchar(255) NOT NULL default '', 
     4090  `Value` varchar(255) NOT NULL default '', 
     4091  `Order` int(10) unsigned NOT NULL default '0', 
     4092  `LKey` varchar(255) NOT NULL default '', 
     4093  `LKey2` varchar(255) NOT NULL default '', 
     4094  PRIMARY KEY (`id`) 
     4095) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
     4096 
     4097-- 
     4098-- Dumping data for table `sys_form_pre_values` 
     4099-- 
     4100INSERT INTO `sys_form_pre_values`(`Key`, `Value`, `Order`, `LKey`, `LKey2`) VALUES  
     4101('Country', 'AF', 1, '__Afghanistan', ''), 
     4102('Country', 'AX', 2, '__Aland_Islands', ''), 
     4103('Country', 'AL', 3, '__Albania', ''), 
     4104('Country', 'DZ', 4, '__Algeria', ''), 
     4105('Country', 'AS', 5, '__American Samoa', ''), 
     4106('Country', 'AD', 6, '__Andorra', ''), 
     4107('Country', 'AO', 7, '__Angola', ''), 
     4108('Country', 'AI', 8, '__Anguilla', ''), 
     4109('Country', 'AQ', 9, '__Antarctica', ''), 
     4110('Country', 'AG', 10, '__Antigua and Barbuda', ''), 
     4111('Country', 'AR', 11, '__Argentina', ''), 
     4112('Country', 'AM', 12, '__Armenia', ''), 
     4113('Country', 'AW', 13, '__Aruba', ''), 
     4114('Country', 'AU', 14, '__Australia', ''), 
     4115('Country', 'AT', 15, '__Austria', ''), 
     4116('Country', 'AZ', 16, '__Azerbaijan', ''), 
     4117('Country', 'BH', 17, '__Bahrain', ''), 
     4118('Country', 'BD', 18, '__Bangladesh', ''), 
     4119('Country', 'BB', 19, '__Barbados', ''), 
     4120('Country', 'BY', 20, '__Belarus', ''), 
     4121('Country', 'BE', 21, '__Belgium', ''), 
     4122('Country', 'BZ', 22, '__Belize', ''), 
     4123('Country', 'BJ', 23, '__Benin', ''), 
     4124('Country', 'BM', 24, '__Bermuda', ''), 
     4125('Country', 'BT', 25, '__Bhutan', ''), 
     4126('Country', 'BO', 26, '__Bolivia', ''), 
     4127('Country', 'BA', 27, '__Bosnia and Herzegovina', ''), 
     4128('Country', 'BW', 28, '__Botswana', ''), 
     4129('Country', 'BV', 29, '__Bouvet Island', ''), 
     4130('Country', 'BR', 30, '__Brazil', ''), 
     4131('Country', 'IO', 31, '__British Indian Ocean Territory', ''), 
     4132('Country', 'VG', 32, '__British Virgin Islands', ''), 
     4133('Country', 'BN', 33, '__Brunei Darussalam', ''), 
     4134('Country', 'BG', 34, '__Bulgaria', ''), 
     4135('Country', 'BF', 35, '__Burkina Faso', ''), 
     4136('Country', 'MM', 36, '__Burma', ''), 
     4137('Country', 'BI', 37, '__Burundi', ''), 
     4138('Country', 'KH', 38, '__Cambodia', ''), 
     4139('Country', 'CM', 39, '__Cameroon', ''), 
     4140('Country', 'CA', 40, '__Canada', ''), 
     4141('Country', 'CV', 41, '__Cape Verde', ''), 
     4142('Country', 'KY', 42, '__Cayman Islands', ''), 
     4143('Country', 'CF', 43, '__Central African Republic', ''), 
     4144('Country', 'TD', 44, '__Chad', ''), 
     4145('Country', 'CL', 45, '__Chile', ''), 
     4146('Country', 'CN', 46, '__China', ''), 
     4147('Country', 'CX', 47, '__Christmas Island', ''), 
     4148('Country', 'CC', 48, '__Cocos (Keeling) Islands', ''), 
     4149('Country', 'CO', 49, '__Colombia', ''), 
     4150('Country', 'KM', 50, '__Comoros', ''), 
     4151('Country', 'CD', 51, '__Congo, Democratic Republic of the', ''), 
     4152('Country', 'CG', 52, '__Congo, Republic of the', ''), 
     4153('Country', 'CK', 53, '__Cook Islands', ''), 
     4154('Country', 'CR', 54, '__Costa Rica', ''), 
     4155('Country', 'CI', 55, '__Cote d''Ivoire', ''), 
     4156('Country', 'HR', 56, '__Croatia', ''), 
     4157('Country', 'CU', 57, '__Cuba', ''), 
     4158('Country', 'CY', 58, '__Cyprus', ''), 
     4159('Country', 'CZ', 59, '__Czech Republic', ''), 
     4160('Country', 'DK', 60, '__Denmark', ''), 
     4161('Country', 'DJ', 61, '__Djibouti', ''), 
     4162('Country', 'DM', 62, '__Dominica', ''), 
     4163('Country', 'DO', 63, '__Dominican Republic', ''), 
     4164('Country', 'TL', 64, '__East Timor', ''), 
     4165('Country', 'EC', 65, '__Ecuador', ''), 
     4166('Country', 'EG', 66, '__Egypt', ''), 
     4167('Country', 'SV', 67, '__El Salvador', ''), 
     4168('Country', 'GQ', 68, '__Equatorial Guinea', ''), 
     4169('Country', 'ER', 69, '__Eritrea', ''), 
     4170('Country', 'EE', 70, '__Estonia', ''), 
     4171('Country', 'ET', 71, '__Ethiopia', ''), 
     4172('Country', 'FK', 72, '__Falkland Islands (Islas Malvinas)', ''), 
     4173('Country', 'FO', 73, '__Faroe Islands', ''), 
     4174('Country', 'FJ', 74, '__Fiji', ''), 
     4175('Country', 'FI', 75, '__Finland', ''), 
     4176('Country', 'FR', 76, '__France', ''), 
     4177('Country', 'GF', 77, '__French Guiana', ''), 
     4178('Country', 'PF', 78, '__French Polynesia', ''), 
     4179('Country', 'TF', 79, '__French Southern and Antarctic Lands', ''), 
     4180('Country', 'GA', 80, '__Gabon', ''), 
     4181('Country', 'GE', 81, '__Georgia', ''), 
     4182('Country', 'DE', 82, '__Germany', ''), 
     4183('Country', 'GH', 83, '__Ghana', ''), 
     4184('Country', 'GI', 84, '__Gibraltar', ''), 
     4185('Country', 'GR', 85, '__Greece', ''), 
     4186('Country', 'GL', 86, '__Greenland', ''), 
     4187('Country', 'GD', 87, '__Grenada', ''), 
     4188('Country', 'GP', 88, '__Guadeloupe', ''), 
     4189('Country', 'GU', 89, '__Guam', ''), 
     4190('Country', 'GT', 90, '__Guatemala', ''), 
     4191('Country', 'GG', 91, '__Guernsey', ''), 
     4192('Country', 'GN', 92, '__Guinea', ''), 
     4193('Country', 'GW', 93, '__Guinea-Bissau', ''), 
     4194('Country', 'GY', 94, '__Guyana', ''), 
     4195('Country', 'HT', 95, '__Haiti', ''), 
     4196('Country', 'HM', 96, '__Heard Island and McDonald Islands', ''), 
     4197('Country', 'VA', 97, '__Holy See (Vatican City)', ''), 
     4198('Country', 'HN', 98, '__Honduras', ''), 
     4199('Country', 'HK', 99, '__Hong Kong (SAR)', ''), 
     4200('Country', 'HU', 100, '__Hungary', ''), 
     4201('Country', 'IS', 101, '__Iceland', ''), 
     4202('Country', 'IN', 102, '__India', ''), 
     4203('Country', 'ID', 103, '__Indonesia', ''), 
     4204('Country', 'IR', 104, '__Iran', ''), 
     4205('Country', 'IQ', 105, '__Iraq', ''), 
     4206('Country', 'IE', 106, '__Ireland', ''), 
     4207('Country', 'IM', 107, '__Isle_of_Man', ''), 
     4208('Country', 'IL', 108, '__Israel', ''), 
     4209('Country', 'IT', 109, '__Italy', ''), 
     4210('Country', 'JM', 110, '__Jamaica', ''), 
     4211('Country', 'JP', 111, '__Japan', ''), 
     4212('Country', 'JE', 112, '__Jersey', ''), 
     4213('Country', 'JO', 113, '__Jordan', ''), 
     4214('Country', 'KZ', 114, '__Kazakhstan', ''), 
     4215('Country', 'KE', 115, '__Kenya', ''), 
     4216('Country', 'KI', 116, '__Kiribati', ''), 
     4217('Country', 'KP', 117, '__Korea, North', ''), 
     4218('Country', 'KR', 118, '__Korea, South', ''), 
     4219('Country', 'KW', 119, '__Kuwait', ''), 
     4220('Country', 'KG', 120, '__Kyrgyzstan', ''), 
     4221('Country', 'LA', 121, '__Laos', ''), 
     4222('Country', 'LV', 122, '__Latvia', ''), 
     4223('Country', 'LB', 123, '__Lebanon', ''), 
     4224('Country', 'LS', 124, '__Lesotho', ''), 
     4225('Country', 'LR', 125, '__Liberia', ''), 
     4226('Country', 'LY', 126, '__Libya', ''), 
     4227('Country', 'LI', 127, '__Liechtenstein', ''), 
     4228('Country', 'LT', 128, '__Lithuania', ''), 
     4229('Country', 'LU', 129, '__Luxembourg', ''), 
     4230('Country', 'MO', 130, '__Macao', ''), 
     4231('Country', 'MK', 131, '__Macedonia, The Former Yugoslav Republic of', ''), 
     4232('Country', 'MG', 132, '__Madagascar', ''), 
     4233('Country', 'MW', 133, '__Malawi', ''), 
     4234('Country', 'MY', 134, '__Malaysia', ''), 
     4235('Country', 'MV', 135, '__Maldives', ''), 
     4236('Country', 'ML', 136, '__Mali', ''), 
     4237('Country', 'MT', 137, '__Malta', ''), 
     4238('Country', 'MH', 138, '__Marshall Islands', ''), 
     4239('Country', 'MQ', 139, '__Martinique', ''), 
     4240('Country', 'MR', 140, '__Mauritania', ''), 
     4241('Country', 'MU', 141, '__Mauritius', ''), 
     4242('Country', 'YT', 142, '__Mayotte', ''), 
     4243('Country', 'MX', 143, '__Mexico', ''), 
     4244('Country', 'FM', 144, '__Micronesia, Federated States of', ''), 
     4245('Country', 'MD', 145, '__Moldova', ''), 
     4246('Country', 'MC', 146, '__Monaco', ''), 
     4247('Country', 'MN', 147, '__Mongolia', ''), 
     4248('Country', 'ME', 148, '__Montenegro', ''), 
     4249('Country', 'MS', 149, '__Montserrat', ''), 
     4250('Country', 'MA', 150, '__Morocco', ''), 
     4251('Country', 'MZ', 151, '__Mozambique', ''), 
     4252('Country', 'NA', 152, '__Namibia', ''), 
     4253('Country', 'NR', 153, '__Nauru', ''), 
     4254('Country', 'NP', 154, '__Nepal', ''), 
     4255('Country', 'NL', 155, '__Netherlands', ''), 
     4256('Country', 'AN', 156, '__Netherlands Antilles', ''), 
     4257('Country', 'NC', 157, '__New Caledonia', ''), 
     4258('Country', 'NZ', 158, '__New Zealand', ''), 
     4259('Country', 'NI', 159, '__Nicaragua', ''), 
     4260('Country', 'NE', 160, '__Niger', ''), 
     4261('Country', 'NG', 161, '__Nigeria', ''), 
     4262('Country', 'NU', 162, '__Niue', ''), 
     4263('Country', 'NF', 163, '__Norfolk Island', ''), 
     4264('Country', 'MP', 164, '__Northern Mariana Islands', ''), 
     4265('Country', 'NO', 165, '__Norway', ''), 
     4266('Country', 'OM', 166, '__Oman', ''), 
     4267('Country', 'PK', 167, '__Pakistan', ''), 
     4268('Country', 'PW', 168, '__Palau', ''), 
     4269('Country', 'PS', 169, '__Palestinian Territory, Occupied', ''), 
     4270('Country', 'PA', 170, '__Panama', ''), 
     4271('Country', 'PG', 171, '__Papua New Guinea', ''), 
     4272('Country', 'PY', 172, '__Paraguay', ''), 
     4273('Country', 'PE', 173, '__Peru', ''), 
     4274('Country', 'PH', 174, '__Philippines', ''), 
     4275('Country', 'PN', 175, '__Pitcairn Islands', ''), 
     4276('Country', 'PL', 176, '__Poland', ''), 
     4277('Country', 'PT', 177, '__Portugal', ''), 
     4278('Country', 'PR', 178, '__Puerto Rico', ''), 
     4279('Country', 'QA', 179, '__Qatar', ''), 
     4280('Country', 'RE', 180, '__Reunion', ''), 
     4281('Country', 'RO', 181, '__Romania', ''), 
     4282('Country', 'RU', 182, '__Russia', ''), 
     4283('Country', 'RW', 183, '__Rwanda', ''), 
     4284('Country', 'SH', 184, '__Saint Helena', ''), 
     4285('Country', 'KN', 185, '__Saint Kitts and Nevis', ''), 
     4286('Country', 'LC', 186, '__Saint Lucia', ''), 
     4287('Country', 'PM', 187, '__Saint Pierre and Miquelon', ''), 
     4288('Country', 'VC', 188, '__Saint Vincent and the Grenadines', ''), 
     4289('Country', 'BL', 189, '__Saint_Barthelemy', ''), 
     4290('Country', 'MF', 190, '__Saint_Martin_French_part', ''), 
     4291('Country', 'WS', 191, '__Samoa', ''), 
     4292('Country', 'SM', 192, '__San Marino', ''), 
     4293('Country', 'ST', 193, '__Sao Tome and Principe', ''), 
     4294('Country', 'SA', 194, '__Saudi Arabia', ''), 
     4295('Country', 'SN', 195, '__Senegal', ''), 
     4296('Country', 'RS', 196, '__Serbia', ''), 
     4297('Country', 'SC', 197, '__Seychelles', ''), 
     4298('Country', 'SL', 198, '__Sierra Leone', ''), 
     4299('Country', 'SG', 199, '__Singapore', ''), 
     4300('Country', 'SK', 200, '__Slovakia', ''), 
     4301('Country', 'SI', 201, '__Slovenia', ''), 
     4302('Country', 'SB', 202, '__Solomon Islands', ''), 
     4303('Country', 'SO', 203, '__Somalia', ''), 
     4304('Country', 'ZA', 204, '__South Africa', ''), 
     4305('Country', 'GS', 205, '__South Georgia and the South Sandwich Islands', ''), 
     4306('Country', 'ES', 206, '__Spain', ''), 
     4307('Country', 'LK', 207, '__Sri Lanka', ''), 
     4308('Country', 'SD', 208, '__Sudan', ''), 
     4309('Country', 'SR', 209, '__Suriname', ''), 
     4310('Country', 'SJ', 210, '__Svalbard', ''), 
     4311('Country', 'SZ', 211, '__Swaziland', ''), 
     4312('Country', 'SE', 212, '__Sweden', ''), 
     4313('Country', 'CH', 213, '__Switzerland', ''), 
     4314('Country', 'SY', 214, '__Syria', ''), 
     4315('Country', 'TW', 215, '__Taiwan', ''), 
     4316('Country', 'TJ', 216, '__Tajikistan', ''), 
     4317('Country', 'TZ', 217, '__Tanzania', ''), 
     4318('Country', 'TH', 218, '__Thailand', ''), 
     4319('Country', 'BS', 219, '__The Bahamas', ''), 
     4320('Country', 'GM', 220, '__The Gambia', ''), 
     4321('Country', 'TG', 221, '__Togo', ''), 
     4322('Country', 'TK', 222, '__Tokelau', ''), 
     4323('Country', 'TO', 223, '__Tonga', ''), 
     4324('Country', 'TT', 224, '__Trinidad and Tobago', ''), 
     4325('Country', 'TN', 225, '__Tunisia', ''), 
     4326('Country', 'TR', 226, '__Turkey', ''), 
     4327('Country', 'TM', 227, '__Turkmenistan', ''), 
     4328('Country', 'TC', 228, '__Turks and Caicos Islands', ''), 
     4329('Country', 'TV', 229, '__Tuvalu', ''), 
     4330('Country', 'UG', 230, '__Uganda', ''), 
     4331('Country', 'UA', 231, '__Ukraine', ''), 
     4332('Country', 'AE', 232, '__United Arab Emirates', ''), 
     4333('Country', 'GB', 233, '__United Kingdom', ''), 
     4334('Country', 'US', 234, '__United States', ''), 
     4335('Country', 'UM', 235, '__United States Minor Outlying Islands', ''), 
     4336('Country', 'UY', 236, '__Uruguay', ''), 
     4337('Country', 'UZ', 237, '__Uzbekistan', ''), 
     4338('Country', 'VU', 238, '__Vanuatu', ''), 
     4339('Country', 'VE', 239, '__Venezuela', ''), 
     4340('Country', 'VN', 240, '__Vietnam', ''), 
     4341('Country', 'VI', 241, '__Virgin Islands', ''), 
     4342('Country', 'WF', 242, '__Wallis and Futuna', ''), 
     4343('Country', 'EH', 243, '__Western Sahara', ''), 
     4344('Country', 'YE', 244, '__Yemen', ''), 
     4345('Country', 'ZM', 245, '__Zambia', ''), 
     4346('Country', 'ZW', 246, '__Zimbabwe', ''); 
     4347 
     4348INSERT INTO `sys_form_pre_values`(`Key`, `Value`, `Order`, `LKey`, `LKey2`) VALUES 
     4349('Sex', '1', 0, '_Male', '_LookinMale'), 
     4350('Sex', '2', 1, '_Female', '_LookinFemale'); 
     4351 
     4352INSERT INTO `sys_form_pre_values`(`Key`, `Value`, `Order`, `LKey`, `LKey2`) VALUES  
     4353('Height', '1', 1, '__4''7" (140cm) or below', ''), 
     4354('Height', '2', 2, '__4''8" - 4''11" (141-150cm)', ''), 
     4355('Height', '3', 3, '__5''0" - 5''3" (151-160cm)', ''), 
     4356('Height', '4', 4, '__5''4" - 5''7" (161-170cm)', ''), 
     4357('Height', '5', 5, '__5''8" - 5''11" (171-180cm)', ''), 
     4358('Height', '6', 6, '__6''0" - 6''3" (181-190cm)', ''), 
     4359('Height', '7', 7, '__6''4" (191cm) or above', ''); 
     4360 
     4361INSERT INTO `sys_form_pre_values`(`Key`, `Value`, `Order`, `LKey`, `LKey2`) VALUES  
     4362('BodyType', '1', 1, '__Average', ''), 
     4363('BodyType', '2', 2, '__Ample', ''), 
     4364('BodyType', '3', 3, '__Athletic', ''), 
     4365('BodyType', '4', 4, '__Cuddly', ''), 
     4366('BodyType', '5', 5, '__Slim', ''), 
     4367('BodyType', '6', 6, '__Very Cuddly', ''); 
     4368 
     4369INSERT INTO `sys_form_pre_values`(`Key`, `Value`, `Order`, `LKey`, `LKey2`) VALUES  
     4370('Religion', '1', 1, '__Adventist', ''), 
     4371('Religion', '2', 2, '__Agnostic', ''), 
     4372('Religion', '3', 3, '__Atheist', ''), 
     4373('Religion', '4', 4, '__Baptist', ''), 
     4374('Religion', '5', 5, '__Buddhist', ''), 
     4375('Religion', '6', 6, '__Caodaism', ''), 
     4376('Religion', '7', 7, '__Catholic', ''), 
     4377('Religion', '8', 8, '__Christian', ''), 
     4378('Religion', '9', 9, '__Hindu', ''), 
     4379('Religion', '10', 10, '__Iskcon', ''), 
     4380('Religion', '11', 11, '__Jainism', ''), 
     4381('Religion', '12', 12, '__Jewish', ''), 
     4382('Religion', '13', 13, '__Methodist', ''), 
     4383('Religion', '14', 14, '__Mormon', ''), 
     4384('Religion', '15', 15, '__Moslem', ''), 
     4385('Religion', '16', 16, '__Orthodox', ''), 
     4386('Religion', '17', 17, '__Pentecostal', ''), 
     4387('Religion', '18', 18, '__Protestant', ''), 
     4388('Religion', '19', 19, '__Quaker', ''), 
     4389('Religion', '20', 20, '__Scientology', ''), 
     4390('Religion', '21', 21, '__Shinto', ''), 
     4391('Religion', '22', 22, '__Sikhism', ''), 
     4392('Religion', '23', 23, '__Spiritual', ''), 
     4393('Religion', '24', 24, '__Taoism', ''), 
     4394('Religion', '25', 25, '__Wiccan', ''), 
     4395('Religion', '26', 26, '__Other', ''); 
     4396 
     4397INSERT INTO `sys_form_pre_values`(`Key`, `Value`, `Order`, `LKey`, `LKey2`) VALUES  
     4398('Ethnicity', '1', 1, '__African', ''), 
     4399('Ethnicity', '2', 2, '__African American', ''), 
     4400('Ethnicity', '3', 3, '__Asian', ''), 
     4401('Ethnicity', '4', 4, '__Caucasian', ''), 
     4402('Ethnicity', '5', 5, '__East Indian', ''), 
     4403('Ethnicity', '6', 6, '__Hispanic', ''), 
     4404('Ethnicity', '7', 7, '__Indian', ''), 
     4405('Ethnicity', '8', 8, '__Latino', ''), 
     4406('Ethnicity', '9', 9, '__Mediterranean', ''), 
     4407('Ethnicity', '10', 10, '__Middle Eastern', ''), 
     4408('Ethnicity', '11', 11, '__Mixed', ''); 
     4409 
     4410INSERT INTO `sys_form_pre_values`(`Key`, `Value`, `Order`, `LKey`, `LKey2`) VALUES  
     4411('MaritalStatus', '1', 1, '__Single', ''), 
     4412('MaritalStatus', '2', 2, '__Attached', ''), 
     4413('MaritalStatus', '3', 3, '__Divorced', ''), 
     4414('MaritalStatus', '4', 4, '__Married', ''), 
     4415('MaritalStatus', '5', 5, '__Separated', ''), 
     4416('MaritalStatus', '6', 6, '__Widow', ''); 
     4417 
     4418INSERT INTO `sys_form_pre_values`(`Key`, `Value`, `Order`, `LKey`, `LKey2`) VALUES  
     4419('Language', '0', 0, '__English', ''), 
     4420('Language', '1', 1, '__Afrikaans', ''), 
     4421('Language', '2', 2, '__Arabic', ''), 
     4422('Language', '3', 3, '__Bulgarian', ''), 
     4423('Language', '4', 4, '__Burmese', ''), 
     4424('Language', '5', 5, '__Cantonese', ''), 
     4425('Language', '6', 6, '__Croatian', ''), 
     4426('Language', '7', 7, '__Danish', ''), 
     4427('Language', '8', 8, '__Dutch', ''), 
     4428('Language', '9', 9, '__Esperanto', ''), 
     4429('Language', '10', 10, '__Estonian', ''), 
     4430('Language', '11', 11, '__Finnish', ''), 
     4431('Language', '12', 12, '__French', ''), 
     4432('Language', '13', 13, '__German', ''), 
     4433('Language', '14', 14, '__Greek', ''), 
     4434('Language', '15', 15, '__Gujrati', ''), 
     4435('Language', '16', 16, '__Hebrew', ''), 
     4436('Language', '17', 17, '__Hindi', ''), 
     4437('Language', '18', 18, '__Hungarian', ''), 
     4438('Language', '19', 19, '__Icelandic', ''), 
     4439('Language', '20', 20, '__Indian', ''), 
     4440('Language', '21', 21, '__Indonesian', ''), 
     4441('Language', '22', 22, '__Italian', ''), 
     4442('Language', '23', 23, '__Japanese', ''), 
     4443('Language', '24', 24, '__Korean', ''), 
     4444('Language', '25', 25, '__Latvian', ''), 
     4445('Language', '26', 26, '__Lithuanian', ''), 
     4446('Language', '27', 27, '__Malay', ''), 
     4447('Language', '28', 28, '__Mandarin', ''), 
     4448('Language', '29', 29, '__Marathi', ''), 
     4449('Language', '30', 30, '__Moldovian', ''), 
     4450('Language', '31', 31, '__Nepalese', ''), 
     4451('Language', '32', 32, '__Norwegian', ''), 
     4452('Language', '33', 33, '__Persian', ''), 
     4453('Language', '34', 34, '__Polish', ''), 
     4454('Language', '35', 35, '__Portuguese', ''), 
     4455('Language', '36', 36, '__Punjabi', ''), 
     4456('Language', '37', 37, '__Romanian', ''), 
     4457('Language', '38', 38, '__Russian', ''), 
     4458('Language', '39', 39, '__Serbian', ''), 
     4459('Language', '40', 40, '__Spanish', ''), 
     4460('Language', '41', 41, '__Swedish', ''), 
     4461('Language', '42', 42, '__Tagalog', ''), 
     4462('Language', '43', 43, '__Taiwanese', ''), 
     4463('Language', '44', 44, '__Tamil', ''), 
     4464('Language', '45', 45, '__Telugu', ''), 
     4465('Language', '46', 46, '__Thai', ''), 
     4466('Language', '47', 47, '__Tongan', ''), 
     4467('Language', '48', 48, '__Turkish', ''), 
     4468('Language', '49', 49, '__Ukrainian', ''), 
     4469('Language', '50', 50, '__Urdu', ''), 
     4470('Language', '51', 51, '__Vietnamese', ''), 
     4471('Language', '52', 52, '__Visayan', ''); 
     4472 
     4473INSERT INTO `sys_form_pre_values`(`Key`, `Value`, `Order`, `LKey`, `LKey2`) VALUES  
     4474('Education', '1', 1, '__High School graduate', ''), 
     4475('Education', '2', 2, '__Some college', ''), 
     4476('Education', '3', 3, '__College student', ''), 
     4477('Education', '4', 4, '__AA (2 years college)', ''), 
     4478('Education', '5', 5, '__BA/BS (4 years college)', ''), 
     4479('Education', '6', 6, '__Some grad school', ''), 
     4480('Education', '7', 7, '__Grad school student', ''), 
     4481('Education', '8', 8, '__MA/MS/MBA', ''), 
     4482('Education', '9', 9, '__PhD/Post doctorate', ''), 
     4483('Education', '10', 10, '__JD', ''); 
     4484 
     4485INSERT INTO `sys_form_pre_values`(`Key`, `Value`, `Order`, `LKey`, `LKey2`) VALUES  
     4486('Income', '1', 1, '__$10,000/year and less', ''), 
     4487('Income', '2', 2, '__$10,000-$30,000/year', ''), 
     4488('Income', '3', 3, '__$30,000-$50,000/year', ''), 
     4489('Income', '4', 4, '__$50,000-$70,000/year', ''), 
     4490('Income', '5', 5, '__$70,000/year and more', ''); 
     4491 
     4492INSERT INTO `sys_form_pre_values`(`Key`, `Value`, `Order`, `LKey`, `LKey2`) VALUES  
     4493('Smoker', '1', 1, '__No', ''), 
     4494('Smoker', '2', 2, '__Rarely', ''), 
     4495('Smoker', '3', 3, '__Often', ''), 
     4496('Smoker', '4', 4, '__Very often', ''); 
     4497 
     4498INSERT INTO `sys_form_pre_values`(`Key`, `Value`, `Order`, `LKey`, `LKey2`) VALUES  
     4499('Drinker', '1', 1, '__No', ''), 
     4500('Drinker', '2', 2, '__Rarely', ''), 
     4501('Drinker', '3', 3, '__Often', ''), 
     4502('Drinker', '4', 4, '__Very often', ''); 
     4503 
     4504-- -------------------------------------------------------- 
    44574505 
    44584506CREATE TABLE IF NOT EXISTS `sys_objects_menu` ( 
    … …  
    45724620('sys_studio_forms', 'Sql', 'SELECT * FROM `sys_objects_form` WHERE 1 ', 'sys_objects_form', 'id', '', 'active', '', 100, NULL, 'start', '', 'title,module', 'auto', '', 'BxTemplStudioFormsForms', ''), 
    45734621('sys_studio_forms_displays', 'Sql', 'SELECT `td`.`id` AS `id`, `td`.`object` AS `object`, `td`.`display_name` AS `display_name`, `td`.`title` AS `title`, `td`.`module` AS `module`, `tf`.`title` AS `form_title` FROM `sys_form_displays` AS `td` LEFT JOIN `sys_objects_form` AS `tf` ON `td`.`object`=`tf`.`object` WHERE 1 ', 'sys_form_displays', 'id', '', '', '', 100, NULL, 'start', '', 'td`.`title,td`.`module', 'auto', '', 'BxTemplStudioFormsDisplays', ''), 
    4574 ('sys_studio_forms_fields', 'Sql', 'SELECT `tdi`.`id` AS `id`, `ti`.`caption` AS `title`, `ti`.`type` AS `type`, `ti`.`module` AS `module`, `tdi`.`active` AS `active`, `ti`.`editable` AS `editable`, `ti`.`deletable` AS `deletable`, `tdi`.`order` AS `order` FROM `sys_form_display_inputs` AS `tdi` LEFT JOIN `sys_form_inputs` AS `ti` ON `tdi`.`input_name`=`ti`.`name` AND `ti`.`object`=? WHERE 1 AND `tdi`.`display_name`=?', 'sys_form_display_inputs', 'id', 'order', 'active', '', 100, NULL, 'start', '', 'ti`.`type,ti`.`caption', 'auto', '', 'BxTemplStudioFormsFields', ''); 
    4575  
    4576  
     4622('sys_studio_forms_fields', 'Sql', 'SELECT `tdi`.`id` AS `id`, `ti`.`caption` AS `title`, `ti`.`type` AS `type`, `ti`.`module` AS `module`, `tdi`.`active` AS `active`, `ti`.`editable` AS `editable`, `ti`.`deletable` AS `deletable`, `tdi`.`order` AS `order` FROM `sys_form_display_inputs` AS `tdi` LEFT JOIN `sys_form_inputs` AS `ti` ON `tdi`.`input_name`=`ti`.`name` AND `ti`.`object`=? WHERE 1 AND `tdi`.`display_name`=?', 'sys_form_display_inputs', 'id', 'order', 'active', '', 100, NULL, 'start', '', 'ti`.`type,ti`.`caption', 'auto', '', 'BxTemplStudioFormsFields', ''), 
     4623('sys_studio_forms_pre_lists', 'Sql', 'SELECT * FROM `sys_form_pre_lists` WHERE 1 ', 'sys_form_pre_lists', 'id', '', '', '', 100, NULL, 'start', '', 'module,key,title', 'auto', '', 'BxTemplStudioFormsPreLists', ''), 
     4624('sys_studio_forms_pre_values', 'Sql', 'SELECT * FROM `sys_form_pre_values` WHERE 1 ', 'sys_form_pre_values', 'id', 'Order', '', '', 100, NULL, 'start', '', 'Key,Value,LKey,LKey2', 'auto', '', 'BxTemplStudioFormsPreValues', ''); 
    45774625 
    45784626CREATE TABLE IF NOT EXISTS `sys_grid_fields` ( 
    … …  
    46524700('sys_studio_forms_fields', 'type', '_adm_form_txt_fields_type', '15%', '13', '', 4), 
    46534701('sys_studio_forms_fields', 'module', '_adm_form_txt_fields_module', '15%', '13', '', 5), 
    4654 ('sys_studio_forms_fields', 'actions', '', '20%', '', '', 6); 
    4655  
     4702('sys_studio_forms_fields', 'actions', '', '20%', '', '', 6), 
     4703('sys_studio_forms_pre_lists', 'key', '_adm_form_txt_pre_lists_key', '20%', '23', '', 1), 
     4704('sys_studio_forms_pre_lists', 'title', '_adm_form_txt_pre_lists_title', '25%', '28', '', 2), 
     4705('sys_studio_forms_pre_lists', 'module', '_adm_form_txt_pre_lists_module', '13%', '11', '', 3), 
     4706('sys_studio_forms_pre_lists', 'values', '_adm_form_txt_pre_lists_values', '12%', '10', '', 3), 
     4707('sys_studio_forms_pre_lists', 'use_for_sets', '_adm_form_txt_pre_lists_use_for_sets', '10%', '8', '', 4), 
     4708('sys_studio_forms_pre_lists', 'actions', '', '20%', '', '', 5), 
     4709('sys_studio_forms_pre_values', 'order', '', '1%', '', '', 1), 
     4710('sys_studio_forms_pre_values', 'Value', '_adm_form_txt_pre_values_value', '20%', '18', '', 2), 
     4711('sys_studio_forms_pre_values', 'LKey', '_adm_form_txt_pre_values_lkey', '30%', '28', '', 3), 
     4712('sys_studio_forms_pre_values', 'LKey2', '_adm_form_txt_pre_values_lkey2', '30%', '28', '', 4), 
     4713('sys_studio_forms_pre_values', 'actions', '', '20%', '', '', 5); 
    46564714 
    46574715 
    … …  
    46984756('sys_studio_forms_fields', 'single', 'delete', '', 'cross.png', 1, 2), 
    46994757('sys_studio_forms_fields', 'independent', 'add', '_adm_form_btn_fields_create', '', 0, 1); 
     4758('sys_studio_forms_pre_lists', 'independent', 'add', '_adm_form_btn_pre_lists_create', '', 0, 1), 
     4759('sys_studio_forms_pre_lists', 'single', 'edit', '', 'document--pencil.png', 0, 1), 
     4760('sys_studio_forms_pre_lists', 'single', 'delete', '', 'cross.png', 1, 2), 
     4761('sys_studio_forms_pre_values', 'independent', 'add', '_adm_form_btn_values_create', '', 0, 1), 
     4762('sys_studio_forms_pre_values', 'single', 'edit', '', 'document--pencil.png', 0, 1), 
     4763('sys_studio_forms_pre_values', 'single', 'delete', '', 'cross.png', 1, 2); 
     4764 
     4765 
    47004766-- -------------------------------------------------------- 
    47014767 

  • trunk/modules/boonex/english/install/data/langs/en.xml

    r15870 r15888  
    22282228    <string name="_adm_nav_txt_items_hide_from_popup"><![CDATA[Hide From]]></string> 
    22292229    <string name="_adm_nav_err_items_hide_from"><![CDATA[Cannot update item]]></string> 
    2230  
    22312230    <string name="_adm_lmi_cpt_forms"><![CDATA[Forms]]></string> 
    22322231    <string name="_adm_lmi_cpt_displays"><![CDATA[Displays]]></string> 
    22332232    <string name="_adm_lmi_cpt_fields"><![CDATA[Fields]]></string> 
     2233    <string name="_adm_lmi_cpt_pre_lists"><![CDATA[Predefined Lists]]></string> 
     2234    <string name="_adm_lmi_cpt_pre_values"><![CDATA[Predefined Items]]></string> 
    22342235    <string name="_adm_form_txt_all_modules"><![CDATA[All Modules]]></string> 
    22352236    <string name="_adm_form_txt_all_forms"><![CDATA[All Forms]]></string> 
    22362237    <string name="_adm_form_txt_select_display"><![CDATA[Select Display]]></string> 
     2238    <string name="_adm_form_txt_select_list"><![CDATA[Select List]]></string> 
    22372239    <string name="_adm_form_err_cannot_process_action"><![CDATA[Cannot process action. It does not have an associated handler.]]></string> 
    22382240    <string name="_adm_form_txt_forms_title"><![CDATA[Title]]></string> 
    … …  
    23162318    <string name="_adm_form_txt_field_type_value"><![CDATA[value]]></string> 
    23172319    <string name="_adm_form_txt_field_type_captcha"><![CDATA[captcha]]></string> 
    2318     <string name=""><![CDATA[]]></string> 
    2319     <string name=""><![CDATA[]]></string> 
    2320     <string name=""><![CDATA[]]></string> 
    23212320    <string name="_adm_form_txt_field_type_display"><![CDATA[Type]]></string> 
    23222321    <string name="_adm_form_txt_field_name"><![CDATA[Name]]></string> 
    … …  
    23692368    <string name="_adm_form_txt_field_checker_params_preg"><![CDATA[Expression]]></string> 
    23702369    <string name="_adm_form_err_field_checker_params_preg"><![CDATA[Enter valid regular expression]]></string> 
     2370     
     2371    <string name="_adm_form_txt_pre_lists_no"><![CDATA[No]]></string> 
     2372    <string name="_adm_form_txt_pre_lists_yes"><![CDATA[Yes]]></string> 
     2373    <string name="_adm_form_txt_pre_lists_key"><![CDATA[Key]]></string> 
     2374    <string name="_adm_form_txt_pre_lists_title"><![CDATA[Title]]></string> 
     2375    <string name="_adm_form_txt_pre_lists_module"><![CDATA[Module]]></string> 
     2376    <string name="_adm_form_txt_pre_lists_values"><![CDATA[Values]]></string> 
     2377    <string name="_adm_form_txt_pre_lists_n_values"><![CDATA[{0} values]]></string> 
     2378    <string name="_adm_form_txt_pre_lists_manage_values"><![CDATA[Manage values]]></string> 
     2379    <string name="_adm_form_txt_pre_lists_use_for_sets"><![CDATA[Use For Sets]]></string> 
     2380    <string name="_adm_form_btn_pre_lists_create"><![CDATA[Add New List]]></string> 
     2381    <string name="_adm_form_txt_pre_lists_country"><![CDATA[Country]]></string> 
     2382    <string name="_adm_form_txt_pre_lists_sex"><![CDATA[Sex]]></string> 
     2383    <string name="_adm_form_txt_pre_lists_height"><![CDATA[Height]]></string> 
     2384    <string name="_adm_form_txt_pre_lists_body_type"><![CDATA[Body Type]]></string> 
     2385    <string name="_adm_form_txt_pre_lists_religion"><![CDATA[Religion]]></string> 
     2386    <string name="_adm_form_txt_pre_lists_ethnicity"><![CDATA[Ethnicity]]></string> 
     2387    <string name="_adm_form_txt_pre_lists_marital_status"><![CDATA[Marital Status]]></string> 
     2388    <string name="_adm_form_txt_pre_lists_language"><![CDATA[Language]]></string> 
     2389    <string name="_adm_form_txt_pre_lists_education"><![CDATA[Education]]></string> 
     2390    <string name="_adm_form_txt_pre_lists_income"><![CDATA[Income]]></string> 
     2391    <string name="_adm_form_txt_pre_lists_smoker"><![CDATA[Smoker]]></string> 
     2392    <string name="_adm_form_txt_pre_lists_drinker"><![CDATA[Drinker]]></string> 
     2393    <string name="_adm_form_txt_pre_lists_create_popup"><![CDATA[Add New List]]></string> 
     2394    <string name="_adm_form_err_pre_lists_create"><![CDATA[Cannot add list]]></string> 
     2395    <string name="_adm_from_err_pre_lists_delete"><![CDATA[Cannot delete list]]></string> 
     2396    <string name="_adm_form_txt_pre_lists_create_popup"><![CDATA[Edit "{0}" List]]></string> 
     2397    <string name="_adm_form_err_pre_lists_edit"><![CDATA[Cannot update list]]></string> 
     2398    <string name="_adm_form_txt_pre_lists_key"><![CDATA[Key]]></string> 
     2399    <string name="_adm_form_dsc_pre_lists_key"><![CDATA[You need to enter field key]]></string> 
     2400    <string name="_adm_form_err_pre_lists_key"><![CDATA[Use alphanumeric characters, '-' and '_' symbols]]></string> 
     2401    <string name="_adm_form_txt_pre_lists_title"><![CDATA[Title]]></string> 
     2402    <string name="_adm_form_dsc_pre_lists_title"><![CDATA[You need to enter field title]]></string> 
     2403    <string name="_adm_form_err_pre_lists_title"><![CDATA[Enter title, more then 3 characters]]></string> 
     2404    <string name="_adm_form_btn_pre_lists_add"><![CDATA[Add]]></string> 
     2405    <string name="_adm_form_btn_pre_lists_save"><![CDATA[Save]]></string> 
     2406    <string name="_adm_form_btn_pre_lists_cancel"><![CDATA[Cancel]]></string> 
     2407    <string name="_adm_form_txt_pre_values_create_popup"><![CDATA[Add New Value]]></string> 
     2408    <string name="_adm_form_err_pre_values_create"><![CDATA[Cannot add value]]></string> 
     2409    <string name="_adm_form_txt_pre_values_edit_popup"><![CDATA[Edit "{0}" Value]]></string> 
     2410    <string name="_adm_form_err_pre_values_edit"><![CDATA[Cannot update value]]></string> 
     2411    <string name="_adm_form_err_pre_values_delete"><![CDATA[Cannot delete value]]></string> 
     2412    <string name="_adm_form_txt_pre_values_value"><![CDATA[Value]]></string> 
     2413    <string name="_adm_form_txt_pre_values_lkey"><![CDATA[Title]]></string> 
     2414    <string name="_adm_form_txt_pre_values_lkey2"><![CDATA[Additional Title]]></string> 
     2415    <string name="_adm_form_btn_pre_values_create"><![CDATA[Add New Value]]></string> 
     2416    <string name="_adm_form_txt_pre_values_value"><![CDATA[Value]]></string> 
     2417    <string name="_adm_form_dsc_pre_values_value"><![CDATA[You need to enter field value]]></string> 
     2418    <string name="_adm_form_err_pre_values_value"><![CDATA[Field value shouldn't be empty]]></string> 
     2419    <string name="_adm_form_txt_pre_values_lkey"><![CDATA[Title]]></string> 
     2420    <string name="_adm_form_dsc_pre_values_lkey"><![CDATA[You need to enter field title]]></string> 
     2421    <string name="_adm_form_err_pre_values_lkey"><![CDATA[Enter title, more then 3 characters]]></string> 
     2422    <string name="_adm_form_txt_pre_values_lkey2"><![CDATA[Additional Title]]></string> 
     2423    <string name="_adm_form_dsc_pre_values_lkey2"><![CDATA[You need to enter field additional title]]></string> 
     2424    <string name="_adm_form_err_pre_values_lkey2"><![CDATA[Enter additional title, more then 3 characters]]></string> 
     2425    <string name="_adm_form_btn_pre_values_add"><![CDATA[Add]]></string> 
     2426    <string name="_adm_form_btn_pre_values_save"><![CDATA[Save]]></string> 
     2427    <string name="_adm_form_btn_pre_values_cancel"><![CDATA[Cancel]]></string> 
    23712428    <string name=""><![CDATA[]]></string> 
    23722429    <string name=""><![CDATA[]]></string> 
    23732430    <string name=""><![CDATA[]]></string> 
    23742431    <string name=""><![CDATA[]]></string> 
    2375          
     2432    <string name=""><![CDATA[]]></string> 
     2433    <string name=""><![CDATA[]]></string> 
     2434     
    23762435 
    23772436    <string name="_adm_page_cpt_builder_mobile"><![CDATA[Mobile Builder]]></string> 

  • trunk/studio/classes/BxDolStudioForms.php

    r15857 r15888  
    1515define('BX_DOL_STUDIO_FORM_TYPE_DISPLAYS', 'displays'); 
    1616define('BX_DOL_STUDIO_FORM_TYPE_FIELDS', 'fields'); 
     17define('BX_DOL_STUDIO_FORM_TYPE_PRE_LISTS', 'pre_lists'); 
     18define('BX_DOL_STUDIO_FORM_TYPE_PRE_VALUES', 'pre_values'); 
    1719 
    1820define('BX_DOL_STUDIO_FORM_TYPE_DEFAULT', BX_DOL_STUDIO_FORM_TYPE_FORMS); 
    … …  
    5153        } 
    5254    } 
     55 
     56    protected function getSystemName($sValue) { 
     57        return str_replace(' ', '_', strtolower($sValue)); 
     58    } 
     59 
     60    protected function getClassName($sValue) { 
     61        return str_replace(' ', '', ucwords(str_replace('_', ' ', $sValue))); 
     62    } 
    5363} 
    5464/** @} */ 

  • trunk/studio/classes/BxDolStudioFormsQuery.php

    r15878 r15888  
    193193        return (int)$this->getOne($sSql); 
    194194    } 
     195 
     196    function getLists($aParams, &$aItems, $bReturnCount = true) { 
     197        $aMethod = array('name' => 'getAll', 'params' => array(0 => 'query')); 
     198        $sSelectClause = $sJoinClause = $sWhereClause = $sGroupClause = $sOrderClause = $sLimitClause = ""; 
     199 
     200        if(!isset($aParams['order']) || empty($aParams['order'])) 
     201           $sOrderClause = "ORDER BY `tl`.`key` ASC"; 
     202 
     203        switch($aParams['type']) { 
     204            case 'by_id': 
     205                $aMethod['name'] = 'getRow'; 
     206                $sWhereClause = $this->prepare(" AND `tl`.`id`=? ", $aParams['value']); 
     207                break; 
     208            case 'pairs_list_values': 
     209                $aMethod['name'] = 'getPairs'; 
     210                $aMethod['params'][1] = 'key'; 
     211                $aMethod['params'][2] = 'values'; 
     212                $sSelectClause = ",COUNT( `tv`.`id`) AS `values`"; 
     213                $sJoinClause = "LEFT JOIN `sys_form_pre_values` AS `tv` ON `tl`.`key`=`tv`.`Key`"; 
     214                $sGroupClause = "GROUP BY `tl`.`id`"; 
     215                break; 
     216            case 'all': 
     217                break; 
     218        } 
     219 
     220        $aMethod['params'][0] = "SELECT  
     221                `tl`.`id` AS `id`, 
     222                `tl`.`module` AS `module`, 
     223                `tl`.`key` AS `key`, 
     224                `tl`.`title` AS `title`, 
     225                `tl`.`use_for_sets` AS `use_for_sets`" . $sSelectClause . " 
     226            FROM `sys_form_pre_lists` AS `tl` " . $sJoinClause . " 
     227            WHERE 1 " . $sWhereClause . " " . $sGroupClause . " " . $sOrderClause . " " . $sLimitClause; 
     228        $aItems = call_user_func_array(array($this, $aMethod['name']), $aMethod['params']); 
     229 
     230        if(!$bReturnCount) 
     231            return count($aItems) > 0; 
     232 
     233        $sQuery = "SELECT  
     234                COUNT(*) 
     235            FROM `sys_form_pre_lists` AS `tl` " . $sJoinClause . " 
     236            WHERE 1 " . $sWhereClause . "  
     237            LIMIT 1"; 
     238        return (int)$this->getOne($sQuery); 
     239    } 
     240 
     241    function getValues($aParams, &$aItems, $bReturnCount = true) { 
     242        $aMethod = array('name' => 'getAll', 'params' => array(0 => 'query')); 
     243        $sSelectClause = $sJoinClause = $sWhereClause = $sGroupClause = $sOrderClause = $sLimitClause = ""; 
     244 
     245        if(!isset($aParams['order']) || empty($aParams['order'])) 
     246           $sOrderClause = "ORDER BY `tv`.`Order` ASC"; 
     247 
     248        switch($aParams['type']) { 
     249            case 'by_id': 
     250                $aMethod['name'] = 'getRow'; 
     251                $sWhereClause = $this->prepare(" AND `tv`.`id`=? ", $aParams['value']); 
     252                break; 
     253            case 'by_key': 
     254                $sWhereClause = $this->prepare(" AND `tv`.`Key`=? ", $aParams['value']); 
     255                break; 
     256            case 'all': 
     257                break; 
     258        } 
     259 
     260        $aMethod['params'][0] = "SELECT  
     261                `tv`.`id` AS `id`, 
     262                `tv`.`Key` AS `key`, 
     263                `tv`.`Value` AS `value`, 
     264                `tv`.`LKey` AS `lkey`, 
     265                `tv`.`LKey2` AS `lkey2`, 
     266                `tv`.`Order` AS `order`" . $sSelectClause . " 
     267            FROM `sys_form_pre_values` AS `tv` " . $sJoinClause . " 
     268            WHERE 1 " . $sWhereClause . " " . $sGroupClause . " " . $sOrderClause . " " . $sLimitClause; 
     269        $aItems = call_user_func_array(array($this, $aMethod['name']), $aMethod['params']); 
     270 
     271        if(!$bReturnCount) 
     272            return count($aItems) > 0; 
     273 
     274        $sQuery = "SELECT  
     275                COUNT(*) 
     276            FROM `sys_form_pre_values` AS `tv` " . $sJoinClause . " 
     277            WHERE 1 " . $sWhereClause . "  
     278            LIMIT 1"; 
     279        return (int)$this->getOne($sQuery); 
     280    } 
     281 
     282    function deleteValues($aParams) { 
     283        $sWhereClause = $sLimitClause = ""; 
     284 
     285        switch($aParams['type']) { 
     286            case 'by_key': 
     287                $sWhereClause = $this->prepare(" AND `tv`.`Key`=? ", $aParams['value']); 
     288                break; 
     289            case 'all': 
     290                break; 
     291        } 
     292 
     293        $sSql = "DELETE FROM `tv` USING `sys_form_pre_values` AS `tv` WHERE 1 " . $sWhereClause . " " . $sLimitClause; 
     294        return $this->query($sSql) !== false; 
     295    } 
     296 
     297    function getValuesOrderMax($sKey) { 
     298        $sSql = $this->prepare("SELECT MAX(`Order`) FROM `sys_form_pre_values` WHERE `Key`=? LIMIT 1", $sKey); 
     299        return (int)$this->getOne($sSql); 
     300    } 
    195301} 
    196302/** @} */ 

  • trunk/studio/templates/base/css/builder_forms.css

    r15857 r15888  
    1313} 
    1414div.bx-grid-header div#bx-form-element-module, 
    15 div.bx-grid-header div#bx-form-element-form { 
     15div.bx-grid-header div#bx-form-element-form, 
     16div.bx-grid-header div#bx-form-element-list { 
    1617    margin-right: 20px; 
    1718} 
    … …  
    3031    margin-right: 20px; 
    3132} 
     33 
     34/*--- Pre Lists page -> Add/Edit Form block ---*/ 
     35div.bx-form-add-list {} 
     36div.bx-form-add-list-cnt {} 
     37 
     38/*--- Pre Values page -> Add/Edit Form block ---*/ 
     39div.bx-form-add-value {} 
     40div.bx-form-add-value-cnt {} 

  • trunk/studio/templates/base/scripts/BxBaseStudioForms.php

    r15857 r15888  
    2929 
    3030        $aMenu = array(); 
    31         $aMenuItems = array(BX_DOL_STUDIO_FORM_TYPE_FORMS, BX_DOL_STUDIO_FORM_TYPE_DISPLAYS, BX_DOL_STUDIO_FORM_TYPE_FIELDS); 
     31        $aMenuItems = array( 
     32            BX_DOL_STUDIO_FORM_TYPE_FORMS,  
     33            BX_DOL_STUDIO_FORM_TYPE_DISPLAYS,  
     34            BX_DOL_STUDIO_FORM_TYPE_FIELDS, 
     35            BX_DOL_STUDIO_FORM_TYPE_PRE_LISTS, 
     36            BX_DOL_STUDIO_FORM_TYPE_PRE_VALUES 
     37        ); 
    3238        foreach($aMenuItems as $sMenuItem) 
    3339            $aMenu[] = array( 
    … …  
    5359    } 
    5460    function getPageCode() { 
    55         $sMethod = 'get' . ucfirst($this->sPage); 
     61        $sMethod = 'get' .  $this->getClassName($this->sPage); 
    5662        if(!method_exists($this, $sMethod)) 
    5763            return ''; 
    … …  
    7076    protected function getFields() { 
    7177        return $this->getGrid('sys_studio_forms_fields'); 
     78    } 
     79 
     80    protected function getPreLists() { 
     81        return $this->getGrid('sys_studio_forms_pre_lists'); 
     82    } 
     83 
     84    protected function getPreValues() { 
     85        return $this->getGrid('sys_studio_forms_pre_values'); 
    7286    } 
    7387 
Note: See TracChangeset for help on using the changeset viewer.
 
 

Site Search

Market

Notes

Websites

About BoonEx• Contacts• © BoonEx (ACN 127966581)