install.sql

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

# 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_poll`
CREATE TABLE `am_plugin_poll` (
  `poll_id` int(11) NOT NULL auto_increment,
  `webspace_id` int(11) default NULL,
  `poll_question` varchar(255) default NULL,
  `connection_id` int(11) default NULL,
  `poll_create_datetime` datetime default NULL,
  PRIMARY KEY  (`poll_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


# Table structure for table `am_plugin_poll_answer`
CREATE TABLE `am_plugin_poll_answer` (
  `answer_id` int(11) NOT NULL auto_increment,
  `connection_id` int(11) default NULL,
  `poll_id` int(11) default NULL,
  `option_id` int(11) default NULL,
  `answer_create_datetime` datetime default NULL,
  PRIMARY KEY  (`answer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


# Table structure for table `am_plugin_poll_option`
CREATE TABLE `am_plugin_poll_option` (
  `option_id` int(11) NOT NULL auto_increment,
  `poll_id` int(11) default NULL,
  `option_body` varchar(255) default NULL,
  `option_order` int(3) default NULL,
  PRIMARY KEY  (`option_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;