11 lines
478 B
SQL
11 lines
478 B
SQL
-- 테이블 생성 SQL - blog_table
|
|
CREATE TABLE blog_table
|
|
(
|
|
`blog_id` INT NOT NULL AUTO_INCREMENT,
|
|
`blog_title` VARCHAR(50) NOT NULL,
|
|
`blog_content` TEXT NULL,
|
|
`blog_owner` INT NOT NULL,
|
|
`created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
`updated_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
|
PRIMARY KEY (blog_id)
|
|
); |