Use following code if you want clean insert into the database.
NOTE: change "pre_" into whatever you set up for the prefix during installation.- SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
- /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
- /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
- /*!40101 SET NAMES utf8 */;
- -- --------------------------------------------------------
- --
- -- Table structure for table `pre_common_member_profile_setting`
- --
- DROP TABLE IF EXISTS `pre_common_member_profile_setting`;
- CREATE TABLE IF NOT EXISTS `pre_common_member_profile_setting` (
- `fieldid` varchar(255) NOT NULL default '',
- `available` tinyint(1) NOT NULL default '0',
- `invisible` tinyint(1) NOT NULL default '0',
- `needverify` tinyint(1) NOT NULL default '0',
- `title` varchar(255) NOT NULL default '',
- `description` varchar(255) NOT NULL default '',
- `displayorder` smallint(6) unsigned NOT NULL default '0',
- `required` tinyint(1) NOT NULL default '0',
- `unchangeable` tinyint(1) NOT NULL default '0',
- `showincard` tinyint(1) NOT NULL default '0',
- `showinthread` tinyint(1) NOT NULL default '0',
- `showinregister` tinyint(1) NOT NULL default '0',
- `allowsearch` tinyint(1) NOT NULL default '0',
- `formtype` varchar(255) NOT NULL,
- `size` smallint(6) unsigned NOT NULL default '0',
- `choices` text NOT NULL,
- `validate` text NOT NULL,
- PRIMARY KEY (`fieldid`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
- --
- -- Dumping data for table `pre_common_member_profile_setting`
- --
- INSERT INTO `pre_common_member_profile_setting` (`fieldid`, `available`, `invisible`, `needverify`, `title`, `description`, `displayorder`, `required`, `unchangeable`, `showincard`, `showinthread`, `showinregister`, `allowsearch`, `formtype`, `size`, `choices`, `validate`) VALUES
- ('realname', 1, 0, 0, 'Real Name', '', 0, 0, 0, 0, 0, 0, 1, 'text', 0, '', ''),
- ('gender', 1, 0, 0, 'Gender', '', 0, 0, 0, 0, 0, 0, 1, 'select', 0, '', ''),
- ('birthyear', 1, 0, 0, 'Birth Year', '', 0, 0, 0, 0, 0, 0, 1, 'select', 0, '', ''),
- ('birthmonth', 1, 0, 0, 'Birth Month', '', 0, 0, 0, 0, 0, 0, 0, 'select', 0, '', ''),
- ('birthday', 1, 0, 0, 'Birthday', '', 0, 0, 0, 0, 0, 0, 0, 'select', 0, '', ''),
- ('constellation', 1, 1, 0, 'Horoscope', '(auto)', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', ''),
- ('zodiac', 1, 1, 0, 'Zodiac', '(auto)', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', ''),
- ('telephone', 1, 1, 0, 'Telephone', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', ''),
- ('mobile', 1, 1, 0, 'Cellphone', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', ''),
- ('idcardtype', 1, 1, 0, 'ID Type', 'ID Card, Passport, Driver License, etc', 0, 0, 0, 0, 0, 0, 0, 'select', 0, 'ID Card\nPassport\nDriver License', ''),
- ('idcard', 1, 1, 0, 'ID #', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', ''),
- ('address', 1, 1, 0, 'Address', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', ''),
- ('zipcode', 1, 1, 0, 'Zip Code', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', ''),
- ('nationality', 0, 0, 0, 'Natinality', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', ''),
- ('birthprovince', 1, 0, 0, 'Birth Place', '', 0, 0, 0, 0, 0, 0, 0, 'select', 0, '', ''),
- ('birthcity', 1, 0, 0, 'Birth City', '', 0, 0, 0, 0, 0, 0, 0, 'select', 0, '', ''),
- ('birthdist', 1, 0, 0, 'Birth District', 'Birth District', 0, 0, 0, 0, 0, 0, 0, 'select', 0, '', ''),
- ('birthcommunity', 1, 0, 0, 'Birth Town', '', 0, 0, 0, 0, 0, 0, 0, 'select', 0, '', ''),
- ('resideprovince', 1, 0, 0, 'State', '', 0, 0, 0, 0, 0, 0, 0, 'select', 0, '', ''),
- ('residecity', 1, 0, 0, 'City', '', 0, 0, 0, 0, 0, 0, 0, 'select', 0, '', ''),
- ('residedist', 1, 0, 0, 'District', 'Birth District', 0, 0, 0, 0, 0, 0, 0, 'select', 0, '', ''),
- ('residecommunity', 1, 0, 0, 'Town', '', 0, 0, 0, 0, 0, 0, 0, 'select', 0, '', ''),
- ('residesuite', 0, 0, 0, 'Suite', 'Room Number', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', ''),
- ('graduateschool', 1, 0, 0, 'Graduate School', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', ''),
- ('education', 1, 0, 0, 'Education', '', 0, 0, 0, 0, 0, 0, 0, 'select', 0, 'Doctor\nMaster\nBachelor\nSpecialist\nMiddle Shcool\nPrimary School\nOther', ''),
- ('company', 1, 0, 0, 'Company', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', ''),
- ('occupation', 1, 0, 0, 'Occupation', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', ''),
- ('position', 1, 0, 0, 'Position', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', ''),
- ('revenue', 1, 1, 0, 'Salary', 'Dollar', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', ''),
- ('affectivestatus', 1, 1, 0, 'Status', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', ''),
- ('lookingfor', 1, 0, 0, 'Looking for', 'Hope to find what kind of friends', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', ''),
- ('bloodtype', 1, 1, 0, 'Blood Type', '', 0, 0, 0, 0, 0, 0, 0, 'select', 0, 'A\nB\nAB\nO\nOther', ''),
- ('height', 0, 1, 0, 'Height', 'Unit Feet', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', ''),
- ('weight', 0, 1, 0, 'Weight', 'Unit Pound', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', ''),
- ('alipay', 1, 1, 0, 'Alipay', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', ''),
- ('icq', 0, 1, 0, 'ICQ', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', ''),
- ('qq', 1, 1, 0, 'QQ', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', ''),
- ('yahoo', 0, 1, 0, 'YAHOO', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', ''),
- ('msn', 1, 1, 0, 'MSN', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', ''),
- ('taobao', 1, 1, 0, 'TaoBao', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', ''),
- ('site', 1, 0, 0, 'Personal Site', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', ''),
- ('bio', 1, 1, 0, 'Introduce', '', 0, 0, 0, 0, 0, 0, 0, 'textarea', 0, '', ''),
- ('interest', 1, 0, 0, 'Hobbies', '', 0, 0, 0, 0, 0, 0, 0, 'textarea', 0, '', ''),
- ('field1', 0, 1, 0, 'Custom 1', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', ''),
- ('field2', 0, 1, 0, 'Custom 2', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', ''),
- ('field3', 0, 1, 0, 'Custom 3', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', ''),
- ('field4', 0, 1, 0, 'Custom 4', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', ''),
- ('field5', 0, 1, 0, 'Custom 5', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', ''),
- ('field6', 0, 1, 0, 'Custom 6', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', ''),
- ('field7', 0, 1, 0, 'Custom 7', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', ''),
- ('field8', 0, 1, 0, 'Custom 8', '', 0, 0, 0, 0, 0, 0, 0, 'text', 0, '', '');
复制代码 |