【SQL开源代码栏目提醒】:以下是网学会员为您推荐的SQL开源代码-webalbum.sql,希望本篇文章对您学习有所帮助。
锘?- phpMyAdmin SQL Dump
-- version 2.9.1-rc2
-- http://www.phpmyadmin.net
--
-- 涓绘満: localhost
-- 鐢熸垚鏃ユ湡: 2006 骞?11 鏈?08 鏃?14:00
-- 鏈嶅姟鍣ㄧ増鏈? 4.1.21
--
PHP 鐗堟湰: 4.4.4
--
-- 鏁版嵁搴? `webalbum`
--
-- --------------------------------------------------------
--
-- 琛ㄧ殑缁撴瀯 `albumcategory`
--
CREATE TABLE `albumcategory` (
`ca_id` int(11) unsigned NOT NULL auto_increment,
`ca_name` varchar(255) default NULL,
PRIMARY KEY (`ca_id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312 AUTO_INCREMENT=6 ;
--
-- 瀵煎嚭琛ㄤ腑鐨勬暟鎹?`albumcategory`
--
INSERT INTO `albumcategory` (`ca_id`, `ca_name`) VALUES
(1, '鏃呮父鐓х墖'),
(2, '灏忔湅鍙嬬収鐗?),
(3, '鍚屼簨鐓х墖');
-- --------------------------------------------------------
--
-- 琛ㄧ殑缁撴瀯 `albummain`
--
CREATE TABLE `albummain` (
`album_id` int(11) unsigned NOT NULL auto_increment,
`ca_id` int(11) unsigned default NULL,
`album_date` datetime default NULL,
`album_title` varchar(255) default NULL,
`album_desc` text,
PRIMARY KEY (`album_id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312 AUTO_INCREMENT=11 ;
--
-- 瀵煎嚭琛ㄤ腑鐨勬暟鎹?`albummain`
--
INSERT INTO `albummain` (`album_id`, `ca_id`, `album_date`, `album_title`, `album_desc`) VALUES
(1, 1, '2006-07-28 15:12:23', '鏄嗘槑涔嬫梾', '2005骞存槬澶╁埌鏄嗘槑涓娓革紝鍗佸垎闅惧繕銆?),
(2, 1, '2006-07-28 15:17:17', '鎽╂礇鍝ュ崟杞︿箣鏃?, '鍘嗙粡鍗佷竷鏃ョ殑鍗曡溅鎽╂礇鍝ヤ箣鏃咃紝鍦ㄧ儓鏃ョ殑閰锋檼鑰冮獙涔嬩笅锛屽叏浣撹溅鍙嬬粓浜庡畨鐒惰浇瑾夊洖褰掞紝璁╂懇娲涘摜浜哄Taiwan鐨勫搧鐗屼互鍙婂瓙姘戠殑鐖卞績鍜岀瀻鎷艰兘鍔涘ぇ澶х殑璁よ瘑涓庤禐鎵傛湰娆″崐鑷姪鏃呮父澶ц嚦绗﹀悎涓鍙ュ悕瑷锛氣滄梾娓告湰鏉ュ氨鍑烘弧鎰忓锛屾梾娓哥殑鍙吹涔熷湪姝ゅ銆傗濅簨鍚庡洖鍛宠捣鏉ユ洿鏈夎嫤灏界敇鏉ヤ箣鎱ㄣ?),
(3, 2, '2006-07-28 15:26:42', '灏忚姵鐨勭収鐗?, '杩欎釜鏄皬鑺崇殑绮鹃夌収鐗囷紝璇峰悇浣嶅悓瀛︽媿鎷嶆墜锛?),
(4, 2, '2006-07-28 15:31:03', '灏忓鐨勭収鐗?, '瀹囧畽瓒呯骇澶х編濂冲皬瀹g殑涓汉鍐欑湡鍠旓紒'),
(5, 3, '2006-07-28 15:46:22', '宸ヤ綔瀹?006骞寸収鐗囨敹闆?, '杩欓噷鏀堕泦浜嗘垜浠繖涓骞存潵绮惧僵鐨勭収鐗囧枖锛屾杩庡悓浜嬩滑澶氬鎻愪緵锛?);
-- --------------------------------------------------------
--
-- 琛ㄧ殑缁撴瀯 `albumphoto`
--
CREATE TABLE `albumphoto` (
`ap_id` int(11) unsigned NOT NULL auto_increment,
`album_id` int(11) unsigned default NULL,
`ap_date` datetime default NULL,
`ap_width` varchar(255) default NULL,
`ap_height` varchar(255) default NULL,
`ap_picurl` varchar(100) default NULL,
PRIMARY KEY (`ap_id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312 AUTO_INCREMENT=46 ;
--
-- 瀵煎嚭琛ㄤ腑鐨勬暟鎹?`albumphoto`
--
INSERT INTO `albumphoto` (`ap_id`, `album_id`, `ap_date`, `ap_width`, `ap_height`, `ap_picurl`) VALUES
(1, 1, '2006-07-28 15:13:01', '640', '480', '001_1.JPG'),
(2, 1, '2006-07-28 15:13:24', '640', '480', '001_2.JPG'),
(3, 1, '2006-07-28 15:13:41', '640', '480', '001_3.JPG'),
(4, 1, '2006-07-28 15:13:55', '640', '480', '001_4.JPG'),
(5, 1, '2006-07-28 15:14:13', '640', '480', '001_5.JPG'),
(6, 1, '2006-07-28 15:14:31', '640', '480', '001_6.JPG'),
(7, 2, '2006-07-28 15:17:39', '480', '640', '002_1.JPG'),
(8, 2, '2006-07-28 15:18:46', '640', '480', '002_2.JPG'),
(9, 2, '2006-07-28 15:19:03', '480', '640', '002_3.JPG'),
(10, 2, '2006-07-28 15:24:02', '640', '480', '002_4.JPG'),
(11, 2, '2006-07-28 15:24:24', '640', '480', '002_5.JPG'),
(12, 2, '2006-07-28 15:24:43', '640', '480', '002_6.JPG'),
(13, 3, '2006-07-28 15:27:03', '480', '640', '003_1.JPG'),
(14, 3, '2006-07-28 15:27:29', '640', '480', '003_2.JPG'),
(15, 3, '2006-07-28 15:27:50', '426', '640', '003_3.JPG'),
(16, 3, '2006-07-28 15:28:10', '640', '426', '003_4.JPG'),
(18, 3, '2006-07-28 15:29:43', '640', '480', '003_5.JPG'),
(19, 3, '2006-07-28 15:30:10', '426', '640', '003_6.JPG'),
(20, 4, '2006-07-28 15:31:23', '640', '480', '004_1.JPG'),
(21, 4, '2006-07-28 15:32:27', '426', '640', '004_2.JPG'),
(22, 4, '2006-07-28 15:32:42', '426', '640', '004_3.JPG'),
(23, 4, '2006-07-28 15:32:58', '640', '480', '004_4.JPG'),
(24, 4, '2006-07-28 15:33:17', '426', '640', '004_5.JPG'),
(25, 4, '2006-07-28 15:33:34', '640', '480', '004_6.JPG'),
(26, 5, '2006-07-28 15:46:41', '426', '640', '005_1.JPG'),
(27, 5, '2006-07-28 15:46:51',