[livejournal] r17624: LJSUP-7052. Add table for "Featured Post...

U   trunk/bin/upgrading/update-db-general.pl

Modified: trunk/bin/upgrading/update-db-general.pl
===================================================================
--- trunk/bin/upgrading/update-db-general.pl	2010-11-01 06:56:18 UTC (rev 17623)
+++ trunk/bin/upgrading/update-db-general.pl	2010-11-01 07:07:29 UTC (rev 17624)
@@ -3113,6 +3113,21 @@
 )
 EOC
 
+register_tablecreate("vertical_posts", <<'EOC');
+CREATE TABLE vertical_posts (
+  vert_id int(10) unsigned NOT NULL,
+  journalid int(10) unsigned NOT NULL,
+  jitemid int(10) unsigned NOT NULL,
+  timecreate datetime NOT NULL,
+  timeadded datetime NOT NULL,
+  is_deleted tinyint(1) default '0',
+  PRIMARY KEY  (journalid,jitemid),
+  KEY timecreate (timecreate),
+  KEY journalid (journalid),
+  KEY vert_id (vert_id)
+)
+EOC
+
 ## --
 ## -- embedconten previews
 ## --