alf (red_alf) wrote in changelog,
alf
red_alf
changelog

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

Committer: afedorov
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 {
 

Tags: dat, ljcom, pl, red_alf
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