Contoh Pembuatan Database pada PHP

Kategori FileStering (Fitur)

- Membership
- Directory
- File
- Sistem Banned
- Sistem Level
- Foto Galeri
- Status
   enum(‘Inactive’,’active’,’banned’)
- Level
   enum(‘free’,’premium’,’operator’,’admin’)

Untuk Pembuatan Database (Script)

create database pwl_xxxx

create table member (

id_member int(11) not null primary key auto_increment,

email varchar(300) not null unique key,

password varchar (100) not null,

name varchar (300) not null,

status enum(‘inactive’,’active’,’banned’),

level enum(‘free’,’premium’,’operator’,’admin),

date_registration datetime

)

create table directory (

id_ directory int(11) not null primary key auto_increment,

directory _name varchar (300) not null,

description text,

status enum(‘inactive’,’active’,’banned’),

id_member int ,

date_create datetime

foreign key (id_member) references member (id_member)

)

create table file (

id_ file int(11) not null primary key auto_increment,

file _name varchar (300) not null,

description text,

status enum(‘inactive’,’active’,’banned’),

id_member int ,

id_directory int,

date_upload datetime

foreign key (id_member) references member (id_member),

foreign key (id_ directory) references directory (id_ directory)

)