DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

Reinis Veips

Reinis has posted 8 posts at DZone. View Full User Profile

DB StruktÅ«ra BBrokastu Humora Topa SavÄcÄ“jam

12.02.2008

| 1668 views |

CREATE TABLE `ieraksti` (
  `id` int(11) NOT NULL auto_increment,
  `temas_id` int(11) NOT NULL,
  `text` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;

CREATE TABLE `temas` (
  `id` int(11) NOT NULL auto_increment,
  `date_added` datetime NOT NULL,
  `name` varchar(100) NOT NULL,
  `link` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;

Tags: