File: toycms_schema.sql

package info (click to toggle)
lua-orbit 2.2.1%2Bdfsg-1
  • links: PTS, VCS
  • area: main
  • in suites: buster, jessie, jessie-kfreebsd, stretch
  • size: 1,956 kB
  • ctags: 638
  • sloc: sql: 78; sh: 32; makefile: 31; xml: 20
file content (36 lines) | stat: -rw-r--r-- 1,261 bytes parent folder | download | duplicates (7)
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
CREATE TABLE toycms_post
       ("id" INTEGER PRIMARY KEY NOT NULL,
       "title" VARCHAR(255) DEFAULT "",
       "body" TEXT DEFAULT "",
       "abstract" TEXT DEFAULT "",
       "image" VARCHAR(255) DEFAULT "",
       "external_url" VARCHAR(255) DEFAULT "",
       "comment_status" VARCHAR(30) DEFAULT "closed",
       "n_comments" INTEGER DEFAULT 0,
       "section_id" INTEGER DEFAULT NULL,
       "user_id" INTEGER DEFAULT NULL,
       "in_home" BOOLEAN DEFAULT "f",
       "published" BOOLEAN DEFAULT "f",
       "published_at" DATETIME DEFAULT NULL);

CREATE TABLE toycms_comment
       ("id" INTEGER PRIMARY KEY NOT NULL,
       "post_id" INTEGER DEFAULT NULL,
       "author" VARCHAR(255) DEFAULT "",
       "email" VARCHAR(255) DEFAULT "",
       "url" VARCHAR(255) DEFAULT "",
       "body" TEXT DEFAULT "",
       "approved" BOOLEAN DEFAULT "f",
       "created_at" DATETIME DEFAULT NULL);

CREATE TABLE toycms_section
       ("id" INTEGER PRIMARY KEY NOT NULL,
        "title" VARCHAR(255) DEFAULT "",
	"description" TEXT DEFAULT "",
	"tag" VARCHAR(255) DEFAULT "");

CREATE TABLE toycms_user
       ("id" INTEGER PRIMARY KEY NOT NULL,
        "login" VARCHAR(255) DEFAULT "",
	"password" VARCHAR(30) DEFAULT "",
	"name" VARCHAR(255) DEFAULT "");