· 9 years ago · Nov 02, 2016, 06:52 AM
1Found @ http://connect.smartmatic.com/db.sql
2
3----------------
4I was unable to find an entry point to login.
5Maybe you guys will have better luck.
6----------------
7
8
9DROP TABLE IF EXISTS users;
10CREATE TABLE users (
11 login varchar(60) NOT NULL,
12 pass varchar(64) NOT NULL,
13 lastlogin datetime DEFAULT NULL,
14 PRIMARY KEY (login)
15) ENGINE=MyISAM DEFAULT CHARSET=utf8;
16
17
18#araXeXyja
19#y$ydeMaNu
20#eTysy2uSa
21#ySubaLeva
22#u6yWehuHe
23
24insert into users (login, pass) values
25('admin', '174205b3053390615e77c6bf33af2440bc2fd993414b7cc9d9a225aa6556e99c'),
26('user1', 'bb130dbf8117feccb72066d492ff1ab0236f02dd85732fd81180740eb3cef96d'),
27('user2', '422b41a5da94143b441db1110ef52be457a705af1249c8f6a97201ac1842c7ac'),
28('user3', 'ba230e23cc8da957b4c2d36df8f9423acbba4293e86fdd74762c38c51c1bdab6'),
29('user4', '8c2f11a6727033572b4cc887933608ebe63496e0ede56581cbfd442a432aaa80');
30
31DROP TABLE IF EXISTS teams;
32CREATE TABLE teams (
33 id int(3) NOT NULL auto_increment,
34 status INT(1) UNSIGNED NOT NULL DEFAULT 0,
35 insdate date DEFAULT NULL,
36 name varchar(60) NOT NULL,
37 pass varchar(20) NOT NULL,
38 how varchar(255) DEFAULT NULL,
39 c_started datetime DEFAULT NULL,
40 c_ended datetime DEFAULT NULL,
41 c_submits int(3) default 0,
42 c_anwser varchar(20) DEFAULT NULL,
43 p_started datetime DEFAULT NULL,
44 p_ended datetime DEFAULT NULL,
45 language VARCHAR(4),
46 problem TEXT,
47 approved datetime DEFAULT NULL,
48 paytype varchar(20) DEFAULT NULL,
49 paybank varchar(50) DEFAULT NULL,
50 paydate date DEFAULT NULL,
51 paycode varchar(50) DEFAULT NULL,
52 PRIMARY KEY (id),
53 KEY(name)
54) ENGINE=MyISAM DEFAULT CHARSET=utf8;
55
56
57DROP TABLE IF EXISTS participants;
58CREATE TABLE participants (
59 id int(3) NOT NULL auto_increment,
60 teamid int(3) NOT NULL,
61 name varchar(50) NOT NULL,
62 lastname varchar(50) NOT NULL,
63 birth date default NULL,
64 idcard varchar(11) NOT NULL,
65 passport varchar(3),
66 address varchar(1024),
67 city varchar(50) default NULL,
68 state varchar(50) default NULL,
69 phone varchar(20) default NULL,
70 mobil varchar(20) default NULL,
71 email varchar(255) default NULL,
72 student varchar(3) default NULL,
73 level varchar(50) default NULL,
74 institute varchar(50) default NULL,
75 title varchar(50) default NULL,
76 employee varchar(3) default NULL,
77 company varchar(50) default NULL,
78 entry date default null,
79 job varchar(50) default NULL,
80 shirt varchar(3) default NULL,
81 vegan varchar(3) default NULL,
82 PRIMARY KEY(id),
83 KEY idcard (idcard)
84) ENGINE=MyISAM DEFAULT CHARSET=utf8;