install.sql

网页开发 网页开发 网页开发 网页开发 网页开发 网页开发 网页开发 网页开发 网页开发 网页开发 网页开发 网页开发 网页开发 网页开发

-- phpMyAdmin SQL Dump
-- version 2.6.2
-- http://www.phpmyadmin.net
-- 
-- 主机: localhost
-- 生成日期: 2006 年 03 月 27 日 00:21
-- 服务器版本: 5.0.7
-- PHP 版本: 5.0.2
-- 
-- 数据库: `topwang`
-- 

-- --------------------------------------------------------

-- 
-- 表的结构 `tw_ad`
-- 

DROP TABLE IF EXISTS `tw_ad`;
CREATE TABLE `tw_ad` (
  `id` int(11) NOT NULL auto_increment,
  `ad_type` tinyint(1) NOT NULL default '1',
  `ad_title` char(100) NOT NULL,
  `ad_description` char(250) default NULL,
  `ad_siteurl` char(100) NOT NULL,
  `ad_logourl` char(100) default NULL,
  `ad_enable` tinyint(1) NOT NULL default '1',
  `ad_addtime` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

-- 
-- 表的结构 `tw_admin`
-- 

DROP TABLE IF EXISTS `tw_admin`;
CREATE TABLE `tw_admin` (
  `m_id` mediumint(9) unsigned NOT NULL auto_increment,
  `m_name` char(50) NOT NULL,
  `m_pwd` char(50) NOT NULL,
  `m_time` int(11) default NULL,
  `m_ip` char(15) default NULL,
  `m_lock` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`m_id`)
) TYPE=MyISAM;

-- 
-- 导出表中的数据 `tw_admin`
-- 

INSERT INTO `tw_admin` VALUES (1, 'admin', '7fef6171469e80d32c0559f88b377245', 1143260618, '127.0.0.1', 0);

-- --------------------------------------------------------

-- 
-- 表的结构 `tw_config`
-- 

DROP TABLE IF EXISTS `tw_config`;
CREATE TABLE `tw_config` (
  `cid` tinyint(4) unsigned NOT NULL auto_increment,
  `site_name` char(50) NOT NULL,
  `site_title` char(100) NOT NULL,
  `site_url` char(100) NOT NULL,
  `site_keywords` char(250) NOT NULL,
  `site_description` char(250) NOT NULL,
  `site_logo` char(50) NOT NULL,
  `site_banner` char(50) NOT NULL,
  `site_bottom` tinytext NOT NULL,
  `site_email` char(50) NOT NULL,
  `site_master` char(50) NOT NULL,
  `site_state` tinyint(1) NOT NULL,
  `site_close_reason` char(250) NOT NULL,
  `up_show_vc` tinyint(1) NOT NULL,
  `up_is_share` tinyint(1) NOT NULL,
  `up_is_description` tinyint(1) NOT NULL,
  `up_max_num_once` tinyint(4) NOT NULL,
  `up_max_file_size` int(11) NOT NULL,
  `up_supported_extensions` char(100) NOT NULL,
  `up_file_name_pre` char(50) NOT NULL,
  `up_path_root` char(100) NOT NULL,
  `up_path_temp` char(50) NOT NULL,
  `up_file_expire` smallint(6) NOT NULL,
  `up_get_id_length` tinyint(4) NOT NULL,
  `up_user_id_length` tinyint(4) NOT NULL,
  `up_record_user_id` tinyint(1) NOT NULL,
  `up_user_id_expire` tinyint(4) NOT NULL,
  `dl_record_pagesize` tinyint(4) NOT NULL,
  `dl_show_validcode` tinyint(1) NOT NULL,
  `dl_open_ad` tinyint(1) NOT NULL,
  `dl_ad_url` char(250) NOT NULL,
  `se_open_search` tinyint(1) NOT NULL,
  `se_search_pagesize` tinyint(4) NOT NULL,
  `info_open_announcement` tinyint(1) NOT NULL default '1',
  `info_announcement_nums` tinyint(4) NOT NULL,
  `info_pagesize` tinyint(4) NOT NULL,
  `rss_enable` tinyint(1) NOT NULL default '1',
  `rss_show_nums` tinyint(4) NOT NULL,
  `share_pagesize` tinyint(4) NOT NULL,
  `share_ban_words` tinytext,
  `ad_is_enable` tinyint(1) NOT NULL default '1',
  `ad_textad_rows` tinyint(4) NOT NULL,
  `ad_logoad_rows` tinyint(4) NOT NULL,
  `ad_logoad_wh` char(20) NOT NULL,
  PRIMARY KEY  (`cid`)
) TYPE=MyISAM;

-- 
-- 导出表中的数据 `tw_config`
-- 

INSERT INTO `tw_config` VALUES (1, '拓网科技官方网站', '拓网文件上传共享系统PHP版 V1.0', 'http://www.topwang.com', '拓网,TopWang,企业网站,文件,上传,提取,ASP,PHP', '拓网科技致力于Web领域的开发.', './images/logo.gif', './images/banner.gif', '欢迎您使用拓网文件上传共享系统', '拓网管理员', '[e-mail]', 1, '网站升级中，请梢后访问!', 0, 1, 1, 10, 100, 'gif,jpeg,png,jpg,zip,torrent', 'TopWang_', './uploadfiles/', 'Y*m*d', 30, 5, 5, 1, 30, 10, 1, 0, 'images/page.html', 1, 10, 1, 10, 10, 1, 10, 10, '日|操|女优|共产党', 0, 6, 6, '88*31');

-- --------------------------------------------------------

-- 
-- 表的结构 `tw_files`
-- 

DROP TABLE IF EXISTS `tw_files`;
CREATE TABLE `tw_files` (
  `f_id` mediumint(9) unsigned NOT NULL auto_increment,
  `f_name` char(100) NOT NULL,
  `f_path` char(250) NOT NULL,
  `f_type` char(30) NOT NULL,
  `f_ext` char(50) NOT NULL,
  `f_size` mediumint(9) NOT NULL,
  `f_getid` char(50) NOT NULL,
  `f_share` tinyint(1) NOT NULL default '0',
  `f_description` char(100) NOT NULL,
  `f_addtime` int(10) unsigned zerofill NOT NULL default '0000000000',
  `f_userid` char(50) NOT NULL,
  `f_userip` char(15) NOT NULL,
  `f_hits` mediumint(9) NOT NULL default '0',
  PRIMARY KEY  (`f_id`)
) TYPE=MyISAM;

-- 
-- 表的结构 `tw_info`
-- 

DROP TABLE IF EXISTS `tw_info`;
CREATE TABLE `tw_info` (
  `id` mediumint(9) NOT NULL auto_increment,
  `type` tinyint(1) NOT NULL default '0',
  `title` char(100) NOT NULL,
  `content` text,
  `author` char(20) NOT NULL,
  `posttime` int(11) NOT NULL,
  `hits` int(11) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

-- 
-- 表的结构 `tw_package`
-- 

DROP TABLE IF EXISTS `tw_package`;
CREATE TABLE `tw_package` (
  `p_id` int(11) NOT NULL auto_increment,
  `p_path` char(250) NOT NULL,
  `p_name` char(250) NOT NULL,
  `p_size` int(11) NOT NULL,
  `p_desc` char(250) NOT NULL,
  `p_share` tinyint(1) NOT NULL default '0',
  `p_getid` char(50) NOT NULL,
  `p_maketime` int(11) NOT NULL,
  PRIMARY KEY  (`p_id`)
) TYPE=MyISAM;

-- 
-- 导出表中的数据 `tw_package`
--