« Previous entry | Next entry » Browse > Snippets

Skip to comments (4) Sql for Nicko
Posted by guest on Apr 06 2008 @ 16:21  :: 1103 unique visits

CREATE TABLE `ibwf_cards` (
 `id` int(10) NOT NULL auto_increment,
 `fntsz` int(5) NOT NULL default \'0\',
 `xst` int(10) NOT NULL default \'0\',
 `yst` int(10) NOT NULL default \'0\',
 `xjp` int(10) NOT NULL default \'0\',
 `yjp` int(10) NOT NULL default \'0\',
 `tcolor` varchar(20) NOT NULL default \'\',
 `category` varchar(20) NOT NULL default \'\',
 PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

INSERT INTO `ibwf_cards` (`fntsz`,`xst`,`yst`) VALUES
(\'(001)\', \'../pmcards/001.jpg\',1),
(\'(002)\', \'../pmcards/002.jpg\',\'2\'),
(\'(003)\', \'../pmcards/003.jpg\',\'3\'),
(\'(004)\', \'../pmcards/004.jpg\',\'4\'),
(\'(005)\', \'../pmcards/005.jpg\',\'5\'),
(\'(006)\', \'../pmcards/006.jpg\',\'6\'),
(\'(007)\', \'../pmcards/007.jpg\',\'7\');

4 comments posted so far
Add your own »