You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
 
 
 

18 lines
483 B

DROP DATABASE IF EXISTS augmented;
CREATE DATABASE augmented;
GRANT ALL ON augmented.* TO augmented@'%' IDENTIFIED BY 'augmented';
USE augmented;
CREATE TABLE posts (
post_id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,
title TEXT,
content TEXT NOT NULL,
description TEXT,
attach TEXT,
author TEXT NOT NULL,
is_op BOOLEAN NOT NULL,
is_signed_author BOOLEAN,
parent INTEGER,
ip TEXT NOT NULL,
tag TEXT,
date_posted DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
);