#
# mSQL Dump  (requires mSQL 2.0 Beta 5 or newer)
#
#--------------------------------------------------------
#
# Table structure for table 'access_log'
#
CREATE TABLE access_log (
  status INT,
  userid CHAR(50),
  uuid CHAR(50),
  ip CHAR(50),
  url CHAR(2048),
  permission_type INT,
  permission_on INT,
  start_time CHAR(50),
  end_time CHAR(50),
  total_time REAL,
  why_disconnect INT
) \g
#
# Dumping data for table 'access_log'
#
#
# Table structure for table 'permissions'
#
CREATE TABLE permissions (
  userid CHAR(50) NOT NULL,
  url CHAR(2048) NOT NULL,
  url_type INT,
  permission_type INT,
  expires CHAR(50),
  debitted_time REAL
) \g
CREATE UNIQUE  INDEX guid_index ON permissions (
	userid,
	url
) \g
#
# Dumping data for table 'permissions'
#
#
# Table structure for table 'redirect'
#
CREATE TABLE redirect (
  url CHAR(2048) NOT NULL,
  url_redirect CHAR(2048)
) \g
CREATE UNIQUE  INDEX url_index ON redirect (
	url
) \g
#
# Dumping data for table 'redirect'
#

# Table structure for table 'register_log'
#
CREATE TABLE register_log (
  status INT,
  userid CHAR(50),
  uuid CHAR(50),
  ip CHAR(50),
  request_time CHAR(50),
  url_redirect CHAR(2048)
) \g


#
# Dumping data for table 'register_log'
#
#
# Table structure for table 'users'
#
CREATE TABLE users (
  userid CHAR(50) NOT NULL,
  password CHAR(50),
  uuid CHAR(50),
  uuid_writeable INT
) \g
CREATE UNIQUE  INDEX userid_index ON users (
	userid
) \g
#
# Dumping data for table 'users'
#