21 lines
383 B
Transact-SQL
Executable File
21 lines
383 B
Transact-SQL
Executable File
IF DB_ID('sqlx') IS NULL
|
|
BEGIN
|
|
CREATE DATABASE sqlx;
|
|
END;
|
|
GO
|
|
|
|
USE sqlx;
|
|
GO
|
|
|
|
IF OBJECT_ID('tweet') IS NULL
|
|
BEGIN
|
|
CREATE TABLE tweet
|
|
(
|
|
id BIGINT NOT NULL PRIMARY KEY,
|
|
text NVARCHAR(4000) NOT NULL,
|
|
is_sent TINYINT NOT NULL DEFAULT 1,
|
|
owner_id BIGINT
|
|
);
|
|
END;
|
|
GO
|