【SQL开源代码栏目提醒】:文章导读:在新的一年中,各位网友都进入紧张的学习或是工作阶段。网学会员整理了SQL开源代码-ksutdorm.sql的相关内容供大家参考,祝大家在新的一年里工作和学习顺利!
-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version 5.0.9-beta-nt
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
--
-- Create schema ksutdorm
--
CREATE DATABASE /*!32312 IF NOT EXISTS*/ ksutdorm;
USE ksutdorm;
--
-- Table structure for table `ksutdorm`.`error`
--
DROP TABLE IF EXISTS `error`;
CREATE TABLE `error` (
`Error_No` int(4) unsigned NOT NULL auto_increment,
`Error_Snum` char(8) NOT NULL,
`Error_Name` varchar(10) NOT NULL,
`Error_IP` char(15) NOT NULL default '0.0.0.0',
`Error_Phone` char(10) NOT NULL,
`Error_MAC1` char(2) NOT NULL default '00',
`Error_MAC2` char(2) NOT NULL default '00',
`Error_MAC3` char(2) NOT NULL default '00',
`Error_MAC4` char(2) NOT NULL default '00',
`Error_MAC5` char(2) NOT NULL default '00',
`Error_MAC6` char(2) NOT NULL default '00',
`Error_Dorm` int(4) NOT NULL,
`Error_Contents` text character set utf8 NOT NULL,
`Error_Date` date NOT NULL,
`Error_Time` time NOT NULL,
`Error_ReplyMsg` text character set utf8,
`Error_ST` char(1) NOT NULL default '0',
PRIMARY KEY (`Error_No`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `ksutdorm`.`error`
--
/*!40000 ALTER TABLE `error` DISABLE KEYS */;
/*!40000 ALTER TABLE `error` ENABLE KEYS */;
--
-- Table structure for table `ksutdorm`.`net_info`
--
DROP TABLE IF EXISTS `net_info`;
CREATE TABLE `net_info` (
`Info_No` int(4) unsigned NOT NULL auto_increment,
`Info_Snum` char(8) NOT NULL,
`Info_Mac1` varchar(2) character set utf8 NOT NULL default 'FF',
`Info_Mac2` varchar(2) character set utf8 NOT NULL default 'FF',
`Info_Mac3` varchar(2) character set utf8 NOT NULL default 'FF',
`Info_Mac4` varchar(2) character set utf8 NOT NULL default 'FF',
`Info_Mac5` varchar(2) character set utf8 NOT NULL default 'FF',
`Info_Mac6` varchar(2) character set utf8 NOT NULL default 'FF',
`Info_IP` char(15) character set latin1 collate latin1_bin NOT NULL default '0.0.0.0',
`Info_Netmask` char(15) character set latin1 collate latin1_bin NOT NULL default '255.255.255.0',
`Info_Gateway` char(15) character set latin1 collate latin1_bin NOT NULL default '0.0.0.0',
`Info_Dns1` char(15) character set latin1 collate latin1_bin NOT NULL default '203.71.36.253',
`Info_Dns2` char(15) character set latin1 collate latin1_bin NOT NULL default '203.71.51.252',
PRIMARY KEY (`Info_No`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `ksutdorm`.`net_info`
--
/*!40000 ALTER TABLE `net_info` DISABLE KEYS */;
INSERT INTO `net_info` (`Info_No`,`Info_Snum`,`Info_Mac1`,`Info_Mac2`,`Info_Mac3`,`Info_Mac4`,`Info_Mac5`,`Info_Mac6`,`Info_IP`,`Info_Netmask`,`Info_Gateway`,`Info_Dns1`,`Info_Dns2`) VALUES
(1,'U930Q125','12','31','3E','31','31','31','0.0.0.0','255.255.255.0','0.0.0.0','203.71.36.253','203.71.51.252'),
(2,'U930Q126','23','32','31','31','31','AD','0.0.0.0','255.255.255.0','0.0.0.0','203.71.36.253','203.71.51.252');
/*!40000 ALTER TABLE `net_info` ENABLE KEYS */;
--
-- Table structure for table `ksutdorm`.`post`
--
DROP TABLE IF EXISTS `post`;
CREATE TABLE `post` (
`Post_No` int(3) unsigned NOT NULL auto_increment,
`Post_Date` date NOT NULL default '0000-00-00',
`Post_Time` time NOT NULL default '00:00:00',
`Post_Contents` text character set utf8 NOT NULL,
`Post_Name` varchar(6) character set utf8 NOT NULL,
`Post_Snum` char(8) NOT NULL,
`Post_LimitName` varchar(6) character set utf8 NOT NULL,
PRIMARY KEY (`Post_No`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `ksutdorm`.`post`
--
/*!40000 ALTER TABLE `post` DISABLE KEYS */;
INSERT INTO `post` (`Post_No`,`Post_Date`,`Post_Time`,`Post_Contents`,`Post_Name`,`Post_Snum`,`Post_LimitName`) VALUES
(72,'2005-12-15','15:30:38','【中心公告】小宝叫什麽...小宝叫什麽....叫小吗...哇..