www.pudn.com > xunibuluo.rar > mydb.sql

# File name: D:\mydb.sql 
# Creation date: 04/30/2008 
# Created by Access to MySQL 3.5 [Demo] 
# -------------------------------------------------- 
# More conversion tools at http://www.convert-in.com 
 
DROP DATABASE IF EXISTS mydb; 
CREATE DATABASE mydb; 
USE mydb; 
mysql_query("SET NAMES 'GB2312'"); 
# 
# Table structure for table 'friend' 
# 
 
DROP TABLE IF EXISTS friend; 
CREATE TABLE friend ( 
  fromid VARCHAR(50) NOT NULL, 
  toid VARCHAR(50) NOT NULL, 
  INDEX fromid (fromid), 
  INDEX toid (toid) 
) TYPE=MyISAM; 
 
# 
# Dumping data for table 'friend' 
# 
 
LOCK TABLES friend WRITE; 
UNLOCK TABLES; 
 
# 
# Table structure for table 'message' 
# 
 
DROP TABLE IF EXISTS message; 
CREATE TABLE message ( 
  num INT NOT NULL AUTO_INCREMENT, 
  fromid VARCHAR(50) NOT NULL, 
  toid VARCHAR(50) NOT NULL, 
  message VARCHAR(80), 
  title VARCHAR(50), 
  zjtime VARCHAR(50), 
  INDEX fromid (fromid), 
  PRIMARY KEY (num), 
  INDEX toid (toid) 
) TYPE=MyISAM; 
 
# 
# Dumping data for table 'message' 
# 
 
LOCK TABLES message WRITE; 
UNLOCK TABLES; 
 
# 
# Table structure for table 'pic' 
# 
 
DROP TABLE IF EXISTS pic; 
CREATE TABLE pic ( 
  id INT NOT NULL AUTO_INCREMENT, 
  zjtime VARCHAR(50), 
  pic_url VARCHAR(50), 
  PRIMARY KEY (id) 
) TYPE=MyISAM; 
 
# 
# Dumping data for table 'pic' 
# 
 
LOCK TABLES pic WRITE; 
INSERT INTO pic (zjtime,pic_url) VALUES('2008-4-5', '1.jpg'); 
UNLOCK TABLES; 
 
# 
# Table structure for table 'player' 
# 
 
DROP TABLE IF EXISTS player; 
CREATE TABLE player ( 
  id VARCHAR(50) NOT NULL, 
  password VARCHAR(50), 
  name VARCHAR(50), 
  ssex VARCHAR(50), 
  question VARCHAR(50), 
  answer VARCHAR(50), 
  pic VARCHAR(50), 
  year VARCHAR(50), 
  month VARCHAR(50), 
  day VARCHAR(50), 
  myword VARCHAR(50), 
  money VARCHAR(50), 
  zctime VARCHAR(50), 
  INDEX id (id), 
  PRIMARY KEY (id) 
) TYPE=MyISAM; 
 
# 
# Dumping data for table 'player' 
# 
 
LOCK TABLES player WRITE; 
insert into player(id,password,name,ssex,money) values('admin','admin','管理员','神','99999'); 
UNLOCK TABLES; 
 
# 
# Table structure for table 'sayword' 
# 
 
DROP TABLE IF EXISTS sayword; 
CREATE TABLE sayword ( 
  from00000 VARCHAR(50), 
  face VARCHAR(50), 
  word VARCHAR(50), 
  time VARCHAR(50), 
  zjtime VARCHAR(50) 
) TYPE=MyISAM; 
 
# 
# Dumping data for table 'sayword' 
# 
 
LOCK TABLES sayword WRITE; 
UNLOCK TABLES; 
 
# 
# Table structure for table 'shop' 
# 
 
DROP TABLE IF EXISTS shop; 
CREATE TABLE shop ( 
  id INT NOT NULL AUTO_INCREMENT, 
  soldid VARCHAR(50) NOT NULL, 
  xinyong VARCHAR(50), 
  shopmes VARCHAR(50), 
  shoppic VARCHAR(50), 
  shopname VARCHAR(50), 
  PRIMARY KEY (id), 
  INDEX soldid (soldid) 
) TYPE=MyISAM; 
 
# 
# Dumping data for table 'shop' 
# 
 
LOCK TABLES shop WRITE; 
insert into shop (soldid,xinyong,shopmes,shopname,shoppic) values('admin','99','店铺第一个','店铺有间','3.png'); 
UNLOCK TABLES; 
 
# 
# Table structure for table 'shoppic' 
# 
 
DROP TABLE IF EXISTS shoppic; 
CREATE TABLE shoppic ( 
  id INT NOT NULL AUTO_INCREMENT, 
  pic_url VARCHAR(50), 
  zjtime VARCHAR(50), 
  PRIMARY KEY (id) 
) TYPE=MyISAM; 
 
# 
# Dumping data for table 'shoppic' 
# 
 
LOCK TABLES shoppic WRITE; 
INSERT INTO shoppic (zjtime,pic_url) VALUES('2008-4-5', '1.jpg'); 
UNLOCK TABLES; 
 
# 
# Table structure for table 'thing' 
# 
 
DROP TABLE IF EXISTS thing; 
CREATE TABLE thing ( 
  id INT NOT NULL AUTO_INCREMENT, 
  shopid VARCHAR(50) NOT NULL, 
  thingname VARCHAR(50), 
  pic VARCHAR(50), 
  thingmes VARCHAR(50), 
  starttime VARCHAR(50), 
  endtime VARCHAR(50), 
  money VARCHAR(50), 
  find VARCHAR(50), 
  PRIMARY KEY (id), 
  INDEX shopid (shopid) 
) TYPE=MyISAM; 
 
# 
# Dumping data for table 'thing' 
# 
 
LOCK TABLES thing WRITE; 
insert into thing (shopid,thingname,pic,thingmes,starttime,endtime,money,find) values('admin','book','3.png','english','2008-4-5','2009-5-2','15','13*****'); 
UNLOCK TABLES;