ImpressCMS/impresscms

View on GitHub
htdocs/install/sql/mysql.structure.sql

Summary

Maintainability
Test Coverage

Unexpected spaces found.
Open

  `avatar_name` varchar(100) NOT NULL default '',

Unexpected spaces found.
Open

  `avatar_created` int(10) NOT NULL default '0',

Unexpected spaces found.
Open

  KEY `mod_cat_order` (`conf_modid`, `conf_catid`, `conf_order`)

Unexpected spaces found.
Open

  `avatar_file` varchar(30) NOT NULL default '',

Unexpected spaces found.
Open

  `user_id` mediumint(8) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `pname` varchar(30) default '',

Unexpected spaces found.
Open

  KEY `com_title` (`com_title`(40))

Unexpected spaces found.
Open

  `avatar_id` mediumint(8) unsigned NOT NULL auto_increment,

Unexpected spaces found.
Open

  `com_ip` varchar(15) NOT NULL default '',

Unexpected spaces found.
Open

  `com_title` varchar(255) NOT NULL default '',

Unexpected spaces found.
Open

  `doimage` tinyint(1) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  KEY `com_pid` (`com_pid`),

Unexpected spaces found.
Open

  KEY `com_itemid` (`com_itemid`),

Unexpected spaces found.
Open

  `not_id` mediumint(8) unsigned NOT NULL auto_increment,

Unexpected spaces found.
Open

  `conf_name` varchar(75) NOT NULL default '',

Unexpected spaces found.
Open

  `imgcat_name` varchar(100) NOT NULL default '',

Unexpected spaces found.
Open

  `imgsetimg_id` mediumint(8) unsigned NOT NULL auto_increment,

Unexpected spaces found.
Open

  `mid` smallint(5) unsigned NOT NULL auto_increment,

Unexpected spaces found.
Open

  `avatar_mimetype` varchar(30) NOT NULL default '',

Unexpected spaces found.
Open

  `com_itemid` mediumint(8) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `dosmiley` tinyint(1) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `doxcode` tinyint(1) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  PRIMARY KEY (`page_id`)

Unexpected spaces found.
Open

  KEY `not_event` (`not_event`)

Unexpected spaces found.
Open

  `block_id` mediumint(8) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `conf_id` smallint(5) unsigned NOT NULL auto_increment,

Unexpected spaces found.
Open

  `conf_modid` smallint(5) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `com_pid` mediumint(8) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `imgcat_id` smallint(5) unsigned NOT NULL auto_increment,

Unexpected spaces found.
Open

  `com_created` int(10) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `com_sig` tinyint(1) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  KEY `com_uid` (`com_uid`),

Unexpected spaces found.
Open

  KEY `imgset_refid` (`imgset_refid`)

Unexpected spaces found.
Open

  KEY `not_itemid` (`not_itemid`),

Unexpected spaces found.
Open

  `conf_desc` varchar(255) NOT NULL default '',

Unexpected spaces found.
Open

  `hascomments` tinyint(1) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `imgcat_foldername` varchar(100) default '',

Unexpected spaces found.
Open

  `hasadmin` tinyint(1) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `ipf` tinyint(1) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `content` text NOT NULL,

Unexpected spaces found.
Open

  `avatar_display` tinyint(1) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  PRIMARY KEY (`avatar_id`),

Unexpected spaces found.
Open

  `com_rootid` mediumint(8) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `id` int(11) NOT NULL auto_increment,

Unexpected spaces found.
Open

  `com_status` tinyint(1) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  KEY `module_id` (`module_id`),

Unexpected spaces found.
Open

  `com_exparams` varchar(255) NOT NULL default '',

Unexpected spaces found.
Open

  `dobr` tinyint(1) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `group_type` varchar(10) NOT NULL default '',

Unexpected spaces found.
Open

  `image_name` varchar(30) NOT NULL default '',

Unexpected spaces found.
Open

  `not_event` varchar(30) NOT NULL default '',

Unexpected spaces found.
Open

  PRIMARY KEY (`not_id`),

Unexpected spaces found.
Open

  `image_weight` smallint(5) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `conf_valuetype` varchar(10) NOT NULL default '',

Unexpected spaces found.
Open

  `confop_id` mediumint(8) unsigned NOT NULL auto_increment,

Unexpected spaces found.
Open

  `name` varchar(50) NOT NULL default '',

Unexpected spaces found.
Open

  KEY `imgcat_id` (`imgcat_id`),

Unexpected spaces found.
Open

  `version` varchar(20) NOT NULL default '00.00.00',

Unexpected spaces found.
Open

  `name` varchar(150) NOT NULL default '',

Unexpected spaces found.
Open

  `avatar_weight` smallint(5) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  KEY `avatar_type` (`avatar_type`,`avatar_display`)

Unexpected spaces found.
Open

  `com_id` mediumint(8) unsigned NOT NULL auto_increment,

Unexpected spaces found.
Open

  `conf_formtype` varchar(15) NOT NULL default '',

Unexpected spaces found.
Open

  `image_created` int(10) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `imgcat_type` char(1) NOT NULL default '',

Unexpected spaces found.
Open

  `description` text,

Unexpected spaces found.
Open

  `block_default` int(1) NOT NULL default '0',

Unexpected spaces found.
Open

  KEY `not_class` (`not_category`),

Unexpected spaces found.
Open

  PRIMARY KEY (`conf_id`),

Unexpected spaces found.
Open

  `linkid` mediumint(8) unsigned NOT NULL auto_increment,

Unexpected spaces found.
Open

  PRIMARY KEY (`image_id`),

Unexpected spaces found.
Open

  `imgcat_display` tinyint(1) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `imgcat_storetype` varchar(5) NOT NULL default '',

Unexpected spaces found.
Open

  KEY `imgcat_display` (`imgcat_display`)

Unexpected spaces found.
Open

  `imgset_name` varchar(50) NOT NULL default '',

Unexpected spaces found.
Open

  `isactive` tinyint(1) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `hasnotification` tinyint(1) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  KEY `dirname` (`dirname`(5)),

Unexpected spaces found.
Open

  `title` varchar(90) NOT NULL default '',

Unexpected spaces found.
Open

  KEY `block_id` (`block_id`)

Unexpected spaces found.
Open

  `com_icon` varchar(25) NOT NULL default '',

Unexpected spaces found.
Open

  `not_modid` smallint(5) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `gperm_groupid` smallint(5) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  KEY `groupid_uid` (`groupid`, `uid`)

Unexpected spaces found.
Open

  `imgcat_id` smallint(5) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  KEY `image_display` (`image_display`)

Unexpected spaces found.
Open

  `dirname` varchar(25) NOT NULL default '',

Unexpected spaces found.
Open

  `avatar_type` char(1) NOT NULL default '',

Unexpected spaces found.
Open

  `page_url` varchar(255) NOT NULL default '',

Unexpected spaces found.
Open

  `not_uid` mediumint(8) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `not_mode` tinyint(1) NOT NULL default 0,

Unexpected spaces found.
Open

  `confcat_id` smallint(5) unsigned NOT NULL auto_increment,

Unexpected spaces found.
Open

  PRIMARY KEY (`confcat_id`)

Unexpected spaces found.
Open

  `confop_value` varchar(255) NOT NULL default '',

Unexpected spaces found.
Open

  PRIMARY KEY (`groupid`),

Unexpected spaces found.
Open

  `gperm_id` int(10) unsigned NOT NULL auto_increment,

Unexpected spaces found.
Open

  KEY `avatar_user_id` (`avatar_id`,`user_id`)

Unexpected spaces found.
Open

  `image_mimetype` varchar(30) NOT NULL default '',

Unexpected spaces found.
Open

  `block_type` varchar(1) NOT NULL default 'L',

Unexpected spaces found.
Open

  PRIMARY KEY (`imgcat_id`),

Unexpected spaces found.
Open

  `page_moduleid` mediumint(8) unsigned NOT NULL default '1',

Unexpected spaces found.
Open

  `imgsetimg_imgset` smallint(5) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `page_title` varchar(255) NOT NULL default '',

Unexpected spaces found.
Open

  `last_update` int(10) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `gperm_itemid` mediumint(8) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  KEY `rankminrankmaxranspecial` (`rank_min`, `rank_max`, `rank_special`),

Unexpected spaces found.
Open

  `groupid` smallint(5) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `image_id` mediumint(8) unsigned NOT NULL auto_increment,

Unexpected spaces found.
Open

  `image_id` mediumint(8) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `image_body` mediumblob,

Unexpected spaces found.
Open

  `imgcat_pid` smallint(5) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `imgcat_maxheight` smallint(3) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `imgcat_weight` smallint(3) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `imgset_refid` mediumint(8) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  KEY `tplset_name` (`tplset_name`(10))

Unexpected spaces found.
Open

  `bid` mediumint(8) unsigned NOT NULL auto_increment,

Unexpected spaces found.
Open

  `options` varchar(255) NOT NULL default '',

Unexpected spaces found.
Open

  `rank_special` tinyint(1) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `avatar_id` mediumint(8) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `page_id` smallint(5) NOT NULL default '0',

Unexpected spaces found.
Open

  `com_modid` smallint(5) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `com_uid` mediumint(8) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `dohtml` tinyint(1) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `conf_title` varchar(255) NOT NULL default '',

Unexpected spaces found.
Open

  `conf_order` smallint(5) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `confop_name` varchar(255) NOT NULL default '',

Unexpected spaces found.
Open

  `imgsetimg_body` blob NOT NULL,

Unexpected spaces found.
Open

  `modname` varchar(25) NOT NULL default '',

Unexpected spaces found.
Open

  `mid` smallint(5) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `func_num` tinyint(3) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `side` tinyint(1) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `template` varchar(50) NOT NULL default '',

Unexpected spaces found.
Open

  `module_id` smallint(5) NOT NULL default '0',

Unexpected spaces found.
Open

  `com_modified` int(10) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  PRIMARY KEY (`com_id`),

Unexpected spaces found.
Open

  `not_category` varchar(30) NOT NULL default '',

Unexpected spaces found.
Open

  KEY `not_uid` (`not_uid`),

Unexpected spaces found.
Open

  `conf_catid` smallint(5) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  KEY `group_type` (`group_type`)

Unexpected spaces found.
Open

  `imgcat_maxwidth` smallint(3) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `dbversion` int(11) unsigned NOT NULL default '1',

Unexpected spaces found.
Open

  `tpl_module` varchar(25) NOT NULL default '',

Unexpected spaces found.
Open

  `email` varchar(255) NOT NULL default '',

Unexpected spaces found.
Open

  `bio` tinytext NOT NULL,

Unexpected spaces found.
Open

  PRIMARY KEY (`uid`),

Unexpected spaces found.
Open

  `client_id` varchar(100) NOT NULL default '',

Unexpected spaces found.
Open

  `sat_repeat` int(11) NOT NULL,

Unexpected spaces found.
Open

  PRIMARY KEY (`id`)

Unexpected spaces found.
Open

  `com_text` text NOT NULL,

Unexpected spaces found.
Open

  `page_id` mediumint(8) unsigned NOT NULL auto_increment,

Unexpected spaces found.
Open

  `page_status` tinyint(1) unsigned NOT NULL default '1',

Unexpected spaces found.
Open

  `conf_value` text NOT NULL,

Unexpected spaces found.
Open

  `confcat_order` smallint(5) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `groupid` smallint(5) unsigned NOT NULL auto_increment,

Unexpected spaces found.
Open

  `image_display` tinyint(1) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  KEY `image_id` (`image_id`)

Unexpected spaces found.
Open

  `imgset_id` smallint(5) unsigned NOT NULL auto_increment,

Unexpected spaces found.
Open

  `tplset_name` varchar(50) NOT NULL default '',

Unexpected spaces found.
Open

  `weight` smallint(3) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `show_func` varchar(50) NOT NULL default '',

Unexpected spaces found.
Open

  `from_userid` mediumint(8) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `tplset_name` varchar(50) NOT NULL default '',

Unexpected spaces found.
Open

  PRIMARY KEY (`tpl_id`),

Unexpected spaces found.
Open

  `attachsig` tinyint(1) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `level` varchar(3) NOT NULL default '1',

Unexpected spaces found.
Open

  `pass_expired` tinyint(1) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `uid` int(11) NOT NULL,

Unexpected spaces found.
Open

  `not_itemid` mediumint(8) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  KEY `conf_id` (`conf_id`)

Unexpected spaces found.
Open

  `gperm_modid` smallint(5) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `gperm_name` varchar(50) NOT NULL default '',

Unexpected spaces found.
Open

  PRIMARY KEY (`gperm_id`),

Unexpected spaces found.
Open

  `uid` mediumint(8) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `image_nicename` varchar(255) NOT NULL default '',

Unexpected spaces found.
Open

  PRIMARY KEY (`imgset_id`),

Unexpected spaces found.
Open

  `hasmain` tinyint(1) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `hassearch` tinyint(1) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  PRIMARY KEY (`mid`),

Unexpected spaces found.
Open

  `title` varchar(255) NOT NULL default '',

Unexpected spaces found.
Open

  KEY `visible` (`visible`),

Unexpected spaces found.
Open

  KEY `mid_funcnum` (`mid`, `func_num`)

Unexpected spaces found.
Open

  KEY `rank_max` (`rank_max`),

Unexpected spaces found.
Open

  `sess_id` varchar(32) NOT NULL default '',

Unexpected spaces found.
Open

  `actkey` varchar(8) NOT NULL default '',

Unexpected spaces found.
Open

  `customtagid` int(11) unsigned NOT NULL auto_increment,

Unexpected spaces found.
Open

  `slot` varchar(12) NOT NULL default '',

Unexpected spaces found.
Open

  `itemid` int(11) NOT NULL,

Unexpected spaces found.
Open

  `sat_code` text NOT NULL,

Unexpected spaces found.
Open

  KEY `not_modid` (`not_modid`),

Unexpected spaces found.
Open

  `confcat_name` varchar(255) NOT NULL default '',

Unexpected spaces found.
Open

  PRIMARY KEY (`confop_id`),

Unexpected spaces found.
Open

  `description` text NOT NULL,

Unexpected spaces found.
Open

  PRIMARY KEY (`linkid`),

Unexpected spaces found.
Open

  PRIMARY KEY (`imgsetimg_id`),

Unexpected spaces found.
Open

  KEY `imgsetimg_imgset` (`imgsetimg_imgset`)

Unexpected spaces found.
Open

  `hasconfig` tinyint(1) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  KEY `active_main_weight` (`isactive`, `hasmain`, `weight`)

Unexpected spaces found.
Open

  `name` varchar(150) NOT NULL default '',

Unexpected spaces found.
Open

  `block_type` char(1) NOT NULL default '',

Unexpected spaces found.
Open

  KEY `mid` (`mid`),

Unexpected spaces found.
Open

  KEY `isactive_visible_mid` (`isactive`, `visible`, `mid`),

Unexpected spaces found.
Open

  KEY `online_module` (`online_module`)

Unexpected spaces found.
Open

  `url` varchar(255) NOT NULL default '',

Unexpected spaces found.
Open

  `user_regdate` int(10) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `user_msnm` varchar(100) NOT NULL default '',

Unexpected spaces found.
Open

  UNIQUE KEY `login_name` (`login_name`(10))

Unexpected spaces found.
Open

  `invite_id` mediumint(8) unsigned NOT NULL auto_increment,

Unexpected spaces found.
Open

  `invite_code` varchar(8) NOT NULL DEFAULT '',

Unexpected spaces found.
Open

  `invite_date` int(10) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `view_date` int(10) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  KEY `register_id` (`register_id`)

Unexpected spaces found.
Open

  `color_border` varchar(6) NOT NULL default '',

Unexpected spaces found.
Open

  `color_text` varchar(6) NOT NULL default '',

Unexpected spaces found.
Open

  `item` VARCHAR(255) NOT NULL,

Unexpected spaces found.
Open

  `rate` int(1) NOT NULL,

Unexpected spaces found.
Open

  PRIMARY KEY (`ratingid`)

Unexpected spaces found.
Open

  `sat_type` varchar(100) NOT NULL DEFAULT 'custom',

Unexpected spaces found.
Open

  `caption` varchar(255) NOT NULL,

Unexpected spaces found.
Open

  `url` varchar(255) NOT NULL,

Unexpected spaces found.
Open

  `online_ip` varchar(15) NOT NULL default '',

Unexpected spaces found.
Open

  `msg_text` text NOT NULL,

Unexpected spaces found.
Open

  `rank_title` varchar(50) NOT NULL default '',

Unexpected spaces found.
Open

  `rank_min` mediumint(8) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `rank_image` varchar(255) default NULL,

Unexpected spaces found.
Open

  `sess_data` text NOT NULL,

Unexpected spaces found.
Open

  `id` smallint(5) unsigned NOT NULL auto_increment,

Unexpected spaces found.
Open

  `tpl_id` mediumint(7) unsigned NOT NULL auto_increment,

Unexpected spaces found.
Open

  `tpl_lastmodified` int(10) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `user_viewemail` tinyint(1) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `posts` mediumint(8) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `uorder` tinyint(1) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `from_id` mediumint(8) unsigned NOT NULL DEFAULT 0,

Unexpected spaces found.
Open

  `types` text NOT NULL,

Unexpected spaces found.
Open

  `name` varchar(255) NOT NULL default '',

Unexpected spaces found.
Open

  PRIMARY KEY (`adsenseid`)

Unexpected spaces found.
Open

  `dirname` varchar(50) NOT NULL default '',

Unexpected spaces found.
Open

  `online_uid` mediumint(8) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `online_updated` int(10) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `online_module` smallint(5) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  KEY `msgidfromuserid` (`msg_id`, `from_userid`)

Unexpected spaces found.
Open

  `rank_id` smallint(5) unsigned NOT NULL auto_increment,

Unexpected spaces found.
Open

  `sess_ip` varchar(64) NOT NULL default '',

Unexpected spaces found.
Open

  `emotion` varchar(75) NOT NULL default '',

Unexpected spaces found.
Open

  `tplset_credits` text NOT NULL,

Unexpected spaces found.
Open

  PRIMARY KEY (`tplset_id`)

Unexpected spaces found.
Open

  `notify_method` tinyint(1) NOT NULL default '1',

Unexpected spaces found.
Open

  `user_occ` varchar(100) NOT NULL default '',

Unexpected spaces found.
Open

  PRIMARY KEY (`invite_id`),

Unexpected spaces found.
Open

  `customtag_content` text NOT NULL,

Unexpected spaces found.
Open

  `mimetypeid` int(11) NOT NULL auto_increment,

Unexpected spaces found.
Open

  `color_link` varchar(6) NOT NULL default '',

Unexpected spaces found.
Open

  `description` varchar(255) NOT NULL,

Unexpected spaces found.
Open

  `fileid` int(10) unsigned NOT NULL AUTO_INCREMENT,

Unexpected spaces found.
Open

  `edit_func` varchar(50) NOT NULL default '',

Unexpected spaces found.
Open

  KEY `touseridreadmsg` (`to_userid`, `read_msg`),

Unexpected spaces found.
Open

  KEY `rankspecial` (`rank_special`)

Unexpected spaces found.
Open

  PRIMARY KEY (`id`)

Unexpected spaces found.
Open

  `tpl_refid` smallint(5) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `tpl_id` mediumint(7) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `tpl_source` mediumtext NOT NULL,

Unexpected spaces found.
Open

  KEY `tpl_id` (`tpl_id`)

Unexpected spaces found.
Open

  `uname` varchar(255) NOT NULL default '',

Unexpected spaces found.
Open

  `user_from` varchar(100) NOT NULL default '',

Unexpected spaces found.
Open

  `user_yim` varchar(25) NOT NULL default '',

Unexpected spaces found.
Open

  `language` varchar(100) NOT NULL default '',

Unexpected spaces found.
Open

  KEY `sat_type` (`sat_type`)

Unexpected spaces found.
Open

  `urllinkid` int(10) unsigned NOT NULL AUTO_INCREMENT,

Unexpected spaces found.
Open

  `conf_id` smallint(5) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  KEY `name_mod_group` (`gperm_name`(10), `gperm_modid`, `gperm_groupid`)

Unexpected spaces found.
Open

  `imgcat_maxsize` int(8) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `imgset_id` smallint(5) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `imgsetimg_file` varchar(50) NOT NULL default '',

Unexpected spaces found.
Open

  `c_type` char(1) NOT NULL default '',

Unexpected spaces found.
Open

  `read_msg` tinyint(1) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  PRIMARY KEY (`rank_id`),

Unexpected spaces found.
Open

  `tpl_type` varchar(20) NOT NULL default '',

Unexpected spaces found.
Open

  KEY `tpl_refid` (`tpl_refid`, `tpl_type`),

Unexpected spaces found.
Open

  `last_login` int(10) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `tag` varchar(50) NOT NULL default '',

Unexpected spaces found.
Open

  `sat_name` varchar(255) NOT NULL,

Unexpected spaces found.
Open

  `sat_onfinish` smallint(2) NOT NULL,

Unexpected spaces found.
Open

  PRIMARY KEY (`sat_id`),

Unexpected spaces found.
Open

  `mid` smallint(5) unsigned NOT NULL,

Unexpected spaces found.
Open

  KEY `mid` (`mid`)

Unexpected spaces found.
Open

  `bcachetime` int(10) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `msg_time` int(10) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  KEY `updated` (`sess_updated`)

Unexpected spaces found.
Open

  `code` varchar(50) NOT NULL default '',

Unexpected spaces found.
Open

  `tplset_desc` varchar(255) NOT NULL default '',

Unexpected spaces found.
Open

  `tplset_created` int(10) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `tpl_lastimported` int(10) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `subject` varchar(255) NOT NULL default '',

Unexpected spaces found.
Open

  `to_userid` mediumint(8) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `rank_max` mediumint(8) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  KEY `tpl_tplset` (`tpl_tplset`, `tpl_file`(10))

Unexpected spaces found.
Open

  `umode` varchar(10) NOT NULL default '',

Unexpected spaces found.
Open

  `theme` varchar(100) NOT NULL default '',

Unexpected spaces found.
Open

  `enc_type` tinyint(2) unsigned NOT NULL default '1',

Unexpected spaces found.
Open

  `timezone_offset` float(3,1) NOT NULL default '0.0',

Unexpected spaces found.
Open

  `user_intrest` varchar(150) NOT NULL default '',

Unexpected spaces found.
Open

  `name` varchar(255) NOT NULL default '',

Unexpected spaces found.
Open

  KEY `mimetypeid` (`mimetypeid`)

Unexpected spaces found.
Open

  `sat_id` int(10) unsigned NOT NULL AUTO_INCREMENT,

Unexpected spaces found.
Open

  `dirname` VARCHAR(255) NOT NULL,

Unexpected spaces found.
Open

  PRIMARY KEY (`fileid`),

Unexpected spaces found.
Open

  `color_url` varchar(6) NOT NULL default '',

Unexpected spaces found.
Open

  `description` varchar(255) NOT NULL,

Unexpected spaces found.
Open

  `isactive` tinyint(1) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `func_file` varchar(50) NOT NULL default '',

Unexpected spaces found.
Open

  `sess_updated` int(10) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  PRIMARY KEY (`sess_id`),

Unexpected spaces found.
Open

  `uid` mediumint(8) unsigned NOT NULL auto_increment,

Unexpected spaces found.
Open

  `description` text NOT NULL,

Unexpected spaces found.
Open

  `adsenseid` int(11) NOT NULL auto_increment,

Unexpected spaces found.
Open

  `format` VARCHAR(100) NOT NULL,

Unexpected spaces found.
Open

  `user_sig` text NOT NULL,

Unexpected spaces found.
Open

  `salt` varchar(255) NOT NULL default '',

Unexpected spaces found.
Open

  `invite_to` varchar(255) NOT NULL DEFAULT '',

Unexpected spaces found.
Open

  `extra_info` text NOT NULL,

Unexpected spaces found.
Open

  KEY `invite_code` (`invite_code`),

Unexpected spaces found.
Open

  `language` varchar(100) NOT NULL default '',

Unexpected spaces found.
Open

  `customtag_type` tinyint(1) NOT NULL default 0,

Unexpected spaces found.
Open

  `dirname` VARCHAR(255) NOT NULL,

Unexpected spaces found.
Open

  `url` varchar(255) NOT NULL,

Unexpected spaces found.
Open

  `weight` smallint(5) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `online_uname` varchar(25) NOT NULL default '',

Unexpected spaces found.
Open

  `msg_image` varchar(100) default NULL,

Unexpected spaces found.
Open

  `smile_url` varchar(100) NOT NULL default '',

Unexpected spaces found.
Open

  `tpl_file` varchar(50) NOT NULL default '',

Unexpected spaces found.
Open

  `name` varchar(60) NOT NULL default '',

Unexpected spaces found.
Open

  `user_icq` varchar(15) NOT NULL default '',

Unexpected spaces found.
Open

  `user_aim` varchar(18) NOT NULL default '',

Unexpected spaces found.
Open

  `pass` varchar(255) NOT NULL default '',

Unexpected spaces found.
Open

  `notify_mode` tinyint(1) NOT NULL default '0',

Unexpected spaces found.
Open

  PRIMARY KEY (`customtagid`)

Unexpected spaces found.
Open

  `style` TEXT NOT NULL,

Unexpected spaces found.
Open

  `color_background` varchar(6) NOT NULL default '',

Unexpected spaces found.
Open

  `visible` tinyint(1) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `last_modified` int(10) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  `msg_id` mediumint(8) unsigned NOT NULL auto_increment,

Unexpected spaces found.
Open

  `display` tinyint(1) NOT NULL default '0',

Unexpected spaces found.
Open

  `user_mailok` tinyint(1) unsigned NOT NULL default '1',

Unexpected spaces found.
Open

  PRIMARY KEY (`bid`),

Unexpected spaces found.
Open

  `login_name` varchar(255) NOT NULL default '',

Unexpected spaces found.
Open

  `sat_enabled` INT(1) NOT NULL,

Unexpected spaces found.
Open

  PRIMARY KEY (`msg_id`),

Unexpected spaces found.
Open

  `sat_addon_id` int(2) unsigned zerofill DEFAULT NULL,

Unexpected spaces found.
Open

  `tplset_id` int(7) unsigned NOT NULL auto_increment,

Unexpected spaces found.
Open

  KEY `sat_lastruntime` (`sat_lastruntime`),

Unexpected spaces found.
Open

  `tpl_desc` varchar(255) NOT NULL default '',

Unexpected spaces found.
Open

  `target` varchar(6) NOT NULL,

Unexpected spaces found.
Open

  `user_avatar` varchar(30) NOT NULL default 'blank.gif',

Unexpected spaces found.
Open

  `register_id` mediumint(8) unsigned NOT NULL DEFAULT 0,

Unexpected spaces found.
Open

  PRIMARY KEY (`urllinkid`),

Unexpected spaces found.
Open

  KEY `mid` (`mid`)

Unexpected spaces found.
Open

  `description` TEXT NOT NULL,

Unexpected spaces found.
Open

  `caption` varchar(255) NOT NULL,

Unexpected spaces found.
Open

  `ratingid` int(11) NOT NULL auto_increment,

Unexpected spaces found.
Open

  KEY `sat_interval` (`sat_interval`),

Unexpected spaces found.
Open

  `mid` smallint(5) unsigned NOT NULL,

Unexpected spaces found.
Open

  `tpl_tplset` varchar(50) NOT NULL default '',

Unexpected spaces found.
Open

  `rank` smallint(5) unsigned NOT NULL default '0',

Unexpected spaces found.
Open

  KEY `uname` (`uname`(10)),

Unexpected spaces found.
Open

  `extension` varchar(60) NOT NULL default '',

Unexpected spaces found.
Open

  `date` int(11) NOT NULL,

Unexpected spaces found.
Open

  `sat_interval` int(11) NOT NULL,

Unexpected spaces found.
Open

  `sat_lastruntime` int(15) unsigned NOT NULL,

There are no issues that match your filters.

Category
Status