HANA-Python/required_sql.sql at main · adithyaamara/HANA-Python · 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
-- Create admins table
CREATE TABLE admins (
  ID int NOT NULL,
  NAME varchar(50) NOT NULL,
  PHONE varchar(10) NOT NULL,
  PWD varchar(100) NOT NULL
);

--
-- Dumping data for table admins
--

INSERT INTO admins (ID, NAME, PHONE, PWD) VALUES
(1, 'your_name', 'your_user_id', 'YourPassword');

-- --------------------------------------------------------

--
-- Table structure for table developers
--

CREATE TABLE developers (
  NAME varchar(50) NOT NULL,
  EMAIL varchar(100) NOT NULL,
  PHONE varchar(10) NOT NULL,
  CITY varchar(30) NOT NULL,
  AGE int NOT NULL
);

-- --------------------------------------------------------

--
-- Table structure for table verified_devs
--

CREATE TABLE verified_devs (
  NAME varchar(100) NOT NULL,
  EMAIL varchar(50) NOT NULL,
  PHONE varchar(10) NOT NULL,
  CITY varchar(50) NOT NULL,
  AGE int NOT NULL,
  PWD varchar(15) NOT NULL
);

-- Setting admins table unique and primary keys

ALTER TABLE admins
  ADD PRIMARY KEY(ID,PHONE)

--
-- Indexes for table developers
--
ALTER TABLE developers
  ADD primary KEY(PHONE,EMAIL)

--
-- Indexes for table verified_devs
--
ALTER TABLE verified_devs
  ADD PRIMARY KEY (PHONE);

COMMIT;