Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- sqlite> PRAGMA table_info(wwwdj_paper_coauthors);
- cid name TYPE notnull dflt_value pk
- ---------- ---------- ---------- ---------- ---------- ----------
- 0 id INTEGER 1 1
- 1 paper_id CHAR(32) 1 0
- 2 profile_id CHAR(32) 1 0
- sqlite> PRAGMA table_info(wwwdj_paper);
- cid name TYPE notnull dflt_value pk
- ---------- ---------- ---------- ---------- ---------- ----------
- 0 id CHAR(32) 1 1
- 1 NUMBER DECIMAL 1 0
- 2 published datetime 0 0
- 3 STATUS SMALLINT 1 0
- 4 associate_ CHAR(32) 0 0
- 5 content_ty CHAR(32) 0 0
- 6 correspond CHAR(32) 0 0
- 7 issue_id CHAR(32) 0 0
- 8 main_edito CHAR(32) 0 0
- sqlite> PRAGMA table_info(wwwdj_profile);
- cid name TYPE notnull dflt_value pk
- ---------- ---------- ------------ ---------- ---------- ----------
- 0 password VARCHAR(128) 1 0
- 1 last_login datetime 0 0
- 2 is_superus bool 1 0
- 3 id CHAR(32) 1 1
- 4 email VARCHAR(254) 1 0
- 5 is_staff bool 1 0
- 6 is_active bool 1 0
- 7 first_name VARCHAR(31) 1 0
- 8 middle_ini VARCHAR(31) 0 0
- 9 last_name VARCHAR(31) 1 0
- 10 affiliatio VARCHAR(160) 0 0
- 11 primary_je VARCHAR(2) 1 0
- 12 secondary_ VARCHAR(2) 0 0
- 13 title VARCHAR(31) 0 0
- 14 picture VARCHAR(100) 0 0
- 15 bio text 0 0
- 16 phone VARCHAR(50) 0 0
- 17 fax VARCHAR(50) 0 0
- 18 website VARCHAR(160) 0 0
- 19 cv VARCHAR(120) 0 0
- 20 street_pri VARCHAR(255) 0 0
- 21 street_sec VARCHAR(255) 0 0
- 22 city VARCHAR(255) 0 0
- 23 state VARCHAR(255) 0 0
- 24 zipcode VARCHAR(50) 0 0
- 25 country VARCHAR(50) 0 0
- 26 date_joine datetime 1 0
- 27 last_modif datetime 1 0
Advertisement
Add Comment
Please, Sign In to add comment
