-- MySQL dump 9.10
--
-- Host: localhost    Database: jointest
-- ------------------------------------------------------
-- Server version	4.0.18-standard

--
-- Table structure for table `tt_news`
--

CREATE TABLE tt_news (
  uid int(11) unsigned NOT NULL auto_increment,
  title tinytext NOT NULL,
  KEY uid (uid)
) TYPE=MyISAM;

--
-- Dumping data for table `tt_news`
--

INSERT INTO tt_news VALUES (1,'News Article 1');
INSERT INTO tt_news VALUES (2,'News Article 2');
INSERT INTO tt_news VALUES (3,'News Article 3');

--
-- Table structure for table `tt_news_cat`
--

CREATE TABLE tt_news_cat (
  uid int(11) unsigned NOT NULL auto_increment,
  priority tinyint(4) unsigned NOT NULL default '1',
  name tinytext NOT NULL,
  KEY uid (uid)
) TYPE=MyISAM;

--
-- Dumping data for table `tt_news_cat`
--

INSERT INTO tt_news_cat VALUES (1,1,'Headline');
INSERT INTO tt_news_cat VALUES (2,3,'Seminar');
INSERT INTO tt_news_cat VALUES (3,10,'Partner News');

--
-- Table structure for table `tt_news_cat_mm`
--

CREATE TABLE tt_news_cat_mm (
  uid_local int(11) unsigned NOT NULL default '0',
  uid_foreign int(11) unsigned NOT NULL default '0',
  KEY uid_local (uid_local),
  KEY uid_foreign (uid_foreign)
) TYPE=MyISAM;

--
-- Dumping data for table `tt_news_cat_mm`
--

INSERT INTO tt_news_cat_mm VALUES (1,2);
INSERT INTO tt_news_cat_mm VALUES (2,1);
INSERT INTO tt_news_cat_mm VALUES (2,3);
INSERT INTO tt_news_cat_mm VALUES (3,3);
INSERT INTO tt_news_cat_mm VALUES (3,1);