head	1.2;
access;
symbols;
locks; strict;
comment	@# @;


1.2
date	2006.02.27.16.53.27;	author nonun;	state Exp;
branches;
next	1.1;

1.1
date	2006.02.01.15.49.51;	author nonun;	state Exp;
branches;
next	;


desc
@@


1.2
log
@*** empty log message ***
@
text
@1. Extend SQL for manipulation databases(only super user)

1-1. CREATE DATABASE [DBNAME]
POST /[DBNAME] HTTP/1.1
Content-length: 22

CREATE DATABASE TESTDB

200 OK
...


1-2. DROP DATABASE [DBNAME]
POST /[DBNAME] HTTP/1.1
Content-length: 20

DROP DATABASE TESTDB

200 OK
...


1-3. CREATE USER [NO]SUPERUSER [DBNAME | *] USERNAME PASSWORD
POST /[DBNAME] HTTP/1.1
Content-length: 48

CREATE USER NOSUPERUSER TESTDB TESTUSER TESTPASS

200 OK
...


1-4. DROP USER USERNAME
POST /[DBNAME] HTTP/1.1
Content-length: 48

DROP USER TESTUSER

200 OK
...


1-5. SHOW [TABLES | DATABASES | STATUS ]
POST /[DBNAME] HTTP/1.1
Content-length: 23

SHOW STATUS

200 OK
...


1-6. KILL SESSION_ID
POST /[DBNAME] HTTP/1.1
Content-length: 7

KILL 12

200 OK
...


1-7. DUMP TO [[MIRROR] FILE 'filename' | CLIENT]
POST /[DBNAME] HTTP/1.1
Content-length: 23

DUMP TO FILE 'dump.sql'

200 OK
...

@


1.1
log
@*** empty log message ***
@
text
@d43 1
a43 1
1-5. SHOW [TABLES | DATABASES | SESSION STATUS [ALL]]
d47 1
a47 1
SHOW SESSION STATUS ALL
d53 1
a53 1
1-6. KILL SESSION_NO
@

