install.sql

来自「一款开源的sns系统源码 安装简单」· SQL 代码 · 共 37 行

# This file is part of AROUNDMe
#
# Copyright (C) 2003-2007 Barnraiser
# http:#www.barnraiser.org/
# [e-mail]
#
# This program is free software: you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation, either version 3 of the License, or
# (at your option) any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; see the file COPYING.txt.  If not, see
# <http:#www.gnu.org/licenses/>



# Table structure for table `am_plugin_event`
CREATE TABLE `am_plugin_event` (
  `event_id` int(11) NOT NULL auto_increment,
  `webspace_id` int(11) default NULL,
  `webpage_id` int(11) default NULL,
  `event_start_datetime` datetime default NULL,
  `event_end_datetime` datetime default NULL,
  `event_title` varchar(255) default NULL,
  `event_body` text,
  `event_venue` varchar(255) NOT NULL,
  `connection_id` int(11) default NULL,
  `event_create_datetime` datetime NOT NULL,
  `event_archived` int(1) default NULL,
  PRIMARY KEY  (`event_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;