21 lines
630 B
SQL
21 lines
630 B
SQL
DROP TABLE IF EXISTS app;
|
|
CREATE TABLE app (
|
|
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
|
|
modify_id INT UNSIGNED,
|
|
status CHAR(1) DEFAULT 'P' NOT NULL,
|
|
cat_id INT UNSIGNED NOT NULL,
|
|
date_added DATETIME NOT NULL,
|
|
rating FLOAT DEFAULT 0.0 NOT NULL,
|
|
votes INT UNSIGNED DEFAULT 0 NOT NULL,
|
|
name VARCHAR(255) NOT NULL,
|
|
has_screenshot CHAR(1) DEFAULT 'N' NOT NULL,
|
|
homepage_url VARCHAR(255),
|
|
submitter VARCHAR(100),
|
|
approved_by VARCHAR(20),
|
|
blurb TEXT,
|
|
#
|
|
PRIMARY KEY app_pk (id),
|
|
INDEX app_status_idx (status),
|
|
INDEX app_cat_id_idx (cat_id),
|
|
INDEX app_date_added_idx (date_added)
|
|
);
|