All pastes #615242 Raw Edit

Miscellany

public text v1 · immutable
·published 2007-07-12 01:02 UTC
rendered paste body

CREATE TABLE `mak` (
  `id` int(250) NOT NULL auto_increment,
  `name` varchar(250) NOT NULL,
  `info` longtext NOT NULL,
  `type` varchar(250) NOT NULL,
  `user` varchar(250) NOT NULL,
  `rating` int(250) NOT NULL,
  `votes` int(250) NOT NULL,
  `date` int(250) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

INSERT INTO `mak` (`id`, `name`, `info`, `type`, `user`, `rating`, `votes`, `date`) VALUES 
(36, 'Magically Animated Glove', 'random information too long and pointless', 'familiar', 'canada joe101', 8, 1, 1184127857);

CREATE TABLE `comments` (
  `id` int(250) NOT NULL auto_increment,
  `comment` longtext NOT NULL,
  `about` int(250) NOT NULL,
  `user` varchar(250) NOT NULL,
  `date` int(11) NOT NULL,
  `first` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

INSERT INTO `comments` (`id`, `comment`, `about`, `user`, `date`, `first`) VALUES 
(113, '<i>Idea posted</i>', 36, 'canada joe101', 1184127857, 1);

There's an example of inserts, and the table structures. The comment posted is the one that is automatically posted every time an article is created.