wisest owl (wisest_owl) wrote in changelog,
wisest owl
wisest_owl
changelog

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

Committer: gprochaev
LJSUP-7052. Add table for "Featured Posts"

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
 ## --

Tags: livejournal, pl, wisest-owl
Subscribe
  • Post a new comment

    Error

    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

    Your IP address will be recorded 

  • 0 comments