Repository navigation
Expand file tree
/
Copy pathUsers.sql
More file actions
62 lines (59 loc) · 1.9 KB
/
Copy pathUsers.sql
File metadata and controls
62 lines (59 loc) · 1.9 KB
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
DROP TABLE IF EXISTS users;
CREATE TABLE users (
id INTEGER PRIMARY KEY AUTOINCREMENT,
nome TEXT NOT NULL,
sobrenome TEXT NOT NULL,
idade INTEGER NOT NULL,
status TEXT NOT NULL CHECK(status IN ('Active','Unactive'))
);
INSERT INTO users (nome, sobrenome, idade, status) VALUES
('Alice','Johnson',28,'Active'),
('Bob','Smith',34,'Active'),
('Charlie','Brown',25,'Active'),
('David','Miller',42,'Active'),
('Emma','Wilson',31,'Active'),
('Frank','Taylor',27,'Active'),
('Grace','Anderson',29,'Active'),
('Henry','Thomas',38,'Active'),
('Isabella','Moore',24,'Active'),
('Jack','Martin',33,'Active'),
('Karen','Lee',30,'Active'),
('Lucas','White',41,'Active'),
('Mia','Harris',26,'Active'),
('Nathan','Clark',35,'Active'),
('Olivia','Lewis',22,'Active'),
('Peter','Walker',37,'Active'),
('Queen','Hall',28,'Active'),
('Ryan','Allen',39,'Active'),
('Sophia','Young',23,'Active'),
('Thomas','King',45,'Active'),
('Uma','Scott',32,'Active'),
('Victor','Green',36,'Active'),
('William','Adams',27,'Active'),
('Xenia','Baker',29,'Active'),
('Zoe','Nelson',21,'Active'),
('Aaron','Carter',40,'Unactive'),
('Bianca','Mitchell',26,'Unactive'),
('Caleb','Perez',31,'Unactive'),
('Diana','Roberts',28,'Unactive'),
('Ethan','Turner',44,'Unactive'),
('Fiona','Phillips',35,'Unactive'),
('George','Campbell',33,'Unactive'),
('Hannah','Parker',24,'Unactive'),
('Ian','Evans',30,'Unactive'),
('Julia','Edwards',27,'Unactive'),
('Kevin','Collins',38,'Unactive'),
('Laura','Stewart',29,'Unactive'),
('Matthew','Sanchez',41,'Unactive'),
('Nina','Morris',22,'Unactive'),
('Oscar','Rogers',36,'Unactive'),
('Paula','Reed',25,'Unactive'),
('Quentin','Cook',34,'Unactive'),
('Rachel','Morgan',32,'Unactive'),
('Samuel','Bell',39,'Unactive'),
('Tina','Murphy',23,'Unactive'),
('Ulysses','Bailey',43,'Unactive'),
('Vanessa','Rivera',28,'Unactive'),
('Walter','Cooper',37,'Unactive'),
('Yasmin','Richardson',26,'Unactive'),
('Zach','Cox',31,'Unactive');