.jpg)
Kategori FileStering (Fitur)
- 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)
)
