vadvs (vadvs) wrote in changelog,
vadvs
vadvs
changelog

[ljcom] r9695: LJSUP-7268: Friends Times

Committer: vsukhanov
LJSUP-7268: Friends Times
U   trunk/bin/upgrading/update-db-local.pl
Modified: trunk/bin/upgrading/update-db-local.pl
===================================================================
--- trunk/bin/upgrading/update-db-local.pl	2010-11-11 07:48:39 UTC (rev 9694)
+++ trunk/bin/upgrading/update-db-local.pl	2010-11-11 10:35:00 UTC (rev 9695)
@@ -1588,6 +1588,18 @@
 ) TYPE=InnoDB
 EOC
 
+register_tablecreate("friendstimes", <<'EOC');
+CREATE TABLE friend_times (
+    userid              INT NOT NULL, 
+    journalid           INT NOT NULL, 
+    jitemid             INT(10) UNSIGNED NOT NULL, 
+    added               DATETIME NOT NULL,
+
+    UNIQUE INDEX(userid, journalid, jitemid)
+
+    ) TYPE=InnoDB
+EOC
+
 # *************************************************************
 register_alter(sub {
 

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