[ljcom] r9466: LJSUP-6542: Tags for verticals

U   trunk/bin/upgrading/proplists-local.dat
U   trunk/bin/upgrading/update-db-local.pl

Modified: trunk/bin/upgrading/proplists-local.dat
===================================================================
--- trunk/bin/upgrading/proplists-local.dat	2010-09-06 07:45:05 UTC (rev 9465)
+++ trunk/bin/upgrading/proplists-local.dat	2010-09-06 08:21:01 UTC (rev 9466)
@@ -472,3 +472,11 @@
   des: a link to the user's profile on twitter
   cldversion: 8
 
+userproplist.ver_tags:
+  cldversion: 7
+  datatype: blobchar
+  des: JSON serialized data with tags for verticals
+  indexed: 0
+  multihomed: 0
+  prettyname: Tags for verticals
+

Modified: trunk/bin/upgrading/update-db-local.pl
===================================================================
--- trunk/bin/upgrading/update-db-local.pl	2010-09-06 07:45:05 UTC (rev 9465)
+++ trunk/bin/upgrading/update-db-local.pl	2010-09-06 08:21:01 UTC (rev 9466)
@@ -1565,7 +1565,17 @@
 ) Type=InnoDB
 EOC
 
+# Communities & vertical tags
+register_tablecreate("ver_tags", <<'EOC');
+CREATE TABLE ver_tags (
+    userid int unsigned not null,
+    seo_tags text not null default '',
+    ver_tags varchar(255) not null default '',
 
+    PRIMARY KEY(userid)
+) TYPE=InnoDB
+EOC
+
 # *************************************************************
 register_alter(sub {