AudioFerret/v2/cut x topic: Difference between revisions

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Created page with "==About== * '''History''': ** '''2012-12-24''' adapted from VbzCart/tables/cat title x topic ==SQL== <mysql>CREATE TABLE `title_x_cut` ( `ID_Cut` INT NOT NULL COMMENT "c..."
 
post-move update
 
(One intermediate revision by the same user not shown)
Line 3: Line 3:
** '''2012-12-24''' adapted from [[VbzCart/tables/cat title x topic]]
** '''2012-12-24''' adapted from [[VbzCart/tables/cat title x topic]]
==SQL==
==SQL==
<mysql>CREATE TABLE `title_x_cut` (
<mysql>CREATE TABLE `cut_x_topic` (
   `ID_Cut` INT NOT NULL COMMENT "cuts.ID",
   `ID_Cut` INT NOT NULL COMMENT "cuts.ID",
   `ID_Topic` INT NOT NULL COMMENT "topics.ID",
   `ID_Topic` INT NOT NULL COMMENT "topics.ID",
   PRIMARY KEY(`ID_Cut`,`ID_Topic`)
   PRIMARY KEY(`ID_Cut`,`ID_Topic`)
) ENGINE = MYISAM;</mysql>
) ENGINE = MYISAM;</mysql>

Latest revision as of 02:53, 25 December 2012

About

SQL

<mysql>CREATE TABLE `cut_x_topic` (

 `ID_Cut` INT NOT NULL COMMENT "cuts.ID",
 `ID_Topic` INT NOT NULL COMMENT "topics.ID",
 PRIMARY KEY(`ID_Cut`,`ID_Topic`)

) ENGINE = MYISAM;</mysql>