joevandyk / monkeycharger fork watch download tarball
public
Description: RESTful Rails app for storing credit cards
Clone URL: git://github.com/joevandyk/monkeycharger.git
monkeycharger / db / development_structure.sql
100644 7 lines (7 sloc) 1.65 kb
raw blame history 
1
2
3
4
5
6
7

CREATE TABLE authorizations ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "credit_card_id" integer DEFAULT NULL, "transaction_id" integer NOT NULL, "last_four_digits" varchar(255) NOT NULL, "amount" decimal NOT NULL, "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL);
CREATE TABLE captures ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "authorization_id" integer NOT NULL, "transaction_id" integer NOT NULL, "amount" integer NOT NULL, "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL);
CREATE TABLE credit_cards ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "crypted_number" varchar(255) NOT NULL, "last_four_digits" varchar(255) NOT NULL, "card_type" varchar(255) NOT NULL, "month" varchar(255) NOT NULL, "year" varchar(255) NOT NULL, "street_address" varchar(255) DEFAULT NULL, "city" varchar(255) DEFAULT NULL, "state" varchar(255) DEFAULT NULL, "country" varchar(255) DEFAULT NULL, "zip" varchar(255) DEFAULT NULL, "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL);
CREATE TABLE refunds ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "authorization" integer NOT NULL, "transaction_id" integer NOT NULL, "amount" decimal NOT NULL, "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL);
CREATE TABLE schema_info (version integer);
CREATE TABLE voids ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "voidee_id" integer NOT NULL, "voidee_type" varchar(255) NOT NULL, "transaction_id" integer NOT NULL, "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL);
INSERT INTO schema_info (version) VALUES (4)