Skip to content

@back2arie /cubrid_kalkun.sql
Created

Embed URL

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
Kalkun Cubrid database schema
--
-- Database: "kalkun"
--
-- --------------------------------------------------------
--
-- Table structure for table "kalkun"
--
CREATE TABLE "kalkun" (
"version" varchar(65535) NOT NULL
);
-- --------------------------------------------------------
--
-- Table structure for table "sms_used"
--
CREATE TABLE "sms_used" (
"id_sms_used" int(11) NOT NULL AUTO_INCREMENT,
"sms_date" date NOT NULL,
"id_user" int(11) NOT NULL,
"out_sms_count" int(11) NOT NULL DEFAULT '0',
"in_sms_count" int(11) NOT NULL DEFAULT '0',
PRIMARY KEY ("id_sms_used")
);
-- --------------------------------------------------------
--
-- Table structure for table "user"
--
CREATE TABLE "user" (
"id_user" int(11) NOT NULL AUTO_INCREMENT(2,1),
"username" varchar(12) NOT NULL,
"realname" varchar(100) NOT NULL,
"password" varchar(255) NOT NULL,
"phone_number" varchar(15) NOT NULL,
"level" varchar(255) NOT NULL DEFAULT 'user',
PRIMARY KEY ("id_user"),
UNIQUE KEY "username" ("username"),
UNIQUE KEY "phone_number" ("phone_number")
);
--
-- Dumping data for table "user"
--
INSERT INTO "user" ("id_user", "username", "realname", "password", "phone_number", "level") VALUES
(1, 'kalkun', 'Kalkun SMS', 'f0af18413d1c9e0366d8d1273160f55d5efeddfe', '123456789', 'admin');
-- --------------------------------------------------------
--
-- Table structure for table "user_folders"
--
CREATE TABLE "user_folders" (
"id_folder" int(11) NOT NULL AUTO_INCREMENT,
"name" varchar(50) NOT NULL,
"id_user" int(11) NOT NULL,
PRIMARY KEY ("id_folder")
);
--
-- Dumping data for table "user_folders"
--
INSERT INTO "user_folders" ("id_folder", "name", "id_user") VALUES
(1, 'inbox', 0),
(2, 'outbox', 0),
(3, 'sent_items', 0),
(4, 'draft', 0),
(5, 'Trash', 0),
(6, 'Spam', 0);
-- --------------------------------------------------------
--
-- Table structure for table "user_inbox"
--
CREATE TABLE "user_inbox" (
"id_inbox" int(11) NOT NULL,
"id_user" int(11) NOT NULL,
"trash" smallint NOT NULL DEFAULT '0',
PRIMARY KEY ("id_inbox")
);
-- --------------------------------------------------------
--
-- Table structure for table "user_outbox"
--
CREATE TABLE "user_outbox" (
"id_outbox" int(11) NOT NULL,
"id_user" int(11) NOT NULL,
PRIMARY KEY ("id_outbox")
);
-- --------------------------------------------------------
--
-- Table structure for table "user_sentitems"
--
CREATE TABLE "user_sentitems" (
"id_sentitems" int(11) NOT NULL,
"id_user" int(11) NOT NULL,
"trash" smallint NOT NULL DEFAULT '0',
PRIMARY KEY ("id_sentitems")
);
-- --------------------------------------------------------
--
-- Table structure for table "user_settings"
--
CREATE TABLE "user_settings" (
"id_user" int(11) NOT NULL,
"theme" varchar(10) NOT NULL DEFAULT 'blue',
"signature" varchar(50) NOT NULL,
"permanent_delete" varchar(255) NOT NULL DEFAULT 'false',
"paging" int(2) NOT NULL DEFAULT '10',
"bg_image" varchar(50) NOT NULL,
"delivery_report" varchar(255) NOT NULL DEFAULT 'default',
"language" varchar(20) NOT NULL DEFAULT 'english',
"conversation_sort" varchar(255) NOT NULL DEFAULT 'asc',
PRIMARY KEY ("id_user")
);
--
-- Dumping data for table "user_settings"
--
INSERT INTO "user_settings" ("id_user", "theme", "signature", "permanent_delete", "paging", "bg_image", "delivery_report", "language", "conversation_sort") VALUES
(1, 'green', 'false;--\nPut your signature here', 'false', 20, 'true;background.jpg', 'default' , 'english', 'asc');
-- --------------------------------------------------------
--
-- Alter table structure for table "inbox"
--
ALTER TABLE "inbox" ADD "id_folder" INT( 11 ) NOT NULL DEFAULT '1',
ADD "readed" varchar( 255 ) NOT NULL DEFAULT 'false';
-- --------------------------------------------------------
--
-- Alter table structure for table "sentitems"
--
ALTER TABLE "sentitems" ADD "id_folder" INT( 11 ) NOT NULL DEFAULT '3';
-- --------------------------------------------------------
--
-- Alter table structure for table "pbk"
--
ALTER TABLE "pbk" ADD "id_user" INT( 11 ) NOT NULL;
ALTER TABLE "pbk" ADD "is_public" varchar(255) NOT NULL DEFAULT 'false';
-- --------------------------------------------------------
--
-- Alter table structure for table "pbk_groups"
--
ALTER TABLE "pbk_groups" ADD "id_user" INT( 11 ) NOT NULL;
ALTER TABLE "pbk_groups" ADD "is_public" varchar(255) NOT NULL DEFAULT 'false';
-- --------------------------------------------------------
--
-- Table structure for table "user_group"
--
CREATE TABLE "user_group" (
"id_group" int(11) NOT NULL AUTO_INCREMENT,
"id_pbk" int(11) NOT NULL,
"id_pbk_groups" int(11) NOT NULL,
"id_user" int(11) NOT NULL,
PRIMARY KEY ("id_group")
);
-- --------------------------------------------------------
--
-- Table structure for table "user_templates"
--
CREATE TABLE "user_templates" (
"id_template" int(11) NOT NULL AUTO_INCREMENT,
"id_user" int(11) NOT NULL,
"Name" varchar(64) NOT NULL,
"Message" varchar(65535) NOT NULL,
PRIMARY KEY ("id_template")
);
-- --------------------------------------------------------
--
-- Table structure for table "b8_wordlist"
--
CREATE TABLE "b8_wordlist" (
"token" varchar(255) NOT NULL,
"count" varchar(255) default NULL,
PRIMARY KEY ("token")
);
INSERT INTO "b8_wordlist" VALUES ('bayes*dbversion', '2');
INSERT INTO "b8_wordlist" VALUES ('bayes*texts.ham', '0');
INSERT INTO "b8_wordlist" VALUES ('bayes*texts.spam', '0');
-- --------------------------------------------------------
--
-- Table structure for table "plugins"
--
CREATE TABLE "plugins" (
"plugin_id" bigint NOT NULL AUTO_INCREMENT,
"plugin_system_name" varchar(255) NOT NULL,
"plugin_name" varchar(255) NOT NULL,
"plugin_uri" varchar(120) DEFAULT NULL,
"plugin_version" varchar(30) NOT NULL,
"plugin_description" varchar(65535),
"plugin_author" varchar(120) DEFAULT NULL,
"plugin_author_uri" varchar(120) DEFAULT NULL,
"plugin_data" string,
PRIMARY KEY ("plugin_id"),
UNIQUE KEY "plugin_index" ("plugin_system_name")
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Something went wrong with that request. Please try again.