【SQL开源代码栏目提醒】:以下是网学会员为您推荐的SQL开源代码-board.sql,希望本篇文章对您学习有所帮助。
锘?- phpMyAdmin SQL Dump
-- version 2.9.1-rc2
-- http://www.phpmyadmin.net
--
-- 涓绘満: localhost
-- 鐢熸垚鏃ユ湡: 2006 骞?11 鏈?18 鏃?15:53
-- 鏈嶅姟鍣ㄧ増鏈? 4.1.21
--
PHP 鐗堟湰: 4.4.4
--
-- 鏁版嵁搴? `board`
--
-- --------------------------------------------------------
--
-- 琛ㄧ殑缁撴瀯 `admin`
--
CREATE TABLE `admin` (
`username` varchar(50) default NULL,
`passwd` varchar(50) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;
--
-- 瀵煎嚭琛ㄤ腑鐨勬暟鎹?`admin`
--
INSERT INTO `admin` (`username`, `passwd`) VALUES
('admin', 'admin');
-- --------------------------------------------------------
--
-- 琛ㄧ殑缁撴瀯 `board`
--
CREATE TABLE `board` (
`boardid` int(11) unsigned NOT NULL auto_increment,
`boardname` varchar(50) default NULL,
`boardsex` varchar(50) default NULL,
`boardsubject` varchar(100) default NULL,
`boardtime` datetime default NULL,
`boardmail` varchar(100) default NULL,
`boardweb` varchar(100) default NULL,
`boardcontent` text,
PRIMARY KEY (`boardid`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312 AUTO_INCREMENT=6 ;
--
-- 瀵煎嚭琛ㄤ腑鐨勬暟鎹?`board`
--
INSERT INTO `board` (`boardid`, `boardname`, `boardsex`, `boardsubject`, `boardtime`, `boardmail`, `board
web`, `boardcontent`) VALUES
(1, '璺汉鐢?, 'male.gif', '濂界偒鐨勭暀瑷鏉垮晩锛?, '2006-10-08 11:22:59', NULL, NULL, '濂界偒鐨勭暀瑷鏉垮晩锛岀湡妫掞紒'),
(2, '璺汉涔?, 'female.gif', '鎴戜篃濂芥兂瑕佷竴涓?, '2006-11-18 15:25:40', NULL, NULL, '鎴戜篃濂芥兂瑕佷竴涓暀瑷鏉匡紒'),
(3, '璺汉鐢?, 'male.gif', '杩欎釜绋嬪簭鎬庝箞鍋?, '2006-11-18 15:28:58', NULL, NULL, '璇烽棶杩欎釜绋嬪簭鎬庝箞鍋氾紵'),
(4, '鑼剁背绔欓暱', 'male.gif', '寰堢畝鍗?, '2006-11-18 15:30:31', 'david@e-happy.com.tw', 'http://www.e-happy.com.tw', '寰堢畝鍗曪紝鎮ㄥ彧瑕佺敤Dreamweaver灏卞ソ浜嗐?);