Kanjut SHELL
Server IP : 172.16.15.8  /  Your IP : 3.138.126.124
Web Server : Apache
System : Linux zeus.vwu.edu 4.18.0-553.27.1.el8_10.x86_64 #1 SMP Wed Nov 6 14:29:02 UTC 2024 x86_64
User : apache ( 48)
PHP Version : 7.2.24
Disable Function : NONE
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : ON
Directory (0705) :  /home/vnlaughlin/public_html/../

[  Home  ][  C0mmand  ][  Upload File  ]

Current File : /home/vnlaughlin/public_html/../as_test.sql
drop table an_posts;
create table an_posts(
	picID int(11) unsigned NOT NULL AUTO_INCREMENT,
	userID int,
	image_path BLOB, 
	image_name BLOB,
	postTitle varchar(255) DEFAULT NULL,
	description text, 
	location varchar(30),
	postDate datetime DEFAULT NULL,
	tags varchar(255) DEFAULT NULL,
	primary key (picID)
	);
	

	
DROP TABLE an_users;
CREATE TABLE an_users (
	userID int(11) unsigned NOT NULL AUTO_INCREMENT,
	username varchar(255) DEFAULT NULL,
	password varchar(255) DEFAULT NULL,
	email varchar(255) DEFAULT NULL,
	image_path varchar(30), 
	image_name varchar(30),
	PRIMARY KEY (userID)
	);

DROP TABLE an_tags;
CREATE TABLE an_tags(
	tagID int(11) unsigned NOT NULL AUTO_INCREMENT,
	tag varchar(255) DEFAULT NULL,
	postID int,	
	PRIMARY KEY (tagID)
	);

Stv3n404 - 2023