filesystem.install.sql

groupoffice

# phpMyAdmin SQL Dump
# version 2.5.5-pl1
# http://www.phpmyadmin.net
#
# Host: localhost
# Generatie Tijd: 19 Apr 2004 om 10:48
# Server versie: 3.23.58
# PHP Versie: 4.3.4
# 
# Database : `groupoffice`
# 

# --------------------------------------------------------

#
# Tabel structuur voor tabel `fsShares`
#


DROP TABLE IF EXISTS `fs_links`;
CREATE TABLE `fs_links` (
  `link_id` int(11) NOT NULL default '0',
  `path` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`link_id`),
  KEY `path` (`path`)
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Tabel structuur voor tabel `fs_shares`
-- 

DROP TABLE IF EXISTS `fs_shares`;
CREATE TABLE `fs_shares` (
  `user_id` int(11) NOT NULL default '0',
  `link_id` int(11) default NULL,
  `path` varchar(200) NOT NULL default '',
  `type` varchar(50) NOT NULL default '',
  `acl_read` int(11) NOT NULL default '0',
  `acl_write` int(11) NOT NULL default '0',
  PRIMARY KEY  (`path`),
  KEY `user_id` (`user_id`),
  KEY `type` (`type`),
  KEY `link_id` (`link_id`)
) TYPE=MyISAM;