/*
Navicat MySQL Data Transfer

Source Server         : v9
Source Server Version : 50091
Source Host           : 10.228.134.211:3306
Source Database       : phpsso

Target Server Type    : MYSQL
Target Server Version : 50091
File Encoding         : 936

Date: 2010-09-08 14:13:09
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `ps_admin`
-- ----------------------------
DROP TABLE IF EXISTS `xt_admin`;
CREATE TABLE `xt_admin` (
  `id` smallint(6) NOT NULL auto_increment,
  `username` char(20) NOT NULL,
  `password` char(32) NOT NULL,
  `encrypt` char(6) default NULL,
  `issuper` tinyint(1) default '0',
  `lastlogin` int(10) default NULL,
  `ip` char(15) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM;

-- ----------------------------
-- Table structure for `xt_loves`
-- ----------------------------
DROP TABLE IF EXISTS `xt_loves`;
CREATE TABLE IF NOT EXISTS `xt_loves` (
  `lid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `content` mediumtext NOT NULL,
  `send` char(15) NOT NULL DEFAULT '',
  `pick` char(15) NOT NULL DEFAULT '',
  `postip` char(15) NOT NULL DEFAULT '',
  `postdate` int(10) unsigned NOT NULL DEFAULT '0',
  `icon` tinyint(2) NOT NULL DEFAULT '0',
  `face` tinyint(2) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`lid`),
  KEY `email` (`pick`)
) ENGINE=MyISAM;

-- ----------------------------
-- Table structure for `xt_session`
-- ----------------------------
DROP TABLE IF EXISTS `xt_session`;
CREATE TABLE `xt_session` (
  `sessionid` char(32) NOT NULL,
  `userid` mediumint(8) unsigned NOT NULL default '0',
  `ip` char(15) NOT NULL,
  `lastvisit` int(10) unsigned NOT NULL default '0',
  `roleid` tinyint(3) unsigned default '0',
  `groupid` tinyint(3) unsigned NOT NULL default '0',
  `m` char(20) NOT NULL,
  `c` char(20) NOT NULL,
  `a` char(20) NOT NULL,
  `data` char(255) NOT NULL,
  PRIMARY KEY  (`sessionid`),
  KEY `lastvisit` (`lastvisit`)
) ENGINE=MEMORY;

-- ----------------------------
-- Table structure for `xt_times`
-- ----------------------------
CREATE TABLE IF NOT EXISTS `xt_times` (
  `ip` char(15) NOT NULL,
  `logintime` int(10) unsigned NOT NULL DEFAULT '0',
  `times` tinyint(1) unsigned NOT NULL DEFAULT '0',
  KEY `ip` (`ip`)
) ENGINE=MyISAM;

-- ----------------------------
-- Table structure for `xt_settings`
-- ----------------------------
DROP TABLE IF EXISTS `xt_settings`;
CREATE TABLE `xt_settings` (
  `name` varchar(32) NOT NULL default '',
  `data` text NOT NULL,
  PRIMARY KEY  (`name`)
) ENGINE=MyISAM;

INSERT INTO `xt_settings` VALUES ('site_name', '天智爱墙');
INSERT INTO `xt_settings` VALUES ('meta_keyword', '济南网站建设|济南网站推广|济南建网站|济南网站制作|软件开发|网站制作|服务器维护|服务器制作|在线咨询|济南网站优化|济南3G网站建设|济南手机网站制作|济南手机网站开发');
INSERT INTO `xt_settings` VALUES ('meta_description', '天智软件（http://www.tintsoft.com）是一家以前沿软件开发为主的高新技术企业，主要致力于济南企业建站、济南网站建设、济南网站制作、ERP及CRM技术的研发、运营与服务。');
INSERT INTO `xt_settings` VALUES ('index_page_size', '50');
INSERT INTO `xt_settings` VALUES ('page_size', '20');
INSERT INTO `xt_settings` VALUES ('js_size', '10');
INSERT INTO `xt_settings` VALUES ('js_content_length', '30');
INSERT INTO `xt_settings` VALUES ('denystr', '');