-- phpMyAdmin SQL Dump
-- version 2.10.2
-- http://www.phpmyadmin.net
-- 
-- 主機: localhost
-- 建立日期: Apr 18, 2011, 01:46 AM
-- 伺服器版本: 5.0.45
-- PHP 版本: 5.2.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- 
-- 資料庫: `carnac`
-- 

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

-- 
-- 資料表格式： `demo_ipdf`
-- 

CREATE TABLE `demo_ipdf` (
  `id` int(11) NOT NULL auto_increment COMMENT '編號',
  `title` varchar(50) collate utf8_unicode_ci NOT NULL COMMENT '標題',
  `author` varchar(20) collate utf8_unicode_ci default NULL COMMENT '作者',
  `type` varchar(20) collate utf8_unicode_ci default NULL COMMENT '類別',
  `content` mediumtext collate utf8_unicode_ci COMMENT '內容',
  `postdate` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP COMMENT '發布日期',
  `indicate` int(2) NOT NULL default '1' COMMENT '是否顯示',
  `notes1` varchar(20) collate utf8_unicode_ci default NULL COMMENT '備註1',
  `notes2` varchar(100) collate utf8_unicode_ci default NULL COMMENT '備註2',
  `sortid` int(11) NOT NULL default '0' COMMENT '排序',
  `lang` varchar(10) collate utf8_unicode_ci NOT NULL default 'zh-tw' COMMENT '語系',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='最新訊息' AUTO_INCREMENT=27 ;

-- 
-- 列出以下資料庫的數據： `demo_ipdf`
-- 

INSERT INTO `demo_ipdf` VALUES (19, '1111', '無', '無', NULL, '2011-04-15 10:36:28', 1, NULL, '200812014444331_2_20110415023625.jpg', 11, 'zh-tw');
INSERT INTO `demo_ipdf` VALUES (20, '1111', '無', '無', NULL, '2011-04-15 10:36:46', 1, NULL, '46181389-072-(600x800)_20110415023645.jpg', 111, 'zh-tw');
INSERT INTO `demo_ipdf` VALUES (21, 'ghgg', '無', '無', NULL, '2011-04-15 11:48:46', 1, NULL, '46181389-072-(600x800)_20110415034845.jpg', 77, 'zh-tw');
INSERT INTO `demo_ipdf` VALUES (18, 'kkk', '無', '無', NULL, '2011-04-15 10:36:07', 1, NULL, 'foot_bg_20110415023606.jpg', 1, 'zh-tw');
INSERT INTO `demo_ipdf` VALUES (17, '7777', '無', '無', NULL, '2011-04-14 16:04:20', 1, NULL, '200812014444331_2_20110414080417.jpg', 99, 'zh-tw');
INSERT INTO `demo_ipdf` VALUES (22, '777', '無', '無', NULL, '2011-04-15 11:49:35', 1, NULL, '46181389-072-(600x800)_20110415034934.jpg', 77, 'zh-tw');
INSERT INTO `demo_ipdf` VALUES (23, '77', '無', '無', NULL, '2011-04-15 11:49:49', 1, NULL, '46181389-072-(600x800)_20110415034949.jpg', 77, 'zh-tw');
INSERT INTO `demo_ipdf` VALUES (24, '77', '無', '無', NULL, '2011-04-15 11:50:02', 1, NULL, '46181389-072-(600x800)_20110415035002.jpg', 77, 'zh-tw');
INSERT INTO `demo_ipdf` VALUES (25, '77', '無', '無', NULL, '2011-04-15 11:50:15', 1, NULL, '46181389-072-(600x800)_20110415035015.jpg', 77, 'zh-tw');
INSERT INTO `demo_ipdf` VALUES (26, '77', '無', '無', NULL, '2011-04-15 11:50:29', 1, NULL, '2246864_202138087_2_20110415035028.jpg', 77, 'zh-tw');