【SQL开源代码栏目提醒】:网学会员SQL开源代码为您提供install.sql参考,解决您在install.sql学习中工作中的难题,参考学习。
-- phpMyAdmin SQL Dump
-- version 2.10.0.2
-- http://www.phpmyadmin.net
--
-- 涓绘満: localhost
-- 鐢熸垚鏃ユ湡: 2007 骞?05 鏈?15 鏃?09:59
-- 鏈嶅姟鍣ㄧ増鏈? 5.0.27
--
PHP 鐗堟湰: 4.4.4
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- 鏁版嵁搴? `guestbook`
--
-- --------------------------------------------------------
--
-- 琛ㄧ殑缁撴瀯 `messages`
--
CREATE TABLE `messages` (
`id` int(11) NOT NULL auto_increment,
`uid` int(11) NOT NULL default '0',
`name` varchar(20) NOT NULL default '',
`email` varchar(150) NOT NULL default '',
`content` text NOT NULL,
`reply` text,
`ip` int(11) NOT NULL default '-1',
`longitude` decimal(11,8) NOT NULL default '0.00000000',
`latitude` decimal(11,8) NOT NULL default '0.00000000',
`posttime` datetime NOT NULL default '0000-00-00 00:00:00',
`replytime` datetime default NULL,
`display` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`id`),
KEY `display` (`display`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- 琛ㄧ殑缁撴瀯 `users`
--
CREATE TABLE `users` (
`uid` int(11) NOT NULL auto_increment,
`uname` varchar(20) NOT NULL default '',
`upass` varchar(32) NOT NULL default '',
`upass2` varchar(32) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`regtime` datetime NOT NULL default '0000-00-00 00:00:00',
`lastlogin` datetime default NULL,
`activated` tinyint(1) NOT NULL default '0',
`settings` varchar(90) NOT NULL default '2|30.58, 114.27|0|true',
PRIMARY KEY (`uid`),
UNIQUE KEY `email` (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- 蹇呴』鎵嬪姩鎻掑叆绗竴涓敤鎴穉dmin锛屽瘑鐮乤bc锛屼互鍚庡彲浠ヤ慨鏀?
-- 灏氬湪娴嬭瘯锛屼笉瀹屽杽
--
INSERT INTO `users` VALUES (1, 'admin', '900150983CD24FB0D6963F7D28E17F72', '900150983CD24FB0D6963F7D28E17F72', 'admin@example.com', '2007-03-16 00:00:00', '2007-05-16 01:15:43', 1, '6|32.639375,114.257813|0|false');