-
Notifications
You must be signed in to change notification settings - Fork 22
Expand file tree
/
Copy pathinit-source.sql
More file actions
54 lines (47 loc) · 1.65 KB
/
Copy pathinit-source.sql
File metadata and controls
54 lines (47 loc) · 1.65 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
-- Source database schema for MySQL → Paimon sync demo
CREATE DATABASE IF NOT EXISTS source_db;
USE source_db;
-- Users table
CREATE TABLE IF NOT EXISTS users (
id BIGINT NOT NULL AUTO_INCREMENT,
name VARCHAR(100) NOT NULL,
email VARCHAR(200),
age INT,
create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
update_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- Orders table
CREATE TABLE IF NOT EXISTS orders (
id BIGINT NOT NULL AUTO_INCREMENT,
user_id BIGINT NOT NULL,
product_name VARCHAR(200),
amount DECIMAL(10,2),
status VARCHAR(20) DEFAULT 'pending',
create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id),
FOREIGN KEY (user_id) REFERENCES users(id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- Products table
CREATE TABLE IF NOT EXISTS products (
id BIGINT NOT NULL AUTO_INCREMENT,
name VARCHAR(200) NOT NULL,
price DECIMAL(10,2),
stock INT DEFAULT 0,
category VARCHAR(100),
create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- Insert sample data
INSERT INTO users (name, email, age) VALUES
('Alice', 'alice@example.com', 30),
('Bob', 'bob@example.com', 25),
('Charlie', 'charlie@example.com', 35);
INSERT INTO products (name, price, stock, category) VALUES
('Laptop', 999.99, 50, 'Electronics'),
('Phone', 699.99, 100, 'Electronics'),
('Book', 29.99, 200, 'Education');
INSERT INTO orders (user_id, product_name, amount, status) VALUES
(1, 'Laptop', 999.99, 'completed'),
(2, 'Phone', 699.99, 'pending'),
(1, 'Book', 29.99, 'completed');