From ffb1997902facb36b78a7cfa522f41f2b3d71cda Mon Sep 17 00:00:00 2001
From: Mike Macgirvin <mike@macgirvin.com>
Date: Wed, 8 Sep 2010 20:14:17 -0700
Subject: mistpark 2.0 infrasturcture lands

---
 update.php | 15 +++++++++++++++
 1 file changed, 15 insertions(+)
 create mode 100644 update.php

(limited to 'update.php')

diff --git a/update.php b/update.php
new file mode 100644
index 000000000..e01bafb90
--- /dev/null
+++ b/update.php
@@ -0,0 +1,15 @@
+<?php
+
+function update_1001() {
+
+	q("ALTER TABLE `item` DROP `like`, DROP `dislike` ");
+
+	q("ALTER TABLE `item` ADD `verb` CHAR( 255 ) NOT NULL AFTER `body` ,
+		ADD `object-type` CHAR( 255 ) NOT NULL AFTER `verb` ,
+		ADD `object` TEXT NOT NULL AFTER `object-type` ");
+
+	q("ALTER TABLE `intro` ADD `duplex` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `knowyou` ");
+	q("ALTER TABLE `contact` ADD `duplex` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `rel` ");
+ 	q("ALTER TABLE `contact` CHANGE `issued-pubkey` `issued-pubkey` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL");  
+	q("ALTER TABLE `contact` ADD `term-date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' AFTER `avatar-date`");
+}
\ No newline at end of file
-- 
cgit v1.2.3