cmiFCxF0

1Creating a database and tables all at once?
2CREATE DATABASE IF NOT EXISTS `preferred_inspections`;
3 USE `preferred_inspections`;
4
5    DROP TABLE IF EXISTS `my_table1`;
6    CREATE TABLE `my_table1` (
7
8        `key`                   INT UNSIGNED AUTO_INCREMENT, 
9
10        `role`                  VARCHAR(70), 
11        `region`                VARCHAR(70),
12        `inspection_type`       VARCHAR(70),
13
14        `inspection_number`     SMALLINT,
15
16        `customer_number`       VARCHAR(70),
17
18        `report_date`           DATE DEFAULT NULL,
19
20        PRIMARY KEY(key)
21
22    ) ENGINE=MyISAM DEFAULT CHARSET=UTF8;
23
24    DROP TABLE IF EXISTS `my_table2`;
25    CREATE TABLE `my_table2` (
26
27        `key`                   INT UNSIGNED AUTO_INCREMENT, 
28
29        `role`                  VARCHAR(70), 
30        `region`                VARCHAR(70),
31        `inspection_type`       VARCHAR(70),
32
33        `inspection_number`     SMALLINT,
34
35        `customer_number`       VARCHAR(70),
36
37        `report_date`           DATE DEFAULT NULL,
38
39        PRIMARY KEY(key)
40
41    ) ENGINE=MyISAM DEFAULT CHARSET=UTF8;
42	
43DROP DATABASE IF EXISTS `preferred_inspections`;
44 CREATE DATABASE `preferred_inspections` (
45
46    CREATE TABLE `my_table1` (
47
48        `key`                   INT UNSIGNED AUTO_INCREMENT, 
49
50        `role`                  VARCHAR(70), 
51        `region`                VARCHAR(70),
52        `inspection_type`       VARCHAR(70),
53
54        `inspection_number`     SMALLINT,
55
56        `customer_number`       VARCHAR(70),
57
58        `report_date`           DATE DEFAULT NULL,
59
60        PRIMARY KEY(key)
61
62    ),
63
64    CREATE TABLE `my_table2` (
65
66        `key`                   INT UNSIGNED AUTO_INCREMENT, 
67
68        `role`                  VARCHAR(70), 
69        `region`                VARCHAR(70),
70        `inspection_type`       VARCHAR(70),
71
72        `inspection_number`     SMALLINT,
73
74        `customer_number`       VARCHAR(70),
75
76        `report_date`           DATE DEFAULT NULL,
77
78        PRIMARY KEY(key)
79
80    )
81
82)   ENGINE=MyISAM DEFAULT CHARSET=UTF8;
83	
84CREATE TABLE `preferred_inspections`.`my_table1` (
85.
86.
87.
88);