PageRenderTime 109ms CodeModel.GetById 14ms app.highlight 86ms RepoModel.GetById 1ms app.codeStats 0ms

/source/sql/cms20110905.sql

http://prosporous.googlecode.com/
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 ;