photo_insert.sql

来自「drupal（内容管理系统CMS）的应用项目」· SQL 代码 · 共 35 行

-- phpMyAdmin SQL Dump
-- version 2.11.6
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jun 04, 2008 at 09:36 PM
-- Server version: 4.1.20
-- PHP Version: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `etreasure1`
--


-- --------------------------------------------------------

-- 
-- Table structure for `sms_game_photos`
-- 

CREATE TABLE `sms_game_photos` (
  `id` int(11) NOT NULL auto_increment,
  `photoPath` varchar(45) NOT NULL default '',
  `photoName` varchar(45) NOT NULL default '',
  `Game_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table  `sms_game_photos`
-- 

INSERT INTO `sms_game_photos` VALUES (1, 'http://127.0.0.1/images/6.jpg', 'lugano piazza', 1);