oh_hell_client_server/oh_hell.schema.sql at main · pacman128/oh_hell_client_server · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
-- MySQL dump 9.11
--
-- Host: localhost    Database: oh_hell
-- ------------------------------------------------------
-- Server version	4.0.24

--
-- Table structure for table `bid`
--

CREATE TABLE bid (
  bid_id INTEGER PRIMARY KEY,
  bid INTEGER NOT NULL default '0',
  deal_id INTEGER NOT NULL default '0',
  player_id INTEGER NOT NULL default '0'
);

--
-- Dumping data for table `bid`
--


--
-- Table structure for table `deal`
--

CREATE TABLE deal (
  deal_id INTEGER PRIMARY KEY,
  game_id INTEGER NOT NULL default '0',
  deal INTEGER NOT NULL default '0',
  num_cards INTEGER NOT NULL default '0',
  dealer_id INTEGER NOT NULL default '0',
  trump INTEGER default NULL
);

--
-- Dumping data for table `deal`
--


--
-- Table structure for table `game`
--

CREATE TABLE game (
  game_id INTEGER PRIMARY KEY,
  time datetime default NULL,
  winner_id INTEGER default NULL
);

--
-- Dumping data for table `game`
--


--
-- Table structure for table `game_players`
--

CREATE TABLE game_players (
  game_id INTEGER  NOT NULL default '0',
  player_id INTEGER NOT NULL default '0',
  game_order INTEGER NOT NULL default '0'
);

--
-- Dumping data for table `game_players`
--


--
-- Table structure for table `player`
--

CREATE TABLE player (
  player_id INTEGER PRIMARY KEY,
  last_name TEXT NOT NULL default '',
  first_name TEXT NOT NULL default ''
);

--
-- Dumping data for table `player`
--


--
-- Table structure for table `trick`
--

CREATE TABLE trick (
  trick_id INTEGER PRIMARY KEY,
  trick_num INTEGER NOT NULL default '0',
  winner_id INTEGER NOT NULL default '0',
  deal_id INTEGER NOT NULL default '0'
);

--
-- Dumping data for table `trick`
--


--
-- Table structure for table `trick_cards`
--

CREATE TABLE trick_cards (
  trick_id INTEGER NOT NULL default '0',
  player_id INTEGER NOT NULL default '0',
  card_num INTEGER NOT NULL default '0',
  card INTEGER NOT NULL default '0'
);

--
-- Dumping data for table `trick_cards`
--