Changeset 10 for trunk/install/jr_modelglue_20091019.sql

Timestamp:

10/28/09 18:06:27 (16 years ago)

Author:

DanWilson

Message:

Updates to the table definititions because of version differences in BlogCFC

Files:

• trunk/install/jr_modelglue_20091019.sql (modified) (3 diffs)

trunk/install/jr_modelglue_20091019.sql

@@ -271 +271 @@
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
---
--- Dumping data for table `tblblogcategories`
---
-
-LOCK TABLES `tblblogcategories` WRITE;
-/*!40000 ALTER TABLE `tblblogcategories` DISABLE KEYS */;
-INSERT INTO `tblblogcategories` VALUES ('6583E7D5-3048-55C9-43407FFC14CFD35A','Joe on Model-Glue','Joe-on-ModelGlue','modelglue'),('6843382C-3048-55C9-4391FBF0A70B59F8','Model-Glue News','ModelGlue-News','modelglue'),('6D9943C0-3048-55C9-436869CC13498D56','Joe on Model-Glue: Flex','Joe-on-ModelGlue-Flex','modelglue'),('9BE768A4-3048-55C9-435EB0DC3A56D373','Scott on Model-Glue','Scott-on-ModelGlue','modelglue'),('9BE7B8F6-3048-55C9-43E1B3E5992921CC','Scott on Model-Glue: Flex','Scott-on-ModelGlue-Flex','modelglue'),('BF420DF9-3048-55C9-43273599C9536D70','Off Topic','Off-Topic','modelglue'),('3BD2BF68-3048-55C9-4358762A45F035DE','Jared on MG:U','Jared-on-MGU','modelglue'),('3BD2E87B-3048-55C9-43528962B0870C5D','Jared on MG:F','Jared-on-MGF','modelglue'),('7D83CB70-FF1D-C52F-5E431175162E374D','Gesture is Coming','Gesture-is-Coming','modelglue'),('3537B38C-FF1D-C52F-5EF4BF9E7EAFA7DC','Ask Team Model-Glue','Ask-Team-ModelGlue','modelglue'),('549545AF-FF1D-C52F-5EF24F4A86C7A492','Training','Training','modelglue');
-/*!40000 ALTER TABLE `tblblogcategories` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `tblblogcomments`
---
-
-DROP TABLE IF EXISTS `tblblogcomments`;
+-- ----------------------------
+-- Table structure for tblblogcomments
+-- ----------------------------
 CREATE TABLE `tblblogcomments` (
   `id` varchar(35) character set latin1 NOT NULL default '',
@@ -296 +284 @@
   `website` varchar(255) default NULL,
   `moderated` tinyint(1) default NULL,
+  `killcomment` varchar(35) default NULL,
+  `subscribeonly` tinyint(4) default NULL,
   PRIMARY KEY  (`id`),
   KEY `blogComments_entryid` (`entryidfk`),
@@ -332 +322 @@
   `released` tinyint(1) default '0',
   `mailed` tinyint(1) default '0',
+  `summary` varchar(255) default NULL,
+  `subtitle` varchar(100) default NULL,
+  `keywords` varchar(100) default NULL,
+  `duration` varchar(10) default NULL,
   PRIMARY KEY  (`id`),
   KEY `blogEntries_blog` (`blog`),