【SQL开源代码栏目提醒】:网学会员SQL开源代码为您提供bookmarks.sql参考,解决您在bookmarks.sql学习中工作中的难题,参考学习。
create database bookmarks;
use bookmarks;
create table user (
username varchar(16) primary key,
passwd char(40) not null,
email varchar(100) not null
);
create table bookmark (
username varchar(16) not null,
bm_URL varchar(255) not null,
index (username),
index (bm_URL)
);
grant select, insert, update, delete
on bookmarks.*
to bm_user@localhost identified by 'pass
word';