aboutsummaryrefslogtreecommitdiffstats
path: root/database.sql
diff options
context:
space:
mode:
authorFriendika <info@friendika.com>2011-01-13 02:07:57 -0800
committerFriendika <info@friendika.com>2011-01-13 02:07:57 -0800
commitb0a03c328fae157e20facf982552147bbadb2542 (patch)
tree43779946cf5ef0d19396e1a37fb9babe3592ddf6 /database.sql
parent9d6f3aa4dd43af69d490d0fe8d355893a206e73f (diff)
parent55598932936196d4a5012f801336c5d850b168ae (diff)
downloadvolse-hubzilla-b0a03c328fae157e20facf982552147bbadb2542.tar.gz
volse-hubzilla-b0a03c328fae157e20facf982552147bbadb2542.tar.bz2
volse-hubzilla-b0a03c328fae157e20facf982552147bbadb2542.zip
Merge branch 'dev'
Diffstat (limited to 'database.sql')
-rw-r--r--database.sql18
1 files changed, 18 insertions, 0 deletions
diff --git a/database.sql b/database.sql
index 61cd95e72..0e21be512 100644
--- a/database.sql
+++ b/database.sql
@@ -89,6 +89,7 @@ CREATE TABLE IF NOT EXISTS `contact` (
`reason` text NOT NULL,
`info` mediumtext NOT NULL,
`profile-id` int(11) NOT NULL DEFAULT '0',
+ `bdyear` CHAR( 4 ) NOT NULL COMMENT 'birthday notify flag',
PRIMARY KEY (`id`),
KEY `uid` (`uid`),
KEY `self` (`self`),
@@ -451,5 +452,22 @@ CREATE TABLE IF NOT EXISTS `addon` (
) ENGINE = MYISAM DEFAULT CHARSET=utf8;
+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;