谁能提供下 数据表common_session 的sql 语句啊。

谁能提供下 数据表common_session 的sql 语句啊。

DROP TABLE IF EXISTS pre_common_session;
CREATE TABLE pre_common_session (
  sid char(6) NOT NULL DEFAULT '',
  ip1 tinyint(3) unsigned NOT NULL DEFAULT '0',
  ip2 tinyint(3) unsigned NOT NULL DEFAULT '0',
  ip3 tinyint(3) unsigned NOT NULL DEFAULT '0',
  ip4 tinyint(3) unsigned NOT NULL DEFAULT '0',
  uid mediumint(8) unsigned NOT NULL DEFAULT '0',
  username char(15) NOT NULL DEFAULT '',
  groupid smallint(6) unsigned NOT NULL DEFAULT '0',
  invisible tinyint(1) NOT NULL DEFAULT '0',
  `action` tinyint(1) unsigned NOT NULL DEFAULT '0',
  lastactivity int(10) unsigned NOT NULL DEFAULT '0',
  lastolupdate int(10) unsigned NOT NULL DEFAULT '0',
  fid mediumint(8) unsigned NOT NULL DEFAULT '0',
  tid mediumint(8) unsigned NOT NULL DEFAULT '0',
  UNIQUE KEY sid (sid),
  KEY uid (uid)
) TYPE=HEAP;

红色部分为你的表前缀，如修改过请替换

1314学习网 发表于 2013-3-27 10:02
红色部分为你的表前缀，如修改过请替换

导入了common_session，但是又提示：•[1146] Table 'net28475068.common_syscache' doesn't exist
•[Query] SELECT * FROM common_syscache WHERE cname IN ('ipbanned')

liuliu220803 发表于 2013-3-27 10:10
导入了common_session，但是又提示：•[1146] Table 'net28475068.common_syscache' doesn't exist
...

我在怀疑你是不是清空了数据库

1. 
   
2. DROP TABLE IF EXISTS pre_common_syscache;
   
3. CREATE TABLE pre_common_syscache (
   
4.   cname varchar(32) NOT NULL,
   
5.   ctype tinyint(3) unsigned NOT NULL,
   
6.   dateline int(10) unsigned NOT NULL,
   
7.   `data` mediumblob NOT NULL,
   
8.   PRIMARY KEY (cname)
   
9. ) TYPE=MyISAM;

复制代码