/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. 

  2. -- version 3.4.3.1
    3. 

  3. -- http://www.phpmyadmin.net
    4. 

  4. --
    5. 

  5. -- ??: localhost
    6. 

  6. -- ????: 2011 ? 09 ? 05 ? 03:55
    7. 

  7. -- ?????: 5.0.51
    8. 

  8. -- PHP ??: 5.2.6
    9. 

  9. 

  10. SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
    11. 

  11. SET time_zone = "+00:00";
    12. 

  12. 

  13. 

  14. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
    15. 

  15. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
    16. 

  16. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
    17. 

  17. /*!40101 SET NAMES utf8 */;
    18. 

  18. 

  19. --
    20. 

  20. -- ???: `cms`
    21. 

  21. --
    22. 

  22. 

  23. -- --------------------------------------------------------
    24. 

  24. 

  25. --
    26. 

  26. -- ???? `se_area`
    27. 

  27. --
    28. 

  28. 

  29. DROP TABLE IF EXISTS `se_area`;
    30. 

  30. CREATE TABLE IF NOT EXISTS `se_area` (
    31. 

  31.   `id` int(8) NOT NULL auto_increment,
    32. 

  32.   `bdtid` smallint(5) NOT NULL,
    33. 

  33.   `bdid` int(5) NOT NULL COMMENT 'class_id',
    34. 

  34.   `lg` varchar(10) NOT NULL,
    35. 

  35.   `del` tinyint(1) NOT NULL,
    36. 

  36.   `tid` int(8) NOT NULL COMMENT 'trees_id',
    37. 

  37.   `gid` varchar(20) NOT NULL,
    38. 

  38.   `at` varchar(20) NOT NULL COMMENT 'add_time',
    39. 

  39.   `title` varchar(50) NOT NULL COMMENT '??',
    40. 

  40.   `display` int(5) NOT NULL COMMENT '??',
    41. 

  41.   `parentid` int(5) NOT NULL COMMENT '??',
    42. 

  42.   PRIMARY KEY  (`id`)
    43. 

  43. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    44. 

  44. 

  45. -- --------------------------------------------------------
    46. 

  46. 

  47. --
    48. 

  48. -- ???? `se_ask`
    49. 

  49. --
    50. 

  50. 

  51. DROP TABLE IF EXISTS `se_ask`;
    52. 

  52. CREATE TABLE IF NOT EXISTS `se_ask` (
    53. 

  53.   `id` int(8) NOT NULL auto_increment,
    54. 

  54.   `bdtid` smallint(5) NOT NULL,
    55. 

  55.   `bdid` int(5) NOT NULL COMMENT 'class_id',
    56. 

  56.   `lg` varchar(10) NOT NULL,
    57. 

  57.   `del` tinyint(1) NOT NULL,
    58. 

  58.   `tid` int(8) NOT NULL COMMENT 'trees_id',
    59. 

  59.   `gid` varchar(20) NOT NULL,
    60. 

  60.   `at` varchar(20) NOT NULL COMMENT 'add_time',
    61. 

  61.   `title` varchar(100) NOT NULL COMMENT '??',
    62. 

  62.   `content` text NOT NULL COMMENT '????',
    63. 

  63.   `reply` text NOT NULL COMMENT '??',
    64. 

  64.   `contact` varchar(100) NOT NULL COMMENT '????',
    65. 

  65.   `addtime` varchar(50) NOT NULL COMMENT '????',
    66. 

  66.   `commend` int(5) NOT NULL COMMENT '??',
    67. 

  67.   PRIMARY KEY  (`id`)
    68. 

  68. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    69. 

  69. 

  70. -- --------------------------------------------------------
    71. 

  71. 

  72. --
    73. 

  73. -- ???? `se_base`
    74. 

  74. --
    75. 

  75. 

  76. DROP TABLE IF EXISTS `se_base`;
    77. 

  77. CREATE TABLE IF NOT EXISTS `se_base` (
    78. 

  78.   `id` int(8) NOT NULL auto_increment,
    79. 

  79.   `bdtid` smallint(5) NOT NULL,
    80. 

  80.   `bdid` int(5) NOT NULL COMMENT 'class_id',
    81. 

  81.   `lg` varchar(10) NOT NULL,
    82. 

  82.   `del` tinyint(1) NOT NULL,
    83. 

  83.   `tid` int(8) NOT NULL COMMENT 'trees_id',
    84. 

  84.   `gid` varchar(20) NOT NULL,
    85. 

  85.   `at` varchar(20) NOT NULL COMMENT 'add_time',
    86. 

  86.   `title` varchar(100) NOT NULL COMMENT '??',
    87. 

  87.   `content` text NOT NULL COMMENT '??',
    88. 

  88.   `pic1` varchar(50) NOT NULL COMMENT '??',
    89. 

  89.   `pic2` varchar(50) NOT NULL COMMENT '??',
    90. 

  90.   `commend` int(5) NOT NULL COMMENT '??',
    91. 

  91.   PRIMARY KEY  (`id`)
    92. 

  92. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    93. 

  93. 

  94. -- --------------------------------------------------------
    95. 

  95. 

  96. --
    97. 

  97. -- ???? `se_cross`
    98. 

  98. --
    99. 

  99. 

  100. DROP TABLE IF EXISTS `se_cross`;
    101. 

  101. CREATE TABLE IF NOT EXISTS `se_cross` (
    102. 

  102.   `id` int(8) NOT NULL auto_increment,
    103. 

  103.   `bdtid` smallint(5) NOT NULL,
    104. 

  104.   `bdid` int(5) NOT NULL COMMENT 'class_id',
    105. 

  105.   `lg` varchar(10) NOT NULL,
    106. 

  106.   `del` tinyint(1) NOT NULL,
    107. 

  107.   `tid` int(8) NOT NULL COMMENT 'trees_id',
    108. 

  108.   `gid` varchar(20) NOT NULL,
    109. 

  109.   `at` varchar(20) NOT NULL COMMENT 'add_time',
    110. 

  110.   `title` varchar(100) NOT NULL COMMENT '??',
    111. 

  111.   `content` text NOT NULL COMMENT '??',
    112. 

  112.   `pic1` varchar(50) NOT NULL COMMENT '??',
    113. 

  113.   `link` text NOT NULL COMMENT '??',
    114. 

  114.   `commend` int(5) NOT NULL COMMENT '??',
    115. 

  115.   PRIMARY KEY  (`id`)
    116. 

  116. ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;
    117. 

  117. 

  118. --
    119. 

  119. -- ??????? `se_cross`
    120. 

  120. --
    121. 

  121. 

  122. INSERT INTO `se_cross` (`id`, `bdtid`, `bdid`, `lg`, `del`, `tid`, `gid`, `at`, `title`, `content`, `pic1`, `link`, `commend`) VALUES
    123. 

  123. (1, 0, 0, 'zh', 1, 75, '131233768191.02', '1312337686', '', '', '', '', 0),
    124. 

  124. (2, 0, 0, 'zh', 1, 75, '131233793981.35', '1312337945', '', '', '', '', 0),
    125. 

  125. (3, 0, 0, 'zh', 1, 75, '131233820153.42', '1312338206', '', '', '', '', 0),
    126. 

  126. (4, 0, 0, 'zh', 1, 75, '131233837919.53', '1312338384', '', '', '', '', 0),
    127. 

  127. (5, 0, 0, 'zh', 1, 75, '131233845192.58', '1312338457', '', '', '', '', 0),
    128. 

  128. (6, 0, 0, 'zh', 1, 75, '131233864535.45', '1312338649', '', '', '', '', 0),
    129. 

  129. (7, 0, 0, 'zh', 1, 75, '131233910039.75', '1312339107', '', '', '', '', 0),
    130. 

  130. (8, 0, 0, 'zh', 0, 75, '131519151516.41', '1315191515', '', '1', '', '1', 661),
    131. 

  131. (9, 0, 0, 'zh', 0, 75, '131519184510.55', '1315193433', '', '1314847738', '', 'b', 3),
    132. 

  132. (10, 0, 0, 'zh', 0, 75, '131519193878.13', '1315191938', '', 'a', '', 'd', 1);
    133. 

  133. 

  134. -- --------------------------------------------------------
    135. 

  135. 

  136. --
    137. 

  137. -- ???? `se_datamod`
    138. 

  138. --
    139. 

  139. 

  140. DROP TABLE IF EXISTS `se_datamod`;
    141. 

  141. CREATE TABLE IF NOT EXISTS `se_datamod` (
    142. 

  142.   `id` tinyint(5) NOT NULL auto_increment COMMENT 'id',
    143. 

  143.   `id_mirror` tinyint(5) NOT NULL,
    144. 

  144.   `tabname` varchar(20) NOT NULL,
    145. 

  145.   `name` varchar(30) NOT NULL,
    146. 

  146.   `declare` varchar(100) NOT NULL,
    147. 

  147.   `extend_id` tinyint(5) NOT NULL default '0',
    148. 

  148.   `extend_name` varchar(10) NOT NULL,
    149. 

  149.   `extend_type` int(1) NOT NULL,
    150. 

  150.   `leaf` tinyint(1) NOT NULL default '0',
    151. 

  151.   `created` tinyint(1) NOT NULL,
    152. 

  152.   `del` tinyint(1) NOT NULL,
    153. 

  153.   PRIMARY KEY  (`id`)
    154. 

  154. ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ;
    155. 

  155. 

  156. --
    157. 

  157. -- ??????? `se_datamod`
    158. 

  158. --
    159. 

  159. 

  160. INSERT INTO `se_datamod` (`id`, `id_mirror`, `tabname`, `name`, `declare`, `extend_id`, `extend_name`, `extend_type`, `leaf`, `created`, `del`) VALUES
    161. 

  161. (6, 0, 'user', '???', '????', 0, '???', 0, 0, 1, 0),
    162. 

  162. (7, 0, 'rtp', '????', '????', 0, '???', 0, 0, 1, 0),
    163. 

  163. (8, 0, 'base', '??', '', 0, '???', 0, 0, 1, 0),
    164. 

  164. (9, 0, 'pic', '??', '', 8, '???', 0, 0, 1, 0),
    165. 

  165. (19, 0, 'news', '??', '', 8, '??', 0, 0, 1, 0),
    166. 

  166. (11, 0, 'ask', '??', '', 0, '???', 0, 0, 1, 0),
    167. 

  167. (17, 0, 'info', '????', '', 0, '???', 0, 0, 1, 0),
    168. 

  168. (14, 0, 'room', '??', '', 8, '???', 0, 0, 1, 0),
    169. 

  169. (20, 0, 'area', '??', '', 0, '???', 0, 0, 1, 0),
    170. 

  170. (15, 0, 'cross', '??', '', 8, '???', 0, 0, 1, 0),
    171. 

  171. (16, 0, 'seo', 'SEO', '', 0, '???', 0, 0, 1, 0),
    172. 

  172. (21, 0, 'log', '??????', '', 0, '???', 0, 0, 1, 0);
    173. 

  173. 

  174. -- --------------------------------------------------------
    175. 

  175. 

  176. --
    177. 

  177. -- ???? `se_father`
    178. 

  178. --
    179. 

  179. 

  180. DROP TABLE IF EXISTS `se_father`;
    181. 

  181. CREATE TABLE IF NOT EXISTS `se_father` (
    182. 

  182.   `id` int(8) NOT NULL auto_increment,
    183. 

  183.   `bdtid` smallint(5) NOT NULL,
    184. 

  184.   `bdid` int(5) NOT NULL COMMENT 'class_id',
    185. 

  185.   `lg` varchar(10) NOT NULL,
    186. 

  186.   `del` tinyint(1) NOT NULL,
    187. 

  187.   `tid` int(8) NOT NULL COMMENT 'trees_id',
    188. 

  188.   `gid` varchar(20) NOT NULL,
    189. 

  189.   `at` varchar(20) NOT NULL COMMENT 'add_time',
    190. 

  190.   PRIMARY KEY  (`id`)
    191. 

  191. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    192. 

  192. 

  193. -- --------------------------------------------------------
    194. 

  194. 

  195. --
    196. 

  196. -- ???? `se_fld`
    197. 

  197. --
    198. 

  198. 

  199. DROP TABLE IF EXISTS `se_fld`;
    200. 

  200. CREATE TABLE IF NOT EXISTS `se_fld` (
    201. 

  201.   `id` smallint(10) NOT NULL auto_increment COMMENT 'id',
    202. 

  202.   `tid` smallint(5) NOT NULL,
    203. 

  203.   `fname` varchar(20) NOT NULL,
    204. 

  204.   `name` varchar(20) NOT NULL,
    205. 

  205.   `type` varchar(20) NOT NULL,
    206. 

  206.   `cfg` text NOT NULL,
    207. 

  207.   `str` text NOT NULL,
    208. 

  208.   `wd` int(10) NOT NULL,
    209. 

  209.   `isfld` tinyint(1) NOT NULL,
    210. 

  210.   `xr` tinyint(1) NOT NULL default '0',
    211. 

  211.   `px` int(3) NOT NULL default '0',
    212. 

  212.   `width` varchar(3) NOT NULL,
    213. 

  213.   `ts` varchar(100) NOT NULL,
    214. 

  214.   `yxwk` int(1) NOT NULL default '1',
    215. 

  215.   `bt` varchar(1) NOT NULL default '0',
    216. 

  216.   `gj` varchar(1) NOT NULL default '0',
    217. 

  217.   `zy` varchar(1) NOT NULL default '1',
    218. 

  218.   `zyz` text NOT NULL,
    219. 

  219.   `qzfs` varchar(10) NOT NULL default '1',
    220. 

  220.   `blm` varchar(40) NOT NULL,
    221. 

  221.   `x` int(2) NOT NULL default '0',
    222. 

  222.   `y` int(2) NOT NULL default '0',
    223. 

  223.   `z` int(2) NOT NULL default '0',
    224. 

  224.   `lg` varchar(5) NOT NULL default 'zh',
    225. 

  225.   `del` tinyint(1) NOT NULL,
    226. 

  226.   `isnew` tinyint(1) NOT NULL,
    227. 

  227.   PRIMARY KEY  (`id`)
    228. 

  228. ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1453 ;
    229. 

  229. 

  230. --
    231. 

  231. -- ??????? `se_fld`
    232. 

  232. --
    233. 

  233. 

  234. INSERT 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. 

  235. (174, 63, 'user', '???', 'textfield', '{"STR":""}', '', 72, 0, 0, 0, '120', '???????!', 0, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0),
    236. 

  236. (175, 63, 'psw', '??', 'password', '{"STR":""}', '', 230, 0, 1, 7, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0),
    237. 

  237. (176, 63, 'name', '????', 'textfield', '{"STR":""}', '', 103, 0, 0, 8, '100', '????????!', 1, '0', '1', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0),
    238. 

  238. (181, 63, 'tel', '??', 'textfield', '', '', 139, 0, 0, 11, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0),
    239. 

  239. (182, 63, 'email', '??', 'textfield', '', '', 146, 0, 0, 10, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0),
    240. 

  240. (1362, 63, 'ct', '????', 'textarea', '{"STR":""}', '', 229, 0, 0, 9, '300', '????!', 1, '0', '0', '0', '', '1', '', 0, 0, 0, 'zh', 0, 0),
    241. 

  241. (219, 64, 'tt', '????', 'textfield', '', '', 173, 0, 0, 0, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0),
    242. 

  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. 

  243. (221, 64, 'cfg', '????', 'textfield', '', '', 0, 0, 1, 2, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0),
    244. 

  244. (1383, 63, 'gongs', '???', 'textfield', '', '', 0, 0, 0, 1, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0),
    245. 

  245. (1384, 63, 'zhiw', '??', 'textfield', '', '', 0, 0, 0, 2, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0),
    246. 

  246. (1385, 63, 'gsjs', '????', 'textfield', '', '', 0, 0, 0, 3, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0),
    247. 

  247. (1386, 63, 'usertype', '????', 'textfield', '', '', 0, 0, 0, 4, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0),
    248. 

  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. 

  249. (1388, 63, 'hexid', '?ID', 'textfield', '', '', 0, 0, 0, 6, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0),
    250. 

  250. (1389, 63, 'tt', '????', 'textfield', '', '', 173, 0, 0, 0, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0),
    251. 

  251. (1390, 63, 'sex', '??', 'textfield', '', '', 0, 0, 0, 0, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0),
    252. 

  252. (1391, 63, 'sheng', '?', 'textfield', '', '', 0, 0, 0, 0, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0),
    253. 

  253. (1392, 63, 'shi', '?', 'textfield', '', '', 0, 0, 0, 0, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0),
    254. 

  254. (1393, 63, 'xian', '?', 'textfield', '', '', 0, 0, 0, 0, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0),
    255. 

  255. (1394, 63, 'homepage', '', 'textfield', '', '', 0, 0, 0, 0, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0),
    256. 

  256. (1395, 63, 'mobile', '', 'textfield', '', '', 0, 0, 0, 0, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0),
    257. 

  257. (1396, 63, 'instro', '??', 'textfield', '', '', 0, 0, 0, 0, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0),
    258. 

  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. 

  259. (1452, 75, 'link', '??', 'textfield', '', '', 0, 0, 0, 3, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0),
    260. 

  260. (1405, 79, 'title', '??', 'textfield', '', '', 0, 0, 0, 0, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 1, 0),
    261. 

  261. (1450, 75, 'pic1', '???', 'textfield', '', '', 0, 0, 0, 1, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 1, 0),
    262. 

  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. 

  263. (1448, 75, 'title', '??', 'textfield', '', '', 0, 0, 0, 0, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 1, 0),
    264. 

  264. (1406, 79, 'content', '?????', 'textfield', '', '', 0, 0, 0, 6, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0),
    265. 

  265. (1407, 79, 'pic1', '???', 'textfield', '', '', 0, 0, 0, 1, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 1, 0),
    266. 

  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. 

  267. (1409, 79, 'commend', '??', 'textfield', '', '', 0, 0, 0, 3, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0),
    268. 

  268. (1410, 79, 'price1', '??', 'textfield', '', '', 0, 0, 0, 4, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0),
    269. 

  269. (1411, 79, 'facility', '????', 'textfield', '', '', 0, 0, 0, 5, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0),
    270. 

  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. 

  271. (1443, 79, 'pic1', '???', 'textfield', '', '', 0, 0, 0, 1, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'en', 1, 0),
    272. 

  272. (1434, 81, 'website', '??', 'textfield', '{"STR":""}', '', 0, 0, 0, 6, '400', '??????!', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0),
    273. 

  273. (1433, 81, 'fax', '??', 'textfield', '{"STR":""}', '', 0, 0, 0, 5, '200', '??????!', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0),
    274. 

  274. (1432, 81, 'phone', '??', 'textfield', '{"STR":""}', '', 0, 0, 0, 4, '200', '??????!', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0),
    275. 

  275. (1431, 81, 'zipcode', '??', 'textfield', '{"STR":""}', '', 0, 0, 0, 3, '200', '??????!', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0),
    276. 

  276. (1430, 81, 'address', '??', 'textfield', '{"STR":""}', '', 0, 0, 0, 2, '200', '??????!', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0),
    277. 

  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. 

  278. (1428, 81, 'title', '????', 'textfield', '{"STR":""}', '', 0, 0, 0, 0, '200', '????????!', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0),
    279. 

  279. (1435, 81, 'around', '????', 'textarea', '{"STR":""}', '', 0, 0, 0, 7, '400', '????????!', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0),
    280. 

  280. (1436, 81, 'map', '??', 'fileup', '', '', 0, 0, 0, 8, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0),
    281. 

  281. (1437, 83, 'title', 'title??', 'textfield', '{"STR":""}', '', 0, 0, 0, 1, '400', '??????!', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0),
    282. 

  282. (1438, 83, 'keywords', '???', 'textarea', '{"STR":""}', '', 0, 0, 0, 2, '400', '???????!', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0),
    283. 

  283. (1439, 83, 'description', '??', 'textarea', '{"STR":""}', '', 0, 0, 0, 3, '400', '??????!', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'zh', 0, 0),
    284. 

  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. 

  285. (1442, 79, 'content', '?????', 'textfield', '', '', 0, 0, 0, 6, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'en', 0, 0),
    286. 

  286. (1441, 79, 'title', '??', 'textfield', '', '', 0, 0, 0, 0, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'en', 1, 0),
    287. 

  287. (1445, 79, 'price1', '??', 'textfield', '', '', 0, 0, 0, 4, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'en', 0, 0),
    288. 

  288. (1446, 79, 'facility', '????', 'textfield', '', '', 0, 0, 0, 5, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'en', 0, 0),
    289. 

  289. (1447, 79, 'commend', '??', 'textfield', '', '', 0, 0, 0, 3, '', '', 1, '0', '0', '1', '', '1', '', 0, 0, 0, 'en', 0, 0);
    290. 

  290. 

  291. -- --------------------------------------------------------
    292. 

  292. 

  293. --
    294. 

  294. -- ???? `se_hotel_bak_dt63t25b`
    295. 

  295. --
    296. 

  296. 

  297. DROP TABLE IF EXISTS `se_hotel_bak_dt63t25b`;
    298. 

  298. CREATE TABLE IF NOT EXISTS `se_hotel_bak_dt63t25b` (
    299. 

  299.   `id` int(8) NOT NULL auto_increment,
    300. 

  300.   `bdtid` smallint(5) NOT NULL,
    301. 

  301.   `bdid` int(5) NOT NULL COMMENT 'class_id',
    302. 

  302.   `lg` varchar(10) NOT NULL,
    303. 

  303.   `del` tinyint(1) NOT NULL,
    304. 

  304.   `tid` int(8) NOT NULL COMMENT 'trees_id',
    305. 

  305.   `gid` varchar(20) NOT NULL,
    306. 

  306.   `at` varchar(20) NOT NULL COMMENT 'add_time',
    307. 

  307.   `title` varchar(100) NOT NULL COMMENT '????',
    308. 

  308.   `content` text NOT NULL COMMENT '????',
    309. 

  309.   `address` varchar(100) NOT NULL COMMENT '??',
    310. 

  310.   `zipcode` varchar(20) NOT NULL COMMENT '??',
    311. 

  311.   `phone` varchar(20) NOT NULL COMMENT '??',
    312. 

  312.   `fax` varchar(20) NOT NULL COMMENT '??',
    313. 

  313.   `website` varchar(100) NOT NULL COMMENT '??',
    314. 

  314.   `around` text NOT NULL COMMENT '????',
    315. 

  315.   `map` varchar(50) NOT NULL COMMENT '??',
    316. 

  316.   PRIMARY KEY  (`id`)
    317. 

  317. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    318. 

  318. 

  319. -- --------------------------------------------------------
    320. 

  320. 

  321. --
    322. 

  322. -- ???? `se_ikey`
    323. 

  323. --
    324. 

  324. 

  325. DROP TABLE IF EXISTS `se_ikey`;
    326. 

  326. CREATE TABLE IF NOT EXISTS `se_ikey` (
    327. 

  327.   `id` int(6) NOT NULL auto_increment COMMENT 'ID',
    328. 

  328.   `user` varchar(20) NOT NULL COMMENT '??',
    329. 

  329.   `psw` varchar(50) NOT NULL COMMENT 'MD5??',
    330. 

  330.   `hexid` varchar(40) NOT NULL COMMENT '?HEXID',
    331. 

  331.   `rh` varchar(40) NOT NULL COMMENT 'Rh',
    332. 

  332.   `rl` varchar(40) NOT NULL COMMENT 'Rl',
    333. 

  333.   `szqz` varchar(40) NOT NULL COMMENT 'encode123456',
    334. 

  334.   PRIMARY KEY  (`id`)
    335. 

  335. ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Ikeycfg' AUTO_INCREMENT=12 ;
    336. 

  336. 

  337. --
    338. 

  338. -- ??????? `se_ikey`
    339. 

  339. --
    340. 

  340. 

  341. INSERT INTO `se_ikey` (`id`, `user`, `psw`, `hexid`, `rh`, `rl`, `szqz`) VALUES
    342. 

  342. (1, '???', 'qq', '60ce077a45b67e6d', '4334f4', '23324f23', '1283941965'),
    343. 

  343. (11, 'a', 'a', '1344815250d97749', 'ffffffff', 'ffffffff', '-494133087');
    344. 

  344. 

  345. -- --------------------------------------------------------
    346. 

  346. 

  347. --
    348. 

  348. -- ???? `se_ikeyw`
    349. 

  349. --
    350. 

  350. 

  351. DROP TABLE IF EXISTS `se_ikeyw`;
    352. 

  352. CREATE TABLE IF NOT EXISTS `se_ikeyw` (
    353. 

  353.   `id` int(6) NOT NULL auto_increment COMMENT 'ID',
    354. 

  354.   `hexid` varchar(40) NOT NULL COMMENT '?HEXID',
    355. 

  355.   `rh` varchar(40) NOT NULL COMMENT 'Rh',
    356. 

  356.   `rl` varchar(40) NOT NULL COMMENT 'Rl',
    357. 

  357.   `wh` varchar(40) NOT NULL COMMENT 'Wh',
    358. 

  358.   `wl` varchar(40) NOT NULL COMMENT 'Wl',
    359. 

  359.   PRIMARY KEY  (`id`),
    360. 

  360.   UNIQUE KEY `hexid` (`hexid`),
    361. 

  361.   UNIQUE KEY `hexid_2` (`hexid`)
    362. 

  362. ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Ikey basecfg ?????' AUTO_INCREMENT=11 ;
    363. 

  363. 

  364. --
    365. 

  365. -- ??????? `se_ikeyw`
    366. 

  366. --
    367. 

  367. 

  368. INSERT INTO `se_ikeyw` (`id`, `hexid`, `rh`, `rl`, `wh`, `wl`) VALUES
    369. 

  369. (1, '60ce077a45b67e6d', '4334f4', '23324f23', 'asdfasdf', 'ff34h45h'),
    370. 

  370. (2, 'ce6b4a096f85e074', '54f34f3f', '54f34f3f', 'asddsfas', 'dsafdfsa'),
    371. 

  371. (3, '1ebc694cd152d8ce', '34t234f4', '234df235', 'tgh67ujj', '353j4567'),
    372. 

  372. (4, 'd190ba69213ea05b', '45123513', '34123134', 'sadsdsdf', '3f55ff34'),
    373. 

  373. (5, '5e1f0b7786dfe6de', 'asdfsadf', 't45gt45', 'asdsfafd', 'asdfasdf'),
    374. 

  374. (6, '82be157193a655db', 'ffffffff', 'ffffffff', 'ffffffff', 'ffffffff'),
    375. 

  375. (7, '', 'ffffffff', 'ffffffff', 'ffffffff', 'ffffffff'),
    376. 

  376. (8, '65480a3856480304', 'asdfasfd', 'asdfasdf', 'asdfasdf', 'asdfasdf'),
    377. 

  377. (9, '3cb6e5de832523fc', 'asdfasfa', 'asdfasdf', 'asdfasfa', 'asdfasfa'),
    378. 

  378. (10, '1344815250d97749', 'ffffffff', 'ffffffff', 'ffffffff', 'ffffffff');
    379. 

  379. 

  380. -- --------------------------------------------------------
    381. 

  381. 

  382. --
    383. 

  383. -- ???? `se_info`
    384. 

  384. --
    385. 

  385. 

  386. DROP TABLE IF EXISTS `se_info`;
    387. 

  387. CREATE TABLE IF NOT EXISTS `se_info` (
    388. 

  388.   `id` int(8) NOT NULL auto_increment,
    389. 

  389.   `bdtid` smallint(5) NOT NULL,
    390. 

  390.   `bdid` int(5) NOT NULL COMMENT 'class_id',
    391. 

  391.   `lg` varchar(10) NOT NULL,
    392. 

  392.   `del` tinyint(1) NOT NULL,
    393. 

  393.   `tid` int(8) NOT NULL COMMENT 'trees_id',
    394. 

  394.   `gid` varchar(20) NOT NULL,
    395. 

  395.   `at` varchar(20) NOT NULL COMMENT 'add_time',
    396. 

  396.   `title` varchar(100) NOT NULL COMMENT '??',
    397. 

  397.   `content` text NOT NULL COMMENT '??',
    398. 

  398.   `address` varchar(100) NOT NULL COMMENT '??',
    399. 

  399.   `zipcode` varchar(20) NOT NULL COMMENT '??',
    400. 

  400.   `phone` varchar(20) NOT NULL COMMENT '??',
    401. 

  401.   `fax` varchar(20) NOT NULL COMMENT '??',
    402. 

  402.   `website` varchar(100) NOT NULL COMMENT '??',
    403. 

  403.   `around` text NOT NULL COMMENT '??',
    404. 

  404.   `mapx` varchar(50) NOT NULL COMMENT '??x',
    405. 

  405.   `mapy` varchar(50) NOT NULL COMMENT '??y',
    406. 

  406.   PRIMARY KEY  (`id`)
    407. 

  407. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    408. 

  408. 

  409. -- --------------------------------------------------------
    410. 

  410. 

  411. --
    412. 

  412. -- ???? `se_news`
    413. 

  413. --
    414. 

  414. 

  415. DROP TABLE IF EXISTS `se_news`;
    416. 

  416. CREATE TABLE IF NOT EXISTS `se_news` (
    417. 

  417.   `id` int(8) NOT NULL auto_increment,
    418. 

  418.   `bdtid` smallint(5) NOT NULL,
    419. 

  419.   `bdid` int(5) NOT NULL COMMENT 'class_id',
    420. 

  420.   `lg` varchar(10) NOT NULL,
    421. 

  421.   `del` tinyint(1) NOT NULL,
    422. 

  422.   `tid` int(8) NOT NULL COMMENT 'trees_id',
    423. 

  423.   `gid` varchar(20) NOT NULL,
    424. 

  424.   `at` varchar(20) NOT NULL COMMENT 'add_time',
    425. 

  425.   `title` varchar(100) NOT NULL COMMENT '??',
    426. 

  426.   `content` text NOT NULL COMMENT '??',
    427. 

  427.   `pic1` varchar(50) NOT NULL COMMENT '??',
    428. 

  428.   `pic2` varchar(50) NOT NULL COMMENT '??',
    429. 

  429.   `hit` int(10) NOT NULL COMMENT '???',
    430. 

  430.   `addtime` varchar(50) NOT NULL COMMENT '????',
    431. 

  431.   `commend` int(5) NOT NULL COMMENT '??',
    432. 

  432.   PRIMARY KEY  (`id`)
    433. 

  433. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    434. 

  434. 

  435. -- --------------------------------------------------------
    436. 

  436. 

  437. --
    438. 

  438. -- ???? `se_news_bak_5pumeuju`
    439. 

  439. --
    440. 

  440. 

  441. DROP TABLE IF EXISTS `se_news_bak_5pumeuju`;
    442. 

  442. CREATE TABLE IF NOT EXISTS `se_news_bak_5pumeuju` (
    443. 

  443.   `id` int(8) NOT NULL auto_increment,
    444. 

  444.   `bdtid` smallint(5) NOT NULL,
    445. 

  445.   `bdid` int(5) NOT NULL COMMENT 'class_id',
    446. 

  446.   `lg` varchar(10) NOT NULL,
    447. 

  447.   `del` tinyint(1) NOT NULL,
    448. 

  448.   `tid` int(8) NOT NULL COMMENT 'trees_id',
    449. 

  449.   `gid` varchar(20) NOT NULL,
    450. 

  450.   `at` varchar(20) NOT NULL COMMENT 'add_time',
    451. 

  451.   PRIMARY KEY  (`id`)
    452. 

  452. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    453. 

  453. 

  454. -- --------------------------------------------------------
    455. 

  455. 

  456. --
    457. 

  457. -- ???? `se_new_bak_g6u8weyh`
    458. 

  458. --
    459. 

  459. 

  460. DROP TABLE IF EXISTS `se_new_bak_g6u8weyh`;
    461. 

  461. CREATE TABLE IF NOT EXISTS `se_new_bak_g6u8weyh` (
    462. 

  462.   `id` int(8) NOT NULL auto_increment,
    463. 

  463.   `bdtid` smallint(5) NOT NULL,
    464. 

  464.   `bdid` int(5) NOT NULL COMMENT 'class_id',
    465. 

  465.   `lg` varchar(10) NOT NULL,
    466. 

  466.   `del` tinyint(1) NOT NULL,
    467. 

  467.   `tid` int(8) NOT NULL COMMENT 'trees_id',
    468. 

  468.   `gid` varchar(20) NOT NULL,
    469. 

  469.   `at` varchar(20) NOT NULL COMMENT 'add_time',
    470. 

  470.   `title` varchar(100) NOT NULL COMMENT '??',
    471. 

  471.   `content` text NOT NULL COMMENT '??',
    472. 

  472.   `pic1` varchar(50) NOT NULL COMMENT '??',
    473. 

  473.   `pic2` varchar(50) NOT NULL COMMENT '??',
    474. 

  474.   `commend` int(5) NOT NULL COMMENT '??',
    475. 

  475.   `hit` int(10) NOT NULL COMMENT '???',
    476. 

  476.   `addtime` varchar(50) NOT NULL COMMENT '????',
    477. 

  477.   PRIMARY KEY  (`id`)
    478. 

  478. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    479. 

  479. 

  480. -- --------------------------------------------------------
    481. 

  481. 

  482. --
    483. 

  483. -- ???? `se_pic`
    484. 

  484. --
    485. 

  485. 

  486. DROP TABLE IF EXISTS `se_pic`;
    487. 

  487. CREATE TABLE IF NOT EXISTS `se_pic` (
    488. 

  488.   `id` int(8) NOT NULL auto_increment,
    489. 

  489.   `bdtid` smallint(5) NOT NULL,
    490. 

  490.   `bdid` int(5) NOT NULL COMMENT 'class_id',
    491. 

  491.   `lg` varchar(10) NOT NULL,
    492. 

  492.   `del` tinyint(1) NOT NULL,
    493. 

  493.   `tid` int(8) NOT NULL COMMENT 'trees_id',
    494. 

  494.   `gid` varchar(20) NOT NULL,
    495. 

  495.   `at` varchar(20) NOT NULL COMMENT 'add_time',
    496. 

  496.   `title` varchar(100) NOT NULL COMMENT '??',
    497. 

  497.   `content` text NOT NULL COMMENT '??',
    498. 

  498.   `pic1` varchar(50) NOT NULL COMMENT '??',
    499. 

  499.   `pic2` varchar(50) NOT NULL COMMENT '??',
    500. 

  500.   `commend` int(5) NOT NULL COMMENT '??',
    501. 

  501.   PRIMARY KEY  (`id`)
    502. 

  502. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    503. 

  503. 

  504. -- --------------------------------------------------------
    505. 

  505. 

  506. --
    507. 

  507. -- ???? `se_room`
    508. 

  508. --
    509. 

  509. 

  510. DROP TABLE IF EXISTS `se_room`;
    511. 

  511. CREATE TABLE IF NOT EXISTS `se_room` (
    512. 

  512.   `id` int(8) NOT NULL auto_increment,
    513. 

  513.   `bdtid` smallint(5) NOT NULL,
    514. 

  514.   `bdid` int(5) NOT NULL COMMENT 'class_id',
    515. 

  515.   `lg` varchar(10) NOT NULL,
    516. 

  516.   `del` tinyint(1) NOT NULL,
    517. 

  517.   `tid` int(8) NOT NULL COMMENT 'trees_id',
    518. 

  518.   `gid` varchar(20) NOT NULL,
    519. 

  519.   `at` varchar(20) NOT NULL COMMENT 'add_time',
    520. 

  520.   `title` varchar(100) NOT NULL COMMENT '??',
    521. 

  521.   `content` text NOT NULL COMMENT '??',
    522. 

  522.   `pic1` varchar(50) NOT NULL COMMENT '??',
    523. 

  523.   `pic2` varchar(50) NOT NULL COMMENT '??',
    524. 

  524.   `price1` varchar(50) NOT NULL COMMENT '??',
    525. 

  525.   `facility` text NOT NULL COMMENT '????',
    526. 

  526.   `commend` int(5) NOT NULL COMMENT '??',
    527. 

  527.   PRIMARY KEY  (`id`)
    528. 

  528. ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
    529. 

  529. 

  530. --
    531. 

  531. -- ??????? `se_room`
    532. 

  532. --
    533. 

  533. 

  534. INSERT INTO `se_room` (`id`, `bdtid`, `bdid`, `lg`, `del`, `tid`, `gid`, `at`, `title`, `content`, `pic1`, `pic2`, `price1`, `facility`, `commend`) VALUES
    535. 

  535. (1, 0, 0, 'zh', 1, 79, '131233828080.27', '1312338296', '', 'sdf', '', '', 'asdf', 'sdf', 0);
    536. 

  536. 

  537. -- --------------------------------------------------------
    538. 

  538. 

  539. --
    540. 

  540. -- ???? `se_room_bak_28kbu7du`
    541. 

  541. --
    542. 

  542. 

  543. DROP TABLE IF EXISTS `se_room_bak_28kbu7du`;
    544. 

  544. CREATE TABLE IF NOT EXISTS `se_room_bak_28kbu7du` (
    545. 

  545.   `id` int(8) NOT NULL auto_increment,
    546. 

  546.   `bdtid` smallint(5) NOT NULL,
    547. 

  547.   `bdid` int(5) NOT NULL COMMENT 'class_id',
    548. 

  548.   `lg` varchar(10) NOT NULL,
    549. 

  549.   `del` tinyint(1) NOT NULL,
    550. 

  550.   `tid` int(8) NOT NULL COMMENT 'trees_id',
    551. 

  551.   `gid` varchar(20) NOT NULL,
    552. 

  552.   `at` varchar(20) NOT NULL COMMENT 'add_time',
    553. 

  553.   PRIMARY KEY  (`id`)
    554. 

  554. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    555. 

  555. 

  556. -- --------------------------------------------------------
    557. 

  557. 

  558. --
    559. 

  559. -- ???? `se_rtp`
    560. 

  560. --
    561. 

  561. 

  562. DROP TABLE IF EXISTS `se_rtp`;
    563. 

  563. CREATE TABLE IF NOT EXISTS `se_rtp` (
    564. 

  564.   `id` int(8) NOT NULL auto_increment,
    565. 

  565.   `bdtid` smallint(5) NOT NULL,
    566. 

  566.   `bdid` int(5) NOT NULL COMMENT 'class_id',
    567. 

  567.   `lg` varchar(10) NOT NULL,
    568. 

  568.   `del` tinyint(1) NOT NULL,
    569. 

  569.   `tid` int(8) NOT NULL COMMENT 'trees_id',
    570. 

  570.   `gid` varchar(20) NOT NULL,
    571. 

  571.   `tt` varchar(80) NOT NULL COMMENT 'title',
    572. 

  572.   `at` varchar(20) NOT NULL COMMENT 'add_time',
    573. 

  573.   `ct` text NOT NULL COMMENT 'content',
    574. 

  574.   `cfg` text NOT NULL COMMENT 'cfg',
    575. 

  575.   PRIMARY KEY  (`id`)
    576. 

  576. ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
    577. 

  577. 

  578. --
    579. 

  579. -- ??????? `se_rtp`
    580. 

  580. --
    581. 

  581. 

  582. INSERT INTO `se_rtp` (`id`, `bdtid`, `bdid`, `lg`, `del`, `tid`, `gid`, `tt`, `at`, `ct`, `cfg`) VALUES
    583. 

  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. 

  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. 

  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. 

  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. 

  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. 

  588. 

  589. -- --------------------------------------------------------
    590. 

  590. 

  591. --
    592. 

  592. -- ???? `se_seo`
    593. 

  593. --
    594. 

  594. 

  595. DROP TABLE IF EXISTS `se_seo`;
    596. 

  596. CREATE TABLE IF NOT EXISTS `se_seo` (
    597. 

  597.   `id` int(8) NOT NULL auto_increment,
    598. 

  598.   `bdtid` smallint(5) NOT NULL,
    599. 

  599.   `bdid` int(5) NOT NULL COMMENT 'class_id',
    600. 

  600.   `lg` varchar(10) NOT NULL,
    601. 

  601.   `del` tinyint(1) NOT NULL,
    602. 

  602.   `tid` int(8) NOT NULL COMMENT 'trees_id',
    603. 

  603.   `gid` varchar(20) NOT NULL,
    604. 

  604.   `at` varchar(20) NOT NULL COMMENT 'add_time',
    605. 

  605.   `title` text NOT NULL COMMENT '??',
    606. 

  606.   `keywords` text NOT NULL COMMENT '???',
    607. 

  607.   `description` text NOT NULL COMMENT '??',
    608. 

  608.   `name` text NOT NULL COMMENT '???',
    609. 

  609.   PRIMARY KEY  (`id`)
    610. 

  610. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    611. 

  611. 

  612. -- --------------------------------------------------------
    613. 

  613. 

  614. --
    615. 

  615. -- ???? `se_tree`
    616. 

  616. --
    617. 

  617. 

  618. DROP TABLE IF EXISTS `se_tree`;
    619. 

  619. CREATE TABLE IF NOT EXISTS `se_tree` (
    620. 

  620.   `id` smallint(5) unsigned NOT NULL auto_increment,
    621. 

  621.   `user` smallint(5) NOT NULL,
    622. 

  622.   `title` varchar(50) NOT NULL,
    623. 

  623.   `parentid` smallint(5) NOT NULL,
    624. 

  624.   `leaf` smallint(1) NOT NULL default '0',
    625. 

  625.   `px` int(6) NOT NULL,
    626. 

  626.   `cls` varchar(60) NOT NULL,
    627. 

  627.   `table` int(5) NOT NULL,
    628. 

  628.   `is_expand` tinyint(1) NOT NULL,
    629. 

  629.   `expand` varchar(50) NOT NULL,
    630. 

  630.   `shield_add` tinyint(1) NOT NULL,
    631. 

  631.   `shield_edit` tinyint(1) NOT NULL,
    632. 

  632.   `shield_del` tinyint(1) NOT NULL,
    633. 

  633.   `is_show` tinyint(1) NOT NULL,
    634. 

  634.   `power` int(2) NOT NULL,
    635. 

  635.   `url` text NOT NULL,
    636. 

  636.   `sortid` int(10) NOT NULL default '1',
    637. 

  637.   `del` smallint(1) NOT NULL,
    638. 

  638.   `config` text NOT NULL,
    639. 

  639.   PRIMARY KEY  (`id`)
    640. 

  640. ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=84 ;
    641. 

  641. 

  642. --
    643. 

  643. -- ??????? `se_tree`
    644. 

  644. --
    645. 

  645. 

  646. INSERT 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. 

  647. (62, 0, '????', 0, 0, 3, 'sucaiwcom92350hwz.png', 0, 0, '', 0, 0, 0, 1, 0, '', 1, 0, '{"lg":""}'),
    648. 

  648. (63, 0, '????', 62, 1, 2, 'page_user.gif', 6, 0, '', 1, 1, 1, 1, 0, '', 1, 0, '{"lg":""}'),
    649. 

  649. (64, 0, '????', 62, 1, 3, 'sucaiwcom94050hmf.png', 7, 0, '', 1, 1, 1, 1, 0, '', 1, 0, '{"lg":""}'),
    650. 

  650. (65, 0, '????', 0, 0, 1, 'default', 0, 0, '', 1, 1, 1, 1, 0, '', 1, 0, '{"lg":""}'),
    651. 

  651. (66, 0, '??', 65, 0, 1, 'default', 8, 0, '', 1, 1, 1, 1, 0, '', 1, 0, '{"lg":""}'),
    652. 

  652. (67, 0, '??', 65, 0, 2, 'default', 0, 0, '', 1, 1, 1, 1, 0, '', 1, 1, '{"lg":""}'),
    653. 

  653. (68, 0, '??', 65, 0, 3, 'default', 0, 0, '', 1, 1, 1, 1, 0, '', 1, 1, '{"lg":""}'),
    654. 

  654. (69, 0, '??', 65, 0, 4, 'default', 0, 0, '', 1, 1, 1, 1, 0, '', 1, 1, '{"lg":""}'),
    655. 

  655. (70, 0, '????', 65, 0, 8, 'default', 0, 0, '', 1, 1, 1, 1, 0, '', 1, 1, '{"lg":""}'),
    656. 

  656. (71, 0, '??', 65, 0, 5, 'default', 0, 0, '', 1, 1, 1, 1, 0, '', 1, 1, '{"lg":""}'),
    657. 

  657. (72, 0, '????', 65, 0, 9, 'default', 0, 0, '', 1, 1, 1, 1, 0, '', 1, 0, '{"lg":""}'),
    658. 

  658. (73, 0, '??', 65, 0, 6, 'default', 0, 0, '', 1, 1, 1, 1, 0, '', 1, 1, '{"lg":""}'),
    659. 

  659. (74, 0, '??', 65, 0, 7, 'default', 0, 0, '', 1, 1, 1, 1, 0, '', 1, 1, '{"lg":""}'),
    660. 

  660. (75, 0, '???', 66, 1, 0, 'default', 15, 0, '', 1, 1, 1, 1, 0, '', 1, 0, '{"lg":""}'),
    661. 

  661. (82, 0, '????', 65, 0, 10, 'default', 0, 0, '', 1, 1, 1, 1, 0, '', 1, 0, '{"lg":""}'),
    662. 

  662. (81, 0, '????', 72, 1, 0, 'default', 12, 0, '', 1, 1, 1, 1, 0, '', 1, 0, '{"lg":""}'),
    663. 

  663. (79, 0, '????', 66, 1, 0, 'default', 14, 0, '80', 1, 1, 1, 1, 0, '', 1, 0, '{"lg":"zh|en"}'),
    664. 

  664. (80, 0, '?????', 66, 1, 0, 'default', 9, 1, '', 1, 1, 1, 0, 0, '', 1, 0, '{"lg":"zh|en"}'),
    665. 

  665. (83, 0, 'SEO', 82, 1, 0, 'default', 16, 0, '', 1, 1, 1, 1, 0, '', 1, 0, '{"lg":""}');
    666. 

  666. 

  667. -- --------------------------------------------------------
    668. 

  668. 

  669. --
    670. 

  670. -- ???? `se_user`
    671. 

  671. --
    672. 

  672. 

  673. DROP TABLE IF EXISTS `se_user`;
    674. 

  674. CREATE TABLE IF NOT EXISTS `se_user` (
    675. 

  675.   `id` int(8) NOT NULL auto_increment,
    676. 

  676.   `bdtid` smallint(5) NOT NULL,
    677. 

  677.   `bdid` int(5) NOT NULL COMMENT 'class_id',
    678. 

  678.   `lg` varchar(10) NOT NULL,
    679. 

  679.   `del` tinyint(1) NOT NULL,
    680. 

  680.   `tid` int(8) NOT NULL COMMENT 'trees_id',
    681. 

  681.   `gid` varchar(20) NOT NULL,
    682. 

  682.   `tt` varchar(80) NOT NULL COMMENT 'title',
    683. 

  683.   `at` varchar(20) NOT NULL COMMENT 'add_time',
    684. 

  684.   `ct` text NOT NULL COMMENT 'content',
    685. 

  685.   `user` varchar(20) NOT NULL COMMENT '???',
    686. 

  686.   `psw` varchar(50) NOT NULL COMMENT '??',
    687. 

  687.   `name` varchar(20) NOT NULL COMMENT '????',
    688. 

  688.   `sex` varchar(20) NOT NULL COMMENT '??',
    689. 

  689.   `sheng` varchar(20) NOT NULL COMMENT '?',
    690. 

  690.   `shi` varchar(20) NOT NULL COMMENT '?',
    691. 

  691.   `xian` varchar(20) NOT NULL COMMENT '?',
    692. 

  692.   `tel` varchar(100) NOT NULL,
    693. 

  693.   `email` varchar(100) NOT NULL,
    694. 

  694.   `homepage` varchar(100) NOT NULL,
    695. 

  695.   `mobile` varchar(100) NOT NULL,
    696. 

  696.   `instro` text NOT NULL COMMENT '??',
    697. 

  697.   `gongs` varchar(50) NOT NULL COMMENT '???',
    698. 

  698.   `zhiw` varchar(100) NOT NULL COMMENT '??',
    699. 

  699.   `gsjs` text NOT NULL COMMENT '????',
    700. 

  700.   `usertype` varchar(20) NOT NULL COMMENT '????',
    701. 

  701.   `rcfg` text NOT NULL COMMENT '????',
    702. 

  702.   `hexid` varchar(50) NOT NULL COMMENT '?ID',
    703. 

  703.   PRIMARY KEY  (`id`)
    704. 

  704. ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=29 ;
    705. 

  705. 

  706. --
    707. 

  707. -- ??????? `se_user`
    708. 

  708. --
    709. 

  709. 

  710. INSERT 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. 

  711. (7, 0, 0, 'zh', 0, 63, '128385263648', '', '1286594882', '', 'a', '0cc175b9c0f1b6a831c399e269772661', '???', '1', '', '', '', '', '', '', '', '', '???1', '', '', '????', '1', ''),
    712. 

  712. (24, 0, 0, '', 0, 0, '', '', '', '????', 'yiming', 'e1a199efdeb9ddef71b851748085e7eb', '???', '', '', '', '', '15109886055', '657342075@qq.com', '', '', '', '', '', '', '', '', ''),
    713. 

  713. (25, 0, 0, 'zh', 0, 63, '128937351541.53', '', '1290842242', '', 'root', '63a9f0ea7bb98050796b649e85481845', '???', '', '', '', '', '', '', '', '', '', '', '', '', '??', '3', ''),
    714. 

  714. (26, 0, 0, '', 0, 0, '', '', '', '????', '15808930776', '668ffb0f7bec7eed48fe1f6733195729', '???', '', '', '', '', '15808930776', '337382080@qq.com', '', '', '', '', '', '', '', '', ''),
    715. 

  715. (27, 0, 0, '', 0, 0, '', '', '', '????', '13976506938', '413f418b8fb0b0af970eec1750498c51', '???', '', '', '', '', '13976506938', '284776872@qq.com', '', '', '', '', '', '', '', '', ''),
    716. 

  716. (28, 0, 0, '', 0, 0, '', '', '', '123', '15109886055', 'e1a199efdeb9ddef71b851748085e7eb', '??', '', '', '', '', '15109886055', 'yunqing__19@163.com', '', '', '', '', '', '', '', '', '');
    717. 

  717. 

  718. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
    719. 

  719. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
    720. 

  720. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
    721. 

  721. 

  722. 

  723. CREATE TABLE IF NOT EXISTS `se_price` (
    724. 

  724.   `id` int(11) NOT NULL auto_increment,
    725. 

  725.   `bdb` varchar(100) NOT NULL COMMENT '???',
    726. 

  726.   `bdid` varchar(50) NOT NULL COMMENT '??????gid',
    727. 

  727.   `date` int(11) NOT NULL default '0' COMMENT '??',
    728. 

  728.   `price` int(11) NOT NULL default '0' COMMENT '??',
    729. 

  729.   `room` smallint(3) NOT NULL default '0' COMMENT '???',
    730. 

  730.   `lg` varchar(10) NOT NULL default 'zh',
    731. 

  731.   `del` tinyint(1) NOT NULL default '0',
    732. 

  732.   `gid` varchar(20) NOT NULL,
    733. 

  733.   PRIMARY KEY  (`id`)
    734. 

  734. ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='??--??  ????/?????' AUTO_INCREMENT=563631 ;# MySQL ????????? (???)?
    735. 

  735. 

  736. --
    737. 

  737. -- ???? `se_log`
    738. 

  738. --
    739. 

  739. 

  740. CREATE TABLE `se_log` (
    741. 

  741.   `id` int(8) NOT NULL auto_increment,
    742. 

  742.   `bdtid` smallint(5) NOT NULL,
    743. 

  743.   `bdid` int(5) NOT NULL COMMENT 'class_id',
    744. 

  744.   `lg` varchar(10) NOT NULL,
    745. 

  745.   `del` tinyint(1) NOT NULL,
    746. 

  746.   `tid` int(8) NOT NULL COMMENT 'trees_id',
    747. 

  747.   `gid` varchar(20) NOT NULL,
    748. 

  748.   `at` varchar(20) NOT NULL COMMENT 'add_time',
    749. 

  749.   `username` varchar(100) NOT NULL COMMENT '???',
    750. 

  750.   `optime` varchar(100) NOT NULL COMMENT '????',
    751. 

  751.   `ip` varchar(100) NOT NULL COMMENT 'IP??',
    752. 

  752.   `opp` varchar(100) NOT NULL COMMENT '??',
    753. 

  753.   `optid` text NOT NULL COMMENT '???tid',
    754. 

  754.   `opid` text NOT NULL COMMENT '???id',
    755. 

  755.   `modularname` varchar(100) NOT NULL COMMENT '????',
    756. 

  756.   `log` text NOT NULL COMMENT '????',
    757. 

  757.   PRIMARY KEY  (`id`)
    758. 

  758. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    759.