create table alias (
    id int not null auto_increment,
    clID char(16) default '' not null,
    user char(16) default '' not null,
    pass char(16) default '' not null,
    acl char(255) default '{}' not null,
    status enum('inactive','active') default 'inactive' not null,
    primary key (id),
    unique key indx1 (clID)
);

create table users (
    id int not null auto_increment,
    registry char(64) default '' not null,
    user char(16) default '' not null,
    cash int default '0' not null,
    area char(16) default '' not null,
    primary key (id),
    unique key indx1 (registry,user)
);

create table price (
    id int not null auto_increment,
    area char(16) default '' not null,
    tld char(16) default '' not null,
    create_price int default '0' not null,
    renew_price int default '0' not null,
    transfer_price int default '0' not null,
    restore_price int default '0' not null,
    status enum('inactive','active') default 'inactive' not null,
    primary key (id),
    unique key indx1 (area,tld)
);
