STRLCPY/wifi_db

Fix obfuscate Clients
RaulCalvoLaorden committed with Raúl Calvo Laorden 1 year ago

f34f4352

1 parent 74e91352

Total 1 files

■ ■ ■ ■ ■ ■

wifi_db_database.sql

		skipped 35 lines
36	36		lon REAL,
37	37		alt REAL,
38	38		CONSTRAINT Key3 PRIMARY KEY (time,mac),
39		-	CONSTRAINT SeenClients FOREIGN KEY (mac) REFERENCES Client (mac)
	39	+	CONSTRAINT SeenClients FOREIGN KEY (mac) REFERENCES Client (mac) ON UPDATE CASCADE ON DELETE CASCADE
40	40		);
41	41
42	42
		skipped 16 lines
59	59		wps_model_number TEXT NOT NULL,
60	60		wps_config_methods TEXT NOT NULL,
61	61		wps_config_methods_keypad TEXT NOT NULL,
62		-	CONSTRAINT KeyWPS PRIMARY KEY (bssid)
63		-	/CONSTRAINT RelationshipWPS FOREIGN KEY (bssid) REFERENCES AP (bssid) ON UPDATE CASCADE ON DELETE CASCADE/
	62	+	CONSTRAINT KeyWPS PRIMARY KEY (bssid),
	63	+	CONSTRAINT RelationshipWPS FOREIGN KEY (bssid) REFERENCES AP (bssid) ON UPDATE CASCADE ON DELETE CASCADE
64	64		);
65	65
66	66
		skipped 29 lines
96	96		file TEXT NOT NULL,
97	97		hashcat TEXT,
98	98		CONSTRAINT Key6 PRIMARY KEY (bssid,mac,file)
99		-	/*CONSTRAINT FRelationship4 FOREIGN KEY (bssid) REFERENCES AP (bssid) ON UPDATE CASCADE ON DELETE CASCADE,
100		-	CONSTRAINT FRelationship5 FOREIGN KEY (mac) REFERENCES Client (mac) ON UPDATE CASCADE ON DELETE CASCADE*/
	99	+	CONSTRAINT FRelationship4 FOREIGN KEY (bssid) REFERENCES AP (bssid) ON UPDATE CASCADE ON DELETE CASCADE,
	100	+	CONSTRAINT FRelationship5 FOREIGN KEY (mac) REFERENCES Client (mac) ON UPDATE CASCADE ON DELETE CASCADE
101	101		);
102	102
103	103		CREATE TABLE IF NOT EXISTS Identity
		skipped 2 lines
106	106		mac TEXT NOT NULL,
107	107		identity TEXT NOT NULL,
108	108		CONSTRAINT Key7 PRIMARY KEY (bssid,mac,identity)
109		-	/*CONSTRAINT FRelationship6 FOREIGN KEY (bssid) REFERENCES AP (bssid) ON UPDATE CASCADE ON DELETE CASCADE,
110		-	CONSTRAINT FRelationship7 FOREIGN KEY (mac) REFERENCES Client (mac) ON UPDATE CASCADE ON DELETE CASCADE*/
	109	+	CONSTRAINT FRelationship6 FOREIGN KEY (bssid) REFERENCES AP (bssid) ON UPDATE CASCADE ON DELETE CASCADE,
	110	+	CONSTRAINT FRelationship7 FOREIGN KEY (mac) REFERENCES Client (mac) ON UPDATE CASCADE ON DELETE CASCADE
111	111		);
112	112

Fix obfuscate Clients