<?php

//安装数据库所有表及须填基础信息
$sqlgv32cms['ad'] = "
CREATE TABLE `".$mysql_prefix."ad` (
  `ad_id` smallint(5) unsigned NOT NULL auto_increment,
  `user_id` int(12) NOT NULL,
  `adp_id` smallint(5) unsigned NOT NULL default '0',
  `ad_mediatype` tinyint(2) unsigned NOT NULL default '1',
  `ad_name` varchar(60) NOT NULL,
  `ad_link` varchar(255) NOT NULL,
  `ad_code` text NOT NULL,
  `ad_starttime` int(11) NOT NULL default '0',
  `ad_endtime` int(11) NOT NULL default '0',
  `ad_linkman` varchar(60) NOT NULL,
  `ad_linkemail` varchar(60) NOT NULL,
  `ad_linkphone` varchar(60) NOT NULL,
  `ad_count` mediumint(8) unsigned NOT NULL default '0',
  `ad_enabled` tinyint(2) unsigned NOT NULL default '1',
  `ad_addtime` int(12) NOT NULL,
  PRIMARY KEY  (`ad_id`),
  KEY `position_id` (`adp_id`),
  KEY `enabled` (`ad_enabled`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
";

$sqlgv32cms['address'] = "
CREATE TABLE `".$mysql_prefix."address` (
  `add_id` int(12) NOT NULL auto_increment,
  `use_id` int(12) unsigned NOT NULL COMMENT '用户ID',
  `add_sex` tinyint(1) unsigned NOT NULL default '0' COMMENT '性别，0保密，1，男，2，女',
  `add_birthday` int(12) NOT NULL,
  `add_phone` varchar(20) NOT NULL COMMENT '家庭电话',
  `add_mobile` varchar(20) NOT NULL COMMENT '手机',
  `add_name` varchar(60) default NULL,
  `add_province` smallint(5) default '0' COMMENT '省',
  `add_city` smallint(5) default '0' COMMENT '市',
  `add_district` smallint(5) default '0' COMMENT '区（县）',
  `add_pcdall` varchar(100) NOT NULL,
  `add_address` varchar(120) default NULL COMMENT '详细地址',
  `add_postalcode` int(10) NOT NULL,
  `add_email` varchar(200) NOT NULL,
  `add_sign` varchar(200) NOT NULL,
  `add_sendtime` smallint(1) NOT NULL,
  `add_enabled` smallint(1) default '1',
  `add_time` int(12) NOT NULL,
  `add_type` smallint(1) NOT NULL default '0',
  PRIMARY KEY  (`add_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
";

 
 
$sqlgv32cms['adposition'] = "
CREATE TABLE `".$mysql_prefix."adposition` (
  `adp_id` tinyint(5) unsigned NOT NULL auto_increment,
  `use_id` int(12) NOT NULL,
  `adp_name` varchar(60) NOT NULL,
  `adp_width` smallint(5) unsigned NOT NULL default '0',
  `adp_height` smallint(5) unsigned NOT NULL default '0',
  `adp_desc` varchar(255) NOT NULL,
  `adp_style` text NOT NULL,
  PRIMARY KEY  (`adp_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
";


$sqlgv32cms['areadict'] = "
CREATE TABLE `".$mysql_prefix."areadict` (
  `are_id` smallint(5) unsigned NOT NULL auto_increment COMMENT '序号ID',
  `are_parentid` smallint(5) unsigned NOT NULL default '0' COMMENT '关联父ID',
  `are_name` varchar(120) NOT NULL COMMENT '地区名称',
  `are_type` tinyint(1) NOT NULL default '2' COMMENT '节点等级',
  `are_locked` smallint(1) NOT NULL default '1' COMMENT '是否锁定',
  PRIMARY KEY  (`are_id`),
  KEY `parent_id` (`are_parentid`),
  KEY `region_type` (`are_type`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 
";

$sqlgv32cms['artlice'] = "
CREATE TABLE `".$mysql_prefix."artlice` (
  `art_id` bigint(24) NOT NULL auto_increment,
  `user_id` int(12) NOT NULL,
  `art_title` varchar(255) NOT NULL,
  `art_pinyin` varchar(200) default NULL,
  `art_author` varchar(50) NOT NULL,
  `ars_id` smallint(10) NOT NULL,
  `art_addtime` int(12) NOT NULL,
  `art_keyword` varchar(255) NOT NULL,
  `art_description` text NOT NULL,
  `art_detail` text NOT NULL,
  `art_pic` varchar(200) NOT NULL,
  `art_file` varchar(200) NOT NULL,
  `art_count` int(12) NOT NULL,
  `art_enabled` smallint(2) NOT NULL,
  `art_begintime` int(12) NOT NULL,
  `art_endtime` int(12) NOT NULL,
  `art_adminid` int(12) NOT NULL,
  `art_list` int(12) NOT NULL default '99999',
  `art_uptime` int(12) NOT NULL,
  `art_sysfile` varchar(20) NOT NULL,
  PRIMARY KEY  (`art_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
";

$sqlgv32cms['artsort'] = "
CREATE TABLE `".$mysql_prefix."artsort` (
  `ars_id` int(10) NOT NULL auto_increment,
  `use_id` int(12) NOT NULL,
  `ars_name` varchar(50) NOT NULL,
  `ars_parentid` int(10) NOT NULL,
  `ars_enabled` smallint(1) NOT NULL default '1',
  `ars_locked` smallint(1) NOT NULL default '1',
  `ars_list` int(10) NOT NULL default '99',
  PRIMARY KEY  (`ars_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
";


$sqlgv32cms['book'] = "
CREATE TABLE `".$mysql_prefix."book` (
  `boo_id` int(10) NOT NULL auto_increment,
  `pro_id` int(12) NOT NULL,
  `use_id` int(12) NOT NULL,
  `boo_name` varchar(100) NOT NULL,
  `boo_phone` varchar(100) NOT NULL,
  `boo_email` varchar(100) NOT NULL,
  `boo_product` varchar(255) NOT NULL,
  `boo_description` text NOT NULL,
  `boo_addtime` int(12) NOT NULL,
  `boo_status` smallint(1) NOT NULL default '0',
  `boo_enabled` smallint(1) NOT NULL default '1',
  `boo_remark` text NOT NULL,
  PRIMARY KEY  (`boo_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
";



$sqlgv32cms['comment'] = "
CREATE TABLE `".$mysql_prefix."comment` (
  `com_id` int(10) unsigned NOT NULL auto_increment,
  `use_id` int(12) NOT NULL,
  `com_type` tinyint(3) unsigned NOT NULL default '0' COMMENT '0产品,1资讯',
  `com_idvalue` mediumint(8) unsigned NOT NULL default '0',
  `com_email` varchar(60) NOT NULL,
  `com_username` varchar(60) NOT NULL,
  `com_content` mediumtext NOT NULL,
  `com_rank` tinyint(1) unsigned NOT NULL default '0',
  `com_addtime` int(10) unsigned NOT NULL default '0',
  `com_ip` varchar(15) NOT NULL,
  `com_status` tinyint(3) unsigned NOT NULL default '0',
  `com_parentid` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`com_id`),
  KEY `parent_id` (`com_parentid`),
  KEY `id_value` (`com_idvalue`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
";


$sqlgv32cms['configsys'] = "
CREATE TABLE `".$mysql_prefix."configsys` (
  `cfs_id` int(12) NOT NULL auto_increment,
  `cfs_name` varchar(255) NOT NULL default '0',
  `cfs_codestr` varchar(15) NOT NULL default '0',
  `cfs_value` varchar(255) NOT NULL default '0',
  `cfs_type` varchar(10) NOT NULL,
  PRIMARY KEY  (`cfs_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
";

$sqlgv32cms['contact'] = "
CREATE TABLE `".$mysql_prefix."contact` (
  `con_id` int(12) NOT NULL auto_increment,
  `cus_id` int(12) NOT NULL,
  `use_idoperate` int(12) NOT NULL,
  `use_idmanager` int(12) NOT NULL,
  `con_name` varchar(100) NOT NULL,
  `con_pinyin` varchar(200) NOT NULL,
  `con_area` varchar(50) NOT NULL,
  `con_address` varchar(255) NOT NULL,
  `con_zip` smallint(10) NOT NULL,
  `con_tel` varchar(50) NOT NULL,
  `con_fax` varchar(50) NOT NULL,
  `con_website` varchar(50) NOT NULL,
  `con_email` varchar(100) NOT NULL,
  `con_losecount` int(5) NOT NULL,
  `con_type` smallint(1) NOT NULL default '1',
  `con_enabled` smallint(1) NOT NULL default '0',
  PRIMARY KEY  (`con_id`),
  KEY `u_idoperate` (`use_idoperate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
";

$sqlgv32cms['customer'] = "
CREATE TABLE `".$mysql_prefix."customer` (
  `cus_id` int(12) NOT NULL auto_increment COMMENT '序号ID',
  `use_idoperate` int(12) NOT NULL COMMENT '分配给用户管理的用户编号',
  `cus_cusname` varchar(100) NOT NULL COMMENT '客户名称',
  `cus_pinyin` varchar(200) NOT NULL COMMENT '客户拼音编码',
  `cus_area` varchar(50) NOT NULL COMMENT '地区',
  `use_idmanager` int(12) NOT NULL COMMENT '客户经理编号',
  `cus_level` smallint(3) NOT NULL COMMENT '客户等级',
  `cus_satisfy` smallint(2) NOT NULL COMMENT '满意度（1-5）默认3',
  `cus_credit` smallint(2) NOT NULL COMMENT '信用度（1-5）默认0',
  `cus_address` varchar(255) NOT NULL COMMENT '地址',
  `cus_zip` smallint(10) NOT NULL COMMENT '邮政编码',
  `cus_tel` varchar(50) NOT NULL COMMENT '电话',
  `cus_fax` varchar(50) NOT NULL COMMENT '传真',
  `cus_website` varchar(50) NOT NULL COMMENT '网址',
  `cus_email` varchar(100) NOT NULL COMMENT '联系邮箱',
  `cus_licence` varchar(50) NOT NULL COMMENT '营业执照注册号',
  `cus_chieftain` varchar(50) NOT NULL COMMENT '法人',
  `cus_bankroll` bigint(24) NOT NULL COMMENT '注册资金',
  `cus_turnover` bigint(24) NOT NULL COMMENT '营业额',
  `cus_bank` varchar(200) NOT NULL COMMENT '开户银行',
  `cus_bankaccount` varchar(50) NOT NULL COMMENT '银行帐号',
  `cus_localtaxno` varchar(50) NOT NULL COMMENT '地税登记号',
  `cus_nationaltaxno` varchar(50) NOT NULL COMMENT '国税登记号',
  `cus_losecount` int(5) NOT NULL COMMENT '联系失败次数',
  `cus_status` smallint(1) NOT NULL default '1' COMMENT '客户状态：1正常;2流失去3删除',
  PRIMARY KEY  (`cus_id`),
  KEY `u_idoperate` (`use_idoperate`),
  KEY `c_cusname` (`cus_cusname`),
  KEY `c_tel` (`cus_tel`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
";


$sqlgv32cms['dept'] = "
CREATE TABLE `".$mysql_prefix."dept` (
  `dep_id` int(10) NOT NULL auto_increment,
  `dep_parentid` int(10) NOT NULL default '0',
  `dep_name` varchar(30) NOT NULL,
  `dep_exttel` varchar(50) NOT NULL,
  `dep_remark` varchar(250) NOT NULL,
  `dep_enabled` smallint(1) NOT NULL default '1',
  `dep_locked` smallint(1) NOT NULL default '1',
  `dep_list` int(10) NOT NULL,
  PRIMARY KEY  (`dep_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
";



$sqlgv32cms['download'] = "
CREATE TABLE `".$mysql_prefix."download` (
  `dow_id` int(12) NOT NULL auto_increment,
  `use_id` int(12) NOT NULL,
  `dow_name` varchar(255) NOT NULL,
  `dow_size` varchar(20) NOT NULL,
  `dow_uptime` int(12) NOT NULL,
  `dow_file` varchar(200) NOT NULL,
  `dow_img` varchar(255) NOT NULL,
  `dow_desc` text NOT NULL,
  `dow_count` int(11) NOT NULL default '0',
  `dow_list` smallint(6) NOT NULL,
  `dow_addtime` int(12) NOT NULL,
  `dow_enabled` smallint(1) NOT NULL default '1',
  PRIMARY KEY  (`dow_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
";


$sqlgv32cms['employ'] = "
CREATE TABLE `".$mysql_prefix."employ` (
  `eml_id` int(10) NOT NULL auto_increment,
  `inv_id` int(12) NOT NULL COMMENT '职位ID',
  `use_id` int(12) NOT NULL,
  `eml_position` varchar(100) NOT NULL,
  `eml_name` varchar(100) NOT NULL,
  `eml_sex` smallint(3) NOT NULL,
  `eml_native` varchar(24) NOT NULL,
  `eml_educational` varchar(100) NOT NULL,
  `eml_age` int(3) NOT NULL,
  `eml_birthday` varchar(10) NOT NULL,
  `eml_school` varchar(100) NOT NULL,
  `eml_startwork` smallint(2) NOT NULL,
  `eml_pay` varchar(100) NOT NULL,
  `eml_year` varchar(10) NOT NULL,
  `eml_marriage` smallint(2) NOT NULL,
  `eml_subject` varchar(100) NOT NULL,
  `eml_phone` varchar(100) NOT NULL,
  `eml_email` varchar(100) NOT NULL,
  `eml_resume` text NOT NULL,
  `eml_enclosure` varchar(200) NOT NULL,
  `eml_enclosurefile` varchar(200) NOT NULL,
  `eml_addtime` int(12) NOT NULL,
  `eml_status` smallint(1) NOT NULL default '0',
  PRIMARY KEY  (`eml_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
";



$sqlgv32cms['employee'] = "
CREATE TABLE `".$mysql_prefix."employee` (
  `use_id` int(12) NOT NULL auto_increment,
  `dep_id` int(10) NOT NULL COMMENT '部门ID',
  `pt_id` int(10) NOT NULL COMMENT '职位ID',
  `r_id` int(12) NOT NULL COMMENT '角色ID',
  `emp_occupation` varchar(30) NOT NULL COMMENT '职称',
  `emp_officephone` varchar(20) NOT NULL,
  `emp_homephone` varchar(20) NOT NULL,
  `emp_mobile` int(11) NOT NULL,
  `emp_homeaddress` varchar(150) NOT NULL,
  `emp_qq` varchar(100) NOT NULL,
  `emp_birthday` varchar(100) NOT NULL,
  `emp_sex` smallint(3) NOT NULL,
  `emp_education` varchar(100) NOT NULL,
  `emp_wage` varchar(100) NOT NULL,
  `emp_duty` varchar(100) NOT NULL,
  `emp_remark` varchar(100) NOT NULL,
  `emp_homepage` varchar(128) NOT NULL,
  `emp_picture` varchar(128) NOT NULL,
  `emp_interest` varchar(255) NOT NULL,
  `emp_signature` varchar(255) NOT NULL,
  `emp_usesig` smallint(1) NOT NULL,
  PRIMARY KEY  (`use_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
";


$sqlgv32cms['express'] = "
CREATE TABLE `".$mysql_prefix."express` (
  `exp_id` int(12) NOT NULL auto_increment,
  `exp_name` varchar(255) NOT NULL,
  `exp_desc` text NOT NULL,
  `exp_price` decimal(28,2) NOT NULL,
  `exp_type` smallint(2) NOT NULL default '0',
  `exp_enabled` smallint(1) NOT NULL,
  PRIMARY KEY  (`exp_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
";

$sqlgv32cms['file'] = "
CREATE TABLE `".$mysql_prefix."file` (
  `fil_id` int(12) NOT NULL auto_increment,
  `use_id` int(12) NOT NULL,
  `fil_dir` varchar(255) NOT NULL,
  `fil_name` varchar(255) NOT NULL,
  `fil_size` int(12) NOT NULL,
  `fil_type` varchar(20) NOT NULL,
  `fil_power` varchar(10) NOT NULL,
  `fil_addtime` varchar(12) NOT NULL,
  `fil_enabled` smallint(1) NOT NULL default '1',
  PRIMARY KEY  (`fil_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
";


$sqlgv32cms['forum'] = "
CREATE TABLE `".$mysql_prefix."forum` (
  `for_id` int(10) NOT NULL auto_increment,
  `use_id` int(12) NOT NULL,
  `for_name` varchar(100) NOT NULL,
  `for_desc` varchar(255) NOT NULL,
  `for_image` varchar(100) NOT NULL,
  `for_list` smallint(5) NOT NULL,
  `for_enabled` smallint(3) NOT NULL default '1',
  PRIMARY KEY  (`for_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
";

$sqlgv32cms['keywork'] = "
CREATE TABLE `".$mysql_prefix."keywork` (
  `key_id` bigint(24) NOT NULL auto_increment,
  `key_word` varchar(255) NOT NULL,
  `key_isup` smallint(2) NOT NULL default '0',
  `key_count` int(10) NOT NULL default '0',
  PRIMARY KEY  (`key_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
";



$sqlgv32cms['invite'] = "
CREATE TABLE `".$mysql_prefix."invite` (
  `inv_id` int(10) NOT NULL auto_increment,
  `use_id` int(12) NOT NULL,
  `inv_position` varchar(100) NOT NULL,
  `inv_num` int(10) NOT NULL,
  `inv_type` varchar(20) NOT NULL,
  `inv_pay` varchar(100) NOT NULL,
  `inv_year` varchar(50) NOT NULL,
  `inv_educational` varchar(100) NOT NULL,
  `inv_sex` smallint(2) NOT NULL,
  `inv_age` smallint(4) NOT NULL,
  `inv_marriage` varchar(100) NOT NULL,
  `inv_subject` varchar(50) NOT NULL,
  `inv_describe` text NOT NULL,
  `inv_requests` text NOT NULL,
  `inv_province` int(10) NOT NULL,
  `inv_city` int(10) NOT NULL,
  `inv_district` int(10) NOT NULL,
  `inv_pcdall` varchar(100) NOT NULL,
  `inv_addtime` int(12) NOT NULL,
  `inv_activetime` int(12) NOT NULL,
  `inv_enabled` smallint(1) NOT NULL default '1',
  PRIMARY KEY  (`inv_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
";



$sqlgv32cms['leaveword'] = "
CREATE TABLE `".$mysql_prefix."leaveword` (
  `lwd_id` mediumint(12) unsigned NOT NULL auto_increment,
  `lwd_parentid` mediumint(12) unsigned NOT NULL default '0',
  `lwd_ip` varchar(16) NOT NULL,
  `use_id` mediumint(12) unsigned NOT NULL default '0',
  `use_name` varchar(60) NOT NULL,
  `use_email` varchar(60) NOT NULL,
  `re_useid` int(12) NOT NULL,
  `lwd_title` varchar(200) NOT NULL,
  `lwd_type` tinyint(1) unsigned NOT NULL default '0',
  `lwd_status` tinyint(1) unsigned NOT NULL default '0',
  `lwd_content` mediumtext NOT NULL,
  `lwd_addtime` int(10) unsigned NOT NULL default '0',
  `lwd_img` varchar(255) NOT NULL,
  `lwd_list` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`lwd_id`),
  KEY `user_id` (`use_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
";





$sqlgv32cms['link'] = "
CREATE TABLE `".$mysql_prefix."link` (
  `lin_id` smallint(5) unsigned NOT NULL auto_increment,
  `use_id` int(12) NOT NULL,
  `lin_name` varchar(100) NOT NULL,
  `lin_url` varchar(200) NOT NULL,
  `lin_logo` varchar(200) NOT NULL,
  `lin_list` int(10) unsigned NOT NULL default '99',
  `lin_enabled` smallint(2) NOT NULL default '1',
  PRIMARY KEY  (`lin_id`),
  KEY `show_order` (`lin_list`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
";




$sqlgv32cms['loginerror'] = "
CREATE TABLE `".$mysql_prefix."loginerror` (
  `error_id` mediumint(8) unsigned NOT NULL auto_increment,
  `user_id` int(12) NOT NULL,
  `session_id` varchar(32) NOT NULL,
  `errorcount` int(10) unsigned NOT NULL default '0',
  `ip_address` varchar(15) NOT NULL default '',
  `start_time` int(12) unsigned NOT NULL default '0',
  `logtype` varchar(5) default NULL,
  PRIMARY KEY  (`error_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
";



$sqlgv32cms['menu'] = "
CREATE TABLE `".$mysql_prefix."menu` (
  `men_id` smallint(2) NOT NULL auto_increment,
  `use_id` int(12) NOT NULL,
  `men_name` varchar(50) NOT NULL,
  `men_powername` varchar(20) NOT NULL,
  `men_file` varchar(255) NOT NULL,
  `men_parentid` smallint(2) NOT NULL,
  `men_enabled` smallint(1) NOT NULL default '1',
  `men_targetval` varchar(30) NOT NULL default '_self',
  `men_list` int(10) NOT NULL,
  `men_type` varchar(3) NOT NULL default 'web',
  PRIMARY KEY  (`men_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
";



$sqlgv32cms['message'] = "
CREATE TABLE `".$mysql_prefix."message` (
  `mes_id` int(12) NOT NULL auto_increment,
  `mes_parentid` int(12) NOT NULL,
  `mes_title` varchar(225) NOT NULL,
  `mes_content` text NOT NULL,
  `mes_type` smallint(1) NOT NULL COMMENT '0用户之间留言，1用户向系统留言',
  `tus_id` int(12) NOT NULL,
  `fus_id` int(12) NOT NULL,
  `use_email` varchar(200) NOT NULL,
  `mes_ip` varchar(64) NOT NULL,
  `mes_addtime` int(12) NOT NULL,
  `mes_enabled` smallint(1) NOT NULL default '1',
  `mes_isread` smallint(1) NOT NULL default '0',
  `mes_readtime` int(12) NOT NULL,
  `mes_status` smallint(1) NOT NULL default '0',
  PRIMARY KEY  (`mes_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
";


$sqlgv32cms['moderator'] = "
CREATE TABLE `".$mysql_prefix."moderator` (
  `mod_id` int(10) NOT NULL auto_increment,
  `use_id` int(10) NOT NULL,
  `for_id` int(10) NOT NULL,
  `mod_type` smallint(3) NOT NULL,
  `mod_enabled` smallint(2) NOT NULL,
  PRIMARY KEY  (`mod_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
";

$sqlgv32cms['notic'] = "
CREATE TABLE `".$mysql_prefix."notic` (
  `not_id` int(12) NOT NULL auto_increment,
  `not_title` int(12) NOT NULL,
  `not_desc` text NOT NULL,
  `nos_id` int(10) NOT NULL,
  `not_addtime` int(12) NOT NULL,
  `not_notictime` int(12) NOT NULL,
  PRIMARY KEY  (`not_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
";


$sqlgv32cms['order'] = "
CREATE TABLE `".$mysql_prefix."order` (
  `ord_id` int(12) NOT NULL auto_increment,
  `ord_sn` varchar(30) NOT NULL,
  `use_id` int(12) NOT NULL,
  `ord_consignee` varchar(60) NOT NULL,
  `add_id` int(12) NOT NULL,
  `ord_addtime` int(12) NOT NULL,
  `ord_express` int(5) NOT NULL,
  `ord_follow` int(5) NOT NULL default '0',
  `ord_paytime` int(12) NOT NULL,
  `ord_allpay` decimal(28,2) NOT NULL,
  `ord_needpay` decimal(28,2) NOT NULL,
  `ord_province` int(5) NOT NULL,
  `ord_city` int(5) NOT NULL,
  `ord_district` int(5) NOT NULL,
  `ord_pcdall` varchar(120) NOT NULL,
  `ord_address` varchar(255) NOT NULL,
  `ord_mobile` varchar(20) NOT NULL,
  `ord_phone` varchar(20) NOT NULL,
  `ord_status` smallint(2) NOT NULL default '1' COMMENT '0，无效，1，新单，2，己确认，3，分单，4，练货，5，打包，6，发货中，7，己发货，8，己收货，',
  `ord_paystatus` smallint(2) NOT NULL,
  `ord_storestatus` smallint(2) NOT NULL,
  PRIMARY KEY  (`ord_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
";

$sqlgv32cms['orderdesc'] = "
CREATE TABLE `".$mysql_prefix."orderdesc` (
  `odd_id` int(12) NOT NULL auto_increment,
  `use_id` int(12) NOT NULL,
  `ord_id` int(12) NOT NULL,
  `pro_id` int(12) NOT NULL,
  `odd_num` int(12) NOT NULL,
  `odd_price` decimal(28,2) NOT NULL,
  `odd_unit` varchar(10) NOT NULL COMMENT '位单',
  PRIMARY KEY  (`odd_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
";


$sqlgv32cms['personal'] = "
CREATE TABLE `".$mysql_prefix."personal` (
  `per_id` int(12) NOT NULL auto_increment,
  `per_type` varchar(20) NOT NULL default 'index',
  `per_name` varchar(30) NOT NULL,
  `per_column` varchar(255) NOT NULL,
  `per_main` text NOT NULL,
  `per_enabled` smallint(1) NOT NULL default '1',
  PRIMARY KEY  (`per_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
";


$sqlgv32cms['picitem'] = "
CREATE TABLE `".$mysql_prefix."picitem` (
  `pii_id` int(12) NOT NULL auto_increment,
  `pic_id` int(12) NOT NULL,
  `pii_url` varchar(255) NOT NULL,
  `pii_count` int(12) NOT NULL,
  `pii_content` text NOT NULL,
  `pii_enabled` smallint(1) NOT NULL default '1',
  `pii_addtime` int(12) NOT NULL,
  `pii_uptime` int(12) NOT NULL,
  PRIMARY KEY  (`pii_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
";

$sqlgv32cms['picsort'] = "
CREATE TABLE `".$mysql_prefix."picsort` (
  `pis_id` int(10) NOT NULL auto_increment,
  `use_id` int(12) NOT NULL,
  `pis_name` varchar(50) NOT NULL,
  `pis_parentid` int(10) NOT NULL,
  `pis_enabled` smallint(1) NOT NULL default '1',
  `pis_locked` smallint(1) NOT NULL default '1',
  `pis_list` int(10) NOT NULL default '99',
  PRIMARY KEY  (`pis_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
";

$sqlgv32cms['picture'] = "
CREATE TABLE `".$mysql_prefix."picture` (
  `pic_id` int(12) NOT NULL auto_increment,
  `pis_id` int(10) NOT NULL,
  `pic_name` varchar(255) NOT NULL,
  `pic_pinyin` varchar(255) NOT NULL,
  `pic_url` varchar(255) NOT NULL,
  `pic_count` int(12) NOT NULL,
  `pic_content` text NOT NULL,
  `pic_enabled` smallint(1) NOT NULL default '1',
  `pic_addtime` int(12) NOT NULL,
  `pic_uptime` int(12) NOT NULL,
  PRIMARY KEY  (`pic_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
";

$sqlgv32cms['product'] = "
CREATE TABLE `".$mysql_prefix."product` (
  `pro_id` int(12) NOT NULL auto_increment,
  `use_id` int(12) NOT NULL,
  `pro_listid` int(12) NOT NULL,
  `pro_name` varchar(255) NOT NULL,
  `pro_img` varchar(200) NOT NULL,
  `pro_barcode` varchar(40) NOT NULL,
  `pro_pinyin` varchar(100) NOT NULL,
  `pro_spec` varchar(40) NOT NULL,
  `pro_num` int(12) NOT NULL default '0',
  `pro_unit` varchar(10) NOT NULL,
  `pro_production` varchar(255) NOT NULL,
  `pro_content` text NOT NULL,
  `prs_id` int(12) NOT NULL,
  `pro_buyprice` decimal(28,2) NOT NULL default '0.00',
  `pro_sellprice` decimal(28,2) NOT NULL default '0.00',
  `pro_marketprice` decimal(28,2) NOT NULL default '0.00',
  `pro_lowestprice` decimal(28,2) NOT NULL default '0.00',
  `pro_specid` int(11) NOT NULL,
  `pro_unitid` int(11) NOT NULL,
  `pro_count` int(10) NOT NULL default '0',
  `pro_addtime` int(12) default NULL,
  `pro_uptime` int(12) NOT NULL,
  `pro_remark` varchar(255) default NULL,
  `pro_enabled` smallint(1) NOT NULL default '1',
  PRIMARY KEY  (`pro_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
";




$sqlgv32cms['proimg'] = "
CREATE TABLE `".$mysql_prefix."proimg` (
  `pri_id` mediumint(8) unsigned NOT NULL auto_increment,
  `pro_id` mediumint(8) unsigned NOT NULL default '0',
  `pri_url` varchar(255) NOT NULL,
  `pri_desc` varchar(255) NOT NULL,
  PRIMARY KEY  (`pri_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
";


$sqlgv32cms['prosort'] = "
CREATE TABLE `".$mysql_prefix."prosort` (
  `prs_id` smallint(8) unsigned NOT NULL auto_increment COMMENT '序号id',
  `prs_name` varchar(90) NOT NULL COMMENT '分类名称',
  `prs_parentid` smallint(8) unsigned NOT NULL default '0' COMMENT '父ID',
  `prs_enabled` smallint(1) unsigned NOT NULL default '1' COMMENT '是否有效',
  `prs_list` smallint(6) NOT NULL COMMENT '排序',
  PRIMARY KEY  (`prs_id`),
  KEY `parent_id` (`prs_parentid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
";

$sqlgv32cms['reply'] = "
CREATE TABLE `".$mysql_prefix."reply` (
  `rep_id` int(12) NOT NULL auto_increment,
  `rep_desc` text NOT NULL,
  `rep_file` varchar(200) NOT NULL,
  `rep_list` int(10) NOT NULL default '99',
  `rep_addtime` int(12) NOT NULL,
  `rep_uptime` int(12) NOT NULL,
  `rep_enabled` smallint(1) NOT NULL default '1',
  `use_id` int(12) NOT NULL,
  `rep_ip` varchar(15) NOT NULL,
  `thr_id` int(12) NOT NULL,
  `for_id` int(10) NOT NULL,
  PRIMARY KEY  (`rep_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
";

$sqlgv32cms['shortinfo'] = "
CREATE TABLE `".$mysql_prefix."shortinfo` (
  `sho_id` int(12) NOT NULL auto_increment,
  `sho_parentid` int(12) NOT NULL,
  `sho_title` varchar(225) NOT NULL,
  `sho_content` text NOT NULL,
  `sho_type` smallint(3) NOT NULL,
  `tus_id` int(12) NOT NULL,
  `fus_id` int(12) NOT NULL,
  `sho_addtime` int(12) NOT NULL,
  `sho_enabled` smallint(1) NOT NULL default '1',
  `sho_isread` smallint(1) NOT NULL default '0',
  `sho_readtime` int(12) NOT NULL,
  `sho_status` smallint(1) NOT NULL default '0',
  PRIMARY KEY  (`sho_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
";





$sqlgv32cms['thread'] = "
CREATE TABLE `".$mysql_prefix."thread` (
  `thr_id` int(12) NOT NULL auto_increment,
  `thr_title` varchar(64) NOT NULL,
  `thr_desc` text NOT NULL,
  `thr_file` varchar(200) NOT NULL,
  `thr_addtime` int(12) NOT NULL,
  `thr_uptime` int(12) NOT NULL,
  `thr_list` int(10) NOT NULL,
  `thr_count` int(10) NOT NULL default '0',
  `thr_replycount` int(10) NOT NULL default '0',
  `use_id` int(12) NOT NULL,
  `thr_ip` varchar(15) NOT NULL,
  `for_id` int(10) NOT NULL,
  `thr_enabled` smallint(3) NOT NULL,
  PRIMARY KEY  (`thr_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
";


$sqlgv32cms['type'] = "
CREATE TABLE `".$mysql_prefix."type` (
  `typ_id` smallint(5) NOT NULL auto_increment,
  `use_id` int(12) NOT NULL,
  `typ_name` varchar(255) NOT NULL,
  `typ_type` varchar(20) NOT NULL,
  PRIMARY KEY  (`typ_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
";


$sqlgv32cms['user'] = "
CREATE TABLE `".$mysql_prefix."user` (
  `use_id` mediumint(8) unsigned NOT NULL auto_increment COMMENT '用户ID序号',
  `use_type` char(1) NOT NULL default 'u' COMMENT 'u代表普通网站注册会员，a代表管理员，e代表本公司员工，c代表客户，s代表供应商',
  `use_email` varchar(60) NOT NULL COMMENT '用户邮箱，唯一值',
  `use_name` varchar(60) NOT NULL COMMENT '字母登录帐号（方便扩展自建邮箱等）',
  `use_pwd` varchar(32) NOT NULL COMMENT '密码（md5+倒序+base64_encode）',
  `use_question` varchar(255) NOT NULL COMMENT '安全问题',
  `use_answer` varchar(255) NOT NULL COMMENT '问题答案',
  `use_locked` smallint(1) NOT NULL default '0' COMMENT '是否锁定',
  `use_enabled` smallint(1) NOT NULL default '1' COMMENT '是否有效',
  `use_rankpoints` int(10) unsigned NOT NULL default '0' COMMENT '等级积分',
  `use_regtime` int(10) unsigned NOT NULL default '0' COMMENT '注册时间',
  `use_logcount` int(10) NOT NULL COMMENT '登录次数',
  `use_logintime` int(12) NOT NULL COMMENT '登录时间',
  `use_loginip` varchar(32) NOT NULL COMMENT '登录IP',
  `use_visitcount` int(10) unsigned NOT NULL default '0' COMMENT '个人主页被浏览量',
  `use_userrank` tinyint(3) unsigned NOT NULL default '0' COMMENT '用户等级',
  `use_isvalidated` tinyint(3) unsigned NOT NULL default '0' COMMENT '是否审批',
  `use_credit` int(10) unsigned NOT NULL COMMENT '信用度（1-5）默认0',
  `use_status` int(1) NOT NULL default '0' COMMENT '用户状态',
  `use_vip` smallint(3) default '0' COMMENT 'VIP等级',
  `use_vipstarttime` int(12) unsigned default '0' COMMENT 'VIP开始时间',
  `use_vipendtime` int(12) unsigned default '0' COMMENT 'VIP结束时间',
  `use_upemail` varchar(60) NOT NULL COMMENT '更新邮件时，准备更新的新邮箱',
  `use_regip` varchar(32) default '0' COMMENT '注册IP',
  `use_isblack` smallint(1) NOT NULL default '0' COMMENT '是否黒名单',
  PRIMARY KEY  (`use_id`),
  UNIQUE KEY `user_name` (`use_name`),
  KEY `email` (`use_email`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
";

$sqlgv32cms['userdetail'] = "
CREATE TABLE `".$mysql_prefix."userdetail` (
  `use_id` mediumint(8) unsigned NOT NULL auto_increment COMMENT '用户ID',
  `usd_sex` tinyint(1) unsigned NOT NULL default '0' COMMENT '性别，0保密，1，男，2，女',
  `usd_nick` varchar(100) NOT NULL,
  `usd_image` varchar(100) NOT NULL,
  `usd_birthday` int(12) NOT NULL,
  `usd_points` int(10) NOT NULL COMMENT '等级积分',
  `usd_visitcount` smallint(5) unsigned NOT NULL default '0',
  `usd_rank` tinyint(3) unsigned NOT NULL default '0' COMMENT '用户级等',
  `usd_salt` varchar(10) NOT NULL default '0' COMMENT '兴趣',
  `usd_flag` tinyint(3) unsigned NOT NULL default '0' COMMENT '标记 ',
  `usd_msn` varchar(60) NOT NULL COMMENT 'MSN值',
  `usd_qq` varchar(20) NOT NULL COMMENT 'QQ值',
  `usd_officephone` varchar(20) NOT NULL COMMENT '办公电话',
  `usd_homephone` varchar(20) NOT NULL COMMENT '家庭电话',
  `usd_mobile` varchar(20) NOT NULL COMMENT '手机',
  `usd_invitename` varchar(60) default NULL,
  `usd_province` smallint(5) default '0' COMMENT '省',
  `usd_city` smallint(5) default '0' COMMENT '市',
  `usd_district` smallint(5) default '0' COMMENT '区（县）',
  `usd_address` varchar(120) default NULL COMMENT '详细地址',
  `usd_truename` varchar(30) character set gb2312 default NULL COMMENT '真实姓名',
  PRIMARY KEY  (`use_id`),
  KEY `flag` (`usd_flag`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
";


$sqlgv32cms['userpower'] = "
CREATE TABLE `".$mysql_prefix."userpower` (
  `use_id` int(12) unsigned NOT NULL,
  `usp_form` varchar(20) NOT NULL,
  `usp_action` text NOT NULL,
  KEY `parent_id` (`usp_form`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
";


$sqlgv32cms['userrank'] = "
CREATE TABLE `".$mysql_prefix."userrank` (
  `rank_id` tinyint(3) unsigned NOT NULL auto_increment,
  `user_id` int(12) NOT NULL,
  `rank_name` varchar(30) NOT NULL default '',
  `min_points` int(10) unsigned NOT NULL default '0',
  `max_points` int(10) unsigned NOT NULL default '0',
  `discount` tinyint(3) unsigned NOT NULL default '0',
  `show_price` tinyint(1) unsigned NOT NULL default '1',
  `special_rank` tinyint(1) unsigned NOT NULL default '0',
  `give_interal_times` float(2,1) NOT NULL default '1.0',
  PRIMARY KEY  (`rank_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
";

$sqlgv32cms['video'] = "
CREATE TABLE `".$mysql_prefix."video` (
  `vid_id` int(12) NOT NULL auto_increment,
  `vis_id` int(10) NOT NULL,
  `vid_parentid` int(12) NOT NULL,
  `vid_name` varchar(255) NOT NULL,
  `vid_pinyin` varchar(255) NOT NULL,
  `vid_img` varchar(255) NOT NULL,
  `vid_url` varchar(255) NOT NULL,
  `vid_count` int(12) NOT NULL,
  `vid_ismaster` smallint(1) NOT NULL,
  `vid_content` text NOT NULL,
  `vid_enabled` smallint(1) NOT NULL default '1',
  `vid_addtime` varchar(12) NOT NULL,
  `vid_uptime` int(12) NOT NULL,
  PRIMARY KEY  (`vid_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
";

$sqlgv32cms['vidsort'] = "
CREATE TABLE `".$mysql_prefix."vidsort` (
  `vis_id` int(10) NOT NULL auto_increment,
  `use_id` int(12) NOT NULL,
  `vis_name` varchar(50) NOT NULL,
  `vis_parentid` int(10) NOT NULL,
  `vis_enabled` smallint(1) NOT NULL default '1',
  `vis_locked` smallint(1) NOT NULL default '1',
  `vis_list` int(10) NOT NULL default '99',
  PRIMARY KEY  (`vis_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
";

$sqlgv32cms['vote'] = "
CREATE TABLE `".$mysql_prefix."vote` (
  `vot_id` smallint(5) unsigned NOT NULL auto_increment,
  `use_id` int(12) NOT NULL,
  `vot_title` varchar(250) NOT NULL,
  `vot_starttime` int(11) unsigned NOT NULL default '0',
  `vot_endtime` int(11) unsigned NOT NULL default '0',
  `vot_selecttype` tinyint(1) unsigned NOT NULL default '0',
  `vot_count` int(10) unsigned NOT NULL default '0',
  `vot_addtime` int(12) NOT NULL,
  PRIMARY KEY  (`vot_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
";


$sqlgv32cms['voteitem'] = "
CREATE TABLE `".$mysql_prefix."voteitem` (
  `voi_id` smallint(5) unsigned NOT NULL auto_increment,
  `use_id` int(12) NOT NULL,
  `vot_id` smallint(5) unsigned NOT NULL default '0',
  `voi_name` varchar(250) NOT NULL,
  `voi_count` int(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`voi_id`),
  KEY `vote_id` (`vot_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
";

$sqlgv32cms['votelog'] = "
CREATE TABLE `".$mysql_prefix."votelog` (
  `vol_id` mediumint(8) unsigned NOT NULL auto_increment,
  `vot_id` smallint(5) unsigned NOT NULL default '0',
  `vol_ipaddress` varchar(15) NOT NULL,
  `vol_addtime` int(12) unsigned NOT NULL default '0',
  `use_id` int(12) unsigned NOT NULL default '0',
  `vol_idstr` varchar(50) default NULL COMMENT '单，多选结果',
  PRIMARY KEY  (`vol_id`),
  KEY `vote_id` (`vot_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
";

$sqlgv32cms['webmenu'] = "
CREATE TABLE `".$mysql_prefix."webmenu` (
  `web_id` smallint(6) NOT NULL auto_increment,
  `web_parentid` smallint(6) NOT NULL,
  `web_name` varchar(20) NOT NULL,
  `web_url` varchar(200) NOT NULL,
  `web_enabled` smallint(1) NOT NULL,
  `web_place` varchar(8) NOT NULL,
  `web_targetval` varchar(20) NOT NULL default '_self',
  `web_list` smallint(2) NOT NULL,
  PRIMARY KEY  (`web_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
";



//插入数据库 

$sqlgv32[] = "INSERT INTO `".$mysql_prefix."artlice` VALUES (1, 0, '关于我们', '', '系统文章', 4, 1341367889, '', '', '', '', '', 1, 1, 0, 1, 1, 205, 1358842646, 'aboutus')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."artlice` VALUES (2, 0, '版权声明', '', '系统文章', 4, 1341367898, '', '', '', '', '0', 0, 1, 0, 0, 1, 207, 1350372232, 'copyright')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."artlice` VALUES (3, 0, '公司介绍', '', '系统文章', 4, 1341368554, '', '', '', '', '0', 0, 1, 0, 0, 1, 208, 1350008539, 'company')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."artlice` VALUES (4, 0, '服务协议', '', '系统文章', 4, 1341367889, '', '', '', '', '0', 0, 1, 0, 0, 1, 203, 1346743089, 'agreement')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."artlice` VALUES (5, 0, '联系我们', '', '系统文章', 4, 1341367898, '', '', '', '', '0', 0, 1, 0, 0, 1, 207, 1350372232, 'contactus')";


$sqlgv32[] = "INSERT INTO `".$mysql_prefix."artsort` VALUES (1, 0, '系统分类', 0, 1, 1, 1)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."artsort` VALUES (2, 0, '企业动态', 0, 1, 1, 99)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."artsort` VALUES (3, 0, '网站信息', 1, 1, 1, 99)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."artsort` VALUES (4, 0, '行业动态', 2, 1, 1, 99)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."artsort` VALUES (5, 0, '本站快讯', 2, 1, 1, 99)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."artsort` VALUES (6, 0, '技术优化', 2, 1, 1, 99)";


$sqlgv32[] = "INSERT INTO `".$mysql_prefix."configsys` VALUES (1, '网站名称', 'webname', 'GV32-CMS企业建站系统', 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."configsys` VALUES (2, '网站标题', 'webtitle', '智伟建站科技有限公司', 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."configsys` VALUES (3, '网站描述', 'webdescription', '智伟企业建站系统是业内领先的网站建设系统。GV32-CMS采用网站功能模块化和网站风格模板化的设计方针，使得用户制作网站更加简易快捷，从而在企业网站建设领域应用非常广泛，是成熟的企业网站系统之一。', 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."configsys` VALUES (4, '网站关键字', 'webkeyword', '网站建设公司,智伟网站制作,智伟网站设计,GV32.COM', 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."configsys` VALUES (5, '客服QQ号码', 'webqq', '1619929648,1619929648,1619929648', 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."configsys` VALUES (6, '客服电话', 'webphote', '020888888,1619929648,1619929648111', 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."configsys` VALUES (7, '暂时关闭网站', 'webclose', '0', 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."configsys` VALUES (8, '关闭网站的原因', 'webclosevalue', '关闭网站的原因', 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."configsys` VALUES (9, '网站Logo', 'weblogo', '/uploads/1/20130122/1358847119.png', 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."configsys` VALUES (10, '是否关闭注册', 'webreg', '1', 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."configsys` VALUES (11, 'ICP证书或ICP备案证书号', 'webcertificate', '粤ICP备88888888号', 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."configsys` VALUES (12, '搜索的关键字', 'webserachkeywor', 'GV32,GV32CMS,GV32.COM111', 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."configsys` VALUES (13, 'MSN', 'regmsn', '1|1|2', 'reg')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."configsys` VALUES (14, 'QQ', 'regqq', '1|1|2', 'reg')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."configsys` VALUES (15, '办公电话', 'regphote', '1|1|1', 'reg')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."configsys` VALUES (16, '家庭电话', 'reghomephote', '1|1|1', 'reg')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."configsys` VALUES (17, '手 机', 'regtel', '1|1|1', 'reg')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."configsys` VALUES (19, '联系人', 'webadmin', 'GV32.COM官网', 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."configsys` VALUES (20, '邮箱地址', 'webmail', 'service@gv32.com', 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."configsys` VALUES (21, '联系地址', 'webaddress', 'GV32.COM官网', 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."configsys` VALUES (23, 'GV32.COM简约免费模板v2.0', 'default', 'default', 'temp')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."configsys` VALUES (24, '网站名称', 'bbsname', 'GV32论坛', 'bbs')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."configsys` VALUES (25, '网站标题', 'bbstitle', '论坛标题GV32-CMS开源系统V1.0，免费自助建站系统', 'bbs')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."configsys` VALUES (26, '网站描述', 'bbsdescription', '论坛描述GV32-CMS开源系统V1.0企业建站系统是业内领先的免费开源网站建设系统。GV32-CMS采用网站功能模块化和网站风格模板化的设计方针，使得用户制作网站更加简易快捷，从而在企业网站建设领域应用非常广泛，是成熟的企业网站系统之一。', 'bbs')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."configsys` VALUES (27, '网站关键字', 'bbskeyword', '论坛关键字GV32-CMS系统,gv32,CMS,免费自助建站系统', 'bbs')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."configsys` VALUES (28, '客服QQ号码', 'bbsqq', '1619929648bbs', 'bbs')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."configsys` VALUES (29, '客服电话', 'bbsphote', '020888888bbs', 'bbs')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."configsys` VALUES (30, '暂时关闭网站', 'bbsclose', '0', 'bbs')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."configsys` VALUES (31, '关闭网站的原因', 'bbsclosevalue', '网站审核中，请稍候再访问！', 'bbs')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."configsys` VALUES (32, '网站Logo', 'bbslogo', '/uploads/20120903/s/1346648694.jpg', 'bbs')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."configsys` VALUES (33, '是否关闭注册', 'bbsreg', '1', 'bbs')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."configsys` VALUES (34, 'ICP证书或ICP备案证书号', 'bbscertificate', '粤ICP备88888888号', 'bbs')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."configsys` VALUES (35, '搜索的关键字', 'bbsserachkeywor', 'GV32,GV32CMS,GV32.COMbbs', 'bbs')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."configsys` VALUES (36, '联系人', 'bbsadmin', '论坛GV32.COM官网', 'bbs')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."configsys` VALUES (37, '邮箱地址', 'bbsmail', 'service@gv32.combbs', 'bbs')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."configsys` VALUES (38, '联系地址', 'bbsaddress', 'GV32.COM官网bbs', 'bbs')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."configsys` VALUES (39, '网站言语包', 'language', 'chinese', 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."configsys` VALUES (40, '开启缓存', 'webtmp', '0', 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."configsys` VALUES (41, '缓存时间', 'webtmptime', '3600', 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."configsys` VALUES (42, '开启伪静态化', 'webhtml', '0', 'web')";


$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (1, 0, '系统设置', 'config', 'config', 0, 1, 'mainFrame', 99, 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (8, 0, '网站设置', 'config', '/?load=config&act=infolist', 1, 1, 'mainFrame', 32, 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (3, 0, '职工管理', 'employee', 'employee', 0, 1, 'mainFrame', 4, 'use')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (9, 0, '更改密码', 'login', '/?load=user&act=pwd', 83, 1, 'mainFrame', 38, 'per')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (10, 0, '退出', 'login', '/?load=user&act=actlogout', 83, 1, '_top', 39, 'per')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (11, 0, '职工列表', 'employee', '/?load=employee&act=infolist', 3, 1, 'mainFrame', 99, 'use')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (4, 0, '文章管理', 'article', 'artsort', 0, 1, 'mainFrame', 1, 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (20, 0, '文章分类', 'artsort', '/?load=artsort&act=infolist', 4, 1, 'mainFrame', 99, 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (12, 0, '文章列表', 'artlice', '/?load=artlice&act=infolist', 4, 1, 'mainFrame', 99, 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (13, 0, '留言管理', 'user', '/index.php?load=message&act=infolist', 44, 1, 'mainFrame', 99, 'use')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (14, 0, '友情链接', 'link', '/?load=link&act=infolist', 70, 1, 'mainFrame', 35, 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (5, 0, '广告管理', 'ad', 'ad', 0, 1, 'mainFrame', 3, 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (21, 0, '广告列表', 'ads', '/?load=ad&act=infolist', 5, 1, 'mainFrame', 4, 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (15, 0, '广告位置', 'ads', '/?load=adposition&act=infolist', 5, 1, 'mainFrame', 5, 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (2, 0, '商品管理', 'product', 'product', 0, 1, 'mainFrame', 0, 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (22, 0, '商品分类', 'prosort', '/?load=prosort&act=infolist', 2, 1, 'mainFrame', 3, 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (16, 0, '商品列表', 'product', '/?load=product&act=infolist', 2, 1, 'mainFrame', 1, 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (23, 0, '添加商品', 'product', '/index.php?load=product&act=add', 2, 1, 'mainFrame', 2, 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (6, 0, '招聘管理', 'invite', 'invite', 0, 1, 'mainFrame', 4, 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (17, 0, '招聘列表', 'invite', '/index.php?load=invite&act=infolist', 6, 1, 'mainFrame', 0, 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (24, 0, '应聘简历', 'employ', '/index.php?load=employ&act=infolist', 6, 1, 'mainFrame', 0, 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (18, 0, '导航栏目', 'webmenu', '/index.php?load=webmenu&act=infolist', 1, 1, 'mainFrame', 32, 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (7, 0, '投票调查', 'vote', 'vote', 0, 1, 'mainFrame', 5, 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (25, 0, '投票主题', 'vote', '/index.php?load=vote&act=infolist', 7, 1, 'mainFrame', 0, 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (19, 0, '预订管理', 'book', '/index.php?load=book&act=infolist', 55, 1, 'mainFrame', 4, 'crm')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (31, 0, '作品管理', 'work', 'work', 0, 0, 'mainFrame', 0, 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (32, 0, '作品分类', 'worksort', '/index.php?load=worksort&act=infolist', 31, 0, 'mainFrame', 3, 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (33, 0, '作品列表', 'work', '/index.php?load=work&act=infolist', 31, 0, 'mainFrame', 1, 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (34, 0, '添加作品', 'works', '/index.php?load=works&act=add', 31, 0, 'mainFrame', 2, 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (35, 0, '模板设置', 'config', '/index.php?load=config&act=temlist', 1, 1, 'mainFrame', 32, 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (36, 0, '首页广告', 'ad', '/index.php?load=ad&act=flashlist', 5, 1, 'mainFrame', 32, 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (37, 0, '论坛设置', 'bbsconfig', 'bbsconfig', 0, 1, 'mainFrame', 99, 'bbs')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (38, 0, '基本设置', 'bbsconfig', '/index.php?load=bbsconfig&act=infolist', 37, 1, 'mainFrame', 32, 'bbs')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (39, 0, '板块设置', 'bbsconfig', '/index.php?load=forum&act=infolist', 37, 1, 'mainFrame', 32, 'bbs')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (40, 0, '内容管理', 'bbsconfig', 'bbsconfig', 0, 1, 'mainFrame', 99, 'bbs')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (41, 0, '主题管理', 'bbsconfig', '/index.php?load=thread&act=infolist', 40, 1, 'mainFrame', 32, 'bbs')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (42, 0, '回复管理', 'bbsconfig', '/index.php?load=reply&act=infolist', 40, 1, 'mainFrame', 32, 'bbs')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (43, 0, '板主管理', 'moderator', '/index.php?load=moderator&act=infolist', 37, 1, 'mainFrame', 32, 'bbs')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (44, 0, '普通会员', 'user', 'userconfig', 0, 1, 'mainFrame', 32, 'use')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (45, 0, '注册设置', 'user', '/index.php?load=userconfig&act=infolist', 44, 1, 'mainFrame', 32, 'use')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (46, 0, '会员管理', 'user', '/index.php?load=user&act=infolist', 44, 1, 'mainFrame', 32, 'use')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (47, 0, '下载系统', 'download', '/index.php?load=download&act=infolist', 71, 1, 'mainFrame', 35, 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (51, 0, '信息管理', 'config', '/index.php/message/infolist', 1, 0, 'mainFrame', 32, 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (52, 0, '客户资料', 'customer', 'customer', 0, 0, 'mainFrame', 1, 'crm')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (53, 0, '客户资料', 'customer', '/index.php/customer/infolist', 52, 0, 'mainFrame', 99, 'crm')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (54, 0, '添加客户', 'customer', '/index.php/customer/add', 52, 0, 'mainFrame', 1, 'crm')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (55, 0, '销售管理', 'order', 'order', 0, 1, 'mainFrame', 1, 'crm')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (56, 0, '销售信息', 'order', '/index.php?load=order&act=infolist', 55, 1, 'mainFrame', 99, 'crm')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (57, 0, '市场管理', 'market', 'market', 0, 0, 'mainFrame', 1, 'crm')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (58, 0, '市场信息', 'market', '/index.php/market/infolist', 57, 0, 'mainFrame', 99, 'crm')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (59, 0, '支持管理', 'market', 'market', 0, 0, 'mainFrame', 1, 'crm')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (60, 0, '运输管理', 'carrier', '/index.php/carrier/infolist', 59, 0, 'mainFrame', 99, 'crm')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (61, 0, '活动管理', 'plan', 'plan', 0, 0, 'mainFrame', 1, 'crm')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (62, 0, '活动信息', 'plan', '/index.php/plan/infolist', 61, 0, 'mainFrame', 99, 'crm')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (63, 0, '协作管理', 'market', 'market', 0, 0, 'mainFrame', 1, 'crm')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (64, 0, '服务管理', 'service', '/index.php/service/infolist', 63, 0, 'mainFrame', 99, 'crm')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (65, 0, '组织部门', 'user', 'userconfig', 0, 0, 'mainFrame', 32, 'use')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (66, 0, '员工管员', 'user', 'userconfig', 0, 0, 'mainFrame', 32, 'use')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (67, 0, '机会管理', 'chance', '/index.php/chance/infolist', 59, 0, 'mainFrame', 99, 'crm')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (68, 0, '交往管理', 'activity', '/index.php/activity/infolist', 59, 0, 'mainFrame', 99, 'crm')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (69, 0, '客户联系人', 'linkman', '/index.php/linkman/infolist', 52, 0, 'mainFrame', 99, 'crm')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (70, 0, '友情链接', 'link', 'link', 0, 1, 'mainFrame', 5, 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (71, 0, '下载系统', 'download', 'download', 0, 1, 'mainFrame', 5, 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (72, 0, '部门管理', 'user', '/?load=dept&act=infolist', 3, 1, 'mainFrame', 99, 'use')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (73, 0, '个性栏目', 'webmenu', '/index.php?load=personal&act=infolist', 1, 1, 'mainFrame', 32, 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (76, 0, '图库管理', 'picture', 'picture', 0, 1, 'mainFrame', 1, 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (77, 0, '图库分类', 'picsort', '/?load=picsort&act=infolist', 76, 1, 'mainFrame', 99, 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (78, 0, '图库列表', 'picture', '/?load=picture&act=infolist', 76, 1, 'mainFrame', 99, 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (79, 0, '视频管理', 'video', 'video', 0, 1, 'mainFrame', 1, 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (80, 0, '视频分类', 'vidsort', '/?load=vidsort&act=infolist', 79, 1, 'mainFrame', 99, 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (81, 0, '视频列表', 'video', '/?load=video&act=infolist', 79, 1, 'mainFrame', 99, 'web')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (82, 0, '客户资料', 'user', '/index.php?load=address&act=infolist', 44, 1, 'mainFrame', 32, 'use')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (83, 0, '个人设置', 'config', 'config', 0, 1, 'mainFrame', 99, 'per')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."menu` VALUES (84, 0, '清除缓存', 'config', '/index.php?load=clear&act=infolist', 1, 1, 'mainFrame', 32, 'web')";

$sqlgv32[] = "INSERT INTO `".$mysql_prefix."webmenu` VALUES (1, 0, '网站地图', '/?load=map', 1, 'bottom', '_blank', 35)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."webmenu` VALUES (2, 0, '产品与服务', '/?load=pro&act=infolist', 1, 'middle', '_self', 13)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."webmenu` VALUES (3, 0, '关于我们', '/?load=aboutus', 1, 'middle', '_self', 11)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."webmenu` VALUES (4, 0, '我的资料', '', 1, 'user', '0', 1)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."webmenu` VALUES (5, 0, '站内消息', '', 1, 'user', '0', 1)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."webmenu` VALUES (6, 0, '个人帐户', '', 0, 'user', '0', 1)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."webmenu` VALUES (7, 0, '在线售后', '', 0, 'user', '0', 1)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."webmenu` VALUES (8, 0, '我的订单', '', 0, 'user', '0', 1)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."webmenu` VALUES (9, 0, '评论管理', '', 1, 'user', '0', 1)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."webmenu` VALUES (10, 4, '基本信息', '/?load=user&act=infolist', 1, 'user', '0', 1)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."webmenu` VALUES (11, 4, '收货地址', '/?load=address&act=infolist', 1, 'user', '0', 1)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."webmenu` VALUES (12, 4, '修改密码', '/?load=user&act=pwd', 1, 'user', '0', 1)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."webmenu` VALUES (13, 5, '发件箱', '/?load=message&act=sendinfo', 1, 'user', '0', 1)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."webmenu` VALUES (14, 5, '收件箱', '/?load=message&act=receiveinfo', 1, 'user', '0', 1)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."webmenu` VALUES (15, 5, '短信提醒', '/?load=message&act=shortinfo', 1, 'user', '0', 1)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."webmenu` VALUES (16, 5, '我的订阅', '/?load=message&act=book', 1, 'user', '0', 1)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."webmenu` VALUES (17, 6, '充值记录', '', 0, 'user', '0', 1)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."webmenu` VALUES (18, 6, '帐户余额', '', 0, 'user', '0', 1)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."webmenu` VALUES (19, 6, '我的积分', '', 0, 'user', '0', 1)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."webmenu` VALUES (20, 6, '优惠券', '', 0, 'user', '0', 1)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."webmenu` VALUES (21, 6, '礼品卡', '', 0, 'user', '0', 1)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."webmenu` VALUES (22, 7, '我要投诉', '/?load=complain&act=send', 0, 'user', '0', 1)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."webmenu` VALUES (23, 7, '投诉管理', '/?load=complain&act=infolist', 0, 'user', '0', 1)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."webmenu` VALUES (24, 8, '订单管理', '', 0, 'user', '0', 1)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."webmenu` VALUES (25, 8, '历史订单', '', 0, 'user', '0', 1)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."webmenu` VALUES (26, 8, '返修/退换货', '', 0, 'user', '0', 1)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."webmenu` VALUES (27, 8, '取消订单记录', '', 0, 'user', '0', 1)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."webmenu` VALUES (28, 9, '商品评价', '/?load=comment&act=pro', 1, 'user', '0', 1)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."webmenu` VALUES (29, 9, '资讯评论', '/?load=comment&act=art', 1, 'user', '0', 1)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."webmenu` VALUES (30, 9, '购买咨询', '/?load=comment&act=buy', 1, 'user', '0', 1)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."webmenu` VALUES (31, 0, '新闻中心', '/?load=art&act=infolist', 1, 'middle', '_self', 12)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."webmenu` VALUES (32, 0, '企业文化', '/?load=personal&act=index&type=culture', 1, 'middle', '_self', 13)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."webmenu` VALUES (33, 0, '投资者关系', '/?load=personal&act=index&type=investor', 0, 'middle', '_self', 14)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."webmenu` VALUES (34, 0, '社会责任', '/?load=personal&act=index&type=society', 1, 'middle', '_self', 15)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."webmenu` VALUES (35, 0, '人力资源', '/?load=invite', 1, 'middle', '_self', 16)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."webmenu` VALUES (36, 0, '联系我们', '/?load=contactus', 1, 'bottom', '_self', 31)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."webmenu` VALUES (37, 0, '友情链接', '/?load=link', 1, 'bottom', '_self', 32)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."webmenu` VALUES (38, 0, '在线咨询', '/?load=message', 1, 'bottom', '_self', 33)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."webmenu` VALUES (39, 0, '版权声明', '/?load=copyright', 1, 'bottom', '_self', 34)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."webmenu` VALUES (40, 0, '下载中心', '/?load=download&act=infolist', 1, 'bottom', '_self', 99)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."webmenu` VALUES (41, 0, '图片中心', '/?load=pic&act=infolist', 1, 'middle', '_self', 99)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."webmenu` VALUES (42, 0, '视频中心', '/?load=vid&act=infolist', 1, 'middle', '_self', 99)";


$sqlgv32[] = "INSERT INTO `".$mysql_prefix."personal` VALUES (1, 'index', '样式页面', 'artsort|prosort|contact', 'JG1haW5BcnJheVtdID0gIGFycmF5KCAnY29uJz0+J2FydGxpY2UnLCduJz0+JzUnLCdzaWQnPT4nMycpOyA=', 1)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."personal` VALUES (2, 'culture', '企业文化', 'artsort|prosort|contact', 'JG1haW5BcnJheVtdID0gIGFycmF5KCAnY29uJz0+J2FydGxpY2UnLCduJz0+JzEwJywnc2lkJz0+JzQnKTsgJG1haW5BcnJheVtdID0gIGFycmF5KCAnY29uJz0+J2FydGxpY2UnLCduJz0+JzIwJywnc2lkJz0+JzYnKTsgJG1haW5BcnJheVtdID0gIGFycmF5KCAnY29uJz0+J2FydGxpY2UnLCduJz0+JzQnLCdzaWQnPT4nMycpOyA=', 1)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."personal` VALUES (3, 'investor', '投资者关系', 'artsort|prosort|contact', 'JG1haW5BcnJheVtdID0gIGFycmF5KCAnY29uJz0+J3Byb2R1Y3QnLCduJz0+JzEwJywnc2lkJz0+JycpOyAkbWFpbkFycmF5W10gPSAgYXJyYXkoICdjb24nPT4nYXJ0bGljZScsJ24nPT4nMTAnLCdzaWQnPT4nJyk7IA==', 1)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."personal` VALUES (4, 'society', '社会责任', 'artsort|prosort|contact', 'JG1haW5BcnJheVtdID0gIGFycmF5KCAnY29uJz0+J3Byb2R1Y3QnLCduJz0+JzUnLCdzaWQnPT4nJyk7ICRtYWluQXJyYXlbXSA9ICBhcnJheSggJ2Nvbic9PidhcnRsaWNlJywnbic9Pic1Jywnc2lkJz0+JycpOyA=', 1)";

$sqlgv32[] = "INSERT INTO `".$mysql_prefix."vidsort` VALUES (1, 0, '电影', 0, 1, 1, 99)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."vidsort` VALUES (2, 0, '连续剧', 0, 1, 1, 99)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."vidsort` VALUES (3, 0, '综艺', 0, 1, 1, 99)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."vidsort` VALUES (4, 0, '直播', 0, 1, 1, 99)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."vidsort` VALUES (5, 0, '动漫', 0, 1, 1, 99)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."vidsort` VALUES (6, 0, '娱乐', 0, 1, 1, 99)";


$sqlgv32[] = "INSERT INTO `".$mysql_prefix."picsort` VALUES (1, 0, '美女', 0, 1, 1, 99)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."picsort` VALUES (2, 0, '壁画', 0, 1, 1, 99)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."picsort` VALUES (3, 0, '名星', 0, 1, 1, 99)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."picsort` VALUES (4, 0, '搞笑', 0, 1, 1, 99)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."picsort` VALUES (5, 0, '车模', 0, 1, 1, 99)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."picsort` VALUES (6, 0, '动漫', 0, 1, 1, 99)";

$sqlgv32[] = "INSERT INTO `".$mysql_prefix."prosort` VALUES (1, '新品上市', 0, 1, 99)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."prosort` VALUES (2, '原创设计', 0, 1, 99)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."prosort` VALUES (3, '特惠推荐', 0, 1, 99)";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."prosort` VALUES (4, '价格分类', 0, 1, 99)";


$sqlgv32[] = "INSERT INTO `".$mysql_prefix."adposition` VALUES (1, 0, '除首页外网页菜单下全站统一广告位910X170', 710, 170, '除首页外网页菜单下全站统一广告位910X180', '')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."adposition` VALUES (2, 0, '首页左边列中250像素X250像素搜索下面', 200, 60, '首页左边列中250像素X250像素搜索下面', '首页左边列中250像素X250像素搜索下面')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."adposition` VALUES (3, 0, '首页左边列中250像素X250像素商品分类下面', 200, 80, '首页左边列中250像素X250像素商品分类下面', '首页左边列中250像素X250像素商品分类下面')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."adposition` VALUES (4, 0, '首页左边列中250像素X250像素联系方式下面', 200, 80, '首页左边列中250像素X250像素联系方式下面', '首页左边列中250像素X250像素联系方式下面')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."adposition` VALUES (5, 0, '首页左边列中250像素X250像素友情链接下面', 200, 67, '首页左边列中250像素X250像素友情链接下面', '首页左边列中250像素X250像素友情链接下面')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."adposition` VALUES (6, 0, '首页右边商品展示下面680X90广告位', 680, 90, '首页右边商品展示下面680X90广告位', '首页右边商品展示下面680X90广告位')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."adposition` VALUES (7, 0, '首页右边公司介绍下面680X90广告位', 680, 90, '首页右边公司介绍下面680X90广告位', '首页右边公司介绍下面680X90广告位')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."adposition` VALUES (8, 0, '首页右边新闻动态下面680X90广告位', 680, 90, '首页右边新闻动态下面680X90广告位', '首页右边新闻动态下面680X90广告位')";
$sqlgv32[] = "INSERT INTO `".$mysql_prefix."adposition` VALUES (9, 0, '商品展示列表页右边商品展示下面680X90广告位', 710, 175, '商品展示列表页右边商品展示下面680X90广告位', '商品展示列表页右边商品展示下面680X90广告位')";


?>