All pastes #522694 Raw Edit

Unnamed

public text v1 · immutable
#522694 ·published 2007-05-30 14:31 UTC
rendered paste body
INSERT INTO wp_anigal_picture (`alb_id`, `path`, `filename`, `hits`, `width`, `height`, `pic_date`, `level`, `photo_order`) VALUES ('1', 'http://www.test.com/wp-content/gallery/00-single/', 'koe800x600.jpg', '0', '800', '600', '2007-05-30 16:06:24', '0', '1')

CREATE TABLE `".wp_anigal_picture."` (
				  `pid` bigint(20) NOT NULL auto_increment,
				  `alb_id` varchar(20) NOT NULL default '',
				  `path` varchar(200) NOT NULL default '',
				  `filename` varchar(200) NOT NULL default '',
				  `hits` bigint(20) NOT NULL default '0',
				  `width` smallint(6) NOT NULL default '0',
				  `height` smallint(6) NOT NULL default '0',
				  `pic_date` datetime NOT NULL,
				  `caption` text NOT NULL,
				  `level` VARCHAR(2) NOT NULL default '0',
                  `photo_order` bigint(20) NOT NULL,
			  PRIMARY KEY  (`pid`),
             KEY `photo_order` (`photo_order`)
  		)