[ljcom] r10993: OPSC-349: Database update for multiple a...

OPSC-349: Database update for multiple application views: userapps_views table added

U   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 {