65 lines
2.6 KiB
MySQL
65 lines
2.6 KiB
MySQL
|
|
||
|
|
CREATE TABLE admin_users (
|
||
|
|
id integer NOT NULL,
|
||
|
|
email character varying(255) DEFAULT ''::character varying NOT NULL,
|
||
|
|
encrypted_password character varying(255) DEFAULT ''::character varying NOT NULL,
|
||
|
|
reset_password_token character varying(255),
|
||
|
|
reset_password_sent_at timestamp without time zone,
|
||
|
|
remember_created_at timestamp without time zone,
|
||
|
|
sign_in_count integer DEFAULT 0,
|
||
|
|
current_sign_in_at timestamp without time zone,
|
||
|
|
last_sign_in_at timestamp without time zone,
|
||
|
|
current_sign_in_ip character varying(255),
|
||
|
|
last_sign_in_ip character varying(255),
|
||
|
|
created_at timestamp without time zone NOT NULL,
|
||
|
|
updated_at timestamp without time zone NOT NULL
|
||
|
|
);
|
||
|
|
|
||
|
|
CREATE SEQUENCE admin_users_id_seq
|
||
|
|
START WITH 1
|
||
|
|
INCREMENT BY 1
|
||
|
|
NO MINVALUE
|
||
|
|
NO MAXVALUE
|
||
|
|
CACHE 1;
|
||
|
|
|
||
|
|
ALTER SEQUENCE admin_users_id_seq OWNED BY admin_users.id;
|
||
|
|
SELECT pg_catalog.setval('admin_users_id_seq', 2, true);
|
||
|
|
ALTER TABLE ONLY admin_users ALTER COLUMN id SET DEFAULT nextval('admin_users_id_seq'::regclass);
|
||
|
|
ALTER TABLE ONLY admin_users
|
||
|
|
ADD CONSTRAINT admin_users_pkey PRIMARY KEY (id);
|
||
|
|
CREATE UNIQUE INDEX index_admin_users_on_email ON admin_users USING btree (email);
|
||
|
|
CREATE UNIQUE INDEX index_admin_users_on_reset_password_token ON admin_users USING btree (reset_password_token);
|
||
|
|
|
||
|
|
---------------------------------
|
||
|
|
|
||
|
|
CREATE TABLE active_admin_comments (
|
||
|
|
id integer NOT NULL,
|
||
|
|
resource_id character varying(255) NOT NULL,
|
||
|
|
resource_type character varying(255) NOT NULL,
|
||
|
|
author_id integer,
|
||
|
|
author_type character varying(255),
|
||
|
|
body text,
|
||
|
|
created_at timestamp without time zone NOT NULL,
|
||
|
|
updated_at timestamp without time zone NOT NULL,
|
||
|
|
namespace character varying(255)
|
||
|
|
);
|
||
|
|
CREATE SEQUENCE active_admin_comments_id_seq
|
||
|
|
START WITH 1
|
||
|
|
INCREMENT BY 1
|
||
|
|
NO MINVALUE
|
||
|
|
NO MAXVALUE
|
||
|
|
CACHE 1;
|
||
|
|
|
||
|
|
ALTER SEQUENCE active_admin_comments_id_seq OWNED BY active_admin_comments.id;
|
||
|
|
SELECT pg_catalog.setval('active_admin_comments_id_seq', 1, false);
|
||
|
|
ALTER TABLE ONLY active_admin_comments ALTER COLUMN id SET DEFAULT nextval('active_admin_comments_id_seq'::regclass);
|
||
|
|
ALTER TABLE ONLY active_admin_comments
|
||
|
|
ADD CONSTRAINT admin_comments_pkey PRIMARY KEY (id);
|
||
|
|
CREATE INDEX index_active_admin_comments_on_author_type_and_author_id ON active_admin_comments USING btree (author_type, author_id);
|
||
|
|
CREATE INDEX index_active_admin_comments_on_namespace ON active_admin_comments USING btree (namespace);
|
||
|
|
CREATE INDEX index_admin_comments_on_resource_type_and_resource_id ON active_admin_comments USING btree (resource_type, resource_id);
|
||
|
|
|
||
|
|
|
||
|
|
---------------------------------
|
||
|
|
|