blob: 5a438318dd7e52ad76e445d9687c0043f83a8ef8 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
|
#!/usr/bin/env perl
#===============================================================================
#
# FILE: db-passwd-create.pl
#
# USAGE: ./db-passwd-create.pl
#
# DESCRIPTION:
#
# OPTIONS: ---
# REQUIREMENTS: ---
# BUGS: ---
# NOTES: ---
# AUTHOR: Stefan Suhren (su), suhren.stefan@fh-swf.de
# ORGANIZATION: FH Südwestfalen, Iserlohn
# VERSION: 1.0
# CREATED: 06.01.2016 13:40:30
# REVISION: ---
#===============================================================================
use strict;
use warnings;
use utf8;
# Add database modul
use DBI;
# Get database config
my %dbconf = do 'dbinc.pl';
my $dbhandle = DBI->connect("DBI:mysql:host=$dbconf{dbhost};database=$dbconf{dbdatabase}", $dbconf{dbuser}, $dbconf{dbpasswd}, {RaiseError=>1}) or die 'DB not accessible';
#Create DB
$dbhandle->do("CREATE TABLE stsuh_passwort
(
nr INT AUTO_INCREMENT,
loginname VARCHAR(20),
password VARCHAR(20),
uid INT,
gid INT,
comment CHAR(255),
homedir CHAR(255),
commandinterpreter CHAR(255),
PRIMARY KEY (nr)
)
") or die $dbhandle->errstr;
$dbhandle->disconnect;
|
