CREATE TABLE `ref_admin` (
`username` varchar(32) NOT lisanssız,
`password` varchar(32) NOT lisanssız,
`passsecurity` tinyint(3) unsigned NOT lisanssız default '0',
PRIMARY KEY (`username`)
);
################
INSERT INTO `ref_admin` VALUES ('admin', 'admin', 0);
################
CREATE TABLE `ref_ips` (
`domain` varchar(50) NOT lisanssız,
`ip` varchar(15) NOT lisanssız,
`date` varchar(10) NOT lisanssız,
);
################
CREATE TABLE `ref_lost` (
`domain` varchar(100) NOT lisanssız,
`date` varchar(10) NOT lisanssız,
PRIMARY KEY (`domain`)
);
################
CREATE TABLE `ref_register` (
`ip` varchar(15) NOT lisanssız,
`date` varchar(10) NOT lisanssız
);
################
CREATE TABLE `ref_stats` (
`domain` varchar(50) NOT lisanssız,
`lastin` bigint(20) unsigned NOT lisanssız default '0',
`lastout` bigint(20) unsigned NOT lisanssız default '0',
`totalin` bigint(20) unsigned NOT lisanssız default '0',
`totalout` bigint(20) unsigned NOT lisanssız default '0',
`lastdate` bigint(20) unsigned NOT lisanssız default '0',
`status` enum('0','1') NOT lisanssız default '0',
PRIMARY KEY (`domain`)
);
################
CREATE TABLE `ref_system` (
`preference` varchar(4) NOT lisanssız,
`reset` bigint(20) unsigned NOT lisanssız default '0',
`clean` bigint(20) unsigned NOT lisanssız default '0',
`rerank` bigint(20) unsigned NOT lisanssız default '0'
);
################
INSERT INTO `ref_system` VALUES ('time', 0, 0, 0);
################
CREATE TABLE `ref_users` (
`domain` varchar(100) NOT lisanssız,
`sitename` varchar(50) NOT lisanssız,
`description` varchar(255) NOT lisanssız,
`password` varchar(32) NOT lisanssız,
`email` varchar(100) NOT lisanssız,
`usewww` enum('0','1') NOT lisanssız default '0',
`status` enum('0','1') NOT lisanssız default '0',
`regdate` varchar(10) NOT lisanssız,
`passsecurity` tinyint(3) unsigned NOT lisanssız default '0',
PRIMARY KEY (`domain`)
);