· 10 years ago · Aug 24, 2016, 10:00 AM
1CREATE TABLE drafting.cards (
2 ID INT NOT NULL AUTO_INCREMENT=0 PRIMARY KEY UNIQUE,
3 SET_ID VARCHAR(36) NULL,
4 SET_NAME VARCHAR(120) NULL,
5 CARD_ID VARCHAR(36) NULL,
6 NAME VARCHAR(36) NULL,
7 COST VARCHAR(36) NULL,
8 CMC INT NULL,
9 COLOR VARCHAR(120) NULL,
10 _TYPE VARCHAR(120) NULL,
11 _SUBTYPE VARCHAR(120) NULL,
12 RARITY VARCHAR(120) NULL,
13 RULES VARCHAR(1000) NULL,
14 _POWER INT NULL,
15 TOUGHNESS INT NULL,
16 PTBOX VARCHAR(10) NULL,
17 ARTIST VARCHAR(80) NULL,
18 _NUMBER VARCHAR(36) NULL,
19 FLAVOR VARCHAR(1000) NULL,
20 MULTIVERSEID INT NULL,
21 FLAGS VARCHAR(240) NULL
22)
23
24
25-- phpMyAdmin SQL Dump
26-- version 4.5.1
27-- http://www.phpmyadmin.net
28--
29-- Host: 127.0.0.1
30-- Generation Time: Aug 24, 2016 at 11:57 AM
31-- Server version: 10.1.9-MariaDB
32-- PHP Version: 5.6.15
33
34SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
35SET time_zone = "+00:00";
36
37
38/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
39/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
40/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
41/*!40101 SET NAMES utf8mb4 */;
42
43--
44-- Database: `drafting`
45--
46CREATE DATABASE IF NOT EXISTS `drafting` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
47USE `drafting`;
48
49-- --------------------------------------------------------
50
51--
52-- Table structure for table `accounts`
53--
54
55CREATE TABLE `accounts` (
56 `id` int(11) NOT NULL,
57 `username` varchar(30) DEFAULT NULL,
58 `passhash` varchar(200) DEFAULT NULL
59) ENGINE=InnoDB DEFAULT CHARSET=latin1;
60
61--
62-- Dumping data for table `accounts`
63--
64
65INSERT INTO `accounts` (`id`, `username`, `passhash`) VALUES
66(0, 'admin', '$2y$10$2qLFtivbeHexTwSI8UI6eem9ld/cOX2jcMDtjHWc6u/mybHTSPIVK');
67
68--
69-- Indexes for dumped tables
70--
71
72--
73-- Indexes for table `accounts`
74--
75ALTER TABLE `accounts`
76 ADD PRIMARY KEY (`id`);
77
78/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
79/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
80/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;