Ticket #3952: linkage.sql

File linkage.sql, 491 bytes (added by Wolfgang <mythtv@…>, 13 years ago)

sql for creating linkage table

Line 
1-- MySQL dump 10.11
2--
3-- Host: localhost    Database: mythconverg
4-- ------------------------------------------------------
5-- Server version       5.0.42-log
6
7--
8-- Table structure for table `linkage`
9--
10
11DROP TABLE IF EXISTS `linkage`;
12CREATE TABLE `linkage` (
13  `portal_chanid` int(11) NOT NULL,
14  `serviceid` int(11) NOT NULL,
15  `chanid` int(11) NOT NULL,
16  `subevent` varchar(255) character set utf8 NOT NULL,
17  KEY `portal_chanid` (`portal_chanid`)
18) ENGINE=MyISAM DEFAULT CHARSET=latin1;
19