PHPIndex

This page lists files in the current directory. You can view content, get download/execute commands for Wget, Curl, or PowerShell, or filter the list using wildcards (e.g., `*.sh`).

create_db.sh 
wget 'https://lists2.roe3.org/swapshop/db/create_db.sh'
View Content 
#!/bin/sh

mysqladmin create swapshop;
mysql -e "grant all privileges on swapshop.* to swapshopuser@localhost identified by 'swapshoppass'";
mysql -e "flush privileges";
mysql swapshop < starter.sql
starter.sql 
wget 'https://lists2.roe3.org/swapshop/db/starter.sql'
View Content 
DROP TABLE IF EXISTS md_categories;
CREATE TABLE md_categories (
  cat_id int(10) NOT NULL auto_increment,
  cat_name varchar(64) NOT NULL default '',
  cat_order int(2) NOT NULL default '0',
  created timestamp(14) NOT NULL,
  PRIMARY KEY  (cat_id)
) TYPE=MyISAM;


DROP TABLE IF EXISTS md_postings;
CREATE TABLE md_postings (
  postId int(10) unsigned NOT NULL auto_increment,
  isAvailable int(1) NOT NULL default '1',
  isConfirmed int(1) NOT NULL default '0',
  category varchar(30) NOT NULL default 'general',
  title varchar(128) NOT NULL default '',
  description longtext NOT NULL,
  email varchar(128) NOT NULL default '',
  city varchar(32) default NULL,
  zip int(11) NOT NULL default '0',
  name varchar(30) default NULL,
  price int(10) NOT NULL default '0',
  ip varchar(18) NOT NULL default '',
  timeStamp timestamp(14) NOT NULL,
  confirmPassword varchar(7) NOT NULL default '',
  imgURL varchar(128) default '(none)',
  imgURLThumb varchar(128) default '(none)',
  PRIMARY KEY  (postId),
  KEY city (city)
) TYPE=MyISAM;