Committer: vtroitsky
OPSC-349: Database update for multiple application views: userapps_views table addedU trunk/bin/upgrading/update-db-local.pl
Modified: trunk/bin/upgrading/update-db-local.pl =================================================================== --- trunk/bin/upgrading/update-db-local.pl 2011-09-12 09:20:04 UTC (rev 10992) +++ trunk/bin/upgrading/update-db-local.pl 2011-09-13 06:21:49 UTC (rev 10993) @@ -1711,6 +1711,20 @@ ) ENGINE=InnoDB }); +# see LJ::UserApps::ApplicationView +# Store views available for specific application (configured in admin panel) +register_tablecreate('userapps_views', qq{ + CREATE TABLE userapps_views ( + view_id varchar(32) NOT NULL, # view_id (link to common properties) + application_id int unsigned NOT NULL, # application id + embed_type ENUM('flash','generated','html','url','static') NOT NULL DEFAULT 'url', # view embedding type (different subclasses used for it) + callback_url varchar(255) DEFAULT '', # application backend server callback for that view + width int(10) unsigned NOT NULL DEFAULT 320, # view width that fit restrictions + height int(10) unsigned NOT NULL DEFAULT 200, # view height that fit restrictions + UNIQUE INDEX (view_id, application_id), INDEX (view_id), INDEX (application_id) + ) ENGINE=InnoDB +}); + # ************************************************************* register_alter(sub {