SQLite format 3@ &# - /##%tabledeploy_infodeploy_infoCREATE TABLE "deploy_info" ( "md5" char(32) NOT NULL, "schema_class" varchar(128) NOT NULL, "schema_version" varchar(16) NOT NULL, "comment" varchar(255) NOT NULL, "deployed_ddl" mediumtext NOT NULL, "deployed_ts" datetime NOT NULL, PRIMARY KEY ("md5") )5I#indexsqlite_autoindex_deploy_info_1deploy_infov=%indexdefault_view_idx_view_iddefault_viewCREATE INDEX "default_view_idx_view_id" ON "default_view" ("view_id")~%%?tabledefault_viewdefault_viewCREATE TABLE "default_view" ( "source_model" varchar(255) NOT NULL, "view_id" integer, PRIMARY KEY ("source_model"), FOREIGN KEY ("view_id") REFERENCES "saved_state"("id") ON DELETE CASCADE ON UPDATE CASCADE )7K%indexsqlite_autoindex_defaul      M59-3ec7d42f4efbec23cc53c05e392607aa4RapidApp::CoreSchema1DO NOT REMOVE THIS ROW-- -- Created by SQL::Translator::Producer::SQLite -- Created on Fri Apr 11 06:25:52 2014 -- BEGIN TRANSACTION; -- -- Table: "default_view" -- CREATE TABLE "default_view" ( # %ec7d42f4efbec23cc53c05e392607aa4 +DUMMY ROOT NODE /~%%?tabledefault_viewdefault_viewCREATE TABLE "default_view" ( "source_model" varchar(255) NOT NULL, "view_id" integer, PRIMARY KEY ("source_model"), FOREIGN KEY ("view_id") REFERENCES "saved_state"("id") ON DELETE CASCADE ON UPDATE CASCADE )7K%indexsqlite_autoindex_default_view_1default_viewv=%indexdefault_view_idx_view_iddefault_viewCREATE INDEX "default_view_idx_view_id" ON "default_view" ("view_id")/##%tabledeploy_infodeploy_infoCREATE TABLE "deploy_info" ( "md5" char(32) NOT NULL, "schema_class" varchar(128) NOT NULL, "schema_version" varchar(16) NOT NULL, "comment" varchar(255) NOT NULL, "deployed_ddl" mediumtext NOT NULL, "deployed_ts" datetime NOT NULL, PRIMARY KEY ("md5") )5I#indexsqlite_autoindex_deploy_info_1deploy_info yyDp55tablenavtree_node_to_rolenavtree_node_to_role CRE\%%{tablenavtree_nodenavtree_nodeCREATE TABLE "navtree_node" ( "id" INTEGER PRIMARY KEY NOT NULL, "pid" integer DEFAULT 0, "text" varchar(255) NOT NULL, "iconcls" varchar(255), "expanded" tinyint, "ordering" integer NOT NULL DEFAULT 500000, FOREIGN KEY ("pid") REFERENCES "navtree_node"("id") ON DELETE CASCADE ON UPDATE CASCADE )j5%indexnavtree_node_idx_pidnavtree_node CREATE INDEX "navtree_node_idx_pid" ON "navtree_node" ("pid")p55tablenavtree_node_to_rolenavtree_node_to_role CREATE TABLE "navtree_node_to_role" ( "node_id" integer NOT NULL, "role" varchar(64) NOT NULL, PRIMARY KEY ("node_id", "role"), FOREIGN KEY ("node_id") REFERENCES "navtree_node"("id") ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY ("role") REFERENCES "role"("role") ON DELETE CASCADE ON UPDATE CASCADE )G [5indexsqlite_autoindex_navtree_node_to_role_1navtree_node_to_role     .LHb 3indexrequest_idx_user_idrequestCREATE INDEX "request_idx_user_i M57indexnavtree_node_to_role_idx_node_idnavtree_node_to_role CREATE INDEX "navtree_node_to_role_idx_node_id" ON "navtree_node_to_role" ("node_id") G5+indexnavtree_node_to_role_idx_rolenavtree_node_to_roleCREATE INDEX "navtree_node_to_role_idx_role" ON "navtree_node_to_role" ("role")[  tablerequestrequestCREATE TABLE "request" ( "id" INTEGER PRIMARY KEY NOT NULL, "user_id" integer, "timestamp" timestamp NOT NULL DEFAULT current_timestamp, "client_ip" varchar(16) NOT NULL, "client_hostname" varchar(255), "uri" varchar(512) NOT NULL, "method" varchar(8) NOT NULL, "user_agent" varchar(1024), "referer" varchar(512), "serialized_request" text, FOREIGN KEY ("user_id") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE CASCADE )b 3indexrequest_idx_user_idrequestCREATE INDEX "request_idx_user_id" ON "request" ("user_id")    '%administratorFull Control 3z"tableroleroleCREATE TABLE "role" ( "id" INTEGER PRIMARY KEY NOT NULL, "role" varchar(64) NOT NULL, tableroleroleCREATE TABLE "role" ( "id" INTEGER PRIMARY KEY NOT NULL, "role" varchar(64) NOT NULL, "description" varchar(255) NOT NULL )Ekindexrole02roleCREATE UNIQUE INDEX "role02" ON "role" ("role")##etablesaved_statesaved_stateCREATE TABLE "saved_state" ( "id" INTEGER PRIMARY KEY NOT NULL, "title" varchar(255) NOT NULL, "subtitle" varchar(1024), "node_id" integer, "user_id" integer, "ordering" integer NOT NULL DEFAULT 500001, "iconcls" varchar(255), "url" varchar(255) NOT NULL, "params" text, "state_data" text, FOREIGN KEY ("node_id") REFERENCES "navtree_node"("id") ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY ("user_id") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE CASCADE )r;#indexsaved_state_idx_node_idsaved_stateCREATE INDEX "saved_state_idx_node_id" ON "saved_state" ("node_id") administrator      OfMwindexusernameuserCREATE UNIQUE INDEX "username" ON "user" ("username")ktableuseruserCREATE TABLE "user" ( "id" INTEGER PRIMARY KEY NOT NULL, "userna7K%indexsqlite_autor;#indexsaved_state_idx_user_idsaved_stateCREATE INDEX "saved_state_idx_user_id" ON "saved_state" ("user_id")tablesessionsessionCREATE TABLE "session" ( "id" varchar NOT NULL, "session_data" text, "expires" integer, "expires_ts" datetime, "user_id" integer, PRIMARY KEY ("id"), FOREIGN KEY ("user_id") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE CASCADE )-Aindexsqlite_autoindex_session_1sessionb3indexsession_idx_user_idsessionCREATE INDEX "session_idx_user_id" ON "session" ("user_id")ktableuseruserCREATE TABLE "user" ( "id" INTEGER PRIMARY KEY NOT NULL, "username" varchar(32) NOT NULL, "password" varchar, "full_name" varchar(255), "last_login_ts" datetime, "disabled" tinyint NOT NULL DEFAULT 0, "disabled_ts" datetime )  Tadmin{CRYPT}$2a$14$uvAqMd.SVe2kPpnzGJPgzOs76S1cIVcTUNm53jKwdju0kWCcdxTJO  admin 'adminadministrator adminadministrator .g.y?%indexuser_to_role_idx_usernameuser_to_role"CREATE INDEX "user_to_role_idx_username" ON "user_to_role" ("username")m7% indexuser_to_role_idx_roleuser_to_role!CREATE INDEX "user_to_role_idx_role" ON "user_to_role" ("role")MwindexusernameuserCREATE UNIQUE INDEX "username" ON "user" ("username")]%%}tableuser_to_roleuser_to_roleCREATE TABLE "user_to_role" ( "username" varchar(32) NOT NULL, "role" varchar(64) NOT NULL, PRIMARY KEY ("username", "role"), FOREIGN KEY ("role") REFERENCES "role"("role") ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY ("username") REFERENCES "user"("username") ON DELETE CASCADE ON UPDATE CASCADE )7K%indexsqlite_autoindex_user_to_role_1user_to_role administrator  admin$%&archar(255) NOT NULL, "view_id" integer, PRIMARY KEY ("source_model"), FOREIGN KEY ("view_id") REFERENCES "saved_state"("id") ON DELETE CASCADE ON UPDATE CASCADE ); CREATE INDEX "default_view_idx_view_id" ON "default_view" ("view_id"); -- -- Table: "deploy_info" -- CREATE TABLE "deploy_info" ( "md5" char(32) NOT NULL, "schema_class" varchar(128) NOT NULL, "schema_version" varchar(16) NOT NULL, "comment" varchar(255) NOT NULL, "deployed_ddl" mediumtext NOT NULL, "deployed_ts" datetime NOT NULL, PRIMARY KEY ("md5") ); -- -- Table: "navtree_node" -- CREATE TABLE "navtree_node" ( "id" INTEGER PRIMARY KEY NOT NULL, "pid" integer DEFAULT 0, "text" varchar(255) NOT NULL, "iconcls" varchar(255), "expanded" tinyint, "ordering" integer NOT NULL DEFAULT 500000, FOREIGN KEY ("pid") REFERENCES "navtree_node"("id") ON DELETE CASCADE ON UPDATE CASCADE ); CREATE INDEX "navtree_node_idx_pid" ON "navtree_node" ("pid"); -- -- Table: "navtree_node_to_role" -- CREATE TABL%E "navtree_node_to_role" ( "node_id" integer NOT NULL, "role" varchar(64) NOT NULL, PRIMARY KEY ("node_id", "role"), FOREIGN KEY ("node_id") REFERENCES "navtree_node"("id") ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY ("role") REFERENCES "role"("role") ON DELETE CASCADE ON UPDATE CASCADE ); CREATE INDEX "navtree_node_to_role_idx_node_id" ON "navtree_node_to_role" ("node_id"); CREATE INDEX "navtree_node_to_role_idx_role" ON "navtree_node_to_role" ("role"); -- -- Table: "request" -- CREATE TABLE "request" ( "id" INTEGER PRIMARY KEY NOT NULL, "user_id" integer, "timestamp" timestamp NOT NULL DEFAULT current_timestamp, "client_ip" varchar(16) NOT NULL, "client_hostname" varchar(255), "uri" varchar(512) NOT NULL, "method" varchar(8) NOT NULL, "user_agent" varchar(1024), "referer" varchar(512), "serialized_request" text, FOREIGN KEY ("user_id") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE CASCADE ); CREATE INDEX "request_idx_user_id" ON "request" ("user_id"); -- -&- Table: "role" -- CREATE TABLE "role" ( "id" INTEGER PRIMARY KEY NOT NULL, "role" varchar(64) NOT NULL, "description" varchar(255) NOT NULL ); CREATE UNIQUE INDEX "role02" ON "role" ("role"); -- -- Table: "saved_state" -- CREATE TABLE "saved_state" ( "id" INTEGER PRIMARY KEY NOT NULL, "title" varchar(255) NOT NULL, "subtitle" varchar(1024), "node_id" integer, "user_id" integer, "ordering" integer NOT NULL DEFAULT 500001, "iconcls" varchar(255), "url" varchar(255) NOT NULL, "params" text, "state_data" text, FOREIGN KEY ("node_id") REFERENCES "navtree_node"("id") ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY ("user_id") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE CASCADE ); CREATE INDEX "saved_state_idx_node_id" ON "saved_state" ("node_id"); CREATE INDEX "saved_state_idx_user_id" ON "saved_state" ("user_id"); -- -- Table: "session" -- CREATE TABLE "session" ( "id" varchar NOT NULL, "session_data" text, "expires" integer, "expires_ts" datetime, "user_id" integer, PRIMARY KEY ("id"), FOREIGN KEY ("user_id") REFERENCES "user"("id") ON DELETE CASCADE ON UPDATE CASCADE ); CREATE INDEX "session_idx_user_id" ON "session" ("user_id"); -- -- Table: "user" -- CREATE TABLE "user" ( "id" INTEGER PRIMARY KEY NOT NULL, "username" varchar(32) NOT NULL, "password" varchar, "full_name" varchar(255), "last_login_ts" datetime, "disabled" tinyint NOT NULL DEFAULT 0, "disabled_ts" datetime ); CREATE UNIQUE INDEX "username" ON "user" ("username"); -- -- Table: "user_to_role" -- CREATE TABLE "user_to_role" ( "username" varchar(32) NOT NULL, "role" varchar(64) NOT NULL, PRIMARY KEY ("username", "role"), FOREIGN KEY ("role") REFERENCES "role"("role") ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY ("username") REFERENCES "user"("username") ON DELETE CASCADE ON UPDATE CASCADE ); CREATE INDEX "user_to_role_idx_role" ON "user_to_role" ("role"); CREATE INDEX "user_to_role_idx_username" ON "user_to_role" ("username"); COMMIT; 2014-04-11T06:25:53