bookmarks.install.sql

来自「国外很不错的一个开源OA系统Group-Office」· SQL 代码 · 共 48 行

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

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

#
# Tabel structuur voor tabel `bm_bookmarks`
#

DROP TABLE IF EXISTS `bm_bookmarks`;
CREATE TABLE `bm_bookmarks` (
  `id` int(11) NOT NULL default '0',
  `user_id` int(11) NOT NULL default '0',
  `catagory_id` int(11) NOT NULL default '0',
  `URL` varchar(200) NOT NULL default '',
  `name` varchar(50) NOT NULL default '',
  `new_window` tinyint(4) NOT NULL default '0',
  `acl_read` int(11) NOT NULL default '0',
  `acl_write` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `id` (`id`)
) TYPE=MyISAM;

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

#
# Tabel structuur voor tabel `bm_catagories`
#

DROP TABLE IF EXISTS `bm_catagories`;
CREATE TABLE `bm_catagories` (
  `id` int(11) NOT NULL default '0',
  `user_id` int(11) NOT NULL default '0',
  `name` varchar(50) NOT NULL default '',
  `acl_read` int(11) NOT NULL default '0',
  `acl_write` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;