create_database.sql

来自「php源码 php源码参考」· SQL 代码 · 共 25 行

create database discussion;

use discussion;

create table header
(
  parent int not null,
  poster char(20) not null,
  title char(20) not null,
  children int default 0 not null,
  area int default 1 not null,
  posted datetime not null,
  postid int unsigned not null auto_increment primary key
);

create table body
(
  postid int unsigned not null primary key,
  message text
);


grant select, insert, update, delete
on discussion.*
to discussion@localhost identified by 'password';