/source/sql/cms20110905.sql
SQL | 758 lines | 543 code | 90 blank | 125 comment | 0 complexity | 6b7976222786e729cbbbefeeb8a6e62b MD5 | raw file
1-- phpMyAdmin SQL Dump 2-- version 3.4.3.1 3-- http://www.phpmyadmin.net 4-- 5-- ??: localhost 6-- ????: 2011 ? 09 ? 05 ? 03:55 7-- ?????: 5.0.51 8-- PHP ??: 5.2.6 9 10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; 11SET time_zone = "+00:00"; 12 13 14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; 15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; 16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; 17/*!40101 SET NAMES utf8 */; 18 19-- 20-- ???: `cms` 21-- 22 23-- -------------------------------------------------------- 24 25-- 26-- ???? `se_area` 27-- 28 29DROP TABLE IF EXISTS `se_area`; 30CREATE TABLE IF NOT EXISTS `se_area` ( 31 `id` int(8) NOT NULL auto_increment, 32 `bdtid` smallint(5) NOT NULL, 33 `bdid` int(5) NOT NULL COMMENT 'class_id', 34 `lg` varchar(10) NOT NULL, 35 `del` tinyint(1) NOT NULL, 36 `tid` int(8) NOT NULL COMMENT 'trees_id', 37 `gid` varchar(20) NOT NULL, 38 `at` varchar(20) NOT NULL COMMENT 'add_time', 39 `title` varchar(50) NOT NULL COMMENT '??', 40 `display` int(5) NOT NULL COMMENT '??', 41 `parentid` int(5) NOT NULL COMMENT '??', 42 PRIMARY KEY (`id`) 43) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; 44 45-- -------------------------------------------------------- 46 47-- 48-- ???? `se_ask` 49-- 50 51DROP TABLE IF EXISTS `se_ask`; 52CREATE TABLE IF NOT EXISTS `se_ask` ( 53 `id` int(8) NOT NULL auto_increment, 54 `bdtid` smallint(5) NOT NULL, 55 `bdid` int(5) NOT NULL COMMENT 'class_id', 56 `lg` varchar(10) NOT NULL, 57 `del` tinyint(1) NOT NULL, 58 `tid` int(8) NOT NULL COMMENT 'trees_id', 59 `gid` varchar(20) NOT NULL, 60 `at` varchar(20) NOT NULL COMMENT 'add_time', 61 `title` varchar(100) NOT NULL COMMENT '??', 62 `content` text NOT NULL COMMENT '????', 63 `reply` text NOT NULL COMMENT '??', 64 `contact` varchar(100) NOT NULL COMMENT '????', 65 `addtime` varchar(50) NOT NULL COMMENT '????', 66 `commend` int(5) NOT NULL COMMENT '??', 67 PRIMARY KEY (`id`) 68) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; 69 70-- -------------------------------------------------------- 71 72-- 73-- ???? `se_base` 74-- 75 76DROP TABLE IF EXISTS `se_base`; 77CREATE TABLE IF NOT EXISTS `se_base` ( 78 `id` int(8) NOT NULL auto_increment, 79 `bdtid` smallint(5) NOT NULL, 80 `bdid` int(5) NOT NULL COMMENT 'class_id', 81 `lg` varchar(10) NOT NULL, 82 `del` tinyint(1) NOT NULL, 83 `tid` int(8) NOT NULL COMMENT 'trees_id', 84 `gid` varchar(20) NOT NULL, 85 `at` varchar(20) NOT NULL COMMENT 'add_time', 86 `title` varchar(100) NOT NULL COMMENT '??', 87 `content` text NOT NULL COMMENT '??', 88 `pic1` varchar(50) NOT NULL COMMENT '??', 89 `pic2` varchar(50) NOT NULL COMMENT '??', 90 `commend` int(5) NOT NULL COMMENT '??', 91 PRIMARY KEY (`id`) 92) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; 93 94-- -------------------------------------------------------- 95 96-- 97-- ???? `se_cross` 98-- 99 100DROP TABLE IF EXISTS `se_cross`; 101CREATE TABLE IF NOT EXISTS `se_cross` ( 102 `id` int(8) NOT NULL auto_increment, 103 `bdtid` smallint(5) NOT NULL, 104 `bdid` int(5) NOT NULL COMMENT 'class_id', 105 `lg` varchar(10) NOT NULL, 106 `del` tinyint(1) NOT NULL, 107 `tid` int(8) NOT NULL COMMENT 'trees_id', 108 `gid` varchar(20) NOT NULL, 109 `at` varchar(20) NOT NULL COMMENT 'add_time', 110 `title` varchar(100) NOT NULL COMMENT '??', 111 `content` text NOT NULL COMMENT '??', 112 `pic1` varchar(50) NOT NULL COMMENT '??', 113 `link` text NOT NULL COMMENT '??', 114 `commend` int(5) NOT NULL COMMENT '??', 115 PRIMARY KEY (`id`) 116) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ; 117 118-- 119-- ??????? `se_cross` 120-- 121 122INSERT INTO `se_cross` (`id`, `bdtid`, `bdid`, `lg`, `del`, `tid`, `gid`, `at`, `title`, `content`, `pic1`, `link`, `commend`) VALUES 123(1, 0, 0, 'zh', 1, 75, '131233768191.02', '1312337686', '', '', '', '', 0), 124(2, 0, 0, 'zh', 1, 75, '131233793981.35', '1312337945', '', '', '', '', 0), 125(3, 0, 0, 'zh', 1, 75, '131233820153.42', '1312338206', '', '', '', '', 0), 126(4, 0, 0, 'zh', 1, 75, '131233837919.53', '1312338384', '', '', '', '', 0), 127(5, 0, 0, 'zh', 1, 75, '131233845192.58', '1312338457', '', '', '', '', 0), 128(6, 0, 0, 'zh', 1, 75, '131233864535.45', '1312338649', '', '', '', '', 0), 129(7, 0, 0, 'zh', 1, 75, '131233910039.75', '1312339107', '', '', '', '', 0), 130(8, 0, 0, 'zh', 0, 75, '131519151516.41', '1315191515', '', '1', '', '1', 661), 131(9, 0, 0, 'zh', 0, 75, '131519184510.55', '1315193433', '', '1314847738', '', 'b', 3), 132(10, 0, 0, 'zh', 0, 75, '131519193878.13', '1315191938', '', 'a', '', 'd', 1); 133 134-- -------------------------------------------------------- 135 136-- 137-- ???? `se_datamod` 138-- 139 140DROP TABLE IF EXISTS `se_datamod`; 141CREATE TABLE IF NOT EXISTS `se_datamod` ( 142 `id` tinyint(5) NOT NULL auto_increment COMMENT 'id', 143 `id_mirror` tinyint(5) NOT NULL, 144 `tabname` varchar(20) NOT NULL, 145 `name` varchar(30) NOT NULL, 146 `declare` varchar(100) NOT NULL, 147 `extend_id` tinyint(5) NOT NULL default '0', 148 `extend_name` varchar(10) NOT NULL, 149 `extend_type` int(1) NOT NULL, 150 `leaf` tinyint(1) NOT NULL default '0', 151 `created` tinyint(1) NOT NULL, 152 `del` tinyint(1) NOT NULL, 153 PRIMARY KEY (`id`) 154) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ; 155 156-- 157-- ??????? `se_datamod` 158-- 159 160INSERT INTO `se_datamod` (`id`, `id_mirror`, `tabname`, `name`, `declare`, `extend_id`, `extend_name`, `extend_type`, `leaf`, `created`, `del`) VALUES 161(6, 0, 'user', '???', '????', 0, '???', 0, 0, 1, 0), 162(7, 0, 'rtp', '????', '????', 0, '???', 0, 0, 1, 0), 163(8, 0, 'base', '??', '', 0, '???', 0, 0, 1, 0), 164(9, 0, 'pic', '??', '', 8, '???', 0, 0, 1, 0), 165(19, 0, 'news', '??', '', 8, '??', 0, 0, 1, 0), 166(11, 0, 'ask', '??', '', 0, '???', 0, 0, 1, 0), 167(17, 0, 'info', '????', '', 0, '???', 0, 0, 1, 0), 168(14, 0, 'room', '??', '', 8, '???', 0, 0, 1, 0), 169(20, 0, 'area', '??', '', 0, '???', 0, 0, 1, 0), 170(15, 0, 'cross', '??', '', 8, '???', 0, 0, 1, 0), 171(16, 0, 'seo', 'SEO', '', 0, '???', 0, 0, 1, 0), 172(21, 0, 'log', '??????', '', 0, '???', 0, 0, 1, 0); 173 174-- -------------------------------------------------------- 175 176-- 177-- ???? `se_father` 178-- 179 180DROP TABLE IF EXISTS `se_father`; 181CREATE TABLE IF NOT EXISTS `se_father` ( 182 `id` int(8) NOT NULL auto_increment, 183 `bdtid` smallint(5) NOT NULL, 184 `bdid` int(5) NOT NULL COMMENT 'class_id', 185 `lg` varchar(10) NOT NULL, 186 `del` tinyint(1) NOT NULL, 187 `tid` int(8) NOT NULL COMMENT 'trees_id', 188 `gid` varchar(20) NOT NULL, 189 `at` varchar(20) NOT NULL COMMENT 'add_time', 190 PRIMARY KEY (`id`) 191) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; 192 193-- -------------------------------------------------------- 194 195-- 196-- ???? `se_fld` 197-- 198 199DROP TABLE IF EXISTS `se_fld`; 200CREATE TABLE IF NOT EXISTS `se_fld` ( 201 `id` smallint(10) NOT NULL auto_increment COMMENT 'id', 202 `tid` smallint(5) NOT NULL, 203 `fname` varchar(20) NOT NULL, 204 `name` varchar(20) NOT NULL, 205 `type` varchar(20) NOT NULL, 206 `cfg` text NOT NULL, 207 `str` text NOT NULL, 208 `wd` int(10) NOT NULL, 209 `isfld` tinyint(1) NOT NULL, 210 `xr` tinyint(1) NOT NULL default '0', 211 `px` int(3) NOT NULL default '0', 212 `width` varchar(3) NOT NULL, 213 `ts` varchar(100) NOT NULL, 214 `yxwk` int(1) NOT NULL default '1', 215 `bt` varchar(1) NOT NULL default '0', 216 `gj` varchar(1) NOT NULL default '0', 217 `zy` varchar(1) NOT NULL default '1', 218 `zyz` text NOT NULL, 219 `qzfs` varchar(10) NOT NULL default '1', 220 `blm` varchar(40) NOT NULL, 221 `x` int(2) NOT NULL default '0', 222 `y` int(2) NOT NULL default '0', 223 `z` int(2) NOT NULL default '0', 224 `lg` varchar(5) NOT NULL default 'zh', 225 `del` tinyint(1) NOT NULL, 226 `isnew` tinyint(1) NOT NULL, 227 PRIMARY KEY (`id`) 228) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1453 ; 229 230-- 231-- ??????? `se_fld` 232-- 233 234INSERT INTO `se_fld` (`id`, `tid`, `fname`, `name`, `type`, `cfg`, `str`, `wd`, `isfld`, `xr`, `px`, `width`, `ts`, `yxwk`, `bt`, `gj`, `zy`, `zyz`, `qzfs`, `blm`, `x`, `y`, `z`, `lg`, `del`, `isnew`) VALUES 235(174, 63, 'user', '???', 'textfield', '{"STR":""}', '', 72, 0, 0, 0, '120', '???????!', 0, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0), 236(175, 63, 'psw', '??', 'password', '{"STR":""}', '', 230, 0, 1, 7, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0), 237(176, 63, 'name', '????', 'textfield', '{"STR":""}', '', 103, 0, 0, 8, '100', '????????!', 1, '0', '1', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0), 238(181, 63, 'tel', '??', 'textfield', '', '', 139, 0, 0, 11, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0), 239(182, 63, 'email', '??', 'textfield', '', '', 146, 0, 0, 10, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0), 240(1362, 63, 'ct', '????', 'textarea', '{"STR":""}', '', 229, 0, 0, 9, '300', '????!', 1, '0', '0', '0', '', '1', '', 0, 0, 0, 'zh', 0, 0), 241(219, 64, 'tt', '????', 'textfield', '', '', 173, 0, 0, 0, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0), 242(220, 64, 'ct', '????', 'htmleditor', '{"height":"200","STR":""}', '', 431, 0, 0, 1, '700', '', 1, '0', '0', '0', '', '1', '', 0, 0, 0, 'zh', 0, 0), 243(221, 64, 'cfg', '????', 'textfield', '', '', 0, 0, 1, 2, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0), 244(1383, 63, 'gongs', '???', 'textfield', '', '', 0, 0, 0, 1, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0), 245(1384, 63, 'zhiw', '??', 'textfield', '', '', 0, 0, 0, 2, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0), 246(1385, 63, 'gsjs', '????', 'textfield', '', '', 0, 0, 0, 3, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0), 247(1386, 63, 'usertype', '????', 'textfield', '', '', 0, 0, 0, 4, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0), 248(1387, 63, 'rcfg', '????', 'combo', '{"STR":""}', '', 0, 0, 0, 5, '120', '????????!', 1, '0', '0', '1', '[{"xv":"\\u7ba1\\u7406\\u5458","yv":"3","ck":"0"}]', '1', '', 0, 0, 0, 'zh', 0, 0), 249(1388, 63, 'hexid', '?ID', 'textfield', '', '', 0, 0, 0, 6, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0), 250(1389, 63, 'tt', '????', 'textfield', '', '', 173, 0, 0, 0, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0), 251(1390, 63, 'sex', '??', 'textfield', '', '', 0, 0, 0, 0, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0), 252(1391, 63, 'sheng', '?', 'textfield', '', '', 0, 0, 0, 0, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0), 253(1392, 63, 'shi', '?', 'textfield', '', '', 0, 0, 0, 0, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0), 254(1393, 63, 'xian', '?', 'textfield', '', '', 0, 0, 0, 0, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0), 255(1394, 63, 'homepage', '', 'textfield', '', '', 0, 0, 0, 0, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0), 256(1395, 63, 'mobile', '', 'textfield', '', '', 0, 0, 0, 0, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0), 257(1396, 63, 'instro', '??', 'textfield', '', '', 0, 0, 0, 0, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0), 258(1451, 75, 'commend', '??', 'recommend', '{"px":"1","STR":"","paixu":"flag_red.png","tjpx":null}', '', 0, 0, 0, 4, '', '', 0, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0), 259(1452, 75, 'link', '??', 'textfield', '', '', 0, 0, 0, 3, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0), 260(1405, 79, 'title', '??', 'textfield', '', '', 0, 0, 0, 0, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 1, 0), 261(1450, 75, 'pic1', '???', 'textfield', '', '', 0, 0, 0, 1, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 1, 0), 262(1449, 75, 'content', '?????', 'my97', '{"zqgs":"yyyy-MM-dd HH:mm:ss","STR":"","pbxq":["","","","","","",""]}', '', 0, 0, 0, 2, '200', '?????????!', 1, '0', '0', '0', '', '1', '', 0, 0, 0, 'zh', 0, 0), 263(1448, 75, 'title', '??', 'textfield', '', '', 0, 0, 0, 0, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 1, 0), 264(1406, 79, 'content', '?????', 'textfield', '', '', 0, 0, 0, 6, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0), 265(1407, 79, 'pic1', '???', 'textfield', '', '', 0, 0, 0, 1, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 1, 0), 266(1408, 79, 'pic2', '??', 'fileup', '{"type":"1","sl1x":"","sl1y":"","sl2x":"","sl2y":"","sypicwz":"9","sytxtwz":"1","sywz":"","syzt":"wqy-microhei-lite.ttc","syys":"FF0000","size":"1024","sywzdx":"12","STR":""}', '', 0, 0, 0, 2, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0), 267(1409, 79, 'commend', '??', 'textfield', '', '', 0, 0, 0, 3, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0), 268(1410, 79, 'price1', '??', 'textfield', '', '', 0, 0, 0, 4, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0), 269(1411, 79, 'facility', '????', 'textfield', '', '', 0, 0, 0, 5, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0), 270(1444, 79, 'pic2', '??', 'fileup', '{"type":"1","sl1x":"","sl1y":"","sl2x":"","sl2y":"","sypicwz":"9","sytxtwz":"1","sywz":"","syzt":"wqy-microhei-lite.ttc","syys":"FF0000","size":"1024","sywzdx":"12","STR":""}', '', 0, 0, 0, 2, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'en', 0, 0), 271(1443, 79, 'pic1', '???', 'textfield', '', '', 0, 0, 0, 1, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'en', 1, 0), 272(1434, 81, 'website', '??', 'textfield', '{"STR":""}', '', 0, 0, 0, 6, '400', '??????!', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0), 273(1433, 81, 'fax', '??', 'textfield', '{"STR":""}', '', 0, 0, 0, 5, '200', '??????!', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0), 274(1432, 81, 'phone', '??', 'textfield', '{"STR":""}', '', 0, 0, 0, 4, '200', '??????!', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0), 275(1431, 81, 'zipcode', '??', 'textfield', '{"STR":""}', '', 0, 0, 0, 3, '200', '??????!', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0), 276(1430, 81, 'address', '??', 'textfield', '{"STR":""}', '', 0, 0, 0, 2, '200', '??????!', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0), 277(1429, 81, 'content', '????', 'fckeditor', '{"height":"400","STR":""}', '', 0, 0, 0, 1, '500', '', 1, '0', '0', '0', '', '1', '', 0, 0, 0, 'zh', 0, 0), 278(1428, 81, 'title', '????', 'textfield', '{"STR":""}', '', 0, 0, 0, 0, '200', '????????!', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0), 279(1435, 81, 'around', '????', 'textarea', '{"STR":""}', '', 0, 0, 0, 7, '400', '????????!', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0), 280(1436, 81, 'map', '??', 'fileup', '', '', 0, 0, 0, 8, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0), 281(1437, 83, 'title', 'title??', 'textfield', '{"STR":""}', '', 0, 0, 0, 1, '400', '??????!', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0), 282(1438, 83, 'keywords', '???', 'textarea', '{"STR":""}', '', 0, 0, 0, 2, '400', '???????!', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0), 283(1439, 83, 'description', '??', 'textarea', '{"STR":""}', '', 0, 0, 0, 3, '400', '??????!', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0), 284(1440, 83, 'name', '?????(?:index.php)', 'textfield', '{"STR":""}', '', 0, 0, 0, 4, '400', '???????!', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0), 285(1442, 79, 'content', '?????', 'textfield', '', '', 0, 0, 0, 6, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'en', 0, 0), 286(1441, 79, 'title', '??', 'textfield', '', '', 0, 0, 0, 0, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'en', 1, 0), 287(1445, 79, 'price1', '??', 'textfield', '', '', 0, 0, 0, 4, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'en', 0, 0), 288(1446, 79, 'facility', '????', 'textfield', '', '', 0, 0, 0, 5, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'en', 0, 0), 289(1447, 79, 'commend', '??', 'textfield', '', '', 0, 0, 0, 3, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'en', 0, 0); 290 291-- -------------------------------------------------------- 292 293-- 294-- ???? `se_hotel_bak_dt63t25b` 295-- 296 297DROP TABLE IF EXISTS `se_hotel_bak_dt63t25b`; 298CREATE TABLE IF NOT EXISTS `se_hotel_bak_dt63t25b` ( 299 `id` int(8) NOT NULL auto_increment, 300 `bdtid` smallint(5) NOT NULL, 301 `bdid` int(5) NOT NULL COMMENT 'class_id', 302 `lg` varchar(10) NOT NULL, 303 `del` tinyint(1) NOT NULL, 304 `tid` int(8) NOT NULL COMMENT 'trees_id', 305 `gid` varchar(20) NOT NULL, 306 `at` varchar(20) NOT NULL COMMENT 'add_time', 307 `title` varchar(100) NOT NULL COMMENT '????', 308 `content` text NOT NULL COMMENT '????', 309 `address` varchar(100) NOT NULL COMMENT '??', 310 `zipcode` varchar(20) NOT NULL COMMENT '??', 311 `phone` varchar(20) NOT NULL COMMENT '??', 312 `fax` varchar(20) NOT NULL COMMENT '??', 313 `website` varchar(100) NOT NULL COMMENT '??', 314 `around` text NOT NULL COMMENT '????', 315 `map` varchar(50) NOT NULL COMMENT '??', 316 PRIMARY KEY (`id`) 317) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; 318 319-- -------------------------------------------------------- 320 321-- 322-- ???? `se_ikey` 323-- 324 325DROP TABLE IF EXISTS `se_ikey`; 326CREATE TABLE IF NOT EXISTS `se_ikey` ( 327 `id` int(6) NOT NULL auto_increment COMMENT 'ID', 328 `user` varchar(20) NOT NULL COMMENT '??', 329 `psw` varchar(50) NOT NULL COMMENT 'MD5??', 330 `hexid` varchar(40) NOT NULL COMMENT '?HEXID', 331 `rh` varchar(40) NOT NULL COMMENT 'Rh', 332 `rl` varchar(40) NOT NULL COMMENT 'Rl', 333 `szqz` varchar(40) NOT NULL COMMENT 'encode123456', 334 PRIMARY KEY (`id`) 335) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Ikeycfg' AUTO_INCREMENT=12 ; 336 337-- 338-- ??????? `se_ikey` 339-- 340 341INSERT INTO `se_ikey` (`id`, `user`, `psw`, `hexid`, `rh`, `rl`, `szqz`) VALUES 342(1, '???', 'qq', '60ce077a45b67e6d', '4334f4', '23324f23', '1283941965'), 343(11, 'a', 'a', '1344815250d97749', 'ffffffff', 'ffffffff', '-494133087'); 344 345-- -------------------------------------------------------- 346 347-- 348-- ???? `se_ikeyw` 349-- 350 351DROP TABLE IF EXISTS `se_ikeyw`; 352CREATE TABLE IF NOT EXISTS `se_ikeyw` ( 353 `id` int(6) NOT NULL auto_increment COMMENT 'ID', 354 `hexid` varchar(40) NOT NULL COMMENT '?HEXID', 355 `rh` varchar(40) NOT NULL COMMENT 'Rh', 356 `rl` varchar(40) NOT NULL COMMENT 'Rl', 357 `wh` varchar(40) NOT NULL COMMENT 'Wh', 358 `wl` varchar(40) NOT NULL COMMENT 'Wl', 359 PRIMARY KEY (`id`), 360 UNIQUE KEY `hexid` (`hexid`), 361 UNIQUE KEY `hexid_2` (`hexid`) 362) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Ikey basecfg ?????' AUTO_INCREMENT=11 ; 363 364-- 365-- ??????? `se_ikeyw` 366-- 367 368INSERT INTO `se_ikeyw` (`id`, `hexid`, `rh`, `rl`, `wh`, `wl`) VALUES 369(1, '60ce077a45b67e6d', '4334f4', '23324f23', 'asdfasdf', 'ff34h45h'), 370(2, 'ce6b4a096f85e074', '54f34f3f', '54f34f3f', 'asddsfas', 'dsafdfsa'), 371(3, '1ebc694cd152d8ce', '34t234f4', '234df235', 'tgh67ujj', '353j4567'), 372(4, 'd190ba69213ea05b', '45123513', '34123134', 'sadsdsdf', '3f55ff34'), 373(5, '5e1f0b7786dfe6de', 'asdfsadf', 't45gt45', 'asdsfafd', 'asdfasdf'), 374(6, '82be157193a655db', 'ffffffff', 'ffffffff', 'ffffffff', 'ffffffff'), 375(7, '', 'ffffffff', 'ffffffff', 'ffffffff', 'ffffffff'), 376(8, '65480a3856480304', 'asdfasfd', 'asdfasdf', 'asdfasdf', 'asdfasdf'), 377(9, '3cb6e5de832523fc', 'asdfasfa', 'asdfasdf', 'asdfasfa', 'asdfasfa'), 378(10, '1344815250d97749', 'ffffffff', 'ffffffff', 'ffffffff', 'ffffffff'); 379 380-- -------------------------------------------------------- 381 382-- 383-- ???? `se_info` 384-- 385 386DROP TABLE IF EXISTS `se_info`; 387CREATE TABLE IF NOT EXISTS `se_info` ( 388 `id` int(8) NOT NULL auto_increment, 389 `bdtid` smallint(5) NOT NULL, 390 `bdid` int(5) NOT NULL COMMENT 'class_id', 391 `lg` varchar(10) NOT NULL, 392 `del` tinyint(1) NOT NULL, 393 `tid` int(8) NOT NULL COMMENT 'trees_id', 394 `gid` varchar(20) NOT NULL, 395 `at` varchar(20) NOT NULL COMMENT 'add_time', 396 `title` varchar(100) NOT NULL COMMENT '??', 397 `content` text NOT NULL COMMENT '??', 398 `address` varchar(100) NOT NULL COMMENT '??', 399 `zipcode` varchar(20) NOT NULL COMMENT '??', 400 `phone` varchar(20) NOT NULL COMMENT '??', 401 `fax` varchar(20) NOT NULL COMMENT '??', 402 `website` varchar(100) NOT NULL COMMENT '??', 403 `around` text NOT NULL COMMENT '??', 404 `mapx` varchar(50) NOT NULL COMMENT '??x', 405 `mapy` varchar(50) NOT NULL COMMENT '??y', 406 PRIMARY KEY (`id`) 407) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; 408 409-- -------------------------------------------------------- 410 411-- 412-- ???? `se_news` 413-- 414 415DROP TABLE IF EXISTS `se_news`; 416CREATE TABLE IF NOT EXISTS `se_news` ( 417 `id` int(8) NOT NULL auto_increment, 418 `bdtid` smallint(5) NOT NULL, 419 `bdid` int(5) NOT NULL COMMENT 'class_id', 420 `lg` varchar(10) NOT NULL, 421 `del` tinyint(1) NOT NULL, 422 `tid` int(8) NOT NULL COMMENT 'trees_id', 423 `gid` varchar(20) NOT NULL, 424 `at` varchar(20) NOT NULL COMMENT 'add_time', 425 `title` varchar(100) NOT NULL COMMENT '??', 426 `content` text NOT NULL COMMENT '??', 427 `pic1` varchar(50) NOT NULL COMMENT '??', 428 `pic2` varchar(50) NOT NULL COMMENT '??', 429 `hit` int(10) NOT NULL COMMENT '???', 430 `addtime` varchar(50) NOT NULL COMMENT '????', 431 `commend` int(5) NOT NULL COMMENT '??', 432 PRIMARY KEY (`id`) 433) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; 434 435-- -------------------------------------------------------- 436 437-- 438-- ???? `se_news_bak_5pumeuju` 439-- 440 441DROP TABLE IF EXISTS `se_news_bak_5pumeuju`; 442CREATE TABLE IF NOT EXISTS `se_news_bak_5pumeuju` ( 443 `id` int(8) NOT NULL auto_increment, 444 `bdtid` smallint(5) NOT NULL, 445 `bdid` int(5) NOT NULL COMMENT 'class_id', 446 `lg` varchar(10) NOT NULL, 447 `del` tinyint(1) NOT NULL, 448 `tid` int(8) NOT NULL COMMENT 'trees_id', 449 `gid` varchar(20) NOT NULL, 450 `at` varchar(20) NOT NULL COMMENT 'add_time', 451 PRIMARY KEY (`id`) 452) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; 453 454-- -------------------------------------------------------- 455 456-- 457-- ???? `se_new_bak_g6u8weyh` 458-- 459 460DROP TABLE IF EXISTS `se_new_bak_g6u8weyh`; 461CREATE TABLE IF NOT EXISTS `se_new_bak_g6u8weyh` ( 462 `id` int(8) NOT NULL auto_increment, 463 `bdtid` smallint(5) NOT NULL, 464 `bdid` int(5) NOT NULL COMMENT 'class_id', 465 `lg` varchar(10) NOT NULL, 466 `del` tinyint(1) NOT NULL, 467 `tid` int(8) NOT NULL COMMENT 'trees_id', 468 `gid` varchar(20) NOT NULL, 469 `at` varchar(20) NOT NULL COMMENT 'add_time', 470 `title` varchar(100) NOT NULL COMMENT '??', 471 `content` text NOT NULL COMMENT '??', 472 `pic1` varchar(50) NOT NULL COMMENT '??', 473 `pic2` varchar(50) NOT NULL COMMENT '??', 474 `commend` int(5) NOT NULL COMMENT '??', 475 `hit` int(10) NOT NULL COMMENT '???', 476 `addtime` varchar(50) NOT NULL COMMENT '????', 477 PRIMARY KEY (`id`) 478) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; 479 480-- -------------------------------------------------------- 481 482-- 483-- ???? `se_pic` 484-- 485 486DROP TABLE IF EXISTS `se_pic`; 487CREATE TABLE IF NOT EXISTS `se_pic` ( 488 `id` int(8) NOT NULL auto_increment, 489 `bdtid` smallint(5) NOT NULL, 490 `bdid` int(5) NOT NULL COMMENT 'class_id', 491 `lg` varchar(10) NOT NULL, 492 `del` tinyint(1) NOT NULL, 493 `tid` int(8) NOT NULL COMMENT 'trees_id', 494 `gid` varchar(20) NOT NULL, 495 `at` varchar(20) NOT NULL COMMENT 'add_time', 496 `title` varchar(100) NOT NULL COMMENT '??', 497 `content` text NOT NULL COMMENT '??', 498 `pic1` varchar(50) NOT NULL COMMENT '??', 499 `pic2` varchar(50) NOT NULL COMMENT '??', 500 `commend` int(5) NOT NULL COMMENT '??', 501 PRIMARY KEY (`id`) 502) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; 503 504-- -------------------------------------------------------- 505 506-- 507-- ???? `se_room` 508-- 509 510DROP TABLE IF EXISTS `se_room`; 511CREATE TABLE IF NOT EXISTS `se_room` ( 512 `id` int(8) NOT NULL auto_increment, 513 `bdtid` smallint(5) NOT NULL, 514 `bdid` int(5) NOT NULL COMMENT 'class_id', 515 `lg` varchar(10) NOT NULL, 516 `del` tinyint(1) NOT NULL, 517 `tid` int(8) NOT NULL COMMENT 'trees_id', 518 `gid` varchar(20) NOT NULL, 519 `at` varchar(20) NOT NULL COMMENT 'add_time', 520 `title` varchar(100) NOT NULL COMMENT '??', 521 `content` text NOT NULL COMMENT '??', 522 `pic1` varchar(50) NOT NULL COMMENT '??', 523 `pic2` varchar(50) NOT NULL COMMENT '??', 524 `price1` varchar(50) NOT NULL COMMENT '??', 525 `facility` text NOT NULL COMMENT '????', 526 `commend` int(5) NOT NULL COMMENT '??', 527 PRIMARY KEY (`id`) 528) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; 529 530-- 531-- ??????? `se_room` 532-- 533 534INSERT INTO `se_room` (`id`, `bdtid`, `bdid`, `lg`, `del`, `tid`, `gid`, `at`, `title`, `content`, `pic1`, `pic2`, `price1`, `facility`, `commend`) VALUES 535(1, 0, 0, 'zh', 1, 79, '131233828080.27', '1312338296', '', 'sdf', '', '', 'asdf', 'sdf', 0); 536 537-- -------------------------------------------------------- 538 539-- 540-- ???? `se_room_bak_28kbu7du` 541-- 542 543DROP TABLE IF EXISTS `se_room_bak_28kbu7du`; 544CREATE TABLE IF NOT EXISTS `se_room_bak_28kbu7du` ( 545 `id` int(8) NOT NULL auto_increment, 546 `bdtid` smallint(5) NOT NULL, 547 `bdid` int(5) NOT NULL COMMENT 'class_id', 548 `lg` varchar(10) NOT NULL, 549 `del` tinyint(1) NOT NULL, 550 `tid` int(8) NOT NULL COMMENT 'trees_id', 551 `gid` varchar(20) NOT NULL, 552 `at` varchar(20) NOT NULL COMMENT 'add_time', 553 PRIMARY KEY (`id`) 554) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; 555 556-- -------------------------------------------------------- 557 558-- 559-- ???? `se_rtp` 560-- 561 562DROP TABLE IF EXISTS `se_rtp`; 563CREATE TABLE IF NOT EXISTS `se_rtp` ( 564 `id` int(8) NOT NULL auto_increment, 565 `bdtid` smallint(5) NOT NULL, 566 `bdid` int(5) NOT NULL COMMENT 'class_id', 567 `lg` varchar(10) NOT NULL, 568 `del` tinyint(1) NOT NULL, 569 `tid` int(8) NOT NULL COMMENT 'trees_id', 570 `gid` varchar(20) NOT NULL, 571 `tt` varchar(80) NOT NULL COMMENT 'title', 572 `at` varchar(20) NOT NULL COMMENT 'add_time', 573 `ct` text NOT NULL COMMENT 'content', 574 `cfg` text NOT NULL COMMENT 'cfg', 575 PRIMARY KEY (`id`) 576) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ; 577 578-- 579-- ??????? `se_rtp` 580-- 581 582INSERT INTO `se_rtp` (`id`, `bdtid`, `bdid`, `lg`, `del`, `tid`, `gid`, `tt`, `at`, `ct`, `cfg`) VALUES 583(2, 0, 0, '', 1, 64, '', '?????', '1284803771', 'red right', '{"xr":{"1":"1","2":"1","15":"1","8":"1","9":"1","10":"1"},"r":{"15":"1","16":"1","9":"1","10":"1"},"x":null,"d":{"10":"1"},"u":{"9":"1","10":"1","63":"1"},"b":null,"q":null}'), 584(3, 0, 0, '', 0, 64, '', '???', '1300786194', '????', '{"xr":{"62":"1","63":"1","64":"1","184":"1","185":"1","186":"1","187":"1","188":"1","189":"1","190":"1","191":"1","192":"1","193":"1","194":"1","195":"1","196":"1","197":"1","198":"1","199":"1","200":"1","201":"1","202":"1","203":"1","204":"1","207":"1","205":"1","209":"1","239":"1","208":"1","206":"1","210":"1","226":"1","220":"1","221":"1","222":"1","223":"1","224":"1","225":"1","235":"1","233":"1","234":"1","236":"1","211":"1","212":"1","213":"1","230":"1","231":"1","214":"1","215":"1","216":"1","217":"1","218":"1","219":"1","232":"1","227":"1","228":"1","229":"1","237":"1","238":"1"},"r":{"63":"1","64":"1","186":"1","188":"1","189":"1","190":"1","191":"1","192":"1","194":"1","195":"1","196":"1","197":"1","199":"1","200":"1","201":"1","202":"1","203":"1","205":"1","209":"1","239":"1","206":"1","210":"1","226":"1","220":"1","221":"1","223":"1","224":"1","225":"1","233":"1","234":"1","236":"1","212":"1","230":"1","231":"1","214":"1","215":"1","217":"1","218":"1","219":"1","232":"1","228":"1","229":"1","238":"1"},"c":{"63":"1","64":"1","186":"1","188":"1","189":"1","190":"1","191":"1","192":"1","194":"1","195":"1","196":"1","197":"1","199":"1","200":"1","201":"1","202":"1","203":"1","205":"1","209":"1","206":"1","210":"1","226":"1","220":"1","221":"1","223":"1","224":"1","225":"1","233":"1","234":"1","236":"1","212":"1","230":"1","231":"1","214":"1","215":"1","217":"1","218":"1","219":"1","232":"1","228":"1","229":"1","238":"1"},"d":{"63":"1","64":"1","186":"1","188":"1","189":"1","190":"1","191":"1","192":"1","194":"1","195":"1","196":"1","197":"1","199":"1","200":"1","201":"1","202":"1","203":"1","205":"1","209":"1","206":"1","210":"1","226":"1","220":"1","221":"1","223":"1","224":"1","225":"1","233":"1","234":"1","236":"1","212":"1","230":"1","231":"1","214":"1","215":"1","217":"1","218":"1","219":"1","232":"1","228":"1","229":"1","238":"1"},"u":{"63":"1","64":"1","186":"1","188":"1","189":"1","190":"1","191":"1","192":"1","194":"1","195":"1","196":"1","197":"1","199":"1","200":"1","201":"1","202":"1","203":"1","205":"1","209":"1","239":"1","206":"1","210":"1","226":"1","220":"1","221":"1","223":"1","224":"1","225":"1","233":"1","234":"1","236":"1","212":"1","230":"1","231":"1","214":"1","215":"1","217":"1","218":"1","219":"1","232":"1","228":"1","229":"1","238":"1"},"b":{"63":"1"},"q":{"63":"1"},"xt":{"1":"1","2":"1","3":"1","4":"1","5":"1","6":"1","7":"1","8":"1","9":"1","10":"1"},"pz":{"63":"1","64":"1"}}'), 585(4, 0, 0, '', 0, 64, '', '??', '1290825623', '????????.', '{"xr":{"62":"1","63":"1","64":"1","1":"1","144":"1","141":"1","146":"1","143":"1","148":"1","149":"1","159":"1","158":"1","157":"1","156":"1","155":"1","154":"1","150":"1","153":"1","152":"1","151":"1","160":"1","161":"1","163":"1","162":"1","166":"1","167":"1","168":"1","169":"1","164":"1","170":"1","171":"1","172":"1","165":"1","173":"1","174":"1","175":"1","176":"1"},"r":{"63":"1","64":"1","144":"1","141":"1","146":"1","143":"1","148":"1","159":"1","158":"1","157":"1","156":"1","155":"1","154":"1","153":"1","152":"1","151":"1","160":"1","162":"1","166":"1","167":"1","168":"1","169":"1","170":"1","171":"1","172":"1","173":"1","174":"1","175":"1","176":"1"},"c":{"63":"1","64":"1","144":"1","141":"1","146":"1","143":"1","148":"1","159":"1","158":"1","157":"1","156":"1","155":"1","154":"1","153":"1","152":"1","151":"1","160":"1","162":"1","166":"1","167":"1","168":"1","169":"1","170":"1","171":"1","172":"1","173":"1","174":"1","175":"1","176":"1"},"d":{"63":"1","64":"1","144":"1","141":"1","146":"1","143":"1","148":"1","159":"1","158":"1","157":"1","156":"1","155":"1","154":"1","153":"1","152":"1","151":"1","160":"1","162":"1","166":"1","167":"1","168":"1","169":"1","170":"1","171":"1","172":"1","173":"1","174":"1","175":"1","176":"1"},"u":{"63":"1","64":"1","144":"1","141":"1","146":"1","143":"1","148":"1","159":"1","158":"1","157":"1","156":"1","155":"1","154":"1","153":"1","152":"1","151":"1","160":"1","162":"1","166":"1","167":"1","168":"1","169":"1","170":"1","171":"1","172":"1","173":"1","174":"1","175":"1","176":"1"},"b":{"63":"1"},"q":{"63":"1"},"xt":{"1":"1","2":"1","3":"1","4":"1","5":"1","6":"1","7":"1","8":"1","9":"1","10":"1"},"pz":{"63":"1","64":"1"}}'), 586(6, 0, 0, '', 1, 64, '', 't', '1285209573', 't', '{"xr":null,"r":null,"c":null,"d":null,"u":null,"b":null,"q":null,"xt":null,"pz":null}'), 587(1, 0, 0, '', 0, 64, '', 'ce', '1313056454', '', '{"xr":{"62":"1","63":"1","64":"1","65":"1","66":"1","75":"1","79":"1","80":"1","67":"1","68":"1","69":"1","70":"1","71":"1","72":"1","81":"1","73":"1","74":"1","82":"1","83":"1"},"r":{"63":"1","64":"1","75":"1","79":"1","80":"1","67":"1","68":"1","69":"1","70":"1","71":"1","81":"1","73":"1","74":"1","83":"1"},"c":{"63":"1","64":"1","75":"1","79":"1","80":"1","67":"1","68":"1","69":"1","70":"1","71":"1","81":"1","73":"1","74":"1","83":"1"},"d":{"63":"1","64":"1","75":"1","79":"1","80":"1","67":"1","68":"1","69":"1","70":"1","71":"1","81":"1","73":"1","74":"1","83":"1"},"u":{"63":"1","64":"1","75":"1","79":"1","80":"1","67":"1","68":"1","69":"1","70":"1","71":"1","81":"1","73":"1","74":"1","83":"1"},"b":{"63":"1"},"q":{"63":"1"},"xt":{"1":"1","2":"1","3":"1","4":"1","5":"1","6":"1","7":"1","8":"1","9":"1","10":"1"},"pz":{"63":"1","64":"1"}}'); 588 589-- -------------------------------------------------------- 590 591-- 592-- ???? `se_seo` 593-- 594 595DROP TABLE IF EXISTS `se_seo`; 596CREATE TABLE IF NOT EXISTS `se_seo` ( 597 `id` int(8) NOT NULL auto_increment, 598 `bdtid` smallint(5) NOT NULL, 599 `bdid` int(5) NOT NULL COMMENT 'class_id', 600 `lg` varchar(10) NOT NULL, 601 `del` tinyint(1) NOT NULL, 602 `tid` int(8) NOT NULL COMMENT 'trees_id', 603 `gid` varchar(20) NOT NULL, 604 `at` varchar(20) NOT NULL COMMENT 'add_time', 605 `title` text NOT NULL COMMENT '??', 606 `keywords` text NOT NULL COMMENT '???', 607 `description` text NOT NULL COMMENT '??', 608 `name` text NOT NULL COMMENT '???', 609 PRIMARY KEY (`id`) 610) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; 611 612-- -------------------------------------------------------- 613 614-- 615-- ???? `se_tree` 616-- 617 618DROP TABLE IF EXISTS `se_tree`; 619CREATE TABLE IF NOT EXISTS `se_tree` ( 620 `id` smallint(5) unsigned NOT NULL auto_increment, 621 `user` smallint(5) NOT NULL, 622 `title` varchar(50) NOT NULL, 623 `parentid` smallint(5) NOT NULL, 624 `leaf` smallint(1) NOT NULL default '0', 625 `px` int(6) NOT NULL, 626 `cls` varchar(60) NOT NULL, 627 `table` int(5) NOT NULL, 628 `is_expand` tinyint(1) NOT NULL, 629 `expand` varchar(50) NOT NULL, 630 `shield_add` tinyint(1) NOT NULL, 631 `shield_edit` tinyint(1) NOT NULL, 632 `shield_del` tinyint(1) NOT NULL, 633 `is_show` tinyint(1) NOT NULL, 634 `power` int(2) NOT NULL, 635 `url` text NOT NULL, 636 `sortid` int(10) NOT NULL default '1', 637 `del` smallint(1) NOT NULL, 638 `config` text NOT NULL, 639 PRIMARY KEY (`id`) 640) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=84 ; 641 642-- 643-- ??????? `se_tree` 644-- 645 646INSERT INTO `se_tree` (`id`, `user`, `title`, `parentid`, `leaf`, `px`, `cls`, `table`, `is_expand`, `expand`, `shield_add`, `shield_edit`, `shield_del`, `is_show`, `power`, `url`, `sortid`, `del`, `config`) VALUES 647(62, 0, '????', 0, 0, 3, 'sucaiwcom92350hwz.png', 0, 0, '', 0, 0, 0, 1, 0, '', 1, 0, '{"lg":""}'), 648(63, 0, '????', 62, 1, 2, 'page_user.gif', 6, 0, '', 1, 1, 1, 1, 0, '', 1, 0, '{"lg":""}'), 649(64, 0, '????', 62, 1, 3, 'sucaiwcom94050hmf.png', 7, 0, '', 1, 1, 1, 1, 0, '', 1, 0, '{"lg":""}'), 650(65, 0, '????', 0, 0, 1, 'default', 0, 0, '', 1, 1, 1, 1, 0, '', 1, 0, '{"lg":""}'), 651(66, 0, '??', 65, 0, 1, 'default', 8, 0, '', 1, 1, 1, 1, 0, '', 1, 0, '{"lg":""}'), 652(67, 0, '??', 65, 0, 2, 'default', 0, 0, '', 1, 1, 1, 1, 0, '', 1, 1, '{"lg":""}'), 653(68, 0, '??', 65, 0, 3, 'default', 0, 0, '', 1, 1, 1, 1, 0, '', 1, 1, '{"lg":""}'), 654(69, 0, '??', 65, 0, 4, 'default', 0, 0, '', 1, 1, 1, 1, 0, '', 1, 1, '{"lg":""}'), 655(70, 0, '????', 65, 0, 8, 'default', 0, 0, '', 1, 1, 1, 1, 0, '', 1, 1, '{"lg":""}'), 656(71, 0, '??', 65, 0, 5, 'default', 0, 0, '', 1, 1, 1, 1, 0, '', 1, 1, '{"lg":""}'), 657(72, 0, '????', 65, 0, 9, 'default', 0, 0, '', 1, 1, 1, 1, 0, '', 1, 0, '{"lg":""}'), 658(73, 0, '??', 65, 0, 6, 'default', 0, 0, '', 1, 1, 1, 1, 0, '', 1, 1, '{"lg":""}'), 659(74, 0, '??', 65, 0, 7, 'default', 0, 0, '', 1, 1, 1, 1, 0, '', 1, 1, '{"lg":""}'), 660(75, 0, '???', 66, 1, 0, 'default', 15, 0, '', 1, 1, 1, 1, 0, '', 1, 0, '{"lg":""}'), 661(82, 0, '????', 65, 0, 10, 'default', 0, 0, '', 1, 1, 1, 1, 0, '', 1, 0, '{"lg":""}'), 662(81, 0, '????', 72, 1, 0, 'default', 12, 0, '', 1, 1, 1, 1, 0, '', 1, 0, '{"lg":""}'), 663(79, 0, '????', 66, 1, 0, 'default', 14, 0, '80', 1, 1, 1, 1, 0, '', 1, 0, '{"lg":"zh|en"}'), 664(80, 0, '?????', 66, 1, 0, 'default', 9, 1, '', 1, 1, 1, 0, 0, '', 1, 0, '{"lg":"zh|en"}'), 665(83, 0, 'SEO', 82, 1, 0, 'default', 16, 0, '', 1, 1, 1, 1, 0, '', 1, 0, '{"lg":""}'); 666 667-- -------------------------------------------------------- 668 669-- 670-- ???? `se_user` 671-- 672 673DROP TABLE IF EXISTS `se_user`; 674CREATE TABLE IF NOT EXISTS `se_user` ( 675 `id` int(8) NOT NULL auto_increment, 676 `bdtid` smallint(5) NOT NULL, 677 `bdid` int(5) NOT NULL COMMENT 'class_id', 678 `lg` varchar(10) NOT NULL, 679 `del` tinyint(1) NOT NULL, 680 `tid` int(8) NOT NULL COMMENT 'trees_id', 681 `gid` varchar(20) NOT NULL, 682 `tt` varchar(80) NOT NULL COMMENT 'title', 683 `at` varchar(20) NOT NULL COMMENT 'add_time', 684 `ct` text NOT NULL COMMENT 'content', 685 `user` varchar(20) NOT NULL COMMENT '???', 686 `psw` varchar(50) NOT NULL COMMENT '??', 687 `name` varchar(20) NOT NULL COMMENT '????', 688 `sex` varchar(20) NOT NULL COMMENT '??', 689 `sheng` varchar(20) NOT NULL COMMENT '?', 690 `shi` varchar(20) NOT NULL COMMENT '?', 691 `xian` varchar(20) NOT NULL COMMENT '?', 692 `tel` varchar(100) NOT NULL, 693 `email` varchar(100) NOT NULL, 694 `homepage` varchar(100) NOT NULL, 695 `mobile` varchar(100) NOT NULL, 696 `instro` text NOT NULL COMMENT '??', 697 `gongs` varchar(50) NOT NULL COMMENT '???', 698 `zhiw` varchar(100) NOT NULL COMMENT '??', 699 `gsjs` text NOT NULL COMMENT '????', 700 `usertype` varchar(20) NOT NULL COMMENT '????', 701 `rcfg` text NOT NULL COMMENT '????', 702 `hexid` varchar(50) NOT NULL COMMENT '?ID', 703 PRIMARY KEY (`id`) 704) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=29 ; 705 706-- 707-- ??????? `se_user` 708-- 709 710INSERT INTO `se_user` (`id`, `bdtid`, `bdid`, `lg`, `del`, `tid`, `gid`, `tt`, `at`, `ct`, `user`, `psw`, `name`, `sex`, `sheng`, `shi`, `xian`, `tel`, `email`, `homepage`, `mobile`, `instro`, `gongs`, `zhiw`, `gsjs`, `usertype`, `rcfg`, `hexid`) VALUES 711(7, 0, 0, 'zh', 0, 63, '128385263648', '', '1286594882', '', 'a', '0cc175b9c0f1b6a831c399e269772661', '???', '1', '', '', '', '', '', '', '', '', '???1', '', '', '????', '1', ''), 712(24, 0, 0, '', 0, 0, '', '', '', '????', 'yiming', 'e1a199efdeb9ddef71b851748085e7eb', '???', '', '', '', '', '15109886055', '657342075@qq.com', '', '', '', '', '', '', '', '', ''), 713(25, 0, 0, 'zh', 0, 63, '128937351541.53', '', '1290842242', '', 'root', '63a9f0ea7bb98050796b649e85481845', '???', '', '', '', '', '', '', '', '', '', '', '', '', '??', '3', ''), 714(26, 0, 0, '', 0, 0, '', '', '', '????', '15808930776', '668ffb0f7bec7eed48fe1f6733195729', '???', '', '', '', '', '15808930776', '337382080@qq.com', '', '', '', '', '', '', '', '', ''), 715(27, 0, 0, '', 0, 0, '', '', '', '????', '13976506938', '413f418b8fb0b0af970eec1750498c51', '???', '', '', '', '', '13976506938', '284776872@qq.com', '', '', '', '', '', '', '', '', ''), 716(28, 0, 0, '', 0, 0, '', '', '', '123', '15109886055', 'e1a199efdeb9ddef71b851748085e7eb', '??', '', '', '', '', '15109886055', 'yunqing__19@163.com', '', '', '', '', '', '', '', '', ''); 717 718/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; 719/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; 720/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; 721 722 723CREATE TABLE IF NOT EXISTS `se_price` ( 724 `id` int(11) NOT NULL auto_increment, 725 `bdb` varchar(100) NOT NULL COMMENT '???', 726 `bdid` varchar(50) NOT NULL COMMENT '??????gid', 727 `date` int(11) NOT NULL default '0' COMMENT '??', 728 `price` int(11) NOT NULL default '0' COMMENT '??', 729 `room` smallint(3) NOT NULL default '0' COMMENT '???', 730 `lg` varchar(10) NOT NULL default 'zh', 731 `del` tinyint(1) NOT NULL default '0', 732 `gid` varchar(20) NOT NULL, 733 PRIMARY KEY (`id`) 734) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='??--?? ????/?????' AUTO_INCREMENT=563631 ;# MySQL ????????? (???)? 735 736-- 737-- ???? `se_log` 738-- 739 740CREATE TABLE `se_log` ( 741 `id` int(8) NOT NULL auto_increment, 742 `bdtid` smallint(5) NOT NULL, 743 `bdid` int(5) NOT NULL COMMENT 'class_id', 744 `lg` varchar(10) NOT NULL, 745 `del` tinyint(1) NOT NULL, 746 `tid` int(8) NOT NULL COMMENT 'trees_id', 747 `gid` varchar(20) NOT NULL, 748 `at` varchar(20) NOT NULL COMMENT 'add_time', 749 `username` varchar(100) NOT NULL COMMENT '???', 750 `optime` varchar(100) NOT NULL COMMENT '????', 751 `ip` varchar(100) NOT NULL COMMENT 'IP??', 752 `opp` varchar(100) NOT NULL COMMENT '??', 753 `optid` text NOT NULL COMMENT '???tid', 754 `opid` text NOT NULL COMMENT '???id', 755 `modularname` varchar(100) NOT NULL COMMENT '????', 756 `log` text NOT NULL COMMENT '????', 757 PRIMARY KEY (`id`) 758) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;