Committer: gprochaev
LJSUP-7052. Landing Page.U trunk/bin/upgrading/update-db-general.pl U trunk/cgi-bin/LJ/Vertical.pm
Modified: trunk/bin/upgrading/update-db-general.pl =================================================================== --- trunk/bin/upgrading/update-db-general.pl 2010-10-26 06:47:36 UTC (rev 17605) +++ trunk/bin/upgrading/update-db-general.pl 2010-10-26 07:13:08 UTC (rev 17606) @@ -3311,6 +3311,18 @@ ) EOC +register_tablecreate('category_recent_posts', <<'EOC'); +CREATE TABLE category_recent_posts ( + jitemid int(11) NOT NULL default '0', + timecreate datetime NOT NULL, + journalid int(10) unsigned NOT NULL, + is_deleted tinyint(1) NOT NULL default '0', + PRIMARY KEY (`journalid`,`jitemid`), + KEY `timecreate` (`timecreate`), + KEY `journalid` (`journalid`) +) +EOC + # PingBack relations register_tablecreate("pingrel", <<'EOC'); CREATE TABLE pingrel ( Modified: trunk/cgi-bin/LJ/Vertical.pm =================================================================== --- trunk/cgi-bin/LJ/Vertical.pm 2010-10-26 06:47:36 UTC (rev 17605) +++ trunk/cgi-bin/LJ/Vertical.pm 2010-10-26 07:13:08 UTC (rev 17606) @@ -341,7 +341,7 @@ undef, $self->{name}, $self->{url}); die $dbh->errstr if $dbh->err; - return $class->new( vertid => $dbh->{mysql_insertid} ); + return $class->new( vert_id => $dbh->{mysql_insertid} ); } sub get_categories {