· 8 years ago · Dec 04, 2017, 12:46 PM
1# mkClock.sql
2USE timeclock;
3DROP TABLE IF EXISTS clock;
4
5CREATE TABLE `clock`
6(
7 `jobId` BIGINT(20) NOT NULL,
8 `Id` BIGINT(20) NOT NULL AUTO_INCREMENT,
9 `punchIn` datetime NOT NULL,
10 `punchOut` datetime NULL,
11 `description` VARCHAR(65535),
12 CONSTRAINT PRIMARY KEY(`jobId`, `Id`)
13);
14
15# end mkClock.sql
16
17# use mysql to run create table script, show create table
18
19mysql> \. mkClock.sql
20Database changed
21Query OK, 0 rows affected (0.00 sec)
22
23Query OK, 0 rows affected, 1 warning (0.06 sec)
24
25mysql> show create table clock;
26+-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
27| Table | Create Table |
28+-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
29| clock | CREATE TABLE `clock` (
30 `jobId` bigint(20) NOT NULL,
31 `Id` bigint(20) NOT NULL AUTO_INCREMENT,
32 `punchIn` datetime NOT NULL,
33 `punchOut` datetime DEFAULT NULL,
34 `description` mediumtext COLLATE utf8_unicode_ci,
35 PRIMARY KEY (`jobId`,`Id`)
36) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci |
37+-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
381 row in set (0.00 sec)
39
40mysql>