DELETE FROM `contacts` WHERE `id` NOT IN ('3dce531d-e31a-b0c7-68ed-4e570466285e', 'be59a6ae-2ceb-667f-5ba0-45b03573f1ac');
DELETE FROM users WHERE id  NOT IN ('93c64d5b-e654-6511-88f9-4e5704efed84', '1', '3c801f9b-cf28-fe53-cd5d-4653bfe5220a');
DELETE FROM users_schools WHERE user_id  NOT IN ('93c64d5b-e654-6511-88f9-4e5704efed84', '1');

DELETE FROM users WHERE contact_id NOT IN ('c4565fc9-30f9-719c-cb31-4437354e807d', 'be59a6ae-2ceb-667f-5ba0-45b03573f1ac','12a41c5c-d3c4-ca41-1f48-46cb93e5d433', '1b955c03-538c-558c-078b-4c88a0965234');
-- DELETE FROM users_schools WHERE school_id  NOT IN ('sssssss-1111', '687ec71c-1c7d-6c97-fc2a-4c889fc5d652', 'bc3a6a25-6dc7-9348-ce21-4c88a00a08ab');
DELETE FROM acl_roles_users WHERE user_id  NOT IN ('c4565fc9-30f9-719c-cb31-4437354e807d', '1', 'ef256ecf-d1c4-c18a-6ade-46cb935f01ae', 'a437cc11-564c-e5c4-3ff0-4c88c6961e3b');

SELECT last_name, first_name, idnumber, custom_var11 FROM `contacts` WHERE `smsgroup` LIKE 'student'

UPDATE contacts SET custom_var11='ticket' WHERE `smsgroup` LIKE 'student'

sms@technopian.com			c74j

-- 2012-09-20

DELETE FROM `users` WHERE `contact_id` IS NULL AND id !='3c801f9b-cf28-fe53-cd5d-4653bfe5220a'

SELECT users.id as user_id, users.deleted, user_name, users.status, users.smsgroup, users.date_entered, users.date_modified, contact_id,
	contacts.idnumber, last_name, first_name, email1, contact_status, contacts.date_entered, contacts.date_modified, contacts.school_id
FROM contacts, users
WHERE contacts.id=users.contact_id AND contacts.deleted=0 AND users.deleted=0 
ORDER BY email1

DELETE FROM `users` WHERE `contact_id` IS NULL AND id !='3c801f9b-cf28-fe53-cd5d-4653bfe5220a'

-- 2012-10-02 honban update 
-- symbolic link in m.e-school.jp
-- wanocoto -> ../../kururi.e-school.jp/htdocs/

-- 2013-09-03�@�g�ˎ��Z�ɒlj�
UPDATE resource SET school_id='02' WHERE name='�g�ˎ��Z' AND category='school';
UPDATE resourceschool_cstm SET last_student_id_c=0 WHERE last_student_id_c='';
UPDATE resourceschool_cstm SET last_invoice_id_c=0 WHERE last_invoice_id_c='';
UPDATE resourceschool_cstm SET last_teacher_id_c=90000 WHERE last_teacher_id_c='';