diff options
author | Friendika <info@friendika.com> | 2011-01-13 02:07:57 -0800 |
---|---|---|
committer | Friendika <info@friendika.com> | 2011-01-13 02:07:57 -0800 |
commit | b0a03c328fae157e20facf982552147bbadb2542 (patch) | |
tree | 43779946cf5ef0d19396e1a37fb9babe3592ddf6 /database.sql | |
parent | 9d6f3aa4dd43af69d490d0fe8d355893a206e73f (diff) | |
parent | 55598932936196d4a5012f801336c5d850b168ae (diff) | |
download | volse-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.sql | 18 |
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; |