白月工作室(局域网)电影网站.zip

-- phpMyAdmin SQL Dump -- version 2.7.0-pl2 -- http://www.phpmyadmin.net -- -- 主机: localhost -- 生成日期: 2010 年 02 月 07 日 19:28 -- 服务器版本: 5.0.45 -- PHP 版本: 5.2.10 -- -- 数据库: `movie` -- -- -------------------------------------------------------- -- -- 表的结构 `byart_admin` -- DROP TABLE IF EXISTS `byart_admin`; CREATE TABLE IF NOT EXISTS `byart_admin` ( `Id` int(11) NOT NULL auto_increment, `admin_name` varchar(20) default NULL, `admin_pass` varchar(32) default NULL, `admin_group` tinyint(1) default NULL, `admin_remark` varchar(200) default NULL, `add_date` date default NULL, PRIMARY KEY (`Id`) ) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=gbk AUTO_INCREMENT=16 ; -- -- 导出表中的数据 `byart_admin` -- INSERT DELAYED IGNORE INTO `byart_admin` (`Id`, `admin_name`, `admin_pass`, `admin_group`, `admin_remark`, `add_date`) VALUES (14, 'admin', 'e10adc3949ba59abbe56e057f20f883e', 2, '', '2007-02-05'), (15, 'byqy', 'e10adc3949ba59abbe56e057f20f883e', 1, '', '2008-01-31'); -- -------------------------------------------------------- -- -- 表的结构 `byart_article` -- DROP TABLE IF EXISTS `byart_article`; CREATE TABLE IF NOT EXISTS `byart_article` ( `Id` int(11) NOT NULL auto_increment, `art_title` varchar(80) default NULL, `art_content` text, `art_typeid` int(11) default NULL, `art_pritype` int(11) default NULL, `art_typename` varchar(20) default NULL, `add_user` varchar(20) default NULL, `edit_user` varchar(16) default NULL, `add_date` date default NULL, `look_time` int(11) default '1', `art_typeclass` varchar(3) default NULL, PRIMARY KEY (`Id`) ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=gbk AUTO_INCREMENT=5 ; -- -- 导出表中的数据 `byart_article` -- INSERT DELAYED IGNORE INTO `byart_article` (`Id`, `art_title`, `art_content`, `art_typeid`, `art_pritype`, `art_typename`, `add_user`, `edit_user`, `add_date`, `look_time`, `art_typeclass`) VALUES (1, 'width:860px;', '<p><font face="Arial"><font face="Arial">width:860px;</font></font></p>', 45, 4, '信息动态', 'admin', NULL, '2008-04-28', 2, '2'), (2, 'dfgdfgdfgdfgdfgdfgdfgdfg', '<font face="Arial">dfgdfgdfgdfgdfgdfgdfgdfg</font>', 28, 6, '先进性教育', 'admin', NULL, '2008-05-04', 1, '3'), (3, 'fdfgdfg', 'dgdgdgdfgdg', 38, 36, '中标信息', 'admin', NULL, '2008-05-04', 1, '3'), (4, '无法', '&nbsp;仍然', 13, 11, '图片新闻', 'admin', NULL, '2008-06-16', 1, '2'); -- -------------------------------------------------------- -- -- 表的结构 `byart_computer` -- DROP TABLE IF EXISTS `byart_computer`; CREATE TABLE IF NOT EXISTS `byart_computer` ( `Id` int(11) NOT NULL auto_increment, `com_name` varchar(40) default NULL, `com_img_url` varchar(100) default NULL, `com_content` text, `add_date` date default NULL, `add_user` varchar(20) default NULL, `look_time` int(11) default '0', `com_stat` tinyint(1) default '0', `com_typeid` int(11) default NULL, `com_typename` varchar(40) default NULL, `com_cpu` varchar(40) default NULL, `com_memory` varchar(50) default NULL, `com_chipset` varchar(50) default NULL, `com_graphics` varchar(40) default NULL, `com_hdd` varchar(40) default NULL, `com_display` varchar(50) default NULL, `com_audio` varchar(40) default NULL, `com_lan` varchar(40) default NULL, `com_wlan` varchar(40) default '无', `com_power` varchar(50) default NULL, `com_keyboard` varchar(50) default NULL, `com_price` int(11) default NULL, `com_relprice` int(11) default NULL, `com_grade` varchar(20) default NULL, PRIMARY KEY (`Id`) ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=gbk AUTO_INCREMENT=4 ; -- -- 导出表中的数据 `byart_computer` -- INSERT DELAYED IGNORE INTO `byart_computer` (`Id`, `com_name`, `com_img_url`, `com_content`, `add_date`, `add_user`, `look_time`, `com_stat`, `com_typeid`, `com_typename`, `com_cpu`, `com_memory`, `com_chipset`, `com_graphics`, `com_hdd`, `com_display`, `com_audio`, `com_lan`, `com_wlan`, `com_power`, `com_keyboard`, `com_price`, `com_relprice`, `com_grade`) VALUES (1, 'ACER 4520G 300512', '/UploadFiles/1211300267a6g1nm.jpg', 'sdgsfgsdf', '2008-05-20', 'admin', 14, 1, 10, 'ACER宏基笔记本', 'AMD 炫龙 TL-56', '512MB DDR2 667', 'NVIDIA ', 'GF8400M G', '120GB S-ATA', '14.1', 'HD', '10/100MB', '802.11B/G', '', '', 4500, 4300, NULL), (2, 'ACER 4520G 300512', '/UploadFiles/1211300855fjyagf.jpg', 'gfghfgh', '2008-05-20', 'admin', 0, 1, 10, 'ACER宏基笔记本', 'AMD 炫龙 TL-56', '512MB DDR2 667', 'NVIDIA ', 'GF8400M G', '120GB S-ATA', '14.1', 'HD', '10/100MB', '802.11B/G', '', '', 4500, 4300, NULL), (3, 'ACER 4520G 300512', '/UploadFiles/1211302921vbxbzg.jpg', 'sdsfdsdfsf', '2008-05-20', 'admin', 8, 1, 10, 'ACER宏基笔记本', 'AMD 炫龙 TL-56', '512MB DDR2 667', 'NVIDIA ', 'GF8400M G', '120GB S-ATA', '14.1', 'HD', '10/100MB', '802.11B/G', '', '', 4500, 4300, '全新'); -- -------------------------------------------------------- -- -- 表的结构 `byart_down` -- DROP TABLE IF EXISTS `byart_down`; CREATE TABLE IF NOT EXISTS `byart_down` ( `Id` int(11) NOT NULL auto_increment, `down_title` varchar(200) default NULL, `down_url` varchar(100) default NULL, `down_content` text, `add_user` varchar(40) default NULL, `add_date` date default NULL, `look_time` int(11) default NULL, `down_typeid` int(11) default NULL, `down_typename` varchar(40) default NULL, PRIMARY KEY (`Id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=gbk AUTO_INCREMENT=2 ; -- -- 导出表中的数据 `byart_down` -- INSERT DELAYED IGNORE INTO `byart_down` (`Id`, `down_title`, `down_url`, `down_content`, `add_user`, `add_date`, `look_time`, `down_typeid`, `down_typename`) VALUES (1, '文件文件文件文件', '/UploadFiles/12094339011srx1g.xls', 'KKKKK', 'admin', '2008-04-29', NULL, 34, '常用表格'); -- -------------------------------------------------------- -- -- 表的结构 `byart_img` -- DROP TABLE IF EXISTS `byart_img`; CREATE TABLE IF NOT EXISTS `byart_img` ( `Id` int(11) NOT NULL auto_increment, `img_title` varchar(200) default NULL, `img_url` varchar(100) default NULL, `img_content` text, `add_date` date default NULL, `add_user` varchar(20) default NULL, `look_time` int(11) default '0', `img_stat` tinyint(1) default '0', `img_typeid` int(11) default NULL, `img_typename` varchar(40) default NULL, PRIMARY KEY (`Id`) ) ENGINE=MyISAM AUTO_INCREMENT=34 DEFAULT CHARSET=gbk AUTO_INCREMENT=34 ; -- -- 导出表中的数据 `byart_img` -- INSERT DELAYED IGNORE INTO `byart_img` (`Id`, `img_title`, `img_url`, `img_content`, `add_date`, `add_user`, `look_time`, `img_stat`, `img_typeid`, `img_typename`) VALUES (4, '优秀项目经理、项目总工领奖', '/UploadFiles/Image/1174308369.jpg', '', '2007-05-11', 'admin', 63, 1, 21, '图片新闻'), (5, '分组讨论', '/UploadFiles/Image/1174308415.jpg', '', '2007-03-19', 'admin', 57, 1, 21, '图片新闻'), (6, '经营部主任王苍松通报各项目经营责任制考核情况', '/UploadFiles/Image/1174308444.jpg', '', '2007-03-19', 'admin', 57, 1, 21, '图片新闻'), (7, '副分局长李全福作专题发言', '/UploadFiles/Image/1174308497.jpg', '', '2007-05-14', 'admin', 65, 1, 21, '图片新闻'), (8, '工会主席李义全作工会工作报告', '/UploadFiles/Image/1174308545.jpg', '', '2007-05-14', 'admin', 37, 1, 21, '图片新闻'), (9, '分局党委书记向学忠讲话', '/UploadFiles/Image/1174308575.jpg', '', '2007-03-19', 'admin', 60, 1, 21, '图片新闻'), (10, '分局长向学忠作行政工作报告', '/UploadFiles/Image/1174308612.jpg', '', '2007-05-14', 'admin', 64, 1, 21, '图片新闻'), (11, '副分局长方成名传达集团公司及局工作会精神', '/UploadFiles/Image/1174308712.jpg', '', '2007-03-19', 'admin', 53, 1, 21, '图片新闻'), (12, '大会会场', '/UploadFiles/Image/1174308743.jpg', '', '2007-03-19', 'admin', 71, 1, 21, '图片新闻'), (13, '大会主席台', '/UploadFiles/Image/1174308776.jpg', '', '2007-03-19', 'admin', 67, 1, 21, '图片新闻'), (14, '工程局领导莅临指�