install.sql

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

# 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_wiki_page`
CREATE TABLE `am_plugin_wiki_page` (
  `wikipage_id` int(11) NOT NULL auto_increment,
  `webspace_id` int(11) default NULL,
  `webpage_id` int(11) default NULL,
  `wikipage_name` varchar(50) default NULL,
  `current_revision_id` int(11) default NULL,
  PRIMARY KEY  (`wikipage_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


# Table structure for table `am_plugin_wiki_revision`
CREATE TABLE `am_plugin_wiki_revision` (
  `revision_id` int(11) NOT NULL auto_increment,
  `wikipage_id` int(11) default NULL,
  `revision_body` text,
  `connection_id` int(11) default NULL,
  `revision_create_datetime` datetime default NULL,
  PRIMARY KEY  (`revision_id`),
  FULLTEXT KEY `search` (`revision_body`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;