28 lines
618 B
SQL
28 lines
618 B
SQL
|
|
CREATE TABLE IF NOT EXISTS `aws` (
|
|
`id` int(10) unsigned NOT NULL auto_increment,
|
|
`uid` int(10) unsigned NOT NULL default '0',
|
|
`hostname` varchar(255) NOT NULL default '',
|
|
`public` INT(1) unsigned NOT NULL DEFAULT '1',
|
|
`hostaliases` TEXT,
|
|
PRIMARY KEY (`id`)
|
|
);
|
|
|
|
|
|
CREATE TABLE IF NOT EXISTS `aws_users` (
|
|
`uid` int(10) unsigned NOT NULL,
|
|
`login` varchar(128) NOT NULL,
|
|
`pass` varchar(38) NOT NULL,
|
|
PRIMARY KEY (`login`),
|
|
INDEX (`uid`)
|
|
);
|
|
|
|
|
|
CREATE TABLE IF NOT EXISTS `aws_access` (
|
|
`id` int(10) unsigned NOT NULL,
|
|
`uid` int(10) unsigned NOT NULL,
|
|
`login` varchar(128) NOT NULL,
|
|
INDEX (`id`)
|
|
);
|
|
|