-- phpMyAdmin SQL Dump
-- version 2.8.0.3
-- http://www.phpmyadmin.net
-- 
-- Host: arcreplace.higarashi.big-metto.net
-- Generation Time: May 24, 2006 at 02:10 PM
-- Server version: 5.0.18
-- PHP Version: 4.4.2
-- 
-- Database: `arcreplace`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `arc_char`
-- 

CREATE TABLE `arc_char` (
  `charid` int(5) NOT NULL auto_increment,
  `ac_name` varchar(64) NOT NULL,
  `ac_sname` varchar(64) default NULL,
  `ac_priowner` int(4) NOT NULL,
  `ac_secowner` int(4) default NULL,
  `ac_series` varchar(96) NOT NULL,
  `ac_claimdate` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `ac_editdate` timestamp NOT NULL default '0000-00-00 00:00:00',
  `ac_info` text,
  `ac_verification` varchar(3) NOT NULL,
  `ac_url` text,
  PRIMARY KEY  (`charid`),
  KEY `ownerMAIN` (`ac_priowner`),
  KEY `ownerSHAR` (`ac_secowner`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `arc_user`
-- 

CREATE TABLE `arc_user` (
  `userid` int(4) NOT NULL auto_increment,
  `au_name` varchar(32) NOT NULL,
  `au_pass` varchar(50) default NULL,
  `au_level` int(1) NOT NULL,
  PRIMARY KEY  (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
