
DROP TABLE IF EXISTS users;
create table users
(
    id_user int NOT NULL auto_increment,                  
    login varchar(255) not null,
    dmn varchar(50) not null, 
    id_parent int not null default 0,
    balance float default 0,
    sitesize int default 0,
    credit float default 0,
    name varchar(255) not null,
    bandesc text default '',
    admindesc text default '',
    status enum('new','ban','active','delete') default 'active',
    pwd varchar(255) default '',
    email varchar(255) default '',
    ext varchar(255) not null default '',
    regdate datetime default '0000-00-00',
    minbalance float default 0,
    extinfo text default '',
    checkkey varchar(255) default '',
    bannerstatus int default 1,
    minbalancepay int default 0,
    helplevel int default 2,

    uploadrnd int default 0,

    title varchar(255) default '',
    description text,
    site varchar(255) not null,
    id_cat int not null default 0,
    city varchar(255) default '',

    parentdeep varchar(255) default '',          # 
    refcount int default 0,                      #   

    ip varchar(20) default '127.0.0.1',
    user_agent varchar(255) default '',
    ses char(50) default '',
    timeses int default 0,
    curpage varchar(255) default '',

    mailnews int default 1,                      #  
    userlevel int default 1,       # 

    clickyesterday int default 0, 
    moneyyesterday float default 0, 
    badyesterday int default 0,

    clickall int default 0, 
    moneyall float default 0,
    moneyrefall float default 0,
    endclick int default 0,

    adverter varchar(255) default '',
    forumban int default 0,

    paysys enum('none','wm','cell') default 'none',    # 
    purse varchar(255) default '',                             #   
    access_ip text default '',
    access_agent text default '',

       primary key (id_user),
       key(status),
       key(balance),
       key(ses),
       key(id_cat),
       key(login)
);
# 
insert into users set id_user=1, regdate=now(), refcount=0, login='admin', dmn='', name='admin', pwd=md5('1234'), ext='moderator,admin,dev', email='q@mail.ru';

DROP TABLE IF EXISTS transactions;
create table transactions
(
    id_trans int NOT NULL auto_increment,                  
    way enum('in','out') not null,
    id_from int not null,
    id_to int not null,
    amount float not null default 0,
    description text,
    transdate datetime,
    typetrans enum('balance','pay'),
    comments text default '',
       primary key (id_trans),
       key(id_from),
       key(id_to)
);

insert into transactions set id_trans=1000, way='out', transdate=NOW(), amount=0, description='start', id_from=0, id_to=0;

DROP TABLE IF EXISTS inmail;
create table inmail
(
    id_mail int not null auto_increment,      #
    id_user int not null,                     #    
    id_contact int not null,                  #   (   )
    datesend datetime,
    folder enum('fin','fout','fdel'),         #,   
    subj varchar(255) default '',             #
    message text,                             #
    status enum('new','view') default 'new',
        primary key(id_mail),
        key(id_user),
        key(status)
);

DROP TABLE IF EXISTS news;
create table news
(
    id_news int NOT NULL auto_increment,
    date datetime not null,
    news text,
    comment int default 0,
       primary key (id_news)
);
insert into news set date=NOW(), news=' ';

DROP TABLE IF EXISTS news_comments;
create table news_comments
(
    id_comment int NOT NULL auto_increment,
    id_news int not null,
    id_user int default 0,
    date datetime not null,
    message text,
       primary key (id_comment),
       key(id_news)
);

DROP TABLE IF EXISTS usercheck;
create table usercheck
(
    id_usercheck int NOT NULL auto_increment,
    id_user int default 0,
    date datetime not null,
    id_check int default 0,
    message text,
       primary key (id_usercheck),
       key(id_user)
);

DROP TABLE IF EXISTS systemmoney;
create table systemmoney
(
    day date,                          #
    money float default 0,             #
    
       unique(day)
);

#################################################################################

DROP TABLE IF EXISTS scs_forum_forum;
create table scs_forum_forum
(
    id_forum int not null auto_increment,  #
    name varchar(255) not null,            # 
    description text default '',           # 
    topics int default 0,                  # 
    lastpost datetime default '0000-00-00',# 
    lang char(3) default '',               # 
    usergroup varchar(50) default '',      #     ''
    picture varchar(255) default '',
    forum_private int not null default 0,  # 
    pos int not null default 0,            #,         
        primary key(id_forum),
        key(usergroup),
        key(lang)
);
insert into scs_forum_forum set id_forum=1, name='', description='  ';

#  
DROP TABLE IF EXISTS scs_forum_topic;
create table scs_forum_topic
(
    id_topic int not null auto_increment,               #
    id_forum int not null,                              #  
    id_user int default 0,                              #  
    id_touser int default 0,                            # 
    author varchar(255) not null,                       #   
    subj varchar(255) not null,                         #
    createtime datetime not null default '0000-00-00',  #
    lastpost datetime not null default '0000-00-00',    # 
    replies int not null default 0,                     # 
    toptopic int not null default 0,
    views int not null default 0,                       # 
    endviews varchar(255) default '',                   #  
    closetopic int not null default 0,
        primary key(id_topic),
        key(id_forum),
        key(id_user),
        key(id_touser)
);

# 
DROP TABLE IF EXISTS scs_forum_post;
create table scs_forum_post
(
    id_post int not null auto_increment,      #
    id_topic int not null,                    # 
    id_user int default 0,                    #  
    author varchar(255) not null,             #   
    message text not null,                    #
    createtime datetime default '0000-00-00', # 
    email varchar(255),                        #
    subscribe int not null default 0,         #  
    visibletime int not null default 0,  #       
    checksum varchar(255) default '',
    info_ip varchar(255),
    info_agent varchar(255),
        primary key(id_post),
        key(id_topic),
        key(createtime),
        key(visibletime)
);

DROP TABLE IF EXISTS statreferer;
create table statreferer
(
    datestat date not null,
    id_user int not null,
    referer varchar(255),
    c int default 0,
       unique(id_user,referer),
       key(datestat),
       key(id_user)
);

DROP TABLE IF EXISTS statagent;
create table statagent
(
    datestat date not null,
    id_user int not null,
    agent varchar(255),
    c int default 0,
       unique(id_user,agent),
       key(datestat),
       key(id_user)
);
