aboutsummaryrefslogtreecommitdiffstats
path: root/update.php
diff options
context:
space:
mode:
authorFriendika <info@friendika.com>2011-01-13 02:01:00 -0800
committerFriendika <info@friendika.com>2011-01-13 02:01:00 -0800
commit55598932936196d4a5012f801336c5d850b168ae (patch)
treed22c9d98072891bb0d4b4bdeb5dc0abcf16fa0b4 /update.php
parentb11963f9ac3551ff850ddfd4c8c58fe0c87dee1a (diff)
downloadvolse-hubzilla-55598932936196d4a5012f801336c5d850b168ae.tar.gz
volse-hubzilla-55598932936196d4a5012f801336c5d850b168ae.tar.bz2
volse-hubzilla-55598932936196d4a5012f801336c5d850b168ae.zip
event and birthday data structures
Diffstat (limited to 'update.php')
-rw-r--r--update.php24
1 files changed, 24 insertions, 0 deletions
diff --git a/update.php b/update.php
index afa3b58a4..1b75d0434 100644
--- a/update.php
+++ b/update.php
@@ -277,3 +277,27 @@ function update_1028() {
function update_1029() {
q("ALTER TABLE `contact` ADD `info` MEDIUMTEXT NOT NULL AFTER `reason` ");
}
+
+function update_1030() {
+ q("ALTER TABLE `contact` ADD `bdyear` CHAR( 4 ) NOT NULL COMMENT 'birthday notify flag' AFTER `profile-id` ");
+
+ q("CREATE TABLE IF NOT EXISTS `event` (
+ `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
+ `uid` INT NOT NULL ,
+ `cid` INT NOT NULL ,
+ `created` DATETIME NOT NULL ,
+ `edited` DATETIME NOT NULL ,
+ `start` DATETIME NOT NULL ,
+ `finish` DATETIME NOT NULL ,
+ `desc` TEXT NOT NULL ,
+ `location` TEXT NOT NULL ,
+ `type` CHAR( 255 ) NOT NULL ,
+ `adjust` TINYINT( 1 ) NOT NULL DEFAULT '1',
+ `allow_cid` MEDIUMTEXT NOT NULL ,
+ `allow_gid` MEDIUMTEXT NOT NULL ,
+ `deny_cid` MEDIUMTEXT NOT NULL ,
+ `deny_gid` MEDIUMTEXT NOT NULL
+ ) ENGINE = MYISAM DEFAULT CHARSET=utf8 ");
+
+
+} \ No newline at end of file